wood burning stoves 2.0*
The moose likes JDBC and the fly likes JDBC Driver for AS400 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC Driver for AS400" Watch "JDBC Driver for AS400" New topic
Author

JDBC Driver for AS400

Robin Richardson
Ranch Hand

Joined: Mar 01, 2001
Posts: 37
Hello, I'm working on a project that requires that the program I'm working on runs on a Solaris 7 server. I have written the program on Windows 2000 due to problems getting a driver for AS400 (DB2, or so I'm told) to work on the Solaris 7 box. Can anyone tell me if there is a driver available? If so, please direct me to that site, and the appropriate download/installation instructions
Thank you
Robin Richardson
Robert Brunner
Ranch Hand

Joined: Jul 18, 2001
Posts: 49
Originally posted by Robin Richardson:
Hello, I'm working on a project that requires that the program I'm working on runs on a Solaris 7 server. I have written the program on Windows 2000 due to problems getting a driver for AS400 (DB2, or so I'm told) to work on the Solaris 7 box. Can anyone tell me if there is a driver available? If so, please direct me to that site, and the appropriate download/installation instructions
Thank you
Robin Richardson

Robin, did you try IBM's site? Also, check out drivers from Merant, and HITSW.
http://industry.java.sun.com/products/jdbc/drivers/search-results/1,2722,,00.html
Robin Richardson
Ranch Hand

Joined: Mar 01, 2001
Posts: 37
I've checked all those sites already. They all seem to be geared toward Windows only, of course since I'm not very familiar with Solaris I may be missing something, and I need to know exactly how to add the driver to the Solaris CLASSPATH (/user/....) so that it will work on this system. I have not been able to find the correct settings.
Thank you
Robin
Robert Brunner
Ranch Hand

Joined: Jul 18, 2001
Posts: 49
Originally posted by Robin Richardson:
I've checked all those sites already. They all seem to be geared toward Windows only, of course since I'm not very familiar with Solaris I may be missing something, and I need to know exactly how to add the driver to the Solaris CLASSPATH (/user/....) so that it will work on this system. I have not been able to find the correct settings.
Thank you
Robin

Robin,
Type 4 rivers are pure Java, they will work on any JVM (in theory at least). Try to download an evaluation version and test it out. I now people who have done JDBC on an AS400.
As far as CLASSPATH, it works just like on Windows. Exact format depends on your shell. Try set CLASSPATH for sh, and setenv CLASSPATH for csh. Driver documentation should help.
 
Consider Paul's rocket mass heater.
 
subject: JDBC Driver for AS400
 
Similar Threads
JDBC - DB2 Native Driver - CCSID Problem
JDBC drivers on Unix
Not able to use OracleDataSource's setConnectionProperties
AS400 Object - UserId & Password w/ password=*NONE on AS400
French Character Problem....