Ashok,
Thanks for the pointer. I found the problem in the URL. Apparently, I have to
include the
entry from the tnsnames.ora file. The thought never would have occured to me, but
someone
else has done this and it worked for him. So I no longer get the "invalid driver
designator" error. However, now I get an "IO Exception: Network Adaptor could not
establish the connection." Any clues on this one???
BTW: I'm running Orion 1.5.2, Oracle 8.0.5.1, and have installed the Oracle JDBC 8.1.7
Thin
driver.
I also noticed another posting regarding a JDBC log file. You said to start OC4J with
-Djdbc.debug=true; but how do I go about doing this. Sorry for the ignorance, but I'm
a
novice (at best) at this.
Thanks again,
- Mo
Ashok Banerjee wrote:
> Your error is in the trace
> NETCMN: invalid driver designator.
> Please check the JDBC URL.
> Cheers,
> Ashok
>
> Mong Kon Mo wrote:
>
> > I've been trying to setup Orion to communicate with our Oracle database,
> > but have had little success. We are using Oracle 8.0.5.1 and have
> > installed the Oracle 8.1.7 JDBC drivers (the 8.0.5.2 drivers were giving
> > us problems). Now we get the following error:
> >
> > com.evermind[Orion/1.5.2 (build 10460)].server.rmi.OrionRemoteException:
> > Transaction was rolled back: javax.ejb.EJBException: Unable to get
> > zipcode: java.sql.SQLException: SystemException: Failed to add the
> > resource due to error in the resource
> > at
> >
>HIT_StatelessSessionBeanWrapper0.getZipcode(HIT_StatelessSessionBeanWrapper0.java:97)
> >
> > at /result.jsp._jspService(/result.jsp.java:72) (JSP page line
> > 52)
> > at com.orionserver[Orion/1.5.2 (build
> > 10460)].http.OrionHttpJspPage.service(Unknown Source)
> > at com.evermind[Orion/1.5.2 (build 10460)]._ah._rad(Unknown
> > Source)
> > at com.evermind[Orion/1.5.2 (build
> > 10460)].server.http.JSPServlet.service(Unknown Source)
> > at com.evermind[Orion/1.5.2 (build 10460)]._cxb._abe(Unknown
> > Source)
> > at com.evermind[Orion/1.5.2 (build 10460)]._cxb._uec(Unknown
> > Source)
> > at com.evermind[Orion/1.5.2 (build 10460)]._io._twc(Unknown
> > Source)
> > at com.evermind[Orion/1.5.2 (build 10460)]._io._gc(Unknown
> > Source)
> > at com.evermind[Orion/1.5.2 (build 10460)]._if.run(Unknown
> > Source)
> > Nested exception is:
> > com.evermind[Orion/1.5.2 (build
> > 10460)].transaction.MarshallingXAException: SQL Error: ORA-06401:
> > NETCMN: invalid driver designator
> > at com.evermind[Orion/1.5.2 (build 10460)]._vo.start(Unknown
> > Source)
> > at com.evermind[Orion/1.5.2 (build 10460)]._fvb.<init>(Unknown
> > Source)
> > at com.evermind[Orion/1.5.2 (build
> > 10460)].server.ApplicationServerTransaction.enlistResource(Unknown
> > Source)
> > at com.evermind[Orion/1.5.2 (build
> > 10460)].server.ApplicationServerTransaction.enlistResource(Unknown
> > Source)
> > at com.evermind[Orion/1.5.2 (build 10460)]._wp._bl(Unknown
> > Source)
> > at com.evermind[Orion/1.5.2 (build
> > 10460)]._lo.prepareStatement(Unknown Source)
> > at Hit.beans.hit.HITBean.getZipcode(HITBean.java:102)
> > at
> >
>HIT_StatelessSessionBeanWrapper0.getZipcode(HIT_StatelessSessionBeanWrapper0.java:66)
> >
> > at /result.jsp._jspService(/result.jsp.java:72) (JSP page line
> > 52)
> > at com.orionserver[Orion/1.5.2 (build
> > 10460)].http.OrionHttpJspPage.service(Unknown Source)
> > at com.evermind[Orion/1.5.2 (build 10460)]._ah._rad(Unknown
> > Source)
> > at com.evermind[Orion/1.5.2 (build
> > 10460)].server.http.JSPServlet.service(Unknown Source)
> > at com.evermind[Orion/1.5.2 (build 10460)]._cxb._abe(Unknown
> > Source)
> > at com.evermind[Orion/1.5.2 (build 10460)]._cxb._uec(Unknown
> > Source)
> > at com.evermind[Orion/1.5.2 (build 10460)]._io._twc(Unknown
> > Source)
> > at com.evermind[Orion/1.5.2 (build 10460)]._io._gc(Unknown
> > Source)
> > at com.evermind[Orion/1.5.2 (build 10460)]._if.run(Unknown
> > Source)
> > Nested exception is:
> > java.sql.SQLException: ORA-06401: NETCMN: invalid driver designator
> > at
> > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
> > at
> > oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:1597)
> > at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java:354)
> > at
> > oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:249)
> > at
> > oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
> >
> > at
> > oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
> > at com.evermind[Orion/1.5.2 (build
> > 10460)].sql.DriverManagerDataSource.getConnection(Unknown Source)
> > at com.evermind[Orion/1.5.2 (build
> > 10460)].sql.DriverManagerConnectionPoolDataSource.getPooledConnection(Unknown
> > Source)
> > at com.evermind[Orion/1.5.2 (build
> > 10460)].sql.OrionPooledDataSource._bgb(Unknown Source)
> > at com.evermind[Orion/1.5.2 (build 10460)]._jb._bgb(Unknown
> > Source)
> > at com.evermind[Orion/1.5.2 (build
> > 10460)].sql.OrionPooledDataSource.getConnection(Unknown Source)
> > at com.evermind[Orion/1.5.2 (build
> > 10460)].sql.DriverManagerXADataSource._bwc(Unknown Source)
> > at com.evermind[Orion/1.5.2 (build 10460)]._vo.start(Unknown
> > Source)
> > at com.evermind[Orion/1.5.2 (build 10460)]._fvb.<init>(Unknown
> > Source)
> > at com.evermind[Orion/1.5.2 (build
> > 10460)].server.ApplicationServerTransaction.enlistResource(Unknown
> > Source)
> > at com.evermind[Orion/1.5.2 (build
> > 10460)].server.ApplicationServerTransaction.enlistResource(Unknown
> > Source)
> > at com.evermind[Orion/1.5.2 (build 10460)]._wp._bl(Unknown
> > Source)
> > at com.evermind[Orion/1.5.2 (build
> > 10460)]._lo.prepareStatement(Unknown Source)
> > at Hit.beans.hit.HITBean.getZipcode(HITBean.java:102)
> > at
> >
>HIT_StatelessSessionBeanWrapper0.getZipcode(HIT_StatelessSessionBeanWrapper0.java:66)
> >
> > at /result.jsp._jspService(/result.jsp.java:72) (JSP page line
> > 52)
> > at com.orionserver[Orion/1.5.2 (build
> > 10460)].http.OrionHttpJspPage.service(Unknown Source)
> > at com.evermind[Orion/1.5.2 (build 10460)]._ah._rad(Unknown
> > Source)
> > at com.evermind[Orion/1.5.2 (build
> > 10460)].server.http.JSPServlet.service(Unknown Source)
> > at com.evermind[Orion/1.5.2 (build 10460)]._cxb._abe(Unknown
> > Source)
> > at com.evermind[Orion/1.5.2 (build 10460)]._cxb._uec(Unknown
> > Source)
> > at com.evermind[Orion/1.5.2 (build 10460)]._io._twc(Unknown
> > Source)
> > at com.evermind[Orion/1.5.2 (build 10460)]._io._gc(Unknown
> > Source)
> > at com.evermind[Orion/1.5.2 (build 10460)]._if.run(Unknown
> > Source)
> >
> > Does anyone have any idea what I might be doing wrong?
> >
> > Thanks in advance,
> >
> > - Mong Kon Mo