memory management



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!

Please help

.



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
    ... 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 ... also If I increase Tomcat java memory when I ...
    (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)
  • 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 ... a destination db but the jave process increase the memory until it ... goes in out of memory. ...
    (comp.lang.java.programmer)