SchemaCrawler

Release History

Version Date Description
10.08.04 2014-04-03
10.08.03 2014-03-24
10.08.02 2013-12-28
10.08.01 2013-11-17
10.8 2013-11-10
10.7 2013-11-05
10.6 2013-10-30
10.5 2013-09-24
10.4 2013-07-24
10.3 2013-05-24
10.2 2013-05-21
10.1 2013-04-21
9.6 2013-03-08
9.5 2013-02-24
9.4 2013-02-02
9.3.2 2012-11-17
9.3.1 2012-11-3
9.3 2012-10-31
9.2 2012-10-21
9.1 2012-09-30
9.0 2012-09-08
8.17 2012-07-12
8.16 2012-06-20
8.15 2012-05-05
8.14 2012-04-08
8.12 2012-02-25
8.11 2012-02-18
8.10 2011-12-08
8.9 2011-12-08
8.8 2011-11-05
8.7 2011-09-05
8.6 2011-05-08
8.5.1 2011-01-28
8.5 2011-01-28
8.4 2010-12-23
8.3.3 2010-08-01
8.3.2 2010-08-01
8.3.1 2010-07-18
8.3 2010-07-15
8.2 2010-05-25
8.1 2010-02-28
8.0 2010-02-03
7.6 2009-12-03
7.5.1 2009-11-28
7.5 2009-11-25
7.4 2009-09-24
7.3.1 2009-09-24
7.3 2009-09-19
7.2 2009-08-21
7.1 2009-08-12
7.0 2009-07-10
6.4 2009-05-10
6.3 2009-05-08
6.2 2009-04-08
6.1 2009-03-29
6.0.2 2008-11-30
6.0.1 2008-10-30
6.0 2008-10-16
5.5 2008-02-28
5.4 2007-12-15
5.3 2007-11-15
5.2 2007-10-30
5.1 2007-08-05
5.0 2007-06-25
4.2 2007-01-07
4.1 2006-12-07
4.0 2006-12-03
3.8 2006-09-26
3.7 2006-06-12
3.6 2006-03-28
3.5 2006-03-06
3.4 2006-01-16
3.3 2005-11-03

Release 10.08.04 - 2014-04-03

Type Changes By
fix Column sort options sort columns in dumps also. Sualeh Fatehi
fix Added generation date to database diagram. Sualeh Fatehi

Release 10.08.03 - 2014-03-24

Type Changes By
fix Made extra columns provided in all information schema views available as attributes of SchemaCrawler Java objects. Sualeh Fatehi
add Added table definition metadata for Oracle. Sualeh Fatehi
add Allow for code to be executed before and after the crawl. This is in the form of pre- and post- executables. Sualeh Fatehi
add Added foreign key definition metadata for Oracle. Sualeh Fatehi
fix Fixed DDL metadata for Oracle, so that it is portable. Sualeh Fatehi
fix Converted code to Git. Sualeh Fatehi

Release 10.08.02 - 2013-12-28

Type Changes By
fix Updated copyright notices. Sualeh Fatehi
fix Fixed javadocs, using standard Java 7 stylesheet. Sualeh Fatehi

Release 10.08.01 - 2013-11-17

Type Changes By
fix Trim all table names, to allow Informix to match correctly. Sualeh Fatehi

Release 10.8 - 2013-11-10

Type Changes By
add Providing richer information about table constraints, including details of constrained columns. Sualeh Fatehi

Release 10.7 - 2013-11-05

Type Changes By
add Providing richer information about table constraints. Renaming check constraints to table constraints. Sualeh Fatehi
fix Worked abound ArrayIndexOutOfBoundsException in MySQL connector with connector 5.1.26 and server version 5.0.95. See https://sourceforge.net/p/schemacrawler/patches/5/ Sualeh Fatehi

Release 10.6 - 2013-10-30

Type Changes By
fix Changed InclusionRule to an interface, to allow custom implementations. Sualeh Fatehi
fix Fixed lack of support for type maps by the Sybase IQ database driver. Sualeh Fatehi

Release 10.5 - 2013-09-24

Type Changes By
fix Fixed bug with table restrictions. Sualeh Fatehi
fix Support all command-line options in ant task. Sualeh Fatehi

Release 10.4 - 2013-07-24

