|
(→Database Connections (base.xml))
|
(→Database Connections (base.xml))
|
| Line 116: | |||
| --> | --> | ||
| </bean> | </bean> | ||
| - | <bean id="dataSource1" class="com.urbancode.anthill3.spring.DecryptPasswordDataSource" | + | </pre> |
| - | destroy-method="close"> | ||
| - | <property name="driverClassName"> | ||
| - | <value>${install.db.driver}</value> | ||
| - | </property> | ||
| - | <property name="url"> | ||
| - | <value>${install.db.url}</value> | ||
| - | </property> | ||
| - | <property name="username"> | ||
| - | <value>${install.db.user}</value> | ||
| - | </property> | ||
| - | <property name="password"> | ||
| - | <value>${install.db.password}</value> | ||
| - | </property> | ||
| - | <property name="maxActive"> | ||
| - | <value>20</value> | ||
| - | </property> | ||
| - | <property name="maxIdle"> | ||
| - | <value>20</value> | ||
| - | </property> | ||
| - | <property name="minIdle"> | ||
| - | <value>20</value> | ||
| - | </property> | ||
| - | <property name="defaultTransactionIsolation"> | ||
| - | <value>2</value> | ||
| - | </property> | ||
| - | <property name="testOnBorrow"> | ||
| - | <value>true</value> | ||
| - | </property> | ||
| - | <property name="validationQuery"> | ||
| - | <value>${install.db.validationQuery}</value> | ||
| - | </property> | ||
| - | <!-- not available in our version or the database connection pool library | ||
| - | <property name="validationQueryTimeout"> | ||
| - | <value>10</value> | ||
| - | </property> | ||
| - | --> | ||
| - | <!-- track abandoned connections. this adds a overhead. only enable if connections are being leaked. | ||
| - | <property name="logAbandoned"> | ||
| - | <value>true</value> | ||
| - | </property> | ||
| - | <property name="removeAbandonedTimeout"> | ||
| - | <value>300</value> | ||
| - | </property> | ||
| - | <property name="removeAbandoned"> | ||
| - | <value>false</value> | ||
| - | </property> | ||
| - | --> | ||
| - | </bean> | ||
| - | <!-- DataSource used for identity generation so it does not create deadlocks --> | ||
| - | <bean id="identityDataSource" class="com.p6spy.engine.spy.P6DataSource" destroy-method="close" scope="singleton"> | ||
| - | <constructor-arg> | ||
| - | <ref local="dataSource1"/> | ||
| - | </constructor-arg> | ||
| - | </bean></pre> | ||
| = Linux Tunables For Increasing Threads & Sockets = | = Linux Tunables For Increasing Threads & Sockets = | ||
