Hi All, here's an issue I have with a MySQL database table name. I have a ta

kevind605 over 11 years ago

Hi All, here's an issue I have with a MySQL database table name. I have a table called msg_in defined in the database. I added the JPA annotation in my xsd but Appian is still doing something weird with the table name. The error says: "The data source schema does not match the type mappings: Missing table: msgintype_msg (APNX-2-4056-000)".

Here's the entire xsd for the table in question. Most of this was generated by XMLSpy. The only stuff I added were the target namespace and the couple of JPA annotations.

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:miemonitor="www.questdiagnostics.com" xmlns:xs="www.w3.org/.../XMLSchema" targetNamespace="www.questdiagnostics.com">
<xs:complexType name="msg_in">
<xs:annotation>
<xs:appinfo source="appian.jpa">
@Table(name="msg_in")
</xs:appinfo>
</xs:annotation>
<xs:sequence>
<xs:element name="msgkey">
<xs:annotation>
<xs:appinfo source="appian.jpa">...

Discussion posts and replies are publicly visible

Parents

0 Eduardo Fuentes
Appian Employee
over 11 years ago

If you don't want the extra table change the type to xs:string and add an annotation to indicate the data type of this column in the table, for instance, the following syntax allowed me to get rid of the extra table when using your XSD to test:

<xs:element name="msg" type="xs:string">
           <xs:annotation>
<xs:appinfo source="appian.jpa">
@Column(columnDefinition="BLOB")
</xs:appinfo>
</xs:annotation>
           </xs:element>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Eduardo Fuentes
Appian Employee
over 11 years ago

If you don't want the extra table change the type to xs:string and add an annotation to indicate the data type of this column in the table, for instance, the following syntax allowed me to get rid of the extra table when using your XSD to test:

<xs:element name="msg" type="xs:string">
           <xs:annotation>
<xs:appinfo source="appian.jpa">
@Column(columnDefinition="BLOB")
</xs:appinfo>
</xs:annotation>
           </xs:element>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data