RE: Accessing a Different DB from the 400

Joe,

Have you looked at Proxool? Their focus is on connection pooling but
looking at their approach may give you some ideas and it is also open
source http://proxool.sourceforge.net/index.html. They support CGLIB
(CGLIB2 as of this weekend) to create dynamic proxies that have some up
front overhead but in the long run they are much faster. With older
CGLIB versions, it takes a lot of calls to offset the startup overhead
but CGLIB2 is supposed to support persistable proxies that will address
the startup overhead but I haven't seen any examples. 

David Morris

...The project is basically a proxy that will pass requests from the
OS/400
application to a server running on a Windows box, which will in turn
access the appropriate JDBC driver.  The project is in its infancy and
only slated to handle basic JDBC1 type functions (simple execute and
query statements).  However, it's Open Source, so you'll be able to do
with it whatever you want...

Joe