org.hibernate.exception.SQLGrammarException: could not execute query

Hibernate JIRA | Roland Scheel | 1 decade ago
  1. 0

    Hibernate will produce wrong sql syntax when using zero-length arrays as parameters for variables in in-clauses. Example: Session s = hibSessionFactory.openSession(); Query q = s.createQuery("from testInQuery.TestTable where id in (:ids)"); q.setParameterList("ids", new Integer[0]); q.list(); produced sql by hibernate: select testtable0_.ID as ID from TESTTABLE testtable0_ where (id in()) Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:70) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:1525) at org.hibernate.loader.Loader.list(Loader.java:1505) at org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:883) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:791) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74) at testInQuery.AbstractDatabase.main(AbstractDatabase.java:35) Caused by: java.sql.SQLException: ORA-00936: missing expression at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181) at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:420) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:896) at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:452) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:986) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2929) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:118) at org.hibernate.loader.Loader.getResultSet(Loader.java:1204) at org.hibernate.loader.Loader.doQuery(Loader.java:368) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:208) at org.hibernate.loader.Loader.doList(Loader.java:1522)

    Hibernate JIRA | 1 decade ago | Roland Scheel
    org.hibernate.exception.SQLGrammarException: could not execute query
  2. 0

    Hibernate will produce wrong sql syntax when using zero-length arrays as parameters for variables in in-clauses. Example: Session s = hibSessionFactory.openSession(); Query q = s.createQuery("from testInQuery.TestTable where id in (:ids)"); q.setParameterList("ids", new Integer[0]); q.list(); produced sql by hibernate: select testtable0_.ID as ID from TESTTABLE testtable0_ where (id in()) Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:70) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:1525) at org.hibernate.loader.Loader.list(Loader.java:1505) at org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:883) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:791) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74) at testInQuery.AbstractDatabase.main(AbstractDatabase.java:35) Caused by: java.sql.SQLException: ORA-00936: missing expression at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181) at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:420) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:896) at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:452) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:986) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2929) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:118) at org.hibernate.loader.Loader.getResultSet(Loader.java:1204) at org.hibernate.loader.Loader.doQuery(Loader.java:368) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:208) at org.hibernate.loader.Loader.doList(Loader.java:1522)

    Hibernate JIRA | 1 decade ago | Roland Scheel
    org.hibernate.exception.SQLGrammarException: could not execute query
  3. 0

    Hibernate IN clause showing error

    Stack Overflow | 4 years ago | JNPW
    java.sql.SQLException: ORA-00942: table or view does not exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Summary: When executing the query "from Privilege p where :user in p.roles.users" an oracle SQLException: "missing expression" is thrown. Alternate queries were found, but this query should either work, or produce a hibernate query exception of some sort (ie malformed query, unsupported query etc), not left up to Oracle. This bug report contains: - 3 Java classes for model objects ~ TestUser.java - contains a set of TestRoles ~ TestRole.java - contains a set of TestUsers and a list of TestPrivileges ~ TestPrivilege.java - contains a set of TestRoles - 3 Hibernate mappings ~ All sets are mapped, some are inverse mappings. - 1 Hibernate configuration file ~ identifies the 3 mapping files - 1 JUnit test class with example queries ~ test1 produces invalid sql ~ test2 is valide, but unexpectedly returns no results ~ test3 is valid and returns correct results - 2 Stack traces, one from test1 and one test2 ////////////////////////////////////////////// // TestUser.java // ////////////////////////////////////////////// package au.com.dytech.find.core.hibernatetest; import java.util.HashSet; import java.util.Set; /** * A User of the system. * * @author Dytech Solutions Pty. Ltd. */ public class TestUser { Set roles; Long id; public TestUser() { roles = new HashSet(); } /** * @return Returns the id. */ public Long getId() { return id; } /** * @param id The id to set. */ public void setId(Long id) { this.id = id; } /** * @param role The role to add. */ public void addRole(TestRole role) { roles.add(role); role.getUsers().add(this); } /** * @return Returns the roles. */ public Set getRoles() { return roles; } /** * @param roles The roles to set. */ public void setRoles(Set roles) { this.roles = roles; } } ////////////////////////////////////////////// // TestRole.java // ////////////////////////////////////////////// package au.com.dytech.find.core.hibernatetest; import java.util.HashSet; import java.util.Set; /** * A role assumed by Users. * * @author Dytech Solutions Pty. Ltd. */ public class TestRole { Set privileges; Set users; Long id; public TestRole() { privileges = new HashSet(); users = new HashSet(); } /** * @return Returns the id. */ public Long getId() { return id; } /** * @param id The id to set. */ public void setId(Long id) { this.id = id; } /** * @param user The user to add. */ public void addUser(TestUser user) { user.addRole(this); } /** * @return Returns the users. */ public Set getUsers() { return users; } /** * @param users The users to set. */ public void setUsers(Set users) { this.users = users; } /** * @param privilege The pivilege to add. */ public void addPrivilege(TestPrivilege privilege) { privileges.add(privilege); privilege.getRoles().add(this); } /** * @return Returns the privileges. */ public Set getPrivileges() { return privileges; } /** * @param privileges The privileges to set. */ public void setPrivileges(Set privileges) { this.privileges = privileges; } } ////////////////////////////////////////////// // TestPrivilege.java // ////////////////////////////////////////////// package au.com.dytech.find.core.hibernatetest; import java.util.HashSet; import java.util.Set; /** * A privilege granted to roles. * * @author Dytech Solutions Pty. Ltd. */ public class TestPrivilege { Set roles; Long id; public TestPrivilege() { roles = new HashSet(); } /** * @return Returns the id. */ public Long getId() { return id; } /** * @param id The id to set. */ public void setId(Long id) { this.id = id; } /** * @param role The role to add. */ public void addRole(TestRole role) { role.addPrivilege(this); } /** * @return Returns the roles. */ public Set getRoles() { return roles; } /** * @param roles The roles to set. */ public void setRoles(Set roles) { this.roles = roles; } } ////////////////////////////////////////////// // TestUser.hbm.xml // ////////////////////////////////////////////// <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping> <class name="au.com.dytech.find.core.hibernatetest.TestUser" table="TEST_USER" > <id name="id" column="id" type="long"> <generator class="native"/> </id> <set name="roles" table="TEST_USER_ROLES" lazy="false" cascade="all"> <key column="USER_ID"/> <many-to-many class = "au.com.dytech.find.core.hibernatetest.TestRole" foreign-key = "FK_TEST_USER_ROLES_ROLE" column = "ROLE_ID"/> </set> </class> </hibernate-mapping> ////////////////////////////////////////////// // TestRole.hbm.xml // ////////////////////////////////////////////// <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping> <class name="au.com.dytech.find.core.hibernatetest.TestRole" table="TEST_ROLE" > <id name="id" column="id" type="long"> <generator class="native"/> </id> <set name="privileges" table="TEST_ROLE_PRIVILEGES" lazy="false" cascade="all"> <key column="ROLE_ID"/> <many-to-many class = "au.com.dytech.find.core.hibernatetest.TestPrivilege" foreign-key = "FK_TEST_ROLE_PRVLGS_PRVLG" column = "PRIVILEGE_ID"/> </set> <set name="users" inverse="true" cascade="all"> <key column="ROLE_ID"/> <many-to-many class = "au.com.dytech.find.core.hibernatetest.TestUser" foreign-key = "FK_TEST_ROLE_USERS_USER" column = "USER_ID"/> </set> </class> </hibernate-mapping> ////////////////////////////////////////////// // TestPrivilege.hbm.xml // ////////////////////////////////////////////// <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping> <class name="au.com.dytech.find.core.hibernatetest.TestPrivilege" table="TEST_PRIVILEGE" > <id name="id" column="id" type="long"> <generator class="native"/> </id> <set name="roles" inverse="true" cascade="all"> <key column="PRIVILEGE_ID"/> <many-to-many class = "au.com.dytech.find.core.hibernatetest.TestRole" foreign-key = "FK_TEST_PRIVILEGE_ROLES_ROLE" column = "ROLE_ID"/> </set> </class> </hibernate-mapping> ////////////////////////////////////////////// // hibernate.cfg.xml // ////////////////////////////////////////////// <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <property name="dialect">org.hibernate.dialect.OracleDialect</property> <property name="show_sql">false</property> <property name="cache.provider_class">org.hibernate.cache.EhCacheProvider</property> <mapping resource="au/com/dytech/find/core/hibernatetest/TestPrivilege.hbm.xml"/> <mapping resource="au/com/dytech/find/core/hibernatetest/TestRole.hbm.xml"/> <mapping resource="au/com/dytech/find/core/hibernatetest/TestUser.hbm.xml"/> </session-factory> </hibernate-configuration> ////////////////////////////////////////////// // HibernateQueryTest.java // ////////////////////////////////////////////// package au.com.dytech.find.core.hibernatetest; import java.io.File; import java.io.IOException; import java.util.Iterator; import java.util.List; import javax.naming.NamingException; import junit.framework.TestCase; import org.apache.commons.dbcp.BasicDataSource; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Transaction; import org.hibernate.cfg.Configuration; import org.springframework.mock.jndi.SimpleNamingContextBuilder; import org.springframework.orm.hibernate3.SessionFactoryUtils; /** * This test exposes a bug in hibernate's query generation. * * @author Dytech Solutions Pty. Ltd. */ public class HibernateQueryTest extends TestCase { Session session; TestUser user1; TestPrivilege privilege1, privilege2, privilege3, privilege4; private Transaction transaction; /** * @see junit.framework.TestCase#setUp() */ public void setUp() throws Exception { user1 = new TestUser(); TestUser user2 = new TestUser(); TestRole role1 = new TestRole(); TestRole role2 = new TestRole(); TestRole role3 = new TestRole(); privilege1 = new TestPrivilege(); privilege2 = new TestPrivilege(); privilege3 = new TestPrivilege(); privilege4 = new TestPrivilege(); user1.addRole(role1); user1.addRole(role2); role1.addPrivilege(privilege1); role1.addPrivilege(privilege2); role2.addPrivilege(privilege1); role2.addPrivilege(privilege3); user2.addRole(role3); role3.addPrivilege(privilege1); role3.addPrivilege(privilege4); setupJndiContext(); session = getSession(); transaction = session.beginTransaction(); List oldUsers = session.createCriteria(TestUser.class).list(); for (Iterator iter = oldUsers.iterator(); iter.hasNext();) { TestUser oldUser = (TestUser) iter.next(); session.delete(oldUser); } transaction.commit(); transaction = session.beginTransaction(); session.save(user1); session.save(user2); transaction.commit(); transaction = session.beginTransaction(); } /** * @see junit.framework.TestCase#tearDown() */ public void tearDown() { transaction.commit(); } /** * Produces invalid SQL. */ public void test1() { Query query = session.createQuery("from TestPrivilege p where :user in p.roles.users"); query.setEntity("user", user1); List results = query.list(); assertEquals(3, results.size()); assertTrue(results.contains(privilege1)); assertTrue(results.contains(privilege2)); assertTrue(results.contains(privilege3)); } /** * Produces valid SQL, but no results are found. */ public void test2() { Query query = session.createQuery("from TestPrivilege p where :user in elements(p.roles.users)"); query.setEntity("user", user1); List results = query.list(); assertEquals(3, results.size()); assertTrue(results.contains(privilege1)); assertTrue(results.contains(privilege2)); assertTrue(results.contains(privilege3)); } /** * Successful Query! */ public void test3() { Query query = session.createQuery("select distinct u.roles.privileges from TestUser u where u = :user"); query.setEntity("user", user1); List results = query.list(); assertEquals(3, results.size()); assertTrue(results.contains(privilege1)); assertTrue(results.contains(privilege2)); assertTrue(results.contains(privilege3)); } /** * Create a new Hibernate Session. */ private Session getSession() { File configFile = new File( "src/code/au/com/dytech/find/core/hibernatetest/hibernate.cfg.xml").getAbsoluteFile(); Configuration cfg = new Configuration(); cfg.configure(configFile); cfg.buildMappings(); cfg.setProperty("hibernate.connection.datasource", "jdbc/FindDb"); SessionFactory sessionFactory = cfg.buildSessionFactory(); Session session = SessionFactoryUtils.getNewSession(sessionFactory); return session; } /** * Sets up testing JNDI resources * */ public void setupJndiContext() throws NamingException, IOException { if (SimpleNamingContextBuilder.getCurrentContextBuilder() == null) { SimpleNamingContextBuilder builder = SimpleNamingContextBuilder.emptyActivatedContextBuilder(); BasicDataSource ds = new BasicDataSource(); ds.setPassword("dbpassword"); ds.setDriverClassName("oracle.jdbc.driver.OracleDriver"); ds.setUsername("dbusername"); ds.setUrl("jdbc:oracle:thin:@dbserver:dbport:dbname"); ds.setMaxActive(10); ds.setInitialSize(1); builder.bind("java:comp/env/" + "jdbc/FindDb", ds); builder.bind("jdbc/FindDb", ds); } } } ////////////////////////////////////////////// // test1 stack trace // ////////////////////////////////////////////// org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:70) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:1596) at org.hibernate.loader.Loader.list(Loader.java:1577) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74) at au.com.dytech.find.core.hibernatetest.HibernateQueryTest.test1(HibernateQueryTest.java:97) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at junit.framework.TestCase.runTest(TestCase.java:154) at junit.framework.TestCase.runBare(TestCase.java:127) at junit.framework.TestResult$1.protect(TestResult.java:106) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.framework.TestResult.run(TestResult.java:109) at junit.framework.TestCase.run(TestCase.java:118) at junit.framework.TestSuite.runTest(TestSuite.java:208) at junit.framework.TestSuite.run(TestSuite.java:203) at junit.framework.TestSuite.runTest(TestSuite.java:208) at junit.framework.TestSuite.run(TestSuite.java:203) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:478) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:344) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196) Caused by: java.sql.SQLException: ORA-00936: missing expression at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:182) at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:589) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1025) at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:632) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1147) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3035) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3076) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120) at org.hibernate.loader.Loader.getResultSet(Loader.java:1272) at org.hibernate.loader.Loader.doQuery(Loader.java:391) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218) at org.hibernate.loader.Loader.doList(Loader.java:1593) ... 23 more ////////////////////////////////////////////// // test2 stack trace // ////////////////////////////////////////////// junit.framework.AssertionFailedError: expected:<3> but was:<0> at junit.framework.Assert.fail(Assert.java:47) at junit.framework.Assert.failNotEquals(Assert.java:282) at junit.framework.Assert.assertEquals(Assert.java:64) at junit.framework.Assert.assertEquals(Assert.java:201) at junit.framework.Assert.assertEquals(Assert.java:207) at au.com.dytech.find.core.hibernatetest.HibernateQueryTest.test2(HibernateQueryTest.java:114) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at junit.framework.TestCase.runTest(TestCase.java:154) at junit.framework.TestCase.runBare(TestCase.java:127) at junit.framework.TestResult$1.protect(TestResult.java:106) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.framework.TestResult.run(TestResult.java:109) at junit.framework.TestCase.run(TestCase.java:118) at junit.framework.TestSuite.runTest(TestSuite.java:208) at junit.framework.TestSuite.run(TestSuite.java:203) at junit.framework.TestSuite.runTest(TestSuite.java:208) at junit.framework.TestSuite.run(TestSuite.java:203) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:478) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:344) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)

    Hibernate JIRA | 1 decade ago | Dytech Solutions
    org.hibernate.exception.SQLGrammarException: could not execute query
  6. 0

    Tomcat - User - IE causes an ORA-00936 error, but not Firefox?

    nabble.com | 8 months ago
    java.sql.SQLException: ORA-00936: missing expression

    12 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      ORA-00936: missing expression

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OraclePreparedStatement.executeQuery
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
      4. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
      5. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
      6. oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:420)
      7. oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:896)
      8. oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:452)
      9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:986)
      10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888)
      11. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2929)
      11 frames
    3. Hibernate
      Loader.doList
      1. org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:118)
      2. org.hibernate.loader.Loader.getResultSet(Loader.java:1204)
      3. org.hibernate.loader.Loader.doQuery(Loader.java:368)
      4. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:208)
      5. org.hibernate.loader.Loader.doList(Loader.java:1522)
      5 frames