• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

JDBC - DB2 Native Driver - CCSID Problem

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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);
server.setUserId(USER_ID);
server.setPassword(PASSWORD);
Driver driver = (Driver) Class.forName("com.ibm.db2.jdbc.app.DB2Driver").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 com.ibm.as400.access.AS400JDBCDriver

Does someone have a clue of what's going on?
 
Without subsidies, chem-ag food costs four times more than organic. Or this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic