I am facing one problem while saving data in loop in sql server 2005 database, I observed that memory which is getting acquired is not getting released(which I haven't seen for Oracle 10g database!) which results in out Of Memory exception
I tried with flushing and clearing session after specific number of saves but its still allocating memory but not freeing up.
<prop key="hibernate.connection.pool_size">10</prop>
<prop key="hibernate.show_sql">false</prop>
<prop key="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</prop>
<prop key="hibernate.query.substitutions">
true 1, false 0, yes 'Y', no 'N'
</prop>
<prop key="hibernate.jdbc.batch_size">200</prop>
<prop key="hibernate.c3p0.max_size">100</prop>
<prop key="hibernate.c3p0.min_size">10</prop>
<prop key="hibernate.c3p0.timeout">5000</prop>
<prop key="hibernate.c3p0.max_statements">100</prop>
<prop key="hibernate.c3p0.idle_test_period">300</prop>
<prop key="hibernate.c3p0.acquire_increment">2</prop>
<prop key="hibernate.c3p0.testConnectionOnCheckout">true</prop>
<prop key="hibernate.default_schema">${database.ownername}</prop>
<prop key="hibernate.jdbc.use_scrollable_resultsets">true</prop>
<prop key="hibernate.jdbc.fetch_size">200</prop>
<prop key="hibernate.cache.use_second_level_cache">false</prop>
<prop key="hibernate.cache.use_query_cache">false</prop>
<prop key="hibernate.connection.release_mode">after_statement</prop>
Login
FAQ
Search
