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]
_______________________________________________
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]