Type Changes By
fix Fixed view definitions for PostgreSQL. Sualeh Fatehi
fix Fixed retrieving index metadata for tables, working around PostgreSQL bugs #3480 and #6253. Sualeh Fatehi
add Added retrieving index definitions for PostgreSQL and Oracle. Sualeh Fatehi
add Added retrieving view definitions for Apache Derby. Sualeh Fatehi

Release 10.3 - 2013-05-24

Type Changes By
fix Rework of the column data type classes, as well as a workaround for an Oracle JDBC driver bug with reporting data type information. Sualeh Fatehi

Release 10.2 - 2013-05-21

Type Changes By
add New option to set output encoding format. The option is "schemacrawler.encoding.output" in the SchemaCrawler properties file. Default input and output encoding has been changed to UTF-8. Sualeh Fatehi
add Support for showing trigger information in Sqlite. Sualeh Fatehi

Release 10.1 - 2013-04-21

Type Changes By
add SchemaCrawler support for J2SE 7 only, since previous Java versions are deprecated. Converted the codebase over to use J2SE 7 constructs. Sualeh Fatehi
add New command-line option, -only-matching, to show only matching tables, and does not show foreign keys that reference other non-matching tables. Modeled after the analogous grep option. Sualeh Fatehi
add New option to set input encoding format for script files and templates. The option is "schemacrawler.encoding.input" in the SchemaCrawler properties file. Sualeh Fatehi
fix Renamed command-line option -table_types to -tabletypes. Sualeh Fatehi

Release 9.6 - 2013-03-08

Type Changes By
fix Fixed diagram generation on Linux when no GraphViz options are supplied. Sualeh Fatehi
fix Added trigger names to JSON output by default. Added new configuration variable, schemacrawler.format.hide_trigger_names to suppress trigger names in all output formats. Sualeh Fatehi
add Added new -portablenames command-line option, to allow for easy comparison between databases, by hiding foreign key names, constraint names, trigger names, index and primary key names, and not showing the fully-qualified table name. Sualeh Fatehi

Release 9.5 - 2013-02-24

Type Changes By
fix Updated HTML generation to have captions consistently for all tables. Numeric data is right-aligned in HTML, and correctly reported in JSON as well. These changes affect other output formats as well. Sualeh Fatehi
fix Updated Oracle database connection URL to the new syntax. Sualeh Fatehi

Release 9.4 - 2013-02-02

Type Changes By
fix Fix for honoring text formatting options in GraphViz dot output. Sualeh Fatehi

Release 9.3.2 - 2012-11-17

Type Changes By
fix Fix for honoring sort options on JSON output. Sualeh Fatehi

Release 9.3.1 - 2012-11-3

Type Changes By
fix Fix for generating diagrams on Unix. Sualeh Fatehi

Release 9.3 - 2012-10-31

Type Changes By
fix Weak associations are returned sorted. Sualeh Fatehi
add Added ability to specify additional command line options for GraphViz, using either Java system properties, or environmental variables. Sualeh Fatehi

Release 9.2 - 2012-10-21

Type Changes By
fix Fixed Windows script, sc.cmd. Sualeh Fatehi
fix Better support for sqlite, including the latest database driver, reporting of foreign keys, and view definitions. Sualeh Fatehi
fix Updated the jTDS JDBC driver to 1.2.6, for Microsoft SQL Server. Sualeh Fatehi
fix Deprecated the getType() method on database objects. Sualeh Fatehi

Release 9.1 - 2012-09-30

Type Changes By
add Added examples for Groovy, Ruby and Python scripting. Sualeh Fatehi
add SchemaCrawler is now bundled as an OSGi jar. Sualeh Fatehi

Release 9.0 - 2012-09-08

Type Changes By
add The API has changed from 8.x versions. All API calls return collections instead of arrays. Schemas are not containers, but tags for database objects. Tables and routines (stored procedures and functions) are available directly on the database, and there are new finders to search by schema. Sualeh Fatehi
add Support for database functions has been added. All references to stored procedures in the code and documentation now refer to routines. Stored procedures and functions are treated in the same way, as routines. Sualeh Fatehi
add SchemaCrawler now allows queries to be specified on the command-line. If a command is not recognized, or is not a named query, it is executed as if it is a query. Sualeh Fatehi
fix The output format includes trgger definitions as part of the schema, instead of as the detailed schema output. Sualeh Fatehi
fix Database connections have to be specified on the command-line, by providing the driver class name and URL. Database connections can no longer be defined in properties files. Sualeh Fatehi
add There are new command-line options. -V, --version will print the SchemaCrawler version and exit. There are shorter and more standard (Unix-like) synonyms -u (for -user), -c (for -command), and -o (for -output). The -procedures switch has been renamed -routines. Sualeh Fatehi

