Hi,
I'm not sure if this helps.. We use SQLServer 2000 database, Hibernate, net.sourceforge.jtds driver AND commons-dbcp for managing the connection pool. My guess is that your problem is more with managing the connection pool. Let me know if this resolves.
so config looks something like this:-
Code:
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName"><value>${hibernate.connection.driver_class}</value></property>
<property name="url"><value>${hibernate.connection.url}</value></property>
<property name="username"><value>${hibernate.connection.username}</value></property>
<property name="password"><value>${hibernate.connection.password}</value></property>
<property name="maxActive"><value>100</value></property>
<property name="maxWait"><value>120000</value></property>
<property name="maxIdle"><value>50</value></property>
<!-- OTHER org.apache.commons.dbcp.BasicDataSource CONFIGURATION SETTERS CAN BE CONFIGURED HERE, SEE http://jakarta.apache.org/commons/dbcp/apidocs/org/apache/commons/dbcp/BasicDataSource.html-->
</bean>
<!-- BEAN DEFINITIONS BELOW THIS POINT SHOULD NOT NEED TO BE EVER MODIFIED FOR AN IMPLEMENTATION -->
<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="mappingResources">
<list>
<!--hibernate mapping entries -->
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">${hibernate.dialect}</prop>
<prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
<!--
<prop key="hibernate.format_sql">true</prop>
<prop key="hibernate.use_sql_comments">true</prop>
-->
<prop key="hibernate.query.substitutions">true 1, false 0, yes 'Y', no 'N'</prop>
<prop key="hibernate.jdbc.batch_size">0</prop>
<prop key="hibernate.jdbc.use_streams_for_binary">true</prop>
<prop key="hibernate.max_fetch_depth">1</prop>
<prop key="hibernate.cache.use_query_cache">false</prop>
<prop key="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</prop>
</props>
</property>
<property name="dataSource"><ref bean="dataSource"/></property>
<property name="entityInterceptor"><ref bean="entityInterceptor"/></property>
</bean>
<bean id="entityInterceptor" class="xx.EntityInterceptor" />
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource"><ref bean="dataSource"/></property>
</bean>
-Srilatha.