[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Parsed but unexecuted SQL statements

Wed Sep 19 12:42:10 EDT 2007

We're running Hibernate on JBoss 4.2.0. We are using an Oracle tool that shows the queries against our database. It shows that there are 1000's of simple queries over a period of time against each of the tables we have defined in Hibernate. The queries are as simple as:

     SELECT * FROM table

The Oracle tool also shows that the query is parsed BUT NEVER EXECUTED! These queries are really killing our performance!!!

Is Hibernate or JBoss doing something under the covers to parse these tables and is it doing it repeatedly? We need to turn this off is there is a setting that enables this behavior.

Thanks in advance.

John G.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4086235#4086235

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4086235