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
5 subscribers
Views
2555 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Integrations
I have a table in Oracle database say "AG_SRV_TRAN_EXT". Created a CDT
kumaraveln
over 9 years ago
I have a table in Oracle database say "AG_SRV_TRAN_EXT". Created a CDT of similar structure,then an entity and when verifiying the mappings i am getting the below error. "The data source schema does not match the type mappings: Missing sequence or table: AG_SRV_TRAN_EXT_sq (APNX-2-4056-000) ".
Attaching the DDL script, XSD and script generated from DB
Note: I already have 2 Entities verified and published in the same data store without any issues.
...
Missing Sequence Err.zip
OriginalPostID-114323
OriginalPostID-114323
Discussion posts and replies are publicly visible
Parents
0
Eduardo Fuentes
Appian Employee
over 9 years ago
If this is an existing table you should already have a sequence that belongs to this table. Since this is Oracle, you can specifiy in your XSD that you want to use an existing sequence. More information at
forum.appian.com/.../e-95347
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
@Id
@SequenceGenerator(name="mysequence", initialValue=1000)
@GeneratedValue(strategy=GenerationType.SEQUENCE, generator="mysequence")
</xsd:appinfo>
</xsd:annotation>
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Eduardo Fuentes
Appian Employee
over 9 years ago
If this is an existing table you should already have a sequence that belongs to this table. Since this is Oracle, you can specifiy in your XSD that you want to use an existing sequence. More information at
forum.appian.com/.../e-95347
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
@Id
@SequenceGenerator(name="mysequence", initialValue=1000)
@GeneratedValue(strategy=GenerationType.SEQUENCE, generator="mysequence")
</xsd:appinfo>
</xsd:annotation>
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data