Session closes while I am inserting data

mariosangiorgio · **Joined:** Sun Feb 14, 2010 7:13 pm **Posts:** 6

Hi everybody,
I am facing a strange Hibernate behavior, I think due to session timeout.

I have to insert a lot of data into the database. The insertion works for the first entries, but a a certain point I get an org.hibernate.SessionException: Session is closed! exception.

My insert method works in the following way:

Unfortunately that works for the insertion of a small number of items, but it doesn't scale up and i get the mentioned exception.

Am I doing something wrong or it is just a matter of some misconfigured parameter?

hallmit · **Posted:** Fri Mar 05, 2010 5:07 am

can you please post your complete stack trace error.

it looks like a batch problem related, have you taken a look at http://docs.jboss.org/hibernate/stable/ ... batch.html ?

mariosangiorgio · **Joined:** Sun Feb 14, 2010 7:13 pm **Posts:** 6

First of all thanks for your quick reply, it is really appreciated.

Here is the full stacktrace

Code:

Exception in thread "main" org.hibernate.SessionException: Session is closed!
   at org.hibernate.impl.AbstractSessionImpl.errorIfClosed(AbstractSessionImpl.java:72)
   at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1347)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:342)
   at $Proxy17.beginTransaction(Unknown Source)
   at it.polimi.crawler.IEEECrawlerNew.getYearArticles(IEEECrawlerNew.java:166)
   at applications.Crawler.main(Crawler.java:106)

Now I am having a look at the page you suggested. Thanks again for you help.

mariosangiorgio · **Joined:** Sun Feb 14, 2010 7:13 pm **Posts:** 6

Looking at the code I found the cause of the problem, it was on the class that manages the sessions. I was not checking if the session factory returned an already closed session.