| Problem with Oracle 9.2.0.5.0 Hibernate 3.2.0 [message #267434] |
Thu, 13 September 2007 05:03  |
sri_amar
Messages: 2
Registered: September 2007
|
Junior Member |
|
|
Hi All,
I am facing a stange problem in my live environment all of a sudden . I am using the below version of softwares
ORACLE 9.2.0.5.0
Hibernate 3.2.0
JDK 1.5
Driver - ojdbc14.jar version 10.2.0.2.0
my application is throwing the below exceptions.
org.hibernate.exception.GenericJDBCException: could not get next sequence value
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:96)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:98)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventLi
stener.java:186)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:1
75)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
at sun.reflect.GeneratedMethodAccessor24.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.orm.hibernate3.HibernateTemplate$CloseSuppressingInvocationHandler.invoke(HibernateTemplate.ja
va:1192)
at $Proxy1.save(Unknown Source)
at boboco.rtm.sdf.db.dao.hibernate.IntervalDaoImpl$3.doInHibernate(IntervalDaoImpl.java:258)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:362)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:328)
at boboco.rtm.sdf.db.dao.hibernate.IntervalDaoImpl.createInterval(IntervalDaoImpl.java:226)
at boboco.rtm.sdf.acrm.processor.DatabaseUpdateProcessor.processPending(DatabaseUpdateProcessor.java:302)
at boboco.rtm.sdf.acrm.processor.DatabaseUpdateProcessor.access$000(DatabaseUpdateProcessor.java:34)
at boboco.rtm.sdf.acrm.processor.DatabaseUpdateProcessor$1.doInTransaction(DatabaseUpdateProcessor.java:260)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:134)
at boboco.rtm.sdf.acrm.processor.DatabaseUpdateProcessor.processPendingTx(DatabaseUpdateProcessor.java:256)
at boboco.rtm.sdf.acrm.processor.DatabaseUpdateProcessor.run(DatabaseUpdateProcessor.java:166)
Caused by: java.sql.SQLException: OALL8 is in an inconsistent state
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
java.sql.SQLException: Protocol violation
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.T4C7Ocommoncall.receive(T4C7Ocommoncall.java:150)
at oracle.jdbc.driver.T4CConnection.doRollback(T4CConnection.java:567)
at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1145)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:288)
at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:577)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransac
tionManager.java:631)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionMan
ager.java:608)
at org.springframework.transaction.support.TransactionTemplate.rollbackOnException(TransactionTemplate.java:160)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:138)
at boboco.rtm.sdf.acrm.processor.DatabaseUpdateProcessor.processPendingTx(DatabaseUpdateProcessor.java:256)
at boboco.rtm.sdf.acrm.processor.DatabaseUpdateProcessor.run(DatabaseUpdateProcessor.java:166)
can anyone please help me ASAP.
Regards
Srinivas.
|
|
|
|
|
|
| Re: Problem with Oracle 9.2.0.5.0 Hibernate 3.2.0 [message #267448 is a reply to message #267434] |
Thu, 13 September 2007 05:23  |
sri_amar
Messages: 2
Registered: September 2007
|
Junior Member |
|
|
Hi
The below is my hbm.xml file
<id
name="intervalId"
column="intervalId"
type="long"
unsaved-value="0"
>
<generator class="native">
<!--
To add non XDoclet generator parameters, create a file named
hibernate-generator-params-Interval.xml
containing the additional parameters and place it in your merge dir.
-->
</generator>
</id>
it have a underlying database squuence and its max values is 9999999999999999999999. and the application was working fine fro many days. all of a sudden it started throwing the exceptions.
Regards
Srinivas
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
