The coding that is mentioned below may help you :
Code:
'! - Data Source ->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName"> <value> jdbc.driverClassName $ () </ value> </ property>
<property name="url"> <value> jdbc.url $ () </ value> </ property>
<property name="username"> <value> jdbc.username $ () </ value> </ property>
<property name="password"> <value> jdbc.password $ () </ value> </ property>
<property name="validationQuery"> <value> jdbc.validationQuery $ () </ value> </ property>
<property name="maxActive"> <value> jdbc.maxActive $ () </ value> </ property>
'/ Bean>
The "ValidationQuery" is something like "select 1", and database-specific. The important thing is that it works to your DB and that it is fast.
Bookmarks