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


Reply via email to