Using CONNECT JDBC with a Postgres database that has UUID seems impossible right now.
I've tried mapping them to VARCHAR(36) and BINARY(16) but can't seem to get any valid data back. The JDBC driver sees this a type OTHER data_type number 1111.
Any ideas? Unfortunately we have a customer where the entire DB is setup around UUIDs.