[Cayenne-user] PostgreSQL custom data type

Hi Chris,

I couldn't find definitive docs on the nature of uniqueidentifier
type (Is there any?) From what little I've found, "uniqueidentifier"
is a binary value. So could you try to map it a Types.VARBINARY on DB
end and "byte[]" on the Java end?

Let us know how that worked.

Andrus

No really good docs. I'm currently using the contrib version of
uniqueidentifier (heavily patched), but there will be a native
uniqueidentifier type in the next release probably not based on the
contrib code.

I think I have this cat skinned... After exhausting all avenues of
getting this to work without any modifications, I broke down and
created and registered a new ExtendedType to process java.util.UUID.
It wasn't difficult at all. (That's a hallmark of a good, extendable,
design and easy to read docs. Kudos to the Cayenne developers!)

First, I'm using the JDBC connection string parameter
"stringtype=unspecified" to leave off the direct casting for quoted
strings. I'm using Types.OTHER when communicating with JDBC.

It has passed my unit tests heretofore.

I'd be happy to make my ExtendedType class available to anyone who
might like to use it.

The only thing missing is the ability to register the ExtendedType in
the XML config, which the docs report is a feature which is planned
for the future.

Very cool. Yeah - if there is a way to read/write a value via JDBC,
Cayenne should be able to accommodate it.

So are you simply using PreparedStatement.setObject(..) and pass
UUID, or you convert UUID to something else (String?) before doing that?
I was thinking of including an ExtendedType for UUID in Cayenne core.
Although I guess we'll have to convert it to a "JDBC primitive" for
DB's other than Postgres. So I guess you can open an improvement
request in Jira and attach your code to it.

Thanks
Andrus