Rob,
I think the problem is caused by trying to get the foreign key metadata for
a view. If I filter the tables so only tables are being processed (in my
case all "real" tables have a z_ prefix, then the modeler works just fine.
I think this can be fixed in DBLoader in loadDbRelationships (line 460 in
the current version, I think) by testing for whether the pkEntity has
primary keys or is a view (have not seen where this is stored so far --
pkEntity does have a list of primary keys, though). There is probably a
more elegant fix.
Using the filtering will get you around this for now (if the filter is not a
regular expression then you can do the filtering a bit more tediously by
running the reengineer multiple times).
Best,
Joe
On 8/13/04 2:28 PM, "ROB ROBINSON" <rrobinson031..ogers.com> wrote:
> Same problem with 1.1 from the latest daily. I
> thought it might be JConnect since I am still using
> JDBC(TM)/5.5(Build 25200), but I tried using:
> http://jtds.sourceforge.net/ and got almost the same
> message (Object does not exist in database)
>
> I am guessing it must be a bug maybe with the version
> of Sybase we are using (12.5.0.2). What version are
> you running?
>
> --- "McDaniel, Joe R." <mcdanij..igr.org> wrote:
>>
>> Hi Rob,
>>
>> "newest version" is the beta version of 1.1. It is
>> pretty stable. I
>> would get the daily release (they are run through a
>> test suite and
>> generally stable).
>>
>> I don't remember any problems with using Cayenne
>> with combinations of
>> views and tables. I would try it with the beta
>> version -- if you are
>> still having a problem it is likely to get fixed
>> "real soon now."
>>
>> Best,
>>
>> Joe
>>
This archive was generated by hypermail 2.0.0 : Mon Aug 16 2004 - 12:32:49 EDT