how to set sql-type with annotations

nelsonhh · **Joined:** Thu Sep 08, 2005 2:14 pm **Posts:** 7

annotations 3.1 beta6
hibernate 3.1 rc2

Hi,

I try to use the native sql-type uniqueidentifier of ms sql server as id with annotations.
I am able to generate the correct guid in the required format:

Code:

   @Id(generator="system-guid")
   @GenericGenerator(name="system-guid", strategy ="guid")
   public String getId(){
      return this.id;
   }
   protected void setId(String id) {
      this.id = id;
   }

But the column type in the table defnition of the database is varchar instead of uniqueidentifier.

Is there a way to force hibernate to use uniqueidentifier as column type?
Something like the sql-type property for annotations?

Thanks in advance

Nils

emmanuel · **Posted:** Wed Oct 26, 2005 5:42 am

@Type
let me know if it works fine on id property

nelsonhh · **Joined:** Thu Sep 08, 2005 2:14 pm **Posts:** 7

Dear Emmanuel,

from what I unnderstood from the docs,
@Type is used for custom user type declaration. But I just need my String be mapped to the uniqueidentifier SQL-Type.

In xml mapping files I could define something like:

Code:

<property name="someGuid" type="string">
    <column name="someGuid" sql-type="uniqueidentifier"/>
</property>

Could you please give me an example how an equivalent @Type def should look like, if I want a custom sql-type="uniqueidentifier".
I searched and read through the docs, queried the forum, but could not found any example.

best regards

Nils

emmanuel · **Posted:** Wed Oct 26, 2005 4:24 pm

oups, wrong answer.
use @Column(columnDefinition="...")