Moving the Curve

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

Related posts:

1. Simplifying Spring’s JMS configuration for JndiTemplate I’ve spent several days, off and on, wrestling with a...
2. How to configure a secure JMS connection using Spring In a comment to my previous post about configuring JMS...
3. wrong user cached for a team foundation server A problem I just faced: I was trying to use...

Related posts brought to you by Yet Another Related Posts Plugin.

Tags: ibm | iseries | java | jdbc | jtopen | open source | os400

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.