apache / apache/arrow-adbc

Java Snowflake ResultSet type 1004 is not supported

Open
#1,621 1 comment 0 reactions 0 assignees View on GitHub
Type: question
Dominant language
C#
Stars
627
Forks
217
Avg merge
22h 22m
Merged PRs (30d)
64

Description

### What would you like help with?

Connecting to Snowflake with Arrow ADBC from Java.
```
final Map parameters = new HashMap<>();
parameters.put(AdbcDriver.PARAM_URI.getKey(), url);
parameters.put(AdbcDriver.PARAM_USERNAME.getKey(), user);
parameters.put(AdbcDriver.PARAM_PASSWORD.getKey(), dbPassword);
adb = new JdbcDriver(bufferAllocator).open(parameters);
ac = adb.connect();
astmt = ac.createStatement();
```
It connects successfully but then createStatement() fails with the following error.
https://community.snowflake.com/s/article/JDBC-Error-ResultSet-type-1004-is-not-supported

Is it already supported?

Contributor guide

Open the contributing guide

Research direction

Reproduce the Java connection using the shown JdbcDriver.open setup and follow the failure at ac.createStatement(). Compare the ResultSet type 1004 error with the linked Snowflake JDBC report to determine whether this is an unsupported feature or a driver bug; done when support status and a reproducible resolution are established.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.