aspose file tools*
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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Set Cursor Type JDBC:ODBC bridge" Watch "Set Cursor Type JDBC:ODBC bridge" New topic
Author

Set Cursor Type JDBC:ODBC bridge

Anchit Kalra
Greenhorn

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

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


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
Greenhorn

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: 3697
    
    5

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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Set Cursor Type JDBC:ODBC bridge
 
Similar Threads
Cursor methods with the JDBC ODBC
JDBC-ODBC Bridge
JDBC Error related to Tomcat and Oracle 10g
simple error
SQL Error 3088