Re: Connections with Tomcat 3.2.4 and PostgreSQL 7.1.3 - Mailing list pgsql-jdbc
From | |
---|---|
Subject | Re: Connections with Tomcat 3.2.4 and PostgreSQL 7.1.3 |
Date | |
Msg-id | 01e401c1c4fa$56b8bc20$6501a8c0@calvin Whole thread Raw |
In response to | Re: Connections with Tomcat 3.2.4 and PostgreSQL 7.1.3 (Justin Clift <justin@postgresql.org>) |
List | pgsql-jdbc |
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 >
pgsql-jdbc by date: