I checked and my current available JDBC Driver is support Java 5 , this is the last Driver supporting DB2 V8 : https://www-304.ibm.com/support/docview.wss?uid=swg1PM32360 and it don't mention the supported Java version , so I'm stuck. any help will be very much appreciate .
On Tue, Jul 12, 2011 at 9:58 AM, Matan Cohen <[email protected]>wrote: > thanks , I'll check it and get back with answers. > > > On Tue, Jul 12, 2011 at 12:32 AM, Robert Burgess <[email protected]>wrote: > >> Hello, >> >> Given that class name in the error message starts with com.ibm.db2.jcc, I >> believe that you are using the newer "Data Server Driver for JDBC and SQLJ" >> and not the older "JDBC/SQLJ Driver for OS/390 and z/OS". >> >> By running "java com.ibm.db2.jcc.DB2Jcc -configuration" (using the same >> CLASSPATH etc. as used when running actual application) I believe you should >> be able to see what version of the JDBC driver you are running and what Java >> (JRE) versions are supported with that JDBC driver version. >> >> At >> http://www-01.ibm.com/support/**docview.wss?uid=swg21428742<http://www-01.ibm.com/support/docview.wss?uid=swg21428742>, >> there is a list of the current "Data Server Driver for JDBC and SQLJ" >> driver versions compatible with different DB2 versions. >> >> Given the error message, I'm guessing you will need to upgrade to a newer >> JDBC driver version in order to run it using Java 6 (aka 1.6). >> >> If you need more help, please tell me.. >> >> Regards, >> Robert >> >> >> >> On 2011-07-11 10:59, Matan Cohen wrote: >> >>> Hi, >>> please excuse me for any lack of knowledge in this area, >>> >>> I have a compenet running under USS which used the JDBC jars from DB2 >>> 8.10V >>> . >>> I needed to upgrade it to run under J6.0 >>> >>> */Z110/usr/lpp/java/J6.0/bin:>**./java -version >>> * >>> *java version "1.6.0" >>> * >>> *Java(TM) SE Runtime Environment (build pmz3160-20071123_01) >>> * >>> *IBM J9 VM (build 2.4, J2RE 1.6.0 IBM J9 2.4 z/OS s390-31 >>> jvmmz3160-20071121_1501* >>> *5 (JIT enabled) >>> * >>> *J9VM - 20071121_015015_bHdSMr >>> * >>> *JIT - r9_20071121_1330 >>> * >>> *GC - 20071031_AA) >>> * >>> *JCL - 20071118_01 * >>> >>> when starting the compenet with Java 6 i get this error : >>> com.ibm.db2.jcc.b.**SqlException: ÝDB2/T2zOS¨ÝJDBC/SQLJ¨ Incompatable >>> JVM. The >>> Dri >>> ver REQUIRES Java 2 support and is not compatible with the JVM:1.6.0 >>> >>> >>> from DB2 literature : >>> *"**JDBC/SQLJ Driver for OS/390 and z/OS (deprecated)* >>> * >>> >>> The JDBC/SQLJ Driver for OS/390® and z/OS is a type 2 driver that >>> contains >>> most of the functions that are described in the JDBC 1.2 specification. >>> This >>> driver also includes some of the functions that are described in the JDBC >>> 2.0 specification. >>> >>> The JDBC/SQLJ 2.0 Driver for OS/390 and z/OS supports these functions: >>> >>> - Global transactions that run under WebSphere Application Server >>> Version >>> 4.0 and above >>> - Implementation of Java user-defined functions and stored procedures >>> - SQLJ statements that perform equivalent functions to all JDBC >>> methods >>> - Connection pooling >>> >>> To use this driver, you need Java 2 Technology Edition, SDK 1.3 or later. >>> To >>> implement Java stored procedures or user-defined functions, you need Java >>> 2 >>> Technology Edition, SDK 1.3.1, SDK 1.4.1 or later." >>> * >>> I wonder if this is one of the reason it is label as depracated ? >>> >>> >>> >> >> > > > -- > best regards, > matan cohen > MF System Administrator. > > -- best regards, matan cohen MF System Administrator. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html

