Charset is always `utf-8`, deprecated IMPORT_DATA_TYPES `FROM_RESULT_SET` value .

The behaviour when it comes to character sets is now simplified,
The target charset is now always UTF-8.
The IMPORT_DATA_TYPES property (and value FROM_RESULT_SET) are now deprecated (change in vs-common-jdbc):
An exception will be thrown when users useFROM_RESULT_SET. The exception message warns the user that the value is no longer supported and the property itself is also deprecated.

Refactoring

• #32: Updated tests to include Exasol V8/ Update to vsjdbc 12.0.0

2.1.2 Fix vulnerabilities CVE-2024-25710 and CVE-2024-26308 in test dependencies

This is a security release in which we updated test dependency com.exasol:exasol-test-setup-abstraction-java to fix vulnerabilities CVE-2024-25710 and CVE-2024-26308 in its transitive dependencies.

Security

• #37: Fixed vulnerabilities CVE-2024-25710 and CVE-2024-26308

Dependency Updates

Compile Dependency Updates

• Updated com.exasol:virtual-schema-common-jdbc:11.0.2 to 12.0.0

Test Dependency Updates

• Updated com.exasol:exasol-testcontainers:6.6.2 to 7.0.1
• Updated com.exasol:hamcrest-resultset-matcher:1.6.1 to 1.6.5
• Updated com.exasol:test-db-builder-java:3.5.1 to 3.5.4
• Updated com.exasol:udf-debugging-java:0.6.11 to 0.6.12
• Updated com.sap.cloud.db.jdbc:ngdbc:2.18.13 to 2.19.16
• Updated org.junit.jupiter:junit-jupiter:5.10.0 to 5.10.2
• Updated org.mockito:mockito-junit-jupiter:5.6.0 to 5.11.0
• Updated org.slf4j:slf4j-jdk14:2.0.9 to 2.0.12
• Updated org.testcontainers:jdbc:1.19.1 to 1.19.7

Plugin Dependency Updates

• Updated com.exasol:error-code-crawler-maven-plugin:1.3.0 to 2.0.1
• Updated com.exasol:project-keeper-maven-plugin:2.9.12 to 4.2.0
• Updated org.apache.maven.plugins:maven-compiler-plugin:3.11.0 to 3.12.1
• Updated org.apache.maven.plugins:maven-enforcer-plugin:3.4.0 to 3.4.1
• Updated org.apache.maven.plugins:maven-failsafe-plugin:3.1.2 to 3.2.5
• Updated org.apache.maven.plugins:maven-surefire-plugin:3.1.2 to 3.2.5
• Added org.apache.maven.plugins:maven-toolchains-plugin:3.1.0
• Updated org.codehaus.mojo:flatten-maven-plugin:1.5.0 to 1.6.0
• Updated org.codehaus.mojo:versions-maven-plugin:2.16.0 to 2.16.2
• Updated org.jacoco:jacoco-maven-plugin:0.8.10 to 0.8.11
• Updated org.sonarsource.scanner.maven:sonar-maven-plugin:3.9.1.2184 to 3.10.0.2594

2.1.1: Dependency upgrade

Summary

This release fixes vulnerability CVE-2023-42503 in transitive test dependency to org.apache.commons:commons-compress via exasol-testcontainers by updating dependencies. Production code was not affected.

Security

• #33: Fixed vulnerability CVE-2023-42503 in test dependency org.apache.commons:commons-compress

Dependency Updates

Compile Dependency Updates

• Updated com.exasol:error-reporting-java:1.0.0 to 1.0.1
• Updated com.exasol:virtual-schema-common-jdbc:10.1.0 to 11.0.2

Test Dependency Updates

• Updated com.exasol:exasol-testcontainers:6.5.0 to 6.6.2
• Updated com.exasol:hamcrest-resultset-matcher:1.5.2 to 1.6.1
• Updated com.exasol:test-db-builder-java:3.4.2 to 3.5.1
• Updated com.exasol:udf-debugging-java:0.6.7 to 0.6.11
• Updated com.sap.cloud.db.jdbc:ngdbc:2.15.10 to 2.18.13
• Updated org.junit.jupiter:junit-jupiter:5.9.2 to 5.10.0
• Updated org.mockito:mockito-junit-jupiter:5.0.0 to 5.6.0
• Updated org.slf4j:slf4j-jdk14:2.0.6 to 2.0.9
• Updated org.testcontainers:jdbc:1.17.6 to 1.19.1

