wood burning stoves
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


Win a copy of Building Microservices this week in the Design forum!
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
 
Have you checked out Aspose?
 
subject: Autoincrement field in cloudscape
 
jQuery in Action, 3rd edition