Re: migrations error

2011-11-01 Thread John Huss
g, boolean) in the type > ERXMigrationTable is not applicable for the arguments (String, > boolean, String) > > > Ted > > --- On Tue, 11/1/11, John Huss wrote: > > From: John Huss > Subject: Re: migrations error > To: "Ramsey Gurley" > Cc: "The

Re: migrations error

2011-11-01 Thread Theodore Petrosky
n Tue, 11/1/11, John Huss wrote: From: John Huss Subject: Re: migrations error To: "Ramsey Gurley" Cc: "Theodore Petrosky" , webobjects-dev@lists.apple.com Date: Tuesday, November 1, 2011, 12:07 PM Ah, I didn't really read it either  :-) Yeah you should just pass th

Re: migrations error

2011-11-01 Thread John Huss
Ah, I didn't really read it either :-) Yeah you should just pass the default value and NOT NULL in the newColumn call: workingTable.newLargeStringColumn("c_password", false, "4004"); workingTable.newLargeStringColumn("c_user_name", false, "theuser"); On Tue, Nov 1, 2011 at 10:37 AM, Ramsey Gurl

Re: migrations error

2011-11-01 Thread Ramsey Gurley
Oops… just looked more closely at your sql. You're setting values on all the rows, aren't you? I believe that can be done by simply setting the default value in the new column method, but I'll defer to John on that. I don't use the defaults so I may be mistaken. Ramsey On Nov 1, 2011, at 8:3

Re: migrations error

2011-11-01 Thread Ramsey Gurley
I think this is commonly handled in a post migration http://webobjects.mdimension.com/hudson/job/Wonder/javadoc/er/extensions/migration/IERXPostMigration.html Just make your migration implement that interface, and the post migration method will be called after the tables are created. From the p

Re: migrations error

2011-11-01 Thread John Huss
The transaction handling for Migrations is a bit sloppy, partly because the JDBC transaction can be started and stopped directly without telling EOF, and that can lead to problems. I created a patch to fix it, the jira is here so you can vote

migrations error

2011-11-01 Thread Theodore Petrosky
I use migrations for all of my company stuff. They are great I am running into a problem: public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable { ERXMigrationTable workingTable = database.existingTableNamed("t_employee");