The internal connection pool has reached its maximum size and no connection is currently available!

Question

Problem :

I am using the Hibernate for a first time for my project and I am very new to Hibernate. I think I have followed all the instructions written in some tutorials but still I keep getting the below Exception that is in my title:

Exception in thread "main" org.hibernate.HibernateException: The internal connection pool has reached its maximum size and no connection is currently available!

What I want to do is simply storing the object into the MySql Database that I have already created.

When I run it I always get above exception and I have no idea why. Maybe I should just change a connection.pool_size property, but if I do so it guesses that I only will get more errors. Can anyone help me?

Answer 1

 

Please do below changes in your HibernateUtil:

public static Session getHibernateSession() {

    final SessionFactory sf = new Configuration()
        .configure("yourConfig.cfg.xml").buildSessionFactory();

    // factory = new Configuration().configure().buildSessionFactory();
    final Session session = sf.openSession();
    return session;
    }

And instead of using the SessionFactory use the Session:

final Session session = HibernateUtil.getHibernateSession();

And after that use the below code:

Transaction tx = session.beginTransaction();
 // all your methods
 tx.commit();
 session.close();

Hope this helps you in resolving your issue.

And you can actually remove that connection pool property from your hbm if you do not need it.