From: | "Jayesh K(dot) Parayali" <jparayali(at)TOTALFLOOD(dot)com> |
---|---|
To: | <nickf(at)ontko(dot)com>, Juan José Antonio Lix <jjantoli(at)excite(dot)com>, <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Something unusual has occured to cause the driver to fail |
Date: | 2001-10-30 22:08:01 |
Message-ID: | 8ACB76BF6B98C94FB6959B660C051BA507D5E1@PACIFIC.TOTALFLOOD.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(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
From | Date | Subject | |
---|---|---|---|
Next Message | fergussom f | 2001-10-30 22:49:08 | where do I start? |
Previous Message | Jeremy Buchmann | 2001-10-30 21:26:06 | Re: Something unusual has occured to cause the driver to fail |