Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Urgent! Error excuting SQL on Oracle 8.1.6 using Merant drivers

 
Steve Granton
Ranch Hand
Posts: 200
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic