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@fastcrypt.com> schreef in bericht
news:41D15B20.5000409@fastcrypt.com...
> 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@postgresql.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
>
