Home » Developer & Programmer » JDeveloper, Java & XML » Problem with Oracle 9.2.0.5.0 Hibernate 3.2.0
Problem with Oracle 9.2.0.5.0 Hibernate 3.2.0 [message #267434] Thu, 13 September 2007 05:03 Go to next message
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 #267445 is a reply to message #267434] Thu, 13 September 2007 05:18 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
What does your hbm.xml look like?
Is the id column defined as filled by an Oracle sequence?
If so, what is that sequence like? Does it have a max-value?
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 Go to previous messageGo to next message
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
Re: Problem with Oracle 9.2.0.5.0 Hibernate 3.2.0 [message #281070 is a reply to message #267448] Thu, 15 November 2007 11:18 Go to previous message
kperche
Messages: 1
Registered: November 2007
Junior Member
Hi Srinivas,

I have exactly the same problem.
Did you solve it?

Thanks

Karine
Previous Topic: is there any difference between java and javascript ?
Next Topic: JavaMail inside Database
Goto Forum:
  


Current Time: Thu Dec 08 16:38:42 CST 2016

Total time taken to generate the page: 0.06238 seconds