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

Nope I don't have any other datastore entities that map to any table called msgintype_msg. That table doesn't exist in the database, nor is it in the XSD, nor is there any entity with that name. I have found that Appian requires the JPA annotations to be used for table names in the XSD. If you don't use the JAP annotations, Appian changes the table names in some circumstances. But I am using the JPA annotation to force it to use the correct table name. But it keeps changing the name anyway. It seems to be the underscore in the table name that is causing the issue. But I can't change the table name in the database because it's already in production.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 kevind605 over 11 years ago

Nope I don't have any other datastore entities that map to any table called msgintype_msg. That table doesn't exist in the database, nor is it in the XSD, nor is there any entity with that name. I have found that Appian requires the JPA annotations to be used for table names in the XSD. If you don't use the JAP annotations, Appian changes the table names in some circumstances. But I am using the JPA annotation to force it to use the correct table name. But it keeps changing the name anyway. It seems to be the underscore in the table name that is causing the issue. But I can't change the table name in the database because it's already in production.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data