I'm still trying to understand your problem. Are you saying that the
following doesn't work for you:
ResultSet rs1 = conn.createStatement().executeQuery("select 1 union
select 2");
ResultSet rs2 = conn.createStatement().executeQuery("select 3 union
select 4");
while (rs1.next() && rs2.next()) {
System.out.println("a = " + rs1.getInt(1));
System.out.println("b = " + rs2.getInt(1));
}
It works without problems here (0.52).
On Jul 13, 3:51 pm, 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]
-~----------~----~----~----~------~----~------~--~---
