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
