JDBC: Encoding Not Supported when connecting to Big5 database

nielsgron

Hi,

I have created a database on DB2 8.1 and 8.2 for Windows using the
codeset "Big5" with the command:

db2 CREATE DATABASE TWBIG5 USING CODESET BIG5 TERRITORY TW

When I try to connect to the database using the DB2 Universal Type 4
JDBC drivers v2.6 I get an error:
"com.ibm.db2.jcc.b.DisconnectException: encoding not supported!!
DB2ConnectionCorrelator: GA050318.GD66.060104020919". I can create and
connect to a UTF-8 database, but there is a database which is in
production with the Big5 codeset, so I can't recreate that one. I've
tried connecting using all the Java 1.4.2_x and 1.5.0_x builds and
still can't connect.

Would anyone have any ideas on how to fix this or get around the
problem? or if the driver actually doesn't support connecting to Big5?

-Niels

Jan 4 '06 #1

Bernd Hohmann

ni*******@gmail.com wrote:

connect to a UTF-8 database, but there is a database which is in
production with the Big5 codeset, so I can't recreate that one. I've
tried connecting using all the Java 1.4.2_x and 1.5.0_x builds and
still can't connect.

Try an IBM Java JDK, it should work.

Bernd

--
"Ja, alles meine Herren" sprach Fürst Lichnowsky. "Ooch det roochen?"
"Ja, auch das Rauchen." "Ooch im Tiergarten?" "Ja, auch im Tiergarten
darf geraucht werden, meine Herren." Und so endeten die Barrikadenkämpfe
des 18. März in Berlin

Jan 4 '06 #2

nielsgron

Hi Bernd,

IBM only offers a 1.4 JDK and it only runs on IBM sold PCs as far as I
can see. This is the only download I could find for Windows ...
http://www-307.ibm.com/pc/support/si...cid=MIGR-56888

It states "Computer must be an IBM system. This program will not
install on non-IBM systems." ... I downloaded it and the installer
wouldn't install. Buying IBM hardware isn't an option.

Are you suggesting some other IBM Java JDK that I am not aware of?

-Niels

Jan 4 '06 #3

Bernd Hohmann

ni*******@gmail.com wrote:

Are you suggesting some other IBM Java JDK that I am not aware of?

Unfortunately not.

Serge, Knut? Any ideas?

BIG5 was a problem for me too, I have no ideas how to fix this under
Windows.

Bernd

--
"Ja, alles meine Herren" sprach Fürst Lichnowsky. "Ooch det roochen?"
"Ja, auch das Rauchen." "Ooch im Tiergarten?" "Ja, auch im Tiergarten
darf geraucht werden, meine Herren." Und so endeten die Barrikadenkämpfe
des 18. März in Berlin

Jan 5 '06 #4

nielsgron

>> Try this - I don't believe it has any hardware restiction:

http://www-128.ibm.com/developerworks/java/jdk/eclipse/
Jan M. Nelken
DB2 Universal Database Service Consultant
Advanced TCX (Tools/Connectivity/eXtenders) Support

Hi,

Jan sent me the link above. I downloaded the Eclipse package and
grabbed the IBM JRE that was included with it. I used the JRE and it
worked, I was able to connect. This fixes my problem.

Although, it would be nice if in the future the DB2 JDBC driver
supported Big5 with the Sun JRE. Future versions of our software will
require 1.5.

thanks very much for the help.
-Niels

Jan 5 '06 #5

Bernd Hohmann

ni*******@gmail.com wrote:

Although, it would be nice if in the future the DB2 JDBC driver
supported Big5 with the Sun JRE. Future versions of our software will
require 1.5.

The culprit isn't the JDBC driver but rather the codepage conversion
routines in the Sun Java Runtime Environment which are unable to handle
this.

Bernd

--
"Ja, alles meine Herren" sprach Fürst Lichnowsky. "Ooch det roochen?"
"Ja, auch das Rauchen." "Ooch im Tiergarten?" "Ja, auch im Tiergarten
darf geraucht werden, meine Herren." Und so endeten die Barrikadenkämpfe
des 18. März in Berlin

Jan 5 '06 #6