I forgto to mention that name the new migrationClass1
G
On 20.11.2008, at 18:47, Gustavo Pizano wrote:
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 [EMAIL PROTECTED]
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46)
DEBUG NSLog - Using JDBCPlugIn
'com.webobjects.jdbcadaptor._FrontBasePlugIn' for [EMAIL PROTECTED]
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46)
DEBUG NSLog - Using JDBCPlugIn
'com.webobjects.jdbcadaptor._FrontBasePlugIn' for [EMAIL PROTECTED]
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46)
DEBUG NSLog - connecting with dictionary: {password = "<password
deleted for log>"; username = "gustavpicora"; URL =
"jdbc:FrontBase://localhost/StockManager"; }
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 [EMAIL PROTECTED]
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46)
DEBUG NSLog - fetching JDBC Info with [EMAIL PROTECTED]
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46)
DEBUG NSLog - connecting with dictionary: {password = "<password
deleted for log>"; username = "gustavpicora"; URL =
"jdbc:FrontBase://localhost/StockManager"; }
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 [EMAIL PROTECTED]
Nov 20 18:37:19 StockManager[1250] (ERXNSLogLog4jBridge.java:46)
DEBUG NSLog - connecting with dictionary: {password = "<password
deleted for log>"; username = "gustavpicora"; URL =
"jdbc:FrontBase://localhost/StockManager"; }
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 [EMAIL PROTECTED]
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
'[EMAIL PROTECTED]'
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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
