reverse engineering /w Middlegen across multiple schemas

[Jeevan Sunkersett]

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 appname="org.ultimania.model" schema="COMMON">
		<hibernate version=" />
			<table name="BANK_TAB" />
			<table name="MYMODULE.MY_MODULE_TAB"/>   ..... //error for this entry
	...
	</middlegen>

..... middlegen throws an error table MYMODULE.MY_MODULE_TAB not found


If I separate out using to 2 middlegen tasks

	<middlegen appname="org.ultimania.model" schema="COMMON">
		<hibernate version=" />
			<table name="BANK_TAB" />
	</middlegen 
	<middlegen appname="org.ultimania.model" schema="MYMODULE">
		<hibernate version=" />
			<table name="MY_MODULE_TAB"/>   ..... //warning for this entry
	...
	</middlegen 

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