A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
JDBC - DB2 Native Driver - CCSID Problem
Joined: Nov 23, 2007
Nov 23, 2007 08:05:00
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.
private AS400 server = null;
server = new AS400(IP_ADDRESS);
Driver driver = (Driver) Class.forName("com.ibm.db2.jdbc.app.DB2Driver").newInstance();
Here is the error message
Error setting driver and connection using
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 com.ibm.as400.access.AS400JDBCDriver
Does someone have a clue of what's going on?
I agree. Here's the link:
subject: JDBC - DB2 Native Driver - CCSID Problem
java.sql.SQLException: No suitable driver
How to connect to remote Database Using IPAddress
How to connect to AS400
How do I setup a DB2 datasource in WSAD test environment?
WebSphere V6.1 Db2 V8.1 Connection Problem
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015