My most recent project required me to use JDBC to connect to the database server on an OS/400 server. I had a heck of a time finding drivers, going around and around again on IBM’s site. The client probably had the drivers, but they were relying on us to tell them what went where and when.
All the documentation I could find seemed to say I needed IBM’s proprietary drivers, and a license key to boot. I found this a tad frustrating, to say the least.
Finally, a coworker’s google-fu broke the logjam as we discovered that there is, indeed, open source drivers for JDBC with the OS/400. The project is called JTOpen.
For the database connection string, the following format worked for us:
jdbc.url=jdbc:as400:DBNAME jdbc.username=DBUSER jdbc.password=DBPASSWORD