I have a query, a simple select:
"select de.phrase,dv.definition as value from dictentries
de,dictvalues dv where de.id=dv.id and dv.locale=?"
and a stored procedure doing the same query:
"{call msim_getDictionary(?)}"
when I use the select I get all the rows, when I use the stored
procedure I'm missing the first row.
After some tests I think that ResultSets from stored procedures are
set to the first row when they should be "before the first row" if I
call beforeFirst() in the resultset I get all the rows. Problem is u
cant call beforeFirst() on TYPE_FORWARD_ONLY resultsets.
--
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.
