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. What does Java option -Xmx stand for? [duplicate]
  32. How do I convert a String to an int in Java?
  33. What does Java option -Xmx stand for? [duplicate]
  34. Is there an invisible character that is not regarded as whitespace?
  35. Problem with gif with transparent background
  36. Finding white rectangle in an image
  37. 1000 * 60 * 60 * 24 * 30 results in a negative number [duplicate]
  38. How to convert nanoseconds to seconds using the TimeUnit enum?
  39. Search for words with telephone numbers from 2-3-4 tree
  40. Using or ‘|’ in regex [duplicate]
  41. How to format strings in Java
  42. What is the difference between x86 and x64
  43. && (AND) and || (OR) in IF statements
  44. How to use the toString method in Java?
  45. What is a NullPointerException, and how do I fix it?
  46. What exactly is Apache Camel?
  47. Unable to find valid certification path to requested target – error even after cert imported
  48. Unable to find valid certification path to requested target – error even after cert imported
  49. What is the equivalent of the C++ Pair in Java?
  50. Java – Convert integer to string [duplicate]
  51. Getting random numbers in Java [duplicate]
  52. What is an instance variable in Java?
  53. javac is not recognized as an internal or external command, operable program or batch file [closed]
  54. javac is not recognized as an internal or external command, operable program or batch file [closed]
  55. Java: “error: cannot find symbol”
  56. How does the Java ‘for each’ loop work?
  57. What is a StackOverflowError?
  58. How to uninstall Eclipse?
  59. Is GNU’s Java Compiler (GCJ) dead? [closed]
  60. How does System.out.print() work?
  61. How do I “decompile” Java class files? [closed]
  62. How do I determine whether an array contains a particular value in Java?
  63. How to initialize an array in Java?
  64. How does the Java ‘for each’ loop work?
  65. Java 8 Iterable.forEach() vs foreach loop
  66. Initialize part of an array in java
  67. How can I solve Exception in thread “main” java.lang.NullPointerException error [duplicate]
  68. How to split a string in Java
  69. What does “Could not find or load main class” mean?
  70. What does “Could not find or load main class” mean?
  71. Why am I getting a NoClassDefFoundError in Java?
  72. How to avoid “ConcurrentModificationException” while removing elements from `ArrayList` while iterating it? [duplicate]
  73. Eclipse/Maven error: “No compiler is provided in this environment”
  74. How do I compare strings in Java?
  75. What is reflection and why is it useful?
  76. Implementing UML diagram to Java [closed]
  77. How to round a number to n decimal places in Java
  78. Using Pairs or 2-tuples in Java [duplicate]
  79. How do I create a file and write to it?
  80. Could not reserve enough space for object heap
  81. When to use LinkedList over ArrayList in Java?
  82. How to convert a char to a String?
  83. Difference between Arrays.asList(array) and new ArrayList(Arrays.asList(array))
  84. What is the proper way to handle a NumberFormatException when it is expected?
  85. What causes “Unable to access jarfile” error?
  86. What does “Could not find or load main class” mean?
  87. How do you create a dictionary in Java? [closed]
  88. Reading a plain text file in Java
  89. Error unable to access jarfile C:\Jar
  90. Where is JRE 11? [duplicate]
  91. In laymans terms, what does ‘static’ mean in Java? [duplicate]
  92. How to convert/parse from String to char in java?
  93. Reverse a string in Java
  94. Static Classes In Java
  95. Is there any doubly linked list implementation in Java?
  96. How to set a Timer in Java?
  97. How do I declare and initialize an array in Java?
  98. How to parse JSON in Java
  99. Is there a way to convert all comments into javadoc comments? [Eclipse/Java]
  100. Convert list to array in Java [duplicate]

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)