Re: UUID column type in PostgreSQL

[Lukas Eder]

> My team have problem with fetching data from tables containing uuid column
> type? Does that data type is support by Jooq or how implement fetching data
> to string type?

More formal support for UUID types is on the roadmap:
https://github.com/jOOQ/jOOQ/issues/1624

Currently, I suggest you have this type treated as VARCHAR / String.
What type of problems are you running into?

Cheers
Lukas

[Lukas Eder]

Hello,

Already today, you can use org.jooq.Converter types to convert some of
your database columns to UUID's. Please consider the relevant sections
of the manual for this:

Runtime conversion
http://www.jooq.org/doc/2.6/manual/sql-execution/fetching/data-type-conversion/

Code-generation time conversion
http://www.jooq.org/doc/2.6/manual/code-generation/custom-data-types/

Formal UUID support for Postgres, SQL Server and some other databases
that natively support such a type is on the roadmap:
https://github.com/jOOQ/jOOQ/issues/1624

Cheers
Lukas

2012/12/26 adela <ad...@oax.com>:
> I am also trying to use UUID (as Primary Key) in PostgreSQL DB. It would be
> nice to have native java.util.UUID support
> (via JOOQ) for many reasons such as type safety, performance,...and less
> code trying to convert/validate UUID correctness to/from DB....

[adela]

Lukas,

You are awesome!  Keep up the good work!  Thank you...That would be really nice to have in today's distributed environments!

[Lukas Eder]

It seems that the Postgres JDBC driver natively supports java.util.UUID through ResultSet.getObject() and PreparedStatement.setObject(). Adding support seems as simple as adding an org.jooq.impl.SQLDataType.UUID that maps the "uuid" type name to the java.util.UUID class.

This will be implemented in jOOQ 3.0 and has a high chance of being backported to 2.7. I will see if UUID types can be supported for all databases through jOOQ's internal type mapping

Cheers

Lukas

2012/12/29 adela <ad...@oax.com>

[Lukas Eder]

UUID support is implemented on github master. These databases have native support for such a type:

- H2 UUID data type: http://www.h2database.com/html/datatypes.html#uuid_type

- Postgres UUID data type: http://www.postgresql.org/docs/9.2/static/datatype-uuid.html

- SQL Server uniqueidentifier data type: http://msdn.microsoft.com/en-us/library/ms187942

- Sybase SQL Anywhere also supports it

In other databases, jOOQ allows for mapping the java.util.UUID type to a CHAR/VARCHAR columns. Implementations that map UUIDs to BINARY(16) can be achieved through custom data types using Converters

Cheers

Lukas

2013/1/5 Lukas Eder <lukas...@gmail.com>

[adela]

Very nice Lukas!  I will check out!

[Lukas Eder]

> Very nice Lukas! I will check out!

Note, I have just now published an updated SNAPSHOT on the sonatype
snapshot repository:
https://oss.sonatype.org/content/repositories/snapshots/org/jooq/

Cheers
Lukas