🚀 go-pugleaf

Hi,

I have a subclass of abstracttablemodel that wraps a java.sql.ResultSet in
the TableModel interface. Whenever a new resultset is passed to this, it
eventually calls fireTableChanged(null). (At first I tried
fireTableChanged(new TableModelEvent(this)) but the actual JTable then
displays no data or columns only some empty rows.)

The problem is that the new ResultSet data is shown in the actual JTable
appended to any old queries. It seems as if fireTableChanged should do a
complete requery and get rid of the old data, but I can't get it to do so.
If I do a different SQL query that returns a different column structure, the
column structure is displayed, but the old data is still adapted. For
example, select * from employee shows all employees with the first column as
EMP_NO. select count(*) as num_emps from employee displays a single num_emps
column with all the EMP_NO in it, and the actual count(*) result at the
bottom.

thanks,

Nick

Nick Collier
nick@spc.uchicago.edu
Database Developer
Social Science Research Computing
University of Chicago


--
Nick Collier
nick@spc.uchicago.edu
Database Developer
Social Science Research Computing
University of Chicago