Re: JdbcRowSet Problem

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);
> }
> }