Hi frndz,

I have problem while inserting bulk number for records. When am inserting more than 1000 records. Am getting..

"org.springframework.web.util.NestedServletException: Handler processing failed; nested exception is java.lang.OutOfMemoryError: Java heap space
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:919)"



For every record am creating new persistence object. So totally creating 1000 objects.

So am getting java heap space error.

Any body help me.

Thanks in advance.

Regards,
sivaprakash.

u have to clear session to evict object from session cache

read this:


http://www.hibernate.org/hib_docs/v3/re ... ch-inserts

Hi Frndz,

I have to insert bulk amount of data.

Three tables:
table1
table2
table3

table1(one-to-many)table2(one-to-one)table3

So when am inserting into table1. It inserts in both table2 and table3.

Am inserting more than 10000 records, Even i have applied batch siza as "30" and second level cache is disabled.
And also for even 30 insertion i will clear and flush the session.

For insertion,
for single insertion, am creating three instace. so totally it creates 30000 instace. So am receiving "Out of memory Exception"

java.lang.OutOfMemoryError: Java heap space
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:919)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:808)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:476)
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:441)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)

17:26:18,574 INFO [STDOUT] java.lang.OutOfMemoryError: Java heap space
17:26:38,304 ERROR [[dps]] Servlet.service() for servlet dps threw exception
java.lang.OutOfMemoryError: Java heap space


Plz frndz help me

Thankx in advance

u keep reference for those object,

so try session.getStatistics().getEntityCount() if u really evict all object from session after 30 saving records

and if yes, than u have to look where do u keep references for all your objects for saving in your app

Thanx for your reply...

Actully i dont know, When i gave the Sysout for following statement.
session.getStatistics().getEntityCount().. Am receiving keep on increasing value.
Can u tell me. whether it correct or not

after each 30 insertion u should get same count(+-),
if number is still increasing aritmeticaly after each 30 insertion (e.q. 90,180,270), it is bad

Thanx share ur idea.

May i know.. Why its occuring.

This is my code

if ( i % 0 == 0 ) {
transaction.commit();
session.flush();
session.clear();
transaction=session.beginTransaction();
}

Even am getting increasing value. And am using Hibernate3.jar file. Is it support the Bulk Insert


Regards,
sivaprakash.G

are u sure that app will hit those code inside if condition???

Hi,
Sorry... i wrongly sent that ......


if ( i % 300 == 0 ) {
transaction.commit();
session.flush();
session.clear();
transaction=session.beginTransaction();
}

Thanx a lot to share your idea with me.

Now no heap space havent came....

May i know details about batch size in cfg file..

My application is running slowly..

For Single Insertion:
Insertion in three table and two file read and one file write and one file upload into BLOB

Can u give some infor. Regarding improve the performance of the application

Regards,
Sivaprakash.G

batch size in cfg should be same as count of records after which u clear session - i use 20 -50 depends on situation, just try and will see

hmm ... and other optimization dunno