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
posted
0
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
posted
0
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
posted
0
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
posted
0
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.
0
