Make your own free website on Tripod.com

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]

Re: InstantDB: ALTER TABLE tableName DROP column BUG


Peter,
I do have a sql1.txt script that illustrates the bug.  However, it is 531 lines
long.  I hate to include it here because it will fill up the mailboxes off all
the list members.  Should I send it directly to you?

The script has 514 "INSERT INTO myTable VALUES(...)" lines.  If I remove any of
these INSERT lines then the script runs fine and does not throw an exception.  I
wonder if I am hitting some buffer limit.

Let me know if you want me to sent my script directly to you.

Thanks,
Ed Kaltenbach

>
>
>   ------------------------------------------------------------------------
>
> Subject: Re: InstantDB: ALTER TABLE tableName DROP column BUG
> Date: Thu, 17 Aug 2000 10:23:38 +0100
> From: "Peter Hearty" <peter.hearty@lutris.com>
> Reply-To: instantDB@enhydra.org
> To: <instantDB@enhydra.org>
>
> Hi Ed
>
> I wasn't able to reproduce this with a simple test. Maybe you could modify
> the attached script so that it looks more like the table you're trying to
> modify. Alternatively, a small self-contained java class that generates the
> problem would do.
>
> Regards
>
> Peter Hearty
> Lutris Technologies UK Ltd.
> -----Original Message-----
> From: Ed Kaltenbach <ekaltenbach@ara.com>
> To: instantdb@enhydra.org <instantdb@enhydra.org>
> Date: 16 August 2000 16:33
> Subject: 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(DefaultCellEdi
> tor.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.jav
> a: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.
> >
>
>   ------------------------------------------------------------------------
>                Name: sql1.txt
>    sql1.txt    Type: Plain Text (text/plain)
>            Encoding: 7bit

-----------------------------------------------------------------------------
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.