Como usar o ShemaSpyGui para ver o diagrama do banco de dados

3

Eu instalei o Postgre hoje e quero ver o banco de dados shema.

Resolvi usar schemaSpy e baixá-lo e também schemaSpyGui

edepoisvejo:

This is the command (password not displayed!) SchemaSpyGUI has generated:
java -jar "D:\free\schemaSpy_5.0.0.jar" -dp "D:\free\postgresql-9.1-903.jdbc4.jar" -t pgsql -db marc_db -host localhost -port 5432 -u marc -connprops "D:\free\schemaSpyGUI20090302\properties\pgsql.properties" -o "D:\free\schemaSpyGUI20090302\marc_marc_db_"

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
Using database properties:
  [D:\free\schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details...

No tables or views were found in schema 'marc'.
The schema does not exist in the database.
Make sure that you specify a valid schema with the -s option and that
  the user specified (marc) can read from the schema.
Note that schema names are usually case sensitive.

3 schemas exist in this database.
Some of these "schemas" may be users or system schemas.

information_schema pg_catalog public 
These schemas contain tables/views that user 'marc' can see:

 information_schema pg_catalE=2og publicI=2

Eu instalei o Graphviz2.38

E se do cmd eu digitar

C:\Program Files (x86)\Graphviz2.38\bin>dot -V
dot - graphviz version 2.38.0 (20140413.2041)

Por favor ajude.

atualizar

após conselhos em comentários, adicionei path\to\Graphviz2.38\bin à variável de ambiente Path e agora vejo o seguinte:

This is the command (password not displayed!) SchemaSpyGUI has generated:
java -jar "D:\freelance\db_things\schemaSpy_5.0.0.jar" -dp "C:\Users\redwhite\.m2\repository\postgresql\postgresql.0-801.jdbc4\postgresql-9.0-801.jdbc4.jar" -t pgsql -db marc_db -host localhost -port 5432 -u marc -connprops "D:\freelance\db_things\schemaSpyGUI20090302\properties\pgsql.properties" -o "D:\freelance\db_things\schemaSpyGUI20090302\marc_marc_db_"

Using database properties:
  [D:\freelance\db_things\schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details...

No tables or views were found in schema 'marc'.
The schema does not exist in the database.
Make sure that you specify a valid schema with the -s option and that
  the user specified (marc) can read from the schema.
Note that schema names are usually case sensitive.

4 schemas exist in this database.
Some of these "schemas" may be users or system schemas.

information_schema pg_catalog pg_toast_temp_1 public 
These schemas contain tables/views that user 'marc' can see:

 informationE=2_sch emapg_catalog publicI=2

minha shema se parece com isso:

    
por gstackoverflow 03.10.2014 / 16:56

1 resposta

0

Consegui corrigir esse problema adicionando C: \ Arquivos de Programas (x86) \ Graphviz2.38 \ bin ao meu "Caminho" para que o Java possa encontrá-lo a partir do diretório que está sendo executado.

    
por 21.03.2016 / 18:11