tags:

views:

32

answers:

1
+1  Q: 

glassfish connection pool additionnal delay while re-creating after idle timeout

Hi, We are currently deploying some applications on a glassfish 3.0.1 using a postgres database through postgresql-9.0-801.jdbc4.jar
Our actual configuration regarding the connexion pool is :

Idle Timeout : 120 seconds
Max Wait Time : 60000 millisecondes
Initial and Mimimum Pool Size : 1
Maximum Pool Size : 1
Pool Resize Quantity : 1

We have noticed that the database connexions are droped and created every 140 seconds instead of 120 seconds.

Is there something we have missed ?

Thank you

A: 

It's probably being active for 20 seconds. Checking that the connection is valid etc.

karianna  2010-10-06 13:10:36
We are carefully monitoring the network for activity, and we have absolutely no traffic, the server is started alone and nothing get through it and the database. Additionally, the database and the glassfish are not on the same machine.
Alexandre GUIDET  2010-10-06 14:24:20
Have you got a DBA which can analyse the connection at the DB end? With Sybase we've found that things like having XA txns switched on can affect these timings
karianna  2010-10-06 14:29:36
After some test with and without xa transactions I noticed as well a significant increase of the recycling delay. Without xa, the idle timeout work fine. with xa, 120 seconds became 180 and 240 seconds became 480. We are going to take care of this weird behavior. If someone know what make glassfish (or postgres JDBC) behave like that, please enlighten us. thanks.
Alexandre GUIDET  2010-10-07 10:08:12

related questions

Java Time Zone is messed up
Eclipse on win64
Automate builds for Java RCP for deployment with JNLP
Why are professors or schools picking Java over C++ to teach to students?
Is there a real benefit of using J#?
Public/Popular Websites using JavaServer Faces
Why can't I use a try block around my super() call?
Accessing post variables using Java Servlets
Personal Linux web server
Is this really widening vs autoboxing?
How can I Java webstart multiple, dependent, native libraries?
Why can't I call toString() on a Java primitive?
How do I use Java to read from a file that is actively being written?
What code analysis tools do you use for your Java projects?
IllegalArgumentException or NullPointerException for a null parameter?
How do I configure and communicate with a serial port?
What is the best way to parse strings in Java
Getting started with a custom JXTA PeerGroup
Creating a custom button in Java
How to get started "writing" a code coverage tool?
Which Build-/Configuration Management Tool?
What is the difference between an int and an Integer in Java/C#?
What is the meaning of the type safety warning in certain Java generics casts?
How would you access Object properties from within an object method?
Converting CSV File to XML in Java