Hello. Please, provide a complete test case.
ARRAY_AGG() in H2 returns an ARRAY value that can be read from a result set with (Object[]) ResultSet.getArray(…).getArray() or with (Object[]) ResultSet.getObject(…) If you got a Clob somehow (for example, using ResultSet.getClob(…) or by accident selection of a wrong column that has CLOB data type) there is nothing to do with it, java.sql.Clob cannot be casted to an array. -- 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.
