SNOW-261996: error when trying to connect in read-only mode

[scollovati]

trafficstars

Hi, some database clients allow to connect in read-only mode from their UI.

If you set that value to True, the JDBC driver is unable to connect to Snowflake with this error: net.snowflake.client.jdbc.SnowflakeLoggedFeatureNotSupportedException

Driver version: 3.12.17

[mlunax]

The problem still exist :(

[ryanrupp]

This was changed/fixed in 3.13.21 (edit - 3.13.16, see linked commit) to ignore calls to setReadOnly (and just debug log that it's not supported). See https://github.com/snowflakedb/snowflake-jdbc/pull/885 and https://github.com/snowflakedb/snowflake-jdbc/commit/ed2f855a83ccae3f0609ae16004852af29e4e552

[sfc-gh-wfateem]

I'm going to close this off because this is an outdated issue that has been addressed already. I actually see the change in v3.13.16. If this is still failing for you on a newer JDBC driver release, then please let us know.

The issue here is the failure that occurs when calling the setReadOnly() method. The JDBC specifications simply mention that this is nothing more than a "hint," so it's valid to ignore the option. If you have the need for a different implementation, then please feel free to open up another issue outlining your use case and why a new implementation is needed for the setReadOnly method. We'll be happy to discuss that with you.