I think I am doing exactly that. :( Nguyen Tra Linh wrote:
> 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 =========================================================================== 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