Re: connection pooling dilemma

From:

Robert Klemme <shortcutter@googlemail.com>

Newsgroups:

comp.lang.java.programmer

Date:

Fri, 08 Feb 2008 18:46:09 +0100

Message-ID:

<613ir3F1tacfjU2@mid.individual.net>

On 08.02.2008 15:54, Lew wrote:

josh wrote:

in every jsp [sic] file I make

Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/articoli");
conn = ds.getConnection();

is there a way to init a DataSource one time only and than reuse it in
all my pages?

should it improve further on my appl?

Yes, follow Robert Klemme's advice to look into MVC and take all the
scriptlet out of your JSPs.

This kind of thing is much easier to manage from a plain-ol' Java
class. You could init() the DataSource from a static initializer or such.

There are also a number of declarative ways to create a DataSource,
e.g., via the context.xml of a Tomcat app.

And of course one can use listeners for various events, namely
application startup, shutdown, session creation, destruction, request
processing (filters) etc. But IMHO the best way is the declarative as
you pointed out.

Kind regards

robert