HI all,

I have 2 record in a table name "item" in mysql database, and use
RecordSet to retrieve that 2 record.

i try to get the number of Result using the below method :

result.last()
int rowCount = result.getRow();

according to Javadoc, it suppose return the exact number of row that the
recordset content. But strangely, the rowCount is 1. After I add a
record to "item", the rowCount is 2 (but i use mysql console, it show
the number of record suppose have 3).

Do anyone know how to solve this??

Thanks.
Max.