Re: Websphere Connection Pooling

I have seen this same error in the WAS console when setting up datasources.
When setting up the JDBC provider there is an environment variable listed
- something like ${JDBC_PROVIDER}.
I replaced that with the true path to the jt400.jar file -
/QIBM/ProdData.../jt400.jar and then the connection worked.

Thanks,
Todd Allen
EDPS
Electronic Data Processing Services
tallen@xxxxxxxxxxxx




Dhanushka Manjula
<dhanuxp@xxxxxxxx
m> To
Sent by: java400-l@xxxxxxxxxxxx
java400-l-bounces cc
@midrange.com
Subject
Websphere Connection Pooling
2009-08-26 04:46


Please respond to
Java Programming
on and around the
iSeries / AS400
<java400-l@midran
ge.com>






Hi All,

I want to create a JDBC connection pooling from WAS 6.0 to access physical
files in QS36F library. I selected the Database type as DB2.
It shows following providers to access the data base

1. DB2 legacy CLI-based Type 2 JDBC Provider
2. DB2 Universal JDBC Driver Provider
3. DB2 UDB for iSeries (Toolbox)
4. DB2 UDB for iSeries (Native)

I want to find out what is the most suitable/Best provider from the above

Anyway, I have selected âDB2 UDB for iSeries (Native)â & created a
Connection & checked the connection using âTest Connectionâ button, it
gives

----------------------------------------------------------------------------------------------------------------------------------

Test connection failed for data source DB2 UDB for iSeries
(Native) DataSource on server server1 at node TestNode01
with the following exception:
java.lang.ClassNotFoundException: DSRA8000E: No jar or zip
files found in /db2_classes.jar. View JVM logs for further
details.
----------------------------------------------------------------------------------------------------------------------------------Â

I think I have made a mistake somewhere & any assistance would be greatly
appreciated.

Thanks
Dhanuxp


This communication and any transmitted documents are intended to be confidential. If there is a problem with this transmission, please contact the sender. If the reader of this message is not the intended recipient, or the employee or agent responsible to deliver it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.