cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <>
Subject Re: Can I use the CayenneModeler to set up indexes? If so, how?
Date Fri, 19 May 2006 15:43:55 GMT
Re indexes: indexes support was requested before and IIRC is the part  
of JPA spec, so the future versions of the Modeler will support that.  
Not 1.2 though.


On May 19, 2006, at 10:46 AM, Gentry, Michael ((Contractor)) wrote:

> The modeler currently doesn't allow you to specify arbitrary indexes.
> This could be added to the wish list, but would mainly be used while
> developing a schema (not while maintaining an in-production schema).
> My preferred approach is to have upgrade scripts that are checked into
> the SCM repository.  You can use filenames like schema_001.sql,
> schema_002.sql, etc.  Makes it easy to sequence them and is highly
> reproducible.  It also clearly documents your changes.  It would be a
> very difficult problem for the modeler to be able to automatically
> determine the required changes from one schema to another -- and you'd
> have to force the DBAs to run the modeler then, too.
> I don't know of a good schema migration tool.
> /dev/mrg
> -----Original Message-----
> From: Eric Lazarus []
> Sent: Friday, May 19, 2006 7:15 AM
> To: cayenne user
> Subject: Can I use the CayenneModeler to set up indexes? If so, how?
> Can I use the CayenneModeler to set up indexes? If so,
> how?
> Can someone share an example, a screen shot or
> something?
> If not, how do others deal with this? Do I write a
> little shell script that does SQL queries to add those
> indexes when I re-gen the database?
> On a separate note, does anyone know a good schema
> migration tool we can use when we, after we deploy, we
> end up with changes to our relational and object
> models and we need to move data forward (and, in an
> emergency perhaps, backward)?
> Eric

View raw message