× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.