On Thu, 2002-10-10 at 23:37, Gerard van de Looi wrote:
> I think it's good to be able to choose from the application server
> connection pool or from the multipool.
> Not all application servers do support connection pools these days. (Most of
> them do!)
I tried to use something like a connection pool, but i dont know how to
configure it(or orion and tomcat dont have a connection pool). These are
currently my config files from both. Could you tell me how i should
change the configuration of these files'?
(or am i already using a connection pool?)
Currently im using the following lines inside Orion (data-sources.xml) :
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="MMBase/PostgreSQL"
location="jdbc/MMBase"
xa-location="jdbc/xa/HypersonicXADS"
ejb-location="jdbc/HypersonicDS"
connection-driver="org.postgresql.Driver"
username="mmbase"
password="mmbase"
url="jdbc:postgresql://eduard.omroep.nl:5432/mmbase"
inactivity-timeout="30"
/>
and in Tomcat (server.xml):
<ResourceParams name="jdbc/MMBase">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.postgresql.Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:postgresql://edyard.omroep.nl:5432/mmbase</value>
</parameter>
<parameter>
<name>username</name>
<value>mmbaseuser</value>
</parameter>
<parameter>
<name>password</name>
<value>mmbase</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
</ResourceParams>
--
Eduard Witteveen Systeem Ontwikkelaar
Publieke Omroep, Gateway C Kamer 101
+31(0)356772910 http://www.omroep.nl/
Sed quis custodiet ipsos custodes? : The sixth Satire from Juvenal
