|
|
REMOTE DATABASE ACCESS
Accessing remote AS/400 databases using JTOpen
By David Gewirtz
If you're running a relatively complex Web site, at some point you're going to need to perform remote queries of databases running on remote machines. Over the past few weeks, we've gotten a number of requests about accessing AS/400-hosted databases from a WebSphere machine, remotely.
Although it's always nice to have WebSphere loaded on the remote machine, it's not necessary. Rather, most standard AS/400 configurations (and yes, there are still loads of people using these systems) run with DB2.
You can connected to the AS/400's DB2 environment with drivers found in the JTOpen, the Open Source version of the IBM Toolbox for Java, located at http://www.ibm.com/developerworks/oss/jt400/. You'll want to look for the drivers found in jt400.jar.
Don't forget you may have to open a hole in your firewall if you're doing a remote (outside the LAN) query, or use a VPN to punch your way through.
David Gewirtz is the author of How To Save Jobs and Where Have All The Emails Gone? For more than 20 years, he has analyzed current, historical, and emerging issues relating to technology, competitiveness, and policy. David is the Editor-in-Chief of the ZATZ magazines, is the Cyberterrorism Advisor for the International Association for Counterterrorism and Security Professionals, and is a member of the instructional faculty at the University of California, Berkeley extension. He can be reached at david@zatz.com and you can follow him at http://www.twitter.com/DavidGewirtz.
|
|
|
|
