Re: Something unusual has occured to cause the driver to fail

From: Jeremy Buchmann <jeremy(at)wellsgaming(dot)com>
To: Juan José Antonio Lix <jjantoli(at)excite(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Something unusual has occured to cause the driver to fail
Date: 2001-10-30 21:26:06
Message-ID: 200110302126.f9ULQ15e016482@mail.greatbasin.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Juan,

Look at the postmaster man page ('man postmaster') and look at
the -N switch. That controls the maximum number of backends that
can be started. The default is 32, which sounds consistent with your
problem.

--Jeremy

On Tuesday, October 30, 2001, at 02:14 AM, Juan José Antonio Lix wrote:

> Hello,
>
> I'm a it consultant and right now I'm involving in a Customer Care
> project.
> A month ago we decide to use a Linux platform to support the database
> server
> and adopt PostgreSQL as our database server. Last month we had the first
> testing "experience". We were trying to simulate 100 concurrent users,
> but
> when just 30 were connected we receive the following crash:
> "Something unusual has occured to cause the driver to fail. Please
> report
> this
> exception: java.sql.SQLException: Sorry, too many clients already
> at org.postgresql.Driver.connect(Driver.java:125)
> at java.sql.DriverManager.getConnection(DriverManager.java:517)
> at java.sql.DriverManager.getConnection(DriverManager.java:177)
> at DbManager.connect(DbManager.java:35)
> at Hilo.<init>(TheFrame.java:242)
> at TheFrame.main(TheFrame.java:181)"
>
> If it means that PostgreSQL doesn't support more that 30 concurrent
> users
> unfortunately we would have to migrate our current development to
> another
> database server, such as MySQL or Oracle. But if, as I suppose, this is
> just
> a JDBC driver's bug we would like to know if another "free-bug" driver
> is
> available.
>
> This is critical for us, so please, reply me as soon as possible.
>
> Thank you,
> Juan José Antolínez
>
>
>
>
>
> _______________________________________________________
> http://inbox.excite.com
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Jayesh K. Parayali 2001-10-30 22:08:01 Re: Something unusual has occured to cause the driver to fail
Previous Message Dave Cramer 2001-10-30 21:00:28 Re: Something unusual has occured to cause the driver to fail