Dear All,
I'm trying to set.up a connection pooler.
I tried with protomatter and also with COMMONS.dbcp....
These are my settings:
<dbconnection
id = "jakarta-commons-dbcp"
isJndi = "false"
isPow2 = "true"
default = "false"
connectionProviderClass =
"org.dbforms.conprovider.JakartaConnectionProvider"
connectionPoolURL = ""
conClass = "org.postgresql.Driver"
name = "jdbc:postgresql://localhost/UWCAD"
username = "useri"
password = "asdfa">
<property name="charSet" value="ISO-8859-1" />
<pool-property name="validationQuery" value="" />
<pool-property name="maxActive" value="10" />
<pool-property name="maxIdle" value="5" />
<pool-property name="maxWait" value="-1" />
<pool-property name="useLog" value="true" />
<pool-property name="validationQuery" value="SELECT COUNT(*) FROM
__sys_data_configuration" />
<pool-property name="defaultAutoCommit" value="false" />
</dbconnection>
::::::::::
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?
At the end of the rendering-page process dbforms should close the connections,
shouldn't it?
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?
Three question, three problems....
Anticipated thanks
Ivan
----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.
-------------------------------------------------------
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_idP47&alloc_id808&op=click
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
