title: doing a jdbc query on a h2 view with array_agg returns a clob type not an array type?
body: <p>I have a h2 database and am trying to create a view with a column that uses array_agg on some text columns:</p>
  
  <pre><code>create view full as 
  select av.*, at.tag from anno_v av 
  left join
  (select id, array_agg(tags) as tag from anno_t group by id) at 
  on at.id = av.id
  </code></pre>
  
  <p>I'm using clojure's java.jdbc 0.7.0 library to query the result set, and am trying to convert the array type to a clojure vector using the :row-fn option (per this <a href="https://github.com/clojure/java.jdbc/tree/java.jdbc-0.7.0#example-usage" rel="nofollow noreferrer">example</a>) when I do</p>
  
  <pre><code>(jdbc/query db ["SELECT * FROM full"] {:row-fn my-parser})
  </code></pre>
  
  <p>where </p>
  
  <pre><code>(defn my-parser [row] (assoc row :tag (vec (.getArray (:tag row)))))
  </code></pre>
  
  <p>I get the error message <code>IllegalArgumentException No matching field found: getArray for class org.h2.jdbc.JdbcClob  clojure.lang.Reflector.getInstanceField (Reflector.java:271)</code></p>
  
  <p>The same query works on my postgres implementation of the view (same sql syntax to create the view, same clojure code). Does anyone know why the array column is being converted to a clob and how I can get it back to an array? I saw <a href="https://docs.oracle.com/javase/tutorial/jdbc/basics/array.html" rel="nofollow noreferrer">this comment</a> saying the jdbc array type is not supported for java dbs, but wasn't sure if that applied to my case.</p>
  
  <p>thanks!</p>