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


Ed

Sure - send me the script. Like you say, sounds like you may be running into
some unexpected limit. Might help to zip it up first though.

My email's peter.hearty@lutris.com.

Regards

Pete

--

Peter Hearty                         peter.hearty@lutris.com
Lutris Technologies (UK)        http://www.lutris.com
----- Original Message -----
From: "Ed Kaltenbach" <ekaltenbach@ara.com>
To: <instantDB@enhydra.org>
Sent: Friday, September 08, 2000 7:31 PM
Subject: 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.
>

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