Re: Connection Pooling/JDBC Connections

Hi
I am not sure if you have heard of software called ibatis, if not take a look at it,
This would solve your issues since it can work in web application as well as in stand alone application, and it will handle all JDBC connections and connections pooling etc.
You wont have to worry about where the application is running,
There is a properties file associated where you can specfy JNDI for web application and user id, password JDBC connection etc for stand alone applciation.

A$HI$H


--- On Mon, 12/15/08, James Perkins <jrperkinsjr@xxxxxxxxx> wrote:

From: James Perkins <jrperkinsjr@xxxxxxxxx>
Subject: Re: Connection Pooling/JDBC Connections
To: "Java Programming on and around the iSeries / AS400" <java400-l@xxxxxxxxxxxx>
Date: Monday, December 15, 2008, 8:36 PM
Gary,
Thanks that makes sense. Don't know why I didn't
think of that one.

Thanks for the help!

James R. Perkins


On Mon, Dec 15, 2008 at 17:13, Gary L Peskin
<garyp@xxxxxxxxxxxx> wrote:

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.

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