【DBFlute】SQLログを出力する。


application.yml
    logging.level.org.dbflute.system.XLog=debug
    logging.level.org.dbflute.system.QLog=debug
コンソールログ
DEBUG 19312 --- [nio-8080-exec-1] org.dbflute.system.XLog                  : ...Initializing sqlExecution for the key 'DEPARTMENT:selectEntity(DepartmentCB):Department'
DEBUG 19312 --- [nio-8080-exec-1] org.dbflute.system.XLog                  : /=================================================================================
DEBUG 19312 --- [nio-8080-exec-1] org.dbflute.system.XLog                  :                                                       DepartmentBhv.selectEntity()
DEBUG 19312 --- [nio-8080-exec-1] org.dbflute.system.XLog                  :                                                       ===========================/
DEBUG 19312 --- [nio-8080-exec-1] org.dbflute.system.XLog                  : DBConnecterController.regist():38 -> ...
DEBUG 19312 --- [nio-8080-exec-1] org.dbflute.system.QLog                  : 
select dfloc.ID as ID, dfloc.NAME as NAME, dfloc.START_DATE as START_DATE, dfloc.END_DATE as END_DATE, dfloc.REGIST_DATE as REGIST_DATE
  from DEPARTMENT dfloc
 where dfloc.ID = '20'
DEBUG 19312 --- [nio-8080-exec-1] org.dbflute.system.XLog                  : ===========/ [00m00s000ms (1) entity={20, 人事部, 2019-06-01, 2020-02-22, 2018-01-01T23:59:59}@9f8e00fd]
DEBUG 19312 --- [nio-8080-exec-1] org.dbflute.system.XLog                  
  • QLogは実行SQLを出力する。
  • XLogはそれ以外のSQL取得結果などを出力する。
  • どちらか片方だけの設定も可能。