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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [EMAIL PROTECTED]

Reply via email to