Re: Connections with Tomcat 3.2.4 and PostgreSQL 7.1.3

Dave,

I know it's not rocket science...
(not that I took the remark personnally ;-) )
What I meant is that you are usually beter off with the default Connexion
poller provided by the AS (potentially JBoss in our conversation) than a
default one ... This is a personnal opinion & not a proven matter :-))

Rgrds,

Thomas,

--
Thomas SMETS
rue J. Wytsmanstraat 62
1050 Bruxelles
yahoo-id : smetsthomas
----- Original Message -----
From: "Dave Cramer" <Dave@micro-automation.net>
To: "'Justin Clift'" <justin@postgresql.org>; <tsmets@brutele.be>
Cc: "'pgsql jdbc'" <pgsql-jdbc@postgresql.org>; <hyellina@iprimus.com.au>
Sent: 06 March, 2002 1:30 PM
Subject: RE: [JDBC] 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)
>
>
>