Hibernate Community • View topic - more info in queries

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

more info in queries

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

pedrosacosta

Post subject: more info in queries

Posted: Thu Mar 30, 2006 4:08 am

Newbie

Joined: Wed Dec 14, 2005 7:27 am
Posts: 18

When i'm executing jbpm, in the log file, the queries to the database are of this type:

Code:

18:48:50,516 INFO  [STDOUT] Hibernate: select top 1 processdef0_.ID_ as ID1_91_, processdef0_.NAME_ 
as NAME2_91_, processdef0_.VERSION_ as VERSION3_91_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN
4_91_, processdef0_.STARTSTATE_ as STARTSTATE5_91_ from JBPM_PROCESSDEFINITION processdef0_ where pr
ocessdef0_.NAME_=? order by processdef0_.VERSION_ desc

Is there any manner to substitute the '?' marks with the values?

Thanks,
Pedro

Top

jurgendl

Post subject:

Posted: Thu Mar 30, 2006 4:49 am

Newbie

Joined: Wed Mar 01, 2006 4:14 am
Posts: 16

use this in the log4j.properties

log4j.logger.org.hibernate.hql=debug
log4j.logger.org.hibernate.type=debug
log4j.logger.org.hibernate.SQL=debug

Top

jurgendl

Post subject:

Posted: Thu Mar 30, 2006 4:51 am

Newbie

Joined: Wed Mar 01, 2006 4:14 am
Posts: 16

this is my complete log config, in our company we use this in each project during programming, testing and deployed-testing

log4j.rootLogger=DEBUG, stdout, file

log4j.appender.file=org.apache.log4j.RollingFileAppender
log4j.appender.file.File=../logs/logfile.log
log4j.appender.file.MaxFileSize=5000KB
log4j.appender.file.MaxBackupIndex=1
log4j.appender.file.layout=org.apache.log4j.PatternLayout
#log4j.appender.file.layout.ConversionPattern=%-4r [%t] %-5p %c %x - %m%n
log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

#debug output wat beperken
log4j.logger.com.sun=ERROR
log4j.logger.org=ERROR
log4j.logger.httpclient.wire=ERROR

### direct log messages to stdout ###
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

### set log levels - for more verbose logging change 'info' to 'debug' ###
log4j.logger.org.hibernate=warn

### log HQL query parser activity
log4j.logger.org.hibernate.hql.ast.AST=warn

### log just the SQL
log4j.logger.org.hibernate.SQL=debug

### log JDBC bind parameters ###
log4j.logger.org.hibernate.type=debug

### log schema export/update ###
log4j.logger.org.hibernate.tool.hbm2ddl=warn

### log HQL parse trees
log4j.logger.org.hibernate.hql=debug

### log cache activity ###
log4j.logger.org.hibernate.cache=warn

### log transaction activity
log4j.logger.org.hibernate.transaction=warn

### log JDBC resource acquisition
log4j.logger.org.hibernate.jdbc=warn

### enable the following line if you want to track down connection ###
### leakages when using DriverManagerConnectionProvider ###
log4j.logger.org.hibernate.connection.DriverManagerConnectionProvider=warn

Top

jurgendl

Post subject:

Posted: Mon Apr 10, 2006 4:21 am

Newbie

Joined: Wed Mar 01, 2006 4:14 am
Posts: 16

was this enough info?

Top

Page 1 of 1

[ 4 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum