aspose file tools*
The moose likes JDBC and the fly likes JDBC ODBC Bridge Question 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 Bridge Question" Watch "JDBC ODBC Bridge Question" New topic
Author

JDBC ODBC Bridge Question

Peter N
Greenhorn

Joined: Jul 19, 2001
Posts: 3
I am attemting to connec to an Infomix UniVerse database throught the jdbc odbc bridge but I am running into some problems
I am able to open the connection to the database and I am able to retrive metadata. When I attempt to create a new Statement I get the error "result set type not supported."
I am able to query the database through php's support of odbc.
Is there any other way that I can query the database?
UniVerse has multivalue fields. Does this affect anything?
Robert Brunner
Ranch Hand

Joined: Jul 18, 2001
Posts: 49
Hi Peter,
What vesion of JDBC are you using, and what version of Informix?
In any event, I would suggest you try a type 4 (or possibly a type 3) driver for Informix - see the SUN JDBC driver page for more information.
Peter N
Greenhorn

Joined: Jul 19, 2001
Posts: 3
I am using Informix UniVerse 9.6 and the odbc driver that came with jdk1.3.1. I only see drivers for other informix databases not UniVerse. Any other suggestions
Alexis Jones
Greenhorn

Joined: Jun 27, 2001
Posts: 4
A lot of drivers don't have full support for JDBC 2.0 features such as scrollable result set. Don't try to make a scrollble result set. If you really need one though, you can go to the Sun site and get RowSet implementations such as a CachedRowSet or JDBCRowSet which wrap up result sets inside their bean instance and allow you to scroll even if your driver doesn't support it.
Peter N
Greenhorn

Joined: Jul 19, 2001
Posts: 3
What other ways are there to query the database other than creating a Statement and using that Statement object to get a Result Set? In other words...If my driver does not support result sets, how do I get the information ot of the database?
Thanks for your help.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC ODBC Bridge Question