| guest |
Tue Sep 02 01:33:26 BST 2008 |
| |
I need to create 2 different db pools connecting to 2 different db urls which would be
consumed by two different applications deployed in a single tomcat instance.
Can it be done using primrose? |
| |
| sedj |
Tue Sep 02 21:03:55 BST 2008 |
| |
Yes, just define two pools in the primrose.config file
Eg :
poolName=pool1
base=40
log=/tmp/pool1_${yyyy-MM-dd}.log
idleTime=300000
logLevel=verbose,info,warn,error,crisis
driverClass=org.postgresql.Driver
driverURL=jdbc:postgresql://localhost:5432/test
user=mysuer
password=mypassword
killActiveConnectionsOverAge=120000
cycleConnections=1000
queueConnectionRequests=true
waitForConnectionIfDatabaseIsDown=false
poolName=pool2
base=40
log=/tmp/pool2_pool_${yyyy-MM-dd}.log
idleTime=300000
logLevel=verbose,info,warn,error,crisis
driverClass=org.postgresql.Driver
driverURL=some_other_url
user=mysuer
password=mypassword
killActiveConnectionsOverAge=120000
cycleConnections=1000
queueConnectionRequests=true
waitForConnectionIfDatabaseIsDown=false |
