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 char set 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

• #25: Updated tests to Exasol v8, updated to vsjdbc 12.0.0

2.1.4: Fixed vulnerabilities CVE-2024-25710 and CVE-2024-26308 in test dependencies

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

Security

• #32: Fixed vulnerabilities CVE-2024-25710 and CVE-2024-26308 in test dependency org.apache.commons:commons-compress

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.3
• Updated com.exasol:udf-debugging-java:0.6.11 to 0.6.12
• Updated com.exasol:virtual-schema-common-jdbc:11.0.2 to 12.0.0
• Updated com.ibm.db2:jcc:11.5.8.0 to 11.5.9.0
• Updated org.jacoco:org.jacoco.agent:0.8.10 to 0.8.11
• Updated org.junit.jupiter:junit-jupiter:5.10.0 to 5.10.2
• Updated org.mockito:mockito-junit-jupiter:5.5.0 to 5.11.0
• Updated org.slf4j:slf4j-jdk14:2.0.9 to 2.0.12
• Updated org.testcontainers:db2:1.19.0 to 1.19.7
• Updated org.testcontainers:junit-jupiter:1.19.0 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.3: Fix CVE-2023-42503 in test dependency

Summary

This release fixes CVE-2023-42503 in test dependency org.apache.commons:commons-compress.

Security

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

Refactoring

• #29: Simplified test dependencies

Dependency Updates

Compile Dependency Updates

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

Test Dependency Updates

• Removed com.exasol:exasol-test-setup-abstraction-java:2.0.2
• Added com.exasol:exasol-testcontainers:6.6.2
• Updated com.exasol:hamcrest-resultset-matcher:1.6.0 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.8 to 0.6.11
• Updated com.exasol:virtual-schema-common-jdbc:10.5.0 to 11.0.2
• Updated org.jacoco:org.jacoco.agent:0.8.9 to 0.8.10
• Updated org.junit.jupiter:junit-jupiter:5.9.3 to 5.10.0
• Updated org.mockito:mockito-junit-jupiter:5.4.0 to 5.5.0
• Updated org.slf4j:slf4j-jdk14:2.0.7 to 2.0.9
• Updated org.testcontainers:db2:1.18.3 to 1.19.0
• Updated org.testcontainers:junit-jupiter:1.18.3 to 1.19.0

Plugin Dependency Updates

• Updated com.exasol:error-code-crawler-maven-plugin:1.2.3 to 1.3.0
• Updated com.exasol:project-keeper-maven-plugin:2.9.7 to 2.9.12
• Updated org.apache.maven.plugins:maven-assembly-plugin:3.5.0 to 3.6.0
• Updated org.apache.maven.plugins:maven-enforcer-plugin:3.3.0 to 3.4.0
• Updated org.apache.maven.plugins:maven-failsafe-plugin:3.0.0 to 3.1.2
• Updated org.apache.maven.plugins:maven-surefire-plugin:3.0.0 to 3.1.2
• Updated org.basepom.maven:duplicate-finder-maven-plugin:1.5.1 to 2.0.1
• Updated org.codehaus.mojo:flatten-maven-plugin:1.4.1 to 1.5.0
• Updated org.codehaus.mojo:versions-maven-plugin:2.15.0 to 2.16.0
• Updated org.jacoco:jacoco-maven-plugin:0.8.9 to 0.8.10

2.1.2: Dependency Upgrade

Summary

This release fixes vulnerability CVE-2023-34462 regarding allocation of resources without limits or throttling by updating test dependency io.netty:netty-handler.

Changes

• #26: Updated dependencies

Dependency Updates

Test Dependency Updates

• Updated com.exasol:exasol-test-setup-abstraction-java:2.0.1 to 2.0.2
• Updated org.mockito:mockito-junit-jupiter:5.3.1 to 5.4.0
• Updated org.testcontainers:db2:1.18.0 to 1.18.3
• Updated org.testcontainers:junit-jupiter:1.18.0 to 1.18.3

2.1.1: Update Dependencies on Top of 2.1.0

Summary

