Set Cursor Type JDBC:ODBC bridge

[Anchit Kalra]

hey guys,

does the jdbc:odbc bridge driver support TYPE_SCROLL_SENSITIVE cursor
eg.

    creatStatement(ResultSet.TYPE_SCROLL_SENSITIVE)

because my progra, is thrwoing an exception .... Result se t type is fwd only. :banghead:

if it doesnt then is there any other driver i can use to connect to a MS access DB.

[Anchit Kalra]

hmm! Did i ask a a wrong question or is there enough information provided!!!


Can some one please reply!!!

[Scott Selikoff]

Please post the exception. If the bridge/driver doesn't support it, there's not much you can do. You either have to update/replace the drive or write code that doesn't use database specific functionality (by writing better tailored queries perhaps). I opt for the second since it makes your code more robust.