On Mar 23, 5:57 am, Ryan How <[email protected]> wrote: > For a select you need to use executeQuery and then iterate over the > result set.
Right, but it doesn't explain why he gets "Select results:null". The culprit seems to be the call to "statement.getMoreResults()", it's misnomer as it "Moves to this Statement object's next result", which means that the first (and only) result in this example gets discarded. Leaving it out leads to "Select results:rs2: columns: 3 rows: 1 pos: -1", what probably is what the OP expected. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
