cayenne-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <>
Subject Re: Index modeling
Date Mon, 18 Jan 2010 21:38:09 GMT
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.


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 *
> *
> 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 []
> Sent: Sunday, January 17, 2010 5:06 AM
> To:
> 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:
> And it's one of the most (wanted and) voted feature request:
> in.system.project:popularissues-panel
> George.

View raw message