lower the loglevel of hibernate and disable the show sql queries in the hibernate config.
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.
If that is not set, just lower the log levels hibernate:
or remove/comment them out them since default level of hibernate is INFO (as can be seen above in logging.properties)
The changes worked for me. I changed from FINEST to INFO. Thanks for your guidance.
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.
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.