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 kevind605 over 11 years ago

...
@Id
</xs:appinfo>
</xs:annotation>
<xs:simpleType>
<xs:restriction base="xs:long">
<xs:minInclusive value="-9223372036854775808"/>
<xs:maxInclusive value="9223372036854775807"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="acknak" default="2">
<xs:simpleType>
<xs:restriction base="xs:byte">
<xs:minInclusive value="-128"/>
<xs:maxInclusive value="127"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="msg">
<xs:simpleType>
<xs:restriction base="xs:base64Binary">
<xs:maxLength value="2147483647"/>
<xs:minLength value="1"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="filename" nillable="true" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="msgstate" default="1">
<xs:simpleType>
<xs:restriction base="xs:byte">
<xs:minInclusive value="-128"/>
<xs:maxInclusive v...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 kevind605 over 11 years ago

...
@Id
</xs:appinfo>
</xs:annotation>
<xs:simpleType>
<xs:restriction base="xs:long">
<xs:minInclusive value="-9223372036854775808"/>
<xs:maxInclusive value="9223372036854775807"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="acknak" default="2">
<xs:simpleType>
<xs:restriction base="xs:byte">
<xs:minInclusive value="-128"/>
<xs:maxInclusive value="127"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="msg">
<xs:simpleType>
<xs:restriction base="xs:base64Binary">
<xs:maxLength value="2147483647"/>
<xs:minLength value="1"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="filename" nillable="true" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="250"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="msgstate" default="1">
<xs:simpleType>
<xs:restriction base="xs:byte">
<xs:minInclusive value="-128"/>
<xs:maxInclusive v...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data