Re: Connection Pooling/JDBC Connections

I usually use java system properties for this. I set the property in the
web container and then test for it in the code. If it's missing, I know
that I'm in a standalone application.

Gary

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

[mailto:java400-l-bounces@xxxxxxxxxxxx]

On Behalf Of James Perkins
Sent: Monday, December 15, 2008 3:27 PM
To: Java Programming on and around the iSeries / AS400
Subject: Connection Pooling/JDBC Connections

Hi All,
You all graciously helped figure out how to use JNDI over a singleton

class

(and for non-web applications use a singleton class) for connection

pooling.

I now have a question about a way to implement both.

Ideally I would like to have one class that handles connecting to a
database, whether it be from a web application or a standalone

application.

For now I just have a boolean to let me know how I want to make the
connection, e.g. JNDI or a singleton.

So, my question is, is there a better way? I thought of surrounding the

JNDI

code in a try/catch, but that seemed kind of messy.

Just looking for any ideas, or letting me know I'm way off base.

Also, what is the general rule for the username and password for a
connection; store it encrypted in a configuration file, hard-code in the
source, etc.?

Thanks in advance,
James R. Perkins
--
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.

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