Connection pools - DB2/AS400

[Lorenzo De Sio <l....@w4b.it>]

Hi all.

I'm running into big trouble trying to let Cocoon access a DB2 database
running on an AS/400 box.

Cocoon (2.0.3) is running on

Red Hat Linux 8.0, Tomcat 4.1.12, Sun JDK 1.3.1_01 (.i386. does it matter?).
I even rolled back from 1.3.1_05 guessing it had same problems as 1.4.

The webapp has 2 connection pools: one points to a MySQL DB on the same box
(it works fine), the other one to DB/2 on the AS/400 (configured following
http://outerthought.net/wiki/Wiki.jsp?page=As400 , thus using IBM JTOpen
3.2's com.ibm.as400.access.AS400JDBCDriver, which should be a Type 4 (?)
driver).

As I try from a simple command line test I wrote, the connection with the
above DB/2 driver works perfectly. The trouble comes when I try to run a
simple SQLTransformer query (same syntax as command-line test) from inside
C2.

core.log shows a well-known

WARN    (2002-11-07) 18:41.18:653   [core.datasources.w4b] (/cnce/test)
Thread-4/ResourceLimitingJdbcDataSource: Could not return Connection
org.apache.avalon.excalibur.datasource.NoValidConnectionException: No valid
JdbcConnection class available

[full stack trace available]

I added a driver-supported "trace" option in the JDBC URL, so catalina.out
shows little more: exact copies of core.log's stack traces, interspersed
with trace output from the driver (at least showing it gets loaded),
followed by another exception:


as400: Driver AS/400 Toolbox for Java JDBC Driver (3650553) : Using IBM
Toolbox for Java JDBC driver implementation.
as400: Toolbox for Java - Open Source Software, JTOpen 3.2, codebase
5722-JC1 V5R2M0.1
as400: JDBC Level: 20
as400: Connection 172.16.2.5 (268406) : Setting server NLV = 2932.
as400: Connection 172.16.2.5 (268406) : Client functional level = V5R2M01
.
as400: Connection 172.16.2.5 (268406) : Data compression = RLE.
as400: Connection 172.16.2.5 (268406) : Using extended datastreams.
as400: Connection 172.16.2.5 (268406) : JDBC driver major version = 5.
as400: Connection 172.16.2.5 (268406) : OS/400 VRM = V5R1M0.
as400: Connection 172.16.2.5 (268406) : Server CCSID = 280.
as400: Connection 172.16.2.5 (268406) : Server functional level = V5R1M00009
(9).
as400: Connection 172.16.2.5 (268406) : Server job identifier =
003984/QUSER/QZDASOINIT.
as400: Connection S659465B (268406)  open.
as400: Connection S659465B (268406) : Auto commit = "true".
as400: Connection S659465B (268406) : Read only = "false".
as400: Connection S659465B (268406) : Transaction isolation = "1".
getConnection returning
driver[className=com.ibm.as400.access.AS400JDBCDriver,AS/400 Toolbox for
Java JDBC Driver]
org.apache.avalon.excalibur.datasource.NoValidConnectionException: No valid
JdbcConnection class available

[full catalina.out available]

Another strange thing is that, if I set pool limits to min=1 and max=1, I
get no driver trace output, but only exceptions. If I increase pool max, I
get driver logs such as the one above, with traces from different
connectionIDs (268406 above)interspersed among each other.

I thought it was something related to JDK version, but I found in this list
no message talking about problems with 1.3.1.

Thanks in advance to anyone willing to give even a little help,

L.

---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <co...@xml.apache.org>
For additional commands, e-mail:   <co...@xml.apache.org>