The only way the driver could be changed to handle this is pre-load the resultset into memory.
Adam Megacz proposed a reasonable solution that is in the list archives. I would entertain such a patch, or would be happy to be employed to write such an addition. But I have no intention of donating time to this issue in the near future. d On 13/07/2008, Marcello Magaldi <[EMAIL PROTECTED]> wrote: > > Hi, > I've got a lot of problems since upgrading from 0.36 to last one sqlite > jdbc. > I need in my program to do 2 or more simultaneous queries and I need to keep > opened 2 or more resultsets at a time (and so 2 or more query statements), > doing > so with 0.52 will give me the exception in subject. > I REALLY need to keep two or more rs opened because in my program I need a > rs to > show the results (and select only the relevant data) and another rs to have > the > same data in the same order but also with the data I need to update a row > such > as the primary key. > With 0.36 all works like a charm, after that version (since 0.4x) I've got > this > problem and I really don't know how to solve it. > In my program I have the main class that interacts with the db and the GUI > (in > another class) that uses the main class methods to query/update the db. > While I can close the statement right after a insert/delete/modify I cannot > do > it with queries since I need to keep opened the resultset to let me > modify/delete the existing data. > Is my only chance to keep using 0.36 in this case ? > > Best Regards > > Marcello Magaldi > > > > > --~--~---------~--~----~------------~-------~--~----~ Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
