This is a current limitation. Cayenne should really be looking at the
fully qualified name of the table, including the schema, but in some
places it doesn't. A workaround would be to enter a fully qualified
name as DbEntity "name", and don't enter anything in the schema field.
Andrus
On Nov 21, 2008, at 11:23 AM, Andreas Pardeike wrote:
On 20 nov 2008, at 23.58, Michael Gentry wrote:
Have you tried having 3 DataMaps? You could put each in a separate
DataMap and I think that would be OK. You'd also need 3 distinct
Java
classes (one for each). Cayenne would want this, anyway, so that it
would know how to route reads/inserts/updates.
I tried multiple datamaps and the modeler still complains. The field
with
the duplicate table name is red and does not save.
The following does not work and I have no clue why:
- DefaultDomain
|
+- domain1_map1
| |
| +- DbEntity: SCHEME1.TEST
|
+- domain1_map2
|
+- DbEntity: SCHEME2.TEST
/Andreas