Hi,
Does anyone have an example of a connection pool definition for mysql database server and are there any extra jar files that would be needed to use the connection pool ? I already have my app running using jdbc connections.
Did you find Ch 25 in the UsersGuide? It can easily be adapted 25.1. ConnectionFactory 25.1.2.1. ProtomatterConnectionProvider
<!--
- uses the Protomatter ConnectionPool
-
- see http://protomatter.sourceforge.net/ for further information
-->
<dbconnection
id = "protomatter"
isJndi = "false"
isPow2 = "true"
default = "true"
connectionProviderClass = "org.dbforms.conprovider.ProtomatterConnectionProvider"
connectionPoolURL = "jdbc:protomatter:pool:postgresPool"
conClass = "org.postgresql.Driver"
name = "jdbc:postgresql://localhost/myDatabase?charSet=ISO-8859-1"
username = "postgres"
password = ""/>
25.1.2.2. JakartaConnectionProvider
<!-
- uses the Jakarta commons-dbcp ConnectionPool
-
- see http://jakarta.apache.org/commons/index.html for further informations
-
- Note: this provider does NOT use the connectionPoolURL attribute.
-->
<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/myDatabase?charSet=ISO-8859-1"
username = "postgres"
password = ""/>
-- Shawn
Happily using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g. Take an Oracle 10g class now, and we'll give you the exam FREE. http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
