Re: Struts 1.0.2 JDBC Connection Pool

["David Morris" <David.Morris@xxxxxxxxxxxxx>]

Stephen,

I have not used the Struts connection pool in a while but it is based
on
the Commons DBCP project, which I have used quite a bit. I use the
following connection properties (we set our library list in the exit
programs).

    private final String NATIVE_CONNECTION_STRING =
"jdbc:db2:*local;naming=system;date format=usa;translate binary=true";
    private final String CONNECTION_STRING =
"jdbc:as400://pctci.pctci.com;naming=system;date format=usa";

I also remember having to put an extra comma (",") at the beginning of

the library list something like ",,lib1,lib2".

David Morris

>>> Gibson.Stephen@burlington.com 12/11/02 08:35AM >>>
Greetings,

I am attempting to use the Struts 1.0.2 JDBC connection pool using the
native DB2 drivers for the AS400...
The application(s) works fine as long as all the necessary tables
(files)
are in the first library in the user profile library list....

Stephen Gibson