Resource temporarily unavailable - Mailing list pgsql-jdbc

From Nico
Subject Resource temporarily unavailable
Date
Msg-id cqiahi$ct6$1@news.hub.org
Whole thread Raw
Responses Re: Resource temporarily unavailable  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-jdbc
I have a servlet that generates a framesetpage. Each of the three frames on
that framesetpage is also a link to a the same servlet, only with other
parameters. The framesetpage has two parts: a topframe and a bottomframe.
The bottomframe has again two parts: a leftframe and a rightframe. The
topframe gets data from two tables, so does the left and the right. They
each make a connection and a resultset for each (6 of them) query based on
those tables. Additionally, they use a common table for metadata.
After a few refreshes(three or four), he gives me an error: resource
temporarily unavailable. How can I resolve this issue? Sometimes, I don't
even have to refresh to get the error. The server my servlet is running
under has a threadpool. But how do I prevent this error from occurring
again? I don't need much, but I have to at least support 5 users at a time.
I have tought about threading or connection pools, but I know very little
about it.

Any help is appreciated.
Nico.



pgsql-jdbc by date:

Previous
From: "Xavier Poinsard"
Date:
Subject: Update french .po
Next
From: Tom Lane
Date:
Subject: Re: Resource temporarily unavailable