I'm experiencing strange behaviour with a CMP bean. My environment is WAS
5.1 running on Windows 2000, using DB2 on AS400 as the datasource. The bean
works correctly
when I call the finder methods but when trying to call the create method I
get the following stack trace. I'm using the JTOpen version 4.2, JT400.jar
for my connection. I found a post that mentioned using an XA datasource so
I
tried that and still didn't have any luck.
The only line in the stack trace that seems to have any value is this one:
java.sql.SQLException: [SQL7008] INP301 in FBPRODTA not valid for operation.
That seems to indicate a mapping error but my finder methods work correctly
so I think that should be fine. This has got me stumped, any help would be
appreciated.
The full stack trace is below, thanks for your help.
Rick
----------------------------------------------------------------------------
--------------------------
[4/3/04 21:07:22:018 MST] 5f305f3 DataAccessReq E PMGR6022E: Error using
adapter to create or execute an Interaction.
com.ibm.ws.rsadapter.cci.WSInteractionImpl@57b957b9
[4/3/04 21:07:22:038 MST] 5f305f3 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@57b957b9
at java.lang.Throwable.<init>(Throwable.java)
at java.lang.Throwable.<init>(Throwable.java)
at com.ibm.ws.exception.WsException.<init>(WsException.java:74)
at
com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException.<init>(Unknown
Source)
at
com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(Unknown
Source)
at
com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensi
onImpl.executeCreate(Unknown Source)
at
com.ibm.ws.ejbpersistence.beanextensions.CBNotExistState.ejbCreate(Unknown
Source)
at
com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensi
onImpl.ejbPostCreate(Unknown Source)
at
com.cf.etools.registration.ejb.CustomerMapping.ConcreteCustomerMapping_cd59d
9ad.ejbPostCreate(ConcreteCustomerMapping_cd59d9ad.java:137)
at
com.cf.etools.registration.ejb.CustomerMapping.EJSCMPCustomerMappingHomeBean
_cd59d9ad.create(EJSCMPCustomerMappingHomeBean_cd59d9ad.java:35)
at
com.cf.etools.registration.ejb.CustomerMapping.EJSRemoteCMPCustomerMappingHo
me_cd59d9ad.create(EJSRemoteCMPCustomerMappingHome_cd59d9ad.java:22)
at java.lang.reflect.AccessibleObject.invokeImpl(Native Method)
at java.lang.reflect.AccessibleObject.invokeL(AccessibleObject.java:207)
at java.lang.reflect.Method.invoke(Method.java)
at com.ibm.CORBA.iiop.ClientDelegate$3.run(ClientDelegate.java:1140)
at java.security.AccessController.doPrivileged(AccessController.java)
at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java:1138)
at $Proxy0.create(Unknown Source)
at
com.cf.etools.registration.ejb.CustomerMapping._CustomerMappingHome_Stub.cre
ate(_CustomerMappingHome_Stub.java:236)
at java.lang.reflect.AccessibleObject.invokeImpl(Native Method)
at java.lang.reflect.AccessibleObject.invokeL(AccessibleObject.java:207)
at java.lang.reflect.Method.invoke(Method.java)
at
com.ibm.etools.utc.model.ReflectionMethodModel.invoke(ReflectionMethodModel.
java:68)
at com.ibm.etools.utc.servlet.InvokeServlet.invoke(InvokeServlet.java:110)
at com.ibm.etools.utc.servlet.InvokeServlet.doPost(InvokeServlet.java:352)
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(StrictServle
tInstance.java:110)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecy
cleServlet.java:174)
at
com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServ
let.java:313)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecyc
leServlet.java:116)
at
com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java
:283)
at
com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidSer
vletReferenceState.java:42)
at
com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletIns
tanceReference.java:40)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(
WebAppRequestDispatcher.java:972)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppReques
tDispatcher.java)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequest
Dispatcher.java:198)
at
com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79)
at
com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker
.java:201)
at
com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(C
achedInvocation.java:71)
at
com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(C
acheableInvocationContext.java:114)
at
com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletReq
uestProcessor.java:186)
at
com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListene
r.java:334)
at
com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.jav
a:56)
at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:610)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java)
---- Begin backtrace for nested exception
java.sql.SQLException: [SQL7008] INP301 in FBPRODTA not valid for operation.
at java.lang.Throwable.<init>(Throwable.java)
at java.lang.Throwable.<init>(Throwable.java)
at java.sql.SQLException.<init>(SQLException.java:51)
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:532)
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:503)
at
com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.jav
a:709)
at
com.ibm.as400.access.AS400JDBCPreparedStatement.executeUpdate(AS400JDBCPrepa
redStatement.java:1107)
at
com.cf.etools.registration.ejb.CustomerMapping.websphere_deploy.DB2UDBAS400_
V5_1.CustomerMappingBeanFunctionSet_cd59d9ad.Create(CustomerMappingBeanFunct
ionSet_cd59d9ad.java:44)
at
com.cf.etools.registration.ejb.CustomerMapping.websphere_deploy.DB2UDBAS400_
V5_1.CustomerMappingBeanFunctionSet_cd59d9ad.execute(CustomerMappingBeanFunc
tionSet_cd59d9ad.java:281)
at
com.ibm.ws.rsadapter.cci.WSInteractionImpl.execute(WSInteractionImpl.java:34
7)
at
com.ibm.ws.rsadapter.cci.WSRelationalRAAdapter.executeCreate(WSRelationalRAA
dapter.java:187)
at
com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(Unknown
Source)
at
com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensi
onImpl.executeCreate(Unknown Source)
at
com.ibm.ws.ejbpersistence.beanextensions.CBNotExistState.ejbCreate(Unknown
Source)
at
com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensi
onImpl.ejbPostCreate(Unknown Source)
at
com.cf.etools.registration.ejb.CustomerMapping.ConcreteCustomerMapping_cd59d
9ad.ejbPostCreate(ConcreteCustomerMapping_cd59d9ad.java:137)
at
com.cf.etools.registration.ejb.CustomerMapping.EJSCMPCustomerMappingHomeBean
_cd59d9ad.create(EJSCMPCustomerMappingHomeBean_cd59d9ad.java:35)
at
com.cf.etools.registration.ejb.CustomerMapping.EJSRemoteCMPCustomerMappingHo
me_cd59d9ad.create(EJSRemoteCMPCustomerMappingHome_cd59d9ad.java:22)
at java.lang.reflect.AccessibleObject.invokeImpl(Native Method)
at java.lang.reflect.AccessibleObject.invokeL(AccessibleObject.java:207)
at java.lang.reflect.Method.invoke(Method.java)
at com.ibm.CORBA.iiop.ClientDelegate$3.run(ClientDelegate.java:1140)
at java.security.AccessController.doPrivileged(AccessController.java)
at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java:1138)
at $Proxy0.create(Unknown Source)
at
com.cf.etools.registration.ejb.CustomerMapping._CustomerMappingHome_Stub.cre
ate(_CustomerMappingHome_Stub.java:236)
at java.lang.reflect.AccessibleObject.invokeImpl(Native Method)
at java.lang.reflect.AccessibleObject.invokeL(AccessibleObject.java:207)
at java.lang.reflect.Method.invoke(Method.java)
at
com.ibm.etools.utc.model.ReflectionMethodModel.invoke(ReflectionMethodModel.
java:68)
at com.ibm.etools.utc.servlet.InvokeServlet.invoke(InvokeServlet.java:110)
at com.ibm.etools.utc.servlet.InvokeServlet.doPost(InvokeServlet.java:352)
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(StrictServle
tInstance.java:110)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecy
cleServlet.java:174)
at
com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServ
let.java:313)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecyc
leServlet.java:116)
at
com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java
:283)
at
com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidSer
vletReferenceState.java:42)
at
com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletIns
tanceReference.java:40)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(
WebAppRequestDispatcher.java:972)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppReques
tDispatcher.java)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequest
Dispatcher.java:198)
at
com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79)
at
com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker
.java:201)
at
com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(C
achedInvocation.java:71)
at
com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(C
acheableInvocationContext.java:114)
at
com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletReq
uestProcessor.java:186)
at
com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListene
r.java:334)
at
com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.jav
a:56)
at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:610)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java)
[4/3/04 21:07:22:148 MST] 5f305f3 ExceptionUtil E CNTR0019E: Non-application
exception occurred while processing method "create". Exception data:
com.ibm.ejs.container.CreateFailureException: ; nested exception is:
javax.ejb.EJBException: nested exception is:
com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E:
Error using adapter to create or execute an Interaction.
com.ibm.ws.rsadapter.cci.WSInteractionImpl@57b957b9
javax.ejb.EJBException: nested exception is:
com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E:
Error using adapter to create or execute an Interaction.
com.ibm.ws.rsadapter.cci.WSInteractionImpl@57b957b9
com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E:
Error using adapter to create or execute an Interaction.
com.ibm.ws.rsadapter.cci.WSInteractionImpl@57b957b9
at java.lang.Throwable.<init>(Throwable.java)
at java.lang.Throwable.<init>(Throwable.java)
at com.ibm.ws.exception.WsException.<init>(WsException.java:74)
at
com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException.<init>(Unknown
Source)
at
com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(Unknown
Source)
at
com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensi
onImpl.executeCreate(Unknown Source)
at
com.ibm.ws.ejbpersistence.beanextensions.CBNotExistState.ejbCreate(Unknown
Source)
at
com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensi
onImpl.ejbPostCreate(Unknown Source)
at
com.cf.etools.registration.ejb.CustomerMapping.ConcreteCustomerMapping_cd59d
9ad.ejbPostCreate(ConcreteCustomerMapping_cd59d9ad.java:137)
at
com.cf.etools.registration.ejb.CustomerMapping.EJSCMPCustomerMappingHomeBean
_cd59d9ad.create(EJSCMPCustomerMappingHomeBean_cd59d9ad.java:35)
at
com.cf.etools.registration.ejb.CustomerMapping.EJSRemoteCMPCustomerMappingHo
me_cd59d9ad.create(EJSRemoteCMPCustomerMappingHome_cd59d9ad.java:22)
at java.lang.reflect.AccessibleObject.invokeImpl(Native Method)
at java.lang.reflect.AccessibleObject.invokeL(AccessibleObject.java:207)
at java.lang.reflect.Method.invoke(Method.java)
at com.ibm.CORBA.iiop.ClientDelegate$3.run(ClientDelegate.java:1140)
at java.security.AccessController.doPrivileged(AccessController.java)
at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java:1138)
at $Proxy0.create(Unknown Source)
at
com.cf.etools.registration.ejb.CustomerMapping._CustomerMappingHome_Stub.cre
ate(_CustomerMappingHome_Stub.java:236)
at java.lang.reflect.AccessibleObject.invokeImpl(Native Method)
at java.lang.reflect.AccessibleObject.invokeL(AccessibleObject.java:207)
at java.lang.reflect.Method.invoke(Method.java)
at
com.ibm.etools.utc.model.ReflectionMethodModel.invoke(ReflectionMethodModel.
java:68)
at com.ibm.etools.utc.servlet.InvokeServlet.invoke(InvokeServlet.java:110)
at com.ibm.etools.utc.servlet.InvokeServlet.doPost(InvokeServlet.java:352)
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(StrictServle
tInstance.java:110)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecy
cleServlet.java:174)
at
com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServ
let.java:313)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecyc
leServlet.java:116)
at
com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java
:283)
at
com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidSer
vletReferenceState.java:42)
at
com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletIns
tanceReference.java:40)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(
WebAppRequestDispatcher.java:972)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppReques
tDispatcher.java)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequest
Dispatcher.java:198)
at
com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79)
at
com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker
.java:201)
at
com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(C
achedInvocation.java:71)
at
com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(C
acheableInvocationContext.java:114)
at
com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletReq
uestProcessor.java:186)
at
com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListene
r.java:334)
at
com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.jav
a:56)
at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:610)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java)
---- Begin backtrace for nested exception
java.sql.SQLException: [SQL7008] INP301 in FBPRODTA not valid for operation.
at java.lang.Throwable.<init>(Throwable.java)
at java.lang.Throwable.<init>(Throwable.java)
at java.sql.SQLException.<init>(SQLException.java:51)
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:532)
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:503)
at
com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.jav
a:709)
at
com.ibm.as400.access.AS400JDBCPreparedStatement.executeUpdate(AS400JDBCPrepa
redStatement.java:1107)
at
com.cf.etools.registration.ejb.CustomerMapping.websphere_deploy.DB2UDBAS400_
V5_1.CustomerMappingBeanFunctionSet_cd59d9ad.Create(CustomerMappingBeanFunct
ionSet_cd59d9ad.java:44)
at
com.cf.etools.registration.ejb.CustomerMapping.websphere_deploy.DB2UDBAS400_
V5_1.CustomerMappingBeanFunctionSet_cd59d9ad.execute(CustomerMappingBeanFunc
tionSet_cd59d9ad.java:281)
at
com.ibm.ws.rsadapter.cci.WSInteractionImpl.execute(WSInteractionImpl.java:34
7)
at
com.ibm.ws.rsadapter.cci.WSRelationalRAAdapter.executeCreate(WSRelationalRAA
dapter.java:187)
at
com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(Unknown
Source)
at
com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensi
onImpl.executeCreate(Unknown Source)
at
com.ibm.ws.ejbpersistence.beanextensions.CBNotExistState.ejbCreate(Unknown
Source)
at
com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensi
onImpl.ejbPostCreate(Unknown Source)
at
com.cf.etools.registration.ejb.CustomerMapping.ConcreteCustomerMapping_cd59d
9ad.ejbPostCreate(ConcreteCustomerMapping_cd59d9ad.java:137)
at
com.cf.etools.registration.ejb.CustomerMapping.EJSCMPCustomerMappingHomeBean
_cd59d9ad.create(EJSCMPCustomerMappingHomeBean_cd59d9ad.java:35)
at
com.cf.etools.registration.ejb.CustomerMapping.EJSRemoteCMPCustomerMappingHo
me_cd59d9ad.create(EJSRemoteCMPCustomerMappingHome_cd59d9ad.java:22)
at java.lang.reflect.AccessibleObject.invokeImpl(Native Method)
at java.lang.reflect.AccessibleObject.invokeL(AccessibleObject.java:207)
at java.lang.reflect.Method.invoke(Method.java)
at com.ibm.CORBA.iiop.ClientDelegate$3.run(ClientDelegate.java:1140)
at java.security.AccessController.doPrivileged(AccessController.java)
at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java:1138)
at $Proxy0.create(Unknown Source)
at
com.cf.etools.registration.ejb.CustomerMapping._CustomerMappingHome_Stub.cre
ate(_CustomerMappingHome_Stub.java:236)
at java.lang.reflect.AccessibleObject.invokeImpl(Native Method)
at java.lang.reflect.AccessibleObject.invokeL(AccessibleObject.java:207)
at java.lang.reflect.Method.invoke(Method.java)
at
com.ibm.etools.utc.model.ReflectionMethodModel.invoke(ReflectionMethodModel.
java:68)
at com.ibm.etools.utc.servlet.InvokeServlet.invoke(InvokeServlet.java:110)
at com.ibm.etools.utc.servlet.InvokeServlet.doPost(InvokeServlet.java:352)
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(StrictServle
tInstance.java:110)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecy
cleServlet.java:174)
at
com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServ
let.java:313)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecyc
leServlet.java:116)
at
com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java
:283)
at
com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidSer
vletReferenceState.java:42)
at
com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletIns
tanceReference.java:40)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(
WebAppRequestDispatcher.java:972)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppReques
tDispatcher.java)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequest
Dispatcher.java:198)
at
com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79)
at
com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker
.java:201)
at
com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(C
achedInvocation.java:71)
at
com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(C
acheableInvocationContext.java:114)
at
com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletReq
uestProcessor.java:186)
at
com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListene
r.java:334)
at
com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.jav
a:56)
at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:610)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java)
javax.ejb.EJBException: nested exception is:
com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E:
Error using adapter to create or execute an Interaction.
com.ibm.ws.rsadapter.cci.WSInteractionImpl@57b957b9
at java.lang.Throwable.<init>(Throwable.java)
at javax.ejb.EJBException.<init>(EJBException.java:41)
at
com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensi
onImpl.executeCreate(Unknown Source)
at
com.ibm.ws.ejbpersistence.beanextensions.CBNotExistState.ejbCreate(Unknown
Source)
at
com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensi
onImpl.ejbPostCreate(Unknown Source)
at
com.cf.etools.registration.ejb.CustomerMapping.ConcreteCustomerMapping_cd59d
9ad.ejbPostCreate(ConcreteCustomerMapping_cd59d9ad.java:137)
at
com.cf.etools.registration.ejb.CustomerMapping.EJSCMPCustomerMappingHomeBean
_cd59d9ad.create(EJSCMPCustomerMappingHomeBean_cd59d9ad.java:35)
at
com.cf.etools.registration.ejb.CustomerMapping.EJSRemoteCMPCustomerMappingHo
me_cd59d9ad.create(EJSRemoteCMPCustomerMappingHome_cd59d9ad.java:22)
at java.lang.reflect.AccessibleObject.invokeImpl(Native Method)
at java.lang.reflect.AccessibleObject.invokeL(AccessibleObject.java:207)
at java.lang.reflect.Method.invoke(Method.java)
at com.ibm.CORBA.iiop.ClientDelegate$3.run(ClientDelegate.java:1140)
at java.security.AccessController.doPrivileged(AccessController.java)
at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java:1138)
at $Proxy0.create(Unknown Source)
at
com.cf.etools.registration.ejb.CustomerMapping._CustomerMappingHome_Stub.cre
ate(_CustomerMappingHome_Stub.java:236)
at java.lang.reflect.AccessibleObject.invokeImpl(Native Method)
at java.lang.reflect.AccessibleObject.invokeL(AccessibleObject.java:207)
at java.lang.reflect.Method.invoke(Method.java)
at
com.ibm.etools.utc.model.ReflectionMethodModel.invoke(ReflectionMethodModel.
java:68)
at com.ibm.etools.utc.servlet.InvokeServlet.invoke(InvokeServlet.java:110)
at com.ibm.etools.utc.servlet.InvokeServlet.doPost(InvokeServlet.java:352)
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(StrictServle
tInstance.java:110)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecy
cleServlet.java:174)
at
com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServ
let.java:313)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecyc
leServlet.java:116)
at
com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java
:283)
at
com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidSer
vletReferenceState.java:42)
at
com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletIns
tanceReference.java:40)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(
WebAppRequestDispatcher.java:972)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppReques
tDispatcher.java)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequest
Dispatcher.java:198)
at
com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79)
at
com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker
.java:201)
at
com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(C
achedInvocation.java:71)
at
com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(C
acheableInvocationContext.java:114)
at
com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletReq
uestProcessor.java:186)
at
com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListene
r.java:334)
at
com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.jav
a:56)
at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:610)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java)
>Hi,
>
>I'm experiencing strange behaviour with a CMP bean. My environment is WAS
>5.1 running on Windows 2000, using DB2 on AS400 as the datasource. The bean
>works correctly
>when I call the finder methods but when trying to call the create method I
>get the following stack trace. I'm using the JTOpen version 4.2, JT400.jar
>for my connection. I found a post that mentioned using an XA datasource so
>I
>tried that and still didn't have any luck.
>
>The only line in the stack trace that seems to have any value is this one:
>java.sql.SQLException: [SQL7008] INP301 in FBPRODTA not valid for operation.
>
>That seems to indicate a mapping error but my finder methods work correctly
>so I think that should be fine. This has got me stumped, any help would be
>appreciated.
>
>The full stack trace is below, thanks for your help.
>
>Rick
>
>
WAG alert: the versions of your JDBC driver and the database aren't the
same.
Ken
"Ken Hygh" <ken...@nc.rr.com> wrote in message
news:c4udfd$m90$1...@news.boulder.ibm.com...
Good luck,
Ursula
"Rick Hugie" <rth...@telus.net> schrieb im Newsbeitrag
news:rukcc.6513$Sh4.998@edtnps84...
Rick
"Ursula Klarmann" <ursula....@boss-ag.de> wrote in message
news:c50oe1$78ue$1...@news.boulder.ibm.com...
Ursula
"Rick Hugie" <rth...@telus.net> schrieb im Newsbeitrag
news:44Xcc.12740$Sh4.55@edtnps84...