Using Flyway (or Liquibase), you'll have to extract the JDBC connection from Cayenne to pass to Flyway to perform the migration when the application initializes. See the bottom of:
http://flywaydb.org/documentation/api.html Also, Flyway doesn't know about Cayenne, so you'd have to update your Cayenne model to have your new column(s) then add an SQL script (or Java migration) for Flyway to use to upgrade the schema separately. Not too difficult, just something to keep in mind to be part of your process. mrg On Sun, Nov 25, 2012 at 10:45 AM, emeka okafor <emeka_1...@yahoo.com> wrote: > Thank you for your suggestions; I am going to try both and see which one > is easier. > > > > ________________________________ > From: Juan José Gil <mat...@gmail.com> > To: user@cayenne.apache.org > Sent: Saturday, November 24, 2012 11:08 PM > Subject: Re: adding new columns to table > > wouldn't be better to use something like flyway? http://flywaydb.org/ > > > 2012/11/24 John Huss <johnth...@gmail.com> > > > There is an experimental library in the cayenne-sandbox you could try: > > http://svn.apache.org/viewvc/cayenne/sandbox/cayenne-migrations/ > > > > I'm using it in production, but your mileage may vary. The migrations > are > > not automatically generated (except for the initial database) but they > are > > easy to write. > > > > > > On Sat, Nov 24, 2012 at 10:59 AM, emeka okafor <emeka_1...@yahoo.com> > > wrote: > > > > > Is there a cayenne way to modifying a databse table? Like a way for > > > cayenne to generate a migration class that can be run when when my > schema > > > changes. > > >
