Using the global `TimeZone` config in the `Properties` object passed to `DriverManager.getConnection` fails with error: "The following options were not recognized: TimeZone"
- 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.