Daniel_macklin
asked on
JDBC-ODBC bridge Invalid handle
I have written a 3 tier database access system using RMI. I have got JDBC working in Oracle, and postgres, but now I'm trying to port it to MS Access using the jdbc-odbc bridge driver.
I have managed to get a connection to the database, and can add data. However when I try to pull data back via the Resultset I get a Java.SQL.SQLException invalid handle when ever I run the rs.next() method. The code works on the other platforms.
Any ideas ????
I have managed to get a connection to the database, and can add data. However when I try to pull data back via the Resultset I get a Java.SQL.SQLException invalid handle when ever I run the rs.next() method. The code works on the other platforms.
Any ideas ????
You might want to try using code similar to this to get some more specific information about your error:
catch (SQLException e) {
while (e != null)
{
System.out.println(e.getMe ssage());
System.out.println("Error code: " + e.getErrorCode());
System.out.println("SQL State: " + e.getSQLState());
e.printStackTrace();
e = e.getNextException();
}
}
catch (SQLException e) {
while (e != null)
{
System.out.println(e.getMe
System.out.println("Error code: " + e.getErrorCode());
System.out.println("SQL State: " + e.getSQLState());
e.printStackTrace();
e = e.getNextException();
}
}
There could be a minor bug while you are getting the resultset, which you may b overlooking . It would be helpful if you post that part of the code here, and some expert will be able to help you out. Is the query properly created ? it will be helpful if you print out the SQL, I am expecting that with little debugging effort this should be solvable.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER