More than likely you've already run once, and the migration did nothing, so it
succeeded, and it's not going to run it again unless you modify the data in the
migration version table to reset it back.
On Apr 6, 2011, at 1:24 PM, Miguel Angel Torres Avila wrote:
> Thanks Paul
>
> For some reason the code inside the upgrade class is never called.
>
> I think I should mistyped something. I am checking now.
>
>
> On Apr 6, 2011, at 12:16 PM, Paul D Yu wrote:
>
>> Miguel
>>
>> You will need to call the external sql script from inside of your
>> Migration.java file.
>>
>> @Override
>> public void upgrade(EOEditingContext editingContext,
>> ERXMigrationDatabase database) throws Throwable {
>>
>> ERXJDBCUtilities.executeUpdateScriptFromResourceNamed(database.adaptorChannel(),
>> "DInAdminEOModel1_Postgresql_Upgrade.migration", "DIModelFramework");
>> }
>>
>> Something like that?
>>
>> Paul
>> On Apr 6, 2011, at 1:07 PM, Chuck Hill wrote:
>>
>>> Is this a "full" Wonder app, extending ERXApplication? If not, you need to
>>> initiate the migration:
>>>
>>> if (ERXMigrator.shouldMigrateAtStartup())
>>> {
>>> try
>>> {
>>> migrator().migrateToLatest();
>>> }
>>> catch (ERXMigrationFailedException e)
>>> {
>>> // It might be a missing plugin problem
>>> new
>>> ERXJDBCConnectionAnalyzer(databaseConnectionDictionary());
>>> throw e;
>>> }
>>> }
>>>
>>> Chuck
>>>
>>>
>>> On Apr 6, 2011, at 9:47 AM, Miguel Angel Torres Avila wrote:
>>>
>>>> Hi all,
>>>>
>>>> I am trying to implement Migrations in an existing Application.
>>>>
>>>> I followed the instructions in this page:
>>>>
>>>> http://webobjects.mdimension.com/hudson/job/Wonder/javadoc/er/extensions/migration/package-summary.html
>>>>
>>>> and this one
>>>>
>>>> http://webobjects.mdimension.com/hudson/job/Wonder/javadoc/er/extensions/migration/ERXMigration.html
>>>>
>>>> I think the steps are:
>>>>
>>>> 1. Modify properties file:
>>>>
>>>> # Migrations
>>>> er.migration.migrateAtStartup=true
>>>> er.migration.createTablesIfNecessary=true
>>>> er.migration.modelNames=DInAdminEOModel
>>>> er.extensions.migration.ERXMigration.useDatabaseSpecificMigrations=true
>>>>
>>>> DInAdminEOModel.InitialMigrationVersion=1
>>>> DInAdminEOModel.MigrationClassPrefix=com.toracom.app.migration.DInAdminEOModel
>>>>
>>>>
>>>> 2. Create class com.toracom.app.migration.DInAdminEOModel1.java
>>>>
>>>> /////// BEGIN CLASS
>>>> package com.toracom.app.migration;
>>>>
>>>> import com.webobjects.eoaccess.EOAdaptorChannel;
>>>> import com.webobjects.eoaccess.EOModel;
>>>> import com.webobjects.eocontrol.EOEditingContext;
>>>> import com.webobjects.foundation.NSArray;
>>>>
>>>> import er.extensions.migration.ERXMigration;
>>>> import er.extensions.migration.ERXModelVersion;
>>>>
>>>> public class DInAdminEOModel1 extends ERXMigration {
>>>> public NSArray<ERXModelVersion> modelDependencies() {
>>>> return null;
>>>> }
>>>>
>>>>
>>>> @Override
>>>> public void upgrade(EOEditingContext editingContext, EOAdaptorChannel
>>>> channel, EOModel model) throws Throwable {
>>>>
>>>> }
>>>>
>>>> @Override
>>>> public void downgrade(EOEditingContext editingContext,
>>>> EOAdaptorChannel channel, EOModel model) throws Throwable {
>>>> // TODO Auto-generated method stub
>>>>
>>>> }
>>>> }
>>>>
>>>> ////// END CLASS
>>>>
>>>>
>>>> 3. Create DInAdminEOModel1_Postgresql_Upgrade.migration file
>>>>
>>>> ALTER TABLE parametros ADD COLUMN modulo_cfdivault_habilitado varchar(5);
>>>> UDPATE parametros SET modulo_cfdivault_habilitado = 'false';
>>>> ALTER TABLE parametros ALTER COLUMN modulo_cfdivault_habilitado SET NOT
>>>> NULL;
>>>>
>>>>
>>>> When I run my application never get the SQL code executed. In the
>>>> Application class I load a Parametros entity but I get the following error
>>>>
>>>> Apr 06 11:38:11 dinadmin[55559] DEBUG NSLog - evaluateExpression:
>>>> <com.webobjects.jdbcadaptor.PostgresqlExpression: "SELECT DISTINCT
>>>> t0.directorio_raiz_procesamiento_cfd, t0.email_formato,
>>>> t0.encoding_archivo_fuente, t0.encoding_escritura_cfd,
>>>> t0.encoding_escritura_div_sol, t0.encoding_escritura_xml_co,
>>>> t0.encoding_escritura_xml_impresion, t0.encoding_lectura_jaxb,
>>>> t0.encoding_obtencion_co, t0.encoding_trans_co, t0.fh, t0.fhc,
>>>> t0.formato_fecha_dhtmlxgrid, t0.formato_numero_registro_bd,
>>>> t0.formato_numero_registro_bd_corto, t0.fsh, t0.fshnm, t0.iva,
>>>> t0.logs_debug, t0.logs_path, t0.logs_stdout, t0.metodo_impresion,
>>>> t0.modulo_cfdivault_habilitado, t0.moneda_id, t0.nd, t0.ne, t0.nm,
>>>> t0.nombre_aplicacion, t0.np, t0.ntc, t0.parametros_id, t0.retraso_daemon,
>>>> t0.rfc_fisica, t0.rfc_moral, t0.sistema_inicializado, t0.url_birt_viewer,
>>>> t0.version_comprobante FROM parametros t0" withBindings: >
>>>> Apr 06 11:38:11 dinadmin[55559] DEBUG NSLog - === Rollback Internal
>>>> Transaction
>>>> ERROR: column t0.modulo_cfdivault_habilitado does not existat
>>>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)
>>>> at
>>>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)
>>>> at
>>>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194)
>>>> at
>>>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
>>>> at
>>>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336)
>>>>
>>>>
>>>> Because the modulo_cfdivault_habilitado column does not exist, so the
>>>> migration's file is never executed.
>>>>
>>>> Am I missing something, maybe a missing Framework?
>>>>
>>>> Thanks in advance.
>>>>
>>>>
>>>> _______________________________
>>>> Ing. Miguel Angel Torres Avila
>>>> Director General
>>>> Tel: +52 (33) 3367 1892
>>>> Cel: +52 (33) 3106 8758
>>>> E-mail: [email protected]
>>>> www.toracom.net
>>>>
>>>> Antes de imprimir, piense en el Medio Ambiente. Before printing think
>>>> about the Environment. Avant d'imprimer, pensez à l'Environnement
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> 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/chill%40global-village.net
>>>>
>>>> This email sent to [email protected]
>>>
>>> --
>>> Chuck Hill Senior Consultant / VP Development
>>>
>>> Practical WebObjects - for developers who want to increase their overall
>>> knowledge of WebObjects or who are trying to solve specific problems.
>>> http://www.global-village.net/products/practical_webobjects
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> 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/pyu%40mac.com
>>>
>>> This email sent to [email protected]
>>
>
>
>
> _______________________________
> Ing. Miguel Angel Torres Avila
> Director General
> Tel: +52 (33) 3367 1892
> Cel: +52 (33) 3106 8758
> E-mail: [email protected]
> www.toracom.net
>
> Antes de imprimir, piense en el Medio Ambiente. Before printing think about
> the Environment. Avant d'imprimer, pensez à l'Environnement
>
>
>
>
>
> _______________________________________________
> 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/mschrag%40pobox.com
>
> This email sent to [email protected]
_______________________________________________
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]
