RowCount in FilteredRowSet

[Feyna Reendrina]

i want to make the table model using FilteredRowSet, but i have some problem to get row count...

method size of FilteredRowSet, can not be used!! beacuse it will be return count of record in FilteredRowSet that inserted and deleted....

what i want is to get count of active record (no deleted record)...

i using this script to claculate...
but it will be always SQLException when reach the last record, if i delete the last record!!

    public int getRowCount() {
        int counter=0;        
        if (crs.size()>0)
        {            
            try{
                crs.beforeFirst();
                while (!crs.isLast()) {
                    if (crs.next()) counter++;
                    else break;
                }
            }catch(SQLException e) {
                System.out.println("SQLException");
                System.out.println(".. method getRowCount, class adapter.transaksiTableModel");
            }
        }
        return counter; 
    }

[Shailesh Chandra]

I haven't use FilteredRowSet, only I can suggest as of now you keep a counter in your program, whenever you delete a row increment the counter.
So at any point of time you can get active rows as crs.size() - deletedRows

Shailesh