[hibernate-dev] ERROR SqlExceptionHelper:144 - Table "GIVENIDSTRENTITY_AUD" not found;
Hi Adam,
when running hibernate test suite, this test
(org.hibernate.envers.test.integration.merge.AddDelTest) always fail with the following
message:
22:09:58,494 DEBUG SQL:104 -
create table GIVENIDSTRENTITY_AUD (
id integer not null,
REV integer not null,
REVTYPE tinyint,
data varchar(255),
primary key (id, REV)
)
Hibernate:
create table GIVENIDSTRENTITY_AUD (
id integer not null,
REV integer not null,
REVTYPE tinyint,
data varchar(255),
primary key (id, REV)
)
22:09:58,851 DEBUG SQL:104 -
insert
into
GIVENIDSTRENTITY_AUD
(REVTYPE, data, id, REV)
values
(?, ?, ?, ?)
Hibernate:
insert
into
GIVENIDSTRENTITY_AUD
(REVTYPE, data, id, REV)
values
(?, ?, ?, ?)
22:09:59,032 WARN SqlExceptionHelper:143 - SQL Error: 42102, SQLState: 42S02
22:09:59,033 ERROR SqlExceptionHelper:144 - Table "GIVENIDSTRENTITY_AUD" not
found; SQL statement:
select givenidstr0_.REV as col_0_0_ from GIVENIDSTRENTITY_AUD givenidstr0_ cross join
REVINFO defaultrev1_ where givenidstr0_.id=? and givenidstr0_.REV=defaultrev1_.REV order
by givenidstr0_.REV asc [42102-145]
org.hibernate.exception.SQLGrammarException: Table "GIVENIDSTRENTITY_AUD" not
found; SQL statement:
select givenidstr0_.REV as col_0_0_ from GIVENIDSTRENTITY_AUD givenidstr0_ cross join
REVINFO defaultrev1_ where givenidstr0_.id=? and givenidstr0_.REV=defaultrev1_.REV order
by givenidstr0_.REV asc [42102-145]
at
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:122)
at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
at
org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler.continueInvocation(ConnectionProxyHandler.java:146)
at
org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
at $Proxy18.prepareStatement(Unknown Source)
at
org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:147)
at
org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:166)
at
org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:145)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1720)
at org.hibernate.loader.Loader.doQuery(Loader.java:828)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:289)
at org.hibernate.loader.Loader.doList(Loader.java:2447)
-------------------------
Best Regards,
Strong Liu <stliu at hibernate.org>
http://about.me/stliu/bio