ResultSet not open. Operation 'last()'

[James Howerton]

Hello
Could someone find the missing code needed to render the table?
error:

[code]May 28, 2010 10:30:59 PM 

view.content.panels.guide.AdminPanel$ResultSetTableModel 

getRowCount
SEVERE: null
java.sql.SQLException: ResultSet not open. Operation 'last()' 

not permitted. Verify that autocommit is OFF.
        at 

org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException

(Unknown Source)

output:

[code]

selectAdmin: 
SELECT
    admin_uid,
    admin_password,
    admin_lname,
    admin_mname,
    admin_fname,
    admin_gender,
    admin_age,
    admin_start_date,
    admin_end_date,
    admin_address,
    admin_state,
    admin_zip,
    admin_area_code,
    admin_phone,
    admin_pay_rate
    FROM admin
    WHERE admin_uid=? 
CONECTION IS GOOD FOR A TEST
query test: selectAllAdmin

number of columns: 15
, ADMIN_UID, ADMIN_PASSWORD, ADMIN_LNAME, ADMIN_MNAME, 

ADMIN_FNAME, ADMIN_GENDER, ADMIN_AGE, ADMIN_START_DATE, 

ADMIN_END_DATE, ADMIN_ADDRESS, ADMIN_STATE, ADMIN_ZIP, 

ADMIN_AREA_CODE, ADMIN_PHONE, ADMIN_PAY_RATE
, ag, a, null, null, Garth, null, null, null, null, null, null, 

null, null, null, null
, aw, a, null, null, Wayne, null, null, null, null, null, null, 

null, null, null, null

adminUserName: SELECT admin_uid FROM admin WHERE admin_uid=?

adminPassword: SELECT admin_password FROM admin WHERE 

admin_uid=?
selectAdmin: 
SELECT
    admin_uid,
    admin_password,
    admin_lname,
    admin_mname,
    admin_fname,
    admin_gender,
    admin_age,
    admin_start_date,
    admin_end_date,
    admin_address,
    admin_state,
    admin_zip,
    admin_area_code,
    admin_phone,
    admin_pay_rate
    FROM admin
    WHERE admin_uid=? 
CONECTION IS GOOD FOR A TEST
query test: selectAllAdmin

number of columns: 15
, ADMIN_UID, ADMIN_PASSWORD, ADMIN_LNAME, ADMIN_MNAME, 

ADMIN_FNAME, ADMIN_GENDER, ADMIN_AGE, ADMIN_START_DATE, 

ADMIN_END_DATE, ADMIN_ADDRESS, ADMIN_STATE, ADMIN_ZIP, 

ADMIN_AREA_CODE, ADMIN_PHONE, ADMIN_PAY_RATE
, ag, a, null, null, Garth, null, null, null, null, null, null, 

null, null, null, null
, aw, a, null, null, Wayne, null, null, null, null, null, null, 

null, null, null, null


[b]
in personalDataTable: Supports TYPE_SCROLL_INSENSITIVE
[/b]
headers: ADMIN_UID
headers: ADMIN_PASSWORD
headers: ADMIN_LNAME
headers: ADMIN_MNAME
headers: ADMIN_FNAME
headers: ADMIN_GENDER
headers: ADMIN_AGE
headers: ADMIN_START_DATE
headers: ADMIN_END_DATE
headers: ADMIN_ADDRESS
headers: ADMIN_STATE
headers: ADMIN_ZIP
headers: ADMIN_AREA_CODE
headers: ADMIN_PHONE
headers: ADMIN_PAY_RATE
records in: ag
records in: a
records in: null
records in: null
records in: Garth
records in: null
records in: null
records in: null
records in: null
records in: null
records in: null
records in: null
records in: null
records in: null
records in: null
innerclass: setQuery(): 15 Columns and 1 records

May 28, 2010 11:24:46 PM 

view.content.panels.guide.AdminPanel$ResultSetTableModel 

getRowCount
SEVERE: null
java.sql.SQLException: ResultSet not open. Operation 'last()' 

not permitted. Verify that autocommit is OFF.

AdminPanel.java GUI to add table

 public void personalDataTable(String thisUser) throws 

