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
+1
person also asked this
people also asked this
Replies
15 replies
Subscribers
5 subscribers
Views
5755 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
Hi, I am getting the below error in the process. I have created a CDT
sudhirp804
over 10 years ago
Hi,
I am getting the below error in the process. I have created a CDT with a field name AirlineID as an Number(Integer). It throws an error when it try to store the value in "Write to Store Entity". Please suggest why the CDT integer type value is not able store in the DataStore Entity. Please note the below CDT syntax.
"Details: An error occurred while trying to convert the given data to the type of the specified entity “AirlineDetailMaster” [id=ed3e7773-2bba-4ae6-87af-ded44c76eb95@14330, type=AirlineDetailMaster (id=5170)] (data store: AirTicketManagement). Value that could not be converted: ActivityClassParameter[name=AirlineID,it=1,v=1] Details: com.appiancorp.core.type.TypeCastException: Invalid Cast: Cannot cast from type 'Number (Integer)' to type 'AirlineDetailMaster': CastInvalid "
<xsd:complexType name="AirlineBooking">
<xsd:sequence>
<xsd:element name="AirlineId" type="xsd:int">
<xsd:annotation>
<xsd:appinf...
OriginalPostID-114466
OriginalPostID-114466
Discussion posts and replies are publicly visible
Parents
0
Eduardo Fuentes
Appian Employee
over 10 years ago
Let me clarify a couple of things:
1. Looking at your post in detail it seems you're letting Appian create the tables automatically for you, correct? You're not trying to map to an existing table, are you?
2. The @Id annotation will let Appian know what your primary key is in the table in the database. This is needed if your table already has a primary key or if you want to name your primary key something different from a_id.
3. When setting the primary key @Id you can also let Appian know if you will be manually populating the value or if the column will be of type auto-increment; in which case the @GeneratedValue annotation is needed in addition to @Id.
4. Can you clarify what your specific scenario is after reviewing my statements #1 to #3; once you clarify that please provide the current XSD (most recent version) and the DDL of the table (generate it from the database NOT from Appian)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Eduardo Fuentes
Appian Employee
over 10 years ago
Let me clarify a couple of things:
1. Looking at your post in detail it seems you're letting Appian create the tables automatically for you, correct? You're not trying to map to an existing table, are you?
2. The @Id annotation will let Appian know what your primary key is in the table in the database. This is needed if your table already has a primary key or if you want to name your primary key something different from a_id.
3. When setting the primary key @Id you can also let Appian know if you will be manually populating the value or if the column will be of type auto-increment; in which case the @GeneratedValue annotation is needed in addition to @Id.
4. Can you clarify what your specific scenario is after reviewing my statements #1 to #3; once you clarify that please provide the current XSD (most recent version) and the DDL of the table (generate it from the database NOT from Appian)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data