Re: Migration Error
Re: Migration Error
- Subject: Re: Migration Error
- From: Gustavo Pizano <email@hidden>
- Date: Thu, 20 Mar 2008 21:28:07 -0500
| ok I guess this refers witht he error of the sql generation rpoblem with EO ann WO 5.4, correct me if Im wrong, I have just tried once again, doing it step-by-step but couldn't make it work.. I will continue but I guess I will not use Migration for now.
Gustavo
On Mar 20, 2008, at 7:17 PM, Gustavo Pizano wrote: Hello after deciding the proper name for the PK add the following lines to the properties file
# Migrations er.migration.migrateAtStartup=true er.migration.createTablesIfNecessary=true er.migration.modelNames=Convocatoriawo ConvocatoriaWO.MigrationClassPrefix = com.convocatoriaWO.migration.Convocatoriawo
#Conection Dictionary dbConnectURLGLOBAL=jdbc:mysql://localhost/Convocatoriawo?capitalizeTypesnames=true&zeroDateTimeBehavior=convertToNull dbConnectUserGLOBAL = root #dbConnectPasswordGLOBAL
the blue highlighted means ..?? the project name?... and the orange kind of red means???
ok so O was following as the screen cast says, btu with my model then I get the following error when running for first time
Mar 20 19:09:41 ConvocatoriaWO[50374] (ERXNSLogLog4jBridge.java:44) DEBUG NSLog - evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "UPDATE _dbupdater SET lockowner = ?, updatelock = ? WHERE (modelname = ? AND (updatelock = ? OR lockowner = ?))" withBindings: 1:"ConvocatoriaWO--1"(lockOwner), 2:1(updateLock), 3:"Convocatoriawo"(modelName), 4:0(updateLock), 5:"ConvocatoriaWO--1"(lockOwner)> Mar 20 19:09:41 ConvocatoriaWO[50374] (ERXNSLogLog4jBridge.java:44) DEBUG NSLog - === Rollback Internal Transaction Mar 20 19:09:41 ConvocatoriaWO[50374] (ERXJDBCMigrationLock.java:126) WARN er.extensions.migration.ERXJDBCMigrationLock - Failed to lock. Attempting to create the table and lock again. Original reason for failure: Table 'convocatoriawo._dbupdater' doesn't existat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1026)
So I dunno what im doing wrong, I created the databases called Convocatoriawo
Gus
|
_______________________________________________
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