Re: Open connections

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
>

In response to

Responses

Browse pgsql-jdbc by date

  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