Release 8.17 - 2012-07-12

Type Changes By
fix The HTML output format outputs valid HTML5 and CSS3, as valid XML. Sualeh Fatehi
fix JSON output supports all of the formatting options that the other text formats support. Sualeh Fatehi
add A new method, getShortName(), get the unqualified name for columns and other dependent objects. Sualeh Fatehi
add A new text format option, "schemacrawler.format.show_unqualified_names", shows the unqualified name in text output, for easier comparisons across different catalogs and schemas. Sualeh Fatehi

Release 8.16 - 2012-06-20

Type Changes By
add Added support for synonyms. Synonyms are shown in SchemaCrawler output for IBM DB2, Oracle, and Microsoft SQL Server, as well as available for extension in other databases. Sualeh Fatehi

Release 8.15 - 2012-05-05

Type Changes By
add Added distribution for Sybase IQ. Sualeh Fatehi

Release 8.14 - 2012-04-08

Type Changes By
add Added new command-line switch to show parent and child tables, in addition to those selected by grep. Sualeh Fatehi

Release 8.12 - 2012-02-25

Type Changes By
add Added ability to stream SchemaCrawler output. Sualeh Fatehi

Release 8.11 - 2012-02-18

Type Changes By
add Added ability to configure SchemaCrawler linters. Sualeh Fatehi
add Added a new lint for useless surrogate keys. Sualeh Fatehi
add Added ability to tag tables and columns with additional metadata attributes from SQL queries. Sualeh Fatehi

Release 8.10 - 2011-12-08

Type Changes By
add Added SchemaCrawler Lint as a separate report, with ability to add custom linters. Sualeh Fatehi
add Added additional SchemaCrawler linters. Sualeh Fatehi
add Added ability to extend SchemaCrawler with custom command. Sualeh Fatehi
fix Fixed issue with constraints with the same name in different schemas. Sualeh Fatehi

Release 8.9 - 2011-12-08

Type Changes By
add Added SchemaCrawler Lint as a separate report, with ability to add custom linters. Sualeh Fatehi
add Added additional SchemaCrawler linters. Sualeh Fatehi
add Added ability to extend SchemaCrawler with custom command. Sualeh Fatehi
fix Fixed issue with constraints with the same name in different schemas. Sualeh Fatehi

Release 8.8 - 2011-11-05

Type Changes By
add Added JSON and TSV output formats. Sualeh Fatehi
fix Moved SchemaCrawler Maven Plugin into a new SourceForge project. Sualeh Fatehi

Release 8.7 - 2011-09-05

Type Changes By
add New INFORMATION_SCHEMA views to provide Oracle metadata details. Sualeh Fatehi
update Update database driver versions. Sualeh Fatehi
fix Fixed bug #3392557 - NullPointer exception thrown when columns excluded in Oracle. Sualeh Fatehi
fix Fixed bug #3392976 - Exception retrieving tables: Could not retrieve indices for Oracle schemas with $ in the name. Sualeh Fatehi
fix Fixed bug #3401752 - Attempt to locate database 'dbo' by name failed. Sualeh Fatehi

Release 8.6 - 2011-05-08

Type Changes By
add New feature to chain, or run multiple SchemaCrawler commands using JavaScript. Sualeh Fatehi

Release 8.5.1 - 2011-01-28

Type Changes By
fix Re-organized command line code, including grep command line. Sualeh Fatehi

Release 8.5 - 2011-01-28

Type Changes By
fix Changed copyright to 2011. Sualeh Fatehi
fix Fixed grep. Sualeh Fatehi
fix Removed option to provide index info SQL. Sualeh Fatehi
fix Better unit test coverage. Restructuring of Eclipse projects. Sualeh Fatehi

Release 8.4 - 2010-12-23

