org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2211) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2092) at org.hibernate.loader.Loader.list(Loader.java:2087) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:95) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283) at org.hibernate.test.unionsubclass2.UnionSubclassTest.testUnionSubclass(UnionSubclassTest.java:93) at org.hibernate.test.TestCase.runTest(TestCase.java:249) at org.hibernate.test.TestCase.runBare(TestCase.java:311) Caused by: java.sql.SQLException: Unexpected token: , in statement [select this_.person_id as person1_2990_0_, this_.name as name2990_0_, this_.sex as sex2990_0_, this_.address as address2990_0_, this_.zip as zip2990_0_, this_.country as country2990_0_, this_.title as title2991_0_, this_.salary as salary2991_0_, this_.manager as manager2991_0_, this_.comments as comments2992_0_, this_.salesperson as salesper2_2992_0_, this_.clazz_ as clazz_0_ from ( select null as comments, sex, country, null as title, person_id, address, null as manager, zip, name, null as salesperson, null as salary, 0 as clazz_ from UPerson union select null as comments, sex, country, title, person_id, address, manager, zip, name, null as salesperson, salary, 1 as clazz_ from UEmployee union select comments, sex, country, null as title, person_id, address, null as manager, zip, name, salesperson, null as salary, 2 as clazz_ from UCustomer ) this_ where (this_.address, this_.zip, this_.country) in ((?, ?, ?), (?, ?, ?))] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:497) at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:415) at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139) at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1540) at org.hibernate.loader.Loader.doQuery(Loader.java:661) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2208) ... 23 more
|