Re: memory management

josh, 31.10.2007 10:22:
Hi, I have the following problem:

in a while loop I get from a db some records and in the same time
I put them with an insert preparedStatement in
a destination db but the jave process increase the memory until it
goes in out of memory.

How can I optimize that? also If I increase Tomcat java memory when I
process more than 500 records
tha java memory is already at 700mb of usage!

My guess is that you are buffering the retrieved rows somehow (or keeping references to them). You will need to show us your code.

Thomas
.

Relevant Pages

  • Re: memory management
    ... I put them with an insert preparedStatement in ... a destination db but the jave process increase the memory until it ... also If I increase Tomcat java memory when I ... As far as I can tell, this will create huge strings with the complete result set, as they are declared outside the loop (actually twice the ...
    (comp.lang.java.programmer)
  • Re: memory management
    ... I put them with an insert preparedStatement in ... also If I increase Tomcat java memory when I ... as they are declared outside the loop (actually twice the ... the problem was not in the resultset but in my logging string! ...
    (comp.lang.java.programmer)
  • Re: memory management
    ... I put them with an insert preparedStatement in ... also If I increase Tomcat java memory when I ... as they are declared outside the loop (actually twice the ... Log4j seems to be the most popular, and might as well be standard, commons-logging is a facade that lets you basically plug in whatever type of logging system you choose (such as log4j or Java Logging), and Java Logging comes standard. ...
    (comp.lang.java.programmer)
  • Re: memory management
    ... a destination db but the jave process increase the memory until it ... also If I increase Tomcat java memory when I ... You can loop through the records, ...
    (comp.lang.java.programmer)
  • memory management
    ... I put them with an insert preparedStatement in ... a destination db but the jave process increase the memory until it ... also If I increase Tomcat java memory when I ...
    (comp.lang.java.programmer)