Menu

Total Newbie: Need some help!

2017-04-19
2017-04-19
  • Renato Neves Fonseca

    (I'm using windows)
    SchemaSpy folder contents:

    graphviz-2.38 installation
    schemaSpyGUI.bat
    schemaSpy_5.0.0.jar

    However whenever I try running schemaSpy with my oracle db this is the output:

    Failed to query Graphviz version information
    with: dot -V
    java.io.IOException: Cannot run program "dot": CreateProcess error=2, The system cannot find the file specified

    Failed to load driver [oracle.jdbc.driver.OracleDriver] from classpath

    Any ideias?

     
  • Rafal Kasa

    Rafal Kasa - 2017-04-23

    To resolve issue that you have with Graphviz and SchemaSpy is very simple please add eg. C:\Program Files (x86)\Graphviz2.38\bin to your PATH variable http://schemaspy.readthedocs.io/en/latest/installation.html

    other option is use -gv and here set path to your Graphviz installation folder.

    You can also try new SchemaSpy 6.0 version you can download and try from http://schemaspy.org/ or from github project https://github.com/schemaspy/schemaspy

     
  •  Cheshire Leopard

    Upon running SchemaSpy from the command line, I also had been getting the following error:
    Failed to query Graphviz version information
    with: dot -V
    java.io.IOException: Cannot run program "dot": CreateProcess error=2, The system cannot find the file specified

    After toying with it (for too long) I found that my path variable for GraphViz was enclosed in quotation marks (running the "path" command from the DOS command prompt displays the current state of the path settings). The quotation marks should work okay, but I discovered that removing the quotation marks seemed to eliminate the error when attempting to run SchemaSpy.

    For Windows 10, in order to remove the quotation marks for the GraphVis path parameter, go to the Windows Start menu and type "environment variables", and select "Edit the system environment variables" from the listed choices. You should see a "System Properties" dialog. On the "Advanced" tab, select the "Environment Variables..." button. Select the "Path" variable from either the User variables section or the System variables section, depending on where you have the GraphVis path defined, and select "Edit...". Select the "Edit text..." button, and remove the quotation marks surrounding the GraphVis path. After making the change, you will have to close and re-open your DOS command window in order for the change to take effect.

     

Log in to post a comment.