-----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-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
