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

Juan-

Go to this page and look for MAX_CONNECTIONS:

http://www.postgresql.org/idocs/index.php?runtime-config.html

I think it will help.

-Nick



> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Juan José Antonio
> Lix
> Sent: Tuesday, October 30, 2001 5:14 AM
> To: pgsql-jdbc@postgresql.org
> Subject: [JDBC] Something unusual has occured to cause the driver to
> fail
>
>
> 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@postgresql.org)
>