• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

JdbcOdbcDriver option problem

 
Ranch Hand
Posts: 97
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 1211
Mac IntelliJ IDE
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
reply
    Bookmark Topic Watch Topic
  • New Topic