I have a number of console programs I need to write for mainframe -
to sql updates and extracts.

When I run a sample program for a sql table read / display, I'm
able to suppress all the:

Hibernate 3.2.0.ga
loaded properties from resource hibernate.properties:
using java.io streams to persist binary types
....etc.....

messages using log4j, but I'm still getting the:

Hibernate: select <table>0_.id as id0_, <table>0_.USERID as USERID0_,

...etc messages. If I use setMaxResults() and setFirstResult() to page
through a large table, I get the 'select' message for each page.
Is there any way in hibernate.properties to suppress the 'select'
messages ? I've got the 'hibernate.show_sql false' set in
hibernate.properties, and I set up a hibernate.cfg.xml file in my
JAR file that holds the EJB3 beans, with a line that does the same:

<property name="hibernate.show_sql">false</property>

I even tried to put lines in the console program like:

org.hibernate.cfg.Configuration config
= new org.hibernate.cfg.Configuration();
config.setProperty("hibernate.show_sql", "false" );

.....all to no avail.
Is there another setting to disable the above 'select' message showing ?

I'm running JBoss 4.0.5ga on windows XP, Hibernate 3.2.0ga,
Java 1.5.0_11-b03, and Mysql 5.0.45-community-nt, and the
Mysql-connector v5.0.7.

Thanks.....tom c.