Hi Experts, Is it possible to generate Entity Relationship(ER Diagram) or Physical diagram for Calculation views in SAP HANA DB? I searched the forum, seems like SchemaSpy has capability to generate ER diagram for tables but could not find anything related to Views Thanks, Raj
Hi, Kindly advise how to use meta with xml without any database. I tried following but its giving error. C:\schema>java -jar schemaSpy.jar -meta meta.xml -o java.lang.IndexOutOfBoundsException: Index: 2, Size: 2 at java.util.ArrayList.rangeCheck(Unknown Source) at java.util.ArrayList.get(Unknown Source) at net.sourceforge.schemaspy.Config.pullParam(Config.java:1383) at net.sourceforge.schemaspy.Config.pullRequiredParam(Config.java:1364) at net.sourceforge.schemaspy.Config.getOutputDir(Config.java:205)...
Hi, I want to create DB Schema from Excel, without creating it first in any database, is it possible, as I want to review the tables, and their links, before actually create in any database. Thanks / Luqman
I wrote a schema file for it , check it out you also have to use https://sourceforge.net/projects/jt400/ JTOpen drivers for that
I wrote a schema file for it , check it out
I frote a schema file for it , check it out
You have to use https://sourceforge.net/projects/jt400/ JTOPen drivers obviously
Hello, I wrote a AS/400 DB2 properties file I whant to share. It seems to work correctly because I was able to create a FULL Library Schema You find it into file attach!
Hi! Are you solved this problem? Tell me please how you are solved this problem? Java 1.0.8.231 PostgreSQL 9.6
Please use the below parameter: [-noimplied] Don’t look for implied relationships. Full list of params here.
Please use the below parameter: [-noimplied] Don’t look for implied relationships. Full list of params here:
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 mode? In other words, Can I give it a dump of all the "CREATE TABLE, CREATE INDEX" and a list of all the sizes of the tables, and then it can generate the report?
Hello I would like to be able to generate a diagram with all of the tables in a schema using the "Compact" view i.e. show the primary/foreign keys but exclude all of the other columns. The relationships diagram is close to what I need (in compact mode) but excludes the "Orphan" tables. The "Orphan" tables diagram includes all of the fields. Is there a way to either hide the non-key columns in the Orphan diagram (i.e. make compact, so I can combine Orphan + Relationships via a png editor), or add...
Hey Sujit, Thanks so much! This works!
Brenda, This issue is related to GraphViz pluggin. Latest snapshot release of schemaspy doesn't require GraphViz pluggins to be installed. So use the snapshot release of schemaspy and use -vizjs as the parameter to the schemaspy command as below $ java -jar schemaspy-6.1.0-SNAPSHOT.jar -t orathin-service -dp ojdbc7.jar -host xyz.com -port 1521 -db xyz -u user1 -p pass1 -o output -cat catalog -vizjs -renderer :cairo This should work.
Me too, would be great if there are any updates on this issue.
Hi, I got exact same error. but when I tried the fix, it says invalid argument --with
Example from logs (redacted): java -jar "<PATH>\schemaSpy.jar" -t pgsql -host <SERVERNAME>:<PORT> -u <USERNAME> -p <PASSWORD> -db <DBNAME> -all -noviews -ahic -dp "<PATH>\postgresql-42.1.4.jar" -gv "C:\Program Files (x86)\Graphviz2.38" -hq -o "C:\SchemaSpy\" 23:22:45.116 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: org.postgresql.util.PSQLException: ERROR: relation "test.Notes" does not exist Position: 15 23:22:45.116 WARNING: Table.initColumnAutoUpdate - SQL:...
Example from logs (redacted): java -jar "<PATH>\schemaSpy.jar" -t pgsql -host <SERVERNAME>:<PORT> -u <USERNAME> -p <PASSWORD> -db <DBNAME> -all -noviews -ahic -dp "<PATH>\postgresql-42.1.4.jar" -gv "C:\Program Files (x86)\Graphviz2.38" -hq -o "C:\SchemaSpy\" 23:22:45.116 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: org.postgresql.util.PSQLException: ERROR: relation "test.Notes" does not exist Position: 15 23:22:45.116 WARNING: Table.initColumnAutoUpdate - SQL:...
Example from logs (redacted): java -jar "<PATH>\schemaSpy.jar" -t pgsql -host <SERVERNAME>:<PORT> -u <USERNAME> -p <PASSWORD> -db <DBNAME> -all -noviews -ahic -dp "<PATH>\postgresql-42.1.4.jar" -gv "C:\Program Files (x86)\Graphviz2.38" -hq -o "C:\SchemaSpy\" 23:22:45.116 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: org.postgresql.util.PSQLException: ERROR: relation "test.Notes" does not exist Position: 15 23:22:45.116 WARNING: Table.initColumnAutoUpdate - SQL:...
Example from logs: java -jar "<PATH>\schemaSpy.jar" -t pgsql -host <SERVERNAME>:<PORT> -u <USERNAME> -p <PASSWORD> -db <DBNAME> -all -noviews -ahic -dp "<PATH>\postgresql-42.1.4.jar" -gv "C:\Program Files (x86)\Graphviz2.38" -hq -o "C:\SchemaSpy\" 23:22:45.116 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: org.postgresql.util.PSQLException: ERROR: relation "test.Notes" does not exist Position: 15 23:22:45.116 WARNING: Table.initColumnAutoUpdate - SQL: select * from...
Example from logs: java -jar "<PATH>\schemaSpy.jar" -t pgsql -host <SERVERNAME>:<PORT> -u <USERNAME> -p <PASSWORD> -db <DBNAME> -all -noviews -ahic -dp "<PATH>\postgresql-42.1.4.jar" -gv "C:\Program Files (x86)\Graphviz2.38" -hq -o "C:\SchemaSpy\" 23:22:45.116 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: org.postgresql.util.PSQLException: ERROR: **relation "test.Notes" does not exist** Position: 15 23:22:45.116 WARNING: Table.initColumnAutoUpdate - SQL: **select...
PostgreSQL Mixed-Case Schema Names Not Quoted in Queries (RowCount)
Errors with Opensuse tumbleweed
schemaspy still refers to password if db has no password or password input not provided
Fixed. Reinstall Graphviz : brew reinstall graphviz --with librsvg-pango
Any suggestion to fix the error I'm getting when using schemaspy? I am using schemaspy with the following string in a mac iOS: . java -jar schemaspy-6.0.0.jar -t pgsql -dp postgresql-42.2.4.jar -s public -db mydatabase -u myuser -p mypassword -host localhost -o mydirectory This is the output: INFO - Starting Main v6.0.0 on EMaillos-MacBook-Pro.local with PID 86078 (/Users/emaillo/Downloads/schemaspy-6.0.0.jar started by emaillo in /Users/emaillo/Downloads) INFO - The following profiles are active:...
Any suggestion to fix the error I'm getting when using schemaspy? I am using schemaspy with the following string in a mac iOS: . java -jar schemaspy-6.0.0.jar -t pgsql -dp postgresql-42.2.4.jar -s public -db mydatabase -u myuser -p mypassword -host localhost -o mydirectory This is the output: INFO - Starting Main v6.0.0 on EMaillos-MacBook-Pro.local with PID 86078 (/Users/emaillo/Downloads/schemaspy-6.0.0.jar started by emaillo in /Users/emaillo/Downloads) INFO - The following profiles are active:...
Here is the session as it appeared
Informix 12.10: ERROR - The cursor has been previously released and is unavailable. SP crashes
No relationship diagram visible
I'm a newbi to SchemaSpy. With SchemaSpy 6x I have not been able to get check constraints to show up. SchemaSpy 5x would show these. I've tried mix/match various mssql...properties and mssql property section contents...etc. but cannot seem to get these showing. Using -cronprops I'm confident its picking up my specified .properties file. Can someone help point ment in the right direction? SELECT TABLE_NAME, COLUMN_NAME, CHECK_CLAUSE, cc.CONSTRAINT_SCHEMA, cc.CONSTRAINT_NAME FROM INFORMATION_SCHEMA.CHECK_CONSTRAINTS...
I'm a newbi to SchemaSpy. With SchemaSpy 6x I have not been able to get check constraints to show up. SchemaSpy 5x would show these. I've tried mix/match various mssql and mssql property files and contents...etc. but cannot seem to get these showing. Can someone help point ment in the right direction? SELECT TABLE_NAME, COLUMN_NAME, CHECK_CLAUSE, cc.CONSTRAINT_SCHEMA, cc.CONSTRAINT_NAME FROM INFORMATION_SCHEMA.CHECK_CONSTRAINTS cc INNER JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE c ON cc.CONSTRAINT_NAME...
Foreign Key of composite key in Oracle are not detected
This problem seems to be solved in SchemaSpy 5.0. Use the "-charset UTF-8" parameter and the resulting HTML will be encoded in UTF-8
I have the same problem. It seems that the charset is hardcoded and the HTML looses accented characters when it is written to disk, so it is not recoverable after generation.
And by the way: Happy New Year! It seems that a secondary effect is that the fact that the index has too many columns that it prevents to generate an implied relationship between the table rfe_item and product_lov on prod_name, prod_brand and prod_fam. I understood "implied constraints" occur when a column has the same name, type and length in another table, and has a unique index or primary key in the other table. Does this occurs with composite indexes too?
Here is the actual database schema for test purpose
Informix 12.10: unique index reported with wrong columns
Hi all after digging deep, the solution is very simple: here is an example to set CLIENT_LOCALE java -jar "C:\Tools\SchemaSpy\schemaSpy.jar" -dp "C:\Program Files (x86)\AGS\common\drivers\informix\jdbc\jdbc.3.70.jc1\ifxjdbc.jar" -t informix -db databaseName -host hostName:portNumber -port 8050 -u informix -p MyPasswd -server $INFORMIXSERVER -o outputDirectory -connprops="CLIENT_LOCALE\=en_US.819" just that simple
Hi all after digging deep, the solution is very simple: here is an example to set CLIENT_LOCALE java -jar "C:\Tools\SchemaSpy\schemaSpy.jar" -dp "C:\Program Files (x86)\AGS\common\drivers\informix\jdbc\jdbc.3.70.jc1\ifxjdbc.jar" -t informix -db databaseName -host hostName:portNumber -port 8050 -u informix -p MyPasswd -server $INFORMIXSERVER -o outputDirectory -connprops "DB_LOCALE\=en_US.819;CLIENT_LOCALE\=en_US.819" just that simple
I just recently ran across SchemaSpy as I'm working on rebuilding my PostgreSQL database structure. After a couple of initial mishaps with basic configuration and figuring out how to format the CLI command, I've been able to produce a great diagram of my new database. However, I noted that all of the tables listed in my analysis report are showing a value of "-1" in the Rows column. Going back through the command line output, I noted a number of lines that say: 13:10:23.523 WARNING: Table.fetchNumRows...
I just recently ran across SchemaSpy as I'm working on rebuilding my PostgreSQL database structure. After a couple of initial mishaps with basic configuration and figuring out how to format the CLI command, I've been able to produce a great diagram of my new database. However, I noted that all of the tables listed in my analysis report are showing a value of "-1" in the Rows column. Going back through the command line output, I noted a number of lines that say: 13:10:23.523 WARNING: Table.fetchNumRows...
I just recently ran across SchemaSpy as I'm working on rebuilding my PostgreSQL database structure. After a couple of initial mishaps with basic configuration and figuring out how to format the CLI command, I've been able to produce a great diagram of my new database. However, I noted that all of the tables listed in my analysis report are showing a value of "-1" in the Rows column. Going back through the command line output, I noted a number of lines that say: 13:10:23.523 WARNING: Table.fetchNumRows...
Really like you work on this tool. We are looking to use it to map our databases. However, we would really like to see the differences between one generation to another somehow. Since this generates a snapshot, we realize doing a diff is a bit tricky. However, I was wondering if there is a way to modify the generation somehow to note a change. For instance, could we use one of the extended meta data formats to toggle a change state for an element and then in css mark that element red or something...
While this post is old, we still use SchemaSpy here to document our SQL Server schemas, so I thought I'd share the solution for getting this to work on SQL Server 2012 and higher. I found the solution by combining the comments from Derrick and John and researching a bit. The closest configuration to SQL Server 2012 and higher is mssql05-jtds. That configuration works except for table comments. There's an extra space at the end of one line inside the mssql05-jtds.properties file inside schemaSpy.jar...
Jul 28, 2017 Here's how I set up SchemaSpy on Windows 10 to generate the schema for Zotero, which uses a SQLite database. (Step 1) DOWNLOADED PREREQUISITE SOFTWARE AND SET THE PATH VARIABLE. (1.a) Downloaded the GraphViz installer [graphviz-2.38.msi] from the GraphViz site: http://www.graphviz.org/Download_windows.php (1.b) Installed GraphViz using the installation defaults, which installed GraphViz to the following program directory: C:\Program Files (x86)\Graphviz2.38. (1.c) Added [C:\Program Files...
Jul 28, 2017 Here's how I set up SchemaSpy on Windows 10 to generate the schema for Zotero, which uses a SQLite database. (Step 1) DOWNLOADED PREREQUISITE SOFTWARE AND SET THE PATH VARIABLE. (1.a) Downloaded the GraphViz installer [graphviz-2.38.msi] from the GraphViz site: http://www.graphviz.org/Download_windows.php (1.b) Installed GraphViz using the installation defaults, which installed GraphViz to the following program directory: C:\Program Files (x86)\Graphviz2.38. (1.c) Added [C:\Program Files...
Jul 28, 2017 Here's how I set up SchemaSpy on Windows 10 to generate the schema for Zotero, which uses a SQLite database. (Step 1) DOWNLOADED PREREQUISITE SOFTWARE AND SET THE PATH VARIABLE. (1.a) Downloaded the GraphViz installer [graphviz-2.38.msi] from the GraphViz site: http://www.graphviz.org/Download_windows.php (1.b) Installed GraphViz using the installation defaults, which installed GraphViz to the following program directory: C:\Program Files (x86)\Graphviz2.38. (1.c) Added [C:\Program Files...
Jul 28, 2017 Here's how I set up SchemaSpy on Windows 10 to generate the schema for Zotero, which uses a SQLite database. (Step 1) DOWNLOADED PREREQUISITE SOFTWARE AND SET THE PATH VARIABLE. (1.a) Downloaded the GraphViz installer [graphviz-2.38.msi] from the GraphViz site: http://www.graphviz.org/Download_windows.php (1.b) Installed GraphViz using the installation defaults, which installed GraphViz to the following program directory: C:\Program Files (x86)\Graphviz2.38. (1.c) Added [C:\Program Files...
Jul 28, 2017 Here's how I set up SchemaSpy on Windows 10 to generate the schema for Zotero, which uses a SQLite database. (Step 1) DOWNLOADED PREREQUISITE SOFTWARE AND SET THE PATH VARIABLE. (1.a) Downloaded the GraphViz installer [graphviz-2.38.msi] from the GraphViz site: http://www.graphviz.org/Download_windows.php (1.b) Installed GraphViz using the installation defaults, which installed GraphViz to the following program directory: C:\Program Files (x86)\Graphviz2.38. (1.c) Added [C:\Program Files...
Upon running SchemaSpy from the command line, I also had been getting the following error: 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 After toying with it (for too long) I found that my path variable for GraphViz was enclosed in quotation marks (running the "path" command from the DOS command prompt displays the current state of the path settings). The quotation marks should...
Hi All, not sure I am posting to the right place, if not please redirect me :-) I having been using SchemaSpy for a few years now and I really love it. I am litterally exclusive of Informix user, which did not get me any trouble with SchemaSpy until now. Just downloaded and installed V6 This time, I wanna analyze an informix database that has a different codeset as standard US codeset. I understood that for Informix JDBC, it is necessary to specify the codeset in the JDBC connection string, by adding...
Hi This error with graphviz is quite common on Mac OSX you can read more here: https://stackoverflow.com/questions/41837485/graphviz-error-now-breaking-schemaspy-db-generation/42018558#42018558 This issue appeared also on schemaspy github https://github.com/schemaspy/schemaspy/issues/33 If you will have any issue with SchemaSpy please create the ticket on github project page. https://github.com/schemaspy/schemaspy You can expect much fastet answer and help from contributors and SchemaSpy Team Best...
I have the exact same error as @Vijay Aravamudhan net.sourceforge.schemaspy.util.Dot$DotFailure: 'dot -Tpng:gd xxxx/diagrams/summary/relationships.real.compact.dot -oxxxx/diagrams/summary/relationships.real.compact.png -Tcmapx' failed with return code 139
@rafal: I have the same issue. Im on a Mac OSX Sierra - and do have graphviz installed via homebrew. dot - graphviz version 2.40.1 (20161225.0304) I tried with both the version of schemaSpy that is publicly released (v5.0.0) and the release candidate (v6.0.0-rc1) jars - both have the same issue. This the line that gets repeated for various tables: .org.schemaspy.util.Dot$DotFailure: 'dot -Tpng:gd ./tmp/diagrams/XXX.1degree.dot -o./tmp/diagrams/XXX.1degree.png -Tcmapx' failed with return code 139
To resolve issue that you have with Graphviz and SchemaSpy is very simple please add eg. C:\Program Files (x86)\Graphviz2.38\bin to your PATH variable http://schemaspy.readthedocs.io/en/latest/installation.html other option is use -gv and here set path to your Graphviz installation folder. You can also try new SchemaSpy 6.0 version you can download and try from http://schemaspy.org/ or from github project https://github.com/schemaspy/schemaspy
(I'm using windows) SchemaSpy folder contents: graphviz-2.38 installation schemaSpyGUI.bat schemaSpy_5.0.0.jar However whenever I try running schemaSpy with my oracle db this is the output: 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 Failed to load driver [oracle.jdbc.driver.OracleDriver] from classpath Any ideias?
Hi, Please try create your issue here on Github - https://github.com/schemaspy/schemaspy/issues...
Hi codek Because project is not maintained on sourceforge from Jun 2014 you can create...
Schemaspy not working against Impala
Hi Kalan You can try new SchemaSpy version if you will have the same issue please...
Hi, Has there been any update to this issue. Would like to connect to SQL server...
OK my bad, guys. I executed that with an older version of Java (v1.7) that's the...
OK my bad, guys. I executed that with an older version of Java (v1.7) that's the...
Hi guys, I'm trying to use schemaSpy for generating a Data Physical Model of my firebird...
Hi amir I suppose that you didn't install Graphviz. http://www.graphviz.org ShemaSpy...
Blank relationships tab -- net.sourceforge.schemaspy.util.Dot$DotFailure ... failed with return code 139
I can confirm that the fix works now. Thank you!
Hi pothoven The new version schemaspy-6.0.0-beta.2 was released you can download...
Hi I confirm this bug, and it will be fixed in next version of SchemaSpy. I created...
For all of you interested abou this feature in SchemaSpy please vote and comment...
Here I am trying to get the row values from database and adding it to the ArrayList....
Hi pothoven Thank you very much for your time and verification version schemaspy-6.0.0-beta.1...
Yes, it is still a problem in the new beta. Using database properties: [schemaspy-6.0.0-beta.1.jar]/org/schemaspy/types/mysql.properties...
Yes, it is still a problem in the new beta, plus adding the "-norows" flag no longer...
Yes, it is still a problem in the new beta, but adding the "-norows" flag no longer...
Yes, it is still a problem in the new beta. Using database properties: [schemaspy-6.0.0-beta.1.jar]/org/schemaspy/types/mysql.properties...
Hi All of you interested new version of SchemaSpy, I would like to invite and look...
Hi Will Smith Please verify version https://github.com/schemaspy/schemaspy/releases,...
Hi Steve Flynn Please verify version https://github.com/schemaspy/schemaspy/releases,...
Hi pothoven Please verify version https://github.com/schemaspy/schemaspy/releases,...
Hi Bijan Vakili Please verify version https://github.com/schemaspy/schemaspy/releases,...
Hi Please verify version https://github.com/schemaspy/schemaspy/releases, if this...
Corrected patch is schemaspy_bug193_patch.diff
Custom SQL for table column listing.
Hi, I'd like to revive a discussion on Ingres support. I have two Ingres server connections...
I've successfully tested this on OS-X against a PostgreSQL v9.5 database with 7 ...
Non-zero error code when querying multiple schemas
Currently we are able to pull the metadata and insert into an html (from hive). However,...
\java -Xmx1073741824 -jar schemaSpy_5.0.0.jar -dp ojdbc14.jar -t orathin -db This...
D:\schemaSpy>C:\app\Oracle\product\11.2.0\client_2\jdk\bin\java -jar schemaSpy_5.0.0.jar...
java.lang.OutOfMemoryError: Java heap space
Try my GitHub sturton https://github.com/sturton/maven-schemaspy-plugin Sent from...
Use long for row count in meta data
I have some tables with larger numbers of rows in them. When I try to generate the...
Followed pointers given by @SDietrich and made update to the source code and it appears...
I am also encountering this situation. Database is PostgreSQL, and schema name is...
I was trying to do the same and found this very useful GitHub link: https://github.com/lgaa/HANAschemaspy...
not reading View comments