Stack Overflow
Stack Overflow

Questions tagged [schemaspy]

SchemaSpy is a Java-based tool that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format.

SchemaSpy is a Java-based tool that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format.

44 questions
15
votes
3 answers

Schema Spy unable to find postgresql driver

I want to use Schema Spy to generate schema diagrams, I have specifed the following command java -jar schemaSpy_5.0.0.jar -t pgsql -host 10.100.71.21[:5432] -db mydb -s public -u username -p password -dp postgresql-8.0-312.jdbc3.jar -o output/ I…
Pankaj Bhambhani
  • 659
  • 3
  • 12
  • 20
13
votes
7 answers

Graphviz error now breaking schemaspy db generation

I have been using Schemaspy(v5.0) to diagram mySQL(v5.7.11) using Graphviz via Homebrew on my Mac (El Capitan). A recent update to Graphviz(v2.40.1) apparently has broken Schemaspy's ability to generate the relational diagrams. Writing/graphing…
Shane Funk
  • 133
  • 2
  • 8
10
votes
2 answers

SchemaSpy PostgreSQL - WARN - Connection Failure

I try to connect to my PostgresSQL server using SchemaSpy. I installed Java using oracle-java8-installer from ppa:webupd8team/java. (My PostgreSQL server works on Docker container so I forward port to 5431) My schemaspy.properties file is: # type of…
karwan
  • 252
  • 4
  • 15
9
votes
1 answer

Unable to connect to Oracle with SchemaSpy

I've installed Oracle Instant Client 64 bits, when connecting with SchemaSpy I get the error message below. PLEASE NOTE: Both these files exist C:\app\instantclient_12_1\ojdbc6.jar C:\app\instantclient_12_1\ocijdbc12.dll And…
Poxipoler
  • 91
  • 1
  • 4
8
votes
3 answers

How to get schemaspy to see the mysql connector?

I've just downloaded schemaspy and it is working perfectly apart from one thing. I always have to specify the path to the mysql connector with the -dp option. If I don't specify it, I get this error: java.lang.ClassNotFoundException:…
naomi
  • 1,934
  • 1
  • 14
  • 29
6
votes
5 answers

Using SchemaSpy to visualize a SQLite database (windows)

I am trying to make a sqlite dump with SchemaSpy. I got SchemaSpy up and running and was able to properly dump a MySQL database. Now I have an .sqlite file (from an iOS application) and a sqlite driver from Christian Werner…
Thorben
  • 6,871
  • 2
  • 19
  • 19
5
votes
3 answers

SchemaSpyGUI : Failed to query Graphviz version information

I need to get mySQL database schema output in html format, so I started working on this with SchemaSpyGUI. Now, when I click on Start SchemaSpy it generate with this errors : Failed to query Graphviz version information with: dot -V …
user3379655
  • 258
  • 1
  • 5
  • 17
4
votes
1 answer

maven-schemaspy-plugin doesn't work (maybe it's a repository issue)

I want to generate a er-diagram from a database integrated in the maven lifecycle. SchemaSpy generates the er-diagram and with the maven-schemaspy-plugin it should be possible to integrate this in the lifecyle-process. (If anyone has a better idea…
MichaelS
  • 41
  • 4
4
votes
1 answer

How to use SchemaSpy with SQLite?

How to use SchemaSpy to create an ERD of an SQLite database? I'm trying this with the chinook.db sample database. Using this command: java -jar schemaspy-6.1.0.jar -t sqlite -db chinook.db -u admin -o . I get this partial output: INFO - The…
writes_on
  • 1,735
  • 2
  • 22
  • 35
4
votes
2 answers

schemaSpy for sqlserver2008?

iam using sqlserver2008, Does this work for sqlserver2008?? i have given java -jar "D:\Program Files\SchemaSpy\schemaSpyGUI.jar" -dp "D:\jtds-1.2.5-dist\jtds-1.2.5.jar" -t mssql-jtds -db EnterpriseVaultDirectory -host localhost -port 1433 -u sa…
Out
  • 627
  • 2
  • 13
  • 20
3
votes
1 answer

Alternatives to SchemaSpy

I am looking for a open source tool that can be used to generate ER diagram. Currently, this is done using SchemaSpy. Maven scripts are invoked during jenkins build to generate these data model diagrams. I have tried POCs using SchemaCrawler as…
venkatesh
  • 435
  • 1
  • 5
  • 9
3
votes
2 answers

SchemaSpy PostgreSQL connection issue

I use the following Schemaspy to connect to one postgreSQL DB successfully. But when I connect to another DB, it reports error "failed to connect to database URL [jdbc....]" java -jar schemaSpy.jar -t pgsql -db erp -host 122.5.XX.XX -port 2345 -u…
Artil
  • 71
  • 4
2
votes
2 answers

WARN - Failed to getImportedKeys The cursor has been previously released and is unavailable

I'm running SchemaSpy v6.1.0-SNAPSHOT on a fairly hefty Informix 12.10 schema, and I get the error "WARN - Failed to getImportedKeys The cursor has been previously released and is unavailable." I know nothing about Java, but I've noticed a very…
Spokey Wheeler
  • 63
  • 7
2
votes
1 answer

Connection Failure warning when generating schema for a local sqlite database using SchemaSpy

I tried the following steps to generate schema for a local sqlite database using SchemaSpy, but a Warning "Connection Failure" occurs and no schema is generated. Downloaded sqlite dll from here, unziped and added to Windows System32…
Mateus Lucas
  • 21
  • 2
2
votes
4 answers

SchemaSpy - Error message while generating the report

I am using SchemaSpy (5.0.0) to generate a report of our Informix database. While running it I get the following error during the last step of 'Gathering schema details': java.sql.SQLException: The cursor has been previously released and is…
Lonzak
  • 9,334
  • 5
  • 57
  • 88
1
2 3