Re: reverse engineer problems

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Wed Sep 21 2005 - 19:31:08 EDT

  • Next message: Marek Wawrzyczny: "3T questions"

    Cris,

    I am not aware of reverse engineering problems specific to 1.2. I'd
    try a quick test of the driver before looking in Cayenne:

        ResultSet keys = connection.getMetaData().getExportedKeys(null,
    "myschema", "my_table");

    Andrus

    On Sep 20, 2005, at 10:18 AM, Cris Daniluk wrote:
    > I have the following PG table:
    >
    > CREATE TABLE personnel (
    > personnel_id SERIAL NOT NULL PRIMARY KEY,
    > ...
    > duty_station_id INTEGER NOT NULL REFERENCES duty_station
    > (duty_station_id),
    > unit_id INTEGER NOT NULL REFERENCES duty_station_unit (unit_id),
    > bos_code CHAR(2) NOT NULL REFERENCES branch_of_service (bos_code),
    > rank_id INTEGER NOT NULL REFERENCES personnel_rank (rank_id)
    > );
    >
    > When reverse engineering in 1.2M5, it is only finding the rank_id
    > relationship. Are there any known defficiencies in the reverse eng in
    > 1.2? I haven't seen any threads on this lately, but the FK discovery
    > problems seem fairly extensive.
    >
    > It's possible its a JDBC driver bug, but I don't think so... Any
    > thoughts?
    >
    > Cris
    >
    >



    This archive was generated by hypermail 2.0.0 : Wed Sep 21 2005 - 19:31:11 EDT