10 Replies Latest reply on Apr 2, 2013 4:08 PM by adamw

Envers & Oracle & ORA-00942 error

goksoy66 Mar 13, 2013 5:29 AM

hi all,

i want to enable auditing on my Oracle database, using Envers. But it fires the following exception.

WARNING: SQL Error: 942, SQLState: 42000

SEVERE: ORA-00942: table or view does not exist

WARNING: SQL Error: 942, SQLState: 42000

SEVERE: ORA-00942: table or view does not exist

SEVERE: Could not synchronize database state with session

org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)

at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)

at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)

at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)

....

But, if I use Derby database, there is no exception thrown.

Should I make some configurations to Oracle db? If yes, how?

1. Re: Envers & Oracle & ORA-00942 error

goksoy66 Mar 13, 2013 5:52 AM (in response to goksoy66)

this exception is thrown when i try to insert a row to @Audited table.
Actions
2. Re: Envers & Oracle & ORA-00942 error

goksoy66 Mar 13, 2013 8:30 AM (in response to goksoy66)

these are the dependencies in pom.xml

         <dependency>
            <groupId>org.hibernate</groupId>
            <artifactId>hibernate-entitymanager</artifactId>
            <version>3.6.9.Final</version>
        </dependency>
        <dependency>
            <groupId>org.hibernate</groupId>
            <artifactId>hibernate-envers</artifactId>
            <version>3.6.9.Final</version>
        </dependency>
        <dependency>
            <groupId>org.hibernate</groupId>
            <artifactId>hibernate-jpamodelgen</artifactId>
            <version>1.2.0.Final</version>
        </dependency>
Actions
3. Re: Envers & Oracle & ORA-00942 error

goksoy66 Mar 15, 2013 8:04 AM (in response to goksoy66)

any comment?
Actions
4. Re: Envers & Oracle & ORA-00942 error

adamw Mar 20, 2013 9:53 AM (in response to goksoy66)

Do you have hbm2ddl set to update? Do the audit tables exist?

Adam
Actions
5. Re: Envers & Oracle & ORA-00942 error

goksoy66 Mar 20, 2013 10:53 AM (in response to adamw)

I am using JPA API, and i've tried "update" option as follows:

<property name="hibernate.hbm2ddl.auto" value="update"/>
Actions
6. Re: Envers & Oracle & ORA-00942 error

adamw Mar 25, 2013 5:41 PM (in response to goksoy66)

Yeah, this should work.
Do you see any logs regarding schema update during Hibernate start-up?

Adam
Actions
7. Re: Envers & Oracle & ORA-00942 error

goksoy66 Mar 27, 2013 8:55 AM (in response to adamw)

yeah, i can see. and it occurs twice.

INFO: Running hbm2ddl schema update
INFO: fetching database metadata
INFO: updating schema

.....

INFO: schema update complete

..........

INFO: Running hbm2ddl schema update
INFO: fetching database metadata
INFO: updating schema

.....

INFO: schema update complete
Actions
8. Re: Envers & Oracle & ORA-00942 error

adamw Mar 29, 2013 9:20 AM (in response to goksoy66)

No idea then, sorry.

Adam
Actions
9. Re: Envers & Oracle & ORA-00942 error

goksoy66 Mar 29, 2013 9:46 AM (in response to adamw)

There is no problem with creating AUD tables. The exception is thrown when I want to insert data.
Actions
10. Re: Envers & Oracle & ORA-00942 error

adamw Apr 2, 2013 4:08 PM (in response to goksoy66)

Weird, maybe some schema/catalog setting causes Oracle to put the audit tables in a different place? Hard to say without debugging.

Adam
Actions

Go to original post