Re: Connection Pooling/JDBC Connections

James - Another open-source tool that handles all the connection
issues is Spring JDBC template. ( Its part of the Spring framework,
but you can ignore the rest and only use the JDBC parts.) You
configure the connection details in an XML file and the code doesn't
care if its using a JNDI datasource ( ie a web app) or a directly
connecting ( ie a batch app)

-Sarah


On Thu, Dec 18, 2008 at 9:04 AM, James Perkins <jrperkinsjr@xxxxxxxxx> wrote:

Ashish,
Thank you very much. I have heard of it before, but I never really looked
into it. I like the concept a lot though!

James R. Perkins


On Wed, Dec 17, 2008 at 19:53, Ashish Kulkarni
<kulkarni_ash1312@xxxxxxxxx>wrote:

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.

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