Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
13 replies
Subscribers
9 subscribers
Views
4982 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Administration
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">...
OriginalPostID-63807
OriginalPostID-63807
Discussion posts and replies are publicly visible
Parents
0
Eduardo Fuentes
Appian Employee
over 10 years ago
What is the value of the type="" attribute in the xs:element of your field? In the example below it's xs:string
<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 10 years ago
What is the value of the type="" attribute in the xs:element of your field? In the example below it's xs:string
<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