Обсуждение: JdbcRowSet Problem

Поиск
Список
Период
Сортировка

JdbcRowSet Problem

От
Dennis Gesker
Дата:
Hello All:

I seem to be having a strange problem with the JDBC driver. I'm writing a simple Swing application where a JTable is populated from data in a postgres database. I'm using a JdbcRowSet. The table populates just fine.

However, I can't seem to update the information in the JTable. Below is the code added to the JTables tablemodel to update the data.

No error is returned and it appears that all command in this function are called.

Is anyone else having this kind of problem? Could some point me in the right direction?

Thanks
Dennis




    public void setValueAt(Object value, int rowIndex, int columnIndex){
  try {

            rowSet.absolute(rowIndex + 1);
            rowSet.setObject(columnIndex + 1, value);
            rowSet.updateRow();
            fireTableCellUpdated(rowIndex, columnIndex);
            JOptionPane.showMessageDialog(null, "Got here.");

        } catch (SQLException sqle) {
            do {
                System.err.println("Exception occourred\nMessage: "
                        + sqle.getMessage());
                System.err.println("SQL state: " + sqle.getSQLState());
                System.err.println("Vendor code: " + sqle.getErrorCode());
                System.err.println("---------------------------------");
            } while ((sqle = sqle.getNextException()) != null);
        }
    }

Re: JdbcRowSet Problem

От
Dennis Gesker
Дата:
Apparently I also needed a rowSet.updateObject statment.  I'm working now.  --drg
Dennis Gesker wrote:
Hello All:

I seem to be having a strange problem with the JDBC driver. I'm writing a simple Swing application where a JTable is populated from data in a postgres database. I'm using a JdbcRowSet. The table populates just fine.

However, I can't seem to update the information in the JTable. Below is the code added to the JTables tablemodel to update the data.

No error is returned and it appears that all command in this function are called.

Is anyone else having this kind of problem? Could some point me in the right direction?

Thanks
Dennis




    public void setValueAt(Object value, int rowIndex, int columnIndex){
  try {

            rowSet.absolute(rowIndex + 1);
            rowSet.setObject(columnIndex + 1, value);
            rowSet.updateRow();
            fireTableCellUpdated(rowIndex, columnIndex);
            JOptionPane.showMessageDialog(null, "Got here.");

        } catch (SQLException sqle) {
            do {
                System.err.println("Exception occourred\nMessage: "
                        + sqle.getMessage());
                System.err.println("SQL state: " + sqle.getSQLState());
                System.err.println("Vendor code: " + sqle.getErrorCode());
                System.err.println("---------------------------------");
            } while ((sqle = sqle.getNextException()) != null);
        }
    }