[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(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(Unknown Sourc e) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(Unknown Sourc e) at de.premiere.plato.app.dao.ojb.OJBPBPersistenceManager.getLatestStoredObject(Unknown Sourc e) at de.premiere.plato.app.navigation.control.NavigationHandlerAction.getLatestStoredObject(Un known Source) at de.premiere.plato.app.navigation.control.NavigationHandlerAction.compareTimestamps(Unknow n Source) at de.premiere.plato.app.navigation.control.NavigationHandlerAction.execute(Unknown Source) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.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]
