• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Migation failed when updating a table
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Migation failed when updating a table

  • Subject: Re: Migation failed when updating a table
  • From: "Mitchell Smith" <email@hidden>
  • Date: Fri, 21 Nov 2008 10:33:24 +1000
You are setting your column to "NOT NULL" so if you have existing rows in the table the alter table will fail unless you provide a default value for the column.
 
userTable.existingColumnNamed("password").defaultValue("xxxxxxxx");
 
then setAllowsNull(false)
 
----- Original Message -----
From: Gustavo Pizano
To: WebObjects-Dev Apple
Sent: Friday, November 21, 2008 3:47 AM
Subject: Migation failed when updating a table

Hello, well I run the migrationClass0 and it run fine, the db was created and everything , but then I forgot I needed another attribute in one entity, I used 

@Override
public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable {
ERXMigrationTable userTable = database.existingTableNamed("USER");
userTable.newStringColumn("password", 16, false);


}
and when I run I got the following. What Im doing wrong?...  thanks
Gustavo


Nov 20 18:37:18 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  - Finished initialization after launch: ERXExtensions
Nov 20 18:37:18 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  - Finished initialization after launch: ERPrototypes
Nov 20 18:37:18 StockManager[1250] (Application.java:13) INFO  er.extensions.appserver.ERXApplication  - Welcome to StockManager !
Nov 20 18:37:18 StockManager[1250] (ERXModelGroup.java:127) WARN  er.extensions.eof.ERXModelGroup  - Clearing previous class descriptions
Nov 20 18:37:18 StockManager[1250] (ERXModelGroup.java:845) WARN  er.extensions.eof.ERXModelGroup  - The EOModel 'erprototypes' has an empty connection dictionary.
Nov 20 18:37:18 StockManager[1250] (ERXEntityClassDescription.java:576) WARN  er.extensions.eof.ERXEntityClassDescription  - Invalid class name for entity: PRODUCTXPROVIDER exception: java.lang.ClassNotFoundException: com.StockManager.eo.EOGenericRecord using com.webobjects.eocontrol.EOGenericRecord instead
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  - Using JDBCPlugIn 'com.webobjects.jdbcadaptor._FrontBasePlugIn' for JDBCAdaptor@2984537
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  - Using JDBCPlugIn 'com.webobjects.jdbcadaptor._FrontBasePlugIn' for JDBCAdaptor@977184
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  - Using JDBCPlugIn 'com.webobjects.jdbcadaptor._FrontBasePlugIn' for JDBCAdaptor@13888686
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  connecting with dictionary: {password = "<password deleted for log>"; username = "gustavpicora"; URL = ""; }
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  === Begin Internal Transaction
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  === Commit Internal Transaction
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  === Begin Internal Transaction
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  - Using JDBCPlugIn 'com.webobjects.jdbcadaptor._FrontBasePlugIn' for JDBCAdaptor@6691152
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  - fetching JDBC Info with JDBCContext@13393004
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  connecting with dictionary: {password = "<password deleted for log>"; username = "gustavpicora"; URL = ""; }
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  - connection disconnected.
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  - fetching JDBC Info with JDBCContext@14935237
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  connecting with dictionary: {password = "<password deleted for log>"; username = "gustavpicora"; URL = ""; }
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  evaluateExpression: <com.webobjects.jdbcadaptor._FrontBasePlugIn$FrontbaseExpression: "UPDATE "_dbupdater" SET "lockowner" = 'StockManager--1', "updatelock" = 1 WHERE ("modelname" = 'StockManager' AND ("updatelock" = 0 OR "lockowner" = 'StockManager--1'))" withBindings: >
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  === Commit Internal Transaction
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  === Begin Internal Transaction
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  evaluateExpression: <com.webobjects.jdbcadaptor._FrontBasePlugIn$FrontbaseExpression: "SELECT t0."version" FROM "_dbupdater" t0 WHERE t0."modelname" = 'StockManager'" withBindings: >
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  - fetch canceled
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  - 1 row(s) processed
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  === Commit Internal Transaction
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  === Begin Internal Transaction
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  evaluateExpression: <com.webobjects.jdbcadaptor._FrontBasePlugIn$FrontbaseExpression: "UPDATE "_dbupdater" SET "lockowner" = NULL, "updatelock" = 0 WHERE "modelname" = 'StockManager'" withBindings: >
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  === Commit Internal Transaction
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  === Begin Internal Transaction
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  === Commit Internal Transaction
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  === Begin Internal Transaction
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  === Commit Internal Transaction
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  - Using JDBCPlugIn 'com.webobjects.jdbcadaptor._FrontBasePlugIn' for JDBCAdaptor@11988768
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  === Begin Internal Transaction
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  === Commit Internal Transaction
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  === Begin Internal Transaction
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  evaluateExpression: <com.webobjects.jdbcadaptor._FrontBasePlugIn$FrontbaseExpression: "UPDATE "_dbupdater" SET "lockowner" = 'StockManager--1', "updatelock" = 1 WHERE ("modelname" = 'StockManager' AND ("updatelock" = 0 OR "lockowner" = 'StockManager--1'))" withBindings: >
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  === Commit Internal Transaction
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  === Begin Internal Transaction
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  evaluateExpression: <com.webobjects.jdbcadaptor._FrontBasePlugIn$FrontbaseExpression: "SELECT t0."version" FROM "_dbupdater" t0 WHERE t0."modelname" = 'StockManager'" withBindings: >
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  - fetch canceled
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  - 1 row(s) processed
Nov 20 18:37:19 StockManager[1250] (ERXMigrator.java:408) INFO  er.extensions.migration.ERXMigrator  - Upgrading StockManager to version 1 with migration 'stockManager.app.migration.StockManager1@ae3b4d'
Nov 20 18:37:19 StockManager[1250] (ERXJDBCUtilities.java:610) INFO  er.extensions.jdbc.ERXJDBCUtilities  - Executing alter table USER add "password" VARCHAR(16) CONSTRAINT NOT_NULL_USER__password NOT NULL
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  === Commit Internal Transaction
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  === Begin Internal Transaction
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  evaluateExpression: <com.webobjects.jdbcadaptor._FrontBasePlugIn$FrontbaseExpression: "UPDATE "_dbupdater" SET "lockowner" = NULL, "updatelock" = 0 WHERE "modelname" = 'StockManager'" withBindings: >
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  === Commit Internal Transaction
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  === Begin Internal Transaction
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  === Rollback Internal Transaction
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  === Begin Internal Transaction
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  === Commit Internal Transaction
Nov 20 18:37:19 StockManager[1250] (ERXApplication.java:1055) ERROR er.extensions.appserver.ERXApplication  - StockManager failed to start.
er.extensions.migration.ERXMigrationFailedException: Migration failed.
at er.extensions.migration.ERXMigrator$ERXMigrationAction.doPerform(ERXMigrator.java:427)
at er.extensions.eof.ERXEOAccessUtilities$ChannelAction.perform(ERXEOAccessUtilities.java:1455)
at er.extensions.migration.ERXMigrator.migrateToLatest(ERXMigrator.java:179)
at er.extensions.appserver.ERXApplication.finishInitialization(ERXApplication.java:956)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.webobjects.foundation.NSSelector._safeInvokeMethod(NSSelector.java:122)
at com.webobjects.foundation.NSNotificationCenter$_Entry.invokeMethod(NSNotificationCenter.java:588)
at com.webobjects.foundation.NSNotificationCenter.postNotification(NSNotificationCenter.java:532)
at com.webobjects.foundation.NSNotificationCenter.postNotification(NSNotificationCenter.java:546)
at com.webobjects.appserver.WOApplication.run(WOApplication.java:1229)
at er.extensions.appserver.ERXApplication.run(ERXApplication.java:1051)
at com.webobjects.appserver.WOApplication.main(WOApplication.java:548)
at er.extensions.appserver.ERXApplication.main(ERXApplication.java:593)
at stockManager.app.Application.main(Application.java:9)
Caused by: java.sql.SQLException: Syntax error 61. Expected Identifier not found.
at com.frontbase.jdbc.FBJErrorMetaData.errorMessageAtIndex(FBJErrorMetaData.java:162)
at com.frontbase.jdbc.FBJErrorMetaData.getExceptionChain(FBJErrorMetaData.java:194)
at com.frontbase.jdbc.FBJStatement.checkMetaData(FBJStatement.java:472)
at com.frontbase.jdbc.FBJStatement.executeUpdate(FBJStatement.java:262)
at er.extensions.jdbc.ERXJDBCUtilities.executeUpdateScript(ERXJDBCUtilities.java:612)
at er.extensions.migration.ERXMigrationColumn.create(ERXMigrationColumn.java:382)
at er.extensions.migration.ERXMigrationTable._newColumn(ERXMigrationTable.java:224)
at er.extensions.migration.ERXMigrationTable.newColumn(ERXMigrationTable.java:269)
at er.extensions.migration.ERXMigrationTable.newStringColumn(ERXMigrationTable.java:282)
at stockManager.app.migration.StockManager1.upgrade(StockManager1.java:25)
at er.extensions.migration.ERXMigrationDatabase$Migration.upgrade(ERXMigrationDatabase.java:425)
at er.extensions.migration.ERXMigrator$ERXMigrationAction.doPerform(ERXMigrator.java:410)
... 16 more
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:43) WARN  NSLog  - A fatal exception occurred: er.extensions.migration.ERXMigrationFailedException: Migration failed.
[2008-11-20 18:37:19 CET] <main> [stack trace already printed]

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your 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
  • Follow-Ups:
    • Re: Migation failed when updating a table
      • From: Mike Schrag <email@hidden>
References: 
 >Migation failed when updating a table (From: Gustavo Pizano <email@hidden>)

  • Prev by Date: Re: URL for WebObjects?
  • Next by Date: Re: URL for WebObjects?
  • Previous by thread: Re: Migation failed when updating a table
  • Next by thread: Re: Migation failed when updating a table
  • Index(es):
    • Date
    • Thread