Article:		Flawed JDO Points the Way to the "Objectbase"
Subject:		JDBC 2.0 Driver list
Date:		2002-04-30 10:49:20
From:		balesd
Response to: JDBC 2.0 adoption
There are many drivers that support JDBC 2.0. You can find a list at: http://industry.java.sun.com/products/jdbc/drivers

Showing messages 1 through 3 of 3.

• JDBC 2.0 Driver list
  2002-04-30 15:24:13  fontaineb [View]
  
  
  JDBC is just an API. Many of the JDBC drivers listed on Javasoft's Web site, and that are supposed to implement JDBC 2.0 capability indeed implement the API but:
  
  a) throw an Exception when you invoke JDBC 2.0-specific methods. A typical example is the previous() method of ResultSet. Another could be the updateRow() method.
  
  b) don't implement what the JDBC 2.0-specific technique is actually supposed to bring. A typical example is the batch update feature: the updates are often just sent one after the other.
  
  I would be glad to hear about a successful experience with a solution other than Oracle. If I take the example of PostgreSQL, a JDBC 2.0 driver is indeed available, but doesn't implement SQLInput and SQLOutput. Hence...
  (cf. http://lab.applinet.nl/postgresql-jdbc)
• JDBC 2.0 Driver list
  2002-04-30 16:28:52  Donald Bales | [View]
  
  
  What you say is true, many drivers list themselves as v2.0 but really aren't. That's because they are drivers for relational databases not object-relational. As far as I know, no "free" objectbase software exists. But that is not surprising. The current implementations of "free" relational databases still have not reached the Oracle7 milestone of implementation from the early 1990s. More important, Oracle9i is the first mature version of object-relational technology. And, that's why I believe it's time to start using objectbases instead of databases. A truly "usable" objectbase finally exists.

• JDBC 2.0 Driver list
  2002-04-30 14:45:11  fontaineb [View]
  
  
  JDBC is only an API. As a result, many of the JDBC drivers listed on Javasoft's Web site, and that are supposed to implement JDBC 2.0-capability actually only implement the API but:
  
  a) throw an Exception when you invoke JDBC 2.0-specific methods. A typicaFor example when you invoke previous() on a ResultSet.
  
  b) don't when you try to invoke