Hi,
We are using WAS4.0 AE and are having real difficulties getting our application SQL to execute successfully when using the Merant drivers (through Sequelink Server 5.1) to connect to Oracle 8.1.6.
The error we get is seen below:
[06/05/02 13:23:32:817 BST] 5e0c39e4 ExceptionUtil X CNTR0020E: Non-application exception occurred while processing method handleEvent on bean BeanId(tickets#ejb_EjbSearch.jar#com.versko.tickets.business.EjbSearch, null): javax.ejb.EJBException: SQLException in findByEventName : java.sql.SQLException: [MERANT][SequeLink
JDBC Driver][Oracle]ORA-00942: table or view does not exist
at com.versko.tickets.entity.performance.PerformanceDm.findByEventName(Unknown Source)
at com.versko.tickets.business.Search.EjbSearchBean.handleEvent(Unknown Source)
at com.versko.tickets.business.Search.EJSRemoteStatelessEjbSearch.handleEvent(EJSRemoteStatelessEjbSearch.java:61)
at com.versko.tickets.business.Search._EjbSearch_Stub.handleEvent(_EjbSearch_Stub.java:275)
at com.versko.controller.business.ControllerBean.handleEvent(Unknown Source)
at com.versko.controller.business.ControllerBean.handleEvent(Unknown Source)
at com.versko.controller.business.EJSRemoteStatelessController.handleEvent(EJSRemoteStatelessController.java:25)
at com.versko.controller.business._Controller_Stub.handleEvent(_Controller_Stub.java:267)
at com.versko.controller.web.WebTierEventHandler.processBusinessEvent(Unknown Source)
at com.versko.tickets.web.SearchWteHandler.generateXml(Unknown Source)
at com.versko.controller.web.WebTierEventHandler.processEvent(Unknown Source)
at com.versko.controller.web.Controller.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
As these tables do exist with data in them (confirmed by using SQL*PLUS) the problem seems to be that the Merant SequeLink Server is executing the statement on the wrong database schema - on a database instance named 'WAS' database rather than our application database that we have specified in the custom properties of the data source. If we stop the 'WAS' database then we get a 'TNS
rotocol adapter error' from the
test connection!
How do we confirm which database the SequeLink Server is executing our SQL on?
And how can we change it to execute our SQL on the correct schema?
Also, do we need to set up a DBA user EJSADMIN (pwd EJSADMIN) on our application database in order for SequeLink Server to connect to it?
Cheers,
Steve
[ May 06, 2002: Message edited by: Steve Granton ]