SchemaSpy - Error while executing

0

I was reading about programs that generate database documentation and found SchemaSpy , by what I understand it generates an html with the bank structure (tables, columns, fks, data dictionary, etc ... ).

As per the documentation, I installed Graphviz and put it in the windows environment variable ( Path ) ( ):

  C: \ ProgramData \ Oracle \ Java \ javapath;% SystemRoot% \ system32;% SystemRoot%;% SystemRoot% \ System32 \ Wbem;% SYSTEMROOT% \ System32 \ WindowsPowerShell \ v1.0 \;   Files (x86) \ AMD \ ATI.ACE \ Core-Static; C: \ Program Files   C: \ Program Files \ Common Files \ Intel \ WiFi \ bin \   C: \ Program Files \ Intel \ WirelessCommon \;   C: \ Program Files \ Git \ cmd; C: \ Program Files \ Git \ cmd; C: \ ProgramData \ ComposerSetup \ bin;% USERPROFILE% .dnx \ bin;   Files \ Microsoft DNX \ Dnvm \: C: \ Program Files (x86) \ Windows   Kits \ 8.1 \ Windows Performance Toolkit \: C: \ Program Files \ Microsoft SQL   C: \ Program Files \ Server \ 130 \ Tools \ Binn \; C: \ PostgreSQL \ pg96 \ bin   C: \ Program Files \ nodejs \; C: \ Program Files \ dotnet \;   \ Program Files \ Java \ jdk1.8.0_111 \ bin; \ Program Files (x86) \ Graphviz2.38 \ bin

Then I downloaded the .jar of SchemaSpy in github ( link ) .

And I tried to run the following command below:

java -jar C:\SchemaSpy\schemaspy.jar -t mysql -db teste -host localhost -port 3306 -s dbo -u root -p  -o C:\SchemaSpy\Documentacao

However, it generates the following error:

Microsoft Windows [versão 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. Todos os direitos reservados.

C:\Users\MAX>java -jar C:\SchemaSpy\schemaspy.jar -t mysql -db teste -host local
host -port 1433 -s dbo -u root -p  -o C:\SchemaSpy\Documentacao

      ____       _                          ____

 / ___|  ___| |__   ___ _ __ ___   __ _/ ___| _ __  _   _
 \___ \ / __| '_ \ / _ \ '_ ' _ \ / _' \___ \| '_ \| | | |
  ___) | (__| | | |  __/ | | | | | (_| |___) | |_) | |_| |
 |____/ \___|_| |_|\___|_| |_| |_|\__,_|____/| .__/ \__, |
                                             |_|    |___/

                                              6.0.0-rc2

SchemaSpy generates an HTML representation of a database schema's relationships.


INFO  - Starting Main v6.0.0-rc2 on MAX-NOTEBOOK with PID 4696 (C:\SchemaSpy\sch
emaspy.jar started by MAX in C:\Users\MAX)
INFO  - No active profile set, falling back to default profiles: default
INFO  - Configuration file not found
INFO  - Starting schema analysis
INFO  - Using database properties:
INFO  -   [C:\SchemaSpy\schemaspy.jar]/org/schemaspy/types/mysql.properties
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

Failed to load driver 'com.mysql.jdbc.Driver'
This entry doesn't point to a valid file/directory: [\mysql\mysql-connector-java
-5.1.6-bin.jar]

Use the -dp option to specify the location of the database
drivers for your database (usually in a .jar or .zip/.Z).

WARN  - Connection Failure
org.schemaspy.model.ConnectionFailure: java.lang.ClassNotFoundException: com.mys
ql.jdbc.Driver
        at org.schemaspy.DbDriverLoader.getDriver(DbDriverLoader.java:154)
        at org.schemaspy.DbDriverLoader.getConnection(DbDriverLoader.java:57)
        at org.schemaspy.service.SqlService.connect(SqlService.java:65)
        at org.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:181)
        at org.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:88)
        at org.schemaspy.Main.runAnalyzer(Main.java:79)
        at org.schemaspy.Main.run(Main.java:72)
        at org.springframework.boot.SpringApplication.callRunner(SpringApplicati
on.java:732)
        at org.springframework.boot.SpringApplication.callRunners(SpringApplicat
ion.java:716)
        at org.springframework.boot.SpringApplication.afterRefresh(SpringApplica
tion.java:703)
        at org.springframework.boot.SpringApplication.run(SpringApplication.java
:304)
        at org.springframework.boot.SpringApplication.run(SpringApplication.java
:1118)
        at org.springframework.boot.SpringApplication.run(SpringApplication.java
:1107)
        at org.schemaspy.Main.main(Main.java:55)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner
.java:48)
        at org.springframework.boot.loader.Launcher.launch(Launcher.java:87)
        at org.springframework.boot.loader.Launcher.launch(Launcher.java:50)
        at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51)

Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
        at java.net.URLClassLoader.findClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        at org.springframework.boot.loader.LaunchedURLClassLoader.loadClass(Laun
chedURLClassLoader.java:94)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Unknown Source)
        at org.schemaspy.DbDriverLoader.getDriver(DbDriverLoader.java:129)
        ... 21 common frames omitted
INFO  - Started Main in 2.491 seconds (JVM running for 3.174)

Can anyone help me solve the problem or suggest other programs that generate the bank's documentation?

    
asked by anonymous 15.02.2018 / 03:47

0 answers