InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

InstantDB: ALTER TABLE tableName DROP column BUG


Hello,
I have uncovered a bug in InstantDB.

If I enter the following SQL command: "ALTER TABLE LETHALITY DROP
Weapon2"
then: "SELECT * FROM LETHALITY"
I get an exception.
It works fine with idb 3.13, but 3.14 and the newest 3.20b1 both have
the bug.
Any chance of getting it fixed before the final (non beta) release of
version 3.2?

Here is the exception I am getting:
AWT-EventQueue-0 ALTER TABLE LETHALITY DROP Weapon2
AWT-EventQueue-0 DELETE FROM qtar$db$cols WHERE ColId = 6840
AWT-EventQueue-0 UPDATE qtar$db$cols SET offset = offset - 4 WHERE
TableID = 1568 AND offset > 21
AWT-EventQueue-0 Select * from LETHALITY
AWT-EventQueue-0 java.sql.SQLException: Problem reading column,
UNCERTAINTY, in table, LETHALITY, java.io.EOFException
java.sql.SQLException: Problem reading column, UNCERTAINTY, in table,
LETHALITY, java.io.EOFException
        at org.enhydra.instantdb.db.SQLProg.execute(SQLProg.java:276,
Compiled Code)
        at
org.enhydra.instantdb.jdbc.idbStatement.execute(idbStatement.java:235,
Compiled Code)
        at
org.enhydra.instantdb.jdbc.idbStatement.executeQuery(idbStatement.java:91,
Compiled Code)
        at JDBCAdapter.executeQuery(JDBCAdapter.java:287, Compiled Code)

        at QTAR.updateWeaponColumns(QTAR.java:8533)
        at QTAR$1.actionPerformed(QTAR.java:725)
        at JDBCAdapter.setValueAt(JDBCAdapter.java:1008, Compiled Code)
        at TableSorter.setValueAt(TableSorter.java:314)
        at javax.swing.JTable.setValueAt(JTable.java:1416)
        at javax.swing.JTable.editingStopped(JTable.java:2544)
        at
javax.swing.DefaultCellEditor.fireEditingStopped(DefaultCellEditor.java:227)

        at
javax.swing.DefaultCellEditor$EditorDelegate.actionPerformed(DefaultCellEditor.java:329)

        at
javax.swing.JTextField.fireActionPerformed(JTextField.java:409)
        at javax.swing.JTextField.postActionEvent(JTextField.java:443)
        at
javax.swing.JTextField$NotifyAction.actionPerformed(JTextField.java:537)

        at
javax.swing.text.JTextComponent.mapEventToAction(JTextComponent.java:966,
Compiled Code)
        at
javax.swing.text.JTextComponent.processComponentKeyEvent(JTextComponent.java:1431,
Compiled Code)
        at javax.swing.JComponent.processKeyEvent(JComponent.java:1538,
Compiled Code)
        at java.awt.Component.processEvent(Component.java:3008, Compiled
Code)
        at java.awt.Container.processEvent(Container.java:990, Compiled
Code)
        at java.awt.Component.dispatchEventImpl(Component.java:2394,
Compiled Code)
        at java.awt.Container.dispatchEventImpl(Container.java:1035,
Compiled Code)
        at java.awt.Component.dispatchEvent(Component.java:2307,
Compiled Code)
        at
java.awt.LightweightDispatcher.processKeyEvent(Container.java:1770,
Compiled Code)
        at
java.awt.LightweightDispatcher.dispatchEvent(Container.java:1740,
Compiled Code)
        at java.awt.Container.dispatchEventImpl(Container.java:1022,
Compiled Code)
        at java.awt.Window.dispatchEventImpl(Window.java:749, Compiled
Code)
        at java.awt.Component.dispatchEvent(Component.java:2307,
Compiled Code)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:287,
Compiled Code)
        at
java.awt.EventDispatchThread.pumpOneEvent(EventDispatchThread.java:103,
Compiled Code)
        at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:92)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:83)





-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.