Juan,
You need to modify the server start up to create more connections check
the documentation for postmaster.
The command line switch is -N 128 -B 256 where -N defines the number of
connections, and -B defines the number of buffers. The buffers can be
higher, but at a minimum they need to be 2 x N. As for the driver's
bugs, I have been running a site 24 x 7 for over 1 year with no
problems. That's not to say there aren't bugs...
Thanks,
Dave
-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Juan José Antonio
Lix
Sent: 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)