Re: Problem with JTA/JTS

Dave Cramer <Dave@micro-automation.net> writes:
> Ok, the problem is that PostgresDataSource does NOT pool connections.

Well, that answers that ...

On reflection though, the behavior Johan reports seems curious.  Is it
really possible that new connections could be launched faster than old
ones shut down?  The backend startup time is not trivial, and he is
executing a query on each connection too.  It's hard to believe that the
backend shutdown time exceeds startup + query time.

Can you think of any reason why the client-side connection closure might
not get signaled to the backend immediately?  If, say, there were some
kind of TCP timeout involved, then the report would make a whole lot
more sense.

            regards, tom lane