problem in connection pooling

[Mahendran Aiyappan]

Hi Guys,

I am facing a problem with connection pooling on jboss 4.2.1GA. For every db call a new connection is created. In other words it seems to be no pooling of connections. Is there is any way to specify this in the properties. My connection properties are as follows:

    
   <bean id="temp"
        class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName">
            <value>com.arjuna.ats.jdbc.TransactionalDriver</value>
        </property>
        <property name="url"
            value="jdbc:arjuna:jdbc:oracle:thin:@temp.com:1521:testdb" />
        <property name="username" value="name" />
        <property name="password" value="password" />
        <property name="connectionProperties" value="DYNAMIC_CLASS=OracleJbossDynamicClass;" />
        <property name="initialSize" value="2" />
        <property name="maxActive" value="20" />        
        <property name="minEvictableIdleTimeMillis" value="600000"/>     
    </bean>

Thanks,
Mahendran.

[Jaikiran Pai]

This looks like a Spring configuration file. JBoss datasources are configured using a *-ds.xml file. See these for details:

http://www.jboss.org/community/wiki/DSdotXML

http://www.jboss.org/community/wiki/ConfigDataSources