• 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: Migrations not executed at startup problem (SOLVED)
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Migrations not executed at startup problem (SOLVED)

  • Subject: Re: Migrations not executed at startup problem (SOLVED)
  • From: John Huss <email@hidden>
  • Date: Wed, 06 Apr 2011 13:12:49 -0500
Or move your own startup code to finishInitialization() instead.

On Wed, Apr 6, 2011 at 1:07 PM, Miguel Angel Torres Avila <email@hidden> wrote:
Thanks Chuck, Paul and Mike for your help

The principal problem was that Migrations functionality is called automatically after my own code that loads some info from de data base, so if the migration has changes in a table that is considered in my code the app crashes before the migration occurs.

The solution is to add the Chuck's code before everything else in the constructor of my Application class.

if (ERXMigrator.shouldMigrateAtStartup())
            {
                try
                {
                    migrator().migrateToLatest();
                }
                catch (ERXMigrationFailedException e)
                {
                    // It might be a missing plugin problem
                    new ERXJDBCConnectionAnalyzer(databaseConnectionDictionary());
                    throw e;
                }
            }



On Apr 6, 2011, at 12:51 PM, Paul D Yu wrote:

Look at the _dbupdater table in your database.

It should have a row in there with your EOModel name in it;  set the version back to null.

Paul

On Apr 6, 2011, at 1:43 PM, Mike Schrag wrote:

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@hidden
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@hidden)

This email sent to email@hidden

-- 
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@hidden)





_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)

This email sent to email@hidden

_______________________________________________
Do not post admin requests to the list. They will be ignored.

This email sent to email@hidden

_______________________________________________
Do not post admin requests to the list. They will be ignored.

This email sent to email@hidden

_______________________________
Ing. Miguel Angel Torres Avila
Director General
Tel: +52 (33) 3367 1892
Cel: +52 (33) 3106 8758
E-mail: email@hidden
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@hidden)
Help/Unsubscribe/Update your Subscription:

This 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: Migrations not executed at startup problem (SOLVED)
      • From: Miguel Angel Torres Avila <email@hidden>
References: 
 >Migrations not executed at startup problem (From: Miguel Angel Torres Avila <email@hidden>)
 >Re: Migrations not executed at startup problem (From: Chuck Hill <email@hidden>)
 >Re: Migrations not executed at startup problem (From: Paul D Yu <email@hidden>)
 >Re: Migrations not executed at startup problem (From: Miguel Angel Torres Avila <email@hidden>)
 >Re: Migrations not executed at startup problem (From: Mike Schrag <email@hidden>)
 >Re: Migrations not executed at startup problem (From: Paul D Yu <email@hidden>)
 >Re: Migrations not executed at startup problem (SOLVED) (From: Miguel Angel Torres Avila <email@hidden>)

  • Prev by Date: Re: Migrations not executed at startup problem (SOLVED)
  • Next by Date: Re: Migrations not executed at startup problem (SOLVED)
  • Previous by thread: Re: Migrations not executed at startup problem (SOLVED)
  • Next by thread: Re: Migrations not executed at startup problem (SOLVED)
  • Index(es):
    • Date
    • Thread