SQL Power Software Forum

Some databases (in MySQL) produce an empty query error message when opened:

Your query could not be executed due to the following error:

java.sql.SQLException: Can not issue empty query.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
at com.mysql.jdbc.StatementImpl.checkNullOrEmptyQuery(StatementImpl.java:437)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:594)
at ca.sqlpower.sql.jdbcwrapper.StatementDecorator.execute(StatementDecorator.java:97)
at ca.sqlpower.swingui.query.SQLQueryUIComponents$ExecuteSQLWorker.doStuff(SQLQueryUIComponents.java:283)
at ca.sqlpower.swingui.SPSwingWorker.run(SPSwingWorker.java:73)
at java.lang.Thread.run(Unknown Source)

Whenever I drag a table into the Playpen for the first time it displays an error message: Failed to populate indices (see attached image).

The table name is not necessarily the one being dragged.

1. There should be a Progress Bar or a message displayed when performing an Automatch

2. 'Use Regular Expression' should be clicked by default in Munge Process definitions.

Get this error message when trying to save a munge process:

org.hibernate.TransientObjectException: object references an unsaved transient instance - save the transient instance before flushing: ca.sqlpower.matchmaker.munge.MungeProcess
at org.hibernate.engine.ForeignKeys.getEntityIdentifierIfNotUnsaved(ForeignKeys.java:219)
at org.hibernate.collection.AbstractPersistentCollection.getOrphans(AbstractPersistentCollection.java:889)
at org.hibernate.collection.PersistentBag.getOrphans(PersistentBag.java:120)
at org.hibernate.engine.CollectionEntry.getOrphans(CollectionEntry.java:350)
at org.hibernate.engine.Cascade.deleteOrphans(Cascade.java:340)
at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:324)
at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:242)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:219)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
at org.hibernate.engine.Cascade.cascade(Cascade.java:130)
at org.hibernate.event.def.AbstractFlushingEventListener.cascadeOnFlush(AbstractFlushingEventListener.java:130)
at org.hibernate.event.def.AbstractFlushingEventListener.prepareEntityFlushes(AbstractFlushingEventListener.java:121)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:65)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at ca.sqlpower.matchmaker.dao.hibernate.AbstractMatchMakerDAOHibernate.save(Unknown Source)
at ca.sqlpower.matchmaker.dao.hibernate.AbstractMatchMakerDAOHibernate.save(Unknown Source)
at ca.sqlpower.matchmaker.swingui.MatchMakerSwingSession.save(Unknown Source)
at ca.sqlpower.matchmaker.undo.AbstractUndoableEditorPane.applyChanges(Unknown Source)
at ca.sqlpower.matchmaker.swingui.MungeProcessEditor.applyChanges(Unknown Source)
at ca.sqlpower.matchmaker.swingui.MungeProcessEditor$5.actionPerformed(Unknown Source)
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.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)

It should be possible to expand individual fields by clicking on them in the Munge Process Definition screen.

In Validate Matches screen column headings should be displayed in cluster graphs. At least it should be available as an option.

Include Login button the DB Connection Manager to enable explicit login operation.

When MM opens a new DB connection, it should display an hourglass with a message "Connecting to a database".