Hi,

I have application with JPA, and try to process and insert a group of records. What application start, it is very fast and take only one second to insert a group of records into database (MySQL), but But after about one or two hours, it'll take about ten seconds to finish transactions, after over night running ( about 12 hours), it become more than one minutes to finish, at last, cause out of memory.

Is it memory leak, I setup java options like -Xmx 1024m. But it also cause out of memory after running some time.

Any configurations like MySQL to improve performance?


Thanks,

Quinten

You should use some tool to monitor the memory leak, and don't forget to turn on the log for hibernate, so you can see what the cause is.

I get error message like this:

Exception in thread "Thread-1" java.lang.OutOfMemoryError: Java heap space
at org.hibernate.util.IdentityMap.entryArray(IdentityMap.java:224)
at org.hibernate.util.IdentityMap.concurrentEntries(IdentityMap.java:89)
at org.hibernate.event.def.AbstractFlushingEventListener.prepareEntityFlushes(AbstractFlushingEventListener.java:136)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:88)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:49)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
at com.tme.exc.ExcData.proc(ExcData.java:74)
at com.tme.exc.ExcData.run(ExcData.java:446)
at java.lang.Thread.run(Unknown Source)


Any suggestion?

thanks

are you doing batch?

http://docs.jboss.org/hibernate/core/3.3/reference/en/html/batch.html

In a nutshell it sounds like you probably just need to flush/clear your Hibernate Session.

Sadly from what I can tell flush/clear does not always work, but yeah..tread the article someone posted above..it will point in you in the right direction.