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
4063 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Integrations
If I already have an existing Oracle sequence, and need to create the XSD to ref
mjmallet
over 9 years ago
If I already have an existing Oracle sequence, and need to create the XSD to reflect that .. what is the correct syntax to use for @SequenceGenerator and @GeneratedValue? I tried different combination and it still wasn't finding my sequence, I had to create from what the DDL was asking (ORGANIZATION_SQ), since this was a test it is not so bad, but down the road if I need to connect to one that already exist.
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
@Id
@Column(name="ORG_ID")
@SequenceGenerator(name="ORGANIZATION_SEQUENCE", initialValue=196)
@GeneratedValue(strategy=GenerationType.SEQUENCE,generator="ORGANIZATION_SEQUENCE")
</xsd:appinfo>
</xsd:annotation>
OriginalPostID-149734
OriginalPostID-149734
Discussion posts and replies are publicly visible
Parents
0
rodgraham
Certified Lead Developer
over 9 years ago
Try adding sequenceName="ORGANIZATION_SEQUENCE" into your SequenceGenerator
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
rodgraham
Certified Lead Developer
over 9 years ago
Try adding sequenceName="ORGANIZATION_SEQUENCE" into your SequenceGenerator
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data