Re: Connections with Tomcat 3.2.4 and PostgreSQL 7.1.3

Pooled connections aren't rocket science. There are quite a few freely
available, poolman for one.


Assuming you only want to connect to one db:
They can be as simple as a linked list where you get the connection off
the head, and return it back to the tail. There's a little bit of
housekeeping when they come back to make sure there aren't any warnings,
and that the connection is in a non-transaction mode, etc.


Dave

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Justin Clift
Sent: Wednesday, March 06, 2002 4:33 AM
To: tsmets@brutele.be
Cc: pgsql jdbc; hyellina@iprimus.com.au
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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)