Posted Wednesday, December 31, 1969 @ 23:59:59
Marlon, This is possible. You have to do the following things.
1) Since QuickTable, fetches the records as the
user scrolls down, before you close the connection ,
you have to trigger the fetch of all records.
yourQuickTable.refresh();
//after refresh add the following
JTable jt = yourQuicktable.getTable();
TableModel dbTableModel = jt.getModel();
int row = dbTableModel.getRowCount()-1;
jt.getValueAt(row,1);
//close the connection
yourQuickTable.close();
2) don't assign any insert/delete/update statements
3) even after you do the above things, if you still
get error like, "connection already closed", then ,
add a dbtableErrorlistener and catch all the errors.
yourQuickTable.addDBTableErrorListener(DBTableErrorListener
yourListener)
4) If you don't want users to edit the data, then for all the columns set the ReadOnly property to true.
I feel this should make it work.
Ben