SchemaSpy Release Notes

• 3.1.1 - 12/18/2006
  • Resolved bug 1602135 - Exception using dot version 2.9.
  • Resolved bug 1571711 - Fail to use precompiled version of dot on MacOS-X.
  • Resolved bug 1597609 - Quoting and Sybase ASE.
  • Resolved bug 1589939 - Incorrect Sybase SQL syntax by extract the number of rows.
• 3.1.0 - 10/05/2006
  • Implemented feature request 1537790 - Column name sort.
    The Columns page is now sortable by column, table, type, size, nullability, auto increment, default value, children or parents.
    Thanks to John Danilson for the suggestion.
  • Implemented feature request 1479956 - Add description.
    Added a new option (-desc) to provide a description of the schema that is displayed on the non-detail pages.
    Thanks to Amihay Gonen for the suggestion.
  • Implemented feature request 1570467 - No table comments option.
    Added -notablecomments option for databases like MySQL that stuff unrelated data where comments belong.
  • Resolved bug 1484462 - SchemaSpy_3.0.0 and Oracle 10g problems.
    Now ignores tables associated with Oracle's recycle bin.
  • Resolved bug 1558067 - OutOfMemoryError on Linux while trying to determine insertion order with recursive constraints. Thanks to Remke Rutgers for his solution.
  • Resolved bug 1530945 - Incorrect variables size in DB2.
    Now uses the value from BUFFER_LENGTH if it's available.
  • Resolved bug 1487385 - XML file is not a valid UTF8.
    Bernard D'Havé provided the code to resolve this one.
  • Resolved bug 1507335 - Views are not filtered with the regular expressions.
  • Resolved bug 1502357 - Blank Relationships tab.
  • Resolved bug 1530965 - columns.html table output issues with DB2.
  • Resolved bug 1487385 - XML file is not valid UTF8.
  • Resolved bug 1571077 - Long comments don't wrap.
• 3.0.0 - 05/07/2006
  • SchemaSpy now generates an XML representation of the database's schema.
  • New -all option analyzes all schemas in the database with one command.
  • Now displays database table and row comments.
  • Comments are normally hidden by default, but a new option reverses that behavior.
  • Added a new option to allow HTML in comments.
  • You can now specify a subset of tables/views to include in the analysis with the new -i <regularExpression> option.
  • Now supports Firebird.
  • Now supports Microsoft SQL Server 2005 thanks to Craig Boland providing a configured mssql05.properties file.
  • Now supports Informix thanks to Tom Conlin providing a configured informix.properties file.
  • A new option (-maxdet) was added to help keep extremely large schemas from getting out of control.
  • Some users needed to specify the character set used to connect to their database, so a new option (-connprops) was added.
  • The relationships page will now always be available, even if there are no relationships or just implied relationships.
  • Tables that contain only implied relationships will now show them by default.
  • Resolved bug 1440650 - Oracle 10g flashback tables with bizarre illegal names cause SchemaSpy to crash.
  • Added support for table names with embedded spaces (feature request 1445745) and reserved words (bug 1449203).
  • Resolved bug 1481396 - NumberFormatException in view.DotFormatter.writeHeader. Now includes diagnostics to help identify Graphviz configuration issues.
  • Cleaned-up the formatting of table details.
