论坛首页 入门讨论版 Hibernate

SQL值显示成“?”(show_sql),想看到完整SQL如何办?

浏览 7816 次
该帖已经被评为新手帖
作者 正文
最后更新时间:2005-03-31
按照上面配置了但是不起作用,我的log4j.properties:

### 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

### direct messages to file hibernate.log ###
#log4j.appender.file=org.apache.log4j.FileAppender
#log4j.appender.file.File=hibernate.log
#log4j.appender.file.layout=org.apache.log4j.PatternLayout
#log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

### set log levels - for more verbose logging change 'info' to 'debug' ###

log4j.rootLogger=warn, stdout

log4j.logger.net.sf.hibernate=info

### log just the SQL
log4j.logger.net.sf.hibernate=info
### log just the SQL
#log4j.logger.net.sf.hibernate.SQL=debug
### log JDBC bind parameters ###
log4j.logger.net.sf.hibernate.type=debug

### log cache activity ###
#log4j.logger.net.sf.hibernate.cache=debug

### log jdbc resource acquisition
#log4j.logger.net.sf.hibernate.impl.BatcherImpl=debug

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

输出的sql还是:
Hibernate: insert into TRACK (title, filePath, playTime, added, volume) values (?, ?, ?, ?, ?)
   
0 请登录后投票
最后更新时间:2005-04-01
<logger name="log4j.logger.net.sf.hibernate" additivity="false">
<level value="INFO"/>
<appender-ref ref="consoleAppender"/>
<!--appender-ref ref="fileAppender"/-->
<!--appender-ref ref="mailAppender"/-->
<!--appender-ref ref="databaseAppender"/-->
</logger>

<logger name="log4j.logger.net.sf.hibernate.type" additivity="false">
应该改为 net.sf.hibernate.type

上面也是样的

<level value="DEBUG"/>
<appender-ref ref="consoleAppender"/>
<!--appender-ref ref="fileAppender"/-->
<!--appender-ref ref="mailAppender"/-->
<!--appender-ref ref="databaseAppender"/-->
</logger>
   
0 请登录后投票
最后更新时间:2007-09-03
robbin 写道
把Hibernate下面的log4j.properties里面的如下一行修改:

[code:1]### log JDBC bind parameters ###
log4j.logger.net.sf.hibernate.type=info[/code:1]

改为:
[code:1]log4j.logger.net.sf.hibernate.type=debug[/code:1]

你就可以看到SQL语句中每个参数的代入值了。


没用啊!!
   
0 请登录后投票
论坛首页 入门讨论版 Hibernate

跳转论坛:
JavaEye推荐