Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
5 replies
Subscribers
7 subscribers
Views
1970 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Hi, I am getting an annotation error for one of CDTs wherein its primary ke
vspravin
over 7 years ago
Hi,
I am getting an annotation error for one of CDTs wherein its primary key is using the annotation : @SequenceGenerator.
The error message looks like "A type mapping annotation is invalid: Could not instantiate id generator [entity-name=PRTPlanDT14727] (MappingException) (APNX-2-4055-000) "
So just wanted to confirm whether @SequenceGenerator annotation is supported by MySQL server as i read in one of the earlier forum notes that this annotation is supported only by Oracle and IBM DB2 server. Please confirm.
OriginalPostID-222478
OriginalPostID-222478
Discussion posts and replies are publicly visible
Parents
0
Andrew P Gramann
Certified Lead Developer
over 7 years ago
MySQL does not use sequences for auto-generated primary keys. Instead, you just tell MySQL to set the column as AUTO_INCREMENT. If you let Appian publish the tables, all you need is the annotations that rameshg73 mentioned in his first post.
More about auto-incremented columns in this stackoverflow article:
stackoverflow.com/.../how-do-i-create-a-sequence-in-mysql
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Andrew P Gramann
Certified Lead Developer
over 7 years ago
MySQL does not use sequences for auto-generated primary keys. Instead, you just tell MySQL to set the column as AUTO_INCREMENT. If you let Appian publish the tables, all you need is the annotations that rameshg73 mentioned in his first post.
More about auto-incremented columns in this stackoverflow article:
stackoverflow.com/.../how-do-i-create-a-sequence-in-mysql
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data