Type Changes By
fix Simplified commands - list_objects is now simply list. Removed the -show_stored_procedures command line option - simply use -proedures= Sualeh Fatehi
fix Fixed issue with obtaining PostgreSQL tables. Sualeh Fatehi
fix Fixed issue with obtaining Derby foreign keys. Sualeh Fatehi
fix Made -infolevel a required command line argument. Sualeh Fatehi
fix Use Maven 3.0 in the build. Sualeh Fatehi

Release 8.3.3 - 2010-08-01

Type Changes By
add Added color to headings in HTML output. Sualeh Fatehi
fix Fixed bug when remarks header was not shown if the table did not have remarks, but columns did. Sualeh Fatehi
fix DB2 INFORMATION_SCHCEMA SQL fixed. Sualeh Fatehi
fix Foreign keys show full column names in graphs, even when the table is excluded. Sualeh Fatehi

Release 8.3.2 - 2010-08-01

Type Changes By
add Column remarks are printed along with table remarks. Sualeh Fatehi
fix Foreign keys show full column names in graphs, even when the table is excluded. Sualeh Fatehi

Release 8.3.1 - 2010-07-18

Type Changes By
add Added new command line option, -urlx, to pass JDBC URL properties to bundled distributions. Sualeh Fatehi
add Added details on the "main" command line in the how-to section of the website. Sualeh Fatehi

Release 8.3 - 2010-07-15

Type Changes By
add Added new bundled distribution for IBM DB2. Sualeh Fatehi
add Added new bundled distribution for HyperSQL 2.0.0. Sualeh Fatehi
add Added support for spaces in schema and catalog names. Sualeh Fatehi
update Changed the test database to HyperSQL 2.0.0. Changed the test data, and added more robust unit tests. Sualeh Fatehi

Release 8.2 - 2010-05-25

Type Changes By
add Added support for spaces or reserved words in table, procedure, and column names. Sualeh Fatehi
add Added new database lint to find column and table names with spaces or reserved words in them. Sualeh Fatehi
add Added SchemaCrawler to the Sonatype Maven public repository. Added new Maven projects examples. Sualeh Fatehi
update Table and procedure remarks are output with verbose output. Sualeh Fatehi
update The Maven plug-in generates a database report that uses the same stylesheet as the rest of the Maven generated website. Sualeh Fatehi
update Generated database diagrams are less "colorful". Sualeh Fatehi

Release 8.1 - 2010-02-28

Type Changes By
add Added SchemaCrawler lint, to highlight potential normalization issues, such as incrementing column names, and other issues. A new -infolevel value, lint, was added. Sualeh Fatehi
update Weak associations are now available only with SchemaCrawler lint. Sualeh Fatehi

Release 8.0 - 2010-02-03

Type Changes By
add Added the -infolevel command-line switch to control the amount of database metadata retrieved by SchemaCrawler. Sualeh Fatehi
add Create a command registry, which allows pluggable commands. Any command can be run from the main class. Sualeh Fatehi
update Dropped the -catalogs command-line switch filtering catalogs. Dropped the concept of a catalog from the API. Databases now directly contain schemas. Sualeh Fatehi

Release 7.6 - 2009-12-03

Type Changes By
fix Fixed specification of Oracle SID using the -database command line switch, as well as spcification of port number. Sualeh Fatehi
fix Fixed shell script classpath. Sualeh Fatehi

Release 7.5.1 - 2009-11-28

Type Changes By
fix Added methods to get imported and exported foreign keys and weak associations. Sualeh Fatehi

Release 7.5 - 2009-11-25

Type Changes By
add Added a SchemaCrawlerInfo object to the database metadata, to provide the SchemaCrawler version number, and Java system properties. Sualeh Fatehi
update Updates to all bundled database drivers. Sualeh Fatehi
fix Bug-fix for obtaining MySQL foreign keys. Sualeh Fatehi
add Added ability to script the database, using JavaScript. A live connection is provided to the JavaScript context for this purpose. Sualeh Fatehi
update Removed command line switch, -schemapattern, and the schemapattern option. Use the -schemas command line switch instead. Sualeh Fatehi
update Added sections to SchemaCrawler output, to make it more readable. Sualeh Fatehi
update Tables sort is done using graph algorithms, and includes cycle checks. Sualeh Fatehi

Release 7.4 - 2009-09-24

Type Changes By
add Added new pre-packaged SchemaCrawler for Oracle. Sualeh Fatehi
fix Fixed issue with index sort order of primary key columns. Sualeh Fatehi
update Updated website with new front page. Sualeh Fatehi

