Re: My connections are all idle...

> Connection c     = null;
> OtherResource or = null;
>
> try
> {
>    c  = cpds.getConnection();
>    or = getOtherResource()
>
>    // do stuff
>    // ...
> }
> finally
> {
>   try { if (or != null) or.close(); }
>   catch (Exception e) { e.printStackTrace(); }
>
>   try { if (c != null) c.close(); }
>   catch (Exception e) { e.printStackTrace(); }
> }
>
> Note that the finally clause will definitely be executed if the  
> Connection is acquired, and there is a best-attempt close() of each  
> resource: If or fails to close(), that Exception won't prevent the  
> attempt to close() the Connection.

>
> Hi, I'm having problems using C3P0's ComboPooledDataSource. My  
> application is
> kinda big, so consider medium to high volumes of clients. The pool of
> connections works well, for days maybe, but sometimes it stops giving
> connections, as if all available connections were in use. However,  
> when I
> check on the DB server (Postgres 8.1) I see all the connections (the  
> same
> number set to maxPoolSize) as "Idle". Not "Idle in transaction", just
> "Idle". What could cause C3P0 not to give this connection to whoever  
> asks
> for a connection on my application?
>
> By the way, I forgot to mention. The DataSource is instantiated when  
> the
> application starts up, and then never closed. Is this the correct  
> way to
> use? I never call a clean up method, as I'm always doing something  
> with the
> DB.
> --
> View this message in context: http://old.nabble.com/My-connections-are-all-idle...-tp27623125p27623125.html
> Sent from the c3p0 - users mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Download Intel® Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> c3p0-users mailing list
> c3p0-users@...
> https://lists.sourceforge.net/lists/listinfo/c3p0-users