• 2.1.2 - 02/28/2006
  • Now generates a relatively useful relationships page even if dot fails to build the larger (and more likely to break Graphviz's dot) images.
  • Lots of minor code cleanup after cranking up Eclipse's warning levels.
• 2.1.1 - 02/05/2006
  • Added a more descriptive error message when the correct version of Graphviz dot isn't installed.
  • Some people were having problems by passing -cp to java and not to SchemaSpy. The classpath-related error messages now clearly specify where -cp belongs.
  • Revamped the classpath-related error messages to include the classpath entries that weren't valid. This should make it easier to track down JDBC driver issues.
  • Updated MySQL's configuration file to point to the latest JDBC drivers. Also gave the URL for the Connector/J drivers.
• 2.1.0 - 11/23/2005
  • SchemaSpy can now analyze all of the schemas of a database with one command. This feature should allow a DBA to do a bulk analysis, documenting every user schema with one command.
  • Resolution of bug 1350392 - NullPointer if FK table not in analyzed schema.
  • Was missing the border along the top edge of the page.
  • Luke Hutteman found a threading issue while reviewing portions of the code. Thanks Luke!
  • Resolution of bug 1351460 - Tab background color mis-named.
  • Resolution of bug 1351488 - Relationships tab displayed when no relationships exist.
  • The layout of the tab area is now significantly cleaner.
  • Added -rankdirbug option to deal with the dot bugs that invariably result from using a non-standard rankdir in .dot files. This option should not be used unless absolutely necessary.
  • Refactored many of the 'formatters' to become 'pages'.
• 2.0.0 - 11/06/2005
  • SchemaSpy now uses a tabbed layout that results in a significantly cleaner page.
  • You now have the ability to explicitly exclude columns from the relationship analysis using a regular expression notation. This keeps those pesky tables that are related to everything from severely cluttering your view of your schema.
  • Added information in the graphs about how many 'parent' and 'child' tables are related to a given table. This gives a visual clue that there are more tables beyond the outskirts of what's currently visible.
  • SchemaSpy now supports HSQLDB thanks to bension providing a hsqldb.properties configuration file.
  • Added support for DB2 UDB Type 4 driver.
  • The graphs are now clearer due to the use of a sans serif font.
  • Resolution of bug 1340880 - accent characters cause dot to fail. SchemaSpy now generates the .dot files using the UTF-8 character set, which is what the dot program expects.
• 1.7.1 - 10/20/2005
  • Added support for DB2's Net (Type 4) driver.
  • Resolution of bug 1325650. Was having more problems with extracting information on Oracle indexes. Due to an Oracle driver bug (Oracle bug #2686037) I inverted how the selectIndexesSql gets evaluated and significantly optimized the SQL. Thanks to Andrea for helping to figure all of this out.
  • Added details of the -cp option to the diagnostic messages when unable to load database drivers.
  • Fixed some minor cosmetic problems.
• 1.7.0 - 10/11/2005
  • SchemaSpy now supports PostgreSQL thanks to Tomi Ollila providing a pgsql.properties.
  • Added a new page that lists all of the columns (with details) in the schema. The intent of this page is to make it easier to find inconsistencies in the schema as well as make it easier to do things like search for all instances of a certain type of column (e.g. 'timestamp').
  • Resolution of bug 1283622. A user from the Slovak Republic ran into problems where dot was unable to deal with some of the characters that are in this character set. Now it should handle them appropriately.
  • Refactored how the links on each page get generated. It was pretty much cut and paste before. Now it's consolidated in HtmlFormatter.writeTableOfContents() so it's much more consistent and easier to change.
  • Implemented feature request 1312220: Modified build.xml to include an appropriate level of debug information (source files and line numbers).
• 1.6.1 - 09/16/2005
  • Fixed Utilities page to not have the 'Generated by SchemaSpy' label on each table.
  • Yan-Fa Li figured out what was causing dot problems on Unix: quotes around filenames.
  • Updated the legend to somewhat match the new IE diagram representation.
• 1.6.0 - 09/11/2005
  • Now displays graphical relationships using Information Engineering (IE) notation. This should make it easier to understand the different types of relationships in the schema.
  • Beefed-up the code that detects if dot is being executed correctly. Some users were getting output that implied that dot was working, but no images were created.
  • Added version information to .dot files to help debugging.
  • Anomalies page had some anomalies.
• 1.5.2 - 09/03/2005
  • Implemented feature request 1280949: Many of DB2's error messages don't give table, column or constraint names but instead give their IDs. As a developer it's a pain to have to try to translate these IDs into something useful. SchemaSpy previously gave these details before I converted to the JDBC metadata approach, which doesn't return these IDs. It now displays these IDs for database types that support it and that have the appropriate SQL defined in their properties files.
• 1.5.0 - 08/30/2005
  • Now displays two versions of the main relationships graph: a smaller 'compact' version and a large full-size version. The compact version should make it easier to get a 'big picture' view of the relationships.
  • Now takes advantage of the GraphVis dot 2.6 ability to point to the East/West center of a node if running dot 2.6 or higher.
  • Figured out a way to have the graph point to the appropriate portion of the main table in the table detail pages.
  • Introduced a new anomaly: Columns whose default value is the word 'NULL' or 'null', but the SQL NULL value may have been intended.
  • Realized that index sort order relates to the column, not the index. Not sure what I was thinking.
  • Added some instructions on the format of connectionSpec in the .properties files.