[hibernate-dev] ERROR SqlExceptionHelper:144 - Table "GIVENIDSTRENTITY_AUD" not found;

[Strong Liu]

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