cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lorenzo De Sio <l.de...@w4b.it>
Subject R: Connection pools - DB2/AS400
Date Thu, 07 Nov 2002 16:32:35 GMT
I just noticed thata catalina.out, after a while shows:

as400: Connection S659465B (526454)  closed.

as if it was alive in the meantime.


L.

-----Messaggio originale-----
Da: Lorenzo De Sio [mailto:l.desio@w4b.it]
Inviato: giovedì 7 novembre 2002 17.31
A: 'cocoon-users@xml.apache.org'
Oggetto: Connection pools - DB2/AS400


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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>

---------------------------------------------------------------------
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message