Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Received-SPF: pass (hermes.apache.org: local policy)
In-Reply-To: <OF5E09B751.C749E87C-ONC1256FCC.0076C2C3@LocalDomain>
Subject: RE: DB Connections are not being closed...
To: "Apache Torque Users List" <torque-user@db.apache.org>
Message-ID: 
 <OF1AB24A6B.02ECCFBF-ONC1256FCE.002AA47B-C1256FCE.002B4DCF@seitenbau.net>
From: Thomas Fischer <fischer@seitenbau.net>
Date: Thu, 24 Mar 2005 08:52:59 +0100
MIME-Version: 1.0
Content-type: text/plain; charset=ISO-8859-1
Content-transfer-encoding: quoted-printable


Hi,

if you do not open any connection explicitly, Torque makes sure that th=
e
connections are closed.

If you open connections explicitly, make sure that they are closed
afterwards. A secure way is doing it like this.

Connection connection =3D null;
try {
   connection =3D Torque.getConnection();
   // do whatever you want with the connection
  Torque.closeConnection(connection);
  connection =3D null;
}
finally {
  if (connection !=3D null) {
    try {
      Torque.closeConnection(connection);
    }
    catch (Exception e) {}
    connection =3D null;
  }
}

Also, only store connections in local variables in order not to run in =
any
threading problems, not in class or instance variables. And never ever
store them in sessions.

   Thomas

Irineu Avan=E7o Jr. <iavanco@mcn.com.br> schrieb am 22.03.2005 18:30:08=
:

> Hi..
>
>
>
> We are facing an issue  with DB connections  using  Jetspeed 1.5  and=

Torque
> 3.1.    We are making stress tests
>
> with  a  portal application  impelemented under  Jetspeed and Torque
> architecture.
>
> The problem is that the connection with Jetspeed DB is not being clos=
ed
> even after the user gets disconnected.   Instead,  the connection are=

closed
> only if I  shutdown  the Web server,  in this case Tomcat 5.
>
>
>
> We did some changes in  the Torque.properties file to try to make the=
m
close
> properly and it did not work.
>
>
>
> Can anybody help us out with this issue ?
>
>
>
> Thank you.
>
>
>
>
>
> Irineu Avan=E7o Jr.
>
>
>
>
>=


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org