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
1
vote
2 answers

Reverse enginerring PostgreSQL database with SSL connection in SchemaSpy

When running SchemaSpy get error: Connection failed because of the following error: "no pg_hba.conf entry for host "xxx.xxx.xxx.xxx", user "xxxx", database "xxx", SSL off" The error occurs because the database does require an SSL connection. Is…
user3689770
  • 11
  • 1
0
votes
1 answer

schemaSpy for php classes

Is there a schemaSpy+graphviz equivalent for creating class diagrams from existing PHP source code? In schemaSpy+graphviz, you can create an ER diagram using an existing database. The output are html files that when a text in the diagram is…
llt
  • 145
  • 1
  • 7
0
votes
0 answers

SchemaSpy error - KIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException

Getting an error while setting up SchemaSpy Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "PKIX path building…
user21794211
  • 1
0
votes
0 answers

Schemaspy with PostgreSQL 8.0.2

I am trying to use SchemaSpy with PostgreSQL 8.0.2, but it is throwing an error. I'm seeking guidance on what steps to take to resolve this issue since the documentation is limited. The error message I receive mentions "unsupported server version"…
Frank
  • 952
  • 1
  • 9
  • 23
0
votes
0 answers

How to trigger schemaSpy method/interface to generate diagrams without running command

Imported schemaSpy:v5.0.0 maven dependency using this : https://mvnrepository.com/artifact/org.jumpmind.symmetric.schemaspy/schemaspy Also added the schemaSpy.properties file with up to date database properties. But once I run the project Nothing is…
iUbaid
  • 313
  • 2
  • 16
0
votes
0 answers

How to create a custom anomaly in SchemaSpy

I was learning about SchemaSpy lately. Was amazed with the UI representation by graphviz. But had a doubt whether we can create custom anomaly, if so how do we create custom anomalies(Step by step approach). Tried to create custom anomaly but didn't…
aswin sivakumar
  • 31
  • 2
0
votes
1 answer

How to debug connection problem for SchemaSpy with MySQL (using password: NO)?

I have a no-login variant of mysql running on my machine. So I just type mysql for getting a mysql client shell. No when I am trying to let SchemaSpy connect to mysql it fails: # try with my user: java -jar schemaSpy_5.0.0.jar -t mysql -dp…
BairDev
  • 2,865
  • 4
  • 27
  • 50
0
votes
1 answer

connecting SchemaSpy to Microsoft SQL Server on Linux for Docker Engine fails with Connection Failure

I am running my database locally in Microsoft SQL Server on Linux for Docker Engine I can successfully connect to it using mssql-cli -U username -P password -d dbname however I am struggling to connect to it using SchemaSpy e.g. $ java -jar…
Gids
  • 722
  • 1
  • 8
  • 18
0
votes
1 answer

SchemaSpy without any direct database connection

I want to use SchemaSpy, but I my database is used heavily 24/7 and the DBA won't give me access, even readonly. However, i can give the DBA some commands and he can run them and give me the results. Is it possible for SchemaSpy to run offline…
John Henckel
  • 10,274
  • 3
  • 79
  • 79
0
votes
1 answer

SQLite is not assigning primary keys

I have a simple SQLite database created using sqlite3.exe (code is below). When I run it through SchemaSpy, it looks like there are no primary keys in my first three tables. I don't understand what is wrong with the CREATE TABLE statements in the…
a11
  • 3,122
  • 4
  • 27
  • 66
0
votes
1 answer

SchemaSpy DB2 Connection Failure

I tried to analyze a DB2 database with SchemaSpy, but got a warning 'Connection Failure'. I tried this way: java -jar schemaspy-6.0.0.jar -configFile schemaspy.properties --logging.pattern.console="%d{HH:mm:ss.SSS} %clr(%-5level) - %msg%n"…
Joern
  • 1
  • 2
0
votes
1 answer

Customize color of reference graph in DbVisualizer

Is it somehow possible to create differenet colored groups in the reference graph of DbVisualizer Free 9.1? For Example: I have table user and roles, category and pictures and each picture is related to an user, but user and roles "boxes" in the…
user2822941
  • 5
  • 3
0
votes
0 answers

Java error while using schemaspy

I have a big database on MSSQL but no schema... after reading Generate an E-R Diagram by reverse-engineering a database I've decided to try schemaspy, but it doesn't want to start because of Java: AFAIK its a matter of java version: I've tried…
Yasskier
  • 791
  • 1
  • 14
  • 36
-2
votes
1 answer

Schemaspy apparently does not show the full length of longish code files

We used schemaspy to read the stored procedure from the database. We found that schemaspy can not read the full definition of the procedure. Is there any possibility to fix this bug? Reading the definition helps to understand and follow the…
Saeed
  • 1
1 2
3