Is it possible to use Oracle Database Synonyms in

2019-08-03 06:42发布

问题:

Using eclipse Dali JPA tools. When I try to create a new Entity from Database, it only tries to pull the table list. It does not list the Synonyms. In my db, all are synonyms. No tables. How do I get the list of Synonyms in this tool?

回答1:

I see you saw my earlier response. So the question remains: Do you see your synonyms in the Data Source Explorer under your database's "Tables" folder? If you do not see them (which I suspect is the case), the problem is with your DTP database "driver"; if you do see them, the problem is with the Dali Entity Generation tool.

Dali is at the mercy of the DTP "driver". That is, Dali sees only the tables reported by the DTP driver. It is up to the driver to determine whether the list of tables includes synonyms that are for tables. You might investigate whether there is a third-party DTP Oracle driver that can do what you need.