---

Posted Saturday, April 27, 2013 @ 05:04:45  

Greetings. I'm trying out quicktable and ran into an error when working with data stored in an MS Access database (perhaps that's the problem ;)

Simple table with three columns. The display and retrieve works great, but when I update a row, I receive the error above.

The stack trace and debug information follow.
Thank you for any advice you have !!
--Charles

run:
C:\Users\Charles Johnson\Documents\CompassHouse\JavaRCIntkStats\Source\ResourceCenterIntake
Apr 27, 2013 5:40:39 AM resourcecenterintake.ResourceCenterIntake main
INFO: Starting up
Apr 27, 2013 5:40:40 AM resourcecenterintake.RCIMain main
INFO: RCIMAIN -Starting up
Apr 27, 2013 5:40:40 AM resourcecenterintake.RCIMain initDocument
INFO: C:\Users\Charles Johnson\Documents\CompassHouse\JavaRCIntkStats\RCtestdatabase2015.mdb
Apr 27, 2013 5:40:40 AM resourcecenterintake.frmjDocument init
INFO: Init called
Property Table.selectionBackground is undefined by your Look & Feel. To fix this problem, fix Look & Feel or call UIManager.put("Table.selectionBackground", Color.black); with appropriate color before creating instance of DBTable object.
Property Table.selectionForeground is undefined by your Look & Feel. To fix this problem, fix Look & Feel or call UIManager.put("Table.selectionForeground", Color.black); with appropriate color before creating instance of DBTable object.
Property Table.focusCellBackground is undefined by your Look & Feel. To fix this problem, fix Look & Feel or call UIManager.put("Table.focusCellBackground", Color.black); with appropriate color before creating instance of DBTable object.
Property Table.focusCellForeground is undefined by your Look & Feel. To fix this problem, fix Look & Feel or call UIManager.put("Table.focusCellForeground", Color.black); with appropriate color before creating instance of DBTable object.
Property Table.gridColor is undefined by your Look & Feel. To fix this problem, fix Look & Feel or call UIManager.put("Table.gridColor", Color.black); with appropriate color before creating instance of DBTable object.
Apr 27, 2013 5:40:43 AM resourcecenterintake.frmjCaseManager init
INFO: Init called
Primary Column: -1
Database meta data information received from jdbc driver
Column 1: Name: id
ReadOnly: true
Data Type: INTEGER
Precision: 10
Scale: 0
Signed: true

Column 2: Name: Description
ReadOnly: true
Data Type: VARCHAR
Length: 50

Column 3: Name: isActive
ReadOnly: true
Data Type: BIT
Length: 1

Executing row count sql=SELECT COUNT(*) from CaseManagers
Time taken to execute rowcount sql=1ms
Time taken to execute select sql=0ms
Skipping recreating columns. To refresh column properties everytime, use 'DBTable.useOldColumnProperties(boolean val)', if needed.
Data updated (1,1): oldvalue: Martha new value: Marty
Executing sql update CaseManagers set Description=?,isActive=? where id=? with arguments:
Argument 1: Datatype in database:NUMERIC. Datatype of cell data: java.lang.Integer. Value:2
java.lang.IndexOutOfBoundsException: Index: -1, Size: 3
Argument 2: Datatype in database:VARCHAR. Datatype of cell data: java.lang.String. Value:Marty
at quick.dbtable.QuickVector.RangeCheck(QuickVector.java:337)
at quick.dbtable.QuickVector.get(QuickVector.java:270)
at quick.dbtable.QuickVector.elementAt(QuickVector.java:128)
at quick.dbtable.DBTableModel.update(DBTableModel.java:1745)
at quick.dbtable.DBTableModel.rowSelectionChanged(DBTableModel.java:2163)
at quick.dbtable.DBTable$2.valueChanged(DBTable.java:533)
at javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:167)
at javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:147)
at javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:194)
at javax.swing.DefaultListSelectionModel.changeSelection(DefaultListSelectionModel.java:388)
at javax.swing.DefaultListSelectionModel.changeSelection(DefaultListSelectionModel.java:398)
at javax.swing.DefaultListSelectionModel.setSelectionInterval(DefaultListSelectionModel.java:442)
at javax.swing.JTable.changeSelectionModel(JTable.java:2351)
at javax.swing.JTable.changeSelection(JTable.java:2420)
at quick.dbtable.ExtendedJTable.changeSelection(ExtendedJTable.java:145)
at javax.swing.plaf.basic.BasicTableUI$Actions.actionPerformed(BasicTableUI.java:526)
at javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1633)
at javax.swing.JComponent.processKeyBinding(JComponent.java:2839)
at javax.swing.JTable.processKeyBinding(JTable.java:5256)
at javax.swing.JComponent.processKeyBindings(JComponent.java:2885)
at javax.swing.JComponent.processKeyEvent(JComponent.java:2802)
at java.awt.Component.processEvent(Component.java:6040)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4630)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1850)
at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:712)
at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:990)
at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:855)
at java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:676)
at java.awt.Component.dispatchEventImpl(Component.java:4502)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Window.dispatchEventImpl(Window.java:2475)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)