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

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.

Jayesh
> -----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
>
> 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(at)postgresql(dot)org
> > [mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of Juan José
> Antonio
> > 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
> 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)
> >
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html