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
Reply
  • 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
Children