Re: Websphere Connection Pooling

["Joe Sam Shirah" <joe_sam@xxxxxxxxxxxxx>]

   Hi Dhanuxp,

   It's certainly possible.  I suggest you bring in an offshore team.  Even 
if they don't know the answer, they will be cheap.  I believe the current 
chain is the Philippines, India, China, Africa.  Unfortunately, you often 
can't be sure who you're talking with since they often use yahoo or hotmail 
addresses even for business use, but so what?


                                                        Joe Sam

Joe Sam Shirah -        http://www.conceptgo.com
conceptGO       -        Consulting/Development/Outsourcing
Java Filter Forum:       http://www.ibm.com/developerworks/java/
Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
Going International?    http://www.jguru.com/faq/I18N
Que Java400?            http://www.jguru.com/faq/Java400

----- Original Message ----- 
From: "Dhanushka Manjula" <dhanuxp@xxxxxxxxx>
To: "Java Programming on and around the iSeries / AS400" 
<java400-l@xxxxxxxxxxxx>
Sent: Wednesday, August 26, 2009 7:30 AM
Subject: RE: Websphere Connection Pooling


Murali, Thank you in advance for your input.
I am trying to use the DB2 for iseries (Toolbox) to create connection 
pooling.
But I can't understand the concept of creating pooling. In searching 
Archives & relevant books on WAS it seems like what I expect to do is not 
possible.
Could any body tell me a link/ RedBook/ RedPaper to read in creating 
connection pooling using WebSphere 6.0?

Thanks
Dhanuxp



--- On Wed, 8/26/09, Murali Rao <Murali.Rao@xxxxxxxxxxxxxxxxxxxxx> wrote:

From: Murali Rao <Murali.Rao@xxxxxxxxxxxxxxxxxxxxx>
Subject: RE: Websphere Connection Pooling
To: "'Java Programming on and around the iSeries / AS400'" 
<java400-l@xxxxxxxxxxxx>
Date: Wednesday, August 26, 2009, 2:07 AM



WE use DB2 for iseries (Toolbox) connection using jt400.jar or JTOpen.jar... 
This jar has got lots of Java classes to connect to db2.
Murali

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx] 
On Behalf Of Dhanushka Manjula
Sent: 26 August 2009 09:47
To: java400-l@xxxxxxxxxxxx
Subject: Websphere Connection Pooling

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 is the Java Programming on and around the iSeries / AS400 (JAVA400-L) 
mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe, 
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a 
moment to review the archives at http://archive.midrange.com/java400-l.


Consider the environment and think before you print this email.

Registered Address: Fortis House Tollgate Eastleigh Hampshire SO53 3YA 
Registered Number: 354568 England
Authorised and regulated by the Financial Services Authority

This e-mail together with any attachments are intended for the addressee 
only and may be private and confidential. If you are not the intended 
recipient, or the person responsible for delivering it to the intended 
recipient, you must not open any attachments, or copy, disclose, distribute, 
retain or use this e-mail, including any attachments, in any way whatsoever; 
please return it to us immediately using the reply facility on e-mail.

Consider the environment and think before you print this email.