Hi Yan Zhu.
If you use JDBC thin, the connect string looks like:
lConnection conn = DriverManager.getConnection
("jdbc:oracle:thin:uid/passwd@ip:port:sid");
whereas in JDBC thick (OCI) the connect string is:
lConnection conn = DriverManager.getConnection
("jdbc:oracle:oci8:uid/passwd@Net_service_name");
where Net service name is a entry in tnsnames.ora.
Linhz
----- Original Message -----
From: "Yan Zhu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 19, 2002 6:58 AM
Subject: oci8 and tnsname
> hey all,
>
> Has anyone used an Oracle thick client like oci8 to
> resolve a database name through tnsname file? I know
> you can do things like thin@ip:host:sid, but I need my jsp
> to be able to look up the names (since I do clustering), and
> I always get a tns look up error. I am running Oracle 8.1.7
> and iPlanet web server 6.0 sp2 as my web container.
>
> thanks in advance.
>
> yan
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://archives.java.sun.com/jsp-interest.html
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.jsp
> http://www.jguru.com/faq/index.jsp
> http://www.jspinsider.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
