back to forum.

Topic: cmd line exec failed: No Suitable driver found for jdbc:sqlserver

Topic by
dluvishis

2009-08-19
06:10

cmd line exec failed: No Suitable driver found for jdbc:sqlserver

Hello,

I've tested connection to MS SQL server 2008 in DataCleaner, was able to run profiling for my test table and then saved the file as my_profiler.dcp.

When I am running it in cmd I am getting the following error:
Exception in thread "main" java.sql.SQLException: No suitable driver found for jdbc:sqlserver://localhost;databaseName=MyTest;
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at dk.eobjects.datacleaner.data.DataContextSelection.selectDatabase(DataContextSelection.java:160)
        at dk.eobjects.datacleaner.data.DataContextSelection.deserialize(DataContextSelection.java:282)
        at dk.eobjects.datacleaner.gui.DataCleanerCli.runInputFile(DataCleanerCli.java:356)
        at dk.eobjects.datacleaner.gui.DataCleanerCli.main(DataCleanerCli.java:312)
I've downloaded and registered sqljdbc_2.0 but it doesn't help.

All ideas will be highly appreciated.

Reply by
kasper

2009-08-19
07:17
And if you open "my_profiler.dcp" from within the DataCleaner GUI application, it works fine? I would expect the same error in the desktop application basically it's saying that there are no drivers installed that accept URLs that start with "jdbc:sqlserver".

Reply by
dluvishis

2009-08-19
16:49
When I open my_profiler.dcp I am getting an error: 
Could not resolve column '#'
 

Message:
    java.lang.IllegalArgumentException: Could not resolve column '#'
Level:
    SEVERE
Stack Trace:
Could not resolve column '#'
    dk.eobjects.datacleaner.util.DomHelper.getColumnsFromChildNodes(DomHelper.java:155)
    dk.eobjects.datacleaner.profiler.ProfilerJobConfiguration.deserialize(ProfilerJobConfiguration.java:122)
    dk.eobjects.datacleaner.gui.windows.ProfilerWindow.deserialize(ProfilerWindow.java:277)
    dk.eobjects.datacleaner.gui.widgets.OpenFileActionListener.actionPerformed(OpenFileActionListener.java:60)
    javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    javax.swing.AbstractButton.doClick(Unknown Source)
    javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
    javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)
    java.awt.Component.processMouseEvent(Unknown Source)
    javax.swing.JComponent.processMouseEvent(Unknown Source)
    java.awt.Component.processEvent(Unknown Source)
    java.awt.Container.processEvent(Unknown Source)
    java.awt.Component.dispatchEventImpl(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Window.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.EventQueue.dispatchEvent(Unknown Source)
    java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    java.awt.EventDispatchThread.run(Unknown Source)
null
    dk.eobjects.datacleaner.util.DomHelper.getColumnsFromChildNodes(DomHelper.java:152)
    dk.eobjects.datacleaner.profiler.ProfilerJobConfiguration.deserialize(ProfilerJobConfiguration.java:122)
    dk.eobjects.datacleaner.gui.windows.ProfilerWindow.deserialize(ProfilerWindow.java:277)
    dk.eobjects.datacleaner.gui.widgets.OpenFileActionListener.actionPerformed(OpenFileActionListener.java:60)
    javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    javax.swing.AbstractButton.doClick(Unknown Source)
    javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
    javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)
    java.awt.Component.processMouseEvent(Unknown Source)
    javax.swing.JComponent.processMouseEvent(Unknown Source)
    java.awt.Component.processEvent(Unknown Source)
    java.awt.Container.processEvent(Unknown Source)
    java.awt.Component.dispatchEventImpl(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Window.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.EventQueue.dispatchEvent(Unknown Source)
    java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    java.awt.EventDispatchThread.run(Unknown Source)

Column "#" is the first column in the table I am interested in. I've tried excluding it from the my_profiler.dcp, but got the same message regarding the first column mentioned as well. After I click Ok on the Error Message, I can see all schemas on the sidebar, but no tables there.
I am connecting to the database using username "DataCleaner".

Reply by
kasper

2009-08-19
19:31
Mysterious ... I think I have an explanation for the error you are getting now, but as far as I can see it's not related to the original error message (the one relating to no suitable driver).

Regarding your last entry (the issue about the first column in your table) I want you to know that just as of yesterday we found a bug relating to SQL server schema exploration so I think this may very well fix things for you. Asbjørn fixed the bug today but we still need to look at a few other issues before we make a release so hold on a few days and I'll keep you posted!

You need to be logged in to participate

In order to post your own comments on this topic, you need to be logged in.

Username:

Log in by clicking the login link at the top of the screen

 

Go back to forum.