Skip to main content
H
harshav420
September 3, 2021
Question

Postgres SQL Insertion of data and fetching the data

  • September 3, 2021
  • 8 replies
  • 0 views

Hi All,

We have a postgre SQL DB connected to Appian system. And one of the column is a primary Key and the type of the Primary Key is UUID. However the Type of the UUID column is not compatible with Appian.

In such scenario how to insert the data and how to retreive the data from the database. If anyone has done it in any other way , Please help us in finding out the solution.

Thanks,

Harsha

    8 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    September 3, 2021

    Did you try to map the UUID field to text in the XSD file using JPA annotations?

    H
    harshav420Author
    September 4, 2021

    [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05] ,

    Yes we did. The entity mapping verified. However when we tried the query entity for this DSE, we were getting unexpected error. The error itself is saying unexpected error.

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    September 4, 2021

    Did you check the logfile tomcat stdout? It might show more details.

    Terms & ConditionsAccessibility statement