Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can I see what SQL statement Castor issues to the database as a result of an operation?

April 26, 2017Castor database operation sql

0

Posted

Can I see what SQL statement Castor issues to the database as a result of an operation?

1 Answer

0

Posted

Yes, you can. By default, Castor uses JDBC proxy classes (wrapping java.sql.Connection and java.sql.PreparedStatement) that capture the core SQL statements as generated by Castor and the user-supplied parameters at execution time of the various persistence operations, and outputs them to the standard logger used by Castor. By default, these output statements are not visible, as the log level is set to level ‘info’. To see these SQL statements, please increase the log level to level ‘debug’ in log4j.xml.