[Middlegen-user] Importing tables fails

Hmm, it appears to be a problem with the way my sql script builds the
tables...it's leaving a lock on the tables or a transaction open. Middlegen
doesn't like this.

Steve

----- Original Message -----
From: "Steve Knight" <***@hotmail.com>
To: <middlegen-***@lists.sourceforge.net>; <***@netcom.no>
Sent: Wednesday, February 20, 2002 11:51 AM
Subject: Importing tables fails

Post by Steve Knight
Aslak,
I'm having more of a user issue now.
When I try to import my tables into the gui it gives me the following
middlegen
java.util.NoSuchElementException
at java.util.StringTokenizer.nextToken(StringTokenizer.java:235)
at org.gjt.mm.mysql.DatabaseMetaData.getImportedKeys(Unknown Source)
at middlegen.MiddlegenPopulator.setFields(Unknown Source)
at middlegen.MiddlegenPopulator.addTables(Unknown Source)
at middlegen.MiddlegenPopulator.populate(Unknown Source)
at middlegen.swing.JMiddlegenPanel$3.actionPerformed(Unknown Source)
at

javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1450)

javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButto

Post by Steve Knight
n.java:1504)
at

javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:3

Post by Steve Knight
78)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:250)
at javax.swing.AbstractButton.doClick(AbstractButton.java:279)
at

javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(Basic

Post by Steve Knight
MenuItemUI.java:886)
at java.awt.Component.processMouseEvent(Component.java:3715)
at java.awt.Component.processEvent(Component.java:3544)
at java.awt.Container.processEvent(Container.java:1164)
at java.awt.Component.dispatchEventImpl(Component.java:2593)
at java.awt.Container.dispatchEventImpl(Container.java:1213)
at java.awt.Component.dispatchEvent(Component.java:2497)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:2451)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:2216)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:2125)
at java.awt.Container.dispatchEventImpl(Container.java:1200)
at java.awt.Window.dispatchEventImpl(Window.java:926)
at java.awt.Component.dispatchEvent(Component.java:2497)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:339)
at

java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.ja

Post by Steve Knight
va:131)
at

java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java

Post by Steve Knight
:98)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:85)
It only does this for the database I need it to work for!!! When I try it
with any other database it works fine!
There must be something obvious that I am missing here. Any ideas what
would cause this?
Thanks,
Steve

a***@netcom.no

2002-02-20 16:27:05 UTC

Steve,

It fails on this line in middlegen.MiddlegenPopulator.setFields
(middlegen.Table) {
...
ResultSet fkRs = getMetaData().getImportedKeys
(_connectionSettings.getCatalog(), _connectionSettings.getSchema(),
tableName);
...
}

Apparently, the call to the MM.MySQL driver's getPrimaryKeys a few
lines above works fine with the same values, so I suspect this might be
a bug in the JDBC driver.

Perhaps you could insert some debug statements on the line above and
print out the values of the three parameters sent to the
getImportedKeys method?

Can you try that, mail me back the results (positive or negative) along
with the version of the JDBC driver you're using? I might have to pass
this over to Mark Matthews (the driver author). You should of course
use the latest version of the driver (2.0.11) in case you ain't.

Good luck!

-Aslak
----- Original Message -----
From: "Steve Knight" <***@hotmail.com>
Date: Wednesday, February 20, 2002 5:51 pm
Subject: [Middlegen-user] Importing tables fails

Post by Steve Knight
Aslak,
I'm having more of a user issue now.
When I try to import my tables into the gui it gives me the
middlegen
java.util.NoSuchElementException
at java.util.StringTokenizer.nextToken(StringTokenizer.java:235)
at org.gjt.mm.mysql.DatabaseMetaData.getImportedKeys(Unknown Source)
at middlegen.MiddlegenPopulator.setFields(Unknown Source)
at middlegen.MiddlegenPopulator.addTables(Unknown Source)
at middlegen.MiddlegenPopulator.populate(Unknown Source)
at middlegen.swing.JMiddlegenPanel$3.actionPerformed(Unknown Source)
at
javax.swing.AbstractButton.fireActionPerformed

(AbstractButton.java:1450) at

Post by Steve Knight
javax.swing.AbstractButton$ForwardActionEvents.actionPerformed

(AbstractButto

Post by Steve Knight
n.java:1504)
at
javax.swing.DefaultButtonModel.fireActionPerformed

(DefaultButtonModel.java:3

Post by Steve Knight
78)
at
javax.swing.DefaultButtonModel.setPressed

(DefaultButtonModel.java:250) at javax.swing.AbstractButton.doClick
(AbstractButton.java:279)

Post by Steve Knight
at
javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased

(Basic

(Container.java:2451) at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:2216)

Post by Steve Knight
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:2125)
at java.awt.Container.dispatchEventImpl(Container.java:1200)
at java.awt.Window.dispatchEventImpl(Window.java:926)
at java.awt.Component.dispatchEvent(Component.java:2497)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:339)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy

(EventDispatchThread.ja

Post by Steve Knight
va:131)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy

(EventDispatchThread.java

Post by Steve Knight
:98)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)

at java.awt.EventDispatchThread.run(EventDispatchThread.java:85)

Post by Steve Knight
It only does this for the database I need it to work for!!! When
I try it
with any other database it works fine!
There must be something obvious that I am missing here. Any ideas
whatwould cause this?
Thanks,
Steve
_______________________________________________
middlegen-user mailing list
https://lists.sourceforge.net/lists/listinfo/middlegen-user

Steve Knight

2002-02-20 18:24:17 UTC

Actually, it appears to be a MySQL-InnoDB issue. I have narrowed it down to
one table that is causing the problems...when I take the table out,
everything works. It is very bizarre as I have 2 other tables that are
almost identical, yet they cause no problems. In fact, Middlegen will
actually crash the MySQL server when this bad table exists! I am currently
using the 4.0.1a version so I am going to try it out with 3.23.48 and see if
that works.

Thanks,

Steve

----- Original Message -----
From: <***@netcom.no>
To: "Steve Knight" <***@hotmail.com>
Cc: <middlegen-***@lists.sourceforge.net>
Sent: Wednesday, February 20, 2002 1:22 PM
Subject: Re: [Middlegen-user] Importing tables fails

Post by a***@netcom.no
Steve,
It fails on this line in middlegen.MiddlegenPopulator.setFields
(middlegen.Table) {
...
ResultSet fkRs = getMetaData().getImportedKeys
(_connectionSettings.getCatalog(), _connectionSettings.getSchema(),
tableName);
...
}
Apparently, the call to the MM.MySQL driver's getPrimaryKeys a few
lines above works fine with the same values, so I suspect this might be
a bug in the JDBC driver.
Perhaps you could insert some debug statements on the line above and
print out the values of the three parameters sent to the
getImportedKeys method?
Can you try that, mail me back the results (positive or negative) along
with the version of the JDBC driver you're using? I might have to pass
this over to Mark Matthews (the driver author). You should of course
use the latest version of the driver (2.0.11) in case you ain't.
Good luck!
-Aslak
----- Original Message -----
Date: Wednesday, February 20, 2002 5:51 pm
Subject: [Middlegen-user] Importing tables fails

(AbstractButton.java:1450) at

Post by Steve Knight
javax.swing.AbstractButton$ForwardActionEvents.actionPerformed

(AbstractButto

Post by Steve Knight
n.java:1504)
at
javax.swing.DefaultButtonModel.fireActionPerformed

(DefaultButtonModel.java:3

Post by Steve Knight
78)
at
javax.swing.DefaultButtonModel.setPressed

(DefaultButtonModel.java:250) at javax.swing.AbstractButton.doClick
(AbstractButton.java:279)

Post by Steve Knight
at
javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased

(Basic

(Container.java:2451) at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:2216)

(EventDispatchThread.ja

Post by Steve Knight
va:131)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy

(EventDispatchThread.java

Post by Steve Knight
:98)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)

at java.awt.EventDispatchThread.run(EventDispatchThread.java:85)

a***@netcom.no

2002-02-20 18:38:50 UTC

InnoDB works for me if table names are in small letters. It don't if
they are in CAPS.

My 2 cents

a

----- Original Message -----
From: "Steve Knight" <***@hotmail.com>
Date: Wednesday, February 20, 2002 9:16 pm
Subject: Re: [Middlegen-user] Importing tables fails

Post by Steve Knight
Actually, it appears to be a MySQL-InnoDB issue. I have narrowed
it down to
one table that is causing the problems...when I take the table out,
everything works. It is very bizarre as I have 2 other tables
that are
almost identical, yet they cause no problems. In fact, Middlegen will
actually crash the MySQL server when this bad table exists! I am
currentlyusing the 4.0.1a version so I am going to try it out with
3.23.48 and see if
that works.
Thanks,
Steve
----- Original Message -----
Sent: Wednesday, February 20, 2002 1:22 PM
Subject: Re: [Middlegen-user] Importing tables fails

might be

Post by a***@netcom.no
a bug in the JDBC driver.
Perhaps you could insert some debug statements on the line above and
print out the values of the three parameters sent to the
getImportedKeys method?
Can you try that, mail me back the results (positive or

negative) along

Post by a***@netcom.no
with the version of the JDBC driver you're using? I might have

to pass

Post by a***@netcom.no
this over to Mark Matthews (the driver author). You should of course
use the latest version of the driver (2.0.11) in case you ain't.
Good luck!
-Aslak
----- Original Message -----
Date: Wednesday, February 20, 2002 5:51 pm
Subject: [Middlegen-user] Importing tables fails

Source)> > at middlegen.MiddlegenPopulator.setFields(Unknown Source)

Post by Steve Knight
at middlegen.MiddlegenPopulator.addTables(Unknown Source)
at middlegen.MiddlegenPopulator.populate(Unknown Source)
at middlegen.swing.JMiddlegenPanel$3.actionPerformed(Unknown

Source)> > at

Post by Steve Knight
javax.swing.AbstractButton.fireActionPerformed

(AbstractButton.java:1450) at

Post by Steve Knight
javax.swing.AbstractButton$ForwardActionEvents.actionPerformed

(AbstractButto

Post by Steve Knight
n.java:1504)
at
javax.swing.DefaultButtonModel.fireActionPerformed

(DefaultButtonModel.java:3

Post by Steve Knight
78)
at
javax.swing.DefaultButtonModel.setPressed

(DefaultButtonModel.java:250) at javax.swing.AbstractButton.doClick
(AbstractButton.java:279)

javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased>
(Basic

(Container.java:2451) at

java.awt.LightweightDispatcher.processMouseEvent(Container.java:2216)

Post by a***@netcom.no
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:2125)

Post by Steve Knight
at java.awt.Container.dispatchEventImpl(Container.java:1200)
at java.awt.Window.dispatchEventImpl(Window.java:926)
at java.awt.Component.dispatchEvent(Component.java:2497)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:339)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy

(EventDispatchThread.ja

Post by Steve Knight
va:131)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy

(EventDispatchThread.java

Post by Steve Knight
:98)
at

java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)>

at java.awt.EventDispatchThread.run(EventDispatchThread.java:85)

Steve Knight

2002-02-20 20:05:10 UTC

It was the version of MySQL we were using. I guess 4.0.1 still has a lot of
bugs. 3.23.48 seems to be working ok.
Note to self...never use alpha versions! We were burned twice by this
problem today with MySQL and MyODBC. Reverting back to the stable releases
solved all our problems.

Thanks for the help,

Steve

----- Original Message -----
From: <***@netcom.no>
To: "Steve Knight" <***@hotmail.com>
Cc: <middlegen-***@lists.sourceforge.net>
Sent: Wednesday, February 20, 2002 3:25 PM
Subject: Re: [Middlegen-user] Importing tables fails

Post by a***@netcom.no
InnoDB works for me if table names are in small letters. It don't if
they are in CAPS.
My 2 cents
a
----- Original Message -----
Date: Wednesday, February 20, 2002 9:16 pm
Subject: Re: [Middlegen-user] Importing tables fails

might be

negative) along

