On Tue, 9 Nov 1999, tluyben wrote:
> The following piece of code quits at the last
> connection with;
> java.sql.SQLException: Too many clients connected already.
> This seems to be around 17 connections.
> Why? What about 100 servletthreads getting a connection
> from a connectionpool. And the system quitting at connection
> 17???
> Or am I doing something wrong? I hope so, because this would
> mean that postgres is far from fit for the task I want to use it
> for...
This looks like a backend problem, rather than JDBC. I know that postgres
can limit the number of simultaneous connections, but it's not normally
that low.
I'm cc'ing the interfaces list.
Peter
> Best regards,
> Tycho Luyben
>
>
> public class Test1 {
>
> public static void main(String[] args) {
> try {
> Class.forName("postgresql.Driver");
> Vector v = new Vector();
> for (int i=0;i<18;i++) {
> Connection con =
> DriverManager.getConnection("jdbc:postgresql:coredb", "", "");
> Statement stmt = con.createStatement();
> stmt.executeUpdate("insert into _group (name) values ('GroupX');");
> stmt.close();
> v.addElement(con);
> }
> }catch(Exception e) {
> e.printStackTrace();
> }
> }
> }
>
-- Peter T Mount peter@retep.org.uk Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgresJava PDF Generator: http://www.retep.org.uk/pdf