duckdb / duckdb/duckdb-java

Attaching DB via URL on Windows leads to "Cannot open file" error

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

Description

When attempting to attach a database via an HTTP URL on Windows, DuckDB seems to interpret the URL as a file and then fails to open it. This issue was introduced between versions 1.2.2.0 and 1.3.0.0. Here is a repo that is able to reproduce the error:

https://github.com/nikammerlaan/duckdb-bug-repro

```
DuckdbBugRepro > test() FAILED
java.sql.SQLException: IO Error: Cannot open file "http://localhost:56144/test-bucket/database.duckdb?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=minioadmin%2F20250712%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250712T203631Z&X-Amz-Expires=3600&X-Amz-SignedHeaders=host&X-Amz-Signature=c90c1d82b5c44409343a9b42f5e451304808d81035f1c1af8ef22cef8f9cb951": The system cannot find the path specified.
at org.duckdb.DuckDBNative.duckdb_jdbc_execute(Native Method)
at org.duckdb.DuckDBPreparedStatement.execute(DuckDBPreparedStatement.java:178)
at org.duckdb.DuckDBPreparedStatement.execute(DuckDBPreparedStatement.java:155)
at org.duckdb.DuckDBPreparedStatement.execute(DuckDBPreparedStatement.java:241)
at DuckdbBugRepro.attachDatabaseFromHttpUrl(DuckdbBugRepro.java:80)
at DuckdbBugRepro.test(DuckdbBugRepro.java:25)
```

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.