SQL Power Software Forum

Yes, the statement will run if the connection alias is removed.
I suggest that it isn't automatically added.

In the project definition page when trying to select the schema from the drop down list, it requires 2 trials before the schema is selected.

From the Table menu, and selecting Table Explorer.

The SQL statement that is automatically generated does not run.
The generated SQL statement includes the connection name when it calls the table.

For example;
SELECT * FROM MatchMakerDefaultRepository.PUBLIC.GROUP_OBJECT_PRIVS

in this example
MatchMakerDefaultRepository = the connection alias
PUBLIC = the schema
GROUP_OBJECT_PRIVS = the table name

Running the defaulted SQL statement yields and error.
Don't need the connection alias, just wanted to suggest that it doesn't appear in the defaulted SQL statement.

The CSV writer munge process doesn't seem to work. PowerMatchMaker doesn't allow it to be selected.

Selecting this munge process, the error is as follows;
java.lang.RuntimeException: Error generating munge step component: ca.sqlpower.matchmaker.swingui.munge.CSVWriterMungeComponent. Possibly caused by an error thrown in the constructor.
at ca.sqlpower.matchmaker.swingui.SwingSessionContextImpl.getMungeComponent(Unknown Source)
at ca.sqlpower.matchmaker.swingui.munge.MungePen$MungePenMungeProcessListener.mmChildrenInserted(Unknown Source)
at ca.sqlpower.matchmaker.event.MatchMakerEventSupport.fireChildrenInserted(Unknown Source)
at ca.sqlpower.matchmaker.AbstractMatchMakerObject.addImpl(Unknown Source)
at ca.sqlpower.matchmaker.munge.MungeProcess.addImpl(Unknown Source)
at ca.sqlpower.matchmaker.munge.MungeProcess.addImpl(Unknown Source)
at ca.sqlpower.matchmaker.AbstractMatchMakerObject.addChild(Unknown Source)
at ca.sqlpower.matchmaker.swingui.munge.MungePen.addMungeStep(Unknown Source)
at ca.sqlpower.matchmaker.swingui.munge.MungePen.drop(Unknown Source)
at java.awt.dnd.DropTarget.drop(Unknown Source)
at sun.awt.dnd.SunDropTargetContextPeer.processDropMessage(Unknown Source)
at sun.awt.dnd.SunDropTargetContextPeer$EventDispatcher.dispatchDropEvent(Unknown Source)
at sun.awt.dnd.SunDropTargetContextPeer$EventDispatcher.dispatchEvent(Unknown Source)
at sun.awt.dnd.SunDropTargetEvent.dispatch(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.processDropTargetEvent(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)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
... 30 more
Caused by: java.lang.IndexOutOfBoundsException: The grid width 3 must be less than or equal to 1.
at com.jgoodies.forms.layout.CellConstraints.ensureValidGridBounds(CellConstraints.java:942)
at com.jgoodies.forms.layout.FormLayout.setConstraints(FormLayout.java:734)
at com.jgoodies.forms.layout.FormLayout.addLayoutComponent(FormLayout.java:925)
at java.awt.Container.addImpl(Unknown Source)
at java.awt.Container.add(Unknown Source)
at com.jgoodies.forms.builder.AbstractFormBuilder.add(AbstractFormBuilder.java:55

at com.jgoodies.forms.builder.DefaultFormBuilder.append(DefaultFormBuilder.java:413)
at ca.sqlpower.matchmaker.swingui.munge.CSVWriterMungeComponent.buildUI(Unknown Source)
at ca.sqlpower.matchmaker.swingui.munge.AbstractMungeComponent.<init>(Unknown Source)
at ca.sqlpower.matchmaker.swingui.munge.AbstractMungeComponent.<init>(Unknown Source)
at ca.sqlpower.matchmaker.swingui.munge.CSVWriterMungeComponent.<init>(Unknown Source)
... 34 more

Thanks Jonathan,

That's perfect, exactly what I was looking for. I guess I should have worded my question a little differently. But thanks for understanding

There is a reference to Interweb in the user guide. I was wondering where or how to access it. It is in reference to getting more information about regular expressions. Specifically in the example of a munge process.

Actually, the reason why I suggested placing the User Preferences in the Tools drop down list was because I couldn't find it. In the version of Matchmaker that I downloaded, there is no User Preference option in any of the drop down menus.

I also checked with a colleagues, and his doesn't not have User Preferences either.

It may just be me

, but I'm not sure where to find User Preferences.
I suggest placing the User Preferences in the Tools drop down list.

Creating a Munge Process - 'Retain Characters'
For example for phone number column, retaining all the digits in the input.
If the output of the munge process is null the output table does not accept the value. An error occurs.

It would be desirable to allow the output table to accept a null result.

When creating a new project.
After filling in all the required fields, clicking on the SAVE button and executing the CREATE output statement, I suggest having a msg box indicating the project was saved. Otherwise, it leaves the user wondering. The Output Table was created, now do I need to click save again?

Currently, when you open the PowerMatchmaker, a window opens the default repository in one window. When the user logs into the desired repository PowerMatchmaker opens a new window. If the user closes the first default window, both the default and the desired windows close.

It would be desirable to only have one window open after logging into the desired database connection and repository.

when adding a new column, while in the new column properties. if the user clicks on cancel. the new column remains in the table.
suggestion is when adding a new column if user clicks on cancel that column does not appear in the table.

to scale the printing of the playpen, currently there's a scale that is dragged.
suggestion is to have the option to type in the print scale.

PowerMatchMaker Developers,

Here's a little suggestion,
make an option available to create a new folder, while in matchmaker.
From the screen shots of the matchmaker product, there used to be a folder menu.

Hey Jonathan,

Sorry for all the going back and forth. I hope I've got the msg across this time. The images are attached.

Thanks,
Lily