Re: Problems (with Oracle9) using OCI JDBC driver on AIX 5

[c_prateesh]

Hi,
I have oracle 9.2.0.1.0 on AIX 5. I am trying to use the OCI driver to
connect to the database but i get an exception saying closed
connection.
The code is pasted below

try {
DriverManager.r egisterDriver(n ew OracleDriver()) ;
Connection con = DriverManager.g etConnection("j dbc:oracle:oci8 :@
","prateesh","p rateesh");
Statement st = con.createState ment();
ResultSet rs = st.executeQuery ("select * from tab_date");
while(rs.next() )
{
System.out.prin tln(rs.getStrin g(1));
}
con.close();
} catch (SQLException e) {
e.printStackTra ce();
}

The above code works fine when i run it on a windows pc with oracle
9i client installed. Could anyone help me out with this. If the
drivers on AIX are the problem then where can i get the updated and
working drivers.
Thanks in advance
Prateesh

--
Posted via http://dbforums.com