• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Devaka Cooray
  • Ron McLeod
  • Jeanne Boyarsky
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Carey Brown
  • Tim Holloway
Bartenders:
  • Martijn Verburg
  • Frits Walraven
  • Himai Minh

Autoincrement field in cloudscape

 
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
catch it before it slithers away! Oh wait, it's a tiny ad:
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic