File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Set Cursor Type JDBC:ODBC bridge Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Set Cursor Type JDBC:ODBC bridge" Watch "Set Cursor Type JDBC:ODBC bridge" New topic

Set Cursor Type JDBC:ODBC bridge

Anchit Kalra

Joined: Jan 25, 2009
Posts: 9
hey guys,

does the jdbc:odbc bridge driver support TYPE_SCROLL_SENSITIVE cursor

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

Joined: Jan 25, 2009
Posts: 9
hmm! Did i ask a a wrong question or is there enough information provided!!!

Can some one please reply!!!
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3749

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.

[OCA 8 Book] [Blog]
I agree. Here's the link:
subject: Set Cursor Type JDBC:ODBC bridge
It's not a secret anymore!