[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3579) Support for PostgreSQL UUID data type
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3579?page=c...
]
Steve Ebersole commented on HHH-3579:
-------------------------------------
mapping it to OTHER is an issue when doing schema export. The way your classes are right
now, any Type reporting OTHER As it's SQL type will be created as UUID. Really OTHER
is worthless in terms of export so in that sense it's arguable to go ahead and allow
it. My preference though is that whenever we are talking about a specific database
datatype we use the type code given that datatype by the database vendor.
That being said, I think (1) the code constant should go on the dialect (this is all
specific to postgresql after all) and (2) we will need 2 types (one specific to postgresql
and mapping to it's uuid datatype, another generic one mapping to char)
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