sql exception..

[naveen <na...@ibro.co.jp>]

hi all,
What does this exception mean, I am using Tomcat 3.2.3. and postgres 7.1.2,
Well I havent put my server on the net as yet, so there is no question of
too many connections. Can anybody tell me where I am going wrong, or what
should I do to set this right...


SQL Exception : Something unusual has occured to cause the driver to fail.
Please report this exception: Exception: java.sql.SQLException: Sorry, too
many clients already


--
To unsubscribe:   <ma...@jakarta.apache.org>
For additional commands: <ma...@jakarta.apache.org>
Troubles with the list: <ma...@jakarta.apache.org>

Re: sql exception..

[Mark Muffett <ma...@muffett.net>]

It could be that your servlets are not releasing connections, or just that
too many of them are trying to open them - are you using connection pooling?

Have a look at the number of connections (ps aux | grep postgres will work
on Unix / Linux, I don't know about Windows).

The default limit on connections to postgres is quite small and I have found
that I've had to increase it to run it sensibly with Tomcat.

Mark

----- Original Message -----
From: "naveen" <na...@ibro.co.jp>
To: "Tomcat Users List" <to...@jakarta.apache.org>
Sent: Friday, November 02, 2001 9:03 AM
Subject: sql exception..


> hi all,
> What does this exception mean, I am using Tomcat 3.2.3. and postgres
7.1.2,
> Well I havent put my server on the net as yet, so there is no question of
> too many connections. Can anybody tell me where I am going wrong, or what
> should I do to set this right...
>
>
> SQL Exception : Something unusual has occured to cause the driver to fail.
> Please report this exception: Exception: java.sql.SQLException: Sorry, too
> many clients already
>
>
> --
> To unsubscribe:   <ma...@jakarta.apache.org>
> For additional commands: <ma...@jakarta.apache.org>
> Troubles with the list: <ma...@jakarta.apache.org>
>


--
To unsubscribe:   <ma...@jakarta.apache.org>
For additional commands: <ma...@jakarta.apache.org>
Troubles with the list: <ma...@jakarta.apache.org>