Unable to access table without synonyms

himanshun over 8 years ago

Hi All,

Is there any way to map xsd to existing table without creating synonyms? We tried giving <schema name>.<table name> in XSD but it gives error.

Below is the error we are getting.
The data source schema does not match the type mappings: Missing table: <SCHEMA_NAME>.<TABLE_NAME> (APNX-2-4056-000)

The user is having grants for this table.

Thanks is advance.

Regards,
Himanshu

Discussion posts and replies are publicly visible

Parents

0 mayureshs7821 over 8 years ago

@himanshun as per my understanding we no need to use schema name in xsd file. Can you try with below xsd configuration
<xsd:annotation>
<xsd:appinfo source="appian.jpa">@Table(name="your table name same as in DB")</xsd:appinfo>
</xsd:annotation>
hope this helps you.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 mayureshs7821 over 8 years ago

@himanshun as per my understanding we no need to use schema name in xsd file. Can you try with below xsd configuration
<xsd:annotation>
<xsd:appinfo source="appian.jpa">@Table(name="your table name same as in DB")</xsd:appinfo>
</xsd:annotation>
hope this helps you.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data