ok, I patched the current ConnectionManagerImpl class. I already supposed a timeout problem, but to see the first exception message will make things clearer... thx.
Dirk -----Urspr�ngliche Nachricht----- Von: Armin Waibel [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 20. Januar 2004 18:08 An: OJB Users List Betreff: Re: exception: cannot request auto-commit state Hi Dirk, [EMAIL PROTECTED] wrote: > Hi, > > I am using PB with DB2 7. auto-commit is set off and also declared in > the jdbc-connection descriptor. When I try to store/retrieve a object > I get the message that ojb cannot request autoCommit state on the connection? > This happens after some time the app is running. any idea? > This exception was thrown by ConnectionManagerImpl class when try to read the autoCommit state of current used connection. If an SQLException was thrown while calling method con.getAutoCommit(), a PersistenceBrokerException was thrown. Unfortunately the first thrown SQLException was discard, so you don't see the real problem behind this (maybe a used connection will become timed out and DB doesn't support reconnect of timed out connections, ...) I checked in a fix in CVS HEAD. Now you will see the underlying SQLException in stack trace of PersistenceBrokerException. regards, Armin > thx, > Dirk > > > org.apache.ojb.broker.PersistenceBrokerException: org.apache.ojb.broker.PersistenceBrokerException: > Cannot request autoCommit state on the connection > at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source) > at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source) > at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow n Source) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionBy > Query(Unknown Sourc > e) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionBy > Query(Unknown Sourc > e) > at > de.premiere.plato.app.dao.ojb.OJBPBPersistenceManager.getLatestStoredO > bject(Unknown Sourc > e) > at > de.premiere.plato.app.navigation.control.NavigationHandlerAction.getLa > testStoredObject(Un > known Source) > at > de.premiere.plato.app.navigation.control.NavigationHandlerAction.compa > reTimestamps(Unknow > n Source) > at de.premiere.plato.app.navigation.control.NavigationHandlerAction.execute(Unk nown Source) > at > org.apache.struts.action.RequestProcessor.processActionPerform(Request > Processor.java:484) > > at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) > at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) > at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) > at > javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