Release 7.3.1 - 2009-09-24

Type Changes By
fix Enhancement to the JavaSqlType class, to contain the SQL type group. New lookup by data-type name added to JavaSqlTypesUtility. Sualeh Fatehi
fix Removed method, getTypeClass(), from ColumnDataType. Sualeh Fatehi
fix Removed deprecated methods for grouping SQL data types (such as isReal()) from the ColumnDataType class. Sualeh Fatehi

Release 7.3 - 2009-09-19

Type Changes By
add Added support for mapping of SQL data type to Java classes. This includes the new JavaSqlType class, and the JavaSqlTypesUtility. A new method, getTypeClass(), has been added to ColumnDataType. Sualeh Fatehi
add Added SchemaCrawler for Apache Derby, that is packaged for Apache Derby. Sualeh Fatehi

Release 7.2 - 2009-08-21

Type Changes By
update Better modeling of privileges and grants. Sualeh Fatehi
fix Bug fix for obtaining indexes and foreign keys with the Oracle driver. Sualeh Fatehi
add Added natural sort order for tables, based on the foreign keys, and corresponding new configuration option, and command-line switch, -sorttables. Also added new API methods to get child and parent tables, based on the foreign keys. Sualeh Fatehi
fix Handle null schemas for databases that do not support schemas, such as MySQL. Sualeh Fatehi
fix Allow data dumps when tables contain binary objects, by fixing the SELECT sort order. Sualeh Fatehi

Release 7.1 - 2009-08-12

Type Changes By
update Better log messages, including for database connections, and inclusion of table and columns in the output. Sualeh Fatehi
update More efficient use of database connections, including a change to the Executable.execute method to take a database connection, rather than a data-source. Sualeh Fatehi
fix Ensure that the pooled connection is closed, rather than the original database connection. This allows SchemaCrawler to play well with pooled connections. Sualeh Fatehi

Release 7.0 - 2009-07-10

Type Changes By
update Major restructuring of the API, with the introduction of a Database object that contains all of the database metadata, and containing catalog and schema objects. Sualeh Fatehi
update To allow for more control on table selection, the -tables command line parameter matches to the fully qualified table name, CATALOG.SCHEMA.TABLENAME. Similarly for the -routines command line parameter. Sualeh Fatehi

Release 6.4 - 2009-05-10

Type Changes By
add New pre-packaged distribution, SchemaCrawler for SQLite. Sualeh Fatehi
update Enhanced algorithm for finding weak associations. Sualeh Fatehi

Release 6.3 - 2009-05-08

Type Changes By
add If no commands are specified, defaults to standard_schema, which provides the most commonly needed details of the schema. Sualeh Fatehi
update SchemaCrawler Grep functionality is built into the SchemaCrawler options, and the SchemaCrawler command-line. This means that all of the SchemaCrawler commands, including graphing, will use filtering and grep options. Sualeh Fatehi
update SchemaCrawler command line option help has been re-written. New command-line options are available. Sualeh Fatehi
add SchemaCrawler can produce Graphviz DOT files to generate schema diagrams. Sualeh Fatehi

Release 6.2 - 2009-04-08

Type Changes By
add A new feature to infer weak associations between tables, even if there is no foreign key. Ruby on Rails table schemes are supported, as well as other simple relationships. Table name prefixes are automatically detected. Sualeh Fatehi
add Database diagram support using Graphviz. Primary keys are indicated in a darker color than other columns. Foreign keys are indicated with arrow connectors. Weak associations between tables are shown in dashed lines. Multiple output formats are supported. Support for Jung is dropped. Sualeh Fatehi

Release 6.1 - 2009-03-29

Type Changes By
add Better reporting of ascending and descending index columns. This is an API change. Sualeh Fatehi
add Better grep options, to allow searching through both tables and stored procedures. Sualeh Fatehi
fix Grep options default to excluding stored procedures. Sualeh Fatehi
fix Minor bug fixes for Sybase, including generating warnings when obtaining table column privileges, instead of failing. Sualeh Fatehi
update New Windows script file for locating Java, and launching SchemaCrawler. Sualeh Fatehi
update Reorganization of distribution, so that only a single SchemaCrawler jar file is distributed in all distributions. License distribution is also reorganized. Sualeh Fatehi

