Why not close the connection as soon as you are done with the database
operation. That way you don't need that many connections open all the
time. Getting a new connections does not take much time if you are using
some kind of connection pooling. I have one application which uses
atmost 6 connections when there are 100 users working.
I don't know your requirement. Just a suggestion.
> -----Original Message-----
> From: Nick Fankhauser [SMTP:nickf(at)ontko(dot)com]
> Sent: Tuesday, October 30, 2001 12:52 PM
> To: Juan José Antonio Lix; pgsql-jdbc(at)postgresql(dot)org
> Subject: Re: [JDBC] Something unusual has occured to cause the
> driver to fail
> Go to this page and look for MAX_CONNECTIONS:
> I think it will help.
> > -----Original Message-----
> > From: pgsql-jdbc-owner(at)postgresql(dot)org
> > [mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of Juan José
> > Lix
> > Sent: Tuesday, October 30, 2001 5:14 AM
> > To: pgsql-jdbc(at)postgresql(dot)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
> > 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
> > this
> > exception: java.sql.SQLException: Sorry, too many clients already
> > at org.postgresql.Driver.connect(Driver.java:125)
> > at
> > at
> > 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
> > unfortunately we would have to migrate our current development to
> > 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
> > TIP 2: you can get off all lists at once with the unregister command
> > (send "unregister YourEmailAddressHere" to
> ---------------------------(end of
> TIP 5: Have you checked our extensive FAQ?
pgsql-jdbc by date
|Next:||From: fergussom f||Date: 2001-10-30 22:49:08|
|Subject: where do I start?|
|Previous:||From: Jeremy Buchmann||Date: 2001-10-30 21:26:06|
|Subject: Re: Something unusual has occured to cause the driver to fail|