FULL PRODUCT VERSION :
*** PROBLEM OCCURS WITH THIS JRE ***
C:\Java\jre1.5.0\bin>java -version
java version "1.5.0"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0-b64)
Java HotSpot(TM) Client VM (build 1.5.0-b64, mixed mode, sharing)

***PROBLEM DOES NOT OCCUR WITH THIS JRE (DISTRIBUTED WITH JDK)
C:\Java\jdk1.5.0\bin>java -version
java version "1.5.0"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0-b64)
Java HotSpot(TM) Client VM (build 1.5.0-b64, mixed mode, sharing)

ADDITIONAL OS VERSION INFORMATION :
Windows Server 2003

EXTRA RELEVANT SYSTEM CONFIGURATION :
DB2 JDBC Type 4 Driver
(connecting to OS390)

A DESCRIPTION OF THE PROBLEM :
When connecting to DB2 with JDBC driver, an exception is thrown (see below) when a query is sent to the database (function Statement.executeQuery is called). This error only occurs with the JRE, it does not occur on machines that have the full JDK installed



STEPS TO FOLLOW TO REPRODUCE THE PROBLEM :
write a program that connects to a db2 database using type4 driver (see below for code) using the following files (available from IBM):

db2jcc.jar
db2jcc_license_cisuz.jar
db2jcc_license_cu.jar

create statement from connection and execute a query against db2

EXPECTED VERSUS ACTUAL BEHAVIOR :
EXPECTED -
resultset to be returned
ACTUAL -
exception thrown, no resultset returned

ERROR MESSAGES/STACK TRACES THAT OCCUR :
Exception in thread "main" com.ibm.db2.jcc.b.DisconnectException: encoding not s
upported!!
        at com.ibm.db2.jcc.a.ba.a(ba.java:499)
        at com.ibm.db2.jcc.a.bd.bR(bd.java:2588)
        at com.ibm.db2.jcc.a.bd.c(bd.java:2261)
        at com.ibm.db2.jcc.a.bd.a(bd.java:2131)
        at com.ibm.db2.jcc.a.bd.b(bd.java:2047)
        at com.ibm.db2.jcc.a.bd.a(bd.java:1999)
        at com.ibm.db2.jcc.a.bd.g(bd.java:118)
        at com.ibm.db2.jcc.a.bd.a(bd.java:40)
        at com.ibm.db2.jcc.a.r.a(r.java:31)
        at com.ibm.db2.jcc.a.bp.g(bp.java:141)
        at com.ibm.db2.jcc.b.ce.h(ce.java:853)
        at com.ibm.db2.jcc.b.ce.a(ce.java:1311)
        at com.ibm.db2.jcc.b.ce.executeQuery(ce.java:253)
        at test.writeArrestCharges(test.java:128)
        at test.main(test.java:156)

REPRODUCIBILITY :
This bug can be reproduced always.

---------- BEGIN SOURCE ----------
            Class.forName("com.ibm.db2.jcc.DB2Driver");

            conn = DriverManager.getConnection("jdbc:db2://161.149.181.200:5016/DB2", uid, pwd);


---------- END SOURCE ----------

CUSTOMER SUBMITTED WORKAROUND :
use jre included with jdk
###@###.### 2004-12-13 22:26:32 GMT