tomcat 3? guess that was a stone age :-) My second question is : do i have to close the connection when may request is finished ? Does this really close the connection or just free the object i used, but save the oracle connection open ?
Yes, please close the connection. Actually, this method gets trapped by PooledConnection interface and the connection will be returned back to the db pool and it WONT get closed. HTH Navjot Singh