aspose file tools*
The moose likes JDBC and the fly likes Jdbc-Odbc problem : Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Jdbc-Odbc problem : "feature not available"" Watch "Jdbc-Odbc problem : "feature not available"" New topic
Author

Jdbc-Odbc problem : "feature not available"

Kristof Camelbeke
Ranch Hand

Joined: Nov 28, 2001
Posts: 97
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

Joined: Jul 11, 2001
Posts: 15299
    
    6

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.


GenRocket - Experts at Building Test Data
Kristof Camelbeke
Ranch Hand

Joined: Nov 28, 2001
Posts: 97
Greg,
Do you now where I can find this type Iv-driver ?
Thanks,
Kristf
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

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

Joined: Nov 28, 2001
Posts: 97
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Jdbc-Odbc problem : "feature not available"