I am not sure whether this question belongs to this forum. But I have a JDBC question. I am setting my preparedStatement with the following flags:
Which would allow me to know how many rows were returned by the result set:
rst = ps.executeQuery();
//We need to know how many rows were returned. This is done
//by pushing the pointer to the last row and then getting
// the row number.
int count = rst.getRow();
// Now push it back to the row before first
This works fine within my session facade, but when I call the same code from my entity bean it returns 0. Now I know tthe sql returns 13 rows. I have been trying to find out what is going on with no avail.
Can any one tell me why?
Thanks in advance.