I'm having a terrible time getting Cayenne to properly handle columns of type uniqueidentifier. I can select data from columns which are type uniqueidentifier, but I can not insert. I've tried different combinations of Java type String versus Java type UUID and Types.VARCHAR versus Types.OTHER.
Please help if you can! Thanks!