Re: [JIRA] Commented: (CAY-777) Still incorrect: CLONE -Import EOModel - Incorrect Join src/target names are created

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Mon Apr 16 2007 - 13:00:46 EDT

  • Next message: Andrus Adamchik: "Fwd: [JIRA] Commented: (CAY-777) Still incorrect: CLONE -Import EOModel - Incorrect Join src/target names are created"

    Hmmm... Looking at the issue some more - it was cloned from another
    issue... So Yegor, are you importing an EOModel, or are you reverse
    engineering the DB? Somehow I have a feeling there's no WebObjects
    EOModel involved at all.

    Andrus

    On Apr 16, 2007, at 7:49 PM, Mike Kienenberger wrote:
    > Yegor,
    >
    > You posted the Cayenne data map, which is probably helpful.
    >
    > But what's needed (What Andrus asked for) is the EOModel files,
    > probably at minimal the Company and BooleanValue.plist files.
    >
    >
    > On 4/16/07, Yegor <yego..intecmedia.com> wrote:
    >> Hi!
    >>
    >> Although I CAN send you the complete set of files and an SQL
    >> script to
    >> create MySQL database, I have decided to extract the relevant part
    >> only:
    >>
    >> <?xml version="1.0" encoding="utf-8"?>
    >> <data-map project-version="2.0">
    >> <property name="defaultPackage" value="com.ray.database"/>
    >> <property name="defaultSchema" value="ray"/>
    >>
    >> <db-entity name="boolean_value" catalog="ray">
    >> <db-attribute name="BOOLEAN_VALUE_ID" type="INTEGER"
    >> isPrimaryKey="true" isMandatory="true" length="11"/>
    >> <db-attribute name="NAME" type="VARCHAR"
    >> isMandatory="true" length="200"/>
    >> <db-attribute name="PRIORITY" type="INTEGER"
    >> isMandatory="true" length="11"/>
    >> </db-entity>
    >> <db-entity name="company" catalog="ray">
    >> <db-attribute name="COMPANY_ID" type="INTEGER"
    >> isPrimaryKey="true" isMandatory="true" length="11"/>
    >> <db-attribute name="ELEMENTS_USED_ID" type="INTEGER"
    >> isMandatory="true" length="11"/>
    >> <db-attribute name="MODELS_USED_ID" type="INTEGER"
    >> isMandatory="true" length="11"/>
    >> </db-entity>
    >>
    >> <obj-entity name="BooleanValue"
    >> className="com.ray.database.BooleanValue"
    >> dbEntityName="boolean_value">
    >> <obj-attribute name="name" type="java.lang.String"
    >> db-attribute-path="NAME"/>
    >> <obj-attribute name="priority"
    >> type="java.lang.Integer"
    >> db-attribute-path="PRIORITY"/>
    >> </obj-entity>
    >> <obj-entity name="Company"
    >> className="com.ray.database.Company"
    >> dbEntityName="company">
    >> </obj-entity>
    >>
    >> <db-relationship name="companyArray" source="boolean_value"
    >> target="company" toMany="true">
    >> <db-attribute-pair source="BOOLEAN_VALUE_ID"
    >> target="ELEMENTS_USED_ID"/>
    >> </db-relationship>
    >> <db-relationship name="companyArray1" source="boolean_value"
    >> target="company" toMany="true">
    >> <db-attribute-pair source="BOOLEAN_VALUE_ID"
    >> target="MODELS_USED_ID"/>
    >> </db-relationship>
    >>
    >> <db-relationship name="toBooleanValue" source="company"
    >> target="boolean_value" toMany="false">
    >> <db-attribute-pair source="ELEMENTS_USED_ID"
    >> target="BOOLEAN_VALUE_ID"/>
    >> </db-relationship>
    >> <db-relationship name="toBooleanValue1" source="company"
    >> target="boolean_value" toMany="false">
    >> <db-attribute-pair source="MODELS_USED_ID"
    >> target="BOOLEAN_VALUE_ID"/>
    >> </db-relationship>
    >>
    >> <obj-relationship name="companyArray" source="BooleanValue"
    >> target="Company" db-relationship-path="companyArray"/>
    >> <obj-relationship name="companyArray1" source="BooleanValue"
    >> target="Company" db-relationship-path="companyArray1"/>
    >> <obj-relationship name="toBooleanValue" source="Company"
    >> target="BooleanValue" db-relationship-path="toBooleanValue"/>
    >> <obj-relationship name="toBooleanValue1" source="Company"
    >> target="BooleanValue" db-relationship-path="toBooleanValue1"/>
    >> </data-map>
    >>
    >> Notice, ELEMENTS_USED_ID became toBooleanValue and MODELS_USED_ID
    >> became
    >> toBooleanValue1.
    >>
    >> I am sorry to say, that this is a showstopper for me: for a Company
    >> table, I simply do not know, whether to use toBooleanValue or
    >> toBooleanValue1.
    >>
    >> If you need the complete files, I will be happy to send them.
    >>
    >> Thanks!!!
    >>
    >>
    >> -----Original Message-----
    >> From: Andrus Adamchik (JIRA) [mailto:de..ayenne.apache.org]
    >> Sent: Monday, April 16, 2007 6:47 PM
    >> To: Yegor
    >> Subject: [JIRA] Commented: (CAY-777) Still incorrect: CLONE -Import
    >> EOModel - Incorrect Join src/target names are created
    >>
    >>
    >> [
    >> https://issues.apache.org/cayenne/browse/CAY-777?
    >> page=com.atlassian.jira
    >> .plugin.system.issuetabpanels:comment-tabpanel#action_12289 ]
    >>
    >> Andrus Adamchik commented on CAY-777:
    >> -------------------------------------
    >>
    >> Yegor,
    >>
    >> could you possibly attach an EOModel (or a relevant part of it) to
    >> this
    >> issue? This will significantly speed up the fix. Or if it contains
    >> sensitive company data, could you create a neutral EOModel from
    >> scratch
    >> that reproduces the problem.
    >>
    >> Thanks
    >> Andrus
    >>
    >> > Still incorrect: CLONE -Import EOModel - Incorrect Join src/target
    >> > names are created
    >> >
    >> ---------------------------------------------------------------------
    >> -
    >> > --------------
    >> >
    >> > Key: CAY-777
    >> > URL: https://issues.apache.org/cayenne/browse/
    >> CAY-777
    >> > Project: Cayenne
    >> > Issue Type: Bug
    >> > Components: Cayenne Core Library
    >> > Affects Versions: 1.1 [LEGACY]
    >> > Environment: EOModels created for WO5.2, Cayenne 1.1B1
    >> > Reporter: Kurbachev Yegor
    >> > Assigned To: Andrus Adamchik
    >> > Priority: Critical
    >> > Fix For: 1.1 [LEGACY]
    >> >
    >> >
    >> > Join source amd target are all created using ObjAttribute names,
    >> > instead of column names. This may still work for EOModels where the
    >> > two are the same, but it is a nasty bug that completely prevents
    >> > import from working in a general case. Looks like a fresh one
    >> (after
    >> > we switched from DBAttributePair to DBJoin, ca. M6)
    >>
    >> --
    >> This message is automatically generated by JIRA.
    >> -
    >> You can reply to this email to add a comment to the issue online.
    >>
    >>
    >>
    >>
    >>
    >>
    >> *********************************************************************
    >> ***
    >> ************
    >> This footnote confirms that this email message has been scanned by
    >> PineApp Mail-SeCure for the presence of malicious code, vandals &
    >> computer viruses.
    >> *********************************************************************
    >> ***
    >> ************
    >>
    >>
    >>
    >>
    >>
    >>
    >



    This archive was generated by hypermail 2.0.0 : Mon Apr 16 2007 - 13:02:22 EDT