0 Replies Latest reply on Sep 19, 2007 12:42 PM by john griffin

    Parsed but unexecuted SQL statements

    john griffin Newbie

      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.