Re: Connections with Tomcat 3.2.4 and PostgreSQL 7.1.3

Justin,

I didn't say JBoss 3 / Tomcat 4 was the way to go !
I just mentionned that JBoss offered a tight integration with "Tomcat" (&
also with the latest version known as catalina).
I you need connection pooling, just chuck a look @ :
http://www.coreservlets.com
And especially this page : http://archive.coreservlets.com/Chapter18.html,
look at the following
                * ConnectionPool.java A class for preallocating, recycling,
and managing JDBC connections.
                * ConnectionPoolServlet.java A servlet that reads
information from a database and presents it
                    in an HTML table. It uses connection pooling to optimize
the database retrieval. A good timing
                    test case is ....

This however the quick & dirty way to do it
(All my respect to Marty Hall) but  believe it's alway proper to use the
native AS dependent connection pooler which is often better that an example
one !

Rgds,

Thomas,


--
Thomas SMETS
rue J. Wytsmanstraat 62
1050 Bruxelles
yahoo-id : smetsthomas
----- Original Message -----
From: "Justin Clift" <justin@postgresql.org>
To: <tsmets@brutele.be>
Cc: "pgsql jdbc" <pgsql-jdbc@postgresql.org>; <hyellina@iprimus.com.au>
Sent: 06 March, 2002 10:33 AM
Subject: Re: [JDBC] Connections with Tomcat 3.2.4 and PostgreSQL 7.1.3


> Hi Thomas,
>
> We're using Tomcat 3.2.4, and we're just about to go into production.
> There isn't any possible way of convincing the management people we
> should go to Catalina, unless there is absolutely no other way of making
> the system work stable.
>
> I'm not familiar with JBoss, but I'll pass your message onto the Java
> guys so they can look it up and check it out.
>
> :-)
>
> Regards and best wishes,
>
> Justin Clift
>
>
> tsmets@brutele.be wrote:
> >
> > Why don't you use the JBoss - Catalina association ...
> > JBoss provides Connection Pooling...via proper MBean configuration
> > I believe then you don't need to release the ***connection*** - at worst
the
> > pooled connection :-)).
> > As I am working on the issue at the moment I cannot tell you more about
it
> > but I guarantee you that this is the way to work ;-))
> >
> > Rgds,
> >
> > Thomas,
> >
> > --
> > Thomas SMETS
> > rue J. Wytsmanstraat 62
> > 1050 Bruxelles
> > yahoo-id : smetsthomas
> >
> > ----- Original Message -----
> > From: "Justin Clift" <justin@postgresql.org>
> > To: "Tony Grant" <tony@animaproductions.com>
> > Cc: <pgsql-jdbc@postgresql.org>; "Hari Yellina"
<hyellina@iprimus.com.au>
> > Sent: 06 March, 2002 7:46 AM
> > Subject: Re: [JDBC] Connections with Tomcat 3.2.4 and PostgreSQL 7.1.3
> >
> > > Hi Tony,
> > >
> > > The java guys here are wondering why it's necessary to explicitely
close
> > > the connections to the database in their .jsp's, as the java garbage
> > > collector should do this automatically?
> > >
> > > :-)
> > >
> > > Regards and best wishes,
> > >
> > > Justin Clift
> > >
> > > --
> > > "My grandfather once told me that there are two kinds of people: those
> > > who work and those who take the credit. He told me to try to be in the
> > > first group; there was less competition there."
> > >      - Indira Gandhi
> > >
> > > ---------------------------(end of
broadcast)---------------------------
> > > TIP 3: if posting/reading through Usenet, please send an appropriate
> > > subscribe-nomail command to majordomo@postgresql.org so that your
> > > message can get through to the mailing list cleanly
> > >
>
> --
> "My grandfather once told me that there are two kinds of people: those
> who work and those who take the credit. He told me to try to be in the
> first group; there was less competition there."
>    - Indira Gandhi
>