Forum LAMS for Tech-Heads - General Forum: Could not open Hibernate Session for transaction


 
You may request notification for Could not open Hibernate Session for transaction.
Search: 

1: Could not open Hibernate Session for transaction
09/20/14 12:38 AM
[ Reply | Forward ]
I have encountered an error when accessing module 1 which i had completed and need to carry onto module 2. this is the error stated: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection Show detail

Posted by Wei May Chua

2: Re: Could not open Hibernate Session for transaction
In response to 1 09/20/14 06:51 AM
[ Reply | Forward ]
HI Wei May,

I think these issues are when you have a capacity problem with MySQL. Can you check the number of max_connections in the DB?

Go into mysql as root and run:


show variable like 'max_conn%';

the post the output of:


show status like '%conn%';

These should display the number of connections effectively used as well as threads.

Thanks,

Ernie

Posted by Ernie Ghiglione

Reply to first post on this page
Back to LAMS for Tech-Heads - General Forum
.LRN Home