Re: Migration Error
Re: Migration Error
- Subject: Re: Migration Error
- From: Archibald Singleton <email@hidden>
- Date: Fri, 21 Mar 2008 11:10:20 -0300
On 20 Mar 2008, at 21:17, 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
Your log is incomplete. This error may "normal". This db is created/used automatically by the migrations mechanism. What the log says is that it didn't exist but that migrations will attempt to create it. Can you check whether the _dbupdater table was created or not.?
= tmk = |
_______________________________________________
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