Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC ODBC Bridge Question

 
Peter N
Greenhorn
Posts: 3
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 49
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 4
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic