Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

Data Access Error using CMP2

1 view

Skip to first unread message

Rick Hugie

unread,

Apr 5, 2004, 5:48:07 PM4/5/04

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

----------------------------------------------------------------------------
--------------------------
[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 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.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)