<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
    <property name="driverClass">
      <value>com.mysql.jdbc.Driver</value>
    </property>
    <property name="jdbcUrl">
      <value>jdbc:mysql://localhost/springproject</value>
    </property>
    <property name="user">
      <value>root</value>
    </property>
    <property name="password">
      <value>tiger1</value>
    </property>
       <!-- Connection pool code start -->
    <property name="testConnectionOnCheckin" value="true" />
    <property name="checkoutTimeout">
      <value>600000</value>
    </property>
    <property name="maxIdleTime">
      <value>30</value>
    </property>
    <property name="maxPoolSize">
      <value>50</value>
    </property>
    <property name="minPoolSize">
      <value>5</value>
    </property>
    <property name="initialPoolSize">
      <value>5</value>
    </property>
    <property name="unreturnedConnectionTimeout">
      <value>50</value>
    </property>
    <property name="maxStatements" value="2000" />
    <property name="idleConnectionTestPeriod" value="30" />
    <property name="automaticTestTable" value="c3p0_con_test" />
    <!-- Connection pool code end -->
  </bean>