Hibernate shows question marks in SQL query

Question

How do I see the actual value in query instead of questions marks? Now, I am seeing

Hibernate: inser into TABEL (ID, FORMAT, SIZE) values (?,?,?)

I want to see the real values being used instead of the question marks.

I set this in my hibernate config file and turned on the debug flag.

<property name="show_sql"> true </property>

Thank you in advance.

Why did you misspell `inser`(t)? – Mr. Polywhirl Jul 24 '19 at 12:23 — Mr. Polywhirl, Jul 24 '19 at 12:23

Hauke Ingmar Schmidt · Accepted Answer · 2017-11-13T18:47:57.563

13

Hibernate uses prepared statements so you can't see the full SQL. You can set the log level for org.hibernate.type to trace to see the values bound to the parameters.

Reference

Hibernate 3.5 Core Documentation
- 3.5. Logging
Hibernate 4.1 Core Documentation
- 4.1. Logging

(As mentioned in/see also this answer).

edited Nov 13 '17 at 18:47

answered Apr 02 '13 at 23:40

Hauke Ingmar Schmidt

11,559
1
42
50

Can you please include a reference for this? – Jolley71717 Nov 13 '17 at 17:57
@Jolley71717 Sure, I added some. – Hauke Ingmar Schmidt Nov 13 '17 at 18:48

score -1 · Answer 2 · edited Jul 24 '19 at 12:22

-1

Use Log4j or Logback to enable and set javax.sql to DEBUG:

<logger name="java.sql" level="debug">
    <appender-ref ref="STDOUT" /> <!-- or your own appender -->
</logger>

edited Jul 24 '19 at 12:22

Mr. Polywhirl

42,981
12
84
132

answered Apr 02 '13 at 23:18

alfonso.kim

2,844
4
32
37

This is not a solution for Hibernate. Spring Actuator shows no loggers with the names `javax.sql` or `java.sql`. – Oliver Jan 13 '21 at 01:24

Hibernate shows question marks in SQL query

2 Answers2

Reference