Re: Index modeling

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Mon Jan 18 2010 - 16:38:09 EST

  • Next message: Andrus Adamchik: "Re: Project site links"

    Cool. I expect the Modeler support won't be an issue. Once everything
    else is done, this can be picked up by other committers.

    BTW, one pretty serious obstacle for turning indexes into first class
    citizens in Cayenne DB metadata is the fact that JDBC does not provide
    any means for reverse-engineering indexes in a DB-independent manner.
    So the only way to load a model with indexes from an existing DB is to
    extend DbAdapter with custom DB SQL for each DB to read indexes. I
    suggest researching this issue first before doing any other work.

    Andrus

    On Jan 17, 2010, at 7:24 PM, Zissis Trabaris wrote:

    > I think I could get it cleanly added to Cayenne 3.1. I would probably
    > have to upgrade the DBMerger, LoaderDeligate, DBLoader, DBEntity,
    > create
    > a MergerToken, and possibly upgrade DBAdapter. Someone else would have
    > to upgrade the modeler since I am not up to speed with that code. I
    > then
    > would be able to contribute the changes back into the trunk code. So
    > should I just checkout the trunk code, make the changes and then
    > submit
    > the diffs?
    >
    > Zissis Trabaris * Chief Technology Officer * INSYSWARE * 3235 West
    > River
    > Road, Grand Island, New York, 14072, USA
    > Mobile (716) 930-5654 * Office (518) 636-4118 * Fax (716) 625-1305 *
    > z.trabari..nsysware.com * www.insysware.com
    >
    > CONFIDENTIALITY: This email (including any attachments) may contain
    > confidential, proprietary and privileged information, and unauthorized
    > disclosure or use is prohibited. If you received this email in error,
    > please notify the sender and delete this email from your system. Thank
    > you.
    >
    >
    > -----Original Message-----
    > From: George Stan [mailto:george.stan..ahoo.com]
    > Sent: Sunday, January 17, 2010 5:06 AM
    > To: de..ayenne.apache.org
    > Subject: Re: Index modeling
    >
    >>> Are there any plans to add DB index definitions and
    >> generation in the
    >>> DBEntities in the near future? We are currently
    >> managing these outside
    >>> of the Cayenne xml and using SQLTemplates to generate
    >> them when I sync
    >>> the models to the DB. It would be nice if we don't
    >> have to maintain that
    >>> code if Cayenne would handle it for us.
    >>
    >> You could certainly put forward a patch for this work and
    >> it would be welcomed. Should be simple enough to implement
    >> the changes to the model schema and the modeler.
    >>
    >> There is already a Jira task open for this but I don't
    >> believe anyone has started work.
    > It is this JIRA issue:
    > https://issues.apache.org/jira/browse/CAY-204
    >
    > And it's one of the most (wanted and) voted feature request:
    > https://issues.apache.org/jira/browse/CAY?report=com.atlassian.jira.plug
    > in.system.project:popularissues-panel
    >
    > George.
    >
    >
    >
    >
    >



    This archive was generated by hypermail 2.0.0 : Mon Jan 18 2010 - 16:38:47 EST