• State Suggested Answer
  • Replies 7 replies
  • Answers 2 answers
  • Subscribers 12 subscribers
  • Views 7693 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Data and Records

Process model and script task

erics171

Hi, 

I have a process model with 2 save to data store entity. In the process, I save to my first CDT, and that works fine. As the process moves on to save in the second CDT, it also works, however, it does not auto-generate an ID. In the database I see an a-id.

What might I be doing wrong?

Many thanks, 

Eric

  Discussion posts and replies are publicly visible

Parents
  • 0
    Hi Eric,

    The default behavior of Appian is that if there is no primary key defined in a CDT, while publishing the data store and creating a table, an extra column with the name a_id would be created in the DB. In order to avoid this, please make a column as primary key.
    Also to auto-generate, use @GeneratedValue annotation in the xsd of CDT.

    Thanks,
    Hema
Reply
  • 0
    Hi Eric,

    The default behavior of Appian is that if there is no primary key defined in a CDT, while publishing the data store and creating a table, an extra column with the name a_id would be created in the DB. In order to avoid this, please make a column as primary key.
    Also to auto-generate, use @GeneratedValue annotation in the xsd of CDT.

    Thanks,
    Hema
Children
No Data

© 2024 Appian. All rights reserved.