Friday, 16 August 2013

WebSphere SQL tracing

This is probably OTT but I've found that the following trace settings capture all SQL queries

com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement=all:
com.ibm.ws.oracle.*=all:
com.ibm.ws.database.*=all:
com.ibm.ws.runtime.WSThreadPool=all:
com.ibm.ws.rsadapter.dbutils.impl.*=all:
com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet=all:
com.ibm.ws.rsadapter.jdbc.WSJdbcStatement=all:
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource=all:
com.ibm.ws.rsadapter.jdbc.WSJdbcDatabaseMetaData=all

No comments:

Post a Comment