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.
<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.
Login
FAQ
Search
