Displaying generated SQL statements

[Jamie Garton]

Hi,
I am using MySql version: 4.1.12a-nt with the mysql-connector-java-4.1.10.zip. I am trying to update a table via java's javax.sql.rowset.CachedRowSet/updatable ResultSet and I'm getting an error about incorrect syntax.

java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'cable_size = 4 , length = null WHERE circuit_id = 1 AND switchboard_id = 2 AND n' at line 1

From this error message it does not look like its displaying the full sql that is being executed, how do I display the entire sql statement?

Thanks
Jamie