users@glassfish.java.net

Re: Getting java.sql.SQLException: Error in allocating a connection.

From: John Arevalo <johnarevalo_at_gmail.com>
Date: Fri, 9 Oct 2009 15:22:38 -0500

On Fri, Oct 9, 2009 at 1:43 PM, <glassfish_at_javadesktop.org> wrote:

> Hi
>
> Initially I tried with max pool size as 150. Once I got this error I
> increased to 200. after 5 to 6 days still I am facing the same issue.
> Initial pool size is 8.
> max pool size is 200
>
> Regards,
> Suresh Kumar
> [Message sent by forum member 'dv320002205' (sureshkumardv_at_gmail.com)]
>
> http://forums.java.net/jive/thread.jspa?messageID=367453
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>
>
Hi,

how are you creating Connection instance?

if you are using java.sql.Connection, java.sql.Statatement and
java.sql.ResultSet, you should close every object after finish your process
to avoid keep Connections and cursors opened to DB.


-- 
John Arévalo
GNU/Linux User #443701
http://counter.li.org/