From: "Bob Weber" <baweber@home.com>
Subject: Re: using Oracle's JDBC driver
Date: 1998/12/12
Message-ID: <Avjc2.1574$tI2.865@news.rdc1.tx.home.com>#1/1
References: <Pine.GSO.3.96.981211131008.13238A-100000@elaine15.Stanford.EDU>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
X-Complaints-To: news@home.net
X-Trace: news.rdc1.tx.home.com 913425504 24.4.30.125 (Fri, 11 Dec 1998 17:18:24 PDT)
Organization: @Home Network
NNTP-Posting-Date: Fri, 11 Dec 1998 17:18:24 PDT
Newsgroups: comp.lang.java.databases,comp.databases.oracle.tools,comp.databases.oracle.misc


When you unpacked the JDBC drivers from ORACLE, there were two .dll's with
them.  If you use the oci JDBC driver you have to make sure those .dll's are
in your path....

Anne Kwong wrote in message ...
>Hi,
> I am newbie to Oracle and I am trying to setup a JDBC connection
>with the oracle database.   Could anyone give me
>any information how to do
>that?  I downloaded the Oracle JDBC driver from  the oracle web site and
>when I try the following program, I get error that says:
>
>The dynamic link library ORA73.dll could not be found in the specified
>path.
>
>G:\epgy>java test
>
>
>java.lang.UnsatisfiedLinkError: no oci73jdbc in shared library path
>        at java.lang.Runtime.loadLibrary(Compiled Code)
>        at java.lang.System.loadLibrary(System.java:561)
>        at oracle.jdbc.oci7.OCIDBAccess.logon(OCIDBAccess.java:138)
>        at
>oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:93)
>        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:146)
>        at java.sql.DriverManager.getConnection(Compiled Code)
>        at java.sql.DriverManager.getConnection(DriverManager.java:126)
>        at test.main(Compiled Code)
>
>The sample program that I write is :
>import java.sql.*;
>
>class
 t{ 
>  public static void main (String args []) throws SQLException { 
>    // Load Oracle driver
>    DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
>     
>    // Connect to the local database
>    Connection conn = 
>      DriverManager.getConnection ("jdbc:oracle:oci7:@epgy", "oraserver",
>"oraserver");
>
>    // Query the employee names 
>    Statement stmt = conn.createStatement (); 
>    ResultSet rset = stmt.executeQuery ("select ename from emp");
>
>      // Print the name out 
>    while (rset.next ())
>      System.out.println (rset.getString (1));
>  } 
>} 
>
>
>
>
>Thank you very much in advance for your help.
>
>Anne Kwong
>



begin 666 Bob Weber.vcf
M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..E=E8F5R.T)O8@T*1DXZ0F]B
M(%=E8F5R#0I!1%([2$]-13H[.SM!<FQI;F=T;VX[5%@[-S8P,#$[55,-"DQ!
M0D5,.TA/344[14Y#3T1)3D<]455/5$5$+5!224Y404),13I!<FQI;F=T;VXL
M(%18(#<V,# Q/3!$/3!!55,-"D5-04E,.TE.5$523D54.F)W96)E<D!O;G)A
M;7 N;F5T#0I%34%)3#M)3E1%4DY%5#IB87=E8F5R0'5S<&$M:7)A+F-O;0T*
M14U!24P[4%)%1CM)3E1%4DY%5#IB87=E8F5R0&AO;64N8V]M#0I2158Z,3DY
:.#$R,3)4,#$R,#(X6@T*14Y$.E9#05)$#0H`
`
end