[c3p0-users] Closing the connection when a specific exception occurs

[kalaskar <rah...@gm...>]

Hi,

I am using c3p0 v0.9.1.2 with Oracle. Occasionally, I get Oracle exceptions
with ORA-3113 "Connection Lost" error code. I have the maxConnectionAge set
to 30mins. These errors seem to go away when the connection is refreshed. I
am not able to pin point the root cause of these exception (could be Oracle
driver bug or something in the network is triggering this issue). As a work
around, I am thinking about making a change to c3p0 such that whenever an
exception with specific Oracle ORA error code occurs, c3p0 will close the
connection. I wanted to run this by few other so see if this seems
reasonable thing to do. Any comments?

-Rahul
-- 
View this message in context: http://www.nabble.com/Closing-the-connection-when-a-specific-exception-occurs-tp21098744p21098744.html
Sent from the c3p0 - users mailing list archive at Nabble.com.