Win a copy of Java 9 Modularity: Patterns and Practices for Developing Maintainable Applications this week in the Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

reverse engineering /w Middlegen across multiple schemas  RSS feed

Jeevan Sunkersett
Ranch Hand
Posts: 78
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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.

  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!