• 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

Jdbc-Odbc problem : "feature not available"

 
Ranch Hand
Posts: 97
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I found out that it is not possible to use
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE)

uprs.moveToInsertRow();
uprs.updateString(1,v.getNaam());
uprs.updateString(2,type);
uprs.updateInt (3,v.getLengte());
uprs.updateString(4,v.getOmschrijving());
uprs.insertRow();
because there is a Jdbc-Odbc Bridge bug that doesn't support an updatable scrollable ResultSet.
I haven't found a solution to this but what is really strange is that at my work it works (on Windows NT4).
Is there a way of downloading the latest Jdbc-Odbc Bridge driver or is that not possible ?
Also are there any other Jdbc-Odbc drivers available as a free download....
Any help is appreciated...
Thanks,
Kristof
 
Ranch Hand
Posts: 15304
6
Mac OS X IntelliJ IDE Chrome
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I don't know what type of database you are using, but you might want to look into a Type IV driver for your database instead of using the ODBC bridge. A pure Java solution will be faster than the ODBC.
As far as downloading a current "version" of the ODBC bridge, I don't think that is possible without upgrading your OS.
Sorry I couldn't be of more help.
 
Kristof Camelbeke
Ranch Hand
Posts: 97
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Greg,
Do you now where I can find this type Iv-driver ?
Thanks,
Kristf
 
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I believe you can upgrade your odbc drivers here. I think you have to download the latest MDAC (and maybe your Jet driver) to accomplish this. Which database are you using (the above link is for MS Access and MS SQL Server I believe.)
Jamie
 
Kristof Camelbeke
Ranch Hand
Posts: 97
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Jamie Robertson:
I believe you can upgrade your odbc drivers here. I think you have to download the latest MDAC (and maybe your Jet driver) to accomplish this. Which database are you using (the above link is for MS Access and MS SQL Server I believe.)
Jamie


The database is Ms-Access ....
I see that the latest ones are for Win XP is it possible to use them for Win ME ?
Thanks for your reply, I'll give it a shot...
Kristof
reply
    Bookmark Topic Watch Topic
  • New Topic