[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3579) Support for PostgreSQL UUID data type

[David Driscoll (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3579?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=37252#action_37252 ] 

David Driscoll commented on HHH-3579:
-------------------------------------

Types.OTHER fully qualified is java.sql.types. So unfortunately, we can't add Types.UUID, unless the folks at Sun let us.
Java.sql.types does not contain an uuid constant, and java.sql.types.OTHER is a bit of a catch all.
The object java.util.UUID is a 128 bit value. But, we could create our a static integer constant to avoid using Types.OTHER.
I tested this approach by creating : public static final int UUID_CONST = 128, and update another 2 lines of code,
and then ran thru my unit tests successfully. Both PostgresSQLDialect.java and UuidType.java will need to reference this
constant, so would Hibernate.java be the appropriate place for this constant ? Let me know. Regards, Dave.

> Support for PostgreSQL UUID data type
> -------------------------------------
>
>                 Key: HHH-3579
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3579
>             Project: Hibernate Core
>          Issue Type: New Feature
>          Components: core
>    Affects Versions: 3.3.1
>            Reporter: Olivier Van Acker
>            Assignee: Steve Ebersole
>             Fix For: 3.6
>
>         Attachments: patch_HH_3579_Hibernate.txt, patch_HH_3579_NullableType.txt, patch_HH_3579_PostgresSQLDialect.txt, patch_HH_3579_TypeFactory.txt, patch_HH_3579_UuidType.txt
>
>
> PostgreSQL has since version 8.3 UUID as data type nativly supported in the database. 
> The only way to get this to work in Hibernate is to add <column name="id" sql-type="uuid"/> to your mappings file (or @columnDefinition via annotations)
> and create your own custom usertype (e.g. public class UUIDUserType implements UserType, Serializable {..} ) and map this to java.util.UUID 
> worth mentioning is that java.util.UUID is only introduced in java 1.5 so there might be a backwards compatibility problem
>  

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira