search

exasol / script-languages-release

Release Repository for Script Language Container for user defined functions (UDF's) that can be used in the EXASOL database.
https://docs.exasol.com/database_concepts/udf_scripts.htm
GNU General Public License v3.0
9 stars 5 forks source link

Investigate support of Java8 java.time* classes #539

Open tomuben opened 2 years ago

tomuben commented 2 years ago

Background

The implementation of the java.sql.Timestamp causes some confusion today, because this class might contain a timezone (extends java.util.Date). The timezone is implicitly set in the udf client and depends of the timezone set on the DB node.

The Java 8 java.time.Instant and java.time.LocalDateTime come without a timezone and would match the Exasol DB TIMESTAMP type. java.time.ZonedDateTime would be the best match for Exasol DATE.

Acceptance Criteria

Investigate and implement support for

tomuben commented 2 years ago

timezone

tomuben commented 2 years ago
  1. Also need to investigate if we should change behavior of old classes. This would mean a breaking change for customers.
  2. Need to involve core-db here. We would need to pass the TZ info to the UDF client from the Database.