> Now with a "monitor" on dbms (pgmonitor) I can see the connections.... > > Logically every post of a jsp page creates a new connection > until I get the maxActive number of connection. When I reach > the maxActive the jsp expects for the "maxWait" time > (indefinite time with -1) and the system is blocked up > waiting for a "new connection". In this way I have 10 idle > connections, and the system locked.... wonderful! > > Now, the connection pooler should use an "idle" connection > when I reach the maxActive number, shouldn't it? Yes - it should. This a problem of the pooler.
> > At the end of the rendering-page process dbforms should close > the connections, shouldn't it? No not with the datalist. Connection is left open for some time. This is necessary to retrieve the next records. > > When I use the getConnection method of dbforms to get a > run-time connection, dbforms should return me an instance of > the connection pooler, is this true? Of the connection poolers connection. Not the pooler it's self... > > Three question, three problems.... > I have had this problem to with connection pooling. And i found that i did'nt want to have 100 of possible connections as maxActive... So i craete the SingleConnectionProvider provider - On connection for each system. If you want to have a little better performance you should use the SinglePerThreadConnection provider. This connection provider creates on connection for each running tomcat thread. This are connections you ever need because each thread handles only request at a given time. And because each connection can handle more then one statement and resultset this works perfect. Oh by the way, the SingleConnection providers do exactly this. Create a connection - held this connection open fore ever and only closes the unneeded statements and resultset during connection close. This should solve your problem Cheers, Henner ------------------------------------------------------- This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools! Get your free copy of BEA WebLogic Workshop 8.1 today. http://ads.osdn.com/?ad_id=5047&alloc_id=10808&op=click _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
