Return-Path: <andras@reea.net>
Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Delivered-To: mailing list torque-user@db.apache.org
Received: (qmail 68535 invoked from network); 20 Jun 2003 08:07:56 -0000
Received: from reea.ms.fx.ro (HELO gw.reea.net) (193.230.173.18)
  by daedalus.apache.org with SMTP; 20 Jun 2003 08:07:56 -0000
Received: (qmail 27395 invoked from network); 20 Jun 2003 07:08:03 -0000
Received: from andras.ms.reea.net (HELO andras) (192.168.0.2)
  by gw.ms.reea.net with SMTP; 20 Jun 2003 07:08:03 -0000
Message-ID: <005a01c33703$178249f0$0200a8c0@andras>
From: "Andras Balogh" <andras@reea.net>
To: "Turbine Torque Users List" <torque-user@db.apache.org>
References: <3EF24322.8070002@slb.com>
Subject: Re: How does Torque handle connections
Date: Fri, 20 Jun 2003 11:08:11 +0300
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1158
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

Hi,

Make sure you are using the second type of pool (Jdbc2Pool).


Andras.




> Hi,
> 
> I am a new Torque user. I have successfully installed Torque and 
> everything looks OK.
> I am using 3.04 b version of torque.
> 
> I have set the connection time out as 3600 s (the default value?). For 
> some reason, the
> number of connections increases and at some point I am getting error 
> messages that
> says maximum number of connections reached or request pending free 
> connections.
> 
> This does not make any sense, as the query requests have been processed 
> and the
> connections may have been released.
> 
> Is there a utility or a piece of code some one has written that can keep 
> track of the
> connection requests that are send to the db and tells me when they are 
> released and
> is available to other requests. Is there a way to force release of 
> connection too.  
> 
> Thanks in avance.