Column definition mapping 'uniqueidentifier '

SQL server database column (not row in above post)

Hello Ajinkya, If you are fetching the data from SQL Server DB, then can use string as shown in below format: <xsd:element name="ProjectId" nillable="true" type="xsd:string">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
                              @Column(name = "ProjectId" columnDefinition="uniqueidentifier")
                    </xsd:appinfo>
</xsd:annotation>
</xsd:element>

Regards,
Vinit.

Hi Vinit ,
I am trying to insert data in Session table. In Session table, we have many columns out of which GuId is one of the column with the data type uniqueidentifier . This column gets auto-populated from a database.
I am able to verify mapping successfully with above changes that you suggested . But when I try to write session data in database 'Wtite to data store' smart service throws below error.

could not load an entity: [DsReportSessionDT37737#]:
com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when
converting from a character string to uniqueidentifier.

@Ajinkya Bendre....AFAIK We cannot make string datatype as uniqueidentifier...

As for the above error i could understand that you are using a string datatype as a unique identifier..

@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

Ajinkya, If the column is autogenerated, then i believe we cannot insert in that column. But if the column is not auto generated, then i believe we can insert data, i have done it before using executesql function. Let me check if i have that code snippet,,,,, I will share it with you shortly.

Hi ajinkyab277,
please refer to the forum link. This may help you.
forum.appian.com/.../Custom_Data_Types_from_XSD.html

Hello Ajinkya, Below is the code snippet, I was able to insert value from Appian to Unique Identifier of MS SQL:

executequery(cons!DATABASE, "INSERT INTO Employoee (
AttachmentId,
RequestId,
CustomerId,
)
VALUES (
NEWID(),
CONVERT(uniqueidentifier,'"&ri!RequestId&"'),
CONVERT(uniqueidentifier,'"&ri!CustomerId&"')
)")
Where both rule inputs are of type text, passed from a process model to this rule.