Java Snowflake ResultSet type 1004 is not supported
- 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
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