tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Phillip Qin <Phillip....@shareowner.com>
Subject RE: Oracle 9i client connection to 8i database
Date Tue, 04 Jan 2005 21:38:56 GMT
There is nothing to do with Oracle client. All you need is the jdbc driver.

-----Original Message-----
From: Brad Rhoads [mailto:brad@zethcon.com] 
Sent: December 27, 2004 5:11 PM
To: 'Tomcat Users List'
Subject: RE: Oracle 9i client connection to 8i database


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:mech@tngtech.com]
> 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: tomcat-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> > 
> > 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> 



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


!DSPAM:41d08896130622933416230!

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message