File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
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
Author

Urgent! Error excuting SQL on Oracle 8.1.6 using Merant drivers

Steve Granton
Ranch Hand

Joined: Jan 13, 2002
Posts: 200
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 ]
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Urgent! Error excuting SQL on Oracle 8.1.6 using Merant drivers