Shirly Radco has uploaded a new change for review. Change subject: history: updated runTime from engine db ......................................................................
history: updated runTime from engine db updated context.runTime to get timstmp from engine db instead of history db, so when on that when the dbs are on seperate hosts the update date and delete date when a record is deleted will be in engine db time as all other records. Change-Id: I117324fcd5b961e83cb3491f8678c9a856754985 Bug-Url: https://bugzilla.redhat.com/1133608 Signed-off-by: Shirly Radco <[email protected]> --- M etl_export/src/ovirt_engine_dwh/dailytimekeepingjob_3_5/DailyTimeKeepingJob.java M etl_export/src/ovirt_engine_dwh/deletetimekeepingjob_3_5/DeleteTimeKeepingJob.java M etl_export/src/ovirt_engine_dwh/hourlytimekeepingjob_3_5/HourlyTimeKeepingJob.java M etl_export/src/ovirt_engine_dwh/parallelrun_3_5/ParallelRun.java M etl_export/src/ovirt_engine_dwh/sampletimekeepingjob_3_5/SampleTimeKeepingJob.java M etl_export/src/ovirt_engine_dwh/statisticssync_3_5/StatisticsSync.java M tos_project/process/DailyTimeKeepingJob_3.5.item M tos_project/process/DailyTimeKeepingJob_3.5.properties M tos_project/process/DeleteTimeKeepingJob_3.5.item M tos_project/process/DeleteTimeKeepingJob_3.5.properties M tos_project/process/HourlyTimeKeepingJob_3.5.item M tos_project/process/HourlyTimeKeepingJob_3.5.properties M tos_project/process/ParallelRun_3.5.item M tos_project/process/ParallelRun_3.5.properties M tos_project/process/SampleTimeKeepingJob_3.5.item M tos_project/process/SampleTimeKeepingJob_3.5.properties M tos_project/process/StatisticsSync_3.5.item M tos_project/process/StatisticsSync_3.5.properties 18 files changed, 65 insertions(+), 34 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-dwh refs/changes/40/32240/1 diff --git a/etl_export/src/ovirt_engine_dwh/dailytimekeepingjob_3_5/DailyTimeKeepingJob.java b/etl_export/src/ovirt_engine_dwh/dailytimekeepingjob_3_5/DailyTimeKeepingJob.java index 88d16b7..9e89918 100644 --- a/etl_export/src/ovirt_engine_dwh/dailytimekeepingjob_3_5/DailyTimeKeepingJob.java +++ b/etl_export/src/ovirt_engine_dwh/dailytimekeepingjob_3_5/DailyTimeKeepingJob.java @@ -1198,7 +1198,7 @@ int nb_line_tJDBCInput_3 = 0; java.sql.Connection conn_tJDBCInput_3 = null; conn_tJDBCInput_3 = (java.sql.Connection) globalMap - .get("conn_tJDBCConnection_1"); + .get("conn_tJDBCConnection_2"); java.sql.Statement stmt_tJDBCInput_3 = conn_tJDBCInput_3 .createStatement(); @@ -2169,7 +2169,7 @@ int nb_line_tJDBCInput_1 = 0; java.sql.Connection conn_tJDBCInput_1 = null; conn_tJDBCInput_1 = (java.sql.Connection) globalMap - .get("conn_tJDBCConnection_1"); + .get("conn_tJDBCConnection_2"); java.sql.Statement stmt_tJDBCInput_1 = conn_tJDBCInput_1 .createStatement(); @@ -6853,5 +6853,5 @@ } /************************************************************************************************ * 190055 characters generated by Talend Open Studio for Data Integration on the - * May 14, 2014 1:56:55 PM IDT + * September 1, 2014 4:08:22 PM IDT ************************************************************************************************/ diff --git a/etl_export/src/ovirt_engine_dwh/deletetimekeepingjob_3_5/DeleteTimeKeepingJob.java b/etl_export/src/ovirt_engine_dwh/deletetimekeepingjob_3_5/DeleteTimeKeepingJob.java index ad15868..f0c5898 100644 --- a/etl_export/src/ovirt_engine_dwh/deletetimekeepingjob_3_5/DeleteTimeKeepingJob.java +++ b/etl_export/src/ovirt_engine_dwh/deletetimekeepingjob_3_5/DeleteTimeKeepingJob.java @@ -1313,7 +1313,7 @@ int nb_line_tJDBCInput_10 = 0; java.sql.Connection conn_tJDBCInput_10 = null; conn_tJDBCInput_10 = (java.sql.Connection) globalMap - .get("conn_tJDBCConnection_1"); + .get("conn_tJDBCConnection_2"); java.sql.Statement stmt_tJDBCInput_10 = conn_tJDBCInput_10 .createStatement(); @@ -2256,7 +2256,7 @@ int nb_line_tJDBCInput_1 = 0; java.sql.Connection conn_tJDBCInput_1 = null; conn_tJDBCInput_1 = (java.sql.Connection) globalMap - .get("conn_tJDBCConnection_1"); + .get("conn_tJDBCConnection_2"); java.sql.Statement stmt_tJDBCInput_1 = conn_tJDBCInput_1 .createStatement(); @@ -9639,5 +9639,5 @@ } /************************************************************************************************ * 265130 characters generated by Talend Open Studio for Data Integration on the - * May 14, 2014 1:56:56 PM IDT + * September 1, 2014 4:08:23 PM IDT ************************************************************************************************/ diff --git a/etl_export/src/ovirt_engine_dwh/hourlytimekeepingjob_3_5/HourlyTimeKeepingJob.java b/etl_export/src/ovirt_engine_dwh/hourlytimekeepingjob_3_5/HourlyTimeKeepingJob.java index 0ed30b4..1004617 100644 --- a/etl_export/src/ovirt_engine_dwh/hourlytimekeepingjob_3_5/HourlyTimeKeepingJob.java +++ b/etl_export/src/ovirt_engine_dwh/hourlytimekeepingjob_3_5/HourlyTimeKeepingJob.java @@ -1156,7 +1156,7 @@ int nb_line_tJDBCInput_3 = 0; java.sql.Connection conn_tJDBCInput_3 = null; conn_tJDBCInput_3 = (java.sql.Connection) globalMap - .get("conn_tJDBCConnection_1"); + .get("conn_tJDBCConnection_2"); java.sql.Statement stmt_tJDBCInput_3 = conn_tJDBCInput_3 .createStatement(); @@ -2072,7 +2072,7 @@ int nb_line_tJDBCInput_1 = 0; java.sql.Connection conn_tJDBCInput_1 = null; conn_tJDBCInput_1 = (java.sql.Connection) globalMap - .get("conn_tJDBCConnection_1"); + .get("conn_tJDBCConnection_2"); java.sql.Statement stmt_tJDBCInput_1 = conn_tJDBCInput_1 .createStatement(); @@ -6537,5 +6537,5 @@ } /************************************************************************************************ * 175341 characters generated by Talend Open Studio for Data Integration on the - * May 14, 2014 1:56:54 PM IDT + * September 1, 2014 4:08:20 PM IDT ************************************************************************************************/ diff --git a/etl_export/src/ovirt_engine_dwh/parallelrun_3_5/ParallelRun.java b/etl_export/src/ovirt_engine_dwh/parallelrun_3_5/ParallelRun.java index 1eab688..df83937 100644 --- a/etl_export/src/ovirt_engine_dwh/parallelrun_3_5/ParallelRun.java +++ b/etl_export/src/ovirt_engine_dwh/parallelrun_3_5/ParallelRun.java @@ -1950,7 +1950,7 @@ int nb_line_tJDBCInput_1 = 0; java.sql.Connection conn_tJDBCInput_1 = null; conn_tJDBCInput_1 = (java.sql.Connection) globalMap - .get("conn_tJDBCConnection_2"); + .get("conn_tJDBCConnection_6"); java.sql.Statement stmt_tJDBCInput_1 = conn_tJDBCInput_1 .createStatement(); @@ -5168,5 +5168,5 @@ } /************************************************************************************************ * 143175 characters generated by Talend Open Studio for Data Integration on the - * January 21, 2014 3:54:37 PM IST + * September 1, 2014 4:08:23 PM IDT ************************************************************************************************/ diff --git a/etl_export/src/ovirt_engine_dwh/sampletimekeepingjob_3_5/SampleTimeKeepingJob.java b/etl_export/src/ovirt_engine_dwh/sampletimekeepingjob_3_5/SampleTimeKeepingJob.java index 06f2687..2dd4cf3 100644 --- a/etl_export/src/ovirt_engine_dwh/sampletimekeepingjob_3_5/SampleTimeKeepingJob.java +++ b/etl_export/src/ovirt_engine_dwh/sampletimekeepingjob_3_5/SampleTimeKeepingJob.java @@ -5067,7 +5067,7 @@ int nb_line_tJDBCInput_2 = 0; java.sql.Connection conn_tJDBCInput_2 = null; conn_tJDBCInput_2 = (java.sql.Connection) globalMap - .get("conn_tJDBCConnection_2"); + .get("conn_tJDBCConnection_3"); java.sql.Statement stmt_tJDBCInput_2 = conn_tJDBCInput_2 .createStatement(); @@ -9712,5 +9712,5 @@ } /************************************************************************************************ * 265073 characters generated by Talend Open Studio for Data Integration on the - * January 21, 2014 3:54:32 PM IST + * September 1, 2014 4:08:19 PM IDT ************************************************************************************************/ diff --git a/etl_export/src/ovirt_engine_dwh/statisticssync_3_5/StatisticsSync.java b/etl_export/src/ovirt_engine_dwh/statisticssync_3_5/StatisticsSync.java index 67545f3..ca3e267 100644 --- a/etl_export/src/ovirt_engine_dwh/statisticssync_3_5/StatisticsSync.java +++ b/etl_export/src/ovirt_engine_dwh/statisticssync_3_5/StatisticsSync.java @@ -16000,7 +16000,7 @@ int nb_line_tJDBCInput_21 = 0; java.sql.Connection conn_tJDBCInput_21 = null; conn_tJDBCInput_21 = (java.sql.Connection) globalMap - .get("conn_tJDBCConnection_2"); + .get("conn_tJDBCConnection_1"); java.sql.Statement stmt_tJDBCInput_21 = conn_tJDBCInput_21 .createStatement(); @@ -17681,5 +17681,5 @@ } /************************************************************************************************ * 492854 characters generated by Talend Open Studio for Data Integration on the - * May 11, 2014 3:45:37 PM IDT + * September 1, 2014 4:08:18 PM IDT ************************************************************************************************/ diff --git a/tos_project/process/DailyTimeKeepingJob_3.5.item b/tos_project/process/DailyTimeKeepingJob_3.5.item index a441985..f2c97b0 100644 --- a/tos_project/process/DailyTimeKeepingJob_3.5.item +++ b/tos_project/process/DailyTimeKeepingJob_3.5.item @@ -101,7 +101,7 @@ <elementParameter field="TEXT" name="UNIQUE_NAME" value="tJDBCInput_1"/> <elementParameter field="CHECK" name="END_OF_FLOW" value="false"/> <elementParameter field="CHECK" name="USE_EXISTING_CONNECTION" value="true"/> - <elementParameter field="COMPONENT_LIST" name="CONNECTION" value="tJDBCConnection_1"/> + <elementParameter field="COMPONENT_LIST" name="CONNECTION" value="tJDBCConnection_2"/> <elementParameter field="TEXT" name="URL" value=""jdbc:""/> <elementParameter field="TABLE" name="DRIVER_JAR"/> <elementParameter field="TEXT" name="DRIVER_CLASS" value=""""/> @@ -546,7 +546,7 @@ <elementParameter field="TEXT" name="UNIQUE_NAME" value="tJDBCInput_3"/> <elementParameter field="CHECK" name="END_OF_FLOW" value="false"/> <elementParameter field="CHECK" name="USE_EXISTING_CONNECTION" value="true"/> - <elementParameter field="COMPONENT_LIST" name="CONNECTION" value="tJDBCConnection_1"/> + <elementParameter field="COMPONENT_LIST" name="CONNECTION" value="tJDBCConnection_2"/> <elementParameter field="TEXT" name="URL" value=""jdbc:""/> <elementParameter field="TABLE" name="DRIVER_JAR"/> <elementParameter field="TEXT" name="DRIVER_CLASS" value=""""/> diff --git a/tos_project/process/DailyTimeKeepingJob_3.5.properties b/tos_project/process/DailyTimeKeepingJob_3.5.properties index e987e0d..6019c55 100644 --- a/tos_project/process/DailyTimeKeepingJob_3.5.properties +++ b/tos_project/process/DailyTimeKeepingJob_3.5.properties @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="UTF-8"?> <xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI"; xmlns:TalendProperties="http://www.talend.org/properties";> - <TalendProperties:Property xmi:id="_FvH2QLzqEeCaj-T1n0SCFw" id="_O-QEENI6EeCOk4qSIFFDtw" label="DailyTimeKeepingJob" creationDate="2011-08-02T12:30:39.367+0300" modificationDate="2014-05-14T13:39:34.912+0300" version="3.5" statusCode="" item="_FvH2QrzqEeCaj-T1n0SCFw" displayName="DailyTimeKeepingJob"> + <TalendProperties:Property xmi:id="_FvH2QLzqEeCaj-T1n0SCFw" id="_O-QEENI6EeCOk4qSIFFDtw" label="DailyTimeKeepingJob" creationDate="2011-08-02T12:30:39.367+0300" modificationDate="2014-09-01T16:02:55.007+0300" version="3.5" statusCode="" item="_FvH2QrzqEeCaj-T1n0SCFw" displayName="DailyTimeKeepingJob"> <author href="../talend.project#_SapC4EJlEeCWRqOtaF5m-w"/> </TalendProperties:Property> <TalendProperties:ItemState xmi:id="_O-iX8NI6EeCOk4qSIFFDtw" path=""/> diff --git a/tos_project/process/DeleteTimeKeepingJob_3.5.item b/tos_project/process/DeleteTimeKeepingJob_3.5.item index bcd3ae4..7685c2e 100644 --- a/tos_project/process/DeleteTimeKeepingJob_3.5.item +++ b/tos_project/process/DeleteTimeKeepingJob_3.5.item @@ -100,7 +100,7 @@ <elementParameter field="TEXT" name="UNIQUE_NAME" value="tJDBCInput_1"/> <elementParameter field="CHECK" name="END_OF_FLOW" value="false"/> <elementParameter field="CHECK" name="USE_EXISTING_CONNECTION" value="true"/> - <elementParameter field="COMPONENT_LIST" name="CONNECTION" value="tJDBCConnection_1"/> + <elementParameter field="COMPONENT_LIST" name="CONNECTION" value="tJDBCConnection_2"/> <elementParameter field="TEXT" name="URL" value=""jdbc:""/> <elementParameter field="TABLE" name="DRIVER_JAR"/> <elementParameter field="TEXT" name="DRIVER_CLASS" value=""""/> @@ -835,7 +835,7 @@ <elementParameter field="TEXT" name="UNIQUE_NAME" value="tJDBCInput_10"/> <elementParameter field="CHECK" name="END_OF_FLOW" value="false"/> <elementParameter field="CHECK" name="USE_EXISTING_CONNECTION" value="true"/> - <elementParameter field="COMPONENT_LIST" name="CONNECTION" value="tJDBCConnection_1"/> + <elementParameter field="COMPONENT_LIST" name="CONNECTION" value="tJDBCConnection_2"/> <elementParameter field="TEXT" name="URL" value=""jdbc:""/> <elementParameter field="TABLE" name="DRIVER_JAR"/> <elementParameter field="TEXT" name="DRIVER_CLASS" value=""""/> diff --git a/tos_project/process/DeleteTimeKeepingJob_3.5.properties b/tos_project/process/DeleteTimeKeepingJob_3.5.properties index 8b9cd78..11a8bfc 100644 --- a/tos_project/process/DeleteTimeKeepingJob_3.5.properties +++ b/tos_project/process/DeleteTimeKeepingJob_3.5.properties @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="UTF-8"?> <xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI"; xmlns:TalendProperties="http://www.talend.org/properties";> - <TalendProperties:Property xmi:id="_FvH2QLzqEeCaj-T1n0SCFw" id="_pOJo4NPOEeClgedRboJzdw" label="DeleteTimeKeepingJob" creationDate="2011-08-02T12:30:39.367+0300" modificationDate="2014-05-14T13:41:14.820+0300" version="3.5" statusCode="" item="_FvH2QrzqEeCaj-T1n0SCFw" displayName="DeleteTimeKeepingJob"> + <TalendProperties:Property xmi:id="_FvH2QLzqEeCaj-T1n0SCFw" id="_pOJo4NPOEeClgedRboJzdw" label="DeleteTimeKeepingJob" creationDate="2011-08-02T12:30:39.367+0300" modificationDate="2014-09-01T15:57:41.151+0300" version="3.5" statusCode="" item="_FvH2QrzqEeCaj-T1n0SCFw" displayName="DeleteTimeKeepingJob"> <author href="../talend.project#_SapC4EJlEeCWRqOtaF5m-w"/> </TalendProperties:Property> <TalendProperties:ItemState xmi:id="_pOXEQNPOEeClgedRboJzdw" path=""/> diff --git a/tos_project/process/HourlyTimeKeepingJob_3.5.item b/tos_project/process/HourlyTimeKeepingJob_3.5.item index f30e7c2..a2a16a5 100644 --- a/tos_project/process/HourlyTimeKeepingJob_3.5.item +++ b/tos_project/process/HourlyTimeKeepingJob_3.5.item @@ -118,7 +118,7 @@ <elementParameter field="TEXT" name="UNIQUE_NAME" value="tJDBCInput_1"/> <elementParameter field="CHECK" name="END_OF_FLOW" value="false"/> <elementParameter field="CHECK" name="USE_EXISTING_CONNECTION" value="true"/> - <elementParameter field="COMPONENT_LIST" name="CONNECTION" value="tJDBCConnection_1"/> + <elementParameter field="COMPONENT_LIST" name="CONNECTION" value="tJDBCConnection_2"/> <elementParameter field="TEXT" name="URL" value=""jdbc:""/> <elementParameter field="TABLE" name="DRIVER_JAR"/> <elementParameter field="TEXT" name="DRIVER_CLASS" value=""""/> @@ -589,7 +589,7 @@ <elementParameter field="TEXT" name="UNIQUE_NAME" value="tJDBCInput_3"/> <elementParameter field="CHECK" name="END_OF_FLOW" value="false"/> <elementParameter field="CHECK" name="USE_EXISTING_CONNECTION" value="true"/> - <elementParameter field="COMPONENT_LIST" name="CONNECTION" value="tJDBCConnection_1"/> + <elementParameter field="COMPONENT_LIST" name="CONNECTION" value="tJDBCConnection_2"/> <elementParameter field="TEXT" name="URL" value=""jdbc:""/> <elementParameter field="TABLE" name="DRIVER_JAR"/> <elementParameter field="TEXT" name="DRIVER_CLASS" value=""""/> diff --git a/tos_project/process/HourlyTimeKeepingJob_3.5.properties b/tos_project/process/HourlyTimeKeepingJob_3.5.properties index 6575e21..6f457cc 100644 --- a/tos_project/process/HourlyTimeKeepingJob_3.5.properties +++ b/tos_project/process/HourlyTimeKeepingJob_3.5.properties @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="UTF-8"?> <xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI"; xmlns:TalendProperties="http://www.talend.org/properties";> - <TalendProperties:Property xmi:id="_FvH2QLzqEeCaj-T1n0SCFw" id="_Q9_uQNI6EeCOk4qSIFFDtw" label="HourlyTimeKeepingJob" creationDate="2011-08-02T12:30:39.367+0300" modificationDate="2014-05-14T13:38:01.438+0300" version="3.5" statusCode="" item="_FvH2QrzqEeCaj-T1n0SCFw" displayName="HourlyTimeKeepingJob"> + <TalendProperties:Property xmi:id="_FvH2QLzqEeCaj-T1n0SCFw" id="_Q9_uQNI6EeCOk4qSIFFDtw" label="HourlyTimeKeepingJob" creationDate="2011-08-02T12:30:39.367+0300" modificationDate="2014-09-01T16:03:46.451+0300" version="3.5" statusCode="" item="_FvH2QrzqEeCaj-T1n0SCFw" displayName="HourlyTimeKeepingJob"> <author href="../talend.project#_SapC4EJlEeCWRqOtaF5m-w"/> </TalendProperties:Property> <TalendProperties:ItemState xmi:id="_Q-FN0NI6EeCOk4qSIFFDtw" path=""/> diff --git a/tos_project/process/ParallelRun_3.5.item b/tos_project/process/ParallelRun_3.5.item index dfecd08..cdedfc5 100644 --- a/tos_project/process/ParallelRun_3.5.item +++ b/tos_project/process/ParallelRun_3.5.item @@ -27,6 +27,8 @@ <elementParameter field="TEXT" name="OEM_CUSTOM_ATTRIBUTE" value=""/> <elementParameter field="TEXT" name="HADOOP_APP_PATH" value=""/> <elementParameter field="TEXT" name="JOBID_FOR_OOZIE" value=""/> + <elementParameter field="TEXT" name="REPOSITORY_CONNECTION_ID" value=""/> + <elementParameter field="TABLE" name="HADOOP_ADVANCED_PROPERTIES"/> <elementParameter field="CHECK" name="IMPLICITCONTEXT_USE_PROJECT_SETTINGS" value="true"/> <elementParameter field="CHECK" name="STATANDLOG_USE_PROJECT_SETTINGS" value="true"/> <elementParameter field="CHECK" name="MULTI_THREAD_EXECATION" value="true"/> @@ -65,6 +67,9 @@ <elementParameter field="TECHNICAL" name="ENCODING:ENCODING_TYPE" value="ISO-8859-15"/> <elementParameter field="CHECK" name="USE_SHARED_CONNECTION" value="true"/> <elementParameter field="TEXT" name="SHARED_CONNECTION_NAME" value=""engine""/> + <elementParameter field="LABEL" name="NOTE" value="This option only applies when deploying and running in the Talend Runtime"/> + <elementParameter field="CHECK" name="SPECIFY_DATASOURCE_ALIAS" value="false"/> + <elementParameter field="TEXT" name="DATASOURCE_ALIAS" value=""""/> <elementParameter field="CHECK" name="IS_USE_AUTO_COMMIT" value="true"/> <elementParameter field="CHECK" name="AUTO_COMMIT" value="false"/> <elementParameter field="TEXT" name="LABEL" value="engine"/> @@ -86,6 +91,9 @@ <elementParameter field="TECHNICAL" name="ENCODING:ENCODING_TYPE" value="ISO-8859-15"/> <elementParameter field="CHECK" name="USE_SHARED_CONNECTION" value="true"/> <elementParameter field="TEXT" name="SHARED_CONNECTION_NAME" value=""sample_ovirt_engine_history""/> + <elementParameter field="LABEL" name="NOTE" value="This option only applies when deploying and running in the Talend Runtime"/> + <elementParameter field="CHECK" name="SPECIFY_DATASOURCE_ALIAS" value="false"/> + <elementParameter field="TEXT" name="DATASOURCE_ALIAS" value=""""/> <elementParameter field="CHECK" name="IS_USE_AUTO_COMMIT" value="true"/> <elementParameter field="CHECK" name="AUTO_COMMIT" value="false"/> <elementParameter field="TEXT" name="LABEL" value="sample_ovirt_engine_history"/> @@ -104,6 +112,7 @@ </node> <node componentName="tRunJob" componentVersion="0.101" offsetLabelX="0" offsetLabelY="0" posX="768" posY="256"> <elementParameter field="TEXT" name="UNIQUE_NAME" value="tRunJob_3"/> + <elementParameter field="CHECK" name="SUBTREE_START" value="false"/> <elementParameter field="CHECK" name="USE_DYNAMIC_JOB" value="false"/> <elementParameter field="TEXT" name="CONTEXT_JOB" value=""/> <elementParameter field="PROCESS_TYPE" name="PROCESS" value="DailyTimeKeepingJob"/> @@ -134,6 +143,7 @@ </node> <node componentName="tRunJob" componentVersion="0.101" offsetLabelX="0" offsetLabelY="0" posX="576" posY="256"> <elementParameter field="TEXT" name="UNIQUE_NAME" value="tRunJob_2"/> + <elementParameter field="CHECK" name="SUBTREE_START" value="false"/> <elementParameter field="CHECK" name="USE_DYNAMIC_JOB" value="false"/> <elementParameter field="TEXT" name="CONTEXT_JOB" value=""/> <elementParameter field="PROCESS_TYPE" name="PROCESS" value="HourlyTimeKeepingJob"/> @@ -164,6 +174,7 @@ </node> <node componentName="tRunJob" componentVersion="0.101" offsetLabelX="0" offsetLabelY="0" posX="384" posY="256"> <elementParameter field="TEXT" name="UNIQUE_NAME" value="tRunJob_1"/> + <elementParameter field="CHECK" name="SUBTREE_START" value="false"/> <elementParameter field="CHECK" name="USE_DYNAMIC_JOB" value="false"/> <elementParameter field="TEXT" name="CONTEXT_JOB" value=""/> <elementParameter field="PROCESS_TYPE" name="PROCESS" value="SampleTimeKeepingJob"/> @@ -197,6 +208,9 @@ <elementParameter field="TECHNICAL" name="ENCODING:ENCODING_TYPE" value="ISO-8859-15"/> <elementParameter field="CHECK" name="USE_SHARED_CONNECTION" value="true"/> <elementParameter field="TEXT" name="SHARED_CONNECTION_NAME" value=""hourly_ovirt_engine_history""/> + <elementParameter field="LABEL" name="NOTE" value="This option only applies when deploying and running in the Talend Runtime"/> + <elementParameter field="CHECK" name="SPECIFY_DATASOURCE_ALIAS" value="false"/> + <elementParameter field="TEXT" name="DATASOURCE_ALIAS" value=""""/> <elementParameter field="CHECK" name="IS_USE_AUTO_COMMIT" value="true"/> <elementParameter field="CHECK" name="AUTO_COMMIT" value="false"/> <elementParameter field="TEXT" name="LABEL" value="hourly_ovirt_engine_history"/> @@ -218,6 +232,9 @@ <elementParameter field="TECHNICAL" name="ENCODING:ENCODING_TYPE" value="ISO-8859-15"/> <elementParameter field="CHECK" name="USE_SHARED_CONNECTION" value="true"/> <elementParameter field="TEXT" name="SHARED_CONNECTION_NAME" value=""daily_ovirt_engine_history""/> + <elementParameter field="LABEL" name="NOTE" value="This option only applies when deploying and running in the Talend Runtime"/> + <elementParameter field="CHECK" name="SPECIFY_DATASOURCE_ALIAS" value="false"/> + <elementParameter field="TEXT" name="DATASOURCE_ALIAS" value=""""/> <elementParameter field="CHECK" name="IS_USE_AUTO_COMMIT" value="true"/> <elementParameter field="CHECK" name="AUTO_COMMIT" value="false"/> <elementParameter field="TEXT" name="LABEL" value="daily_ovirt_engine_history"/> @@ -239,6 +256,9 @@ <elementParameter field="TECHNICAL" name="ENCODING:ENCODING_TYPE" value="ISO-8859-15"/> <elementParameter field="CHECK" name="USE_SHARED_CONNECTION" value="true"/> <elementParameter field="TEXT" name="SHARED_CONNECTION_NAME" value=""delete_ovirt_engine_history""/> + <elementParameter field="LABEL" name="NOTE" value="This option only applies when deploying and running in the Talend Runtime"/> + <elementParameter field="CHECK" name="SPECIFY_DATASOURCE_ALIAS" value="false"/> + <elementParameter field="TEXT" name="DATASOURCE_ALIAS" value=""""/> <elementParameter field="CHECK" name="IS_USE_AUTO_COMMIT" value="true"/> <elementParameter field="CHECK" name="AUTO_COMMIT" value="false"/> <elementParameter field="TEXT" name="LABEL" value="delete_ovirt_engine_history"/> @@ -257,8 +277,9 @@ </node> <node componentName="tJDBCInput" componentVersion="0.102" offsetLabelX="0" offsetLabelY="0" posX="160" posY="192"> <elementParameter field="TEXT" name="UNIQUE_NAME" value="tJDBCInput_1"/> + <elementParameter field="CHECK" name="END_OF_FLOW" value="false"/> <elementParameter field="CHECK" name="USE_EXISTING_CONNECTION" value="true"/> - <elementParameter field="COMPONENT_LIST" name="CONNECTION" value="tJDBCConnection_2"/> + <elementParameter field="COMPONENT_LIST" name="CONNECTION" value="tJDBCConnection_6"/> <elementParameter field="TEXT" name="URL" value=""jdbc:""/> <elementParameter field="TABLE" name="DRIVER_JAR"/> <elementParameter field="TEXT" name="DRIVER_CLASS" value=""""/> @@ -270,6 +291,9 @@ <elementParameter field="TECHNICAL" name="QUERYSTORE:QUERYSTORE_TYPE" value="BUILT_IN"/> <elementParameter field="GUESS_SCHEMA" name="GUESS_SCHEMA" value=""""/> <elementParameter field="MEMO_SQL" name="QUERY" value=""select distinct 'runTime', CURRENT_TIMESTAMP(6)""/> + <elementParameter field="LABEL" name="NOTE" value="This option only applies when deploying and running in the Talend Runtime"/> + <elementParameter field="CHECK" name="SPECIFY_DATASOURCE_ALIAS" value="false"/> + <elementParameter field="TEXT" name="DATASOURCE_ALIAS" value=""""/> <elementParameter field="ENCODING_TYPE" name="ENCODING" value=""ISO-8859-15""/> <elementParameter field="TECHNICAL" name="ENCODING:ENCODING_TYPE" value="ISO-8859-15"/> <elementParameter field="CHECK" name="USE_CURSOR" value="false"/> @@ -287,12 +311,13 @@ <elementParameter field="MEMO" name="COMMENT" value=""/> <elementParameter field="CHECK" name="VALIDATION_RULES" value="false"/> <metadata connector="FLOW" name="tJDBCInput_1"> - <column key="false" length="255" name="key" nullable="true" precision="0" sourceType="" type="id_String"/> - <column comment="" key="false" length="35" name="value" nullable="true" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="6" sourceType="DATETIME" type="id_Date"/> + <column key="false" length="255" name="key" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> + <column comment="" key="false" length="35" name="value" nullable="true" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="6" sourceType="DATETIME" type="id_Date" usefulColumn="true"/> </metadata> </node> <node componentName="tContextLoad" componentVersion="0.101" offsetLabelX="0" offsetLabelY="0" posX="160" posY="288"> <elementParameter field="TEXT" name="UNIQUE_NAME" value="tContextLoad_1"/> + <elementParameter field="CHECK" name="END_OF_FLOW" value="true"/> <elementParameter field="CLOSED_LIST" name="LOAD_NEW_VARIABLE" value="Warning"/> <elementParameter field="CLOSED_LIST" name="NOT_LOAD_OLD_VARIABLE" value="Warning"/> <elementParameter field="CHECK" name="PRINT_OPERATIONS" value="false"/> @@ -305,8 +330,8 @@ <elementParameter field="MEMO" name="COMMENT" value=""/> <elementParameter field="CHECK" name="VALIDATION_RULES" value="false"/> <metadata connector="FLOW" name="tContextLoad_1"> - <column defaultValue="" key="false" length="255" name="key" nullable="true" precision="0" sourceType="" type="id_String"/> - <column defaultValue="" key="false" length="35" name="value" nullable="true" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="6" sourceType="DATETIME" type="id_Date"/> + <column defaultValue="" key="false" length="255" name="key" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> + <column defaultValue="" key="false" length="35" name="value" nullable="true" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="6" sourceType="DATETIME" type="id_Date" usefulColumn="true"/> </metadata> </node> <node componentName="tInfiniteLoop" componentVersion="0.102" offsetLabelX="0" offsetLabelY="0" posX="960" posY="96"> @@ -319,6 +344,7 @@ </node> <node componentName="tRunJob" componentVersion="0.101" offsetLabelX="0" offsetLabelY="0" posX="960" posY="256"> <elementParameter field="TEXT" name="UNIQUE_NAME" value="tRunJob_6"/> + <elementParameter field="CHECK" name="SUBTREE_START" value="false"/> <elementParameter field="CHECK" name="USE_DYNAMIC_JOB" value="false"/> <elementParameter field="TEXT" name="CONTEXT_JOB" value=""/> <elementParameter field="PROCESS_TYPE" name="PROCESS" value="DeleteTimeKeepingJob"/> @@ -396,6 +422,9 @@ <elementParameter field="TECHNICAL" name="ENCODING:ENCODING_TYPE" value="ISO-8859-15"/> <elementParameter field="CHECK" name="USE_SHARED_CONNECTION" value="true"/> <elementParameter field="TEXT" name="SHARED_CONNECTION_NAME" value=""engine-events""/> + <elementParameter field="LABEL" name="NOTE" value="This option only applies when deploying and running in the Talend Runtime"/> + <elementParameter field="CHECK" name="SPECIFY_DATASOURCE_ALIAS" value="false"/> + <elementParameter field="TEXT" name="DATASOURCE_ALIAS" value=""""/> <elementParameter field="CHECK" name="IS_USE_AUTO_COMMIT" value="true"/> <elementParameter field="CHECK" name="AUTO_COMMIT" value="true"/> <elementParameter field="TEXT" name="LABEL" value="engine-events"/> diff --git a/tos_project/process/ParallelRun_3.5.properties b/tos_project/process/ParallelRun_3.5.properties index 73ccfe6..92b5425 100644 --- a/tos_project/process/ParallelRun_3.5.properties +++ b/tos_project/process/ParallelRun_3.5.properties @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="UTF-8"?> <xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI"; xmlns:TalendProperties="http://www.talend.org/properties";> - <TalendProperties:Property xmi:id="_6g-uoNI5EeCOk4qSIFFDtw" id="_6g7rUNI5EeCOk4qSIFFDtw" label="ParallelRun" creationDate="2011-08-29T15:24:54.696+0300" modificationDate="2013-06-23T12:05:52.347+0300" version="3.5" statusCode="" item="_6g-uotI5EeCOk4qSIFFDtw" displayName="ParallelRun"> + <TalendProperties:Property xmi:id="_6g-uoNI5EeCOk4qSIFFDtw" id="_6g7rUNI5EeCOk4qSIFFDtw" label="ParallelRun" creationDate="2011-08-29T15:24:54.696+0300" modificationDate="2014-09-01T15:35:46.207+0300" version="3.5" statusCode="" item="_6g-uotI5EeCOk4qSIFFDtw" displayName="ParallelRun"> <author href="../talend.project#_SapC4EJlEeCWRqOtaF5m-w"/> </TalendProperties:Property> <TalendProperties:ItemState xmi:id="_6g-uodI5EeCOk4qSIFFDtw" path=""/> diff --git a/tos_project/process/SampleTimeKeepingJob_3.5.item b/tos_project/process/SampleTimeKeepingJob_3.5.item index a2cd735..3c35a00 100644 --- a/tos_project/process/SampleTimeKeepingJob_3.5.item +++ b/tos_project/process/SampleTimeKeepingJob_3.5.item @@ -171,7 +171,7 @@ <elementParameter field="TEXT" name="UNIQUE_NAME" value="tJDBCInput_2"/> <elementParameter field="CHECK" name="END_OF_FLOW" value="false"/> <elementParameter field="CHECK" name="USE_EXISTING_CONNECTION" value="true"/> - <elementParameter field="COMPONENT_LIST" name="CONNECTION" value="tJDBCConnection_2"/> + <elementParameter field="COMPONENT_LIST" name="CONNECTION" value="tJDBCConnection_3"/> <elementParameter field="TEXT" name="URL" value=""jdbc:""/> <elementParameter field="TABLE" name="DRIVER_JAR"/> <elementParameter field="TEXT" name="DRIVER_CLASS" value=""""/> @@ -216,6 +216,7 @@ <elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/> <elementParameter field="CHECK" name="LKUP_PARALLELIZE" value="false"/> <elementParameter field="TEXT" name="ROWS_BUFFER_SIZE" value="2000000"/> + <elementParameter field="CHECK" name="CHANGE_HASH_AND_EQUALS_FOR_BIGDECIMAL" value="false"/> <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/> <elementParameter field="CHECK" name="INFORMATION" value="false"/> <elementParameter field="MEMO" name="COMMENT" value=""/> @@ -476,6 +477,7 @@ <elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/> <elementParameter field="CHECK" name="LKUP_PARALLELIZE" value="false"/> <elementParameter field="TEXT" name="ROWS_BUFFER_SIZE" value="2000000"/> + <elementParameter field="CHECK" name="CHANGE_HASH_AND_EQUALS_FOR_BIGDECIMAL" value="false"/> <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/> <elementParameter field="CHECK" name="INFORMATION" value="false"/> <elementParameter field="MEMO" name="COMMENT" value=""/> diff --git a/tos_project/process/SampleTimeKeepingJob_3.5.properties b/tos_project/process/SampleTimeKeepingJob_3.5.properties index 7a23295..81ea01a 100644 --- a/tos_project/process/SampleTimeKeepingJob_3.5.properties +++ b/tos_project/process/SampleTimeKeepingJob_3.5.properties @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="UTF-8"?> <xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI"; xmlns:TalendProperties="http://www.talend.org/properties";> - <TalendProperties:Property xmi:id="_FvH2QLzqEeCaj-T1n0SCFw" id="_FvEy8LzqEeCaj-T1n0SCFw" label="SampleTimeKeepingJob" creationDate="2011-08-02T12:30:39.367+0300" modificationDate="2013-10-14T13:38:05.478+0300" version="3.5" statusCode="" item="_FvH2QrzqEeCaj-T1n0SCFw" displayName="SampleTimeKeepingJob"> + <TalendProperties:Property xmi:id="_FvH2QLzqEeCaj-T1n0SCFw" id="_FvEy8LzqEeCaj-T1n0SCFw" label="SampleTimeKeepingJob" creationDate="2011-08-02T12:30:39.367+0300" modificationDate="2014-09-01T14:34:52.349+0300" version="3.5" statusCode="" item="_FvH2QrzqEeCaj-T1n0SCFw" displayName="SampleTimeKeepingJob"> <author href="../talend.project#_SapC4EJlEeCWRqOtaF5m-w"/> </TalendProperties:Property> <TalendProperties:ItemState xmi:id="_FvH2QbzqEeCaj-T1n0SCFw" path=""/> diff --git a/tos_project/process/StatisticsSync_3.5.item b/tos_project/process/StatisticsSync_3.5.item index a6601dc..fd09c44 100644 --- a/tos_project/process/StatisticsSync_3.5.item +++ b/tos_project/process/StatisticsSync_3.5.item @@ -2032,7 +2032,7 @@ <elementParameter field="TEXT" name="UNIQUE_NAME" value="tJDBCInput_21"/> <elementParameter field="CHECK" name="END_OF_FLOW" value="false"/> <elementParameter field="CHECK" name="USE_EXISTING_CONNECTION" value="true"/> - <elementParameter field="COMPONENT_LIST" name="CONNECTION" value="tJDBCConnection_2"/> + <elementParameter field="COMPONENT_LIST" name="CONNECTION" value="tJDBCConnection_1"/> <elementParameter field="TEXT" name="URL" value=""jdbc:""/> <elementParameter field="TABLE" name="DRIVER_JAR"/> <elementParameter field="TEXT" name="DRIVER_CLASS" value=""""/> diff --git a/tos_project/process/StatisticsSync_3.5.properties b/tos_project/process/StatisticsSync_3.5.properties index 27bd628..c5c502c 100644 --- a/tos_project/process/StatisticsSync_3.5.properties +++ b/tos_project/process/StatisticsSync_3.5.properties @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="UTF-8"?> <xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI"; xmlns:TalendProperties="http://www.talend.org/properties";> - <TalendProperties:Property xmi:id="_oWT9MVRyEeCEMvYqeevraA" id="_oWT9MFRyEeCEMvYqeevraA" label="StatisticsSync" creationDate="2011-07-06T14:16:52.840+0300" modificationDate="2014-05-11T15:44:15.302+0300" version="3.5" statusCode="" item="_oWT9M1RyEeCEMvYqeevraA" displayName="StatisticsSync"> + <TalendProperties:Property xmi:id="_oWT9MVRyEeCEMvYqeevraA" id="_oWT9MFRyEeCEMvYqeevraA" label="StatisticsSync" creationDate="2011-07-06T14:16:52.840+0300" modificationDate="2014-09-01T15:59:03.861+0300" version="3.5" statusCode="" item="_oWT9M1RyEeCEMvYqeevraA" displayName="StatisticsSync"> <author href="../talend.project#_SapC4EJlEeCWRqOtaF5m-w"/> </TalendProperties:Property> <TalendProperties:ItemState xmi:id="_oWT9MlRyEeCEMvYqeevraA" path=""/> -- To view, visit http://gerrit.ovirt.org/32240 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I117324fcd5b961e83cb3491f8678c9a856754985 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-dwh Gerrit-Branch: master Gerrit-Owner: Shirly Radco <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
