On Sat, 5 Feb 2005 12:29:23 -0600, Patil, Prashant V
> Generally I don't have problem reading data and storing but for larger
> data, my program hangs when I am trying to insert XML message to database.
> Database guys are saying I am doing something wrong with memory and there
> are no locking blocks at oracle.
> Also I am using java.sql class for creating connection, statement,
> Does anybody face this kind of problem?
Are you getting any sort of error message? If so, can you paste it here for us?
When your program hangs if you just leave it running does it
eventually give an error?
What is your method of reading/writing the data? Do you read it all
out and then put it all into the next place or do you read one
section, write that section, destroy variables used and start over?
I've had problems running out of memory when reading/writing large
amounts of data to databases with Jython, but in those cases I get
"JVM: out of memory" kinds of messages. The solution was multifold:
the first step was to increase the -Xmx flag in my Jython command line
for that script the second step was to look carefully at all of the
variables I was creating in the script and make sure that they weren't
inefficient (I was storing a JDBC recordset into a Jython dictionary -
that's a "bad idea" in terms of memory).
Hope this helps,