Originally Posted by daiondoroga
Basically I want to get the row count in the resultset. So first method i am calling is resultSet.last(), there itself I could not proceed.
Do not use resultSet.last() to get the no of row count as that will not return you the count properly instead use the count SQL something like
Code: JAVA
ResultSet rs = executeQuery("SELECT COUNT(*) AS rowcount FROM MyTable");
int RocordCount = rs.getInt("rowcount") ;
rs.close() ;