Re: Connection Pooling/JDBC Connections

James- I have not used the tools you mentioned. I have used Spring
JDBC template and iBatis with the AS/400 without any issues. Keep in
mind all the tools you mentioned are ORM persistence tools, meaning
they generate the SQL needed to persist and load your Java objects.
iBatis and Spring JDBC Template do not generate SQL. The programmer
writes all SQL statements. iBatis and Spring JDBC Template just reduce
the amount of boilerplate code needed to talk to a db down to
practially zilch. My Java methods that query table with 20 SQL parms
and put the results into a List of objects is only 1-2 lines of Java
code ( and 4 lines of XML ) when I use Spring JDBC Template.
When I was comparing tools, I counted lines of XML plus lines of Java
code needed to talk to the db.

-Sarah



On Thu, Dec 18, 2008 at 5:48 PM, James Perkins <jrperkinsjr@xxxxxxxxx>
wrote:

Thanks Sarah!

I guess I should really start looking at some of these persistence

libraries

a better look ;-)

Has anyone successfully used any of these on a System i?
- persist http://code.google.com/p/persist/
- EoD SQL https://eodsql.dev.java.net/
- Ebean http://www.avaje.org/

I like the lightweight aspects, from what I have read, of these ones.

James R. Perkins


On Thu, Dec 18, 2008 at 14:15, Sarah Poger Gladstone <
listmember@xxxxxxxxxxxxxx> wrote:

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.

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