Re: Something unusual has occured to cause the driver to fail - Mailing list pgsql-jdbc

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@ontko.com]
> Sent:    Tuesday, October 30, 2001 12:52 PM
> To:    Juan José Antonio Lix; pgsql-jdbc@postgresql.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@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)
> >
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html