Cannot Execute `SHOW TRANSACTIONS` Statement

[snowflakedb]

Cannot Execute `SHOW TRANSACTIONS` Statement

[KAllan357]

Just an additional note: it appears this is also affecting several other statements I used to be able to execute:

• SHOW WAREHOUSES LIKE ...
• ALTER WAREHOUSE %s RESUME

[howryu]

Hi @KAllan357 Thanks for reporting.

First I am not an expert clojure.java.jdbc. Is this a tool? Or a package on top of JDBC driver.

From the stacktrace it seems that clojure.java.jdbc/db-do-command maps to Java Statement.exeuteBatch() and from Javadoc, it states that executeBatch will throw SQLException if the statement generate a result set. https://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#executeBatch()

And from 3.3.0 we decided to disable PreparedStatement on certain statements type. And right now it only worked for SELECT statement and DML. For DDL and all other statements type, we returned exception now.

Do you know clojure.java.jdbc have api which will use Statement.exeucte()api?
From their doc, it seems that they are using PreparedStatement all the time.

[howryu]

Update:
Just discussed with my colleagues, we decide to catch such exceptions in JDBC. and ignore it. Then you can execute show transactions. Hopefully it will solve your problem.

[KAllan357]

@howryu clojure.java.jdbc is the defacto JDBC library for Clojure and as you saw, they chose to execute prepared statements throughout their code.

Your proposed solution to relax the strictness of executing prepared statements sounds good.

[howryu]

@KAllan357
This is resolved in 45f9506. Release is planned in JDBC v3.4.0 for 30th Nov