db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Skiles" <dski...@docfinity.com>
Subject RE: Error 38000 with a stack overflow on recordset.next()?
Date Thu, 20 Oct 2005 20:04:34 GMT
-----Original Message-----
From: Jeffrey Lichtman [mailto:swazoo@rcn.com] 
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

Mime
View raw message