Hi, Yan Zhu:
please try follow way, I run it to connect to a oracle DB on NT successfully:
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:oci8:@dbnameInTNS";
con=DriverManager.getConnection(url,username,password);
cheers,
Luke Kuang
----- Original Message -----
From: "Yan Zhu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 22, 2002 10:20 PM
Subject: Re: iplanet web server and oci driver?
> But I think they are valid, because I have a stand along java program
> using exactly the same thing and it works. :-(
>
> Nguyen Tra Linh wrote:
>
> > TNS-12545 Connect failed because target host or object does not exist
> >
> > Cause: The address specified is not valid, or the program being connected to
> > does not exist.
> >
> > Action: Ensure the ADDRESS parameters have been entered correctly; the most
> > likely incorrect parameter is the node name. Ensure that the executable for
> > the server exists (perhaps "oracle" is missing). If the protocol is TCP/IP,
> > edit the TNSNAMES.ORA file to change the host name to a numeric IP address
> > and try again.
> >
> > ----- Original Message -----
> > From: "Yan Zhu" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Monday, January 21, 2002 10:14 PM
> > Subject: iplanet web server and oci driver?
> >
> > > hey all,
> > > Has anyone successfully used oracle oci driver in iplanet
> > > web container?
> > >
> > > this is what I am trying to do:
> > >
> > > <%@ page import="java.util.*" %>
> > > <%@ page import="java.sql.*" %>
> > >
> > > <%
> > >
> > > String db_driver = "oracle.jdbc.driver.OracleDriver";
> > > String username = "blah";
> > > String password = "blah";
> > > file://String db_url = "jdbc:oracle:thin:@10.94.2.8:1521:icsprd2";
> > > String db_url = "jdbc:oracle:oci8:@ICSPRD.WORLD";
> > >
> > > out.println(System.getProperty("java.library.path"));
> > >
> > > Connection dbConn;
> > > Class.forName(db_driver);
> > > try {
> > > dbConn = DriverManager.getConnection(db_url, username, password);
> > > } catch (Exception e) {
> > > out.println(e.getMessage());
> > > e.printStackTrace();
> > > }
> > >
> > > %>
> > >
> > >
> > > and when I go to the jsp, I got:
> > >
> > >
> > /opt/oracle/product/8.1.7/lib:/opt/oracle/product/8.1.7/jdbc/lib/classes12.z
> > ip:/usr/java/j2se1.3/jre/lib/sparc:/usr/java/j2se1.3/jre/lib/sparc/server:/u
> > sr/java/j2se1.3/jre/lib/sparc/classic:/usr/java/j2se1.3/jre/lib/sparc/native
> > _threads:/opt/oracle/product/8.1.7/lib:/usr/iplanet/webservers/6.0sp2/bin/ht
> > tps/lib:/opt/oracle/product/8.1.7/lib:/usr/lib:/usr/dt/lib:/usr/openwin/lib:
> > /opt/gnu/lib:/usr/local/lib:/usr/lib
> > >
> > > ORA-12545: Connect failed because target host or object does not exist
> > >
> > > looks like the tnsname look up failed!
> > >
> > > I can't figure out why, everything works in my shell programs. :(
> > >
> > > 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
��칻 �&ޙ����b�� ��ڽ�.��&�+an�r�('���H�
LDDI1h�ؠz�fj)m�X��ǫ�6�j˧r����[�ܬz�R<�SL2$Ңg�zW�j{E (����'��W��Ƨm��wZ�m��ڭ�b��#j���w(���)�z���f�m���j���w(��k�ۜ��㲟�j�m�Xm����
���j{h��'���������a��� 0� ���&����)�{�m�����)�r�
