Re: Migration bug?
Re: Migration bug?
- Subject: Re: Migration bug?
- From: Ray Kiddy <email@hidden>
- Date: Sat, 2 Jan 2010 16:50:50 -0800
On Jan 2, 2010, at 4:31 PM, Chuck Hill wrote:
One problem is that this plugin may only build under 5.4. Which is
why it has not yet been added to Wonder.
The ant build system knows whether the environment it is in is running
5.4 or 5.3. Or it easily could. The variables exist. They may need to
plugged into the targets.
I assume the Maven and eclipse build environments do or can know the
WO version also.
Is there a build system where this is known to be a problem? I can pre-
flight the changes to the ant build system to enable conditional
builds of the plugin and we'll see.
cheers - ray
On Jan 2, 2010, at 2:01 PM, Ray Kiddy wrote:
On Jan 2, 2010, at 10:18 AM, Mark Woollard wrote:
Thanks - thats it - plugin fixes problem
Mark
It occurs to me that we can have ERXApplication, at
applicationDidLaunch time or thereabouts, check (1) are your models
using MySQL? and (2) are you using 5.3 or 5.4? and then we could
switch the plugin in the connection dictionary of the loaded models.
Or is this a road we might not want to start going down?
- ray
On 2 Jan 2010, at 17:29, Mike Schrag wrote:
WO 5.4 breaks sql generation ... you need to use the custom mysql
plugin that has been posted on the wonder list.
ms
On Jan 2, 2010, 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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden