DQguru does not properly handle SQL Server (2005) tables with spaces in their name

What steps will reproduce the problem?
1. Create a table in a SQL Server 2005 instance with a space in its name. I
used 'foo bar' with one column called 'foo'
2. Create a new de-duping project on this table.
3. Create a new transformation on this table.

What is the expected output? What do you see instead?
I expected the transformation to get created. Instead, a SQLServerException
gets thrown.

Is there an error stacktrace? If so, please paste it below.
SQLInputStep attempted to execute the statement:
'SELECT foo FROM jeffrey.dbo.foo bar'

The resulting stacktrace is:
java.lang.RuntimeException: Failed to refresh step foo bar
    at
ca.sqlpower.matchmaker.swingui.munge.AbstractMungeComponent.<init>(AbstractMunge
Component.java:255)
    at
ca.sqlpower.matchmaker.swingui.munge.SQLInputMungeComponent.<init>(SQLInputMunge
Component.java:40)
    at
ca.sqlpower.matchmaker.swingui.SwingSessionContextImpl.getMungeComponent(SwingSe
ssionContextImpl.java:596)
    at
ca.sqlpower.matchmaker.swingui.munge.MungePen.buildComponents(MungePen.java:408)
    at ca.sqlpower.matchmaker.swingui.munge.MungePen.<init>(MungePen.java:233)
    at
ca.sqlpower.matchmaker.swingui.MungeProcessEditor.<init>(MungeProcessEditor.java
:129)
    at
ca.sqlpower.matchmaker.swingui.MatchMakerTreeMouseAndSelectionListener.valueChan
ged(MatchMakerTreeMouseAndSelectionListener.java:464)
    at javax.swing.JTree.fireValueChanged(JTree.java:2399)
    at javax.swing.JTree$TreeSelectionRedirector.valueChanged(JTree.java:2770)
    at
javax.swing.tree.DefaultTreeSelectionModel.fireValueChanged(DefaultTreeSelection
Model.java:629)
    at
javax.swing.tree.DefaultTreeSelectionModel.notifyPathChange(DefaultTreeSelection
Model.java:1078)
    at
javax.swing.tree.DefaultTreeSelectionModel.setSelectionPaths(DefaultTreeSelectio
nModel.java:287)
    at
javax.swing.tree.DefaultTreeSelectionModel.setSelectionPath(DefaultTreeSelection
Model.java:170)
    at javax.swing.JTree.setSelectionPath(JTree.java:1174)
    at
javax.swing.plaf.basic.BasicTreeUI.selectPathForEvent(BasicTreeUI.java:2296)
    at
javax.swing.plaf.basic.BasicTreeUI$Handler.handleSelectionImpl(BasicTreeUI.java:
3509)
    at
javax.swing.plaf.basic.BasicTreeUI$Handler.handleSelection(BasicTreeUI.java:3484
)
    at
javax.swing.plaf.basic.BasicTreeUI$Handler.mousePressed(BasicTreeUI.java:3465)
    at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:222)
    at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:221)
    at java.awt.Component.processMouseEvent(Component.java:5599)
    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:3933)
    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:2
69)
    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)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column
name 'foo'.
    at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown
Source)
    at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown
Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStateme
nt(Unknown
Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecuti
onRequest.executeStatement(Unknown
Source)
    at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
Source)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(Unknown
Source)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.cursorOpen(Unknown Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown
Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerStatement$StatementExecutionRequest.execut
eStatement(Unknown
Source)
    at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
Source)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(Unknown
Source)
    at
ca.sqlpower.sql.jdbcwrapper.StatementDecorator.executeQuery(StatementDecorator.j
ava:97)
    at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.jav
a:205)
    at ca.sqlpower.matchmaker.munge.SQLInputStep.doOpen(SQLInputStep.java:187)
    at
ca.sqlpower.matchmaker.munge.AbstractMungeStep.open(AbstractMungeStep.java:504)
    at
ca.sqlpower.matchmaker.munge.AbstractMungeStep.open(AbstractMungeStep.java:482)
    at
ca.sqlpower.matchmaker.swingui.munge.AbstractMungeComponent.<init>(AbstractMunge
Component.java:251)
    ... 38 more

Please use labels and text to provide additional information.
Original issue reported on code.google.com by mo.j...@gmail.com on 27 Jul 2009 at 3:43
SQLPower / power-matchmaker

DQguru does not properly handle SQL Server (2005) tables with spaces in their name #13
