wood burning stoves 2.0
The moose likes Websphere and the fly likes Urgent! Error excuting SQL on Oracle 8.1.6 using Merant drivers Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "Urgent! Error excuting SQL on Oracle 8.1.6 using Merant drivers" Watch "Urgent! Error excuting SQL on Oracle 8.1.6 using Merant drivers" New topic

Urgent! Error excuting SQL on Oracle 8.1.6 using Merant drivers

Steve Granton
Ranch Hand

Joined: Jan 13, 2002
Posts: 200
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?
[ May 06, 2002: Message edited by: Steve Granton ]
I agree. Here's the link: http://aspose.com/file-tools
subject: Urgent! Error excuting SQL on Oracle 8.1.6 using Merant drivers
It's not a secret anymore!