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

WAS5 Oracle 9

1 view
Skip to first unread message

Manish

unread,
May 9, 2003, 7:42:50 PM5/9/03
to
We have an application running on Oracle 9 with JBoss and WebLogic.

I am evaluating to port the app. on WAS5, While doing so I am facing
the following problem.

OS: Windows 200
I am using Web Sphere App Server 5.0 trial and I'am using Application
Assembly Tool .

I' am using Oracle9i Enterprise Edition.The Application uses EJB 2.0.

I added a Oracle Datasource through the AdminConsole.

The application also connects to the db using JDBC.

I could successfully build and deploy the EJBs ( I had to add Access
Intent
wsOptimisticUpdate for it to work with Oracle). The app connects and
runs fine
using the Oracle Datasource through JDBC but for the EJBs it gives me
a runtime exception.
In my session bean, there is function, which calls an entity finder
and
it returns the following exception. Any help would be appreciated.

-Manish


5/9/03 16:06:13:792 PDT] 5507415c DataAccessReq E PMGR6022E: Error
using adapter to create or execute an Interaction.
com.ibm.ws.rsadapter.cci.WSInteractionImpl@6e0d815b

[5/9/03 16:06:13:792 PDT] 5507415c 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@6e0d815b
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(DataAccessRequestImpl.java:127)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanInstanceExtensionImpl.executeQuery(ConcreteBeanInstanceExtensionImpl.java:264)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanInstanceExtensionImpl.executeFind(ConcreteBeanInstanceExtensionImpl.java:155)
at com.postx.common.ejb.ConcreteLoginInfo_d8a8e78b.ejbFindByServerName_Local(Unknown
Source)
at com.postx.common.interfaces.EJSCMPLoginInfoHomeBean_d8a8e78b.findByServerName_Local(Unknown
Source)
at com.postx.common.interfaces.EJSLocalCMPLoginInfoHome_d8a8e78b.findByServerName(Unknown
Source)
at com.postx.common.ejb.LoginManagementBean.removeLoginInfo(LoginManagementBean.java:308)
at com.postx.common.interfaces.EJSRemoteStatelessLoginManagement_4bd18ce6.removeLoginInfo(Unknown
Source)
at com.postx.common.interfaces._LoginManagementRemote_Stub.removeLoginInfo(_LoginManagementRemote_Stub.java:353)
at com.postx.ui.Config.init(Config.java:215)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doInit(StrictServletInstance.java:82)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._init(StrictLifecycleServlet.java:147)
at com.ibm.ws.webcontainer.servlet.PreInitializedServletState.init(StrictLifecycleServlet.java:270)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.init(StrictLifecycleServlet.java:113)
at com.ibm.ws.webcontainer.servlet.ServletInstance.init(ServletInstance.java:175)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at com.ibm.ws.webcontainer.webapp.WebAppServletManager.addServlet(WebAppServletManager.java:761)
at com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadServlet(WebAppServletManager.java:257)
at com.ibm.ws.webcontainer.webapp.WebAppServletManager.getServletReference(WebAppServletManager.java:382)
at com.ibm.ws.webcontainer.webapp.WebApp.getServletReference(WebApp.java:589)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcherInfo.calculateInfo(WebAppRequestDispatcherInfo.java:177)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcherInfo.<init>(WebAppRequestDispatcherInfo.java:59)
at com.ibm.ws.webcontainer.webapp.WebApp.getRequestDispatcher(WebApp.java:1415)
at com.ibm.ws.webcontainer.webapp.WebApp.getRequestDispatcher(WebApp.java:1376)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:196)
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.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:4077)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:623)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527)
at com.postx.common.ejb.websphere_deploy.ORACLE_V9_1.LoginInfoCMPFunctionSet_d8a8e78b.FindByServerName_Local(Unknown
Source)
at com.postx.common.ejb.websphere_deploy.ORACLE_V9_1.LoginInfoCMPFunctionSet_d8a8e78b.execute(Unknown
Source)
at com.ibm.ws.rsadapter.cci.WSInteractionImpl.execute(WSInteractionImpl.java:156)
at com.ibm.ws.rsadapter.cci.WSRelationalRAAdapter.executeFinder(WSRelationalRAAdapter.java:262)
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(DataAccessRequestImpl.java:81)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanInstanceExtensionImpl.executeQuery(ConcreteBeanInstanceExtensionImpl.java:264)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanInstanceExtensionImpl.executeFind(ConcreteBeanInstanceExtensionImpl.java:155)
at com.postx.common.ejb.ConcreteLoginInfo_d8a8e78b.ejbFindByServerName_Local(Unknown
Source)
at com.postx.common.interfaces.EJSCMPLoginInfoHomeBean_d8a8e78b.findByServerName_Local(Unknown
Source)
at com.postx.common.interfaces.EJSLocalCMPLoginInfoHome_d8a8e78b.findByServerName(Unknown
Source)
at com.postx.common.ejb.LoginManagementBean.removeLoginInfo(LoginManagementBean.java:308)
at com.postx.common.interfaces.EJSRemoteStatelessLoginManagement_4bd18ce6.removeLoginInfo(Unknown
Source)
at com.postx.common.interfaces._LoginManagementRemote_Stub.removeLoginInfo(_LoginManagementRemote_Stub.java:353)
at com.postx.ui.Config.init(Config.java:215)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doInit(StrictServletInstance.java:82)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._init(StrictLifecycleServlet.java:147)
at com.ibm.ws.webcontainer.servlet.PreInitializedServletState.init(StrictLifecycleServlet.java:270)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.init(StrictLifecycleServlet.java:113)
at com.ibm.ws.webcontainer.servlet.ServletInstance.init(ServletInstance.java:175)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at com.ibm.ws.webcontainer.webapp.WebAppServletManager.addServlet(WebAppServletManager.java:761)
at com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadServlet(WebAppServletManager.java:257)
at com.ibm.ws.webcontainer.webapp.WebAppServletManager.getServletReference(WebAppServletManager.java:382)
at com.ibm.ws.webcontainer.webapp.WebApp.getServletReference(WebApp.java:589)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcherInfo.calculateInfo(WebAppRequestDispatcherInfo.java:177)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcherInfo.<init>(WebAppRequestDispatcherInfo.java:59)
at com.ibm.ws.webcontainer.webapp.WebApp.getRequestDispatcher(WebApp.java:1415)
at com.ibm.ws.webcontainer.webapp.WebApp.getRequestDispatcher(WebApp.java:1376)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:196)
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)

0 new messages