[Log4J] Enable SQL logging for Hibernate

Step1. log4j.Properties [Add below entries in your log4j properties file]

### log just the SQL
log4j.logger.org.hibernate.SQL=trace
log4j.logger.org.hibernate.engine.query=trace
log4j.logger.org.hibernate.type=trace

### log JDBC bind parameters ###
log4j.logger.org.hibernate.jdbc=trace
#log4j.additivity.org.hibernate.SQL=false
log4j.logger.org.hibernate=info
### log schema export/update ###
log4j.logger.org.hibernate.tool.hbm2ddl=info
### log cache activity ###
log4j.logger.org.hibernate.cache=info

Step2: Set show_sql= true in hibernate-config.xml

 
  
  com.microsoft.sqlserver.jdbc.SQLServerDriver
  jdbc:sqlserver://localhost:1433
  ADMIN
  Admin1234
  validate

  
  1


  
  org.hibernate.dialect.SQLServerDialect


  
  thread
  
  org.hibernate.cache.NoCacheProvider
  
  true