Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Jdbc-Odbc problem : "feature not available"

 
Kristof Camelbeke
Ranch Hand
Posts: 97
  • Mark post as helpful
  • send pies
  • 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
 
Gregg Bolinger
GenRocket Founder
Ranch Hand
Posts: 15302
6
Chrome IntelliJ IDE Mac OS X
  • Mark post as helpful
  • send pies
  • 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
  • Quote
  • Report post to moderator
Greg,
Do you now where I can find this type Iv-driver ?
Thanks,
Kristf
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • 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
  • 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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic