Hey JDBC Developers... what does JDBC 3.0 mean to you?

Blog Post created by spilon on Nov 18, 2010

Hello, JDBC Developers of the world!


If you are familiar with JDBC and the Java Platform, you probably know that the latest version of the JDBC API is 4.0 and the latest version of the Java Platform is 6 (these were released December 11th, 2006). This is what our PI JDBC Driver supports.


In this first year of existence of our PI JDBC Driver, we received a few requests to support the older JDBC 3.0 API, which was included in on Java SE 1.4 (a.k.a 4). We originally planned to implement this "retrograde feature" in the 2010 R2 release (v1.1) that's coming up by the end of the year, but decided against that for a couple reasons:

  1. We had a lot of new exciting features to implement, and any time spent on this would obviously prevent our small (but oh so smart!) team to work on these...
    Per the PI System Roadmap, expect this release by the end of the year
  2. Some of the major players people would integrate PI JDBC with (e.g. SAP Business Objects, IBM Cognos), ended up upgrading their offerings to support the JDBC 4.0 API.
  3. There is a workaround to use SQL Server (which you most likely have, because of AF ) as a bridge with Microsoft's SQL Server JDBC Driver, which supports both 3.0 and 4.0

So, the question to you all: do you think it's valuable for us to consider implementing the older JDBC 3.0 API and support for older Java runtimes such as JRE5 and/or JRE4, in a subsequent release of PI JDBC? If so, why? Please include your platform and other Application Server details which prevent you from upgrading to JRE6.

System.out.println("Looking forward to hearing from you all!");