[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3579) Support for PostgreSQL UUID data type
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3579?page=c...
]
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira