wood burning stoves 2.0*
The moose likes JDBC 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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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: 3700

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.

My Blog: Down Home Country Coding with Scott Selikoff
I agree. Here's the link: http://aspose.com/file-tools
subject: Set Cursor Type JDBC:ODBC bridge
Similar Threads
JDBC Error related to Tomcat and Oracle 10g
Cursor methods with the JDBC ODBC
SQL Error 3088
simple error