RE: [WDSCI-L] Best Practice for iSeries Data Access

[Colin Williams <colin.williams@xxxxxxxxxxxx>]

David,

If your using Websphere, you are already provided with a datasource that
implements connection pooliing.

I use IBMs DBbeans provided with WDSC in my web application, 
and the com.ibm.as400.access.AS400JDBCConnectionPoolDataSource driver in
jt400.jar as the driver for my datasource in WAS.

Its nice because your application does not have to be aware of the db config
at all, just the name of the datasource,
which I pull in from a properties file that is external to the application
anyway

Cheers
Colin.W

-----Original Message-----
From: David Kelly [mailto:Davidk@xxxxxxxxxxxxxxxxxxx] 
Sent: 21 January 2004 14:51
To: Websphere Development Studio Client for iSeries (E-mail)
Subject: [WDSCI-L] Best Practice for iSeries Data Access


Hello,
I'm researching best practice for iSeries EIS data access from a Model 2
framework.  I believe it would behoove me to have a pool of connections to
my iSeries DB ready for web traffic, rather than performing them for each
request. I'm confused with all the literature referencing DTO & DAO I am
finding when reviewing the RedBooks found via a connection factory search.  
At my front controller Action Servlet init(), I thought I would prepare a
data base connection pool for latter use in the Servlets' doGet/doPost
method.  I planned to insert my specific code in doGet/doPost to log stats
about my form by HttpServletRequest.getParameter("session"), which I would
be updating in subsequent pages.  I'm hoping I can retrieve the session and
use it as a key in my iSeries tracking file, any tips appreciated.  The
forwarding pages would be determined via ActionForward returned from my
Action class.  Any URL's or recommending reading would be appreciated.  I'm
currently finding stuff like JCA, resource adaptors.  Is this the location I
should dig in with my research? It's certainly a fun course of discovery
learning Java and the different frameworks available.  In RPG, we rarely
name our design patterns, it sure helps when communicating ideas to have a
common syntax for these designs.  The more I play with the Java, the more I
learn how much more I need to learn.  This keeps it fresh and exciting.
Thanks to all for years of sharing of ideas and tips.  
David Kelly  

_______________________________________________
This is the Websphere Development Studio Client for iSeries  (WDSCI-L)
mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/wdsci-l.
This e-mail has been sent by a company of Bertram Group Ltd, whose registered 
office is The Nest, Rosary Road Norwich NR1 1TF.
This message, and any attachments, are intended solely for the addressee and 
may contain privileged or confidential information.  If you are not the 
intended recipient, any disclosure, copying, distribution or any action taken 
or omitted to be taken in reliance on it, is prohibited and may be unlawful.  
If you believe that you have received this email in error, please contact the 
sender immediately.
Opinions, conclusions and statements of intent in this e-mail are those of the 
sender and will not bind a Bertram Group Ltd company unless confirmed in 
writing by a director independently of this message.
Although we have taken steps to ensure that this email and any attachments are 
free from any virus, we advise that in keeping with good computing practice the 
recipient should ensure they are actually virus free.