Re: using Oracle's JDBC driver

From: Bob Weber <baweber_at_home.com>
Date: 1998/12/12
Message-ID: <Avjc2.1574$tI2.865_at_news.rdc1.tx.home.com>#1/1

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:_at_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_at_T*1DXZ0F]B M(%=E8F5R#0I!1%([2$]-13H[.SM!<FQI;F=T;VX[5%_at_[-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_at_T*14Y$.E9#05)$#0H` `
end Received on Sat Dec 12 1998 - 00:00:00 CET