aspose file tools*
The moose likes Websphere and the fly likes Autoincrement field in cloudscape Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
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
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
 
Consider Paul's rocket mass heater.
 
subject: Autoincrement field in cloudscape