I believe that this methods return wrong information.:
DatabaseMetada.supportOpenCursorsAcrossCommit() return false /
would return TRUE
DatabaseMetada.supportOpenCursorsAcrossRollBack() return false /
would return TRUE
Code like this was user to say that.
rs = executeQuery( ... );
while ( rs.next() ) {
con.rollback();
con.commit();
System.err.println( n++ ) ;
}
Count all the rows in the result set.
Dario.