aspose file tools
The moose likes Websphere and the fly likes Autoincrement field in cloudscape Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Products » Websphere
Reply Bookmark "Autoincrement field in cloudscape" Watch "Autoincrement field in cloudscape" New topic
Author

Autoincrement field in cloudscape

basudev kar
Greenhorn

Joined: Apr 22, 2005
Posts: 13
posted private message
0
Quote
Hi all,
I am getting problem while inserting datas through CMP bean into database because in the table there is one autoincrement column.I am declared that field as auto increment in the cloudscape database.but its throughing error in the ejbCreate() method. below i am given some errors


[5/17/05 16:08:25:406 GMT+05:30] 18efcc3c DataAccessReq E PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@ae90c35
[5/17/05 16:08:25:500 GMT+05:30] 18efcc3c 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@ae90c35
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(DataAccessRequestImpl.java:127)
at com.ibm.ws.ejbpersistence.beanextensions.CBStatefulPersistor.executeCreate(CBStatefulPersistor.java:229)
at com.ibm.ws.ejbpersistence.beanextensions.CBNotExistState.ejbCreate(CBNotExistState.java:38)
at com.ibm.ws.ejbpersistence.beanextensions.CBStatefulPersistor.ejbPostCreate(CBStatefulPersistor.java:94)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.ejbPostCreate(ConcreteBeanStatefulInstanceExtensionImpl.java:133)
at com.realsoftinc.vonc.emailchannelinfo.ConcreteEmailChannelInfo_6b701be9.ejbPostCreate(ConcreteEmailChannelInfo_6b701be9.java:289)
at com.realsoftinc.vonc.emailchannelinfo.EJSCMPEmailChannelInfoHomeBean_6b701be9.create_Local(EJSCMPEmailChannelInfoHomeBean_6b701be9.java:86)
at com.realsoftinc.vonc.emailchannelinfo.EJSLocalCMPEmailChannelInfoHome_6b701be9.create(EJSLocalCMPEmailChannelInfoHome_6b701be9.java:59)
at com.realsoftinc.vonc.channelmanager.ChannelManagerBean.addChannel(ChannelManagerBean.java:120)
at com.realsoftinc.vonc.channelmanager.EJSRemoteStatelessChannelManager_96adacf7.addChannel(EJSRemoteStatelessChannelManager_96adacf7.java:178)
at com.realsoftinc.vonc.channelmanager._ChannelManager_Stub.addChannel(_ChannelManager_Stub.java:381)
at com.realsoftinc.vonc.controller.ServiceController.createChannel(ServiceController.java:1596)
at com.realsoftinc.vonc.controller.ServiceController.doPost(ServiceController.java:147)
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:258)
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.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:872)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:491)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:173)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:199)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:114)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:187)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:331)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:432)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:343)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:592)
---- Begin backtrace for nested exception
ERROR 42Z23: Attempt to modify an autoincrement column 'CHANNELID'.
at db2j.bq.b.newException(Unknown Source)
at db2j.b.co.rs_(Unknown Source)
at db2j.b.bf.ha_(Unknown Source)
at db2j.ac.m._o68(Unknown Source)
at db2j.ac.m.prepare(Unknown Source)
at db2j.r.k.<init>(Unknown Source)
at db2j.h.f.<init>(Unknown Source)
at db2j.h.c.newLocalPreparedStatement(Unknown Source)
at db2j.r.c.prepareStatement(Unknown Source)
at db2j.h.c.prepareStatement(Unknown Source)
at com.ibm.db2j.core.BaseConnectionHandle.prepareStatement(Unknown Source)
at com.ibm.ws.rsadapter.cci.WSResourceAdapterBase.prepareStatement(WSResourceAdapterBase.java:143)
at com.realsoftinc.vonc.emailchannelinfo.websphere_deploy.CLOUDSCAPE_V50_1.EmailChannelInfoBeanFunctionSet_6b701be9.Create(EmailChannelInfoBeanFunctionSet_6b701be9.java:35)
at com.realsoftinc.vonc.emailchannelinfo.websphere_deploy.CLOUDSCAPE_V50_1.EmailChannelInfoBeanFunctionSet_6b701be9.execute(EmailChannelInfoBeanFunctionSet_6b701be9.java:748)
at com.ibm.ws.rsadapter.cci.WSInteractionImpl.execute(WSInteractionImpl.java:156)
at com.ibm.ws.rsadapter.cci.WSRelationalRAAdapter.executeCreate(WSRelationalRAAdapter.java:179)
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(DataAccessRequestImpl.java:86)
at com.ibm.ws.ejbpersistence.beanextensions.CBStatefulPersistor.executeCreate(CBStatefulPersistor.java:229)
at com.ibm.ws.ejbpersistence.beanextensions.CBNotExistState.ejbCreate(CBNotExistState.java:38)
at com.ibm.ws.ejbpersistence.beanextensions.CBStatefulPersistor.ejbPostCreate(CBStatefulPersistor.java:94)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.ejbPostCreate(ConcreteBeanStatefulInstanceExtensionImpl.java:133)
at com.realsoftinc.vonc.emailchannelinfo.ConcreteEmailChannelInfo_6b701be9.ejbPostCreate(ConcreteEmailChannelInfo_6b701be9.java:289)
at com.realsoftinc.vonc.emailchannelinfo.EJSCMPEmailChannelInfoHomeBean_6b701be9.create_Local(EJSCMPEmailChannelInfoHomeBean_6b701be9.java:86)
at com.realsoftinc.vonc.emailchannelinfo.EJSLocalCMPEmailChannelInfoHome_6b701be9.create(EJSLocalCMPEmailChannelInfoHome_6b701be9.java:59)
at com.realsoftinc.vonc.channelmanager.ChannelManagerBean.addChannel(ChannelManagerBean.java:120)
at com.realsoftinc.vonc.channelmanager.EJSRemoteStatelessChannelManager_96adacf7.addChannel(EJSRemoteStatelessChannelManager_96adacf7.java:178)
at com.realsoftinc.vonc.channelmanager._ChannelManager_Stub.addChannel(_ChannelManager_Stub.java:381)
at com.realsoftinc.vonc.controller.ServiceController.createChannel(ServiceController.java:1596)
at com.realsoftinc.vonc.controller.ServiceController.doPost(ServiceController.java:147)
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:258)
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.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:872)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:491)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:173)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:199)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:114)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:187)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:331)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:432)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:343)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:592)



thanks,
basudev
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Autoincrement field in cloudscape
 
Similar Threads
[Problem Solved!] Problem using CMP EJBs (Thanks in advance!)
PersistenceManagerException in ejbCreate
Please help with RolledbackLocalException
Error while calling EJBs
com.ibm.ws.rsadapter Exception