Error running demo app
sannegrinovero Oct 13, 2008 4:45 AMHello, very nice project!
I downloaded the trunk from SVN to give a look, I've hit this exception
running the console demo:
Oct 13, 2008 12:34:37 PM org.hibernate.util.JDBCExceptionReporter logExceptions WARNING: SQL Error: -28, SQLState: S0022 Oct 13, 2008 12:34:37 PM org.hibernate.util.JDBCExceptionReporter logExceptions SEVERE: Column not found: ID in statement [select person_ver0_.id as id3_, person_ver0_._revision as column2_3_, person_ver0_._revision_type as column3_3_, person_ver0_.name as name3_, person_ver0_.surname as surname3_, person_ver0_.address_id as address6_3_ from Person_versions person_ver0_ where person_ver0_._revision_type<>? and person_ver0_._revision=(select max(person_ver1_._revision) from Person_versions person_ver1_ where person_ver1_._revision<=? and person_ver0_.id=person_ver1_.id) and person_ver0_.id=?] Exception in thread "main" 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:2216) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) at org.hibernate.loader.Loader.list(Loader.java:2099) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.jboss.envers.query.impl.AbstractVersionsQuery.buildAndExecuteQuery(AbstractVersionsQuery.java:88) at org.jboss.envers.query.impl.EntitiesAtRevisionQuery.list(EntitiesAtRevisionQuery.java:82) at org.jboss.envers.query.impl.AbstractVersionsQuery.getSingleResult(AbstractVersionsQuery.java:98) at org.jboss.envers.reader.VersionsReaderImpl.find(VersionsReaderImpl.java:100) at org.jboss.envers.demo.TestConsole.printPersonHistory(TestConsole.java:92) at org.jboss.envers.demo.TestConsole.start(TestConsole.java:315) at org.jboss.envers.demo.TestConsole.main(TestConsole.java:454) Caused by: java.sql.SQLException: Column not found: ID in statement [select person_ver0_.id as id3_, person_ver0_._revision as column2_3_, person_ver0_._revision_type as column3_3_, person_ver0_.name as name3_, person_ver0_.surname as surname3_, person_ver0_.address_id as address6_3_ from Person_versions person_ver0_ where person_ver0_._revision_type<>? and person_ver0_._revision=(select max(person_ver1_._revision) from Person_versions person_ver1_ where person_ver1_._revision<=? and person_ver0_.id=person_ver1_.id) and person_ver0_.id=?] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.executeQuery(Unknown Source) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1787) at org.hibernate.loader.Loader.doQuery(Loader.java:674) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2213) ... 14 more
I just did "list person history" (2), and choose person 1.
I built it just doing, suing Java 1.5.16:
ant dist-demo cd dist java -jar envers-console-demo.jar
I don't need you to help me on this of course, it's just to let you know.
regards,