RE: Handling Database Connections

Classes here are loaded by the Web classloader. This should work as it
provides one classloader per web application, not per instance. It seems
like there might be something with the class that you coded up.

However, if you're using WAS, you should be creating a data source using the
administrative console and then looking up the data source via JNDI, not
creating your own connections to the database because these cannot be
managed by WAS. If you use the administration console, your data source
will be properly shared across all applications.

Have a look at
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/index.jsp?topic=/com.i
bm.websphere.base.iseries.doc/info/iseries/ae/tdat_ccrtpds.html

Gary

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx

[mailto:java400-l-bounces@xxxxxxxxxxxx]

On Behalf Of James Perkins
Sent: Tuesday, November 25, 2008 7:12 PM
To: Java Programming on and around the iSeries / AS400
Subject: Re: Handling Database Connections

For the one I tested it on we are using WebSphere Application Server V6.0.
We also use V6.1 and probably soon V7.

I put the class in the normal WEB-INF/classes/ directory.

James R. Perkins


On Tue, Nov 25, 2008 at 17:46, Gary L Peskin <garyp@xxxxxxxxxxxx> wrote:

What JSP/servlet container are you using (and what release)? You need

to

be
sure that your class is in the correct place so that it's only loaded

once.

Gary

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx

[mailto:java400-l-bounces@xxxxxxxxxxxx]

On Behalf Of James Perkins
Sent: Tuesday, November 25, 2008 5:25 PM
To: Java Programming on and around the iSeries / AS400
Subject: Re: Handling Database Connections

Thanks all for your help. I did write a singleton to handle this, but

ran

into a problem.

I'm not sure the singleton is being reused. I keep getting multiple
connections each time the class that uses the singleton is called.

This class is called from a JSP, so maybe this has to do with the
classloader? I found an article JavaWorld that talks about this, but

I'm

still a bit confused.
http://www.javaworld.com/javaworld/jw-04-2003/jw-0425-
designpatterns.html?page=7

Could someone kindly point me in the right direction. I have feeling

this

might be an easy thing, but I'm just not sure.

James R. Perkins