We are using Hibernate in Websphere Portal 5.1.0.2 enviornment. We are not sure but suddenly we are getting following error messages. Any idea?

Hibernate version:
3.0.1

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

[7/27/06 7:05:21:146 CDT] 133a8c JDBCException W
org.hibernate.util.JDBCExceptionReporter SQL Error: 1031, SQLState: 42000
[7/27/06 7:05:21:148 CDT] 133a8c JDBCException E
org.hibernate.util.JDBCExceptionReporter ORA-01031: insufficient
privileges
[7/27/06 7:05:21:150 CDT] 133a8c JDBCException W
org.hibernate.util.JDBCExceptionReporter SQL Error: 1031, SQLState: 42000
[7/27/06 7:05:21:152 CDT] 133a8c JDBCException E
org.hibernate.util.JDBCExceptionReporter ORA-01031: insufficient
privileges
[7/27/06 7:05:21:154 CDT] 133a8c AbstractFlush E
org.hibernate.event.def.AbstractFlushingEventListener Could not
synchronize database state with session
[7/27/06 7:05:21:184 CDT] 133a8c AbstractFlush E
org.hibernate.event.def.AbstractFlushingEventListener TRAS0014I: The
following exception was logged
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch
update
[7/27/06 7:10:43:821 CDT] 4c040 JDBCException W
org.hibernate.util.JDBCExceptionReporter SQL Error: 1031, SQLState: 42000
[7/27/06 7:10:43:824 CDT] 4c040 JDBCException E
org.hibernate.util.JDBCExceptionReporter ORA-01031: insufficient
privileges
[7/27/06 7:10:43:826 CDT] 4c040 JDBCException W
org.hibernate.util.JDBCExceptionReporter SQL Error: 1031, SQLState: 42000
[7/27/06 7:10:43:828 CDT] 4c040 JDBCException E
org.hibernate.util.JDBCExceptionReporter ORA-01031: insufficient
privileges
[7/27/06 7:10:43:831 CDT] 4c040 AbstractFlush E
org.hibernate.event.def.AbstractFlushingEventListener Could not
synchronize database state with session
[7/27/06 7:10:43:848 CDT] 4c040 AbstractFlush E
org.hibernate.event.def.AbstractFlushingEventListener TRAS0014I: The
following exception was logged
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch
update
[7/27/06 7:11:16:713 CDT] 128deae JDBCException W
org.hibernate.util.JDBCExceptionReporter SQL Error: 1031, SQLState: 42000
[7/27/06 7:11:16:717 CDT] 128deae JDBCException E
org.hibernate.util.JDBCExceptionReporter ORA-01031: insufficient
privileges
[7/27/06 7:11:16:718 CDT] 128deae JDBCException W
org.hibernate.util.JDBCExceptionReporter SQL Error: 1031, SQLState: 42000
[7/27/06 7:11:16:720 CDT] 128deae JDBCException E
org.hibernate.util.JDBCExceptionReporter ORA-01031: insufficient
privileges
[7/27/06 7:11:16:721 CDT] 128deae AbstractFlush E
org.hibernate.event.def.AbstractFlushingEventListener Could not
synchronize database state with session
[7/27/06 7:11:16:730 CDT] 128deae AbstractFlush E
org.hibernate.event.def.AbstractFlushingEventListener TRAS0014I: The
following exception was logged
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch
update
[7/27/06 7:11:16:836 CDT] 128deae SystemOut O
java.runtime.name=Java(TM) 2 Runtime Environment, Stand...
[7/27/06 7:12:07:836 CDT] 133a8c JDBCException W
org.hibernate.util.JDBCExceptionReporter SQL Error: 1031, SQLState: 42000
[7/27/06 7:12:07:839 CDT] 133a8c JDBCException E
org.hibernate.util.JDBCExceptionReporter ORA-01031: insufficient
privileges
[7/27/06 7:12:07:840 CDT] 133a8c JDBCException W
org.hibernate.util.JDBCExceptionReporter SQL Error: 1031, SQLState: 42000
[7/27/06 7:12:07:842 CDT] 133a8c JDBCException E
org.hibernate.util.JDBCExceptionReporter ORA-01031: insufficient
privileges
[7/27/06 7:12:07:843 CDT] 133a8c AbstractFlush E
org.hibernate.event.def.AbstractFlushingEventListener Could not
synchronize database state with session
[7/27/06 7:12:07:848 CDT] 133a8c AbstractFlush E
org.hibernate.event.def.AbstractFlushingEventListener TRAS0014I: The
following exception was logged
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch
update
[7/27/06 7:12:38:438 CDT] 1937244 JDBCException W
org.hibernate.util.JDBCExceptionReporter SQL Error: 1031, SQLState: 42000
[7/27/06 7:12:38:441 CDT] 1937244 JDBCException E
org.hibernate.util.JDBCExceptionReporter ORA-01031: insufficient
privileges
[7/27/06 7:12:38:443 CDT] 1937244 JDBCException W
org.hibernate.util.JDBCExceptionReporter SQL Error: 1031, SQLState: 42000
[7/27/06 7:12:38:445 CDT] 1937244 JDBCException E
org.hibernate.util.JDBCExceptionReporter ORA-01031: insufficient
privileges
[7/27/06 7:12:38:446 CDT] 1937244 AbstractFlush E
org.hibernate.event.def.AbstractFlushingEventListener Could not
synchronize database state with session
[7/27/06 7:12:38:454 CDT] 1937244 AbstractFlush E
org.hibernate.event.def.AbstractFlushingEventListener TRAS0014I: The
following exception was logged
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch
update
[7/27/06 7:38:25:747 CDT] 4c040 RequestUtils E parsePostData: Read
timed out
[7/27/06 7:54:33:554 CDT] 1190ba4 DynaValidator E
org.apache.struts.validator.DynaValidatorForm
org.apache.struts.validator.FieldChecks.validateMask(java.lang.Object,
org.apache.commons.validator.ValidatorAction,
org.apache.commons.validator.Field,
org.apache.struts.action.ActionMessages,
org.apache.commons.validator.Validator,
javax.servlet.http.HttpServletRequest)
[7/27/06 7:54:33:561 CDT] 1190ba4 DynaValidator E
org.apache.struts.validator.DynaValidatorForm TRAS0014I: The following
exception was logged org.apache.commons.validator.ValidatorException:
org.apache.struts.validator.FieldChecks.validateMask(java.lang.Object,
org.apache.commons.validator.ValidatorAction,
org.apache.commons.validator.Field,
org.apache.struts.action.ActionMessages,
org.apache.commons.validator.Validator,
javax.servlet.http.HttpServletRequest)


Name and version of the database you are using:

Oracle 9.2.0.7

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

I have started seeing it today too. In my case it happens on calls that use batch inserts. It makes no sense at all. Why should the question of permissions matter when doing a batch of inserts as opposed to doing them one at a time?

What version of Oracle are you using? My suspicions are raised about this because I never saw this issue when working against an Oracle9 database but I do get it when going against Oracle10. I suspect it could be a bug either in Oracle or in the Hibernate dialect.

We are using 9.2.0.6.0 Oracle and 9.2.0.5.0 JDBC driver

I think there's probably nothing in common between our two cases other than that both produce the same Oracle Error Code.

I think there's probably nothing in common between our two cases other than that both produce the same Oracle Error Code.

best suggestion would be to use a JDBC logger and log DML going in, then cut and paste into your SQL tool with oracle....999 times out 1000, your SQL tool will give you the same exact error. From there, you can debug the problem further most likely after you know why the SQL fails first.
later,
Dean