O
Oskar
Hi,
At this moment I'm having a problem updating the database using an
entity bean.
the column to update is a clob.
when i do an update using a small amount of data it goes perfect..
but when i do an update with a large ammount of data i get the
following exception:
the second exception : "Gegevensgrootte overschrijdt maximumgrootte
voor dit type.: 14056"
tells that the datasize exceeds the maximum size for this type...
but it's a clob ?!?!?!?!?!?
We're using WAS 5.2. and oracle 8.?
anyone an idea?
thanks
Oskar
[16-5-06 11:19:31:281 CEST] 21950fc6 DataAccessReq E PMGR0000E: Call
stack:
com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException:
PMGR6022E: Error using adapter to create or execute an Interaction.
com.ibm.ws.rsadapter.cci.WSInteractionImpl@7ada8fd0
at
com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(Unknown
Source)
at
com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.executeStore(Unknown
Source)
at
com.ibm.ws.ejbpersistence.beanextensions.CBReadyState.ejbStore(Unknown
Source)
at
com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.ejbStore(Unknown
Source)
at
com.aon.av.ejb.ConcreteAVMail_92fe8987.ejbStore(ConcreteAVMail_92fe8987.java:58)
at
com.ibm.ejs.container.ContainerManaged2_0BeanO.store(ContainerManaged2_0BeanO.java:254)
at
com.ibm.ejs.container.EntityBeanO.beforeCompletion(EntityBeanO.java:1062)
at
com.ibm.ejs.container.ContainerTx.beforeCompletion(ContainerTx.java:542)
at
com.ibm.ejs.util.tran.SyncDriver.beforeCompletion(SyncDriver.java:279)
at
com.ibm.ws.Transaction.JTA.RegisteredSyncs.distributeBefore(RegisteredSyncs.java:110)
at
com.ibm.ws.Transaction.JTA.TransactionImpl.internalPrepare(TransactionImpl.java:1211)
at
com.ibm.ws.Transaction.JTA.TransactionImpl.commit(TransactionImpl.java:960)
at
com.ibm.ws.Transaction.JTA.TranManagerImpl.commit(TranManagerImpl.java:150)
at
com.ibm.ws.Transaction.JTA.TranManagerSet.commit(TranManagerSet.java:182)
at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.java:712)
at
com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java:167)
at
com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.java:565)
at
com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java(Compiled
Code))
at
com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:2916)
at
com.aon.av.ejb.EJSRemoteStatelessMailBeheerder_5f2ca6da.saveMail(EJSRemoteStatelessMailBeheerder_5f2ca6da.java:117)
at
com.aon.av.ejb._MailBeheerder_Stub.saveMail(_MailBeheerder_Stub.java:405)
at
com.aon.av.actions.GetMailAction.saveMail(GetMailAction.java:143)
at
com.aon.av.actions.GetMailAction.execute(GetMailAction.java:46)
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.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at
com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at
com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
at
com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at
com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:76)
at
com.aon.av.utils.SessionFilter.doFilter(SessionFilter.java:82)
at
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:132)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:71)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:974)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:564)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200)
at
com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119)
at
com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276)
at
com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at
com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:116)
at
com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:186)
at
com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
at
com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672)
Caused by: java.sql.SQLException: Gegevensgrootte overschrijdt
maximumgrootte voor dit type.: 14056
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:95)
at
oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.java:2445)
at
oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStatement.java:1170)
at
oracle.jdbc.driver.OraclePreparedStatement.setCharacterStream(OraclePreparedStatement.java:3756)
at
com.aon.av.ejb.websphere_deploy.ORACLE_V8_1.AVMailBeanFunctionSet_92fe8987.Store(AVMailBeanFunctionSet_92fe8987.java:244)
at
com.aon.av.ejb.websphere_deploy.ORACLE_V8_1.AVMailBeanFunctionSet_92fe8987.execute(AVMailBeanFunctionSet_92fe8987.java:645)
at
com.ibm.ws.rsadapter.cci.WSInteractionImpl.execute(WSInteractionImpl.java:417)
at
com.ibm.wsspi.ejbpersistence.WSEJBToRAAdapter.executeUpdate(WSEJBToRAAdapter.java:242)
at
com.ibm.ws.rsadapter.cci.WSRelationalRAAdapter.executeUpdate(WSRelationalRAAdapter.java:301)
... 53 more
---- Begin backtrace for nested exception
java.sql.SQLException: Gegevensgrootte overschrijdt maximumgrootte voor
dit type.: 14056
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:95)
at
oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.java:2445)
at
oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStatement.java:1170)
at
oracle.jdbc.driver.OraclePreparedStatement.setCharacterStream(OraclePreparedStatement.java:3756)
at
com.aon.av.ejb.websphere_deploy.ORACLE_V8_1.AVMailBeanFunctionSet_92fe8987.Store(AVMailBeanFunctionSet_92fe8987.java:244)
at
com.aon.av.ejb.websphere_deploy.ORACLE_V8_1.AVMailBeanFunctionSet_92fe8987.execute(AVMailBeanFunctionSet_92fe8987.java:645)
At this moment I'm having a problem updating the database using an
entity bean.
the column to update is a clob.
when i do an update using a small amount of data it goes perfect..
but when i do an update with a large ammount of data i get the
following exception:
the second exception : "Gegevensgrootte overschrijdt maximumgrootte
voor dit type.: 14056"
tells that the datasize exceeds the maximum size for this type...
but it's a clob ?!?!?!?!?!?
We're using WAS 5.2. and oracle 8.?
anyone an idea?
thanks
Oskar
[16-5-06 11:19:31:281 CEST] 21950fc6 DataAccessReq E PMGR0000E: Call
stack:
com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException:
PMGR6022E: Error using adapter to create or execute an Interaction.
com.ibm.ws.rsadapter.cci.WSInteractionImpl@7ada8fd0
at
com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(Unknown
Source)
at
com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.executeStore(Unknown
Source)
at
com.ibm.ws.ejbpersistence.beanextensions.CBReadyState.ejbStore(Unknown
Source)
at
com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.ejbStore(Unknown
Source)
at
com.aon.av.ejb.ConcreteAVMail_92fe8987.ejbStore(ConcreteAVMail_92fe8987.java:58)
at
com.ibm.ejs.container.ContainerManaged2_0BeanO.store(ContainerManaged2_0BeanO.java:254)
at
com.ibm.ejs.container.EntityBeanO.beforeCompletion(EntityBeanO.java:1062)
at
com.ibm.ejs.container.ContainerTx.beforeCompletion(ContainerTx.java:542)
at
com.ibm.ejs.util.tran.SyncDriver.beforeCompletion(SyncDriver.java:279)
at
com.ibm.ws.Transaction.JTA.RegisteredSyncs.distributeBefore(RegisteredSyncs.java:110)
at
com.ibm.ws.Transaction.JTA.TransactionImpl.internalPrepare(TransactionImpl.java:1211)
at
com.ibm.ws.Transaction.JTA.TransactionImpl.commit(TransactionImpl.java:960)
at
com.ibm.ws.Transaction.JTA.TranManagerImpl.commit(TranManagerImpl.java:150)
at
com.ibm.ws.Transaction.JTA.TranManagerSet.commit(TranManagerSet.java:182)
at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.java:712)
at
com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java:167)
at
com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.java:565)
at
com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java(Compiled
Code))
at
com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:2916)
at
com.aon.av.ejb.EJSRemoteStatelessMailBeheerder_5f2ca6da.saveMail(EJSRemoteStatelessMailBeheerder_5f2ca6da.java:117)
at
com.aon.av.ejb._MailBeheerder_Stub.saveMail(_MailBeheerder_Stub.java:405)
at
com.aon.av.actions.GetMailAction.saveMail(GetMailAction.java:143)
at
com.aon.av.actions.GetMailAction.execute(GetMailAction.java:46)
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.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at
com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at
com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
at
com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at
com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:76)
at
com.aon.av.utils.SessionFilter.doFilter(SessionFilter.java:82)
at
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:132)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:71)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:974)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:564)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200)
at
com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119)
at
com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276)
at
com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at
com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:116)
at
com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:186)
at
com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
at
com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672)
Caused by: java.sql.SQLException: Gegevensgrootte overschrijdt
maximumgrootte voor dit type.: 14056
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:95)
at
oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.java:2445)
at
oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStatement.java:1170)
at
oracle.jdbc.driver.OraclePreparedStatement.setCharacterStream(OraclePreparedStatement.java:3756)
at
com.aon.av.ejb.websphere_deploy.ORACLE_V8_1.AVMailBeanFunctionSet_92fe8987.Store(AVMailBeanFunctionSet_92fe8987.java:244)
at
com.aon.av.ejb.websphere_deploy.ORACLE_V8_1.AVMailBeanFunctionSet_92fe8987.execute(AVMailBeanFunctionSet_92fe8987.java:645)
at
com.ibm.ws.rsadapter.cci.WSInteractionImpl.execute(WSInteractionImpl.java:417)
at
com.ibm.wsspi.ejbpersistence.WSEJBToRAAdapter.executeUpdate(WSEJBToRAAdapter.java:242)
at
com.ibm.ws.rsadapter.cci.WSRelationalRAAdapter.executeUpdate(WSRelationalRAAdapter.java:301)
... 53 more
---- Begin backtrace for nested exception
java.sql.SQLException: Gegevensgrootte overschrijdt maximumgrootte voor
dit type.: 14056
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:95)
at
oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.java:2445)
at
oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStatement.java:1170)
at
oracle.jdbc.driver.OraclePreparedStatement.setCharacterStream(OraclePreparedStatement.java:3756)
at
com.aon.av.ejb.websphere_deploy.ORACLE_V8_1.AVMailBeanFunctionSet_92fe8987.Store(AVMailBeanFunctionSet_92fe8987.java:244)
at
com.aon.av.ejb.websphere_deploy.ORACLE_V8_1.AVMailBeanFunctionSet_92fe8987.execute(AVMailBeanFunctionSet_92fe8987.java:645)