File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes thread count keeps rising not released Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "thread count keeps rising not released" Watch "thread count keeps rising not released" New topic

thread count keeps rising not released

sameer sood
Ranch Hand

Joined: Dec 05, 2007
Posts: 30
I am working with hibernate 3.2 and mysql 5
The problem is that when i end sessions in hibernate the thread related to it are not released, the task manager in windows shows a rising thread count and as my server has max of 154 threads limit (which is a MYSQl bug).
The limit can be changed but my question is that when i do session.close(0
why are not the threads released.

this is my cfg

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "">
<property name="connection.url">
<property name="connection.driver_class">
<property name="connection.username">root</property>
<property name="connection.password">root</property>
<!-- Set AutoCommit to true -->
<property name="connection.autocommit">true</property>
<!-- SQL Dialect to use. Dialects are database specific -->
<property name="dialect">
<!-- <property name="hibernate.show_sql">true</property> -->
<!-- Mapping files -->
resource="com/ibm/claimtool/hibernate/ClaimHours.hbm.xml" />
<mapping resource="com/ibm/claimtool/hibernate/User.hbm.xml" />
resource="com/ibm/claimtool/hibernate/ApplicationHours.hbm.xml" />

I am a new bee so please be patient

Sameer Sood
SCJP 1.5 (93%), SCWCD 1.5 (95%)
I agree. Here's the link:
subject: thread count keeps rising not released
It's not a secret anymore!