Hibernate 4.2:How to trace sql values with JDK logging API

Question

Our current project has no log4j jars, we use JDK logging API only. Now i needed to see the values of HQL statements, which are currently displayed with "?","?".

I found a lot of tips, using LOG4J. But no solution found with JDK:---((

I have set the following in logging.properties:

org.hibernate.level=TRACE
org.hibernate.SQL.level = TRACE
.level=TRACE

But it had no effect. If I set the INFO level, so all WARNs, that I send for tests, will NOT be visible. Thus, logging.properties is bound to Java class path

Does anybody have any ideas?

lumion · Accepted Answer · 2015-07-10 03:19:26Z

1

JBoss Logging will look for a System setting with the key org.jboss.logging.provider. What you need to do is to set the system properties with that key with value "jdk", such that Hibernate will use Java logging framework for logging

System.setProperty("org.jboss.logging.provider", "jdk");

To log binding parameters in sql, you need one more statement in your logging.properties

org.hibernate.type.descriptor.sql.level=FINEST

You may refer the details from the logging guide of Hibernate http://docs.jboss.org/hibernate/orm/4.3/topical/html/logging/Logging.html

answered Jul 10, 2015 at 3:19

lumion

456 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Afshin Moazami · Accepted Answer · 2013-11-25 04:27:40Z

0

The authoritative resource on Java JDK logging is the Java Logging Guide : http://docs.oracle.com/javase/7/docs/api/java/util/logging/package-summary.html

But generally speaking, JDK logging does not define a TRACE level: http://docs.oracle.com/javase/6/docs/api/java/util/logging/Level.html

Hibernate uses JBoss Logging for its logging. JBoss Logging defines a TRACE level (like most logging libraries other than the JDK); when bridging to JDK logging, JBoss Logging maps TRACE to JDK's FINER level. So you'd want to use =FINER in your config (or =FINEST)

edited Nov 25, 2013 at 4:27

Afshin Moazami

2,0985 gold badges33 silver badges57 bronze badges

answered Jun 3, 2013 at 17:14

Steve Ebersole

9,4512 gold badges53 silver badges46 bronze badges

4 Comments

Kamen Jahr Over a year ago

Hi, i have tried, to set FINEST with NO effect:-(( if i debug to the org.jboss.logging.BasicLogger. public boolean isTraceEnabled() { return isEnabled(Level.TRACE);, the "false" is returned, because java.util.logging.Logger. public boolean isLoggable(Level level) { if (level.intValue() < levelValue || levelValue == offValue) { return false; } return true; } reeturns "false", because "levelValue" equals to 800 (also INFO)

Steve Ebersole Over a year ago

Your problem is not Hibernate nor JBoss Logging. You simply are not configuring JDK Logging correctly. I have never used JDK logging (mainly because of stuff like this). So I cannot help you with that. I posted the JDK Logging tool page. I tried reading it, but tbh, it is less than great documentation and I came away with no more knowledge of how to configure JDK Logging via a properties file.

James R. Perkins Over a year ago

@KamenJahr As Steve said it looks like the JDK logging is not configured correct. Can you explain how you're configuring it? By default JDK logging looks in the JRE lib directory for a logging.properties file. You can override that with the java.util.logging.config.file system property though.

Kamen Jahr Over a year ago

@ALL you are all right, my logging.properties was not correclty bound in java class path, i don't know currently, what is wrong, but if i load the loggings.properties using the following code, i see the real values of HQLs if i use the FINEST level: public static void loadLoggings(String fullName) throws SecurityException, IOException { InputStream is = null; is = new FileInputStream(fullName); LogManager.getLogManager().readConfiguration(is); }. i have defined such level: org.hibernate.SQL.level =FINEST within properties file. Other level options are set to OFF

Community · Accepted Answer · 2017-05-23 12:14:46Z

0

I have encountered the same issue and doesn't want to use another logging facility.

I ended up with following configuration (original question):

handlers=java.util.logging.ConsoleHandler
java.util.logging.ConsoleHandler.level=FINE
org.hibernate.level=WARN
org.hibernate.SQL.level=FINE

Perhaps not the best one, because it logs sometimes a lot of stuff, but it is working.

edited May 23, 2017 at 12:14

CommunityBot

11 silver badge

answered Sep 15, 2015 at 8:39

CSchulz

11.1k11 gold badges63 silver badges118 bronze badges

Comments

ejaenv · Accepted Answer · 2016-07-21 11:02:19Z

0

with wireshark you can easily see the full mysql sentences

answered Jul 21, 2016 at 11:02

ejaenv

2,4872 gold badges26 silver badges28 bronze badges

Collectives™ on Stack Overflow

Hibernate 4.2:How to trace sql values with JDK logging API

4 Answers 4

Comments

4 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related