Plugin Dependency Updates

• Updated com.exasol:error-code-crawler-maven-plugin:1.2.1 to 1.3.0
• Updated com.exasol:project-keeper-maven-plugin:2.9.1 to 2.9.12
• Updated org.apache.maven.plugins:maven-assembly-plugin:3.4.2 to 3.6.0
• Updated org.apache.maven.plugins:maven-compiler-plugin:3.10.1 to 3.11.0
• Updated org.apache.maven.plugins:maven-enforcer-plugin:3.1.0 to 3.4.0
• Updated org.apache.maven.plugins:maven-failsafe-plugin:3.0.0-M7 to 3.1.2
• Updated org.apache.maven.plugins:maven-surefire-plugin:3.0.0-M7 to 3.1.2
• Added org.basepom.maven:duplicate-finder-maven-plugin:2.0.1
• Updated org.codehaus.mojo:flatten-maven-plugin:1.3.0 to 1.5.0
• Updated org.codehaus.mojo:versions-maven-plugin:2.13.0 to 2.16.0
• Updated org.jacoco:jacoco-maven-plugin:0.8.8 to 0.8.10

2.1.0: Enhanced Data Type Detection for Result Sets Latest

Summary

Starting with version 7.1.14 Exasol database uses the capabilities reported by each virtual schema to provide select list data types for each push down request. Based on this information the JDBC virtual schemas no longer need to infer the data types of the result set by inspecting its values. Instead the JDBC virtual schemas can now use the information provided by the database.

This release provides enhanced data type detection for result sets by updating virtual-schema-common-jdbc to version 10.1.0. If this new detection mechanism causes issues (e.g. with encoding of CHAR and VARCHAR types) you can disable it by setting IMPORT_DATA_TYPES to value FROM_RESULT_SET when creating the virtual schema. See the documentation of JDBC adapter properties for details.

We also updated dependencies and added integration tests using the saplabs/hanaexpress Docker image.

Features

• #29: Updated to VSCJDBC 10.1.0

Refactoring

• #5: Added integration tests

Dependency Updates

Compile Dependency Updates

• Updated com.exasol:error-reporting-java:0.4.1 to 1.0.0
• Updated com.exasol:virtual-schema-common-jdbc:9.0.4 to 10.1.0

Test Dependency Updates

• Added com.exasol:exasol-testcontainers:6.5.0
• Added com.exasol:hamcrest-resultset-matcher:1.5.2
• Added com.exasol:test-db-builder-java:3.4.2
• Added com.exasol:udf-debugging-java:0.6.7
• Added com.sap.cloud.db.jdbc:ngdbc:2.15.10
• Updated org.junit.jupiter:junit-jupiter:5.8.1 to 5.9.2
• Updated org.mockito:mockito-junit-jupiter:4.1.0 to 5.0.0
• Added org.slf4j:slf4j-jdk14:2.0.6
• Added org.testcontainers:jdbc:1.17.6

Plugin Dependency Updates

• Updated com.exasol:artifact-reference-checker-maven-plugin:0.4.0 to 0.4.2
• Updated com.exasol:error-code-crawler-maven-plugin:0.1.1 to 1.2.1
• Updated com.exasol:project-keeper-maven-plugin:1.3.2 to 2.9.1
• Updated io.github.zlika:reproducible-build-maven-plugin:0.13 to 0.16
• Updated org.apache.maven.plugins:maven-assembly-plugin:3.3.0 to 3.4.2
• Updated org.apache.maven.plugins:maven-compiler-plugin:3.8.1 to 3.10.1
• Updated org.apache.maven.plugins:maven-enforcer-plugin:3.0.0 to 3.1.0
• Added org.apache.maven.plugins:maven-failsafe-plugin:3.0.0-M7
• Updated org.apache.maven.plugins:maven-jar-plugin:3.2.0 to 3.3.0
• Updated org.apache.maven.plugins:maven-surefire-plugin:3.0.0-M5 to 3.0.0-M7
• Added org.codehaus.mojo:flatten-maven-plugin:1.3.0
• Updated org.codehaus.mojo:versions-maven-plugin:2.8.1 to 2.13.0
• Updated org.jacoco:jacoco-maven-plugin:0.8.7 to 0.8.8
• Added org.sonarsource.scanner.maven:sonar-maven-plugin:3.9.1.2184
• Updated org.sonatype.ossindex.maven:ossindex-maven-plugin:3.1.0 to 3.2.0

Dependency updates

Features

• #25: Migrated to GitHub Actions and updated dependencies

Dependency Updates

Compile Dependency Updates

• Updated com.exasol:error-reporting-java:0.2.2 to 0.4.1
• Updated com.exasol:virtual-schema-common-jdbc:9.0.1 to 9.0.4

Test Dependency Updates

• Updated org.junit.jupiter:junit-jupiter:5.7.0 to 5.8.1
• Updated org.mockito:mockito-junit-jupiter:3.7.7 to 4.1.0

Plugin Dependency Updates

• Updated com.exasol:artifact-reference-checker-maven-plugin:0.3.1 to 0.4.0
• Added com.exasol:error-code-crawler-maven-plugin:0.1.1
• Updated com.exasol:project-keeper-maven-plugin:0.4.2 to 1.3.2
• Added io.github.zlika:reproducible-build-maven-plugin:0.13
• Updated org.apache.maven.plugins:maven-enforcer-plugin:3.0.0-M3 to 3.0.0
• Updated org.apache.maven.plugins:maven-jar-plugin:2.4 to 3.2.0
• Updated org.apache.maven.plugins:maven-surefire-plugin:3.0.0-M3 to 3.0.0-M5
• Updated org.codehaus.mojo:versions-maven-plugin:2.7 to 2.8.1
• Updated org.jacoco:jacoco-maven-plugin:0.8.5 to 0.8.7

Removed SQL_DIALECT property, fixed String datatypes mapping and mapping for literal boolean

Summary

The SQL_DIALECT property used when executing a CREATE VIRTUAL SCHEMA from the Exasol database is obsolete from this version. Please, do not provide this property anymore.

Bug Fixes

• #17: Fixed mapping for literal boolean.
• #6: Fixed mapping for String datatypes.

Dependence Updates

Runtime Dependencies

• Updated com.exasol:virtual-schema-common-jdbc:9.0.0 to 9.0.1

Restricted the amount of mapped tables to 1000 and fixed SELECT * with unsupported data types behavior

Summary

This release includes the following changes from the updated common libraries:

• Restricted the amount of mapped tables in the remote schema to 1000;
• Fixed the problem with SELECT * and unsupported data types;

Refactoring

• #18: Updated to the latest virtual-schema-common-jdbc.
• #13: Changed the deprecated ${version} property to ${project.version}.
• #11: Added ExaError builder.

Dependence Updates

Runtime Dependencies

• Updated com.exasol:virtual-schema-common-jdbc:7.0.0 to 9.0.0
• Updated com.exasol:error-reporting-java:0.2.0 to 0.2.2

Test Dependencies

• Updated org.mockito:mockito-junit-jupiter:3.6.0 to 3.7.7
• Removed com.exasol:test-db-builder-java:2.0.0
• Removed org.testcontainers:junit-jupiter:1.15.0
• Removed com.exasol:exasol-testcontainers:3.3.1
• Removed com.exasol:hamcrest-resultset-matcher:1.2.1

Plugin Dependencies

• Updated com.exasol:project-keeper-maven-plugin:0.4.1 to 0.4.2
• Removed org.jacoco.agent:org.jacoco:0.8.5
• Removed org.apache.maven.plugins:maven-failsafe-plugin:3.0.0-M3

Migration from the virtual-schemas repository

Features

• #1: Extracted this dialect from virtual-schemas repository