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...

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