6 Replies Latest reply on Jan 26, 2010 10:21 AM by mike_burton

[jBPM4.3] - Debug messages on the console

mike_burton Jan 19, 2010 3:28 PM

When i run the test examples in 4.3, i see the debug messages (SQL Queries etc..) printing on console.
Can any one please tell me how to stop priting these debug messages (atleast SQL queries).

Thanks for your valuable responses.

1. Re: [jBPM4.3] - Debug messages on the console

kukeltje Jan 19, 2010 4:10 PM (in response to mike_burton)

lower the loglevel of hibernate and disable the show sql queries in the hibernate config.
Actions
2. Re: [jBPM4.3] - Debug messages on the console

mike_burton Jan 19, 2010 4:31 PM (in response to kukeltje)

Hi Ronald,

Thanks for the information. But i could not find out show sql anywhere in hiberante config. Can you please guide me in which hibernate config file i need to set it.

Thanks
Actions
3. Re: [jBPM4.3] - Debug messages on the console

kukeltje Jan 19, 2010 4:50 PM (in response to mike_burton)

If that is not set, just lower the log levels hibernate:

change e.g.

org.hibernate.SQL.level=FINEST
org.hibernate.type.level=FINEST

into

org.hibernate.SQL.level=INFO
org.hibernate.type.level=INFO

or remove/comment them out them since default level of hibernate is INFO (as can be seen above in logging.properties)
Actions
4. Re: [jBPM4.3] - Debug messages on the console

mike_burton Jan 20, 2010 10:30 AM (in response to kukeltje)

Hi Ronald,

The changes worked for me. I changed from FINEST to INFO. Thanks for your guidance.
Actions
5. Re: [jBPM4.3] - Debug messages on the console

saraswati.santanu Jan 23, 2010 5:17 AM (in response to mike_burton)

Mike,
hibernate prints SQL only if show_sql property is set to true. If the SQL print statements are formatted like "Hibernate: <SQL>" then you can be assured that show_sql is true.

In jBPM 4.3 example show_sql is false (this is false by default, and in the example it is not set to true). Please check if that is updated. Otherwise if you are using something like spring then you may need to check the spring configuration for this value. If you are not sure, you can run a find comand for show_sql on the whole directory. You will get something.

Regards,
Santanu
Actions
6. Re: [jBPM4.3] - Debug messages on the console

mike_burton Jan 26, 2010 10:21 AM (in response to saraswati.santanu)

Hi Santanu,

Thanks for your reply. I dont see the formatted SQL statemens like "Hibernate: <SQL>" on console. I am only running the test examples which are in jBPM4.3 and even i dont find show_sql property any where in the whole directory.
Actions

Go to original post