I found the the below "Generated SQL' is executing every much, and am not sure what is causing this or how to prevent this from happening if possible. Any suggestions on how to prevent this from happening are much appreciated!


Hibernate version:
3.2.6ga
Mapping documents (All properties other than connection):
<property name="hibernate.c3p0.acquire_increment">1</property>
<property name="hibernate.c3p0.idle_test_period">3</property> <!-- seconds -->
<property name="hibernate.c3p0.max_size">20</property>
<property name="hibernate.c3p0.max_statements">0</property>
<property name="hibernate.c3p0.min_size">1</property>
<property name="hibernate.c3p0.timeout">20</property> <!-- seconds -->
<property name="hibernate.c3p0.initial_pool_size">1</property>
<property name="hibernate.c3p0.max_connection_age">120</property>

<property name="hibernate.dialect">org.hibernate.dialect.OracleDialect</property>

<property name="hibernate.current_session_context_class">thread</property>

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

Name and version of the database you are using:
Oracle 10.1.0.2.0
Oracle JDBC Driver 11.1.0.6.0

The generated SQL:
SELECT NULL AS table_cat,

o.owner AS table_schem,

o.object_name AS table_name,

o.object_type AS table_type,

NULL AS remarks

FROM all_objects o

WHERE o.owner LIKE :1 ESCAPE :"SYS_B_0"

AND o.object_name LIKE :2 ESCAPE :"SYS_B_1"

AND o.object_type IN (:"SYS_B_2", :"SYS_B_3")

ORDER BY table_type, table_schem, table_name