Release 6.0.2 - 2008-11-30

Type Changes By
fix Minor bug fixes for MySQL, where the schema name was being reported as null, causing an exception. Sualeh Fatehi

Release 6.0.1 - 2008-10-30

Type Changes By
fix Minor bug fixes for Oracle, where the data-type was a short instead of an integer. Sualeh Fatehi

Release 6.0 - 2008-10-16

Type Changes By
fix Changed the API so that there is a separation of concerns - the SchemaInfoLevel should be an option, not a CrawlHandler property. Sualeh Fatehi
add Changed the API so the top level object is a catalog, which contains schemas. This means that there is full support for multiple schemas. Sualeh Fatehi
add Added support for JavaScript scripting. Sualeh Fatehi

Release 5.5 - 2008-02-28

Type Changes By
fix Fixed bug that always reported an index as unique. Sualeh Fatehi
fix Fixed bug with primary key columns. Sualeh Fatehi
add SchemaCrawler for Microsoft SQL Server to show procedures and triggers. Sualeh Fatehi
add SchemaCrawler distribution for any database. Sualeh Fatehi

Release 5.4 - 2007-12-15

Type Changes By
add Added new command line switch, -schemapattern, for specifying schema patterns when a connection is specified from the command line. Sualeh Fatehi
add Added object attributes automatically, from unused columns in the metadata calls. Nothing goes to waste. Sualeh Fatehi
add Added JDBC driver metadata, including driver properties, and separated those from the database system metadata. Sualeh Fatehi

Release 5.3 - 2007-11-15

Type Changes By
fix Made sure that all relevant license files are getting delivered. Sualeh Fatehi
fix Fixed bug in accessing foreign key update and delete rules on Oracle. Sualeh Fatehi
fix Fixed equals comparison on all schema objects, and added a unit test for equals. Sualeh Fatehi
add Added an easier way to access foreign keys from the foreign key column itself Use isPartOfForeignKey(), and getReferencedColumn() on the Column class. Sualeh Fatehi
add Externalized the wrapper for java.sql.Types into a new public class, schemacrawler.schema.SqlDataType. Sualeh Fatehi
add Added the ability to get result-set metadata. Sualeh Fatehi
add Changed schema info level from an enum into a class that can be used to specify details on what aspects of the schema need to be retrieved. Sualeh Fatehi

Release 5.2 - 2007-10-30

Type Changes By
add A significant re-write of the internal command processing code. Sualeh Fatehi
add Spring framework support for all of SchemaCrawler functionality, including integrations and grep. Sualeh Fatehi
add New example for grep. Sualeh Fatehi
add New example for using the Spring framework with SchemaCrawler. Sualeh Fatehi
fix Pre-packaged releases do not load config file, even if available. Sualeh Fatehi
fix Fixed Unix shell script for PostgreSQL. Sualeh Fatehi

Release 5.1 - 2007-08-05

Type Changes By
add Simplified examples. Sualeh Fatehi
add Executable for SchemaCrawler for Microsoft SQL Server and MySQL. Sualeh Fatehi
add Commonly available SchemaCrawler command line argument for setting the log level. Sualeh Fatehi

Release 5.0 - 2007-06-25

Type Changes By
fix API changed to use Java 5 constructs. Tested with Java 6. API is no longer Java 1.4 compatible. Sualeh Fatehi
add Started SchemaCrawler Grep for MS SQL Server. Sualeh Fatehi
fix Fixed java.lang.AbstractMethodError with Java 6. Sualeh Fatehi

Release 4.2 - 2007-01-07

Type Changes By
fix Fixed null pointer exception with DB2. Sualeh Fatehi
fix Fixed error message on a bad command line. Added a general -help option. Sualeh Fatehi
add Added new schema grep functionality, that can search for tables and columns usng regular expressions. Sualeh Fatehi
add Added new example for setting options programatically. Sualeh Fatehi
add Added documentation for provding database connection options directly on the command line. Sualeh Fatehi
update Updated ant task to optionally take database connection options as arguments, instead of from the configuration file. Sualeh Fatehi

Release 4.1 - 2006-12-07

Type Changes By
fix Fixed bug [ 1610140 ] Sorting doesn't work. Sualeh Fatehi
fix Fixed output of standard data types. Also changed the configuration option name. Sualeh Fatehi
fix Fixed column output for tables and procedures that contain an underscore in their name. JDBC matches the underscore to a wildcard character. Sualeh Fatehi

