postgresql jdbc driver doest not support primitive array of uuids
static {
ARRAY_CLASS_TO_SUPPORT.put(long[].class, LONG_ARRAY);
ARRAY_CLASS_TO_SUPPORT.put(int[].class, INT_ARRAY);
ARRAY_CLASS_TO_SUPPORT.put(short[].class, SHORT_ARRAY);
ARRAY_CLASS_TO_SUPPORT.put(double[].class, DOUBLE_ARRAY);
ARRAY_CLASS_TO_SUPPORT.put(float[].class, FLOAT_ARRAY);
ARRAY_CLASS_TO_SUPPORT.put(boolean[].class, BOOLEAN_ARRAY);
ARRAY_CLASS_TO_SUPPORT.put(String[].class, STRING_ARRAY);
}
but that works
(let [ua (into-array String ["a1dfa22e-bce4-4ef0-979f-d64315c88ce5"])]
(with-open [c (get-connection ...)]
(jdbc/execute! c ["select * from uuid_test where u = ANY(?::uuid[])" ua])))
thanks, looks better, than mine solution
just for my curiosity. Do you know why JDBC doesn’t support UUIDs array @maxp?