I always assumed the Oracle client was required. . . I uninstalled the client and get the same results. With the sid syntax I at least get an entry in the listener.log:
27-DEC-2004 16:58:11 * (CONNECT_DATA=(SID=test)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.4)(PORT=33244)) * establish * But the app doesn't get a connection. And with the service_name syntax I only get a connection error: DatabaseMessageresources: Loading all the messages for the messageMap NVFactory: _readNVPair expected ) DatabaseMessageresources: SQL EXCEPTION FETCHING MESSAGE java.sql.SQLException: Io exception: NL Exception was generated at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:187) I've run into a similar problem where the db server was behind the firewall and the firewall didn't allow high-ports, but in this case both machines are behind the firewall. Any other ideas why I might not be able to get a connection? > -----Original Message----- > From: Michael Echerer [mailto:[EMAIL PROTECTED] > Sent: Saturday, December 25, 2004 4:08 AM > To: Tomcat Users List > Subject: Re: Oracle 9i client connection to 8i database > > How come that you need an Oracle client installation at all > when you just want to use the Oracle thin JDBC driver? IHMO > the client installation is only required for OCI thick drivers... > > Brad Rhoads wrote: > > We have an (struts) app that talks to an Oracle 8i database. Our > > latest installation wants to run the app on Fedora Core 2. > I couldn't > > get the Oracle 8i client install, so I installed the 9i > client. With > > the 9i client, you have to use a service_name instead of a > sid in the connection. > > > > Normally my connection string (in my web.xml) looks like: > > > > <param-value>jdbc:oracle:thin:@10.0.0.7:1521:test</param-value> > > > > But it seems to get a service_name instead of a sid I have to use > > something > > like: > > > > > > > <param-value>jdbc:oracle:thin:@jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS > > =(PROT > > > OCOL=TCP)(HOST=10.0.0.7)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=test)) > > )</par > > am-value> > > > > My problem is I'm getting this error: > > > > NVFactory: _readNVPair expected > > > > It doesn't seem to make any difference if I use the 8i or > the 9i drivers. > > > > I've also tried > > > > > <param-value>jdbc:oracle:thin:@//10.0.0.7:1521/test</param-value> > > > > But that just gave me a format error. > > > > I can connect fine using sqlplus. > > > > What am I doing wrong? > > > > Thanks for the help. Merry Christmas! > > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]