45 questions
-2
votes
1
answer
135
views
Trying to generate Entity Relationship Diagram from an Aurora Postgres 15.4 on AWS with SchemaSpy 6.2.4
My database is Aurora Postgres 15.4 -- connection works postgresql-42.7.5.jar exists
schemaspy-6.2.4 is installed -- schemaspy-6.2.4.jar
Graphviz-12.2.1-win64 is installed -- dot - graphviz version 12....
- 7
0
votes
1
answer
77
views
Creating a docker container of the generated SchemaSpy documentation site
I'm trying to create a permanent docker container to host the documentation site generated by SchemaSpy of my mysql database.
Here is the relevant section from my docker-compose.yaml:
docs:
...
- 159
0
votes
0
answers
198
views
Unable to run Schemaspy due to SQL Server connection error due to trustServerCertificate
I get the following error when trying to run Schemaspy 6.2.4. I'm trying to connect to SQL Server 2019. I don't know how to add the TrustServerCertificate=true setting. Can someone please help me with ...
- 1
0
votes
0
answers
76
views
Does SchemaSpy supports Azure Data Warehouse? Any other open-source alternative?
We use azure data warehouse service to store our Datasets which are huge in sizes and I want to check if SchemaSpy tool would be able to help us generate interactive HTML documentation for database ...
- 1,183
4
votes
2
answers
1k
views
SchemaSpy providing Graphviz errors/warnings
I am running SchemaSpy and am able to produce graphviz summaries, but receive two repeated errors/warnings. Here is a sample of the output from my run:
INFO - Starting Main v6.2.2 on DESKTOP-43FMD5O ...
- 51
0
votes
0
answers
289
views
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 ...
- 1,226
1
vote
2
answers
1k
views
Failed to generate Table diagram -- RelationShipDiagramError (SchemaSpy - GraphViz)
Trying to create the DB schema ER Diagram using the below command but unable to generate the ER diagrams sue to some issue with graphViz configurations. schemaSpy is creating the html based file of ...
- 321
1
vote
1
answer
135
views
SchemaSpy 6.1.0 is not available on Maven central?
I try to find it on Maven Central, but the best I can find in version 5.0.0 under net.sourceforge.schemaspy groupId.
I wonder if it could be available soon or later under it.
Is any one has a clue why ...
- 1,205
1
vote
2
answers
502
views
SchemaSpy Testcontainers. Copy results from the container
I want to run SchemaSpy container against PosgtreSQL database to generate the documentation. Here is the approach I came up with:
Start PostgreSQL.
Start SchemaSpy with overridden entrypoint (/bin/sh)...
- 1,452
-2
votes
1
answer
149
views
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 ...
- 1
0
votes
1
answer
658
views
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:
...
- 3,231
1
vote
1
answer
1k
views
How can I make schemaspy work with SQL Server 2016 (v13)?
last I used schemaspy was with SQL Server 2005 or 2008 in 2017. I tried it against a SQL Server 2016 (v13) instance and I can't find a jar file for the database connection that will work.
- 1,153
1
vote
0
answers
228
views
Editing SchemaSpy Layout files
I am currently using SchemaSpy to document databases and it is working fine.
However, there are some things within the generated HTML that I do not want, thus I opened up the jar file and edited the ...
- 46
4
votes
1
answer
812
views
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 ...
- 1,905
1
vote
2
answers
688
views
Java Runtime Error with class file version error
I've downloaded just about every JDBC driver version I can find along with multiple versions of JAVA.
Everytime I try to run SchemaSpy I get the following error:
Exception in thread "main" java.lang....
- 153