Im running JBoss 3.2.3 at the moment. I am also using a Postgres 7.3 database. At the moment I have configured JBoss datasource for only 32 connections as this is the default maximum connections with Postgres. I am trying to start some load testing now so I need to increase this. I know how to do this but here is my problem.
I send 32 requests to the database and each request only requires 1 database connection and this works fine. Now some requests need more than one connection so when I send 32 of these type of requests naturally I get exceptions on my server telling me that no connections can be found. Is there any way of configuring my server to handle this nicer ? Any sort of configurations that I should have that enables requests to be queued if no connection is available ?