Hi, I have a h2 view where one of the columns is an array_agg of various text columns: e.g.
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 When I do a jdbc query on the view (using a clojure wrapper), I get back that the column in question is a JdbcClob type, whereas I would have expected an array type. I gather that perhaps the array data type is not supported for jdbc's java db drivers from the comment here: https://docs.oracle.com/javase/tutorial/jdbc/basics/array.html; however, I was wondering if there was some way I could cast the Clob to an Array when parsing the result set - does anyone know if/how I could do this? as an aside, I know I can do array_agg in Postgres and call .getArray on it, but trying the same steps for the h2 implementation yields: `IllegalArgumentException No matching field found: getArray for class org.h2.jdbc.JdbcClob clojure.lang.Reflector.getInstanceField (Reflector.java:271)` thanks! -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
