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

    Envers & Oracle & ORA-00942 error

    goksoy66

      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?