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
