WhiteRabbit version 1.0.0

This is the release of the new version of WhiteRabbit and Rabbit in a Hat: 1.0.0

Most notable additions and changes:

• support for a new database: Snowflake;
• The database drivers (JDBC) for Google BigQuery and Teradata are no longer included, they need to be downloaded separately when needed;
• update of dependencies to recent versions to avoid security issues
• a fix was added to read CSV's that contain a Byte Order Mark (BOM) without errors (#411)
• the Oracle JDBC dependency was updated

Note that Snowflake users running WhiteRabbit with Java version 16 or newer, the environment variable JAVA_OPTS should be set to (or extended with): --add-opens=java.base/java.nio=ALL-UNNAMED

WhiteRabbit version 1.0.0 release candidate 2

This is the second release candidate of the next version of WhiteRabbit and Rabbit in a Hat: 1.0.0

Most notable additions and changes:

• support for a new database: Snowflake;
• The database drivers (JDBC) for Google BigQuery and Teradata are no longer included, they need to be downloaded separately when needed;
• update of dependencies to the latest versions to avoid security issues

Changes from the first release candidate:

• for Snowflake, the field metadata is retrieved through a SQL query instead of from the JDBC metadata (it is possible to enable using JDBC metadata instead of SQL by setting the environment variable WR_USE_SNOWFLAKE_JDBC_METADATA to "true" or "1" before starting WhiteRabbit)
• a fix was added to read CSV's that contain a Byte Order Mark (BOM) without errors (issue 411)

Note that Snowflake users running WhiteRabbit with Java version 16 or newer, the environment variable JAVA_OPTS should be set to (or extended with): --add-opens=java.base/java.nio=ALL-UNNAMED

WhiteRabbit version 1.0.0 release candidate 1

This is the first release candidate of the next version of WhiteRabbit and Rabbit in a Hat: 1.0.0

Most notable additions and changes:

• support for a new database: Snowflake;
• The database drivers (JDBC) for Google BigQuery and Teradata are no longer included, they need to be downloaded separately when needed;
• update of dependencies to the latest versions to avoid security issues

For snowflake: please use the attached test candidate WhiteRabbit-1.0.0-rc2-test.zip
This jar fixes issue #409.

Also for Snowflake: when running with Java JDK 16 or newer, the environment variable JAVA_OPTS should be set to (or extended with):
'--add-opens=java.base/java.nio=ALL-UNNAMED'

Test version for issue 293

This test release attempts to solve issue 293. The following text has been added to the documentation:

The Apache POI library is used for generating the scan report in Excel format. This library creates its own directory for temporary files in the system temporary directory. In issue 293 it has been reported that this can cause problems in a multi-user environment, when multiple user attempt to create this directory with too restrictive permissions (read-only for other users). WhiteRabbit from version 0.10.9 attempts to circumvent this automatically, but this workaround can fail due to concurrency problems. If you want to prevent this from happening entirely , you can set either the environment variable ORG_OHDSI_WHITERABBIT_POI_TMPDIR or the Java system property org.ohdsi.whiterabbit.poi.tmpdir to a temporary directory of your choice when starting WhiteRabbit (best would be to add this to the whiteRabbit or whiteRabbit.bat script). Please note that this directory should exist before your start WhiteRabbit, and that it should be writable by any user that may want to run WhiteRabbit. For each user a separate subdirectory will be created, so that permission related conflicts should be avoided. Also, WhiteRabbit now attempts to detect this situation before the scan starts. If this is detected, the scan is not started, and the problem identified before the scan, instead of afterwards.

Dependencies/vulnerabilities update

Update of all minor and patch versions of dependencies, EXCEPT:

• Apache poi and related (newer versions depend on a newer version of xmlbeans, which in turn requires Java 11)
• Teradata jdbc driver (needs a major version update, but there is no facility to test this)

Note: In version 0.10.8 one dependency was missing due to an oversight, this breaks CSV imports, version 0.10.8a fixes that.

Debug release of v0.10.7

This version is functionally identical to v0.10.7, but prints a line in the console window when the system property 'jdbc.drivers' has a non-null value, for debugging purposes. Unless you need this, use v0.10.7 as previously released.

WhiteRabbit v0.10.7

Fixes

• Fix database connection of fake data generator #326
• Fix column names CDMv6 #323
• Fix redshift jdbc to match POM #327
• Update postgres dependency #329

WhiteRabbit v0.10.6

Fixes

• Invalid scan report file issue #316, introduced in v0.10.4 when upgrading apache poi dependencies
• Word export, same underlying issue.

WhiteRabbit v0.10.5

Fixes

• Remove dependency on apache poi-ooxml-schemas, fixing issue with scan report generation

WhiteRabbit v0.10.4

New features and improvements

Rabbit in a Hat

• Support for CDM v5.4 #311
• General CDM version cleanup #311

White Rabbit

None

Fixes

Rabbit core

• Dependency updates. #289

White Rabbit

None

Rabbit in a Hat

• Avoid translating JSON multiple times #291