DOC LONGBLOB, ENCODING VARCHAR(20),
ANNEE_GESTION INTEGER,
INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
- INDEX IX_EDMN_DOC_ANNEE_GESTION(COLLECTIVITE,BUDGET,ANNEE_GESTION),
+ INDEX IX_EDMN2012_DOC_ANNEE_GESTION(COLLECTIVITE,BUDGET,ANNEE_GESTION),
ARCHIVE_NAME VARCHAR(100), INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM
</table>
+
<table type="index" id="T1" base-name="EDMN_2012_ETATEDMN_IX" version="2" main="true">
CREATE TABLE IF NOT EXISTS ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL,
<sql failonerror="false">ALTER TABLE ${base-name} ADD IMPUTATION VARCHAR(1)</sql>
</patch>
</table>
- <table id="T2" base-name="EDMN_2012_LIASSES_IX" type="index" version="2" based-on="key1">
+
+ <table id="T2" base-name="EDMN_2012_LIASSES_IX" type="index" version="3" based-on="key1">
CREATE TABLE IF NOT EXISTS ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL,
BUDGET VARCHAR(24) NOT NULL,
INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
INDEX IX_${base-name}_DC (DOC_ID),
INDEX ${base-name}_NODEID (NODEID),
- INDEX IX_EDMN_ETATEDMN_LIASSES_ANGEST (COLLECTIVITE,BUDGET,ANNEE_GESTION),
- INDEX IX_EDMN_ETATEDMN_LIASSES_LIASSE_CENTRALE (NUM_LIASSE),
+ INDEX IX_${base-name}_ANGEST (COLLECTIVITE,BUDGET,ANNEE_GESTION),
+ INDEX IX_${base-name}_LIASSES_LIASSE_CENTRALE (NUM_LIASSE),
INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM
<patch from-version="1">
<sql failonerror="false">ALTER TABLE ${base-name} ADD NODEID VARCHAR(10)</sql>
- </patch>
+ </patch>
+ <patch from-version="2">
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NODEID VARCHAR(10)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} DROP INDEX IX_EDMN_ETATEDMN_LIASSES_ANGEST</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} DROP INDEX IX_EDMN_ETATEDMN_LIASSES_LIASSE_CENTRALE</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD INDEX IX_${base-name}_ANGEST (COLLECTIVITE,BUDGET,ANNEE_GESTION)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD INDEX IX_${base-name}_LIASSE_CENTRALE (NUM_LIASSE)</sql>
+ </patch>
</table>
+
<table id="T3" base-name="EDMN_2012_PJ_IX" type="index" version="2" based-on="key2">
CREATE TABLE IF NOT EXISTS ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL,
</layer>
<layer name="oracle" persistence-model="xemelios-sql">
+
<document id="edmn2012" repository-import-xslt-file="">
+
<table base-name="EDMN_2012_SPECIAL_KEYS" type="special-key" version="1">
<sql xml:space="preserve">
CREATE TABLE ${base-name} (
<sql>CREATE INDEX ${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET)</sql>
<sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql>
</table>
- <table base-name="EDMN_LIST_BUDG_COLL" type="list-bc" version="1">
+
+ <table base-name="EDMN_2012_LIST_BUDG_COLL" type="list-bc" version="1">
<sql xml:space="preserve">
CREATE TABLE ${base-name} (
BUDGET VARCHAR(1000) NOT NULL,
ANNEE_GESTION NUMBER,
INITIAL_DOC_NAME VARCHAR(1000) NOT NULL )
</sql>
- <sql>CREATE INDEX ${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql>
- <sql>CREATE INDEX EDMN_DOC_ANNEE_GESTION ON ${base-name} (COLLECTIVITE,BUDGET,ANNEE_GESTION)</sql>
- <sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql>
+ <sql>CREATE INDEX EDMN2012_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql>
+ <sql>CREATE INDEX EDMN2012_DOC_AG ON ${base-name} (COLLECTIVITE,BUDGET,ANNEE_GESTION)</sql>
+ <sql>CREATE INDEX EDMN2012_AN ON ${base-name} (ARCHIVE_NAME)</sql>
</table>
<table base-name="EDMN_2012_ETAT" id="T1" type="index" main="true" version="2">
<sql xml:space="preserve">
TRIMESTRE NUMBER,
IMPUTATION VARCHAR(1) )
</sql>
- <sql>CREATE INDEX ETATEDMN_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql>
- <sql>CREATE INDEX ETATEDMN_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql>
- <sql>CREATE INDEX ETATEDMN_AN ON ${base-name} (ARCHIVE_NAME)</sql>
- <sql>CREATE INDEX ETATEDMN_NODEID ON ${base-name} (NODEID)</sql>
- <sql>CREATE INDEX ETATEDMN_CODEEVT ON ${base-name} (CODEEVT)</sql>
- <sql>CREATE INDEX ETATEDMN_TYPEPCE ON ${base-name} (TYPEPCE)</sql>
- <sql>CREATE INDEX ETATEDMN_DESIGNTYPE ON ${base-name} (DESIGNTYPE)</sql>
- <sql>CREATE INDEX ETATEDMN_SOCIETE ON ${base-name} (SOCIETE)</sql>
- <sql>CREATE INDEX ETATEDMN_NOMSOC ON ${base-name} (NOMSOCIETE)</sql>
- <sql>CREATE INDEX ETATEDMN_NUMPCEFI ON ${base-name} (NUMPIECEFI)</sql>
- <sql>CREATE INDEX ETATEDMN_POSTE ON ${base-name} (POSTE)</sql>
- <sql>CREATE INDEX ETATEDMN_EXECOMPTA ON ${base-name} (EXERCICECOMPTA)</sql>
- <sql>CREATE INDEX ETATEDMN_REFFIN ON ${base-name} (REFERENCEFINANCIERE)</sql>
- <sql>CREATE INDEX ETATEDMN_TXTENTFIN ON ${base-name} (TXTENTETEFINANCIER)</sql>
- <sql>CREATE INDEX ETATEDMN_TXTFIN ON ${base-name} (TEXTEFINANCIER)</sql>
- <sql>CREATE INDEX ETATEDMN_MINBUDG ON ${base-name} (MINISTEREBUDGETAIRE)</sql>
- <sql>CREATE INDEX ETATEDMN_MINBUDGDES ON ${base-name} (MINISTEREBUDGETAIREDESIGN)</sql>
- <sql>CREATE INDEX ETATEDMN_DOMACT ON ${base-name} (DOMAINEACTIVITE)</sql>
- <sql>CREATE INDEX ETATEDMN_FOURNUM ON ${base-name} (FOURNISSEURNUM)</sql>
- <sql>CREATE INDEX ETATEDMN_FOURNOM ON ${base-name} (FOURNISSEURNOM)</sql>
- <sql>CREATE INDEX ETATEDMN_FOURSIRET ON ${base-name} (FOURNISSEURSIRET)</sql>
- <sql>CREATE INDEX ETATEDMN_BENEFNUM ON ${base-name} (BENEFICIAIRENUM)</sql>
- <sql>CREATE INDEX ETATEDMN_BENEFNOM ON ${base-name} (BENEFICIAIRENOM)</sql>
- <sql>CREATE INDEX ETATEDMN_BENEFSIRET ON ${base-name} (BENEFICIAIRESIRET)</sql>
- <sql>CREATE INDEX ETATEDMN_RIBPAYS ON ${base-name} (RIBPAYS)</sql>
- <sql>CREATE INDEX ETATEDMN_RIBBANC ON ${base-name} (RIBBANC)</sql>
- <sql>CREATE INDEX ETATEDMN_RIBCOMPTE ON ${base-name} (RIBCOMPTE)</sql>
- <sql>CREATE INDEX ETATEDMN_RIBCLE ON ${base-name} (RIBCLE)</sql>
- <sql>CREATE INDEX ETATEDMN_CPTEPCE ON ${base-name} (COMPTEPCE)</sql>
- <sql>CREATE INDEX ETATEDMN_LIBPCE ON ${base-name} (LIBELLEPCE)</sql>
- <sql>CREATE INDEX ETATEDMN_DEBCRED ON ${base-name} (DEBITCREDITPCE)</sql>
- <sql>CREATE INDEX ETATEDMN_CPTEBUDG ON ${base-name} (COMPTEBUDG)</sql>
- <sql>CREATE INDEX ETATEDMN_DTECOMPTA ON ${base-name} (DATECOMPTABLE)</sql>
- <sql>CREATE INDEX ETATEDMN_DTEPAIE ON ${base-name} (DATEPAIEMENT)</sql>
- <sql>CREATE INDEX ETATEDMN_MT ON ${base-name} (MTPCE)</sql>
- <sql>CREATE INDEX ETATEDMN_DOMFONC ON ${base-name} (DOMAINEFONCTIONNEL)</sql>
- <sql>CREATE INDEX ETATEDMN_CENTFIN ON ${base-name} (CENTREFINANCIER)</sql>
- <sql>CREATE INDEX ETATEDMN_DESIGNFIN ON ${base-name} (DESIGNATIONFINANCIER)</sql>
- <sql>CREATE INDEX ETATEDMN_CENTCOUT ON ${base-name} (CENTRECOUT)</sql>
- <sql>CREATE INDEX ETATEDMN_CENTCOUTDES ON ${base-name} (CENTRECOUTDESIGN)</sql>
- <sql>CREATE INDEX ETATEDMN_TYPEJ ON ${base-name} (TYPEEJ)</sql>
- <sql>CREATE INDEX ETATEDMN_TYPEJDES ON ${base-name} (TYPEEJDESIGN)</sql>
- <sql>CREATE INDEX ETATEDMN_NUMEJ ON ${base-name} (NUMEJ)</sql>
- <sql>CREATE INDEX ETATEDMN_NUMEJLONG ON ${base-name} (NUMEJLONG)</sql>
- <sql>CREATE INDEX ETATEDMN_DTEEJ ON ${base-name} (DATEEJ)</sql>
- <sql>CREATE INDEX ETATEDMN_TYPECR ON ${base-name} (TYPEECRITURE)</sql>
- <sql>CREATE INDEX ETATEDMN_PERFIN ON ${base-name} (PERIMFINANCIER)</sql>
- <sql>CREATE INDEX ETATEDMN_SEREXEC ON ${base-name} (SERVEXEC)</sql>
- <sql>CREATE INDEX ETATEDMN_PJ ON ${base-name} (PJ)</sql>
- <sql>CREATE INDEX ETATEDMN_ESPCE ON ${base-name} (ESPACEMENT)</sql>
- <sql>CREATE INDEX ETATEDMN_COMPT ON ${base-name} (COMPTABLE)</sql>
- <sql>CREATE INDEX ETATEDMN_LIBCOMPT ON ${base-name} (LIBELLECOMPTABLE)</sql>
- <sql>CREATE INDEX ETATEDMN_NUMLIASSEDEB ON ${base-name} (NUMLIASSEDEB)</sql>
- <sql>CREATE INDEX ETATEDMN_NUMLIASSEFIN ON ${base-name} (NUMLIASSEFIN)</sql>
- <sql>CREATE INDEX ETATEDMN_ANNEE ON ${base-name} (ANNEE)</sql>
- <sql>CREATE INDEX ETATEDMN_MOIS ON ${base-name} (MOIS)</sql>
- <sql>CREATE INDEX ETATEDMN_TRIM ON ${base-name} (TRIMESTRE)</sql>
- <sql>CREATE INDEX ETATEDMN_IMP ON ${base-name} (IMPUTATION)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_AN ON ${base-name} (ARCHIVE_NAME)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_NODEID ON ${base-name} (NODEID)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_CODEEVT ON ${base-name} (CODEEVT)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_TYPEPCE ON ${base-name} (TYPEPCE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_DESIGNTYPE ON ${base-name} (DESIGNTYPE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_SOCIETE ON ${base-name} (SOCIETE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_NOMSOC ON ${base-name} (NOMSOCIETE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_NUMPCEFI ON ${base-name} (NUMPIECEFI)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_POSTE ON ${base-name} (POSTE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_EXECOMPTA ON ${base-name} (EXERCICECOMPTA)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_REFFIN ON ${base-name} (REFERENCEFINANCIERE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_TXTENTFIN ON ${base-name} (TXTENTETEFINANCIER)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_TXTFIN ON ${base-name} (TEXTEFINANCIER)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_MINBUDG ON ${base-name} (MINISTEREBUDGETAIRE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_MINBUDGDES ON ${base-name} (MINISTEREBUDGETAIREDESIGN)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_DOMACT ON ${base-name} (DOMAINEACTIVITE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_FOURNUM ON ${base-name} (FOURNISSEURNUM)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_FOURNOM ON ${base-name} (FOURNISSEURNOM)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_FOURSIRET ON ${base-name} (FOURNISSEURSIRET)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_BENEFNUM ON ${base-name} (BENEFICIAIRENUM)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_BENEFNOM ON ${base-name} (BENEFICIAIRENOM)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_BENEFSIRET ON ${base-name} (BENEFICIAIRESIRET)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_RIBPAYS ON ${base-name} (RIBPAYS)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_RIBBANC ON ${base-name} (RIBBANC)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_RIBCOMPTE ON ${base-name} (RIBCOMPTE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_RIBCLE ON ${base-name} (RIBCLE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_CPTEPCE ON ${base-name} (COMPTEPCE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_LIBPCE ON ${base-name} (LIBELLEPCE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_DEBCRED ON ${base-name} (DEBITCREDITPCE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_CPTEBUDG ON ${base-name} (COMPTEBUDG)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_DTECOMPTA ON ${base-name} (DATECOMPTABLE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_DTEPAIE ON ${base-name} (DATEPAIEMENT)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_MT ON ${base-name} (MTPCE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_DOMFONC ON ${base-name} (DOMAINEFONCTIONNEL)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_CENTFIN ON ${base-name} (CENTREFINANCIER)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_DESIGNFIN ON ${base-name} (DESIGNATIONFINANCIER)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_CENTCOUT ON ${base-name} (CENTRECOUT)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_CENTCOUTDES ON ${base-name} (CENTRECOUTDESIGN)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_TYPEJ ON ${base-name} (TYPEEJ)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_TYPEJDES ON ${base-name} (TYPEEJDESIGN)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_NUMEJ ON ${base-name} (NUMEJ)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_NUMEJLONG ON ${base-name} (NUMEJLONG)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_DTEEJ ON ${base-name} (DATEEJ)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_TYPECR ON ${base-name} (TYPEECRITURE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_PERFIN ON ${base-name} (PERIMFINANCIER)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_SEREXEC ON ${base-name} (SERVEXEC)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_PJ ON ${base-name} (PJ)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_ESPCE ON ${base-name} (ESPACEMENT)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_COMPT ON ${base-name} (COMPTABLE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_LIBCOMPT ON ${base-name} (LIBELLECOMPTABLE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_NUMLIASSEDEB ON ${base-name} (NUMLIASSEDEB)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_NUMLIASSEFIN ON ${base-name} (NUMLIASSEFIN)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_ANNEE ON ${base-name} (ANNEE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_MOIS ON ${base-name} (MOIS)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_TRIM ON ${base-name} (TRIMESTRE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_IMP ON ${base-name} (IMPUTATION)</sql>
<patch from-version="1">
<sql>ALTER TABLE ${base-name} ADD IMPUTATION VARCHAR(1)</sql>
- <sql>CREATE INDEX ETATEDMN_IMP ON ${base-name} (IMPUTATION)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_IMP ON ${base-name} (IMPUTATION)</sql>
</patch>
</table>
<table base-name="EDMN_2012_ETAT_LIASSES" id="T2" type="index" based-on="key1" version="1">
<sql>CREATE INDEX ETATEDMN2012_LIASSE_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql>
<sql>CREATE INDEX ETATEDMN2012_LIASSE_DC ON ${base-name} (DOC_ID)</sql>
<sql>CREATE INDEX ETATEDMN2012_LIASSE_NODEID ON ${base-name} (NODEID)</sql>
- <sql>CREATE INDEX LIASSE_ANNEE_GEST ON ${base-name} (COLLECTIVITE,BUDGET,ANNEE_GESTION)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_LIASSE_AG ON ${base-name} (COLLECTIVITE,BUDGET,ANNEE_GESTION)</sql>
<sql>CREATE INDEX ETATEDMN2012_LIASSE_CENTRALE ON ${base-name} (NUM_LIASSE)</sql>
<sql>CREATE INDEX ETATEDMN2012_LIASSE_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql>
<sql>CREATE INDEX ETATEDMN2012_LIASSE_AN ON ${base-name} (ARCHIVE_NAME)</sql>
String[] els = line.split(";");
for (int i = 0; i < 12; i++)
if(i==4){ // code ministere
- ps.setString(i + 1, new StringBuilder("MIN").append(els[i]).toString());
+ ps.setString(i + 1, new StringBuilder("MIN").append(els[i]).toString()); // Ajout du MIN au code ministere du fichier de patch car il est manquant
} else {
ps.setString(i + 1, els[i]);
}
- logger.debug("inserting ["+els[0]+","+els[1]+","+els[2]+","+els[3]+","+els[4]+","+els[5]+"]");
+ //logger.debug("inserting ["+els[0]+","+els[1]+","+els[2]+","+els[3]+","+els[4]+","+els[5]+"]");
ps.executeUpdate();
line = br.readLine();
}
rs.next();
int rows = rs.getInt(1);
- logger.debug("Nombre de ligne à patcher" + rows);
+ logger.debug("Nombre de ligne EDMN à patcher : " + rows);
getImportServiceProvider().endLongWait();
br.close();
psLiassesLocales.setString(2, budget);
psLiassesLocales.setString(3, docId);
ResultSet rsLiasses = psLiassesLocales.executeQuery();
+
if (rsLiasses.next()) {
String comptable = rsLiasses.getString(1);
String imputation = rsLiasses.getString(2);
- String ministere = new StringBuilder("MIN").append(rsLiasses.getString(3)).toString(); // TODO : Ajout du MIN au code ministere du patch
+ String ministere = new StringBuilder("MIN").append(rsLiasses.getString(3)).toString(); // Ajout du MIN au code ministere du patch
String annee = rsLiasses.getString(4);
String trimestre = rsLiasses.getString(5);
String numLiasseDeb = rsLiasses.getString(6);
String sql = queryProvider.getQuery("selectIndexPatch").replace("{:liasse}", numLiasses);
PreparedStatement ps = conPatch.prepareStatement(sql);
- ps.setString(1, annee.substring(2));
+ ps.setString(1, annee);
ps.setString(2, trimestre);
ps.setString(3, comptable);
ps.setString(4, imputation);
ps.setString(5, ministere);
ResultSet rs2 = ps.executeQuery();
- // logger.debug("querying ["+annee.substring(2)+","+trimestre+","+comptable+","+imputation+","+ministere+","+numLiasseDeb+","+numLiasseFin+"]");
+ logger.debug("selectIndexPatch ["+annee+","+trimestre+","+comptable+","+imputation+","+ministere+","+numLiasseDeb+","+numLiasseFin+"]");
// StringBuilder numLiassesNat = new StringBuilder();
ArrayList<Liasse> liasses = new ArrayList<Liasse>();
while (rs2.next()) {
rs2.close();
ps.close();
if (liasses.size() > 0) {
- // logger.debug("patching ["+collectivite+","+budget+","+docId+"]");
+ //logger.debug("patching ["+collectivite+","+budget+","+docId+"]");
// numLiassesNat.deleteCharAt(numLiassesNat.length()-1);
ps = con2.prepareStatement(queryProvider.getQuery("insertLiasse"));
ps.setString(1, collectivite);