Hi Robert,
1. I will add that functionality to append entities to the existing map (rather than create new map each time) within the next couple days.
2. As for connecting relationships between different schemas ("parent" and "child"), we will have to add this functionality as well. It will support relationships from child to parent, but any relationships from parent to child will have to be added manually (at least for a time). This functionality will be added about the same time as item 1.
We appreciate your input.
Misha Shengaout
----- Original Message -----
From: Robert John Andersen
To: cayenne-devel
Sent: Wednesday, May 01, 2002 10:01 PM
Subject: Modeler using multiple schemas problem
Our current database (oracle) configuration has multiple schemas in 1 instance. One of the schemas is a reference schema that is accessable from the other schemas. I created a map with on of the main schemas, I then tried to use the same logon information and select the reference schema and nothing was generated. If I use the logon information for the reference schema it does generate it but puts it in a different map.
A side note: even though the main schema has foreign key information to the reference schema it doesn't pick that up in the modeler nor does it pick it up in the 2 jdbc applications I use, seems like some limitation in jdbc.
It would be nice to have separate maps for the main schema and the reference schema but how would relationships from the main->reference schema be done? I would prefer to not have to create all the relationships by hand since we have over 50 reference tables and over 100 tables that refer to them.
This archive was generated by hypermail 2.0.0 : Wed May 01 2002 - 23:50:16 EDT