This post originated from an RSS feed registered with Java Buzz by Marc Logemann. Original Post: Configuring Kodo inside Spring Part2 Feed Title: Marc's Java Blog Feed URL: http://www.logemann.org/day/index_java.xml Feed Description: Java related topics for all major areas. So you will see J2ME, J2SE and J2EE issues here. Latest Java Buzz Posts Latest Java Buzz Posts by Marc Logemann Latest Posts From Marc's Java Blog

This is a follow up to my previous blog. If you need control of the ConnectionPool provided by com.solarmetric.jdbc.PoolingDataSource, you just can create your own Pool and supply it to the PoolingDataSource like this:

   <bean id="dataSource" class="com.solarmetric.jdbc.PoolingDataSource">
    <constructor-arg>
      <ref local="connectionPool"/>
    </constructor-arg>
        <property name="connectionURL">
            <value>jdbc:mysql://localhost/somedb?useUnicode=true</value>
        </property>
        <property name="connectionDriverName">
            <value>com.mysql.jdbc.Driver</value>
        </property>
        <property name="connectionPassword">
            <value>root</value>
        </property>
        <property name="connectionUserName">
            <value>root</value>
        </property>
    </bean> 

You see, we use setter and constructor injection for providing the needed properties. The connectionPool can only be applied in the constructor in the Kodo DataSource.

Then we create our own ConnectionPool like this:

    <bean id="connectionPool" class="com.solarmetric.jdbc.ConnectionPoolImpl">
        <property name="maxActive">
            <value>10</value>
        </property>
        <property name="maxWait">
            <value>1000</value>
        </property>
    </bean> 

There are a lot more properties you can define, check the API documentation for ConnectionPoolImpl for more infos.