File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes JDBC - DB2 Native Driver - CCSID Problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC - DB2 Native Driver - CCSID Problem" Watch "JDBC - DB2 Native Driver - CCSID Problem" New topic

JDBC - DB2 Native Driver - CCSID Problem

EVEN Laurent

Joined: Nov 23, 2007
Posts: 1
Hi all,

I'm trying to connect to a DB2 database using the db2_classes.jar (DB2 native driver) and I'm having CSSID problems.
I looked at all the posts about it but I couldn't find any solution.

Here's code
private AS400 server = null;
server = new AS400(IP_ADDRESS);
Driver driver = (Driver) Class.forName("").newInstance();

Here is the error message
Error setting driver and connection using JDBC native driver. The error message is as follows: CCSID value is not valid.

When I'm looking at the server.getCcsid() returned value I've got 297.
In my AS400 user profile (chgusrfprf), the CCSID is initialized to *SYSVAL. It looks ok for me

I managed to connect to this DB2 database with the

Does someone have a clue of what's going on?
subject: JDBC - DB2 Native Driver - CCSID Problem
It's not a secret anymore!