Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.0.5

Mapping documents: n/a

Code between sessionFactory.openSession() and session.close(): n/a

Full stack trace of any exception that occurs: n/a

Name and version of the database you are using: DB2 8.2.1

The generated SQL (show_sql=true): n/a

Debug level Hibernate log excerpt:

I am running Hibernate in a WAS 5.1 test server within WSAD 5.1.2. I have log4j and commons-logging jars in the web project classpath. Our own application code uses log4j directly (not commons apis) and works just fine - i.e. I can turn on or off the debug level as needed.

But it looks like WAS's use of commons-logging is preventing me from getting Hibernate to use log4j - Hibernate's log messages come out looking like the test server in terms of format - and not at all with the pattern layout that I have specified in our log4j.properties file. This is a sample of what the Hibernate log message looks like vs one from our application:

[6/21/05 13:21:35:831 EDT] 3d3a21a2 SessionFactor I org.hibernate.impl.SessionFactoryImpl Checking 3 named queries
[INVSVCS] [ BootStrapServlet:: init( 93)] [06/21 13:21:35] [DEBUG] [SEVERITY 4] Putting the Hibernate main session factory into the AppContext object...

Has anyone worked around this problem and been able to get Hibernate to at least log at debug level within WSAD using the WAS 5.1 test server?

I don't need this often but ever now and then it would be helpful to get this level of detail from Hibernate.

WebSphere uses Commons Logging and supplies its own log Factory implementation so by default, you would only see INFO and ERROR messages in the WAS console. To override WAS so you have control over the format and get DEBUG messages in the console, add a file called "org.apache.commons.logging.LogFactory" to your web application's META-INF/services. In that file, add the line:

org.apache.commons.logging.impl.LogFactoryImpl

There's a document describing all the details (PDF):

http://www-1.ibm.com/support/docview.ws ... 4610&aid=1

Great! - That's exactly what I was looking for!