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.
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.
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:
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.