Hi, now I see your project I see that the problem I had was more common.
I tried to make some Swing application that run with SQL Server, but both SwingSet and Sun One swing's models failed to do because of the same problem: apparently JDBC drivers (and I tried jTDS and Microsoft's JDBC) don't support all the functions. I tried your software
and had the same exception:
java.sql.SQLException: ResultSet is read only.
at net.sourceforge.jtds.jdbc.JtdsResultSet.checkUpdateable(JtdsResultSet.java:314)
at net.sourceforge.jtds.jdbc.MSCursorResultSet.moveToInsertRow(MSCursorResultSet.java:1062)
at com.sun.rowset.JdbcRowSetImpl.moveToInsertRow(Unknown Source)
at jdbcmanager.table.DataGrid.addRow(DataGrid.java:167)
at jdbcmanager.table.DbTable.actionPerformed(DbTable.java:87)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
My question is if you have an idea of why this is not supported.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi, now I see your project I see that the problem I had was more common.
I tried to make some Swing application that run with SQL Server, but both SwingSet and Sun One swing's models failed to do because of the same problem: apparently JDBC drivers (and I tried jTDS and Microsoft's JDBC) don't support all the functions. I tried your software
and had the same exception:
java.sql.SQLException: ResultSet is read only.
at net.sourceforge.jtds.jdbc.JtdsResultSet.checkUpdateable(JtdsResultSet.java:314)
at net.sourceforge.jtds.jdbc.MSCursorResultSet.moveToInsertRow(MSCursorResultSet.java:1062)
at com.sun.rowset.JdbcRowSetImpl.moveToInsertRow(Unknown Source)
at jdbcmanager.table.DataGrid.addRow(DataGrid.java:167)
at jdbcmanager.table.DbTable.actionPerformed(DbTable.java:87)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
My question is if you have an idea of why this is not supported.