Logging SQL Statements

To see SQL statements that are issued to the database, turn on SQL logging: set app.debug to true in \archibus\web-inf\config\core.properties .

The SQL statements will be logged to \webapps\archibus\WEB-INF\archibus.log .

You will see debug messages in the log, for example:

[DEBUG][DataSourceImpl][Adding persistent restriction [com.archibus.db.RestrictionForFieldsImpl@782678||forFields|#ASQL_VPAField() LIKE 'HQ%'|bl_id]] [DEBUG][DataSourceImpl][SELECT em.em_id,em.em_std,em.phone,em.bl_id,em.fl_id,em.rm_id FROM em WHERE (em.bl_id LIKE 'HQ%')]

Classes inherit logging level from their packages. However, in debug mode many packages are forced into debug logging level, regardless of the settings in core.properties . This behavior cannot be configured.