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.
On Thu, Nov 20, 2008 at 4:16 AM, Andreas Pardeike <a..sys.se> wrote:
> Hi,
>
> I have a project that uses DB2 tables that I don't have control
> over. The problem is that for a specific database entity, I need
> to handle records from three different DB2 libraries:
>
> - LIB1.TABLE
> - LIB2.TABLE
> - LIB3.TABLE
>
> Before, I simply created a view that contained a union of those
> three tables but now I need to write to it. When I try to create
> those three tables in the modeler, it does not like to create
>
> DBEntity Configuration
> Name: TABLE
> Schema: LIB1
>
> +
>
> DBEntity Configuration
> Name: TABLE
> Schema: LIB2
>
> Why does this limitation exist? Is there a way around? I really
> need to write to those tables depending on the logged-in user.
>
> Any help appreciated,
> Andreas Pardeike
>
This archive was generated by hypermail 2.0.0 : Thu Nov 20 2008 - 17:58:37 EST