• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

thread count keeps rising not released

 
sameer sood
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
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" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="connection.url">
jdbc:mysql://localhost:3306/db_claim_tool
</property>
<property name="connection.driver_class">
com.mysql.jdbc.Driver
</property>
<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">
org.hibernate.dialect.MySQLDialect
</property>
<!-- <property name="hibernate.show_sql">true</property> -->
<!-- Mapping files -->
<mapping
resource="com/ibm/claimtool/hibernate/ClaimHours.hbm.xml" />
<mapping resource="com/ibm/claimtool/hibernate/User.hbm.xml" />
<mapping
resource="com/ibm/claimtool/hibernate/ApplicationHours.hbm.xml" />
</session-factory>
</hibernate-configuration>

I am a new bee so please be patient
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic