SQL Power Business Intelligence Productivity Tools
Company OverviewBusiness Intelligence Productivity ToolsQuick-Start Implementation ServicesDemos & TurotialsFrequently Asked Questions (FAQ)Open Source Community ResourcesSQL Power ForumImplementation & Technology PartnersGet SQL Power SoftwareContact Us

SQL Power Software Forum

SQL Power Software Forum

  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page  [Register] Register /  [Login] Login 
Messages posted by: argyllsock
Forum Index » Profile for argyllsock » Messages posted by argyllsock
Author Message
Currently, when forward engineering a data model to MySQL, the tables default to the default engine.

Would be preferable if the Architect would allow the user to select the database engine to be used for the table.
Power*Architect 0.9.13-20090706174751
Copyright 2003-2009 SQL Power Group Inc.

Operating System:
Mac OS X 10.5.7 (i386)

Runtime Environment:
Java(TM) 2 Runtime Environment, Standard Edition
1.5.0_16-b06-284

I am able to generate and run ddls from a schema imported from a Postgres implementation. However, when I try to populate the data at the db level (ie. all tables), I get the following error:


java.lang.ClassCastException: ca.sqlpower.sqlobject.SQLSchema
at ca.sqlpower.architect.swingui.DataMoverPanel.doDataMove(DataMoverPanel.java:212)
at ca.sqlpower.architect.swingui.DataMoverPanel$2.actionPerformed(DataMoverPanel.java:181)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1882)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2202)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:25
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:5602)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
at java.awt.Component.processEvent(Component.java:5367)
at java.awt.Container.processEvent(Container.java:2010)
at java.awt.Component.dispatchEventImpl(Component.java:406
at java.awt.Container.dispatchEventImpl(Container.java:206
at java.awt.Component.dispatchEvent(Component.java:3903)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4256)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3936)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3866)
at java.awt.Container.dispatchEventImpl(Container.java:2054)
at java.awt.Window.dispatchEventImpl(Window.java:1801)
at java.awt.Component.dispatchEvent(Component.java:3903)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:176)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)


Some further troubleshooting:

When I create a table from scratch in the playpen, I am able to generate the DDL for MySQL. When I try to bring a single table from Postgres and engineer it into MySQL, I get the error.
Power*Architect 0.9.13-20090626122359
Copyright 2003-2009 SQL Power Group Inc.

Operating System:
Mac OS X 10.5.7 (i386)

Runtime Environment:
Java(TM) 2 Runtime Environment, Standard Edition
1.5.0_16-b06-284

I open a connection to a Postgres database and bring the contents into the playpen. I then try to forward engineer the model to a MySQL Database (connectivity confirmed) and I receive the error message detailed below. I even tried, with the same results, to forward engineer a single table (no relationships).

java.lang.NullPointerException
at ca.sqlpower.architect.ddl.MySqlDDLGenerator.addComment(MySqlDDLGenerator.java:501)
at ca.sqlpower.architect.ddl.GenericDDLGenerator.addTable(GenericDDLGenerator.java:825)
at ca.sqlpower.architect.ddl.GenericDDLGenerator.generateDDLStatements(GenericDDLGenerator.java:227)
at ca.sqlpower.architect.ddl.GenericDDLGenerator.generateDDLScript(GenericDDLGenerator.java:172)
at ca.sqlpower.architect.swingui.action.ExportDDLAction$1.call(ExportDDLAction.java:85)
at ca.sqlpower.architect.swingui.action.ExportDDLAction$1.call(ExportDDLAction.java:75)
at ca.sqlpower.swingui.DataEntryPanelBuilder$2.actionPerformed(DataEntryPanelBuilder.java:153)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1882)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2202)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:25
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:5602)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
at java.awt.Component.processEvent(Component.java:5367)
at java.awt.Container.processEvent(Container.java:2010)
at java.awt.Component.dispatchEventImpl(Component.java:406
at java.awt.Container.dispatchEventImpl(Container.java:206
at java.awt.Component.dispatchEvent(Component.java:3903)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4256)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3936)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3866)
at java.awt.Container.dispatchEventImpl(Container.java:2054)
at java.awt.Window.dispatchEventImpl(Window.java:1801)
at java.awt.Component.dispatchEvent(Component.java:3903)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:176)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
Power*Architect 0.9.13-20090626122359
Copyright 2003-2009 SQL Power Group Inc.

Operating System:
Mac OS X 10.5.7 (i386)

Runtime Environment:
Java(TM) 2 Runtime Environment, Standard Edition
1.5.0_16-b06-284

If I select a database as both the source and the target (both are MySQL-- InnoDB source and MyISAM target) for the Copy Table Data function, I get the following error:

java.lang.ClassCastException: ca.sqlpower.sqlobject.SQLCatalog
at ca.sqlpower.architect.swingui.DataMoverPanel.doDataMove(DataMoverPanel.java:212)
at ca.sqlpower.architect.swingui.DataMoverPanel$2.actionPerformed(DataMoverPanel.java:181)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1882)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2202)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:25
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:5602)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
at java.awt.Component.processEvent(Component.java:5367)
at java.awt.Container.processEvent(Container.java:2010)
at java.awt.Component.dispatchEventImpl(Component.java:406
at java.awt.Container.dispatchEventImpl(Container.java:206
at java.awt.Component.dispatchEvent(Component.java:3903)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4256)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3936)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3866)
at java.awt.Container.dispatchEventImpl(Container.java:2054)
at java.awt.Window.dispatchEventImpl(Window.java:1801)
at java.awt.Component.dispatchEvent(Component.java:3903)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:176)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)

The same error occurs irrespective of the names of the source and target databases. If the function is designed for a single table copy, I suggest simply disabling the selection of a database.
Wabit 0.9.7-20090623121048
Copyright 2003-2009 SQL Power Group Inc.

Operating System:
Mac OS X 10.5.7 (i386)

Runtime Environment:
Java(TM) 2 Runtime Environment, Standard Edition
1.5.0_16-b06-284

VM info:
Java HotSpot(TM) Client VM
1.5.0_16-133
Apple Inc.

The Wabit supports the selection of Preferences from the Wabit dropdown menu. Selection of this option invokes nothing. Since there is no equivalent on the Windows release, I believe that the Preferences option needs to be either hidden or deactived.
Power*Architect 0.9.13-rc2
Copyright 2003-2009 SQL Power Group Inc.

Operating System:
Mac OS X 10.5.7 (i386)

Runtime Environment:
Java(TM) 2 Runtime Environment, Standard Edition
1.5.0_16-b06-284

Create a simple table in MySQL. Populate the table with a few values (I created a single column).
Use Architect to forward engineer the table to Postgres. This works successfully.

Use the 'Copy Table Data' to copy the contents from MySQL to Postgres. You get the following error:

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"test"."test_table"' at line 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1027)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2537)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2466)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1383)
at ca.sqlpower.sql.jdbcwrapper.StatementDecorator.executeQuery(StatementDecorator.java:97)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
at ca.sqlpower.sql.DataMover.copyTable(DataMover.java:108)
at ca.sqlpower.architect.swingui.DataMoverPanel.moveSingleTable(DataMoverPanel.java:303)
at ca.sqlpower.architect.swingui.DataMoverPanel.doDataMove(DataMoverPanel.java:212)
at ca.sqlpower.architect.swingui.DataMoverPanel$2.actionPerformed(DataMoverPanel.java:177)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1882)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2202)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:5602)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
at java.awt.Component.processEvent(Component.java:5367)
at java.awt.Container.processEvent(Container.java:2010)
at java.awt.Component.dispatchEventImpl(Component.java:4068)
at java.awt.Container.dispatchEventImpl(Container.java:2068)
at java.awt.Component.dispatchEvent(Component.java:3903)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4256)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3936)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3866)
at java.awt.Container.dispatchEventImpl(Container.java:2054)
at java.awt.Window.dispatchEventImpl(Window.java:1801)
at java.awt.Component.dispatchEvent(Component.java:3903)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:176)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)


Follow up:

I also tried moving data from Postgres to MySQL and received the following error:

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"test"."test_table" (stuff) VALUES ('test value ' at line 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1027)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2543)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1737)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2022)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1940)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1925)
at ca.sqlpower.sql.jdbcwrapper.PreparedStatementDecorator.executeUpdate(PreparedStatementDecorator.java:120)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at ca.sqlpower.sql.DataMover.copyTable(DataMover.java:153)
at ca.sqlpower.architect.swingui.DataMoverPanel.moveSingleTable(DataMoverPanel.java:303)
at ca.sqlpower.architect.swingui.DataMoverPanel.doDataMove(DataMoverPanel.java:212)
at ca.sqlpower.architect.swingui.DataMoverPanel$2.actionPerformed(DataMoverPanel.java:177)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1882)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2202)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:5602)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
at java.awt.Component.processEvent(Component.java:5367)
at java.awt.Container.processEvent(Container.java:2010)
at java.awt.Component.dispatchEventImpl(Component.java:4068)
at java.awt.Container.dispatchEventImpl(Container.java:2068)
at java.awt.Component.dispatchEvent(Component.java:3903)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4256)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3936)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3866)
at java.awt.Container.dispatchEventImpl(Container.java:2054)
at java.awt.Window.dispatchEventImpl(Window.java:1801)
at java.awt.Component.dispatchEvent(Component.java:3903)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:176)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
What I am running:

Power*Architect 0.9.13-rc2

Operating System:
Mac OS X 10.5.7 (i386)

Runtime Environment:
Java(TM) 2 Runtime Environment, Standard Edition
1.5.0_16-b06-284

VM info:
Java HotSpot(TM) Client VM
1.5.0_16-133
Apple Inc.

Memory:
15MiB allocated (595MiB max); 6MiB free

To replicate:

Select 'Forward Engineer SQL Script'
Select a Target Database
Click on Properties
Click on 'OK' in Properties Window
You get 'A connection with the name <Database Connection> already exists'

What I think should happen is the Properties Window is closed and control is returned to the 'Forward Engineer SQL Script' window.
It would be great if the user guide referred to the Architect version number it relates to on the cover sheet. I found myself working with an outdated copy of the guide!
To reproduce:

Mac 10.5.7
MySQL 5.1.35

Create a connection to a local installation of MySQL. The playpen can be populated with metadata from the instance. Attempt to remove the connection via right clicking on the connection and selecting 'Remove Connection'. Receive the following error:

java.lang.NullPointerException
at ca.sqlpower.sqlobject.SQLObjectUtils.findColumnsSourcedFromDatabase(SQLObjectUtils.java:399)
at ca.sqlpower.architect.SourceObjectIntegrityWatcher.dbChildrenPreRemove(SourceObjectIntegrityWatcher.java:42)
at ca.sqlpower.sqlobject.SQLObject.fireDbChildrenPreRemove(SQLObject.java:613)
at ca.sqlpower.sqlobject.SQLObject.fireDbChildPreRemove(SQLObject.java:633)
at ca.sqlpower.sqlobject.SQLObject.removeImpl(SQLObject.java:410)
at ca.sqlpower.sqlobject.SQLObject.removeChild(SQLObject.java:391)
at ca.sqlpower.sqlobject.SQLObject.removeChild(SQLObject.java:400)
at ca.sqlpower.architect.swingui.action.RemoveSourceDBAction.actionPerformed(RemoveSourceDBAction.java:55)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1882)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2202)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:25
at javax.swing.AbstractButton.doClick(AbstractButton.java:334)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1051)
at apple.laf.CUIAquaMenuItem.doClick(CUIAquaMenuItem.java:119)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1092)
at java.awt.Component.processMouseEvent(Component.java:5602)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
at java.awt.Component.processEvent(Component.java:5367)
at java.awt.Container.processEvent(Container.java:2010)
at java.awt.Component.dispatchEventImpl(Component.java:406
at java.awt.Container.dispatchEventImpl(Container.java:206
at java.awt.Component.dispatchEvent(Component.java:3903)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4256)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3936)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3866)
at java.awt.Container.dispatchEventImpl(Container.java:2054)
at java.awt.Window.dispatchEventImpl(Window.java:1801)
at java.awt.Component.dispatchEvent(Component.java:3903)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:176)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
Hi,

Is there an easy way for the community to create new transformation functions and to share them? Ideally, one would be able to go to a community area, review the available functions, and import them into the DQ Guru as needed.

Thanks
Hi,

I've been playing with DQ Guru. As a non-technical individual, it would be nice to be able to create 'super transformations' that are made up of the base transformations already contained within DQ Guru. I would then be able to reuse some of the more complex cleansing processes that I've developed.

Thanks,
Postgres 8.3.7
DQ Guru 0.9.5-20090423135916
Both running locally on Windows XP SP 2

When attempting to generate a sample table, the first time I click the 'Create' button, nothing happens (create button remains active). Second time I click the 'Create' button, I receive the following error messages:

ca.sqlpower.sqlobject.SQLObjectException: The table Demo_DB.JK.Demo_table already exists
at ca.sqlpower.sqlobject.SQLObjectUtils.addSimulatedTable(SQLObjectUtils.java:294)
at ca.sqlpower.matchmaker.swingui.BuildExampleTableDialog.generateTableSQL(BuildExampleTableDialog.java:306)
at ca.sqlpower.matchmaker.swingui.BuildExampleTableDialog$2.actionPerformed(BuildExampleTableDialog.java:24
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.Dialog$1.run(Unknown Source)
at java.awt.Dialog$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Dialog.show(Unknown Source)
at java.awt.Component.show(Unknown Source)
at java.awt.Component.setVisible(Unknown Source)
at java.awt.Window.setVisible(Unknown Source)
at java.awt.Dialog.setVisible(Unknown Source)
at ca.sqlpower.matchmaker.swingui.action.BuildExampleTableAction.actionPerformed(BuildExampleTableAction.java:44)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.AbstractButton.doClick(Unknown Source)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
MySQL is running on MAC OS X
To reproduce:

DQ Guru release 0.9.5-20090423135916

Going against a MySQL database (R5.1 - movies), Follow the steps listed for creating a De-duping project in the DQGuru user manual. When you get to the run match engine step, the following error occurs:

ca.sqlpower.matchmaker.SourceTableException: PreCondition failed: Source table structure has changed!
at ca.sqlpower.matchmaker.MatchEngineImpl.checkPreconditions(MatchEngineImpl.java:107)
at ca.sqlpower.matchmaker.MatchEngineImpl.call(MatchEngineImpl.java:172)
at ca.sqlpower.matchmaker.swingui.engine.EngineWorker.doStuff(EngineWorker.java:117)
at ca.sqlpower.swingui.SPSwingWorker.run(SPSwingWorker.java:60)
at java.lang.Thread.run(Unknown Source)

The tables were created just before running the process. I'm pretty sure there's not any 'legacy' items that could be impacting this - in any case, an abort like this should not occur.
 
Forum Index » Profile for argyllsock » Messages posted by argyllsock
Go to:   
Powered by JForum 2.1.8 © JForum Team