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


  1.  Home
  2. JAVA400-L
  3. December 2008

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.



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.