FileNotFoundException,
            IOException, SQLException {
        cad = new ConnectAdminDAO();
        setConn(cad.getConn());
        //conn = getConn();
        [b]
         rs = cad.personalDataTable(thisUser);
        [/b]
        rsmd = (ResultSetMetaData) rs.getMetaData();
        //PrintColumnTypes pct =new PrintColumnTypes();
        //pct.printColTypes(rsmd);
        model = new ResultSetTableModel();
        model.setQuery(rs, rsmd);

        [b]
        table = new JTable(model);
        [/b]

        table.setPreferredScrollableViewportSize(new 

Dimension(500, 70));
        table.setFillsViewportHeight(true);
        JScrollPane scrollpane = new JScrollPane(table);
        scrollpane.setVisible(true);
        tablePanel.add(scrollpane);
        tablePanel.setPreferredSize(new Dimension(550,90));
        

tablePanel.setBorder(BorderFactory.createLoweredBevelBorder());
        add(tablePanel);
        rs.close();
    }

ConnectAdminDAO()
public int rst=ResultSet.TYPE_SCROLL_INSENSITIVE;
public int cro=ResultSet.CONCUR_READ_ONLY;
public int tsi=ResultSet.TYPE_SCROLL_INSENSITIVE;

public ResultSet personalDataTable(String thisUser) throws 

FileNotFoundException, IOException, SQLException {
        this.uid = thisUser;
        ddf = new DerbyDAOFactory();
        conn = ddf.getConnection();
       [b] conn.setAutoCommit(false);[/b]
        setConn(conn);
[b]
        ps = (PreparedStatement) conn.prepareStatement(
                ModelUtils.getXMLResource("selectAdmin"), 

rst,cro);
[/b]
        ps.setString(1, thisUser);
        rs = ps.executeQuery();
        DatabaseMetaData meta = conn.getMetaData();
        if (meta.supportsResultSetType(tsi)) {
            System.out.println("in personalDataTable: Supports 

TYPE_SCROLL_INSENSITIVE");
        } else {
            System.out.println("in personalDataTable; No support 

for Supports                                                     

        TYPE_SCROLL_INSENSITIVE");
        }

        return rs;
    }

 
 public class ResultSetTableModel extends AbstractTableModel {

        public int columnCount;
        public String[] headers;
        public ResultSet rs;
        public ResultSetMetaData rsmd;

        public void setQuery(ResultSet rs, ResultSetMetaData 

rsmd) throws FileNotFoundException,
                IOException, SQLException {
            this.rs = rs;
            this.rsmd = rsmd;
            recordCount = 0;

            ////////////////////////// debug 

//////////////////////////////

            try {
                headers = new String[getColumnCount()];
                for (int h = 1; h <= getColumnCount(); h++) {
                    headers[h - 1] = rsmd.getColumnName(h);
                    System.out.println("headers: " + 

rsmd.getColumnName(h));
                }
                while (rs.next()) {
                    record = new String[getColumnCount()];
                    for (int i = 0; i < getColumnCount(); i++) {
                        record[i] = rs.getString(i + 1);
                        System.out.println("records in: " + 

rs.getString(i + 1));
                    }
                    recordCount++;

                }
                ////////////////////////// debug 

//////////////////////////////
                fireTableChanged(null); 
                System.out.println("innerclass: setQuery(): "
                        + rsmd.getColumnCount() + " Columns and 

" + recordCount + " records");
            } catch (Exception e) {

                e.printStackTrace();
            }
        }
         [b]

        public int getRowCount() {
            try {
                rs.last();
                return rs.getRow();
            } catch (SQLException ex) {
                

Logger.getLogger(AdminPanel.class.getName()).log(Level.SEVERE, 

null, ex);
                ex.printStackTrace();
                return 0;
            }

        }
         [/b]

        public String getColumnName(int columnIndex) {
            try {
                return rsmd.getColumnName(columnIndex + 1);
            } catch (SQLException ex) {
                

Logger.getLogger(AdminPanel.class.getName()).log(Level.SEVERE, 

null, ex);
                ex.printStackTrace();
                return "";
            }
        }

        public int getColumnCount() {
            try {
                return rsmd.getColumnCount();
            } catch (SQLException ex) {
                

Logger.getLogger(AdminPanel.class.getName()).log(Level.SEVERE, 

null, ex);
                ex.printStackTrace();
                return 0;
            }

        }

        public Object getValueAt(int rowIndex, int columnIndex) 

{
            try {
                rs.absolute(rowIndex + 1);
                return rs.getObject(columnIndex + 1);
            } catch (SQLException ex) {
                

Logger.getLogger(AdminPanel.class.getName()).log(Level.SEVERE, 

null, ex);
                ex.printStackTrace();
                return "";
            }
        }

        public Class getColumnClass(int columnIndex) {
            return getValueAt(0, columnIndex).getClass();


        }
    }