RE: Error 38000 with a stack overflow on recordset.next()?

[Jeffrey Lichtman]

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 Lichtman
                                [EMAIL PROTECTED]
                                Check out Swazoo Koolak's Web Jukebox at
                                http://swazoo.com/