Hi Johnny, That should do it. Ramsey would know for sure. Try that and post back if it doesn't work.
Dave On Jan 5, 2010, at 3:22 PM, Johnny Miller wrote: > To use this plugin do you just add the project to the workspace, build it and > then include it as a WO Framework? > > Thanks in advance, > > Johnny > > > On Jan 2, 2010, at 7:29 AM, David LeBer wrote: > >> Before we go any further, are you using WO5.4 and MySQL without using >> Ramsey's MySQL plugin? >> >> <http://issues.objectstyle.org/jira/browse/WONDER-339> >> >> On 2010-01-02, at 12:23 PM, Mark Woollard wrote: >> >>> Am using Wonder Project migration for the first time. The initial database >>> creation works but am now trying to add a single column as the second >>> revision of the database. When running application am getting error as >>> follows: >>> >>> Jan 02 17:13:28 TheApp[53817] INFO er.extensions.jdbc.ERXJDBCUtilities - >>> Executing alter table t_position null c_abbreviation longtext NOT NULL >>> Jan 02 17:14:11 TheApp[53817] DEBUG NSLog - === Commit Internal >>> Transaction >>> Jan 02 17:14:11 TheApp[53817] DEBUG NSLog - === Begin Internal Transaction >>> Jan 02 17:14:11 TheApp[53817] DEBUG NSLog - evaluateExpression: >>> <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "UPDATE _dbupdater >>> SET lockowner = NULL, updatelock = ? WHERE modelname = ?" withBindings: >>> 1:0(updateLock), 2:"MockDraft"(modelName)> >>> Jan 02 17:14:11 TheApp[53817] DEBUG NSLog - === Commit Internal >>> Transaction >>> Jan 02 17:14:11 TheApp[53817] DEBUG NSLog - === Begin Internal Transaction >>> Jan 02 17:14:20 TheApp[53817] DEBUG NSLog - === Rollback Internal >>> Transaction >>> Jan 02 17:14:36 TheApp[53817] ERROR er.extensions.appserver.ERXApplication >>> - TheApp failed to start. >>> MySQLSyntaxErrorException: You have an error in your SQL syntax; check the >>> manual that corresponds to your MySQL server version for the right syntax >>> to use near 'null c_abbreviation longtext NOT NULL' at line 1 >>> >>> The database is mysql, and it seems to me that the alter statement is >>> incorrect on the first line of the log, there should be 'add column' rather >>> than 'null'. The migration class is as follows: >>> >>> public class DbVersion1 extends Migration { >>> >>> @Override >>> public void downgrade(EOEditingContext ec, ERXMigrationDatabase >>> database) >>> throws Throwable { >>> >>> database.existingTableNamed("t_position").existingColumnNamed("c_abbreviation").delete(); >>> } >>> >>> @Override >>> public void upgrade(EOEditingContext ec, ERXMigrationDatabase database) >>> throws Throwable { >>> ERXMigrationTable table = >>> database.existingTableNamed("t_position"); >>> table.newStringColumn("c_abbreviation", false, ""); >>> } >>> } >>> >>> The new column is using the varchar10 prototype. Am stuck as can't see why >>> the sql is being generated incorrectly. Anyone have any ideas? >>> >>> Thanks >>> Mark >>> >>> >>> >>> _______________________________________________ >>> Do not post admin requests to the list. They will be ignored. >>> Webobjects-dev mailing list ([email protected]) >>> Help/Unsubscribe/Update your Subscription: >>> http://lists.apple.com/mailman/options/webobjects-dev/dleber_wodev%40codeferous.com >>> >>> This email sent to [email protected] >> >> ;david >> >> -- >> David LeBer >> Codeferous Software >> 'co-def-er-ous' adj. Literally 'code-bearing' >> site: http://codeferous.com >> blog: http://davidleber.net >> profile: http://www.linkedin.com/in/davidleber >> twitter: http://twitter.com/rebeld >> -- >> Toronto Area Cocoa / WebObjects developers group: >> http://tacow.org >> >> >> >> >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list ([email protected]) >> Help/Unsubscribe/Update your Subscription: >> http://lists.apple.com/mailman/options/webobjects-dev/jlmiller%40kahalawai.com >> >> This email sent to [email protected] > > Johnny Miller > Kahalawai Media Corp > http://www.kahalawai.com > > > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/webobjects%40avendasora.com > > This email sent to [email protected] > > _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
