I have the following Oracle Database Table: CREATE TABLE APP_POSIT

davidj578 over 8 years ago

I have the following Oracle Database Table:

CREATE TABLE APP_POSIT_INFO (
POSIT_ID VARCHAR2(50),
LATITUDE DECIMAL,
LONGITUDE DECIMAL
);

While I have a form where a User can enter this data and I have created a CDT and Data Store and I can write to the Data Store inside a BPM it's not clear how to map the data in the Data Store to the Table APP_POSIT_INFO. Please let me know how best to do this. I have been working with the Forum "Write to Data Store Entity" but it is not clear what needs to be done. Thanks in advance.

Discussion posts and replies are publicly visible

0 Tessy over 8 years ago

Is your CDT xsd mapped to the database fields and table?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tessy over 8 years ago

Can you please post your XSD?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Carlos Santander
A Score Level 2
over 8 years ago

David, it seems like you need some annotations in your CDT. Check forum.appian.com/.../Custom_Data_Types_from_XSD.html for an overview of the JPA annotations you can use.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 davidj578 over 8 years ago

Hi Carloss and Theresaa - I can't get Appian to map to any tables it hasn't auto generated. Is a primary key id required as an addition to my existing tables? If not, the syntax for getting Appian to identify the table appears to be incorrect.

<xsd:complexType name="cdtXSD">
<xsd:annotation>
<xsd:appinfo source="oracleDB">
@Table(name="tableName")
</xsd:appinfo>
</xsd:annotation>

It appears to be taking the <xsd:complexType name="cdtXSD"> as the table name and ignoring @Table(name="tableName").

It gives the following error:

The data source schema does not match the type mappings: Missing table: cdtXSD (APNX-2-4056-000)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Carlos Santander
A Score Level 2
over 8 years ago

Did you actually change the xsd:appinfo line? As per the documentation, it should be <xsd:appinfo source="appian.jpa">
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tom Ryan
Appian Employee
over 8 years ago

Hi David, as specified here forum.appian.com/.../Custom_Data_Types_from_XSD.html names are automatically formatted to lowercase unless you use an explicit name tag. If the lowercase schema attribute value doesn't match the casing of the schema in Oracle, the entity for the data store won't map correctly. To solve this problem use the @Column(name="columnName") annotations.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel