From: | "Nico" <nicohmail-postgresql(at)yahoo(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Open connections |
Date: | 2004-12-28 13:33:08 |
Message-ID: | cqrnah$179m$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
I forgot to mention one thing: I have no control over the server it's
running on. I only have permission for my account. It is imperative that I
can have 4 open connections with my database, since my servlet generates a
framesetpage where each frame of the three frames is that same servlet with
other parameters to connect to the same database. Most of the time it's not
a problem, but when I get 3 or more visitors at the same time, my
connections start to make trouble. Here is my website:
http://www.haegenssites.com/servlet/menus.DBMenuShow?dbname=haegens_vva&menuid=311
"Dave Cramer" <pg(at)fastcrypt(dot)com> schreef in bericht
news:41D15B20(dot)5000409(at)fastcrypt(dot)com(dot)(dot)(dot)
> Nico,
>
> this is somewhat problematic, the only way to do this is to use the unix
> tool ps to determine the number of processes.
>
> A much better way to do this is to use a robust connection pool like dbcp
> from apache, which will manage your connections for you.
>
> Dave
>
> Nico wrote:
>
>>I would like to know how many connections are open at a certain time from
>>a servlet, so I can anticipate connection errors. How do I do that?
>>
>>Nico.
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 3: if posting/reading through Usenet, please send an appropriate
>> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>> message can get through to the mailing list cleanly
>>
>>
>>
>
> --
> Dave Cramer
> http://www.postgresintl.com
> 519 939 0336
> ICQ#14675561
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2004-12-28 14:05:36 | Re: problem to get nextval of a sequence |
Previous Message | Daniel Schaedler | 2004-12-28 13:32:59 | Re: problem to get nextval of a sequence |