Release 4.0 - 2006-12-03

Type Changes By
add Added support for SQL standard INFORMATION_SCHEMA views. If equivalent SQL for the standard INFORMATION_SCHEMA view is specified, it is used to provide additional schema information such as check constraints, triggers, and view and procedure definitions. Sualeh Fatehi
add Added support for get index information views. This SQL will be used in preference to the getIndexInfo JDBC method to allow for databases and drivers that do not support getIndexInfo due to permissioning issues. Sualeh Fatehi
fix Better output format for HTML and text. Sualeh Fatehi
fix Better handling of output file resources. Sualeh Fatehi
fix Better handling of database connection resources. Sualeh Fatehi
fix More information on the website, and better website usability. Sualeh Fatehi

Release 3.8 - 2006-09-26

Type Changes By
add Added Maven 2.0 plugin for generation of schema reports Sualeh Fatehi
add Added command line option to provide database connection information Sualeh Fatehi
fix Worked around a bug in the Oracle driver as described in http://issues.apache.org/jira/browse/DDLUTILS-29?page=all Sualeh Fatehi

Release 3.7 - 2006-06-12

Type Changes By
add Added retrieval of database properties Sualeh Fatehi
add Added retrieval of column data types, both system datatypes and UDTs Sualeh Fatehi
add Added unit tests to ensure that the XHTML output is valid XML Sualeh Fatehi
fix Fixed bug with merge rows option Sualeh Fatehi
fix Fixed bug with appending output when multiple runs of SchemaCrawler append to the same output file Sualeh Fatehi
fix Fixed SQLException with Oracle Database 10g Express Edition driver on outputting views Sualeh Fatehi
add Added XStream integration for XML serialization and deserialization Sualeh Fatehi
add Added new command, verbose_schema, that can give all possible details of the schema Sualeh Fatehi
add Obtain database system properties when the maximum schema command is used Sualeh Fatehi
add Added integrations with FreeMarker for templated output Sualeh Fatehi
remove Removed Betwixt integration, since the required functionality is provided by XStream Sualeh Fatehi

Release 3.6 - 2006-03-28

Type Changes By
add Added integrations with Velocity for templated output, and with JUNG for JPEG graph generation Sualeh Fatehi
add Added new examples to demonstrate Velocity templating, and JUNG graphs Sualeh Fatehi
add New command line option to specify the output file name Sualeh Fatehi

Release 3.5 - 2006-03-06

Type Changes By
add Added ability to retrieve column and table privileges Sualeh Fatehi
add Added Betwixt mappings for XML serialization and de-serialization Sualeh Fatehi
add Added Unix shell scripts for examples Sualeh Fatehi
fix Fixed bug with the ordering of primary key and index columns Sualeh Fatehi
update Changed API - ColumnInfoLevel is called SchemaInfoLevel Sualeh Fatehi
update Moved source repository to Subversion Sualeh Fatehi

Release 3.4 - 2006-01-16

Type Changes By
fix Correction of spelling of the "sort_alphabetically" option names Sualeh Fatehi
update Refactoring of inhertance hierarchy of database objects, resulting in fewer equals, hashCode and compareTo implementations Sualeh Fatehi
update Better HTML formatting for counts Sualeh Fatehi
fix Dirty reads are performed for counts and other operations Sualeh Fatehi
fix Sets the default value for table columns Sualeh Fatehi
update Javadoc clean-up Sualeh Fatehi
update Findbugs, checkstyle, and PMD code smells clean-up Sualeh Fatehi

Release 3.3 - 2005-11-03

Type Changes By
add The ability to include as well as exclude tables using regular expressions. Sualeh Fatehi
add The ability to include as well as exclude columns using regular expressions. Sualeh Fatehi
add A new substitution variable, ${columns}, for use in database queries that iterate over tables. Sualeh Fatehi
add New examples for executing database-specific and user-defined queries have been added. Sualeh Fatehi
add Better output formatting for HTML dumps, and counts in text format. Sualeh Fatehi
add New website. Sualeh Fatehi
fix Worked around an issue with the Sybase driver, that provides primary keys in a different order than most other drivers. Sualeh Fatehi
fix Improved logging, and made the log level in the configuration really work. Sualeh Fatehi