This release updates dependency virtual-schema-common-jdbc which adds support for the new adapter property MAX_TABLE_COUNT and fixes ambiguous results by escaping SQL wildcards such as underscore _ and percent % in names of catalogs, schemas, and tables when retrieving column metadata from JDBC driver.

Documentation

• #23: Fixed broken links

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 10.5.0

Test Dependency Updates

• Updated com.exasol:exasol-test-setup-abstraction-java:2.0.0 to 2.0.1
• Updated com.exasol:hamcrest-resultset-matcher:1.5.2 to 1.6.0
• Updated com.exasol:test-db-builder-java:3.4.1 to 3.4.2
• Updated com.exasol:udf-debugging-java:0.6.6 to 0.6.8
• Updated com.exasol:virtual-schema-common-jdbc:10.1.0 to 10.5.0
• Updated org.jacoco:org.jacoco.agent:0.8.8 to 0.8.9
• Updated org.junit.jupiter:junit-jupiter:5.9.2 to 5.9.3
• Updated org.mockito:mockito-junit-jupiter:5.0.0 to 5.3.1
• Added org.slf4j:slf4j-jdk14:2.0.7
• Updated org.testcontainers:db2:1.17.6 to 1.18.0
• Updated org.testcontainers:junit-jupiter:1.17.6 to 1.18.0

Plugin Dependency Updates

• Updated com.exasol:error-code-crawler-maven-plugin:1.2.1 to 1.2.3
• Updated com.exasol:project-keeper-maven-plugin:2.9.1 to 2.9.7
• Updated org.apache.maven.plugins:maven-assembly-plugin:3.4.2 to 3.5.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.3.0
• Updated org.apache.maven.plugins:maven-failsafe-plugin:3.0.0-M7 to 3.0.0
• Updated org.apache.maven.plugins:maven-surefire-plugin:3.0.0-M7 to 3.0.0
• Added org.basepom.maven:duplicate-finder-maven-plugin:1.5.1
• Updated org.codehaus.mojo:flatten-maven-plugin:1.3.0 to 1.4.1
• Updated org.codehaus.mojo:versions-maven-plugin:2.13.0 to 2.15.0
• Updated org.jacoco:jacoco-maven-plugin:0.8.8 to 0.8.9

2.1.0: Enhanced Data Type Detection for Result Sets

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.

The release also improves conversion of DB2 types TIMESTAMP and TIME:

• TIMESTAMP DB2 columns are now converted to TIMESTAMP columns in Exasol, before they had type VARCHAR.
• TIME DB2 columns now use the format HH24:MM:SS, before it was HH24.MM.SS.

Features

• #21: Updated to VSCJDBC 10.1.0

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.5 to 10.1.0

Test Dependency Updates

• Updated com.exasol:exasol-test-setup-abstraction-java:0.3.2 to 2.0.0
• Removed com.exasol:exasol-testcontainers:6.1.2
• Updated com.exasol:hamcrest-resultset-matcher:1.5.1 to 1.5.2
• Updated com.exasol:test-db-builder-java:3.3.3 to 3.4.1
• Updated com.exasol:udf-debugging-java:0.6.3 to 0.6.6
• Updated com.exasol:virtual-schema-common-jdbc:9.0.5 to 10.1.0
• Updated com.ibm.db2:jcc:11.5.7.0 to 11.5.8.0
• Updated org.junit.jupiter:junit-jupiter:5.8.2 to 5.9.2
• Updated org.mockito:mockito-junit-jupiter:4.6.1 to 5.0.0
• Updated org.testcontainers:db2:1.17.2 to 1.17.6
• Updated org.testcontainers:junit-jupiter:1.17.2 to 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:1.1.1 to 1.2.1
• Updated com.exasol:project-keeper-maven-plugin:2.4.6 to 2.9.1
• Updated io.github.zlika:reproducible-build-maven-plugin:0.15 to 0.16
• Updated org.apache.maven.plugins:maven-assembly-plugin:3.3.0 to 3.4.2
• Updated org.apache.maven.plugins:maven-dependency-plugin:3.3.0 to 3.5.0
• Updated org.apache.maven.plugins:maven-enforcer-plugin:3.0.0 to 3.1.0
• Updated org.apache.maven.plugins:maven-failsafe-plugin:3.0.0-M5 to 3.0.0-M7
• Updated org.apache.maven.plugins:maven-jar-plugin:3.2.2 to 3.3.0
• Updated org.apache.maven.plugins:maven-surefire-plugin:3.0.0-M5 to 3.0.0-M7
• Updated org.codehaus.mojo:flatten-maven-plugin:1.2.7 to 1.3.0
• Updated org.codehaus.mojo:versions-maven-plugin:2.10.0 to 2.13.0

2.0.4: Update dependencies

Summary

This release updates dependencies to fix the following vulnerabilities in transitive test dependencies:

• io.netty:netty-common:jar:4.1.72.Final:test
  • CVE-2022-24823
• io.netty:netty-handler:jar:4.1.72.Final:test
  • https://ossindex.sonatype.org/vulnerability/sonatype-2020-0026
• org.apache.xmlrpc:xmlrpc-common:jar:3.1.3:test
  • CVE-2016-5003
  • CVE-2016-5002
• commons-codec:commons-codec:jar:1.11:test
  • https://ossindex.sonatype.org/vulnerability/sonatype-2012-0050
• org.apache.xmlrpc:xmlrpc-client:jar:3.1.3:test
  • CVE-2016-5004

Features

• #19: Updated dependencies

Dependency Updates

Compile Dependency Updates

• Updated com.exasol:virtual-schema-common-jdbc:9.0.4 to 9.0.5

Test Dependency Updates

• Added com.exasol:exasol-test-setup-abstraction-java:0.3.2
• Updated com.exasol:exasol-testcontainers:6.1.1 to 6.1.2
• Updated com.exasol:test-db-builder-java:3.3.2 to 3.3.3
• Updated com.exasol:udf-debugging-java:0.6.1 to 0.6.3
• Updated com.exasol:virtual-schema-common-jdbc:9.0.4 to 9.0.5
• Updated org.mockito:mockito-junit-jupiter:4.5.1 to 4.6.1
• Updated org.testcontainers:db2:1.17.1 to 1.17.2
• Updated org.testcontainers:junit-jupiter:1.17.1 to 1.17.2

Plugin Dependency Updates

• Updated com.exasol:artifact-reference-checker-maven-plugin:0.4.1 to 0.4.0
• Updated com.exasol:project-keeper-maven-plugin:2.3.2 to 2.4.6
• Updated org.apache.maven.plugins:maven-clean-plugin:3.2.0 to 2.5
• Updated org.apache.maven.plugins:maven-deploy-plugin:2.8.2 to 2.7
• Updated org.apache.maven.plugins:maven-failsafe-plugin:3.0.0-M6 to 3.0.0-M5
• Updated org.apache.maven.plugins:maven-install-plugin:2.5.2 to 2.4
• Updated org.apache.maven.plugins:maven-resources-plugin:3.2.0 to 2.6
• Updated org.apache.maven.plugins:maven-site-plugin:3.12.0 to 3.3
• Updated org.apache.maven.plugins:maven-surefire-plugin:3.0.0-M6 to 3.0.0-M5

2.0.3: Upgraded dependencies compared to 2.0.2

Bugfixes

• #17: Upgraded dependencies to fix CVE-2022-21724 in the PostgreSQL JDBC driver.

Dependency Updates

Compile Dependency Updates

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

Runtime Dependency Updates

• Added org.glassfish:jakarta.json:2.0.1

Test Dependency Updates

• Updated com.exasol:exasol-testcontainers:4.0.0 to 6.1.1
• Updated com.exasol:hamcrest-resultset-matcher:1.4.1 to 1.5.1
• Updated com.exasol:test-db-builder-java:3.2.0 to 3.3.2
• Updated com.exasol:udf-debugging-java:0.4.0 to 0.6.1
• Updated com.exasol:virtual-schema-common-jdbc:9.0.3 to 9.0.4
• Updated com.ibm.db2:jcc:11.5.6.0 to 11.5.7.0
• Updated org.jacoco:org.jacoco.agent:0.8.7 to 0.8.8
• Updated org.junit.jupiter:junit-jupiter:5.8.1 to 5.8.2
• Updated org.mockito:mockito-junit-jupiter:4.0.0 to 4.5.1
• Updated org.testcontainers:db2:1.16.2 to 1.17.1
• Updated org.testcontainers:junit-jupiter:1.16.2 to 1.17.1

Plugin Dependency Updates

• Updated com.exasol:artifact-reference-checker-maven-plugin:0.3.1 to 0.4.1
• Updated com.exasol:error-code-crawler-maven-plugin:0.4.0 to 1.1.1
• Updated com.exasol:project-keeper-maven-plugin:1.3.1 to 2.3.2
• Updated io.github.zlika:reproducible-build-maven-plugin:0.13 to 0.15
• Updated org.apache.maven.plugins:maven-clean-plugin:3.1.0 to 3.2.0
• Updated org.apache.maven.plugins:maven-compiler-plugin:3.8.1 to 3.10.1
• Updated org.apache.maven.plugins:maven-dependency-plugin:3.1.2 to 3.3.0
• Updated org.apache.maven.plugins:maven-enforcer-plugin:3.0.0-M3 to 3.0.0
• Updated org.apache.maven.plugins:maven-failsafe-plugin:3.0.0-M3 to 3.0.0-M6
• Updated org.apache.maven.plugins:maven-jar-plugin:3.2.0 to 3.2.2
• Updated org.apache.maven.plugins:maven-site-plugin:3.9.1 to 3.12.0
• Updated org.apache.maven.plugins:maven-surefire-plugin:3.0.0-M3 to 3.0.0-M6
• Added org.codehaus.mojo:flatten-maven-plugin:1.2.7
• Updated org.codehaus.mojo:versions-maven-plugin:2.8.1 to 2.10.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

Fixed non-default schema query bug

Summary

In this release we have fixed a problem when SELECT from a non-default schema returned an exception.

Bug Fixes

• #15: Fixed a problem when SELECT from a non-default schema returned an exception.

Dependency Updates

Runtime Dependency Updates

• Removed org.jacoco:org.jacoco.agent:0.8.7

Test Dependency Updates

• Added org.jacoco:org.jacoco.agent:0.8.7
• Updated org.junit.jupiter:junit-jupiter:5.7.2 to 5.8.1
• Updated org.mockito:mockito-junit-jupiter:3.11.2 to 4.0.0
• Updated org.testcontainers:db2:1.16.0 to 1.16.2
• Updated org.testcontainers:junit-jupiter:1.16.0 to 1.16.2

Plugin Dependency Updates

• Updated com.exasol:error-code-crawler-maven-plugin:0.5.1 to 0.4.0
• Updated com.exasol:project-keeper-maven-plugin:0.10.0 to 1.3.1

Dependency Updates

Summary

In this release we updated the dependencies. By that we fixed transitive CVE-2021-36090.

Dependency Updates

Compile Dependency Updates

• Updated com.exasol:error-reporting-java:0.2.2 to 0.4.0
• Updated com.exasol:virtual-schema-common-jdbc:9.0.2 to 9.0.3

Test Dependency Updates

• Updated com.exasol:exasol-testcontainers:3.5.1 to 4.0.0
• Updated com.exasol:hamcrest-resultset-matcher:1.4.0 to 1.4.1
• Updated com.exasol:test-db-builder-java:3.1.1 to 3.2.0
• Updated com.exasol:udf-debugging-java:0.3.0 to 0.4.0
• Updated com.exasol:virtual-schema-common-jdbc:9.0.2 to 9.0.3
• Updated com.ibm.db2:jcc:11.5.5.0 to 11.5.6.0
• Updated org.junit.jupiter:junit-jupiter:5.7.1 to 5.7.2
• Updated org.mockito:mockito-junit-jupiter:3.9.0 to 3.11.2
• Updated org.testcontainers:db2:1.15.3 to 1.16.0
• Updated org.testcontainers:junit-jupiter:1.15.3 to 1.16.0

Plugin Dependency Updates

• Updated com.exasol:error-code-crawler-maven-plugin:0.4.0 to 0.5.1
• Updated com.exasol:project-keeper-maven-plugin:0.7.0 to 0.10.0