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] -~----------~----~----~----~------~----~------~--~---