Thread: JdbcRowSet Problem
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);
}
}
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);
}
}
Apparently I also needed a rowSet.updateObject statment. I'm working now. --drg
Dennis Gesker wrote:
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);
}
}