I have the following Oracle Database Table: CREATE TABLE APP_POSIT

davidj578 over 9 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

Parents

0 Tom Ryan
Appian Employee
over 9 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

Reply

0 Tom Ryan
Appian Employee
over 9 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

Children

No Data