I don't know if this will work, but it is worth a shot. There should be a
jt400.jar file on the 400. It should be in
/QIBM/ProdData/HTTP/Public/jt400/lib. It will probably be a different
(older?) version of the driver you have, but it might work.
I don't think that the JT Open drivers are JDBC2.0 drivers, so if the
pooling that is done is taking advantage of the pooling capabilities of
JDBC2.0, it might not work. I can't say that for certain though since I
have not looked into it very much, so I could be very wrong about that.
If you don't have luck with the JT Open DB2 drivers, there are some other
db2 drivers that might work. You can find db2_classes.jar in
/QIBM/ProdData/Java400/ext, along with some other jars that may be useful.
Dan Feather
[EMAIL PROTECTED]
|---------+----------------------------------------------------------------->
| | cocoon-users-return-42279-dfeather=oreillyauto.com@XML|
| | .APACHE.ORG |
| | |
| | 11/07/02 10:32 AM |
| | Please respond to cocoon-users |
| | |
|---------+----------------------------------------------------------------->
>-----------------------------------------------------------------------------------------|
|
|
| To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
|
| cc:
|
| Subject: R: Connection pools - DB2/AS400
|
>-----------------------------------------------------------------------------------------|
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: '[EMAIL PROTECTED]'
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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
---------------------------------------------------------------------
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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
---------------------------------------------------------------------
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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
