Author: echatellier Date: 2012-05-15 11:53:13 +0200 (Tue, 15 May 2012) New Revision: 3421 Url: http://chorem.org/repositories/revision/lima/3421 Log: Correction migration : h2 index on clob Modified: trunk/lima-business/src/main/java/org/chorem/lima/business/migration/MigrationV0_6.java trunk/lima-callao/src/main/xmi/accounting.properties Modified: trunk/lima-business/src/main/java/org/chorem/lima/business/migration/MigrationV0_6.java =================================================================== --- trunk/lima-business/src/main/java/org/chorem/lima/business/migration/MigrationV0_6.java 2012-05-15 08:53:50 UTC (rev 3420) +++ trunk/lima-business/src/main/java/org/chorem/lima/business/migration/MigrationV0_6.java 2012-05-15 09:53:13 UTC (rev 3421) @@ -60,25 +60,26 @@ log.info("Migrates to version 0.6"); } - // delete computed fields - queries.add("Alter table FINANCIALTRANSACTION drop column AMOUNTDEBIT"); - queries.add("Alter table FINANCIALTRANSACTION drop column AMOUNTCREDIT"); + // migration from h2 to 1.3.166 not supporting index on clob + queries.add("Alter table account alter column accountnumber varchar"); - // model refactoring - queries.add("drop table record"); - + // add new columns queries.add("alter table account drop column masteraccount"); queries.add("alter table account drop column generalledger"); - + queries.add("alter table entry add column lettering varchar(30)"); queries.add("alter table financialtransaction drop column financialperiod"); - queries.add("alter table entry add column lettering varchar(30)"); + // perform some migration queries.add("update entry e set lettering = (select l.code from Letter l where l.topiaid = e.letter)"); + + // delete non necessary fields + queries.add("Alter table FINANCIALTRANSACTION drop column AMOUNTDEBIT"); + queries.add("Alter table FINANCIALTRANSACTION drop column AMOUNTCREDIT"); + queries.add("alter table vatstatement drop column amount"); queries.add("alter table entry drop column letter"); + + // delete tables + queries.add("drop table record"); queries.add("drop table letter"); - - queries.add("alter table vatstatement drop column amount"); - - } } Modified: trunk/lima-callao/src/main/xmi/accounting.properties =================================================================== --- trunk/lima-callao/src/main/xmi/accounting.properties 2012-05-15 08:53:50 UTC (rev 3420) +++ trunk/lima-callao/src/main/xmi/accounting.properties 2012-05-15 09:53:13 UTC (rev 3421) @@ -49,7 +49,7 @@ # lazy org.chorem.lima.entity.Entry.attribute.account.tagvalue.lazy=false org.chorem.lima.entity.FinancialTransaction.attribute.entry.tagvalue.lazy=false -org.chorem.lima.entity.FinancialTransaction.attribute.entrybook.tagvalue.lazy=false +org.chorem.lima.entity.FinancialTransaction.attribute.entryBook.tagvalue.lazy=false org.chorem.lima.entity.FinancialStatement.attribute.subFinancialStatements.tagvalue.lazy=false org.chorem.lima.entity.FinancialStatement.attribute.masterFinancialStatement.tagvalue.lazy=false org.chorem.lima.entity.VatStatement.attribute.subVatStatements.tagvalue.lazy=false