Gw Scheduler
Scopo
Funzionalità per schedulare facilmente l'esecuzione di codice contenuto in un qualunque file .groovy disponibile nei contenuti statici. Grazie a questo componente si possono schedulare task usando una apposita gwClass di Geoweb in gestione che modella definizioni di schedulazione.
Caratteristiche
- possibilità di definire più di una schedulazione per la stessa istanza di Geoweb, con impostazioni temporali distinte per ciascuna schedulazione.
- schedulazioni facilmente dispiegabili tramite file .groovy
- possibilità di attivare/disattivare la schedulazione da interfaccia utente
- possibilità di modificare i parametri temporali per la schedulazione da interfaccia utente
- le modifiche su attivazione/disattivazione e dei parametri temporali sono applicati istantaneamente
- senza dover riavviare il server od altro
- le esecuzioni di task in corso al momento del cambio parametri/disattivazione finiscono normalmente
Generalità
I trigger applicativi che stanno dietro la gwClass provvederanno a far si che le modifiche vengano applicate istantaneamente. Se si inserisce una schedule definition, con il flag enabled a true, essa verrà subito schedulata, e partirà secondo la configurazione. Se si modifica una schedule definition, le modifiche verranno applicate immediatamente (ma eventuali task attualmente in corso finiranno normalmente). Se si elimina una schedule definition dalla lista dei record della classe, quel task verrà rimosso dalla programmazione (ma eventuali task attualmente in corso finiranno normalmente).
Supporto Ambienti clusterizzati
Sono supportati gli ambienti clusterizzati dalla version 4.5.0. per ragioni di retrocompatibilità è necessario abilitare esplicitamente il flag gwscheduler.clusterMode.enabled=true nel configuration.properties. Inoltre bisogna aggiungere il field lock_end_time alla tabella gw_sched_def.
Limiti
Non utilizzabile in ambienti clusterizzati, dove ci sono più istanze di geoweb in versioni precedenti alla 4.5.0.
Per Iniziare
- class gw_sched_def Se necessario importarla usando i file .xml della classe o del tema
- aggiungere in un qualche progetto di configurazione questo leafitem
<leafItem name="gw_sched_def_test" label="gw_sched_def test" image="" type="gwClassList"> <parameter name="className" value="gw_sched_def" hideToClient="false"></parameter> </leafItem>
- assicurarsi che nel configuration.properties il flag gwscheduler.enabled non sia settato a false
################################################################## # G W S C H E D U L E R ################################################################## #toggle the gwSchedluer execution, optional, default true gwscheduler.enabled=false #toggle the support for cluster environment , optional, default false #is subordinate to the addition of the field 'lock_end_time' #to 'gw_sched_def' relation gwscheduler.clusterMode.enabled=false
Parametri gestiti dalla gwClass
I seguenti parametri sono configurabili e gestibili tramite l'interfaccia dell'apposita gwClass (vedi sotto) Geoweb:
- sched_def_name String, nome della definizione, deve essere univoco o verra lanciata un'eccezione
- script_name String, The .groovy file that will be executed (comprensive of .groovy extention, with the eventual relative path starting form 'WEB/groovy' folder existing in static contents
- enabled Integer, Toggle the script execution
- cron String, Cron Expression [must be of 6 slot]. It has priority on all other values (when provided all other parameters are simply ignored)
- start_time Date, When available it's used to give to execution a start time, maybe combined with period or delay values. if absent execution will start as soon as possible
- delay Integer, Delay after the last execution end (ms)
- period Integer,Period between two consecutive executions start (ms). Has priority over delay
- parameters_json String, this is the JSON string representation of the java.util.Map that will be available as incoming parameter inside the .groovy file, under name 'parameters'
I primi 3 parametri sono richiesti e sono comuni ad ogni definizione. I parametri cron, start_time, delay, period sono opzionali e vanno usati a seconda delle esigenze. Se ne puo impostare solo uno o combinarne due. Ci sono delle priorità nella valutazione di questi parametri.
Ordine di valutazione
- cron Schedule the given {@link Runnable}, invoking it whenever the trigger indicates a next execution time.
- both startTime and period Schedule the given {@link Runnable}, invoking it at the specified execution time and subsequently with the given period.
- both startTime and delay Schedule the given {@link Runnable}, invoking it at the specified execution time and subsequently with the given delay between the completion of one execution and the start of the next.
- only startTime Schedule the given {@link Runnable}, invoking it at the specified execution time. Execution will end once the scheduler shuts down or the returned
- only period Schedule the given {@link Runnable}, starting as soon as possible and invoking it with the given period.
- only delay Schedule the given {@link Runnable}, starting as soon as possible and invoking it with the given delay between the completion of one execution and the start of the next.
Note
La differenza tra period e delay è che il primo considera il tempo che passa tra l'avvio di un task ed il successivo, indipendentemente dal tempo necessario all'esecuzione del task, mentre delay conta il tempo a partire dalla fine della precedente esecuzione.
Nelle versioni piu recenti della gwClass di gestione delle schedulazione, nella UI di classe potrebbe esserci un cronExpGeneratorWidget. Esso genera però una cron da 7 slot, mentre il GwScheduler accetta cron expression nel formato da 6 slot. Bisogna quindi, una volta creata la cron expression, manualmente rimuovere l'ultimo * dalla fine dell'espressione:
Casi di utilizzo tipici
Eseguire un task ogni ora:
- settare period con l'equivalente dei ms presenti in un'ora (partirà appena schedulata, con enabled a true)
Eseguire un task ogni ora avendo controllo sulla precisa data di inizio:
- settare period con l'equivalente dei ms presenti in un'ora e start_time all'ora desiderata
Eseguire un task ogni ora con min 0 sec 0
- settare cron cosi: 0 0 0/1 * * *
Creazione programmatica di una schedulazione
Oltre che dalla UI di gestione si possono schedulare esecuzioni anche programmaticamente, da altri groovy.
import com.fasterxml.jackson.databind.ObjectMapper; .. def parameters = [:]; //CUSTOM PARAMETERS MAP parameter.param1 = "one"; parameter.param2 = 2; .. ObjectMapper mapper = new ObjectMapper(); String parameters_json= mapper.writeValueAsString(parameters); //GENERATING JSON .. //CREATING SCHED DEF def gwClassName = "gw_sched_def"; def rec = [:]; rec.sched_def_name = "sched_def_name"; rec.script_name = "script_name"; rec.enabled = true; rec.cron = "0 * * * * *"; //6 blocks cron expression rec.parameters_json = parameters_json; def itemId = classService.insertClassRecord(gwClassName , rec);
Class XML
- gwclass_gw_sched_def.xml
<list> <Class> <className>gw_sched_def</className> <label>Scheduler Definition</label> <description>Scheduler Definition</description> <note>GwClass usata per poter gestire definizioni di schedulazioni. I record inseriti in questa gwClass vengono valutati dal bean Spring GwScheduler durante la sua inizializzazione, che si preoccupa di schedulare l'esecuzione dello script groovy. Il trigger correlato alla gwClass si preoccupa invece di modificare al volo i parametri della schedulazione: attivo/disattivo, cron expression, start time, delay, period. Questo in caso di update, mentre in caso di delete la schedulazione verrà annullata In tutti i casi se una groovy è gia partito la sua esecuzione verrà comunque terminata anche in caso di update/delete della definizione della schedulazione</note> <author>GSC</author> <status>IN USE</status> <useType>STANDARD</useType> <version>1</version> <insertDate>2019-04-19 08:05:34.628 UTC</insertDate> <updateDate>2019-04-19 08:05:34.628 UTC</updateDate> <tableName>gw_sched_def</tableName> <type>0</type> <keyColumn>sched_def_id</keyColumn> <nameColumn>sched_def_name</nameColumn> <geomColumn> </geomColumn> <classOrder>1</classOrder> <hidden>0</hidden> <tableEditName>gw_sched_def</tableEditName> <geomKeyColumn>sched_def_id</geomKeyColumn> <layout>default</layout> <eventTrigger>com.geowebframework.webclient.scheduler.GwSchedDefTrigger</eventTrigger> <actionsList> <Action> <actionCode>standardListSelectedAllAttributeExportToExcel(queryParameter, grid)</actionCode> <name>exl_export_all_attributes</name> <label>Esporta in XLS</label> <description>Esporta tutti gli attributi in XLS</description> <author>GW</author> <version>1</version> <insertDate>2019-04-19 08:05:34.632 UTC</insertDate> <updateDate>2019-04-19 08:05:34.632 UTC</updateDate> <tooltip>Esporta in XLS</tooltip> <typology>1</typology> </Action> </actionsList> <attributeGroupList> <AttributeGroup> <description>main</description> <attributeList> <Attribute> <columnName>sched_def_name</columnName> <label>Schedulation Definition Name</label> <description>Schedulation Definition Name</description> <name>sched_def_name</name> <dataType>STRING</dataType> <listOrder>1</listOrder> <filterOrder>1</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>true</listed> <ctrlType>0</ctrlType> <ctrlParam> <width>250</width> <height>18</height> <maxLength>255</maxLength> <defaultValue></defaultValue> <required>true</required> <readonly>false</readonly> <scopeName></scopeName> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> </ctrlParam> </Attribute> <Attribute> <columnName>script_name</columnName> <label>Script Name (.groovy file)</label> <description>The .groovy file that will be executed (comprensive of .groovy extention, with the eventual relative path starting form 'WEB/groovy' folder existing in static contents</description> <name>script_name</name> <dataType>STRING</dataType> <listOrder>2</listOrder> <hidden>false</hidden> <filtered>false</filtered> <listed>true</listed> <ctrlType>0</ctrlType> <ctrlParam> <width>250</width> <height>18</height> <maxLength>255</maxLength> <defaultValue></defaultValue> <required>true</required> <readonly>false</readonly> <scopeName></scopeName> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> </ctrlParam> </Attribute> <Attribute> <columnName>enabled</columnName> <label>Enabled</label> <description>Toggle the script execution</description> <name>enabled</name> <dataType>INTEGER</dataType> <listOrder>3</listOrder> <filterOrder>2</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>true</listed> <ctrlType>6</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.CheckBox"> <width>250</width> <defaultValue>checked</defaultValue> <required>true</required> <readonly>false</readonly> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <handleThreeState>false</handleThreeState> <typeValue>1/0</typeValue> <labels>Yes/No</labels> </ctrlParam> </Attribute> <Attribute> <columnName>cron</columnName> <label>Cron Expression (6 digit)</label> <description>Cron expression must consist of 6 fields: seconds, minutes, hours, daysOfMonth, months, daysOfWeek. It has priority on all other values (when provided all other parameters are simply ignored)</description> <name>cron</name> <dataType>STRING</dataType> <listOrder>4</listOrder> <filterOrder>4</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>true</listed> <ctrlType>1</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.TextBox"> <width>250</width> <height>18</height> <listWidth>140</listWidth> <maxLength>255</maxLength> <defaultValue></defaultValue> <required>false</required> <readonly>false</readonly> <disabled>false</disabled> <hideRelations>false</hideRelations> <intermediateChanges>false</intermediateChanges> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <regExp></regExp> <regExpGen></regExpGen> <placeHolder>6 digit cron expressions</placeHolder> <promptMessage>Cron expression must consist of 6 fields: seconds, minutes, hours, daysOfMonth, months, daysOfWeek</promptMessage> <invalidMessage>Cron expression must consist of 6 fields: seconds, minutes, hours, daysOfMonth, months, daysOfWeek</invalidMessage> <missingMessage>A valid 6 digit cron expressions is required</missingMessage> <trim>true</trim> <lowercase>false</lowercase> <uppercase>false</uppercase> <propercase>false</propercase> </ctrlParam> </Attribute> <Attribute> <columnName>human_readable_cron</columnName> <label>Human Readable Cron Expression</label> <description>Human Readable Cron Expression</description> <name>human_readable_cron</name> <dataType>STRING</dataType> <filterOrder>3</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>false</listed> <ctrlType>16</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.Textarea"> <width>250</width> <height>40</height> <maxLength>255</maxLength> <defaultValue></defaultValue> <required>false</required> <readonly>true</readonly> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <DEFAULT__NUMROWS>0</DEFAULT__NUMROWS> <DEFAULT__NUMCOLS>0</DEFAULT__NUMCOLS> <DEFAULT__TYPE>0</DEFAULT__TYPE> <DEFAULT__MIN__WIDTH>0</DEFAULT__MIN__WIDTH> <DEFAULT__MAX__WIDTH>0</DEFAULT__MAX__WIDTH> <DEFAULT__MIN__HEIGHT>0</DEFAULT__MIN__HEIGHT> <DEFAULT__MAX__HEIGHT>0</DEFAULT__MAX__HEIGHT> <numRows>5</numRows> <numCols>50</numCols> <type>0</type> <maxWidth>250</maxWidth> <maxHeight>200</maxHeight> </ctrlParam> </Attribute> <Attribute> <columnName>start_time</columnName> <label>Start Time</label> <description>When available it's used to give to execution a start time, maybe combined with period or delay values. if absent execution will start as soon as possible</description> <name>start_time</name> <dataType>DATE</dataType> <listOrder>5</listOrder> <filterOrder>5</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>true</listed> <ctrlType>5</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.Date"> <width>250</width> <listWidth>120</listWidth> <defaultValue></defaultValue> <required>false</required> <readonly>false</readonly> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <format>dd-MM-yyyy</format> <formatTime>HH:mm:ss</formatTime> <handleTime>true</handleTime> </ctrlParam> </Attribute> <Attribute> <columnName>delay</columnName> <label>Delay (ms)</label> <description>Delay after the last execution end (ms)</description> <name>delay</name> <dataType>INTEGER</dataType> <listOrder>7</listOrder> <filterOrder>7</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>true</listed> <ctrlType>25</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.NumberBox"> <width>250</width> <height>18</height> <listWidth>100</listWidth> <defaultValue></defaultValue> <required>false</required> <readonly>false</readonly> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <numberFormatType>NUMBER</numberFormatType> <pattern>#.</pattern> <min>0.0</min> <max>1.7976931348623157E308</max> <currencyCode>EUR</currencyCode> </ctrlParam> </Attribute> <Attribute> <columnName>period</columnName> <label>Period (ms)</label> <description>Period between two consecutive executions start (ms). Has priority over delay</description> <name>period</name> <dataType>INTEGER</dataType> <listOrder>6</listOrder> <filterOrder>6</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>true</listed> <ctrlType>25</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.NumberBox"> <width>250</width> <height>18</height> <listWidth>100</listWidth> <defaultValue></defaultValue> <required>false</required> <readonly>false</readonly> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <numberFormatType>NUMBER</numberFormatType> <pattern>#.</pattern> <min>0.0</min> <max>1.7976931348623157E308</max> <currencyCode>EUR</currencyCode> </ctrlParam> </Attribute> <Attribute> <columnName>parameters_json</columnName> <label>Parameters Json</label> <description>This is the JSON string representation of the java.util.Map that will be available as incoming parameter inside the .groovy file, under name 'parameters'</description> <name>parameters_json</name> <dataType>STRING</dataType> <hidden>false</hidden> <filtered>false</filtered> <listed>false</listed> <ctrlType>16</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.Textarea"> <width>250</width> <height>40</height> <maxLength>255</maxLength> <defaultValue></defaultValue> <required>false</required> <readonly>false</readonly> <disabled>false</disabled> <hideRelations>false</hideRelations> <intermediateChanges>false</intermediateChanges> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <DEFAULT__NUMROWS>0</DEFAULT__NUMROWS> <DEFAULT__NUMCOLS>0</DEFAULT__NUMCOLS> <DEFAULT__TYPE>0</DEFAULT__TYPE> <DEFAULT__MIN__WIDTH>0</DEFAULT__MIN__WIDTH> <DEFAULT__MAX__WIDTH>0</DEFAULT__MAX__WIDTH> <DEFAULT__MIN__HEIGHT>0</DEFAULT__MIN__HEIGHT> <DEFAULT__MAX__HEIGHT>0</DEFAULT__MAX__HEIGHT> <numRows>5</numRows> <numCols>50</numCols> <type>0</type> <maxWidth>250</maxWidth> <maxHeight>200</maxHeight> </ctrlParam> </Attribute> </attributeList> </AttributeGroup> </attributeGroupList> <attributesWithNoGroupList> <Attribute> <columnName>sched_def_id</columnName> <label>Schedulation Definition ID</label> <description>Schedulation Definition ID</description> <name>sched_def_id</name> <dataType>INTEGER</dataType> <filtered>false</filtered> <listed>false</listed> <ctrlType>25</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.NumberBox"> <width>250</width> <height>18</height> <defaultValue></defaultValue> <required>false</required> <readonly>false</readonly> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <numberFormatType>NUMBER</numberFormatType> <pattern>#.</pattern> <min>0.0</min> <max>1.7976931348623157E308</max> <currencyCode>EUR</currencyCode> </ctrlParam> </Attribute> </attributesWithNoGroupList> <detailLayoutsList> <DetailLayout> <name>default</name> <layout class="ContainerNode" type="ContentPane" width="500" widthUOM="px" height="450" heightUOM="px" title="main" startSelectedInParent="false" attributeGroup="main"/> </DetailLayout> </detailLayoutsList> <hasDynamicAcl>false</hasDynamicAcl> <gwVersion>4.4.0</gwVersion> </Class> </list>
Theme XML
- gwtheme_gw_scheduler.xml
<list> <Theme> <name>GW - Scheduler</name> <description>GW - Scheduler</description> <hidden>0</hidden> <classesList> <Class> <className>gw_sched_def</className> <label>Scheduler Definition</label> <description>Scheduler Definition</description> <note>GwClass usata per poter gestire definizioni di schedulazioni. I record inseriti in questa gwClass vengono valutati dal bean Spring GwScheduler durante la sua inizializzazione, che si preoccupa di schedulare l'esecuzione dello script groovy. Il trigger correlato alla gwClass si preoccupa invece di modificare al volo i parametri della schedulazione: attivo/disattivo, cron expression, start time, delay, period. Questo in caso di update, mentre in caso di delete la schedulazione verrà annullata In tutti i casi se una groovy è gia partito la sua esecuzione verrà comunque terminata anche in caso di update/delete della definizione della schedulazione</note> <author>GSC</author> <status>IN USE</status> <useType>STANDARD</useType> <version>1</version> <insertDate>2019-04-19 08:05:34.628 UTC</insertDate> <updateDate>2019-04-19 08:05:34.628 UTC</updateDate> <tableName>gw_sched_def</tableName> <type>0</type> <keyColumn>sched_def_id</keyColumn> <nameColumn>sched_def_name</nameColumn> <geomColumn> </geomColumn> <classOrder>1</classOrder> <hidden>0</hidden> <tableEditName>gw_sched_def</tableEditName> <geomKeyColumn>sched_def_id</geomKeyColumn> <layout>default</layout> <eventTrigger>com.geowebframework.webclient.scheduler.GwSchedDefTrigger</eventTrigger> <actionsList> <Action> <actionCode>standardListSelectedAllAttributeExportToExcel(queryParameter, grid)</actionCode> <name>exl_export_all_attributes</name> <label>Esporta in XLS</label> <description>Esporta tutti gli attributi in XLS</description> <author>GW</author> <version>1</version> <insertDate>2019-04-19 08:05:34.632 UTC</insertDate> <updateDate>2019-04-19 08:05:34.632 UTC</updateDate> <tooltip>Esporta in XLS</tooltip> <typology>1</typology> </Action> </actionsList> <attributeGroupList> <AttributeGroup> <description>main</description> <attributeList> <Attribute> <columnName>sched_def_name</columnName> <label>Schedulation Definition Name</label> <description>Schedulation Definition Name</description> <name>sched_def_name</name> <dataType>STRING</dataType> <listOrder>1</listOrder> <filterOrder>1</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>true</listed> <ctrlType>0</ctrlType> <ctrlParam> <width>250</width> <height>18</height> <maxLength>255</maxLength> <defaultValue></defaultValue> <required>true</required> <readonly>false</readonly> <scopeName></scopeName> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> </ctrlParam> </Attribute> <Attribute> <columnName>script_name</columnName> <label>Script Name (.groovy file)</label> <description>The .groovy file that will be executed (comprensive of .groovy extention, with the eventual relative path starting form 'WEB/groovy' folder existing in static contents</description> <name>script_name</name> <dataType>STRING</dataType> <listOrder>2</listOrder> <hidden>false</hidden> <filtered>false</filtered> <listed>true</listed> <ctrlType>0</ctrlType> <ctrlParam> <width>250</width> <height>18</height> <maxLength>255</maxLength> <defaultValue></defaultValue> <required>true</required> <readonly>false</readonly> <scopeName></scopeName> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> </ctrlParam> </Attribute> <Attribute> <columnName>enabled</columnName> <label>Enabled</label> <description>Toggle the script execution</description> <name>enabled</name> <dataType>INTEGER</dataType> <listOrder>3</listOrder> <filterOrder>2</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>true</listed> <ctrlType>6</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.CheckBox"> <width>250</width> <defaultValue>checked</defaultValue> <required>true</required> <readonly>false</readonly> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <handleThreeState>false</handleThreeState> <typeValue>1/0</typeValue> <labels>Yes/No</labels> </ctrlParam> </Attribute> <Attribute> <columnName>cron</columnName> <label>Cron Expression (6 digit)</label> <description>Cron expression must consist of 6 fields: seconds, minutes, hours, daysOfMonth, months, daysOfWeek. It has priority on all other values (when provided all other parameters are simply ignored)</description> <name>cron</name> <dataType>STRING</dataType> <listOrder>4</listOrder> <filterOrder>4</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>true</listed> <ctrlType>1</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.TextBox"> <width>250</width> <height>18</height> <listWidth>140</listWidth> <maxLength>255</maxLength> <defaultValue></defaultValue> <required>false</required> <readonly>false</readonly> <disabled>false</disabled> <hideRelations>false</hideRelations> <intermediateChanges>false</intermediateChanges> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <regExp></regExp> <regExpGen></regExpGen> <placeHolder>6 digit cron expressions</placeHolder> <promptMessage>Cron expression must consist of 6 fields: seconds, minutes, hours, daysOfMonth, months, daysOfWeek</promptMessage> <invalidMessage>Cron expression must consist of 6 fields: seconds, minutes, hours, daysOfMonth, months, daysOfWeek</invalidMessage> <missingMessage>A valid 6 digit cron expressions is required</missingMessage> <trim>true</trim> <lowercase>false</lowercase> <uppercase>false</uppercase> <propercase>false</propercase> </ctrlParam> </Attribute> <Attribute> <columnName>human_readable_cron</columnName> <label>Human Readable Cron Expression</label> <description>Human Readable Cron Expression</description> <name>human_readable_cron</name> <dataType>STRING</dataType> <filterOrder>3</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>false</listed> <ctrlType>16</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.Textarea"> <width>250</width> <height>40</height> <maxLength>255</maxLength> <defaultValue></defaultValue> <required>false</required> <readonly>true</readonly> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <DEFAULT__NUMROWS>0</DEFAULT__NUMROWS> <DEFAULT__NUMCOLS>0</DEFAULT__NUMCOLS> <DEFAULT__TYPE>0</DEFAULT__TYPE> <DEFAULT__MIN__WIDTH>0</DEFAULT__MIN__WIDTH> <DEFAULT__MAX__WIDTH>0</DEFAULT__MAX__WIDTH> <DEFAULT__MIN__HEIGHT>0</DEFAULT__MIN__HEIGHT> <DEFAULT__MAX__HEIGHT>0</DEFAULT__MAX__HEIGHT> <numRows>5</numRows> <numCols>50</numCols> <type>0</type> <maxWidth>250</maxWidth> <maxHeight>200</maxHeight> </ctrlParam> </Attribute> <Attribute> <columnName>start_time</columnName> <label>Start Time</label> <description>When available it's used to give to execution a start time, maybe combined with period or delay values. if absent execution will start as soon as possible</description> <name>start_time</name> <dataType>DATE</dataType> <listOrder>5</listOrder> <filterOrder>5</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>true</listed> <ctrlType>5</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.Date"> <width>250</width> <listWidth>120</listWidth> <defaultValue></defaultValue> <required>false</required> <readonly>false</readonly> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <format>dd-MM-yyyy</format> <formatTime>HH:mm:ss</formatTime> <handleTime>true</handleTime> </ctrlParam> </Attribute> <Attribute> <columnName>delay</columnName> <label>Delay (ms)</label> <description>Delay after the last execution end (ms)</description> <name>delay</name> <dataType>INTEGER</dataType> <listOrder>7</listOrder> <filterOrder>7</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>true</listed> <ctrlType>25</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.NumberBox"> <width>250</width> <height>18</height> <listWidth>100</listWidth> <defaultValue></defaultValue> <required>false</required> <readonly>false</readonly> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <numberFormatType>NUMBER</numberFormatType> <pattern>#.</pattern> <min>0.0</min> <max>1.7976931348623157E308</max> <currencyCode>EUR</currencyCode> </ctrlParam> </Attribute> <Attribute> <columnName>period</columnName> <label>Period (ms)</label> <description>Period between two consecutive executions start (ms). Has priority over delay</description> <name>period</name> <dataType>INTEGER</dataType> <listOrder>6</listOrder> <filterOrder>6</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>true</listed> <ctrlType>25</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.NumberBox"> <width>250</width> <height>18</height> <listWidth>100</listWidth> <defaultValue></defaultValue> <required>false</required> <readonly>false</readonly> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <numberFormatType>NUMBER</numberFormatType> <pattern>#.</pattern> <min>0.0</min> <max>1.7976931348623157E308</max> <currencyCode>EUR</currencyCode> </ctrlParam> </Attribute> <Attribute> <columnName>parameters_json</columnName> <label>Parameters Json</label> <description>This is the JSON string representation of the java.util.Map that will be available as incoming parameter inside the .groovy file, under name 'parameters'</description> <name>parameters_json</name> <dataType>STRING</dataType> <hidden>false</hidden> <filtered>false</filtered> <listed>false</listed> <ctrlType>16</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.Textarea"> <width>250</width> <height>40</height> <maxLength>255</maxLength> <defaultValue></defaultValue> <required>false</required> <readonly>false</readonly> <disabled>false</disabled> <hideRelations>false</hideRelations> <intermediateChanges>false</intermediateChanges> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <DEFAULT__NUMROWS>0</DEFAULT__NUMROWS> <DEFAULT__NUMCOLS>0</DEFAULT__NUMCOLS> <DEFAULT__TYPE>0</DEFAULT__TYPE> <DEFAULT__MIN__WIDTH>0</DEFAULT__MIN__WIDTH> <DEFAULT__MAX__WIDTH>0</DEFAULT__MAX__WIDTH> <DEFAULT__MIN__HEIGHT>0</DEFAULT__MIN__HEIGHT> <DEFAULT__MAX__HEIGHT>0</DEFAULT__MAX__HEIGHT> <numRows>5</numRows> <numCols>50</numCols> <type>0</type> <maxWidth>250</maxWidth> <maxHeight>200</maxHeight> </ctrlParam> </Attribute> </attributeList> </AttributeGroup> </attributeGroupList> <attributesWithNoGroupList> <Attribute> <columnName>sched_def_id</columnName> <label>Schedulation Definition ID</label> <description>Schedulation Definition ID</description> <name>sched_def_id</name> <dataType>INTEGER</dataType> <filtered>false</filtered> <listed>false</listed> <ctrlType>25</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.NumberBox"> <width>250</width> <height>18</height> <defaultValue></defaultValue> <required>false</required> <readonly>false</readonly> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <numberFormatType>NUMBER</numberFormatType> <pattern>#.</pattern> <min>0.0</min> <max>1.7976931348623157E308</max> <currencyCode>EUR</currencyCode> </ctrlParam> </Attribute> </attributesWithNoGroupList> <detailLayoutsList> <DetailLayout> <name>default</name> <layout class="ContainerNode" type="ContentPane" width="500" widthUOM="px" height="450" heightUOM="px" title="main" startSelectedInParent="false" attributeGroup="main"/> </DetailLayout> </detailLayoutsList> <hasDynamicAcl>false</hasDynamicAcl> </Class> </classesList> <gwVersion>4.4.0</gwVersion> </Theme> </list>
SCRIPT
Oracle
- gw_sched_def_script_oracle.sql
CREATE TABLE "SCHEMA_NAME"."GW_SCHED_DEF" ( "SCHED_DEF_ID" NUMBER(*,0) NOT NULL ENABLE, "SCHED_DEF_NAME" VARCHAR2(250 BYTE), "CRON" VARCHAR2(4000 BYTE), "HUMAN_READABLE_CRON" VARCHAR2(4000 BYTE), "START_TIME" DATE, "DELAY" NUMBER(38,0), "PERIOD" NUMBER(38,0), "SCRIPT_NAME" VARCHAR2(250 BYTE), "PARAMETERS_JSON" VARCHAR2(4000 BYTE), "ENABLED" NUMBER(1,0), "LOCK_END_TIME" DATE, CONSTRAINT "GW_SCHED_DEF_PK" PRIMARY KEY ("SCHED_DEF_ID"), CONSTRAINT "GW_SCHED_DEF_UK" UNIQUE ("SCHED_DEF_NAME") );
Postgres
- gw_sched_def_script_postgres.sql
CREATE TABLE [PMA_DATI_GW].[GW_SCHED_DEF]( [SCHED_DEF_ID] [INT] IDENTITY(1,1) NOT NULL, [SCHED_DEF_NAME] [VARCHAR](100) NULL, [CRON] [VARCHAR](4000) NULL, [HUMAN_READABLE_CRON] [VARCHAR](4000) NULL, [START_TIME] [datetime] NULL, [DELAY] [INT] NULL, [PERIOD] [INT] NULL, [SCRIPT_NAME] [VARCHAR](250) NULL, [PARAMETERS_JSON] [VARCHAR](4000) NULL, [ENABLED] [INT] NULL, [lock_end_time] [datetime] NULL, CONSTRAINT [GW_SCHED_DEF_PK] PRIMARY KEY CLUSTERED ( [SCHED_DEF_ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO
SqlServer
- gw_sched_def_script_sqlserver.sql
CREATE TABLE [PMA_DATI_GW].[GW_SCHED_DEF]( [SCHED_DEF_ID] [INT] IDENTITY(1,1) NOT NULL, [SCHED_DEF_NAME] [VARCHAR](100) NULL, [CRON] [VARCHAR](4000) NULL, [HUMAN_READABLE_CRON] [VARCHAR](4000) NULL, [START_TIME] [datetime] NULL, [DELAY] [INT] NULL, [PERIOD] [INT] NULL, [SCRIPT_NAME] [VARCHAR](250) NULL, [PARAMETERS_JSON] [VARCHAR](4000) NULL, [ENABLED] [INT] NULL, [lock_end_time] [datetime] NULL, CONSTRAINT [GW_SCHED_DEF_PK] PRIMARY KEY CLUSTERED ( [SCHED_DEF_ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO
GwSchedDefTrigger - trigger applicativo predefinito
Di seguito l'implementazione predefinita del trigger applicativo. Nel caso si debba ricorrere ad una personalizzazione, impostare gw_sched_def.groovy come trigger applicativo, ed estendere GwSchedDefTrigger oppure modifcarne il codice sotto riportato:
GwSchedDefTrigger
- gw_sched_def.groovy
package com.geowebframework.webclient.scheduler; import java.util.Date; import java.util.HashMap; import java.util.List; import org.springframework.scheduling.support.CronTrigger; import com.geowebframework.dataservice.ListService; import com.geowebframework.dataservice.querybuilder.EventTrigger; import com.geowebframework.metadataservice.ClassService; import com.geowebframework.transfer.model.metadataservice.Class; public class GwSchedDefTrigger extends EventTrigger { //issue #565 public final static String PROPERTY_SCHED_DEF_ID = "sched_def_id"; public final static String PROPERTY_SCHED_DEF_NAME = "sched_def_name"; public final static String PROPERTY_ENABLED = "enabled"; public final static String PROPERTY_CRON = "cron"; public final static String PROPERTY_HUMAN_READABLE_CRON = "human_readable_cron"; public final static String PROPERTY_START_TIME = "start_time"; public final static String PROPERTY_PERIOD = "period"; public final static String PROPERTY_DELAY = "delay"; public final static String PROPERTY_LOCK_END_TIME = "lock_end_time"; //issue #1233 public BOOLEAN beforeInsert(HashMap<String,Object> valuesMap){ log.info("gwSchedDefTrigger - beforeInsert()"); log.info("valuesMap: "+valuesMap); String cron = (String) valuesMap.get(PROPERTY_CRON); IF(cron!=NULL){ String human_readable_cron = NULL; IF(!cron.trim().isEmpty()) { try { //testing cron expression: it's valid if does not throws exception (6 digit, no year) CronTrigger cronTrigger = new CronTrigger(cron); } catch (Exception e) { log.error(e.getMessage(), e); throw new RuntimeException("Invalid cron expression. "+e.getMessage()); } human_readable_cron = GwScheduler.getHumanReadableCronDescription(cron); } valuesMap.put(PROPERTY_HUMAN_READABLE_CRON, human_readable_cron); log.info("human_readable_cron: "+human_readable_cron); } return true; }; public boolean afterInsert(HashMap<String,Object> valuesMap){ log.info("gwSchedDefTrigger - afterInsert()"); log.info("valuesMap: "+valuesMap); String sched_def_name = (String) valuesMap.get(PROPERTY_SCHED_DEF_NAME); try { ((GwScheduler) services.get("gwScheduler")).activateSchedulation(sched_def_name); } catch (Exception e) { throw new RuntimeException(e.getMessage(), e); } return true; }; public boolean beforeUpdate(HashMap<String,Object> valuesMap,HashMap<String,Object> oldValuesMap){ log.info("gwSchedDefTrigger - beforeUpdate()"); log.info("valuesMap: "+valuesMap); log.info("oldValuesMap: "+oldValuesMap); String cron = (String) valuesMap.get(PROPERTY_CRON); if(cron!=null){ String human_readable_cron = null; if(!cron.trim().isEmpty()) { try { //testing cron expression: it's valid IF does NOT throws exception (6 digit, no YEAR) CronTrigger cronTrigger = NEW CronTrigger(cron); } catch (Exception e) { log.error(e.getMessage(), e); throw NEW RuntimeException("Invalid cron expression. "+e.getMessage()); } human_readable_cron = GwScheduler.getHumanReadableCronDescription(cron); } valuesMap.put(PROPERTY_HUMAN_READABLE_CRON, human_readable_cron); log.info("human_readable_cron: "+human_readable_cron); } //issue #1233 //lock_end_time may TO be auto-computated too far IN TIME () //---------------------------- String sched_def_name = (String) valuesMap.get(PROPERTY_SCHED_DEF_NAME); INTEGER enabled = NULL; Object enabledObj = valuesMap.get(PROPERTY_ENABLED); IF(enabledObj!=NULL) { IF(enabledObj instanceof INTEGER) enabled = (INTEGER) enabledObj; //It handles Oracle problem that CONVERT it IN BigDecimal ELSE IF(!enabledObj.toString().trim().isEmpty()) enabled = INTEGER.parseInt(enabledObj.toString().trim()); } DATE start_time = (DATE) valuesMap.get(PROPERTY_START_TIME); Object period = valuesMap.get(PROPERTY_PERIOD); //INTEGER, but ONLY need TO know IF had changed Object delay = valuesMap.get(PROPERTY_DELAY); //INTEGER, but ONLY need TO know IF had changed BOOLEAN needToResetLockEndTime = sched_def_name!=NULL || enabled!=NULL || cron!=NULL || start_time!=NULL || period!=NULL || delay!=NULL; IF(needToResetLockEndTime==TRUE){ valuesMap.put(PROPERTY_LOCK_END_TIME, NULL); } //---------------------------- RETURN TRUE; }; public BOOLEAN afterUpdate(HashMap<String,Object> valuesMap,HashMap<String,Object> oldValuesMap){ log.info("gwSchedDefTrigger - afterUpdate()"); log.info("valuesMap: "+valuesMap); log.info("oldValuesMap: "+oldValuesMap); String sched_def_name = (String) valuesMap.get(PROPERTY_SCHED_DEF_NAME); String sched_def_name_old = (String) oldValuesMap.get(PROPERTY_SCHED_DEF_NAME); INTEGER enabled = NULL; Object enabledObj = valuesMap.get(PROPERTY_ENABLED); IF(enabledObj!=NULL) { IF(enabledObj instanceof INTEGER) enabled = (INTEGER) enabledObj; //It handles Oracle problem that CONVERT it IN BigDecimal ELSE IF(!enabledObj.toString().trim().isEmpty()) enabled = INTEGER.parseInt(enabledObj.toString().trim()); } String cron = (String) valuesMap.get(PROPERTY_CRON); DATE start_time = (DATE) valuesMap.get(PROPERTY_START_TIME); Object period = valuesMap.get(PROPERTY_PERIOD); //INTEGER, but ONLY need TO know IF had changed Object delay = valuesMap.get(PROPERTY_DELAY); //INTEGER, but ONLY need TO know IF had changed BOOLEAN needToRecompute = sched_def_name!=NULL || enabled!=NULL || cron!=NULL || start_time!=NULL || period!=NULL || delay!=NULL; log.info("needToRecompute: "+needToRecompute); IF(needToRecompute==TRUE){ IF(sched_def_name==NULL) sched_def_name = sched_def_name_old; IF(enabled!=NULL && enabled==0) ((GwScheduler) services.get("gwScheduler")).deactivateSchedulation(sched_def_name); ELSE try { ((GwScheduler) services.get("gwScheduler")).activateSchedulation(sched_def_name); } catch (Exception e) { throw NEW RuntimeException(e.getMessage(), e); } } RETURN TRUE; }; public BOOLEAN beforeDelete(HashMap<String,Object> valuesMap){ log.info("gwSchedDefTrigger - beforeDelete()"); log.info("valuesMap: "+valuesMap); INTEGER sched_def_id = NULL; Object sched_def_idObj = valuesMap.get(PROPERTY_SCHED_DEF_ID); IF(sched_def_idObj!=NULL) { IF(sched_def_idObj instanceof INTEGER) sched_def_id = (INTEGER) sched_def_idObj; //It handles Oracle problem that CONVERT it IN BigDecimal ELSE IF(!sched_def_idObj.toString().trim().isEmpty()) sched_def_id = INTEGER.parseInt(sched_def_idObj.toString().trim()); } //issue #908 Class gwClass = ((ClassService) services.get("gwm_classService")).selectByClassName(NEW Class(GwScheduler.GW_SCHED_DEF_CLASSNAME)); List<? extends HashMap<String,Object>> rec = ((ListService) services.get("queryService")).executeQuery("select * from "+gwClass.getTableNameSchemaPrefixed()+".gw_sched_def where "+PROPERTY_SCHED_DEF_ID+"="+sched_def_id, NULL); log.info("rec: "+rec); IF(rec!=NULL && !rec.isEmpty()){ String sched_def_name = (String) rec.get(0).get(PROPERTY_SCHED_DEF_NAME); valuesMap.put(PROPERTY_SCHED_DEF_NAME, sched_def_name); } RETURN TRUE; }; public BOOLEAN afterDelete(HashMap<String,Object> valuesMap){ log.info("gwSchedDefTrigger - afterDelete()"); log.info("valuesMap: "+valuesMap); String sched_def_name = (String) valuesMap.get(PROPERTY_SCHED_DEF_NAME); //populated IN beforeDelete() IF(sched_def_name!=NULL) { ((GwScheduler) services.get("gwScheduler")).deactivateSchedulation(sched_def_name); } RETURN TRUE; }; }