Hibernate version: 2.1.4

Mapping documents:
<property name="dialect">net.sf.hibernate.dialect.MySQLDialect</property>
<property name="show_sql">false</property>
<property name="use_outer_join">true</property>
<property name="connection.isolation">4</property>
<property name="transaction.factory_class">net.sf.hibernate.transaction.JTATransactionFactory</property>
<property name="transaction.manager_lookup_class">net.sf.hibernate.transaction.JBossTransactionManagerLookup</property>
<property name="jta.UserTransaction">UserTransaction</property>

Data Source Configuration :

<!-- pooling enhancement -->
<blocking-timeout-millis>500</blocking-timeout-millis>
<idle-timeout-minutes>5</idle-timeout-minutes>
<min-pool-size>10</min-pool-size>
<max-pool-size>50</max-pool-size>
<check-valid-connection-sql>SELECT 1</check-valid-connection-sql>

<!-- MySQL specific enhancement -->
<connection-property name="autoReconnect">true</connection-property>
<connection-property name="autoReconnectForPools">true</connection-property>
<connection-property name="useNewIO">true</connection-property>

Code between sessionFactory.openSession() and session.close():\
public static final ThreadLocal session = new ThreadLocal();
Session s = (Session) session.get();
if (s == null) {
try {
s = sessionFactory.openSession();
session.set(s);
} catch (Exception e) {
throw new HibernateException(e.getMessage());
}
}
// check if session is not connected
if (!s.isConnected()) {
logger.warn("Reconnecting hibernate session...");
s.reconnect();
}
level++;
return s;
closeSession :
public static void closeSession() {
level--;
if (level <= 0) {
Session s = (Session) session.get();
if (s != null && s.isOpen()) {
session.set(null);
try {
s.flush();
s.close();

} catch (HibernateException e) {
logger.warn(e.getMessage());
}
}
}
}

Full stack trace of any exception that occurs:

Name and version of the database you are using: MySql 4.0.18 (connector/J 3.0.14)

Debug level Hibernate log excerpt: We can see some times database connection are not returning to connection pool on session close. I beleive that session.close() will close the connection .. Is there any thing is wrong in my configuration ...
Your help is highly appreciatable.

Thanks,
Jack

If an exception occurs during flush(), you do not close() the session.

Gavin,

Thanks for your reply.
Okay now I will change it and i will place session.close in finally block.

Any how but I can't see any exception during flush. But I observed one thing , whenever there are multiple sessions opened then some sessions are not closing.

Once again thanks for your time.

Thanks,
Jack

You're somehow mismatching sessions references while opening multiple ones in your code
Hibernate sessions have no relationship with each other (not on connection at least)

Hai Emmanuel,

Thanks for highlighting this.

Do you think there is any thing wrong in my code at Beans(calling sessions and closing) or configuration of session(Hibernate).

The opening session and closing session code is above. And here I am attaching my bean level code for your reference .

SessionBean :
Transaction tx = null;
try {
Session session = XXXSession.currentSession();
tx = session.beginTransaction();
Long id = (Long) session.save(rrd);
session.flush();
return id;
} catch (HibernateException e) {
logger.error("Unable to create reload request: " +
ExceptionUtils.getStackTrace(e));
throw new TestFacadeCreateException(e);
} finally {
XXXSession.closeSession();
}

Please advice ..

Thanks,
Jack.

Well, you never commit or rollback any transaction. This is pretty wrong ;-)

Thanks Emmanuel,

Actually we have commit and rollback in our code .. when I copied to Forum I removed ... some code ..

It's okay, it seems we have find the root cause ... , we have a small problem in closeSession part.

Thanks to all , who have spent their valuable time.