Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

com.ibm.websphere.ce.cm.Stale Connection Exception

 
aa zz
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
WebSphere Platform 6.0 [ND 6.0.2.15 cf150636.04]
Java version = J2RE 1.4.2 IBM AIX 5L for PowerPC
Hibernate 3.1

I am using websphere connection pooling. Here is the error message I see intermittently

[2/4/07 8:55:26:167 EST] 00000063 SystemOut O Hibernate: select SEQ_TXLIFE.nextval from dual
[2/4/07 8:55:26:201 EST] 00000063 ConnectionEve A J2CA0056I: The Connection Manager received a fatal connection error from the Resource Adaptor for resource jdbc/acord. The exception which was received is com.ibm.websphere.ce.cm.StaleConnectionException: Io exception: Connection reset
[2/4/07 8:55:26:220 EST] 00000063 JDBCException W org.hibernate.util.JDBCExceptionReporter logExceptions SQL Error: 17002, SQLState: null
[2/4/07 8:55:26:232 EST] 00000063 JDBCException E org.hibernate.util.JDBCExceptionReporter logExceptions Io exception: Connection reset
[2/4/07 8:55:26:244 EST] 00000063 JDBCException W org.hibernate.util.JDBCExceptionReporter logExceptions SQL Error: 17002, SQLState: null
[2/4/07 8:55:26:274 EST] 00000063 JDBCException E org.hibernate.util.JDBCExceptionReporter logExceptions Io exception: Connection reset
[2/4/07 8:55:26:288 EST] 00000063 SystemOut O 02/04/2007 08:55:26 ERROR com.conseco.hibernate.manager.HibernateDBManager - HibernateDBManager:save() - HibernateException could not get next sequence value could not get next sequence value - 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:91)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java(Compiled Code))
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java(Compiled Code))
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:530)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:518)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:514)


I have Pretest connection check marked in admin console for WAS 6.0.2

Any ideas, clues ?

Thanks in advance !
[ February 05, 2007: Message edited by: Bear Bibeault ]
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 65335
97
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"aa zz",

There aren't many rules that you need to worry about here on the Ranch, but one that we take very seriously regards the use of proper names. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Thanks!
bear
JavaRanch Sheriff
 
Chuck Emmons
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm having the same issue in a Websphere 6.0 environment using Hibernate 3.2.

Any help would be really appreciated.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic