Editing JDBC ResultSets in a JTable

Thread view:

Marc Dzaebel - 24 Jan 2004 12:57 GMT

Hi,

viewing ResultSets is easy by adapting the TableModel (e.g.
ResultSetTableModel). However, how do I create an *editable* JTable that
accesses its ResultSet directly (updateObject() ... updateRow()) rather than
copies in an array? Do I have to write new CellEditors?

Thank you very much in advance

Marc

Reply to this Message

Christophe Vanfleteren - 24 Jan 2004 13:04 GMT

> Hi,
>
[quoted text clipped - 6 lines]
>
> Marc

No, you'll need to override the setValueAt() method of the TableModel you're
using to update your ResultSet with the new value.

Signature

Kind regards,
Christophe Vanfleteren

Reply to this Message

Marc Dzaebel - 24 Jan 2004 17:46 GMT

> No, you'll need to override the setValueAt() method of the TableModel you're
> using to update your ResultSet with the new value.

Hi Christophe,

I already tried this before but now, as you reminded me again, I found that
I did not print the error from updateRow() in setValueAt() and missed the
function. Silly mistake. So you saved me a lot of time! It seems I need the
fix of ConnectorJ 3.1.0 for updatable ResultSets
(http://bugs.mysql.com/bug.php?id=1592)

Thank you very much!

Marc

Reply to this Message

Editing JDBC ResultSets in a JTable

Free Magazines