JDBC & Documentation

[Former Member]

Hello together!

I'm searching a download for the JDBC-Driver for MaxDB 7.5 and/or the documentation.

Especially i would like to know to wich value i must set the Fetchdirection of a Statement or a ResultSet so that i can also move backwards in the ResultSet or how i get the RowCount of an ResultSet.

Thanks a lot for your answers

Christian

[alexander_schroeder]

Hello Christian,

you can use the JDBC driver from the currently available (7.6) package. The driver is compatible with all released version of MaxDB.

For scrollable result sets, you need to use the right scrollability flag when creating a PreparedStatement ('prepare' functions) or execute a Statement. With SCROLL_SENSITIVE you may see changes by others (in isolation level, of course), with SCROLL_INSENSITIVE you do not see changes made by others (but this may have a price tag).

Regards

Alexander