Re: Subject: Issue with Reverse Engineering Sybase Database

From: McDaniel, Joe (mcdanij..igr.org)
Date: Mon Aug 16 2004 - 12:31:59 EDT

  • Next message: Gowry Gabriev: "Support for encrypted db passwords"

    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