JPA (openjpa), DB2, update, commit = Invalid cursor name? -
trying perform simple update on object jpa (websphere-openjpa, db2):
public t update(t t) { synchronized(this) { this.em.gettransaction().begin(); t = this.em.merge(t); this.em.gettransaction().commit(); } return t; } but getting "invalid cursor name" sql exception during transaction commit. ideas means?
[3/07/12 12:17:27:586 est] 00000025 webapp e com.ibm.ws.webcontainer.webapp.webapp logservleterror srve0293e: [servlet error]-[jaxrsapplication]: <openjpa-2.1.2-snapshot-r422266:1179900 fatal store error> org.apache.openjpa.persistence.rollbackexception: transaction has been rolled back. see nested exceptions details on errors occurred. failedobject: prepstmnt 125018062 update cchdevt.tcc_property set comments = ?, last_updated = ? property_name = ? [org.apache.openjpa.jdbc.kernel.jdbcstoremanager$cancelpreparedstatement_] @ org.apache.openjpa.persistence.entitymanagerimpl.commit(entitymanagerimpl.java:593) @ com.qbe.config.dao.genericdaojpaimpl.update(genericdaojpaimpl.java:50) @ com.qbe.config.service.qbepropertyservice.saveproperty(qbepropertyservice.java:42) @ com.qbe.config.web.qbepropertyresource.save(qbepropertyresource.java:87) @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:60) @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:37) @ java.lang.reflect.method.invoke(method.java:611) @ com.sun.jersey.spi.container.javamethodinvokerfactory$1.invoke(javamethodinvokerfactory.java:60) @ com.sun.jersey.server.impl.model.method.dispatch.abstractresourcemethoddispatchprovider$voidoutinvoker._dispatch(abstractresourcemethoddispatchprovider.java:167) @ com.sun.jersey.server.impl.model.method.dispatch.resourcejavamethoddispatcher.dispatch(resourcejavamethoddispatcher.java:75) @ com.sun.jersey.server.impl.uri.rules.httpmethodrule.accept(httpmethodrule.java:288) @ com.sun.jersey.server.impl.uri.rules.righthandpathrule.accept(righthandpathrule.java:147) @ com.sun.jersey.server.impl.uri.rules.resourceclassrule.accept(resourceclassrule.java:108) @ com.sun.jersey.server.impl.uri.rules.righthandpathrule.accept(righthandpathrule.java:147) @ com.sun.jersey.server.impl.uri.rules.rootresourceclassesrule.accept(rootresourceclassesrule.java:84) @ com.sun.jersey.server.impl.application.webapplicationimpl._handlerequest(webapplicationimpl.java:1483) @ com.sun.jersey.server.impl.application.webapplicationimpl._handlerequest(webapplicationimpl.java:1414) @ com.sun.jersey.server.impl.application.webapplicationimpl.handlerequest(webapplicationimpl.java:1363) @ com.sun.jersey.server.impl.application.webapplicationimpl.handlerequest(webapplicationimpl.java:1353) @ com.sun.jersey.spi.container.servlet.webcomponent.service(webcomponent.java:414) @ com.sun.jersey.spi.container.servlet.servletcontainer.service(servletcontainer.java:537) @ com.sun.jersey.spi.container.servlet.servletcontainer.service(servletcontainer.java:708) @ javax.servlet.http.httpservlet.service(httpservlet.java:668) @ com.ibm.ws.webcontainer.servlet.servletwrapper.service(servletwrapper.java:1188) @ com.ibm.ws.webcontainer.servlet.servletwrapper.handlerequest(servletwrapper.java:763) @ com.ibm.ws.webcontainer.servlet.servletwrapper.handlerequest(servletwrapper.java:454) @ com.ibm.ws.webcontainer.servlet.servletwrapperimpl.handlerequest(servletwrapperimpl.java:178) @ com.ibm.ws.webcontainer.filter.webappfiltermanager.invokefilters(webappfiltermanager.java:1020) @ com.ibm.ws.webcontainer.webapp.webapp.handlerequest(webapp.java:3703) @ com.ibm.ws.webcontainer.webapp.webgroup.handlerequest(webgroup.java:304) @ com.ibm.ws.webcontainer.webcontainer.handlerequest(webcontainer.java:962) @ com.ibm.ws.webcontainer.wswebcontainer.handlerequest(wswebcontainer.java:1662) @ com.ibm.ws.webcontainer.channel.wcchannellink.ready(wcchannellink.java:195) @ com.ibm.ws.http.channel.inbound.impl.httpinboundlink.handlediscrimination(httpinboundlink.java:452) @ com.ibm.ws.http.channel.inbound.impl.httpinboundlink.handlenewrequest(httpinboundlink.java:511) @ com.ibm.ws.http.channel.inbound.impl.httpinboundlink.processrequest(httpinboundlink.java:305) @ com.ibm.ws.http.channel.inbound.impl.httpiclreadcallback.complete(httpiclreadcallback.java:83) @ com.ibm.ws.tcp.channel.impl.aioreadcompletionlistener.futurecompleted(aioreadcompletionlistener.java:165) @ com.ibm.io.async.abstractasyncfuture.invokecallback(abstractasyncfuture.java:217) @ com.ibm.io.async.asyncchannelfuture.firecompletionactions(asyncchannelfuture.java:161) @ com.ibm.io.async.asyncfuture.completed(asyncfuture.java:138) @ com.ibm.io.async.resulthandler.complete(resulthandler.java:204) @ com.ibm.io.async.resulthandler.runeventprocessingloop(resulthandler.java:775) @ com.ibm.io.async.resulthandler$2.run(resulthandler.java:905) @ com.ibm.ws.util.threadpool$worker.run(threadpool.java:1659) breaking up...
caused by: <openjpa-2.1.2-snapshot-r422266:1179900 fatal general error> org.apache.openjpa.persistence.persistenceexception: transaction has been rolled back. see nested exceptions details on errors occurred. failedobject: prepstmnt 125018062 update cchdevt.tcc_property set comments = ?, last_updated = ? property_name = ? [org.apache.openjpa.jdbc.kernel.jdbcstoremanager$cancelpreparedstatement_] @ org.apache.openjpa.kernel.brokerimpl.newflushexception(brokerimpl.java:2321) @ org.apache.openjpa.kernel.brokerimpl.flush(brokerimpl.java:2158) @ org.apache.openjpa.kernel.brokerimpl.flushsafe(brokerimpl.java:2056) @ org.apache.openjpa.kernel.brokerimpl.beforecompletion(brokerimpl.java:1974) @ org.apache.openjpa.kernel.localmanagedruntime.commit(localmanagedruntime.java:81) @ org.apache.openjpa.kernel.brokerimpl.commit(brokerimpl.java:1498) @ org.apache.openjpa.kernel.delegatingbroker.commit(delegatingbroker.java:933) @ org.apache.openjpa.persistence.entitymanagerimpl.commit(entitymanagerimpl.java:569) ... 45 more breaking up...
caused by: <openjpa-2.1.2-snapshot-r422266:1179900 fatal general error> org.apache.openjpa.persistence.persistenceexception: invalid cursor name. failedobject: prepstmnt 125018062 update cchdevt.tcc_property set comments = ?, last_updated = ? property_name = ? [org.apache.openjpa.jdbc.kernel.jdbcstoremanager$cancelpreparedstatement_] @ org.apache.openjpa.jdbc.sql.dbdictionary.narrow(dbdictionary.java:4878) @ org.apache.openjpa.jdbc.sql.dbdictionary.newstoreexception(dbdictionary.java:4838) @ org.apache.openjpa.jdbc.sql.db2dictionary.newstoreexception(db2dictionary.java:596) @ org.apache.openjpa.jdbc.sql.sqlexceptions.getstore(sqlexceptions.java:136) @ org.apache.openjpa.jdbc.sql.sqlexceptions.getstore(sqlexceptions.java:78) @ org.apache.openjpa.jdbc.kernel.batchingpreparedstatementmanagerimpl.flushbatch(batchingpreparedstatementmanagerimpl.java:236) @ org.apache.openjpa.jdbc.kernel.batchingconstraintupdatemanager.flush(batchingconstraintupdatemanager.java:63) @ org.apache.openjpa.jdbc.kernel.abstractupdatemanager.flush(abstractupdatemanager.java:103) @ org.apache.openjpa.jdbc.kernel.abstractupdatemanager.flush(abstractupdatemanager.java:76) @ org.apache.openjpa.jdbc.kernel.jdbcstoremanager.flush(jdbcstoremanager.java:742) @ org.apache.openjpa.kernel.delegatingstoremanager.flush(delegatingstoremanager.java:131) ... 52 more breaking up...
caused by: com.ibm.db2.jcc.a.sqlexception: invalid cursor name. @ com.ibm.db2.jcc.a.zc.setcursorname(zc.java:723) @ com.ibm.websphere.rsadapter.db2universaldatastorehelper.dostatementcleanup(db2universaldatastorehelper.java:243) @ com.ibm.ws.rsadapter.jdbc.wsjdbcpreparedstatement.closewrapper(wsjdbcpreparedstatement.java:490) @ com.ibm.ws.rsadapter.jdbc.wsjccpreparedstatement.closewrapper(wsjccpreparedstatement.java:294) @ com.ibm.ws.rsadapter.jdbc.wsjdbcobject.close(wsjdbcobject.java:240) @ com.ibm.ws.rsadapter.jdbc.wsjdbcobject.close(wsjdbcobject.java:193) @ org.apache.openjpa.lib.jdbc.delegatingpreparedstatement.close(delegatingpreparedstatement.java:161) @ org.apache.openjpa.lib.jdbc.delegatingpreparedstatement.close(delegatingpreparedstatement.java:161) @ org.apache.openjpa.jdbc.kernel.batchingpreparedstatementmanagerimpl.flushbatch(batchingpreparedstatementmanagerimpl.java:234) ... 57 more
Comments
Post a Comment