This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Oracle 8 DB CMP access with WSAD 5.0 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle 8 DB CMP access with WSAD 5.0" Watch "Oracle 8 DB CMP access with WSAD 5.0" New topic
Author

Oracle 8 DB CMP access with WSAD 5.0

theo cocolucci
Greenhorn

Joined: Dec 01, 2003
Posts: 10
Hello,
I get an error creating new EJB CMP Bean ( See the text of the exception underneath).
I'm using a thin ORacle client to access my database, and cannot even create a Bean, knowing that :
- the database is perfectly accessible through other persistance mecanism
- problems appears independently of compatibility between java data format and Database data format (use of com.ibm.vap.converters.VapNumberToIntegerConverter)
- use of security roles don't seem to change anything
- error appears while calling beanHome.create(), or any hand made finder
- use of access intention 'use of optimistic Update' (other are not supported by Oracle clients)
the text of the error is :
'error of use of adaptator to create or execute an interaction'.
What is the problem ? is the Oracle client (v. 8) under conditions not compatible with WSAD resource adaptors ? or is there a configuration parameter I haven't set ? Any other idee ?
Help will be fine !
Pierre

here is the exception :
com.ibm.ejs.container.CreateFailureException: javax.ejb.EJBException: nested exception is: com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E: Erreur d'utilisation de l'adaptateur pour cr�er ou ex�cuter une interaction. ???; nested exception is: javax.ejb.EJBException: nested exception is: com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E: Erreur d'utilisation de l'adaptateur pour cr�er ou ex�cuter une interaction. ??? javax.ejb.EJBException: nested exception is: com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E: Erreur d'utilisation de l'adaptateur pour cr�er ou ex�cuter une interaction. ??? com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E: Erreur d'utilisation de l'adaptateur pour cr�er ou ex�cuter une interaction. ??? at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(DataAccessRequestImpl.java:159) 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 michelin.cmp.ConcreteFormulaire_4c690527.ejbPostCreate(ConcreteFormulaire_4c690527.java:183) at michelin.cmp.EJSCMPFormulaireHomeBean_4c690527.create_Local(EJSCMPFormulaireHomeBean_4c690527.java:52) at michelin.cmp.EJSLocalCMPFormulaireHome_4c690527.create(EJSLocalCMPFormulaireHome_4c690527.java:42) at java.lang.reflect.Method.invoke(Native Method) 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:323) 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.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182) 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 java.lang.ClassCastException: java.lang.Integer at michelin.cmp.websphere_deploy.ORACLE_V8_1.FormulaireBeanFunctionSet_4c690527.Create(FormulaireBeanFunctionSet_4c690527.java:43) at michelin.cmp.websphere_deploy.ORACLE_V8_1.FormulaireBeanFunctionSet_4c690527.execute(FormulaireBeanFunctionSet_4c690527.java:352) 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 michelin.cmp.ConcreteFormulaire_4c690527.ejbPostCreate(ConcreteFormulaire_4c690527.java:183) at michelin.cmp.EJSCMPFormulaireHomeBean_4c690527.create_Local(EJSCMPFormulaireHomeBean_4c690527.java:52) at michelin.cmp.EJSLocalCMPFormulaireHome_4c690527.create(EJSLocalCMPFormulaireHome_4c690527.java:42) at java.lang.reflect.Method.invoke(Native Method) 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:323) 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.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182) 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) javax.ejb.EJBException: nested exception is: com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E: Erreur d'utilisation de l'adaptateur pour cr�er ou ex�cuter une interaction. ??? at com.ibm.ws.ejbpersistence.beanextensions.CBStatefulPersistor.executeCreate(CBStatefulPersistor.java:244) 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 michelin.cmp.ConcreteFormulaire_4c690527.ejbPostCreate(ConcreteFormulaire_4c690527.java:183) at michelin.cmp.EJSCMPFormulaireHomeBean_4c690527.create_Local(EJSCMPFormulaireHomeBean_4c690527.java:52) at michelin.cmp.EJSLocalCMPFormulaireHome_4c690527.create(EJSLocalCMPFormulaireHome_4c690527.java:42) at java.lang.reflect.Method.invoke(Native Method) 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:323) 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.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182) 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)
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30138
    
150

Theo,
I think it is complaining about the Vap adapter. What types are the database and CMP fields?
Also, you may have more luck in the IBM/Websphere forum below.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
theo cocolucci
Greenhorn

Joined: Dec 01, 2003
Posts: 10
Hi Jeanne,
about the Vap Adapter, the one I use is
VapNumberToIntegerConverter
the type in the Bean is Integer
the type in the database is NUMBER(22, 0).
this may be ok, no ?
Theo
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30138
    
150

The database field can hold a value that is larger than an integer can hold. The maximum integer value is 2^31.
Don't know if that's what is causing the problem, but it's possible.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Oracle 8 DB CMP access with WSAD 5.0
 
Similar Threads
Oracle 8 DB CMP access with WSAD 5.0
PersistenceManagerException in ejbCreate
Autoincrement field in cloudscape
com.ibm.ws.rsadapter Exception
Error while calling EJBs