SQL statement without question marks indicate ?

Eugen · **Joined:** Tue Mar 07, 2006 8:31 am **Posts:** 7

Hello,

if I set show_sql on true, I see the SQL batch, but instead of the variable I see only the question marks:

insert into one.document (pdf, xml, xsl, title, desc, id) values (?, ?, ?, ?, ?, ?)

How can I see complete statement with values?

Eugene

kgignatyev · **Posted:** Wed Mar 29, 2006 1:52 pm

In H configuration
<property name="hibernate.type">true</property>

in log4j configuration
log4j.logger.org.hibernate.type=DEBUG
log4j.logger.custtype=DEBUG

Eugen · **Joined:** Tue Mar 07, 2006 8:31 am **Posts:** 7

nevertheless it shows:

20:20:24,968 DEBUG [SQL] insert into one.document (pdf, XML, XSL, title, desc, id) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into one.document (pdf, XML, XSL, title, desc, id) values (?, ?, ?, ?, ?, ?)

kgignatyev · **Posted:** Wed Mar 29, 2006 3:33 pm

Please make sure that the confuguration files are used and free of typos.
Make sure also that log4j's appender has appropriate threshold.

Log should show something like this:
Hibernate: delete from idfclient where exists (select dotaz1_.id from dotaz dotaz1_ where idfclient.dotaz_id=dotaz1_.id and dotaz1_.id=?)
1985 [main] DEBUG org.hibernate.type.StringType - binding 'a' to parameter: 1