Ashok,
Have you got Forte CE or JBuilder or other IDE? Use this to make a
connection over the network to oracle. You can also just try a simple jdbc
program to make a connection over the network. This will verify that the
driver works with your version of oracle.
If the simple program or IDE don't work, its the driver version.
Your problems don't sound like an orion issue.
Regards,
the elephantwalker
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Mong Kon Mo
Sent: Thursday, July 19, 2001 2:30 PM
To: Orion-Interest
Subject: Re: Oracle JDBC problems
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(Unknow
n
> > 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
