-----Original Message-----
From: Jeffrey Lichtman [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 20, 2005 3:15 PM
To: Derby Discussion
Subject: RE: Error 38000 with a stack overflow on recordset.next()?
Here's a potential workaround for your problem. I suspect it will
work, but I'm not sure:
SELECT path from filesystemfiles where not exists
(select * from existingfiles where existingfiles.path =
filesystemfiles.path)
The query does the same thing as your original one with "not in", but
I suspect Derby will not try to use the in-memory optimization I
mentioned in my previous mail.
Jeff,
That works perfectly. Thanks for the help.
Daniel
