This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes JdbcOdbcDriver option  problem 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 "JdbcOdbcDriver option  problem " Watch "JdbcOdbcDriver option  problem " New topic
Author

JdbcOdbcDriver option problem

Kristof Camelbeke
Ranch Hand

Joined: Nov 28, 2001
Posts: 97
Hello,
I can make a connection to a Ms-Access database and retrieve the data into the ResultSet.
But now I decided I wanted to make my ResultSet scrollable so I can insert and delete so I updated my statement handler as follows :

Statement stmt = con.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
But when I now make a connection I receive an error that tells me that the option is not available.
I there a way to solve this or should I try something else ?
Thanks for any input....
Kristof
Sonny Gill
Ranch Hand

Joined: Feb 02, 2002
Posts: 1211

Hi mate,
From what I know, to get a scrollable resultset, there are two conditions. The database you are using must support it, and the JDBC driver you are using must support it. So, there is not much you can do, other that to move to another database,like Oracle, with those capabilities.
hope that helps.


The future is here. It's just not evenly distributed yet. - William Gibson
Consultant @ Xebia. Sonny Gill Tweets
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: JdbcOdbcDriver option problem
 
Similar Threads
Closing a db connection
consuquences of not closing ResultSet?
reusing the Statement object
Regarding java.sql.Connection
Problem in Seperating Core Servlet to Database Query Java