Hi,
Reverse engineering my Oracle database with Middlegen, works fine for me.
However I have the following requirements, for which middlegen gives errors/ warnings
We are developing an enterprise solution, having multiple modules.
My DBA did a re-org of the database.
So we now have a
Common schema (holding all common tables) referred to by all modules
and individual schemas to hold tables of individual modules.
Now for "MY-module" we have a schema "
MYMODULE" with a table
MY_MODULE_TAB,
which has a foreign key relation with a common table in common schema say
BANK_TAB
How do we specify such details to the middlegen
ant task?
The middlegen ant task accepts userID, password and schema amongst other parameters.
followed by a list of Table names that need to be reverse engineered.
But it cannot accept a table name with schema name as classifier.
..... middlegen throws an error table MYMODULE.MY_MODULE_TAB not found
If I separate out using to 2 middlegen tasks
middlegen throws a warning;
Found a relation between MY_MODULE_TAB and BANK_TAB. Skipping it since BANK_TAB isn't among the specified tables.
Has anobody faced this scenario.
Any clues will be appreciated.
~g1