Hibernate version:2.1.6


In addition to show_sql, could there be (is there?) a setting that would, instead of question marks, log the actual values of the SQL query parameters ?

Values can, sure, be debug-logged explicitly in code, but a globally configurable Hibernate-level switch would come in very handy when locating performance bottlenecks and analyzing their SQL...

You would have to pay special attention to security with this setting on, but I assume most production systems would have show_sql="false" in any case...

//markku

I, too, am interested in seeing the actual SQL parameters instead of the question mark. I've searched this forum and haven't found that anyone has actually resolved this issue. Is there an answer? Is it already posted? Please post a pointer to the information if it exists.

Thanks,

TR

I found a partial answer in this topic: http://forum.hibernate.org/viewtopic.php?t=37

However, this solution also logs all the values returned by the query, which could become a real drain. We have need to log the parameters used in the query, but would rather not have all the values that are returned. Is it possible to do this using the existing logging strategy?

Thanks,

TR

http://www.p6spy.org/ is a proxy JDBC driver wich logs the full SQL and mutch more if you want.

HTH
Ernst