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?