JDBC 3.0 support with WebSphere Application Server
 Technote (troubleshooting)
 
Problem(Abstract)
Which version of IBM® WebSphere® Application Server supports JDBC 3.0?
 
Cause
If you are using JDBC 3.0's functionality with WebSphere Application Server V5.0 on distributed platforms (UNIX®, Windows®), you may get some error.

For instance, if you are trying to retrieve automatically generated keys from a DB2 table with DB2 V8 FixPak 10 with the following code:


Connection.prepareStatement(sql-statement, Statement.RETURN_GENERATED_KEYS);

You may get the following exception:

'prepareStatement(String, int)' is not supported on the WebSphere java.sql.Connection implementation.

There is no problem on WebSphere Application Server V6.0.2.
 
Resolving the problem
The JDBC 3.0 is supported in WebSphere Application Server V6.0 and beyond because the JDBC 3.0 requires the JDK 1.4. However, it is supported on WebSphere Application Server on z/OS v5.1.
 
 
Cross Reference information
Segment Product Component Platform Version Edition
Application Servers Runtimes for Java Technology Java SDK
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > DB Connections/Connection Pooling
Operating system(s): Windows
Software version: 6.1
Software edition:
Reference #: 1238875
IBM Group: Software Group
Modified date: May 31, 2006