When I import the attached schema to create a data type, and then verify mapping

When I import the attached schema to create a data type, and then verify mapping in a Data Entity, that works fine. However, when I try to query the table using a QueryEntity, I get an error ORA-00942 table or view does not exist. I think it is because the user that is connecting to the database is not the schema owner of the table I am trying to query. I tried adding the schema name into the @Table annotation, either this way, @Table(name="BPMS_AUTH_HISTORY", schema="ESOA"), or this way, @Table(name="ESOA.BPMS_AUTH_HISTORY"), but then when I try to verify mappings in the Data Entity, I get a mapping error that the table cannot be found. Is there a way to make this work in the annotation? Or is the only option to create a synonym for the database table? This is an Oracle database.

LoginAuthHistory.xsd

OriginalPostID-143965

OriginalPostID-143965

  Discussion posts and replies are publicly visible