duckdb / duckdb/duckdb-java

Using the global `TimeZone` config in the `Properties` object passed to `DriverManager.getConnection` fails with error: "The following options were not recognized: TimeZone"

Open
#417 5 comments 0 reactions 0 assignees View on GitHub
Dominant language
C++
Stars
127
Forks
80
Avg merge
13h 49m
Merged PRs (30d)
48

Description

This error seems counter-intuitive as this config is documented as global: https://duckdb.org/docs/stable/configuration/overview.html#global-configuration-options

Shouldn't this `Properties` object allow us to configure the global timezone of our statements?

Reproducer (scala code):
```scala
val config = new Properties()
config.put("TimeZone", "UTC")
DriverManager.getConnection(url, config).unwrap(classOf[DuckDBConnection])
```

Error:
```java
java.sql.SQLException: Invalid Input Error: The following options were not recognized: TimeZone
at org.duckdb.DuckDBNative.duckdb_jdbc_startup(Native Method)
at org.duckdb.DuckDBConnection.newConnection(DuckDBConnection.java:62)
at org.duckdb.DuckDBDriver.connect(DuckDBDriver.java:114)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:683)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:191)
...
```

cc @guizmaii

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.