Re: Open connections
От | Nico |
---|---|
Тема | Re: Open connections |
Дата | |
Msg-id | cqrnah$179m$1@news.hub.org обсуждение исходный текст |
Ответ на | Open connections ("Nico" <nicohmail-postgresql@yahoo.com>) |
Ответы |
Re: Open connections
|
Список | 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@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 >
В списке pgsql-jdbc по дате отправления: