Return to the iSeriesTools Tips
AppServer4RPG
Application Server to make Java Components available for AS400 RPG programs.
3 steps to acccess any database over jdbc from STRSQL, QMQRY and embedded SQL - install ArdGate its open Source and available at: http://sourceforge.net/projects/appserver4rpg/ you could choose between runnable jar or running on Tomcat or other J2EE compliant WebServer - add the JDBC database to the remote database directory with ADDRDBDIRE - install the JDBC driver Archive to ArdGate and provide url and driver class name Access the database with normal SQL as any other database in the remote database directory. Its very scalable with high performance, it uses one prestarted JVM to serve multiple RPG or other native AS/400 clients using my other Java Freeware AppServer4RPG (which is extendable for other applications to provide java access to RPG)
Dieter Bender
http://www.bender-dv.de
[report a broken link by clicking here]