File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes JDBC ODBC Bridge Question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC ODBC Bridge Question" Watch "JDBC ODBC Bridge Question" New topic

JDBC ODBC Bridge Question

Peter N

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

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

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

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:
subject: JDBC ODBC Bridge Question
It's not a secret anymore!