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.registerDriver(new OracleDriver());
Connection con = DriverManager.getConnection("jdbc:oracle:oci8:@
","prateesh","prateesh");
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select * from tab_date");
while(rs.next())
{
System.out.println(rs.getString(1));
}
con.close();
} catch (SQLException e) {
e.printStackTrace();
}

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