Post by a***@netcom.no
with the version of the JDBC driver you're using? I might have

to pass

Source)> > at middlegen.MiddlegenPopulator.setFields(Unknown Source)

Post by Steve Knight
at middlegen.MiddlegenPopulator.addTables(Unknown Source)
at middlegen.MiddlegenPopulator.populate(Unknown Source)
at middlegen.swing.JMiddlegenPanel$3.actionPerformed(Unknown

Source)> > at

Post by Steve Knight
javax.swing.AbstractButton.fireActionPerformed

(AbstractButton.java:1450) at

Post by Steve Knight
javax.swing.AbstractButton$ForwardActionEvents.actionPerformed

(AbstractButto

Post by Steve Knight
n.java:1504)
at
javax.swing.DefaultButtonModel.fireActionPerformed

(DefaultButtonModel.java:3

Post by Steve Knight
78)
at
javax.swing.DefaultButtonModel.setPressed

(DefaultButtonModel.java:250) at javax.swing.AbstractButton.doClick
(AbstractButton.java:279)

javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased>
(Basic

(Container.java:2451) at

java.awt.LightweightDispatcher.processMouseEvent(Container.java:2216)

Post by a***@netcom.no
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:2125)

(EventDispatchThread.ja

Post by Steve Knight
va:131)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy

(EventDispatchThread.java

Post by Steve Knight
:98)
at

java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)>

at java.awt.EventDispatchThread.run(EventDispatchThread.java:85)

_______________________________________________
middlegen-user mailing list
https://lists.sourceforge.net/lists/listinfo/middlegen-user

Aslak Hellesøy

2002-02-20 23:00:11 UTC

ok. if you narrow it down good enough to spot the sinner i'm sure the authors would love to hear about it. don't hesitate to tell the mysql/innodb/jdbc guys about any bugs you might find. especially this, cause it's meta data related, and that's not a very common usage area. they probably don't receive a lot of bug reports about that.

keep up the work pal!

-aslak

B| aslak hellesoy, manager
E| +47 982 19 432, ***@bekk.no
K| bekk consulting as, pb. 134 sentrum, 0102 oslo, norway
K| www.bekk.no

_____________Original message ____________
Subject: Re: [Middlegen-user] Importing tables fails
Sender: ***@netcom.no
Date: Thu, 21 Feb 2002 01:52:40 +0100

InnoDB works for me if table names are in small letters. It don't if
they are in CAPS.

My 2 cents

a

----- Original Message -----
From: "Steve Knight" <***@hotmail.com>
Date: Wednesday, February 20, 2002 9:16 pm
Subject: Re: [Middlegen-user] Importing tables fails

might be

negative) along

Post by a***@netcom.no
with the version of the JDBC driver you're using? I might have

to pass

Source)> > at middlegen.MiddlegenPopulator.setFields(Unknown Source)

Post by Steve Knight
at middlegen.MiddlegenPopulator.addTables(Unknown Source)
at middlegen.MiddlegenPopulator.populate(Unknown Source)
at middlegen.swing.JMiddlegenPanel$3.actionPerformed(Unknown

Source)> > at

Post by Steve Knight
javax.swing.AbstractButton.fireActionPerformed

(AbstractButton.java:1450) at

Post by Steve Knight
javax.swing.AbstractButton$ForwardActionEvents.actionPerformed

(AbstractButto

Post by Steve Knight
n.java:1504)
at
javax.swing.DefaultButtonModel.fireActionPerformed

(DefaultButtonModel.java:3

Post by Steve Knight
78)
at
javax.swing.DefaultButtonModel.setPressed

(DefaultButtonModel.java:250) at javax.swing.AbstractButton.doClick
(AbstractButton.java:279)

javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased>
(Basic

(Container.java:2451) at

java.awt.LightweightDispatcher.processMouseEvent(Container.java:2216)

Post by a***@netcom.no
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:2125)

(EventDispatchThread.ja

Post by Steve Knight
va:131)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy

(EventDispatchThread.java

Post by Steve Knight
:98)
at

java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)>

at java.awt.EventDispatchThread.run(EventDispatchThread.java:85)