oracle synonyms

chelaru.viorel · **Joined:** Tue Sep 05, 2006 8:23 am **Posts:** 7

hi all,

i have a problem when trying to reverse engineering from an orale database; it doesn't generate hbm and code from sysnonyms; from tables there's not a problem;i could do a workaround but i want to know if there is possible to reverse engineering from synonyms and how to do that .

thanks,
Viorel

max · **Posted:** Thu Sep 07, 2006 2:49 am

there were issues with synonyms once, don't know if we fixed them yet.

look in jira - patches welcome.

rig · **Joined:** Wed Sep 06, 2006 9:54 am **Posts:** 9

Hi,

max wrote:

there were issues with synonyms once, don't know if we fixed them yet

But why you don't ignore synonyms then? I don't know, how you figure out the tables, but in oracle, just do an

Code:

SELECT * FROM user_tables

or

Code:

SELECT * FROM user_objects WHERE object_type = 'TABLE'

and synonyms staying untouched. I have the same problem and have to delete always all synonyms, before starting reverse engeneering. And we have around 80 synonyms in our db-schema.

reguards,
rig

max · **Posted:** Thu Sep 07, 2006 7:18 pm

you first say you dont get synonyms generated and then afterwards says that i dont ignore synonyms ?

rig · **Joined:** Wed Sep 06, 2006 9:54 am **Posts:** 9

I mean: if hbm2hbmxml is unable to handle (oracle?)-synonyms, why it throws an error while reverse engeneering instead of ignoring them and only consider "real"-tables?

max · **Posted:** Thu Sep 07, 2006 7:42 pm

hbm2hbmxml does not care about synonyms.

it is the reverse engineering that has issues e.g. jdbcconfiguration.

Now you say it reports an error, what is that error ?

rig · **Joined:** Wed Sep 06, 2006 9:54 am **Posts:** 9

Hi,

2 days ago, I configured hbm2hbmxml for reverse engeneering, started it and got an error because of a synonyms (the name of the synonym was contained in the error-message). To avoid these error, I deleted the synoyms in the db and run hbm2hbmxml again and everything works fine.

To show you the error, I recreate the deleted synonyms, run hbm2hbmxml and ... nothing. everything works fine. I changed the db-schema to one only contains synoyms and started hbm2hbmxml again and everythings works fine, too.

Don't know what to do/say :-)

Perhaps the Thread-Starter could post a screenshot - I'm unable

best reguards
rig