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]>
