Who is actually doing the logging? Is it java.sql or is it the responsibility of the underlying JDBC driver (varies from vendor to vendor) to decide whether logging takes place?
Thanks, Gili On 14/04/2010 1:35 AM, Stephen Friedrich wrote:
Using this log4j configuration I am getting all sql statements added to the "sql" appender: <!-- iBatis --> <category name="com.ibatis" additivity="false"> <priority value="debug"/> <appender-ref ref="sql"/> </category> <!-- iBatis also uses standard java.sql classes as log categories --> <!-- Log query results --> <category name="java.sql.ResultSet" additivity="false"> <priority value="error"/> <appender-ref ref="sql"/> </category> <!-- Log connections, prepared statements etc. --> <category name="java.sql" additivity="false"> <priority value="debug"/> <appender-ref ref="sql"/> </category> -----Ursprüngliche Nachricht----- Von: cowwoc [mailto:cow...@bbs.darktech.org] Gesendet: Mittwoch, 14. April 2010 01:17 An: user-java@ibatis.apache.org Betreff: Enabling iBatis 3 logging Hi, I'm getting this exception: [snip] operation: setValue org.apache.ibatis.exceptions.IbatisException: ### Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near "WHERE" Position: 68 [snip] The annoying thing is I can't find an easy way to find out what postiion 68 refers to. I wish that iBatis would include the SQL statement in the exception message. I remember seeing iBatis log SQL statements when I first started playing with it last week. I suppressed them somehow and I forget how. Could someone please help me figure out how to re-enable them? PS: I am using "ibaguice", Guice 2.0, and iBatis 3 annotations (no xml files at all). Thanks, Gili --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
--------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org