tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <ch...@christopherschultz.net>
Subject Re: Release a database connection from pool
Date Tue, 10 Sep 2013 13:38:33 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

Jose,

On 9/9/13 2:56 PM, Jose MarĂ­a Zaragoza wrote:
> Hello:
> 
> I've got a simple question. I'm using Tomcat 6 & DBCP library ( bit
> I've got the same question with Tomcat JDBC pool )
> 
> 
> My question is:
> 
> when DBCP wants to release a database connection from the pool (
> for example , if it is idle for more than
> minEvictableIdleTimeMillis )
> 
> does it just close the TCP socket connection ( FIN packet )?

It can't: not all JDBC drivers use TCP/IP, so the only thing the DBCP
can do is call Connection.close and hope the driver does something
intelligent.

> If it does, is it enough for remote database server knows that it
> has to release its resources ?

That's up to the database server. I can't imagine a db server that
would not know what to do under these circumstances.

> Or does it do anything more by using propietary driver's commands?
> I asking me if ( some ) database servers need a special command to 
> finish a connection/session ?

Servers need to be tolerant of clients disappearing without warning.
Any sane database would rollback any in-progress transactions and, of
course, release any server-side resources necessary to support that
client.

- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.14 (Darwin)
Comment: GPGTools - http://gpgtools.org
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQIcBAEBCAAGBQJSLyDWAAoJEBzwKT+lPKRYbt0QAIwX+FltnxXCiYR39HqGHPop
HUbFx36HykgODEhwWPaPUqKKs3+7TZO0bOSxGeXIyehN/zwZczswArSGKlWGvlVo
pOWLpp5qgqycL0CgqGG0tnmz369PGNz3FdXHMiZNGIoEiDzhgcz8//6tDKVZoWYK
6m8YrzEirdbTtr+KteIQUVDop1wn1jPdYZ0Nz2GBRoaeYLvjs6kqtbtt64xks4zn
8Fyp5lvnZHtBcLFZAeOaMBx9KdU1QN+ihDKm/ngEi1iPe94VoQxMmi8nEg5T69Ql
rToR7cIOexDbrzoOGTvMjs3LqWVcwD8wQYTh2xJ7SruvG2EMaJjPVswaCK49sTe2
G50EhuihctfJtlxqYP1leGeNYTBrGLSlNsUCKROYZ8POAuMg+pPJoD+geK0fCLIt
ffiET0aLmwT5pGVdNcEmcNnDRAjTnErmc+CNP/p+KhBlwBf3/t1XyqFWRunzN24a
Q97ycxrtueuMOnGxSDeZ7UfPXn644IKi3VEgiKXrlANz51qAXn9eR21sl7KnJLMR
QUZ+dKJWKdMta6rimkQ25zdiyXzlZrds9S39oK4vMhDIUo85BTApU08a1SV8R76t
p41u7M3SxaJzmJELH+/svbb9sSb6NlyzqdYO6QuclBRyqXHGulOQfvGMeX5e7Xig
y9R/xtkAIttxDFTvI6cp
=BAiZ
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message