how can I stop hibernate to write out the generated query strings while operating?

I set the Appender File Logger to write to a text file and log4j.logger property to "DEBUG" to write the all output that hibernate generates into a text file.

But I couldnt stop hibernate to write out queries on the output console.

Set hibernate.show_sql = false in your configuration.