sonicneo

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">

        <property name="driverClassName"><value>${db.driver}</value></property>

        <property name="url"><value>${db.url}</value></property>

        <property name="username"><value>${db.user}</value></property>

        <property name="password"><value>${db.password}</value></property>

        <property name="poolPreparedStatements"><value>true</value></property>

        <property name="maxActive"><value>10</value></property>

        <property name="maxIdle"><value>10</value></property>

</bean>                                   

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">

        <property name="driverClass">

            <value>net.sourceforge.jtds.jdbc.Driver</value>

        </property>

        <property name="jdbcUrl">

               <value>jdbc:jtds:sqlserver://${database.host}:${database.port}/${database.name};ssl=request</value>

        </property>

        <property name="user">

            <value>${database.username}</value>

        </property>

        <property name="password">

            <value>${database.password}</value>

        </property>

        <property name="acquireIncrement">

            <value>3</value>

        </property>

        <property name="minPoolSize">

            <value>1</value>

        </property>

        <property name="maxPoolSize">

            <value>15</value>

        </property>

        <property name="maxStatementsPerConnection">

            <value>100</value>

        </property>

        <property name="automaticTestTable">

            <value>c3p0_test_table</value>

        </property>

        <property name="numHelperThreads">

            <value>20</value>

        </property>

    </bean>