Hibernate show real SQL

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 --> %d{HH:mm:ss} %-5p %c - %m%n
log4j.appender.hb.Threshold=TRACE

hibernate.cfg.xml

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

persistence.xml

Some frameworks use persistence.xml:

<property name="hibernate.show_sql" value="true"/>
<property name="hibernate.format_sql" value="true"/>
<property name="hibernate.use_sql_comments" value="true"/>

Related Posts:

  1. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  2. How to fix org.hibernate.LazyInitializationException – could not initialize proxy – no Session
  3. How to fix the Hibernate “object references an unsaved transient instance – save the transient instance before flushing” error
  4. How to fix the Hibernate “object references an unsaved transient instance – save the transient instance before flushing” error
  5. What’s the difference between JPA and Hibernate?
  6. How to map a composite key with JPA and Hibernate?
  7. HTTP Status 405 – Request method ‘POST’ not supported (Spring MVC)
  8. org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘MyController’:
  9. Error creating bean with name ‘entityManagerFactory’ defined in class path resource : Invocation of init method failed
  10. What does the following Oracle error mean: invalid column index
  11. org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set
  12. What does the following Oracle error mean: invalid column index
  13. Error creating bean with name ‘entityManagerFactory’ defined in class path resource : Invocation of init method failed
  14. Unable to create requested service [org.hibernate .engine.jdbc.env.spi.JdbcEnvironment]-MySQL
  15. org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set
  16. org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set
  17. What’s the difference between session.persist() and session.save() in Hibernate?
  18. What’s the advantage of load() vs get() in Hibernate?
  19. HTTP Status 405 – Request method ‘POST’ not supported (Spring MVC)
  20. What Java ORM do you prefer, and why?
  21. What are the possible values of the Hibernate hbm2ddl.auto configuration and what do they do
  22. PersistentObjectException: detached entity passed to persist thrown by JPA and Hibernate
  23. Hibernate Error: a different object with the same identifier value was already associated with the session
  24. How to solve the “failed to lazily initialize a collection of role” Hibernate exception
  25. hibernate properties not found
  26. How do I get the size of a java.sql.ResultSet?
  27. Efficient way to do batch INSERTS with JDBC
  28. What kind of Java type is “[B”?
  29. Hibernate – Batch update returned unexpected row count from update: 0 actual row count: 0 expected: 1
  30. How to convert java.util.Date to java.sql.Date?
  31. In a simple to understand explanation, what is Runnable in Java?
  32. Java – How to use \t in my example [duplicate]
  33. Android Studio Could not initialize class org.codehaus.groovy.runtime.InvokerHelper
  34. String concatenation: concat() vs “+” operator
  35. How to remove the last character from a string?
  36. Java : Comparable vs Comparator [duplicate]
  37. Convert int to char in java
  38. How to request.getParameterNames into List of strings?
  39. How can I prevent java.lang.NumberFormatException: For input string: “N/A”?
  40. stale element reference: element is not attached to the page document
  41. Error: can only iterate over an array or an instance of java.lang.Iterable
  42. Why can array constants only be used in initializers?
  43. Where is Java’s Array indexOf?
  44. How to check if an int is a null
  45. How do I apply the for-each loop to every character in a String?
  46. Session TimeOut in web.xml
  47. Java – removing first character of a string
  48. How to send a Map in JSON
  49. What is the significance of log4j.rootLogger property in log4j.properties file? What happens if I don’t use this property?
  50. “Instantiating” a List in Java? [duplicate]
  51. Missing `server’ JVM (Java\jre7\bin\server\jvm.dll.)
  52. Convert String array to ArrayList
  53. java uses or overrides a deprecated API error
  54. What is setBounds and how do I use it?
  55. Exception in thread “main” java.lang.NumberFormatException: For input string: “S”
  56. Java Console Prompt for ENTER input before moving on [duplicate]
  57. Remove last character of a StringBuilder?
  58. Why SpringMVC Request method ‘GET’ not supported?
  59. Error: JAVA_HOME is not defined correctly executing maven
  60. Eclipse No tests found using JUnit 5 caused by NoClassDefFoundError for LauncherFactory
  61. Android – SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
  62. How to sort an array of objects in Java?
  63. Filling a 2D array in Java
  64. How to compress a String in Java?
  65. Java end of file
  66. A KeyValuePair in Java
  67. Unclosed Character Literal error
  68. Java error: void cannot be converted to String
  69. CreateProcess error=2, The system cannot find the file specified
  70. Add String Array to ArrayList
  71. Java Array Sort descending?
  72. The import javafx cannot be resolved
  73. Java Copy Constructor ArrayLists
  74. Implementing an actionlistener to a JTextField
  75. StringIndexOutOfBoundsException String index out of range: 0
  76. Cannot resolve method in java
  77. Using regex to match any character except =
  78. Why is a ConcurrentModificationException thrown and how to debug it
  79. How to sort a HashSet?
  80. Variable used in lambda expression should be final or effectively final
  81. Populate int array with for loop in Java
  82. calling boolean method, heads or tails
  83. Android Color Picker
  84. How to fix an UnsatisfiedLinkError (Can’t find dependent libraries) in a JNI project
  85. How to Delete a topic in apache kafka [duplicate]
  86. Java Main Game Loop
  87. “Integer number too large” error message for 600851475143
  88. How to fix java.lang.UnsupportedClassVersionError: Unsupported major.minor version
  89. JPA or JDBC, how are they different?
  90. Why is Netbeans suggesting I “Flip operands of the binary operators” in my Java code
  91. How to resolve “Syntax error on token “else”” in Java?
  92. What’s the difference between Jetty and Netty?
  93. Is there a way to simulate the C++ ‘friend’ concept in Java?
  94. Good way to encapsulate Integer.parseInt()
  95. What is the difference between “Double” and “double” in Java?
  96. What is the purpose of the default keyword in Java?
  97. What exactly is Ajax request? Is it different from Servlet Request?
  98. java ‘jar’ is not recognized as an internal or external command
  99. A JRE or JDK must be available in order to run Eclipse. No JVM was found after searching the following locations
  100. Why cannot cast Integer to String in java?

Leave a Comment