Hibernate show real SQL

Question

if I set   lt property name  show sql  gt true lt  property gt    in my hibernate cfg xml configuration file in the console I can see the SQL   But it s not real SQL    Can I see the SQL code that will be passed directly to database   Example   I see   select this  code from true employee this  where this  code     Can I see  select employee code from employee where employee code 12   the real SQL

User · Answer

Worth noting that the code you see is sent to the database as is  the queries are sent separately to prevent SQL injection  AFAIK The   marks are placeholders that are replaced by the number params by the database  not by hibernate

User · Answer

select this  code from true employee this  where this  code   is what will be sent to your database   this  is an alias for that instance of the employee table

User · Answer

If you can already see the SQL being printed  that means you have the code below in your hibernate cfg xml    lt property name  show sql  gt true lt  property gt    To print the bind parameters as well  add the following to your log4j properties file   log4j logger net sf hibernate type debug

User · Answer

log4j properties  log4j logger org hibernate INFO  hb log4j logger org hibernate SQL DEBUG log4j logger org hibernate type TRACE log4j logger org hibernate hql ast AST info log4j logger org hibernate tool hbm2ddl warn log4j logger org hibernate hql debug log4j logger org hibernate cache info log4j logger org hibernate jdbc debug  log4j appender hb org apache log4j ConsoleAppender log4j appender hb layout org apache log4j PatternLayout log4j appender hb layout ConversionPattern HibernateLog -- gt   d HH mm ss   -5p  c -  m n log4j appender hb Threshold TRACE   hibernate cfg xml   lt property name  show sql  gt true lt  property gt   lt property name  format sql  gt true lt  property gt   lt property name  use sql comments  gt true lt  property gt    persistence xml  Some frameworks use persistence xml    lt property name  hibernate show sql  value  true   gt   lt property name  hibernate format sql  value  true   gt   lt property name  hibernate use sql comments  value  true   gt

User · Answer

Can I see       the real SQL   If you want to see the SQL sent directly to the database  that is formatted similar to your example   you ll have to use some kind of jdbc driver proxy like P6Spy  or log4jdbc    Alternatively you can enable logging of the following categories  using a log4j properties file here    log4j logger org hibernate SQL DEBUG log4j logger org hibernate type TRACE   The first is equivalent to hibernate show sql true  the second prints the bound parameters among other things   Reference   Hibernate 3 5 Core Documentation    3 5  Logging   Hibernate 4 1 Core Documentation    4 1  Logging

[java] Hibernate show real SQL

Examples related to java

Examples related to sql

Examples related to hibernate

Examples related to orm