David,
I do not see any other way than programmatically separating the
lines of the SQL query. Is this doable ? Like, if it's a backup, it
probably has a chance that each query is a line, or ?
If yes, then it should be pretty easy to use a LineNumberReader and
feed each line as an SQL
parameters. Watching
the task manager, the memory usage slowly increases as it inserts rows.
-Original Message-
From: Paul Libbrecht [mailto:[EMAIL PROTECTED]
Sent: Monday, July 09, 2007 4:13 PM
To: Jakarta Commons Users List
Subject: Re: [jelly] How to make a large Jelly-SQL script
a large Jelly-SQL script
more memory efficient?
Oh, sorry, hadn't grasped,
but then I doubt jelly can do anything... am I wrong or it is
normal for an SQL driver to keep an amount based in memory as
long as the transaction is not committed ?
Do you see something jelly code that stores