hi all, does anyone know if clojure.java.jdbc can return an array type for an h2 database? i'm having some trouble when i run a query and i expect to get an array type for a column, but am getting a clob (here's the question fleshed out in more detail: https://stackoverflow.com/questions/53745570/doing-a-jdbc-query-on-a-h2-view-with-array-agg-returns-a-clob-type-not-an-array)

You'll probably have to extend one of the protocols to do the conversion.

i see, will try that; thanks!

hi sean, just to check: i was going to follow this stack overflow post but is this what you had in mind by extending the protocol? https://stackoverflow.com/questions/19103870/jsonify-a-jdbc4array-in-clojure

Something like that, yeah.

http://clojure-doc.org/articles/ecosystem/java_jdbc/using_sql.html#protocol-extensions-for-transforming-values

In next.jdbc, this will be a lot easier. Partly because you'll be able to specify protocol extensions on the fly for specific columns. Which will require Clojure 1.10.

(and it will also have built-in datafy/`nav` support)

thank you!