• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Autoincrement field in cloudscape

 
basudev kar
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic