Java Snowflake ResultSet type 1004 is not supported

[jaceksan]

What would you like help with?

Connecting to Snowflake with Arrow ADBC from Java.

final Map<String, Object> 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?

[lidavidm]

Ideally we'd provide JNI bindings so you could take advantage of the Go-based driver.

In the meantime we need to update to specify the right options, apparently.