Im trying to degub a program using Springs's jdbcTemplate and I would really like to view the query. Is there any way to either use the debugger or a db2 watcher to see the outgoing/incoming queries?
Thanks for any help.
Asked
Active
Viewed 33 times
1
-
possible duplicate of [JDBC logging to file](http://stackoverflow.com/questions/5738181/jdbc-logging-to-file) – OldProgrammer Jun 06 '14 at 16:12
1 Answers
1
You can enable the JDBC trace, e.g. by adding the property traceFile=/path/to/trace.file; to your JDBC URL. More details: http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.admin.trb.doc/doc/t0020709.html?lang=en
Keep in mind that it affects the driver performance, obviously.
mustaccio
- 18,234
- 16
- 48
- 57