Column definition mapping 'uniqueidentifier '

Certified Lead Developer
Is there any by which I can map Sql server database row with data type 'uniqueidentifier ' with appian column.

OriginalPostID-245193

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer
    @Ajinkya Bendre, as per my Understanding You can define String Data Type as uniqueIdentifier as i already have used it earlier, as shown below:-
    ===========================================================================



    @Id
    @Column(name="EmployeeID",columnDefinition="VARCHAR(255)")



    ===========================================================================

    But in this case we cannot treat this column to be Auto Generated (i.e. @GeneratedValue), as Integer Type, in Such Cases you need to provide Unique values for that column such as Email ID, Organization Employee ID etc....

    Hope this will Help You
  • 0
    Certified Lead Developer
    in reply to aloks0189

    I think @GeneratedValue must be an INTEGER. Having GUID as auto generated value is logically incorrect. DB won't be able to generate next value on it's own.

Reply Children
No Data