hi friend, I have created the application in which I need to configure the connection pool.In which I am configuring the connection pooling in the spring_Config file. using the Basicdatasource. but there is some problem to create the connection pool. Please tell me how to create the connection pooling in spring application using BasicDatasource.

I tried this one code in spring config ;-

bean id="datasource" class="org.apache.commons.dbcp.BasicDataSource"> com.mysql.jdbc.Driver jdbc:mysql://192.168.1.12:3306/revup?noAccessToProcedureBodies=true jdbc:mysql://localhost:3306/revup?noAccessToProcedureBodies=true--> revuser root--> kjacob gme997FK-->

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

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

Is there any modification of code please tell me. thanks in advance.