How to reconstruct sql query from a ResultSet

Question

Somewhere way inside JBoss in a hibernate query I'm catching an error that leaves me with a ResultSet. This code is a plugged in custom data type.

It would be nice if I could simple do rs.getStatement().toString() and be done with it, but that unfortunately doesn't give away anything about the sql statement that went into it.

I was thinking doing something with ((PreparedStatement)rs.getStatement()).getMetaData().

I really wished hibernate would be a little more informative when it runs into errors. Does anyone have a good solution to help reveal which table and which column that was used when the exception occurred?

Answer 1

One way you can debug Hibernate is by turning on its detailed logging.

For example, you can log all SQL statements as they are executed by turning on logging for org.hibernate.SQL. From here you should be able to narrow down the last statement executed prior to your exception.

Documentation can be found here.

Answer 2

getting the MetaData for the ResultSet will not allow you to get the info that was passed in. In Hibernate you can have the statements be output to a log file.

Most JDBC drivers allow you to set tracing so that you can debug.

Answer 3

Simply enable SQL logging in the Hibernate configuration properties by setting the hibernate.show_sql property to true.

This more reliable than examining the result sets metadata since the where clause is not available.