chore(TDI-50507): bump component-runtime to 1.38.12 (#9309 )

fix(TDI-50482): cve bump activemq-client 5.15.16 (#9240 )
* cve bump activemq-client 5.15.16 * jdk 8 compliant lib
2023-11-23 10:47:21 +08:00 · 2023-11-20 14:30:19 +02:00 · 2023-11-20 08:42:12 +02:00 · 2023-11-20 11:51:08 +08:00 · 2023-11-06 19:27:29 +08:00 · 2023-10-26 09:05:05 +02:00
47 changed files with 165 additions and 528 deletions
--- a/.project
+++ b/.project
@@ -0,0 +1,17 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<projectDescription>
+	<name>tdi-studio-se</name>
+	<comment></comment>
+	<projects>
+	</projects>
+	<buildSpec>
+		<buildCommand>
+			<name>org.eclipse.m2e.core.maven2Builder</name>
+			<arguments>
+			</arguments>
+		</buildCommand>
+	</buildSpec>
+	<natures>
+		<nature>org.eclipse.m2e.core.maven2Nature</nature>
+	</natures>
+</projectDescription>
--- a/main/plugins/org.talend.designer.components.libs/libs_src/adal4j/src/samples/public-client-app-sample/pom.xml
+++ b/main/plugins/org.talend.designer.components.libs/libs_src/adal4j/src/samples/public-client-app-sample/pom.xml
@@ -26,7 +26,7 @@
 		<dependency>
 			<groupId>org.json</groupId>
 			<artifactId>json</artifactId>
-			<version>20230227</version>
+			<version>20231013</version>
 		</dependency>
 		<dependency>
 			<groupId>javax.servlet</groupId>
--- a/main/plugins/org.talend.designer.components.libs/libs_src/adal4j/src/samples/web-app-samples-for-adal4j/pom.xml
+++ b/main/plugins/org.talend.designer.components.libs/libs_src/adal4j/src/samples/web-app-samples-for-adal4j/pom.xml
@@ -25,7 +25,7 @@
 		<dependency>
 			<groupId>org.json</groupId>
 			<artifactId>json</artifactId>
-			<version>20230227</version>
+			<version>20231013</version>
 		</dependency>
 		<dependency>
 			<groupId>javax.servlet</groupId>
--- a/main/plugins/org.talend.designer.components.libs/libs_src/servicenow/pom.xml
+++ b/main/plugins/org.talend.designer.components.libs/libs_src/servicenow/pom.xml
@@ -1,125 +0,0 @@
-<!--
-  Copyright (C) 2006-2020 Talend Inc. - www.talend.com
-
-  Licensed under the Apache License, Version 2.0 (the "License");
-  you may not use this file except in compliance with the License.
-  You may obtain a copy of the License at
-
-  http://www.apache.org/licenses/LICENSE-2.0
-
-  Unless required by applicable law or agreed to in writing, software
-  distributed under the License is distributed on an "AS IS" BASIS,
-  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-  See the License for the specific language governing permissions and
-  limitations under the License.
-  -->
-
-<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
-         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
-    <modelVersion>4.0.0</modelVersion>
-    <groupId>org.talend.components</groupId>
-    <artifactId>components-servicenow</artifactId>
-    <name>servicenow</name>
-    <version>1.0.1</version>
-    <properties>
-        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
-        <talend.nexus.url>https://artifacts-oss.talend.com</talend.nexus.url>
-    </properties>
-    <description>Talend Helper library for ServiceNow components</description>
-    <url>
-        https://github.com/Talend/tdi-studio-se/
-    </url>
-    <licenses>
-        <license>
-            <name>Apache-2.0</name>
-            <url>
-                http://www.talendforge.org/modules/licenses/APACHE_v2.txt
-            </url>
-        </license>
-    </licenses>
-    <dependencies>
-        <dependency>
-            <groupId>commons-codec</groupId>
-            <artifactId>commons-codec</artifactId>
-            <version>1.6</version>
-            <type>jar</type>
-        </dependency>
-        <dependency>
-            <groupId>commons-logging</groupId>
-            <artifactId>commons-logging</artifactId>
-            <version>1.1.3</version>
-            <type>jar</type>
-        </dependency>
-        <dependency>
-            <groupId>org.apache.httpcomponents</groupId>
-            <artifactId>httpclient</artifactId>
-            <version>4.3.1</version>
-            <type>jar</type>
-        </dependency>
-        <dependency>
-            <groupId>org.apache.httpcomponents</groupId>
-            <artifactId>httpclient-cache</artifactId>
-            <version>4.3.1</version>
-            <type>jar</type>
-        </dependency>
-        <dependency>
-            <groupId>org.apache.httpcomponents</groupId>
-            <artifactId>httpmime</artifactId>
-            <version>4.3.1</version>
-            <type>jar</type>
-        </dependency>
-        <dependency>
-            <groupId>org.apache.httpcomponents</groupId>
-            <artifactId>httpcore</artifactId>
-            <version>4.3.1</version>
-            <type>jar</type>
-        </dependency>
-        <dependency>
-            <groupId>org.json</groupId>
-            <artifactId>json</artifactId>
-            <version>20230227</version>
-            <type>jar</type>
-        </dependency>
-        <dependency>
-            <groupId>junit</groupId>
-            <artifactId>junit</artifactId>
-            <version>4.0</version>
-            <type>jar</type>
-            <optional>true</optional>
-        </dependency>
-    </dependencies>
-    <distributionManagement>
-        <snapshotRepository>
-            <id>talend_nexus_deployment</id>
-            <url>${talend.nexus.url}/nexus/content/repositories/TalendOpenSourceSnapshot/</url>
-        </snapshotRepository>
-        <repository>
-            <id>talend_nexus_deployment</id>
-            <url>${talend.nexus.url}/nexus/content/repositories/TalendOpenSourceRelease/</url>
-        </repository>
-    </distributionManagement>
-    <build>
-        <plugins>
-            <plugin>
-                <groupId>org.apache.maven.plugins</groupId>
-                <artifactId>maven-compiler-plugin</artifactId>
-                <version>2.3.2</version>
-                <configuration>
-                    <source>1.6</source>
-                    <target>1.6</target>
-                </configuration>
-            </plugin>
-            <plugin>
-                <groupId>org.apache.maven.plugins</groupId>
-                <artifactId>maven-deploy-plugin</artifactId>
-                <version>2.8.2</version>
-            </plugin>
-        </plugins>
-
-        <resources>
-            <resource>
-                <directory>src/main/java</directory>
-            </resource>
-        </resources>
-    </build>
-</project>
--- a/main/plugins/org.talend.designer.components.libs/libs_src/servicenow/src/main/java/org/talend/servicenow/Util.java
+++ b/main/plugins/org.talend.designer.components.libs/libs_src/servicenow/src/main/java/org/talend/servicenow/Util.java
@@ -1,269 +0,0 @@
-/**
- * Copyright (C) 2006-2019 Talend Inc. - www.talend.com
- *
- * Licensed under the Apache License, Version 2.0 (the "License");
- * you may not use this file except in compliance with the License.
- * You may obtain a copy of the License at
- *
- * http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing, software
- * distributed under the License is distributed on an "AS IS" BASIS,
- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- * See the License for the specific language governing permissions and
- * limitations under the License.
- */
-
-package org.talend.servicenow;
-
-import java.io.IOException;
-import java.util.ArrayList;
-import java.util.Collections;
-import java.util.HashMap;
-import java.util.LinkedList;
-import java.util.List;
-import java.util.Map;
-
-import org.apache.http.HttpResponse;
-import org.apache.http.ParseException;
-import org.apache.http.client.ClientProtocolException;
-import org.apache.http.client.HttpClient;
-import org.apache.http.client.methods.HttpGet;
-
-public class Util {
-
-    private HttpClient client;
-
-    private String baseurl;
-
-    public Util(HttpClient client, String baseurl) {
-        this.client = client;
-        this.baseurl = baseurl;
-    }
-
-    private Map<String, String> typeMapping = new HashMap<String, String>();
-
-    {
-        typeMapping.put("string", "id_String");
-        typeMapping.put("boolean", "id_Boolean");
-        typeMapping.put("integer", "id_Integer");
-        typeMapping.put("decimal", "id_BigDecimal");
-        typeMapping.put("float", "id_Float");
-        typeMapping.put("glide_date_time", "id_Date");
-        typeMapping.put("glide_date", "id_Date");
-        typeMapping.put("glide_time", "id_Date");
-    }
-
-    public static class ColumnMetadata {
-
-        private String name;
-
-        private String type;
-
-        private int maxlength;
-
-        private String pattern;
-
-        public ColumnMetadata(String name, String type, int maxlength, String pattern) {
-            this.name = name;
-            this.type = type;
-            this.maxlength = maxlength;
-            this.pattern = pattern;
-        }
-
-        public String getName() {
-            return name;
-        }
-
-        public String getType() {
-            return type;
-        }
-
-        public int getMaxLength() {
-            return maxlength;
-        }
-
-        public String getPattern() {
-            return pattern;
-        }
-
-        public String toString() {
-            return name + ":" + type + ":" + maxlength;
-        }
-    }
-
-    public Map<String, ColumnMetadata> getMetadata(String tablename) throws ClientProtocolException, IOException {
-        Map<String, ColumnMetadata> result = new HashMap<String, ColumnMetadata>();
-        List<String> relation = getRelationship(tablename);
-
-        StringBuilder sb = new StringBuilder();
-        for (String tname : relation) {
-            sb.setLength(0);
-            sb.append(this.baseurl);
-            sb.append("/api/now/table/");
-            sb.append("sys_dictionary");
-            sb.append("?sysparm_exclude_reference_link=true");
-            sb.append("&sysparm_query=name=");
-            sb.append(tname);
-            sb.append("&sysparm_fields=element,internal_type,max_length,active");
-
-            HttpGet httpget = new HttpGet(sb.toString());
-            httpget.setHeader("Accept", "application/json");
-
-            HttpResponse response = this.client.execute(httpget);
-            List<Map<String, String>> info = extractResponse4MultiRowFromArray(response);
-
-            for (Map<String, String> row : info) {
-                String element = row.get("element");
-                boolean active = Boolean.parseBoolean(row.get("active"));
-                if (element != null && !element.isEmpty() && active) {
-                    String talend_type = null;
-                    String pattern = null;
-
-                    String servicenow_type = (String) row.get("internal_type");
-
-                    if (servicenow_type != null && !servicenow_type.isEmpty()) {
-                        talend_type = typeMapping.get(servicenow_type);
-
-                        //need date pattern
-                        if ("glide_date_time".equals(servicenow_type)) {
-                            pattern = "yyyy-MM-dd HH:mm:ss";
-                        } else if ("glide_date".equals(servicenow_type)) {
-                            pattern = "yyyy-MM-dd";
-                        } else if ("glide_time".equals(servicenow_type)) {
-                            pattern = "HH:mm:ss";
-                        }
-                    }
-
-                    if (talend_type == null) {
-                        talend_type = "id_String";
-                    }
-
-                    int mlength = 64;
-                    String maxlength = (String) row.get("max_length");
-                    if (maxlength != null && !maxlength.isEmpty()) {
-                        mlength = Integer.parseInt(maxlength);
-                    }
-
-                    ColumnMetadata column = new ColumnMetadata(element, talend_type, mlength, pattern);
-                    result.put(element, column);
-                }
-            }
-        }
-
-        return result;
-    }
-
-    private List<String> getRelationship(String tablename) throws ClientProtocolException, IOException {
-        LinkedList<String> result = new LinkedList<String>();
-
-        StringBuilder sb = new StringBuilder();
-        sb.append(this.baseurl);
-        sb.append("/api/now/table/");
-        sb.append("sys_db_object");
-        sb.append("?sysparm_exclude_reference_link=true");
-        sb.append("&sysparm_query=name=");
-        sb.append(tablename);
-        sb.append("&sysparm_fields=name,super_class");
-
-        HttpGet httpget = new HttpGet(sb.toString());
-        httpget.setHeader("Accept", "application/json");
-
-        HttpResponse response = this.client.execute(httpget);
-        Map<String, String> info = extractResponse4OneRowFromArray(response);
-
-        result.add(info.get("name"));
-
-        String superclass = info.get("super_class");
-        while (superclass != null && !superclass.isEmpty()) {
-            sb.setLength(0);
-            sb.append(this.baseurl);
-            sb.append("/api/now/table/");
-            sb.append("sys_db_object/");
-            sb.append(superclass);
-            sb.append("?sysparm_exclude_reference_link=true");
-            sb.append("&sysparm_fields=name,super_class");
-
-            httpget = new HttpGet(sb.toString());
-            httpget.setHeader("Accept", "application/json");
-
-            response = this.client.execute(httpget);
-            info = extractResponse4OneRowFromObject(response);
-
-            result.add(info.get("name"));
-
-            superclass = info.get("super_class");
-        }
-
-        Collections.reverse(result);
-
-        return result;
-    }
-
-    private Map<String, String> extractResponse4OneRowFromArray(HttpResponse response)
-            throws ParseException, IOException {
-        validateResponse(response);
-
-        Map<String, String> result = new HashMap<String, String>();
-
-        org.json.JSONArray array = (org.json.JSONArray) getResult(response);
-
-        for (int i = 0; i < array.length(); i++) {
-            org.json.JSONObject row = (org.json.JSONObject) array.get(i);
-            for (String key : row.keySet()) {
-                result.put(key, (String) row.get(key));
-            }
-        }
-
-        return result;
-    }
-
-    private Map<String, String> extractResponse4OneRowFromObject(HttpResponse response)
-            throws ParseException, IOException {
-        validateResponse(response);
-
-        Map<String, String> result = new HashMap<String, String>();
-
-        org.json.JSONObject object = (org.json.JSONObject) getResult(response);
-
-        for (String key : object.keySet()) {
-            result.put(key, (String) object.get(key));
-        }
-
-        return result;
-    }
-
-    private List<Map<String, String>> extractResponse4MultiRowFromArray(HttpResponse response)
-            throws ParseException, IOException {
-        validateResponse(response);
-
-        List<Map<String, String>> result = new ArrayList<Map<String, String>>();
-
-        org.json.JSONArray array = (org.json.JSONArray) getResult(response);
-
-        for (int i = 0; i < array.length(); i++) {
-            Map<String, String> element = new HashMap<String, String>();
-            org.json.JSONObject row = (org.json.JSONObject) array.get(i);
-            for (String key : row.keySet()) {
-                element.put(key, (String) row.get(key));
-            }
-            result.add(element);
-        }
-
-        return result;
-    }
-
-    private void validateResponse(HttpResponse response) {
-        if (response.getStatusLine().getStatusCode() != 200) {
-            throw new RuntimeException(
-                    "Fail to get the table metadata. The operation has returned the code : " + response.getStatusLine()
-                            + ".");
-        }
-    }
-
-    private Object getResult(HttpResponse response) throws ParseException, IOException {
-        String responseBody = org.apache.http.util.EntityUtils.toString(response.getEntity());
-        org.json.JSONObject json = new org.json.JSONObject(responseBody);
-        return json.get("result");
-    }
-}
--- a/main/plugins/org.talend.designer.components.localprovider/components/tBigQueryBulkExec/tBigQueryBulkExec_java.xml
+++ b/main/plugins/org.talend.designer.components.localprovider/components/tBigQueryBulkExec/tBigQueryBulkExec_java.xml
@@ -285,7 +285,8 @@
         <IMPORT NAME="google-http-client-1.38.0.jar" MODULE="google-http-client-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client/1.38.0"  REQUIRED="true" />
         <IMPORT NAME="google-oauth-client-1.33.3.jar" MODULE="google-oauth-client-1.33.3.jar" MVN="mvn:com.google.oauth-client/google-oauth-client/1.33.3" REQUIRED="true" />
         <IMPORT NAME="google-http-client-jackson2-1.38.0.jar" MODULE="google-http-client-jackson2-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client-jackson2/1.38.0"  REQUIRED="true" />
-         <IMPORT NAME="guava-20.0.jar" MODULE="guava-20.0.jar" MVN="mvn:com.google.guava/guava/20.0" REQUIRED="true" />
+         <IMPORT NAME="guava-32.1.2-jre.jar" MODULE="guava-32.1.2-jre.jar" MVN="mvn:com.google.guava/guava/32.1.2-jre" REQUIRED="true" />
+         <IMPORT NAME="failureaccess-1.0.1.jar" MODULE="failureaccess-1.0.1.jar" MVN="mvn:com.google.guava/failureaccess/1.0.1" REQUIRED="true" />
 		<IMPORT NAME="jackson-core-2.13.4.jar" MODULE="jackson-core-2.13.4.jar" MVN="mvn:com.fasterxml.jackson.core/jackson-core/2.13.4" REQUIRED="true" />
 		<!-- REQUIRED FOR GOOGLE STORAGE -->
 		<IMPORT NAME="jets3t-0.9.1" MODULE="jets3t-0.9.1.jar" MVN="mvn:org.talend.libraries/jets3t-0.9.1/6.0.0"  REQUIRED="true" />
--- a/main/plugins/org.talend.designer.components.localprovider/components/tBigQueryInput/tBigQueryInput_java.xml
+++ b/main/plugins/org.talend.designer.components.localprovider/components/tBigQueryInput/tBigQueryInput_java.xml
@@ -211,7 +211,8 @@
 		 <IMPORT NAME="google-http-client-1.38.0.jar" MODULE="google-http-client-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client/1.38.0"  REQUIRED="true" />
 		 <IMPORT NAME="google-oauth-client-1.33.3.jar" MODULE="google-oauth-client-1.33.3.jar" MVN="mvn:com.google.oauth-client/google-oauth-client/1.33.3" REQUIRED="true" />
 		 <IMPORT NAME="google-http-client-jackson2-1.38.0.jar" MODULE="google-http-client-jackson2-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client-jackson2/1.38.0"  REQUIRED="true" />
-		 <IMPORT NAME="guava-20.0.jar" MODULE="guava-20.0.jar" MVN="mvn:com.google.guava/guava/20.0" REQUIRED="true" />
+		 <IMPORT NAME="guava-32.1.2-jre.jar" MODULE="guava-32.1.2-jre.jar" MVN="mvn:com.google.guava/guava/32.1.2-jre" REQUIRED="true" />
+		 <IMPORT NAME="failureaccess-1.0.1.jar" MODULE="failureaccess-1.0.1.jar" MVN="mvn:com.google.guava/failureaccess/1.0.1" REQUIRED="true" />
 		<IMPORT NAME="jackson-core-2.13.4.jar" MODULE="jackson-core-2.13.4.jar" MVN="mvn:com.fasterxml.jackson.core/jackson-core/2.13.4" REQUIRED="true" />
 		<IMPORT NAME="google-cloud-bigquery-1.126.3.jar" MODULE="google-cloud-bigquery-1.126.3.jar" MVN="mvn:com.google.cloud/google-cloud-bigquery/1.126.3" REQUIRED_IF="AUTH_MODE == 'SERVICEACCOUNT'" />

--- a/main/plugins/org.talend.designer.components.localprovider/components/tBigQuerySQLRow/tBigQuerySQLRow_java.xml
+++ b/main/plugins/org.talend.designer.components.localprovider/components/tBigQuerySQLRow/tBigQuerySQLRow_java.xml
@@ -197,7 +197,8 @@
            <IMPORT NAME="google-http-client-1.38.0.jar" MODULE="google-http-client-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client/1.38.0"  REQUIRED="true" />
            <IMPORT NAME="google-oauth-client-1.33.3.jar" MODULE="google-oauth-client-1.33.3.jar" MVN="mvn:com.google.oauth-client/google-oauth-client/1.33.3" REQUIRED="true" />
            <IMPORT NAME="google-http-client-jackson2-1.38.0.jar" MODULE="google-http-client-jackson2-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client-jackson2/1.38.0"  REQUIRED="true" />
-            <IMPORT NAME="guava-20.0.jar" MODULE="guava-20.0.jar" MVN="mvn:com.google.guava/guava/20.0" REQUIRED="true"/>
+            <IMPORT NAME="guava-32.1.2-jre.jar" MODULE="guava-32.1.2-jre.jar" MVN="mvn:com.google.guava/guava/32.1.2-jre" REQUIRED="true"/>
+            <IMPORT NAME="failureaccess-1.0.1.jar" MODULE="failureaccess-1.0.1.jar" MVN="mvn:com.google.guava/failureaccess/1.0.1" REQUIRED="true" />
            <IMPORT NAME="jackson-core-2.13.4.jar" MODULE="jackson-core-2.13.4.jar"
                    MVN="mvn:com.fasterxml.jackson.core/jackson-core/2.13.4" REQUIRED="true"/>
            <IMPORT NAME="google-cloud-bigquery-1.126.3.jar" MODULE="google-cloud-bigquery-1.126.3.jar"
--- a/main/plugins/org.talend.designer.components.localprovider/components/tCloudStart/tCloudStart_java.xml
+++ b/main/plugins/org.talend.designer.components.localprovider/components/tCloudStart/tCloudStart_java.xml
@@ -168,7 +168,7 @@ COMPATIBILITY="ALL"
      <IMPORT NAME="sts" MODULE="sts-2.5.0.jar" MVN="mvn:org.apache.jclouds.api/sts/2.5.0"  REQUIRED_IF="PROVIDER=='AWS_EC2'"/>
      <IMPORT NAME="jclouds-core" MODULE="jclouds-core-2.5.0.jar" MVN="mvn:org.apache.jclouds/jclouds-core/2.5.0"  REQUIRED_IF="PROVIDER=='AWS_EC2'"/>
      <IMPORT NAME="gson" MODULE="gson-2.8.9.jar" MVN="mvn:com.google.code.gson/gson/2.8.9"  REQUIRED_IF="PROVIDER=='AWS_EC2'"/>
-      <IMPORT NAME="guava" MODULE="guava-30.0-jre.jar" MVN="mvn:com.google.guava/guava/30.0-jre"  REQUIRED_IF="PROVIDER=='AWS_EC2'"/>
+      <IMPORT NAME="guava" MODULE="guava-32.1.2-jre.jar" MVN="mvn:com.google.guava/guava/32.1.2-jre"  REQUIRED_IF="PROVIDER=='AWS_EC2'"/>
      <IMPORT NAME="failureaccess" MODULE="failureaccess-1.0.1.jar" MVN="mvn:com.google.guava/failureaccess/1.0.1"  REQUIRED_IF="PROVIDER=='AWS_EC2'"/>
      <IMPORT NAME="listenablefuture" MODULE="listenablefuture-9999.0-empty-to-avoid-conflict-with-guava.jar" MVN="mvn:com.google.guava/listenablefuture/9999.0-empty-to-avoid-conflict-with-guava"  REQUIRED_IF="PROVIDER=='AWS_EC2'"/>
      <IMPORT NAME="jsr305" MODULE="jsr305-3.0.2.jar" MVN="mvn:com.google.code.findbugs/jsr305/3.0.2"  REQUIRED_IF="PROVIDER=='AWS_EC2'"/>
--- a/main/plugins/org.talend.designer.components.localprovider/components/tCloudStop/tCloudStop_java.xml
+++ b/main/plugins/org.talend.designer.components.localprovider/components/tCloudStop/tCloudStop_java.xml
@@ -77,7 +77,7 @@ COMPATIBILITY="ALL"
      <IMPORT NAME="sts" MODULE="sts-2.5.0.jar" MVN="mvn:org.apache.jclouds.api/sts/2.5.0"  REQUIRED_IF="PROVIDER=='AWS_EC2'"/>
      <IMPORT NAME="jclouds-core" MODULE="jclouds-core-2.5.0.jar" MVN="mvn:org.apache.jclouds/jclouds-core/2.5.0"  REQUIRED_IF="PROVIDER=='AWS_EC2'"/>
      <IMPORT NAME="gson" MODULE="gson-2.8.9.jar" MVN="mvn:com.google.code.gson/gson/2.8.9"  REQUIRED_IF="PROVIDER=='AWS_EC2'"/>
-      <IMPORT NAME="guava" MODULE="guava-30.0-jre.jar" MVN="mvn:com.google.guava/guava/30.0-jre"  REQUIRED_IF="PROVIDER=='AWS_EC2'"/>
+      <IMPORT NAME="guava" MODULE="guava-32.1.2-jre.jar" MVN="mvn:com.google.guava/guava/32.1.2-jre"  REQUIRED_IF="PROVIDER=='AWS_EC2'"/>
      <IMPORT NAME="failureaccess" MODULE="failureaccess-1.0.1.jar" MVN="mvn:com.google.guava/failureaccess/1.0.1"  REQUIRED_IF="PROVIDER=='AWS_EC2'"/>
      <IMPORT NAME="listenablefuture" MODULE="listenablefuture-9999.0-empty-to-avoid-conflict-with-guava.jar" MVN="mvn:com.google.guava/listenablefuture/9999.0-empty-to-avoid-conflict-with-guava"  REQUIRED_IF="PROVIDER=='AWS_EC2'"/>
      <IMPORT NAME="jsr305" MODULE="jsr305-3.0.2.jar" MVN="mvn:com.google.code.findbugs/jsr305/3.0.2"  REQUIRED_IF="PROVIDER=='AWS_EC2'"/>
--- a/main/plugins/org.talend.designer.components.localprovider/components/tFileInputExcel/tFileInputExcel_java.xml
+++ b/main/plugins/org.talend.designer.components.localprovider/components/tFileInputExcel/tFileInputExcel_java.xml
@@ -177,7 +177,7 @@
 	<CODEGENERATION>
 		<IMPORTS>
 			<IMPORT NAME="Java_Excel" MODULE="jxl.jar" MVN="mvn:org.talend.libraries/jxl/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.jexcel/lib/jxl.jar" REQUIRED_IF="(VERSION_2007 == 'false')" />
-			<IMPORT NAME="simpleexcel" MODULE="simpleexcel-2.5-20220830.jar" MVN="mvn:org.talend.components/simpleexcel/2.5-20220830" REQUIRED_IF="(VERSION_2007 == 'true') AND GENERATION_MODE == 'EVENT_MODE')" />
+			<IMPORT NAME="simpleexcel" MODULE="simpleexcel-2.9-20230830.jar" MVN="mvn:org.talend.components/simpleexcel/2.9-20230830" REQUIRED_IF="(VERSION_2007 == 'true') AND GENERATION_MODE == 'EVENT_MODE')" />
 			<IMPORT NAME="Java_DOM4J2" MODULE="dom4j-2.1.3.jar" MVN="mvn:org.dom4j/dom4j/2.1.3" REQUIRED_IF="(VERSION_2007 == 'true')" BundleID="" />
 			<IMPORT NAME="reload4j-1.2.19" MODULE="reload4j-1.2.19.jar" MVN="mvn:ch.qos.reload4j/reload4j/1.2.19" REQUIRED_IF="(VERSION_2007 == 'true')" BundleID="" />

--- a/main/plugins/org.talend.designer.components.localprovider/components/tGSBucketCreate/tGSBucketCreate_java.xml
+++ b/main/plugins/org.talend.designer.components.localprovider/components/tGSBucketCreate/tGSBucketCreate_java.xml
@@ -244,7 +244,8 @@
 				<IMPORT NAME="google-http-client-1.38.0" MODULE="google-http-client-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client/1.38.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
 				<IMPORT NAME="google-http-client-jackson2-1.38.0" MODULE="google-http-client-jackson2-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client-jackson2/1.38.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
 				<IMPORT NAME="jackson-core-2.13.4" MODULE="jackson-core-2.13.4.jar" MVN="mvn:com.fasterxml.jackson.core/jackson-core/2.13.4" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
-				<IMPORT NAME="guava-20.0.jar" MODULE="guava-20.0.jar" MVN="mvn:com.google.guava/guava/20.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
+				<IMPORT NAME="guava-32.1.2-jre.jar" MODULE="guava-32.1.2-jre.jar" MVN="mvn:com.google.guava/guava/32.1.2-jre" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
+				<IMPORT NAME="failureaccess-1.0.1.jar" MODULE="failureaccess-1.0.1.jar" MVN="mvn:com.google.guava/failureaccess/1.0.1" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />

 			<IMPORT NAME="google-cloud-storage-1.104.0" MODULE="google-cloud-storage-1.104.0.jar" MVN="mvn:com.google.cloud/google-cloud-storage/1.104.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
 				<!-- Transitive dependencies of google-cloud-storage -->
--- a/main/plugins/org.talend.designer.components.localprovider/components/tGSBucketDelete/tGSBucketDelete_java.xml
+++ b/main/plugins/org.talend.designer.components.localprovider/components/tGSBucketDelete/tGSBucketDelete_java.xml
@@ -162,7 +162,8 @@
 				<IMPORT NAME="google-http-client-1.38.0" MODULE="google-http-client-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client/1.38.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
 				<IMPORT NAME="google-http-client-jackson2-1.38.0" MODULE="google-http-client-jackson2-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client-jackson2/1.38.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
 				<IMPORT NAME="jackson-core-2.13.4" MODULE="jackson-core-2.13.4.jar" MVN="mvn:com.fasterxml.jackson.core/jackson-core/2.13.4" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
-				<IMPORT NAME="guava-20.0.jar" MODULE="guava-20.0.jar" MVN="mvn:com.google.guava/guava/20.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
+				<IMPORT NAME="guava-32.1.2-jre.jar" MODULE="guava-32.1.2-jre.jar" MVN="mvn:com.google.guava/guava/32.1.2-jre" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
+				<IMPORT NAME="failureaccess-1.0.1.jar" MODULE="failureaccess-1.0.1.jar" MVN="mvn:com.google.guava/failureaccess/1.0.1" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />

 			<IMPORT NAME="google-cloud-storage-1.104.0" MODULE="google-cloud-storage-1.104.0.jar" MVN="mvn:com.google.cloud/google-cloud-storage/1.104.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
 				<!-- Transitive dependencies of google-cloud-storage -->
--- a/main/plugins/org.talend.designer.components.localprovider/components/tGSBucketExist/tGSBucketExist_java.xml
+++ b/main/plugins/org.talend.designer.components.localprovider/components/tGSBucketExist/tGSBucketExist_java.xml
@@ -163,7 +163,8 @@
 				<IMPORT NAME="google-http-client-1.38.0" MODULE="google-http-client-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client/1.38.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
 				<IMPORT NAME="google-http-client-jackson2-1.38.0" MODULE="google-http-client-jackson2-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client-jackson2/1.38.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
 				<IMPORT NAME="jackson-core-2.13.4" MODULE="jackson-core-2.13.4.jar" MVN="mvn:com.fasterxml.jackson.core/jackson-core/2.13.4" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
-				<IMPORT NAME="guava-20.0.jar" MODULE="guava-20.0.jar" MVN="mvn:com.google.guava/guava/20.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
+				<IMPORT NAME="guava-32.1.2-jre.jar" MODULE="guava-32.1.2-jre.jar" MVN="mvn:com.google.guava/guava/32.1.2-jre" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
+				<IMPORT NAME="failureaccess-1.0.1.jar" MODULE="failureaccess-1.0.1.jar" MVN="mvn:com.google.guava/failureaccess/1.0.1" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />

 			<IMPORT NAME="google-cloud-storage-1.104.0" MODULE="google-cloud-storage-1.104.0.jar" MVN="mvn:com.google.cloud/google-cloud-storage/1.104.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
 				<!-- Transitive dependencies of google-cloud-storage -->
--- a/main/plugins/org.talend.designer.components.localprovider/components/tGSBucketList/tGSBucketList_java.xml
+++ b/main/plugins/org.talend.designer.components.localprovider/components/tGSBucketList/tGSBucketList_java.xml
@@ -167,7 +167,8 @@
 				<IMPORT NAME="google-http-client-1.38.0" MODULE="google-http-client-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client/1.38.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
 				<IMPORT NAME="google-http-client-jackson2-1.38.0" MODULE="google-http-client-jackson2-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client-jackson2/1.38.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
 				<IMPORT NAME="jackson-core-2.13.4" MODULE="jackson-core-2.13.4.jar" MVN="mvn:com.fasterxml.jackson.core/jackson-core/2.13.4" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
-				<IMPORT NAME="guava-20.0.jar" MODULE="guava-20.0.jar" MVN="mvn:com.google.guava/guava/20.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
+				<IMPORT NAME="guava-32.1.2-jre.jar" MODULE="guava-32.1.2-jre.jar" MVN="mvn:com.google.guava/guava/32.1.2-jre" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
+				<IMPORT NAME="failureaccess-1.0.1.jar" MODULE="failureaccess-1.0.1.jar" MVN="mvn:com.google.guava/failureaccess/1.0.1" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />

 			<IMPORT NAME="google-cloud-storage-1.104.0" MODULE="google-cloud-storage-1.104.0.jar" MVN="mvn:com.google.cloud/google-cloud-storage/1.104.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
 				<!-- Transitive dependencies of google-cloud-storage -->
--- a/main/plugins/org.talend.designer.components.localprovider/components/tGSConnection/tGSConnection_java.xml
+++ b/main/plugins/org.talend.designer.components.localprovider/components/tGSConnection/tGSConnection_java.xml
@@ -114,7 +114,8 @@
 				<IMPORT NAME="google-http-client-1.38.0" MODULE="google-http-client-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client/1.38.0" REQUIRED_IF="(AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN')" />
 				<IMPORT NAME="google-http-client-jackson2-1.38.0" MODULE="google-http-client-jackson2-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client-jackson2/1.38.0" REQUIRED_IF="(AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN')" />
 				<IMPORT NAME="jackson-core-2.13.4" MODULE="jackson-core-2.13.4.jar" MVN="mvn:com.fasterxml.jackson.core/jackson-core/2.13.4" REQUIRED_IF="(AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN')" />
-				<IMPORT NAME="guava-20.0.jar" MODULE="guava-20.0.jar" MVN="mvn:com.google.guava/guava/20.0" REQUIRED_IF="(AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN')" />
+				<IMPORT NAME="guava-32.1.2-jre.jar" MODULE="guava-32.1.2-jre.jar" MVN="mvn:com.google.guava/guava/32.1.2-jre" REQUIRED_IF="(AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN')" />
+				<IMPORT NAME="failureaccess-1.0.1.jar" MODULE="failureaccess-1.0.1.jar" MVN="mvn:com.google.guava/failureaccess/1.0.1" REQUIRED_IF="(AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN')" />

 			<IMPORT NAME="google-cloud-storage-1.104.0" MODULE="google-cloud-storage-1.104.0.jar" MVN="mvn:com.google.cloud/google-cloud-storage/1.104.0" REQUIRED_IF="(AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN')" />
 				<!-- Transitive dependencies of google-cloud-storage -->
--- a/main/plugins/org.talend.designer.components.localprovider/components/tGSCopy/tGSCopy_java.xml
+++ b/main/plugins/org.talend.designer.components.localprovider/components/tGSCopy/tGSCopy_java.xml
@@ -240,7 +240,8 @@
 				<IMPORT NAME="google-http-client-1.38.0" MODULE="google-http-client-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client/1.38.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
 				<IMPORT NAME="google-http-client-jackson2-1.38.0" MODULE="google-http-client-jackson2-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client-jackson2/1.38.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
 				<IMPORT NAME="jackson-core-2.13.4" MODULE="jackson-core-2.13.4.jar" MVN="mvn:com.fasterxml.jackson.core/jackson-core/2.13.4" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
-				<IMPORT NAME="guava-20.0.jar" MODULE="guava-20.0.jar" MVN="mvn:com.google.guava/guava/20.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
+				<IMPORT NAME="guava-32.1.2-jre.jar" MODULE="guava-32.1.2-jre.jar" MVN="mvn:com.google.guava/guava/32.1.2-jre" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
+				<IMPORT NAME="failureaccess-1.0.1.jar" MODULE="failureaccess-1.0.1.jar" MVN="mvn:com.google.guava/failureaccess/1.0.1" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />

 			<IMPORT NAME="google-cloud-storage-1.104.0" MODULE="google-cloud-storage-1.104.0.jar" MVN="mvn:com.google.cloud/google-cloud-storage/1.104.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
 				<!-- Transitive dependencies of google-cloud-storage -->
--- a/main/plugins/org.talend.designer.components.localprovider/components/tGSDelete/tGSDelete_java.xml
+++ b/main/plugins/org.talend.designer.components.localprovider/components/tGSDelete/tGSDelete_java.xml
@@ -233,7 +233,8 @@
 				<IMPORT NAME="google-http-client-1.38.0" MODULE="google-http-client-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client/1.38.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
 				<IMPORT NAME="google-http-client-jackson2-1.38.0" MODULE="google-http-client-jackson2-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client-jackson2/1.38.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
 				<IMPORT NAME="jackson-core-2.13.4" MODULE="jackson-core-2.13.4.jar" MVN="mvn:com.fasterxml.jackson.core/jackson-core/2.13.4" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
-				<IMPORT NAME="guava-20.0.jar" MODULE="guava-20.0.jar" MVN="mvn:com.google.guava/guava/20.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
+				<IMPORT NAME="guava-32.1.2-jre.jar" MODULE="guava-32.1.2-jre.jar" MVN="mvn:com.google.guava/guava/32.1.2-jre" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
+				<IMPORT NAME="failureaccess-1.0.1.jar" MODULE="failureaccess-1.0.1.jar" MVN="mvn:com.google.guava/failureaccess/1.0.1" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />

 			<IMPORT NAME="google-cloud-storage-1.104.0" MODULE="google-cloud-storage-1.104.0.jar" MVN="mvn:com.google.cloud/google-cloud-storage/1.104.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
 				<!-- Transitive dependencies of google-cloud-storage -->
--- a/main/plugins/org.talend.designer.components.localprovider/components/tGSGet/tGSGet_java.xml
+++ b/main/plugins/org.talend.designer.components.localprovider/components/tGSGet/tGSGet_java.xml
@@ -271,7 +271,8 @@
 				<IMPORT NAME="google-http-client-1.38.0" MODULE="google-http-client-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client/1.38.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
 				<IMPORT NAME="google-http-client-jackson2-1.38.0" MODULE="google-http-client-jackson2-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client-jackson2/1.38.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
 				<IMPORT NAME="jackson-core-2.13.4" MODULE="jackson-core-2.13.4.jar" MVN="mvn:com.fasterxml.jackson.core/jackson-core/2.13.4" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
-				<IMPORT NAME="guava-20.0.jar" MODULE="guava-20.0.jar" MVN="mvn:com.google.guava/guava/20.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
+				<IMPORT NAME="guava-32.1.2-jre.jar" MODULE="guava-32.1.2-jre.jar" MVN="mvn:com.google.guava/guava/32.1.2-jre" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
+				<IMPORT NAME="failureaccess-1.0.1.jar" MODULE="failureaccess-1.0.1.jar" MVN="mvn:com.google.guava/failureaccess/1.0.1" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />

 			<IMPORT NAME="google-cloud-storage-1.104.0" MODULE="google-cloud-storage-1.104.0.jar" MVN="mvn:com.google.cloud/google-cloud-storage/1.104.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
 				<!-- Transitive dependencies of google-cloud-storage -->
--- a/main/plugins/org.talend.designer.components.localprovider/components/tGSList/tGSList_java.xml
+++ b/main/plugins/org.talend.designer.components.localprovider/components/tGSList/tGSList_java.xml
@@ -233,7 +233,8 @@
 				<IMPORT NAME="google-http-client-1.38.0" MODULE="google-http-client-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client/1.38.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
 				<IMPORT NAME="google-http-client-jackson2-1.38.0" MODULE="google-http-client-jackson2-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client-jackson2/1.38.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
 				<IMPORT NAME="jackson-core-2.13.4" MODULE="jackson-core-2.13.4.jar" MVN="mvn:com.fasterxml.jackson.core/jackson-core/2.13.4" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
-				<IMPORT NAME="guava-20.0.jar" MODULE="guava-20.0.jar" MVN="mvn:com.google.guava/guava/20.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
+				<IMPORT NAME="guava-32.1.2-jre.jar" MODULE="guava-32.1.2-jre.jar" MVN="mvn:com.google.guava/guava/32.1.2-jre" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
+				<IMPORT NAME="failureaccess-1.0.1.jar" MODULE="failureaccess-1.0.1.jar" MVN="mvn:com.google.guava/failureaccess/1.0.1" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />

 			<IMPORT NAME="google-cloud-storage-1.104.0" MODULE="google-cloud-storage-1.104.0.jar" MVN="mvn:com.google.cloud/google-cloud-storage/1.104.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
 				<!-- Transitive dependencies of google-cloud-storage -->
--- a/main/plugins/org.talend.designer.components.localprovider/components/tGSPut/tGSPut_java.xml
+++ b/main/plugins/org.talend.designer.components.localprovider/components/tGSPut/tGSPut_java.xml
@@ -217,7 +217,8 @@
 				<IMPORT NAME="google-http-client-1.38.0" MODULE="google-http-client-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client/1.38.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
 				<IMPORT NAME="google-http-client-jackson2-1.38.0" MODULE="google-http-client-jackson2-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client-jackson2/1.38.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
 				<IMPORT NAME="jackson-core-2.13.4" MODULE="jackson-core-2.13.4.jar" MVN="mvn:com.fasterxml.jackson.core/jackson-core/2.13.4" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
-				<IMPORT NAME="guava-20.0.jar" MODULE="guava-20.0.jar" MVN="mvn:com.google.guava/guava/20.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
+				<IMPORT NAME="guava-32.1.2-jre.jar" MODULE="guava-32.1.2-jre.jar" MVN="mvn:com.google.guava/guava/32.1.2-jre" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
+				<IMPORT NAME="failureaccess-1.0.1.jar" MODULE="failureaccess-1.0.1.jar" MVN="mvn:com.google.guava/failureaccess/1.0.1" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />

 			<IMPORT NAME="google-cloud-storage-1.104.0" MODULE="google-cloud-storage-1.104.0.jar" MVN="mvn:com.google.cloud/google-cloud-storage/1.104.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((AUTH_TYPE == 'SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN'))" />
 				<!-- Transitive dependencies of google-cloud-storage -->
--- a/main/plugins/org.talend.designer.components.localprovider/components/tGoogleDataprocManage/tGoogleDataprocManage_java.xml
+++ b/main/plugins/org.talend.designer.components.localprovider/components/tGoogleDataprocManage/tGoogleDataprocManage_java.xml
@@ -406,9 +406,11 @@
 			<IMPORT NAME="gson"
 				MODULE="gson-2.8.9.jar" MVN="mvn:com.google.code.gson/gson/2.8.9" REQUIRED="true"/>
 			<IMPORT NAME="json"
-				MODULE="json-20230227.jar" MVN="mvn:org.json/json/20230227" REQUIRED="true"/>
+				MODULE="json-20231013.jar" MVN="mvn:org.json/json/20231013" REQUIRED="true"/>
 			<IMPORT NAME="guava"
-				MODULE="guava-27.0.1-jre.jar" MVN="mvn:com.google.guava/guava/27.0.1-jre" REQUIRED="true"/>
+				MODULE="guava-32.1.2-jre.jar" MVN="mvn:com.google.guava/guava/32.1.2-jre" REQUIRED="true"/>
+			<IMPORT NAME="failureaccess-1.0.1.jar" 
+			    MODULE="failureaccess-1.0.1.jar" MVN="mvn:com.google.guava/failureaccess/1.0.1" REQUIRED="true" />
 			<IMPORT NAME="jackson-core"
 				MODULE="jackson-core-2.13.4.jar" MVN="mvn:com.fasterxml.jackson.core/jackson-core/2.13.4" REQUIRED="true"/>
 			<IMPORT NAME="jackson-core-asl"
--- a/main/plugins/org.talend.designer.components.localprovider/components/tMomConnection/tMomConnection_java.xml
+++ b/main/plugins/org.talend.designer.components.localprovider/components/tMomConnection/tMomConnection_java.xml
@@ -182,7 +182,7 @@
  <CODEGENERATION>
    <IMPORTS>
      
-      <IMPORT NAME="activemq-client-5.15.15.jar" MODULE="activemq-client-5.15.15.jar" MVN="mvn:org.apache.activemq/activemq-client/5.15.15" REQUIRED_IF="SERVER == 'ACTIVEMQ'" BundleID="" />
+      <IMPORT NAME="activemq-client-5.15.16.jar" MODULE="activemq-client-5.15.16.jar" MVN="mvn:org.apache.activemq/activemq-client/5.15.16" REQUIRED_IF="SERVER == 'ACTIVEMQ'" BundleID="" />
      <IMPORT NAME="geronimo-jms_1.1_spec-1.1.1.jar" MODULE="geronimo-jms_1.1_spec-1.1.1.jar" MVN="mvn:org.talend.libraries/geronimo-jms_1.1_spec-1.1.1/6.3.0" REQUIRED_IF="SERVER == 'ACTIVEMQ'" />
      <IMPORT NAME="geronimo-j2ee-management_1.1_spec-1.0.1.jar" MODULE="geronimo-j2ee-management_1.1_spec-1.0.1.jar" MVN="mvn:org.talend.libraries/geronimo-j2ee-management_1.1_spec-1.0.1/6.3.0" REQUIRED_IF="SERVER == 'ACTIVEMQ'" />
      <IMPORT NAME="hawtbuf-1.11.jar" MODULE="hawtbuf-1.11.jar" MVN="mvn:org.talend.libraries/hawtbuf-1.11/6.3.0" REQUIRED_IF="SERVER == 'ACTIVEMQ'" />
@@ -190,7 +190,7 @@
      <IMPORT NAME="slf4j-log4j12-1.7.16.jar" MODULE="slf4j-log4j12-1.7.16.jar" MVN="mvn:org.slf4j/slf4j-log4j12/1.7.16" REQUIRED_IF="SERVER == 'ACTIVEMQ'" />
      
      <IMPORT NAME="WEBSPHERE MQ LIB" MODULE="com.ibm.mq.allclient-9.2.4.0.jar" MVN="mvn:com.ibm.mq/com.ibm.mq.allclient/9.2.4.0" REQUIRED_IF="(SERVER == 'WEBSPHERE')" />
-      <IMPORT NAME="JSON In Java " MODULE="json-20230227.jar" MVN="mvn:org.json/json/20230227" REQUIRED_IF="(SERVER == 'WEBSPHERE')" />
+      <IMPORT NAME="JSON In Java " MODULE="json-20231013.jar" MVN="mvn:org.json/json/20231013" REQUIRED_IF="(SERVER == 'WEBSPHERE')" />
      <IMPORT NAME="bcprov-jdk15on-1.69" MODULE="bcprov-jdk15on-1.69.jar" MVN="mvn:org.bouncycastle/bcprov-jdk15on/1.69" REQUIRED_IF="(SERVER == 'WEBSPHERE')" />
      <IMPORT NAME="bcpkix-jdk15on-1.69" MODULE="bcpkix-jdk15on-1.69.jar" MVN="mvn:org.bouncycastle/bcpkix-jdk15on/1.69" REQUIRED_IF="(SERVER == 'WEBSPHERE')" />
      <IMPORT NAME="bcutil-jdk15on-1.69" MODULE="bcutil-jdk15on-1.69.jar" MVN="mvn:org.bouncycastle/bcutil-jdk15on/1.69" REQUIRED_IF="(SERVER == 'WEBSPHERE')" />
--- a/main/plugins/org.talend.designer.components.localprovider/components/tMomInputLoop/tMomInputLoop_java.xml
+++ b/main/plugins/org.talend.designer.components.localprovider/components/tMomInputLoop/tMomInputLoop_java.xml
@@ -308,7 +308,7 @@
    <IMPORTS>
      
      <!-- ActiveMQ -->
-      <IMPORT NAME="activemq-client-5.15.15.jar" MODULE="activemq-client-5.15.15.jar" MVN="mvn:org.apache.activemq/activemq-client/5.15.15" REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'ACTIVEMQ')" BundleID="" />
+      <IMPORT NAME="activemq-client-5.15.16.jar" MODULE="activemq-client-5.15.16.jar" MVN="mvn:org.apache.activemq/activemq-client/5.15.16" REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'ACTIVEMQ')" BundleID="" />
      <IMPORT NAME="geronimo-jms_1.1_spec-1.1.1.jar" MODULE="geronimo-jms_1.1_spec-1.1.1.jar" MVN="mvn:org.talend.libraries/geronimo-jms_1.1_spec-1.1.1/6.3.0" REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'ACTIVEMQ')" />
      <IMPORT NAME="geronimo-j2ee-management_1.1_spec-1.0.1.jar" MODULE="geronimo-j2ee-management_1.1_spec-1.0.1.jar" MVN="mvn:org.talend.libraries/geronimo-j2ee-management_1.1_spec-1.0.1/6.3.0" REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'ACTIVEMQ')" />
      <IMPORT NAME="hawtbuf-1.11.jar" MODULE="hawtbuf-1.11.jar" MVN="mvn:org.talend.libraries/hawtbuf-1.11/6.3.0" REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'ACTIVEMQ')" />
@@ -329,7 +329,7 @@

 	  <!-- Websphere MQ -->
      <IMPORT NAME="WEBSPHERE MQ LIB" MODULE="com.ibm.mq.allclient-9.2.4.0.jar" MVN="mvn:com.ibm.mq/com.ibm.mq.allclient/9.2.4.0"  REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'WEBSPHERE')" />
-      <IMPORT NAME="JSON In Java " MODULE="json-20230227.jar" MVN="mvn:org.json/json/20230227" REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'WEBSPHERE')" />
+      <IMPORT NAME="JSON In Java " MODULE="json-20231013.jar" MVN="mvn:org.json/json/20231013" REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'WEBSPHERE')" />
      <IMPORT NAME="bcprov-jdk15on-1.69" MODULE="bcprov-jdk15on-1.69.jar" MVN="mvn:org.bouncycastle/bcprov-jdk15on/1.69" REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'WEBSPHERE')" />
      <IMPORT NAME="bcpkix-jdk15on-1.69" MODULE="bcpkix-jdk15on-1.69.jar" MVN="mvn:org.bouncycastle/bcpkix-jdk15on/1.69" REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'WEBSPHERE')" />
      <IMPORT NAME="bcutil-jdk15on-1.69" MODULE="bcutil-jdk15on-1.69.jar" MVN="mvn:org.bouncycastle/bcutil-jdk15on/1.69" REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'WEBSPHERE')" />
--- a/main/plugins/org.talend.designer.components.localprovider/components/tMomMessageIdList/tMomMessageIdList_java.xml
+++ b/main/plugins/org.talend.designer.components.localprovider/components/tMomMessageIdList/tMomMessageIdList_java.xml
@@ -83,7 +83,7 @@ This component only support Websphere MQ currently!
  <CODEGENERATION>
   <IMPORTS>
       <IMPORT NAME="WEBSPHERE MQ LIB" MODULE="com.ibm.mq.allclient-9.2.4.0.jar" MVN="mvn:com.ibm.mq/com.ibm.mq.allclient/9.2.4.0"  REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'WEBSPHERE')" />
-       <IMPORT NAME="JSON In Java " MODULE="json-20230227.jar" MVN="mvn:org.json/json/20230227" REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'WEBSPHERE')" />
+       <IMPORT NAME="JSON In Java " MODULE="json-20231013.jar" MVN="mvn:org.json/json/20231013" REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'WEBSPHERE')" />
       <IMPORT NAME="bcprov-jdk15on-1.69" MODULE="bcprov-jdk15on-1.69.jar" MVN="mvn:org.bouncycastle/bcprov-jdk15on/1.69" REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'WEBSPHERE')" />
       <IMPORT NAME="bcpkix-jdk15on-1.69" MODULE="bcpkix-jdk15on-1.69.jar" MVN="mvn:org.bouncycastle/bcpkix-jdk15on/1.69" REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'WEBSPHERE')" />
       <IMPORT NAME="bcutil-jdk15on-1.69" MODULE="bcutil-jdk15on-1.69.jar" MVN="mvn:org.bouncycastle/bcutil-jdk15on/1.69" REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'WEBSPHERE')" />
--- a/main/plugins/org.talend.designer.components.localprovider/components/tMomOutput/tMomOutput_java.xml
+++ b/main/plugins/org.talend.designer.components.localprovider/components/tMomOutput/tMomOutput_java.xml
@@ -433,7 +433,7 @@
  <CODEGENERATION>
    <IMPORTS>
      <!-- ActiveMQ -->
-      <IMPORT NAME="activemq-client-5.15.15.jar" MODULE="activemq-client-5.15.15.jar" MVN="mvn:org.apache.activemq/activemq-client/5.15.15" REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'ACTIVEMQ')" BundleID="" />
+      <IMPORT NAME="activemq-client-5.15.16.jar" MODULE="activemq-client-5.15.16.jar" MVN="mvn:org.apache.activemq/activemq-client/5.15.16" REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'ACTIVEMQ')" BundleID="" />
      <IMPORT NAME="geronimo-jms_1.1_spec-1.1.1.jar" MODULE="geronimo-jms_1.1_spec-1.1.1.jar" MVN="mvn:org.talend.libraries/geronimo-jms_1.1_spec-1.1.1/6.3.0" REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'ACTIVEMQ')" />
      <IMPORT NAME="geronimo-j2ee-management_1.1_spec-1.0.1.jar" MODULE="geronimo-j2ee-management_1.1_spec-1.0.1.jar" MVN="mvn:org.talend.libraries/geronimo-j2ee-management_1.1_spec-1.0.1/6.3.0" REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'ACTIVEMQ')" />
      <IMPORT NAME="hawtbuf-1.11.jar" MODULE="hawtbuf-1.11.jar" MVN="mvn:org.talend.libraries/hawtbuf-1.11/6.3.0" REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'ACTIVEMQ')" />
@@ -454,7 +454,7 @@

 	  <!-- Websphere MQ -->
      <IMPORT NAME="WEBSPHERE MQ LIB" MODULE="com.ibm.mq.allclient-9.2.4.0.jar" MVN="mvn:com.ibm.mq/com.ibm.mq.allclient/9.2.4.0"  REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'WEBSPHERE')" />
-      <IMPORT NAME="JSON In Java " MODULE="json-20230227.jar" MVN="mvn:org.json/json/20230227" REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'WEBSPHERE')" />
+      <IMPORT NAME="JSON In Java " MODULE="json-20231013.jar" MVN="mvn:org.json/json/20231013" REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'WEBSPHERE')" />
      <IMPORT NAME="bcprov-jdk15on-1.69" MODULE="bcprov-jdk15on-1.69.jar" MVN="mvn:org.bouncycastle/bcprov-jdk15on/1.69" REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'WEBSPHERE')" />
      <IMPORT NAME="bcpkix-jdk15on-1.69" MODULE="bcpkix-jdk15on-1.69.jar" MVN="mvn:org.bouncycastle/bcpkix-jdk15on/1.69" REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'WEBSPHERE')" />
      <IMPORT NAME="bcutil-jdk15on-1.69" MODULE="bcutil-jdk15on-1.69.jar" MVN="mvn:org.bouncycastle/bcutil-jdk15on/1.69" REQUIRED_IF="(USE_CONNECTION=='false' AND SERVER == 'WEBSPHERE')" />
--- a/main/plugins/org.talend.designer.components.localprovider/components/tServiceNowInput/tServiceNowInput_java.xml
+++ b/main/plugins/org.talend.designer.components.localprovider/components/tServiceNowInput/tServiceNowInput_java.xml
@@ -455,8 +455,8 @@
      		<IMPORT MODULE="httpclient-cache-4.3.1.jar" NAME="httpclient-cache" MVN="mvn:org.apache.httpcomponents/httpclient-cache/4.3.1" REQUIRED="true"/>
 	      	<IMPORT NAME="httpcore-4.4.13" MODULE="httpcore-4.4.13.jar" MVN="mvn:org.apache.httpcomponents/httpcore/4.4.13" REQUIRED="true"/>
 	      	<IMPORT MODULE="httpmime-4.3.1.jar" NAME="httpmime" MVN="mvn:org.apache.httpcomponents/httpmime/4.3.1" REQUIRED="true"/>
-            <IMPORT NAME="json" MODULE="json-20230227.jar" MVN="mvn:org.json/json/20230227" REQUIRED="true"/>
-            <IMPORT NAME="components-servicenow" MODULE="components-servicenow-1.0.1-20210428.jar" MVN="mvn:org.talend.components/components-servicenow/1.0.1-20210428" REQUIRED="true"/>
+            <IMPORT NAME="json" MODULE="json-20231013.jar" MVN="mvn:org.json/json/20231013" REQUIRED="true"/>
+            <IMPORT NAME="components-servicenow" MODULE="components-servicenow-1.1-20231115.jar" MVN="mvn:org.talend.components/components-servicenow/1.1-20231115" REQUIRED="true"/>
        </IMPORTS>
    </CODEGENERATION>
    <RETURNS>
--- a/main/plugins/org.talend.designer.components.localprovider/components/tServiceNowOutput/tServiceNowOutput_java.xml
+++ b/main/plugins/org.talend.designer.components.localprovider/components/tServiceNowOutput/tServiceNowOutput_java.xml
@@ -426,7 +426,7 @@
 	      	<IMPORT MODULE="httpclient-cache-4.3.1.jar" NAME="httpclient-cache" MVN="mvn:org.apache.httpcomponents/httpclient-cache/4.3.1" REQUIRED="true"/>
 	      	<IMPORT NAME="httpcore-4.4.13" MODULE="httpcore-4.4.13.jar" MVN="mvn:org.apache.httpcomponents/httpcore/4.4.13" REQUIRED="true"/>
 	      	<IMPORT MODULE="httpmime-4.3.1.jar" NAME="httpmime" MVN="mvn:org.apache.httpcomponents/httpmime/4.3.1" REQUIRED="true"/>
-            <IMPORT NAME="json" MODULE="json-20230227.jar" MVN="mvn:org.json/json/20230227" REQUIRED="true"/>
+            <IMPORT NAME="json" MODULE="json-20231013.jar" MVN="mvn:org.json/json/20231013" REQUIRED="true"/>
            <IMPORT MODULE="commons-io-2.8.0.jar" NAME="commons-io" MVN="mvn:commons-io/commons-io/2.8.0" REQUIRED="true"/>
        </IMPORTS>
    </CODEGENERATION>
--- a/main/plugins/org.talend.designer.maven.job/resources/templates/osgi/assembly_job_template.xml
+++ b/main/plugins/org.talend.designer.maven.job/resources/templates/osgi/assembly_job_template.xml
@@ -9,6 +9,14 @@
        <format>jar</format>
    </formats>
    <fileSets>
+        <fileSet>
+            <!-- add wsdl -->
+            <directory>${basedir}/src/main/java</directory>
+            <outputDirectory>${file.separator}</outputDirectory>
+            <includes>
+                <include>${talend.job.path}/**/*.wsdl</include>
+            </includes>
+        </fileSet>
        <fileSet> <!-- add java classes -->
            <directory>${project.build.outputDirectory}</directory>
            <outputDirectory>${file.separator}</outputDirectory>
--- a/main/plugins/org.talend.designer.maven.job/resources/templates/osgi/pom_job_template.xml
+++ b/main/plugins/org.talend.designer.maven.job/resources/templates/osgi/pom_job_template.xml
@@ -38,6 +38,7 @@
        <project.distribution-management.repository.id>@ProjectDistributionManagementRepositoryId@</project.distribution-management.repository.id>
        <project.distribution-management.repository.url>@ProjectDistributionManagementRepositoryUrl@</project.distribution-management.repository.url>
        <docker.skip>true</docker.skip>
+        <talend.job.parent.id>@JobParentId@</talend.job.parent.id>
 	</properties>

 	<dependencies>
@@ -55,7 +56,12 @@
 					<dependency>
 						<groupId>org.codehaus.plexus</groupId>
 						<artifactId>plexus-utils</artifactId>
-						<version>3.0.24</version>
+						<version>4.0.0</version>
+					</dependency>
+					<dependency>
+						<groupId>org.codehaus.plexus</groupId>
+						<artifactId>plexus-xml</artifactId>
+						<version>4.0.0</version>
 					</dependency>
 					<dependency>
 				      <groupId>org.apache.commons</groupId>
@@ -75,12 +81,12 @@
 					<dependency>
 						<groupId>org.codehaus.plexus</groupId>
 						<artifactId>plexus-archiver</artifactId>
-						<version>3.6.0</version>
+						<version>4.8.0</version>
 					</dependency>
 					<dependency>
 						<groupId>org.codehaus.plexus</groupId>
 					    <artifactId>plexus-io</artifactId>
-					    <version>3.0.0</version>
+					    <version>3.4.1</version>
 					</dependency>
 				</dependencies>
 				<configuration>
@@ -109,6 +115,7 @@
                            <goal>single</goal>
                        </goals>
                        <configuration>
+			    <attach>false</attach>
                            <descriptors>
                                <descriptor>${basedir}/src/main/assemblies/assembly.xml</descriptor>
                            </descriptors>
@@ -142,6 +149,7 @@
                                    <goal>single</goal>
                                </goals>
                                <configuration>
+				    <attach>false</attach>
                                    <descriptors>
                                        <descriptor>${basedir}/src/main/assemblies/assembly.xml</descriptor>
                                    </descriptors>
--- a/main/plugins/org.talend.designer.maven.job/resources/templates/standalone/pom_job_template.xml
+++ b/main/plugins/org.talend.designer.maven.job/resources/templates/standalone/pom_job_template.xml
@@ -28,6 +28,7 @@
 		<talend.job.date>${maven.build.timestamp}</talend.job.date>
 		<talend.job.context>@JobContext@</talend.job.context>
 		<talend.job.id>@JobId@</talend.job.id>
+		<talend.job.parent.id>@JobParentId@</talend.job.parent.id>
 		<talend.job.type>@JobType@</talend.job.type>
 		<talend.job.folder>@JobFolder@</talend.job.folder>
 		<talend.job.framework>@Framework@</talend.job.framework>
--- a/main/plugins/org.talend.designer.runprocess/src/main/java/org/talend/designer/runprocess/maven/MavenJavaProcessor.java
+++ b/main/plugins/org.talend.designer.runprocess/src/main/java/org/talend/designer/runprocess/maven/MavenJavaProcessor.java
@@ -347,6 +347,10 @@ public class MavenJavaProcessor extends JavaProcessor {
        parameters.put(IBuildPomCreatorParameters.CP_WIN, this.windowsClasspath);
        parameters.put(IBuildPomCreatorParameters.ARGUMENTS_MAP, getArguments());
        parameters.put(IBuildPomCreatorParameters.OVERWRITE_POM, Boolean.TRUE);
+        
+        if (itemProperty.getParentItem() !=null) {
+        	parameters.put(IBuildParametes.PARENT_ITEM, itemProperty.getParentItem());
+        }

        AbstractBuildProvider foundBuildProvider = BuildExportManager.getInstance().getBuildProvider(buildTypeName, parameters);
        if (foundBuildProvider != null) {
--- a/main/plugins/org.talend.libraries.excel/.classpath
+++ b/main/plugins/org.talend.libraries.excel/.classpath
@@ -8,7 +8,7 @@
 	<classpathentry exported="true" kind="lib" path="lib/poi-ooxml-4.1.2-20200903124306_modified_talend.jar"/>
 	<classpathentry exported="true" kind="lib" path="lib/poi-ooxml-schemas-4.1.2-20200903124306_modified_talend.jar"/>
 	<classpathentry exported="true" kind="lib" path="lib/poi-scratchpad-4.1.2-20200903124306_modified_talend.jar"/>
-	<classpathentry exported="true" kind="lib" path="lib/simpleexcel-2.5-20220830.jar"/>
+	<classpathentry exported="true" kind="lib" path="lib/simpleexcel-2.9-20230830.jar"/>
 	<classpathentry exported="true" kind="lib" path="lib/talendExcel-1.6-20200923.jar"/>
 	<classpathentry exported="true" kind="lib" path="lib/talendMsgMailUtil-1.2-20200923.jar"/>
 	<classpathentry kind="con" path="org.eclipse.jdt.launching.JRE_CONTAINER"/>
--- a/main/plugins/org.talend.libraries.excel/META-INF/MANIFEST.MF
+++ b/main/plugins/org.talend.libraries.excel/META-INF/MANIFEST.MF
@@ -5,7 +5,7 @@ Bundle-SymbolicName: org.talend.libraries.excel
 Bundle-Version: 7.3.1.qualifier
 Bundle-ClassPath: .,
 lib/commons-collections4-4.1.jar,
- lib/simpleexcel-2.5-20220830.jar,
+ lib/simpleexcel-2.9-20230830.jar,
 lib/poi-4.1.2-20200903124306_modified_talend.jar,
 lib/poi-ooxml-4.1.2-20200903124306_modified_talend.jar,
 lib/poi-ooxml-schemas-4.1.2-20200903124306_modified_talend.jar,
--- a/main/plugins/org.talend.libraries.excel/pom.xml
+++ b/main/plugins/org.talend.libraries.excel/pom.xml
@@ -76,7 +76,7 @@
 								<artifactItem>
                                    <groupId>${talend.groupid}</groupId>
                                    <artifactId>simpleexcel</artifactId>
-                                    <version>2.5-20220830</version>
+                                    <version>2.9-20230830</version>
                                </artifactItem>
                                <artifactItem>
                                    <groupId>${talend.groupid}</groupId>
--- a/main/plugins/org.talend.libraries.guava/.classpath
+++ b/main/plugins/org.talend.libraries.guava/.classpath
@@ -1,6 +1,6 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <classpath>
-	<classpathentry exported="true" kind="lib" path="lib/guava-18.0.jar"/>
+	<classpathentry exported="true" kind="lib" path="lib/guava-32.0.1-jre.jar"/>
 	<classpathentry kind="con" path="org.eclipse.jdt.launching.JRE_CONTAINER"/>
 	<classpathentry kind="con" path="org.eclipse.pde.core.requiredPlugins"/>
 	<classpathentry kind="output" path="bin"/>
--- a/main/plugins/org.talend.libraries.guava/META-INF/MANIFEST.MF
+++ b/main/plugins/org.talend.libraries.guava/META-INF/MANIFEST.MF
@@ -4,7 +4,7 @@ Bundle-Name: Guava
 Bundle-SymbolicName: org.talend.libraries.guava
 Bundle-Version: 7.3.1.qualifier
 Eclipse-BundleShape: dir
-Bundle-ClassPath: lib/guava-18.0.jar
+Bundle-ClassPath: lib/guava-32.0.1-jre.jar
 Export-Package: com.google.common.annotations,
 com.google.common.base,
 com.google.common.cache,
--- a/main/plugins/org.talend.libraries.guava/build.properties
+++ b/main/plugins/org.talend.libraries.guava/build.properties
@@ -2,4 +2,4 @@ output.. = bin/
 bin.includes = META-INF/,\
               .,\
               lib/,\
-               lib/guava-18.0.jar
+               lib/
--- a/main/plugins/org.talend.libraries.guava/lib/guava-18.0.jar
+++ b/main/plugins/org.talend.libraries.guava/lib/guava-18.0.jar
--- a/main/plugins/org.talend.libraries.guava/pom.xml
+++ b/main/plugins/org.talend.libraries.guava/pom.xml
@@ -9,4 +9,32 @@
  </parent>
  <artifactId>org.talend.libraries.guava</artifactId>
  <packaging>eclipse-plugin</packaging>
+  <build>
+        <plugins>
+            <plugin>
+                <groupId>org.apache.maven.plugins</groupId>
+                <artifactId>maven-dependency-plugin</artifactId>
+                <version>2.8</version>
+                <executions>
+                    <execution>
+                        <id>copy-maven-repository1</id>
+                        <phase>generate-sources</phase>
+                        <goals>
+                            <goal>copy</goal>
+                        </goals>
+                        <configuration>
+                            <outputDirectory>${project.basedir}/lib</outputDirectory>
+                            <artifactItems>
+                                <artifactItem>
+                                    <groupId>com.google.guava</groupId>
+                                    <artifactId>guava</artifactId>
+                                    <version>32.0.1-jre</version>
+                                </artifactItem>
+                            </artifactItems>
+                        </configuration>
+                    </execution>
+                </executions>
+            </plugin>
+        </plugins>
+    </build>
 </project>
--- a/main/plugins/org.talend.repository/plugin.xml
+++ b/main/plugins/org.talend.repository/plugin.xml
@@ -3735,15 +3735,6 @@
              name="RemoveDuplicateContextReferencesMigrationTask"
              version="7.3.1">
        </projecttask>
-        <projecttask
-              beforeLogon="true"
-              breaks="7.3.0"
-              class="org.talend.repository.model.migration.RemoveUnwantedUsageDataMigrationTask"
-              description="Remove unwanted old entried from prefrence store for Usage Data Collection"
-              id="org.talend.repository.model.migration.RemoveUnwantedUsageDataMigrationTask"
-              name="RemoveUnwantedUsageDataMigrationTask"
-              version="7.3.1">
-        </projecttask>
        <projecttask
              beforeLogon="false"
              breaks="7.3.1"
--- a/main/plugins/org.talend.repository/src/main/java/org/talend/repository/model/migration/GenerateJobPomMigrationTask.java
+++ b/main/plugins/org.talend.repository/src/main/java/org/talend/repository/model/migration/GenerateJobPomMigrationTask.java
@@ -15,12 +15,15 @@ package org.talend.repository.model.migration;
 import java.util.Date;
 import java.util.GregorianCalendar;
 import java.util.List;
-
 import org.talend.core.CorePlugin;
 import org.talend.core.model.migration.AbstractItemMigrationTask;
+import org.talend.core.model.process.ProcessUtils;
 import org.talend.core.model.properties.Item;
+import org.talend.core.model.properties.ProcessItem;
 import org.talend.core.model.repository.ERepositoryObjectType;
 import org.talend.core.repository.model.ProxyRepositoryFactory;
+import org.talend.designer.core.model.utils.emf.talendfile.NodeType;
+import org.talend.designer.runprocess.ItemCacheManager;

 /**
 * DOC zwxue class global comment. Detailled comment
@@ -37,7 +40,18 @@ public class GenerateJobPomMigrationTask extends AbstractItemMigrationTask {
    public ExecutionResult execute(Item item) {
        // only execute the migration task during logon, disable it for the import item (check of log finished)
        if (!ProxyRepositoryFactory.getInstance().isFullLogonFinished()) {
+        	
+        	// skip poms generation for routelets
+            if (item != null && item.getProperty() != null && ProcessUtils.isRoutelet(item.getProperty())) {
+            	return ExecutionResult.SKIPPED;
+            }
+            
            CorePlugin.getDefault().getRunProcessService().generatePom(item);
+            
+            if (item != null && ProcessUtils.isRoute(item.getProperty()) && ProcessUtils.isRouteWithRoutelets(item)) {
+            	generatePomsForChildRoutelets(item);
+            }
+          
            return ExecutionResult.SUCCESS_NO_ALERT;
        }
        return ExecutionResult.NOTHING_TO_DO;
@@ -47,5 +61,26 @@ public class GenerateJobPomMigrationTask extends AbstractItemMigrationTask {
    public List<ERepositoryObjectType> getTypes() {
        return ERepositoryObjectType.getAllTypesOfProcess2();
    }
-
+    
+    private void generatePomsForChildRoutelets(Item routeItem) {
+        // generate poms for child routelets with references to parent routes
+        if (routeItem!= null && routeItem.getProperty() != null && ProcessUtils.isRoute(routeItem.getProperty())) {
+            if (routeItem!= null && routeItem instanceof ProcessItem) {
+                for (Object obj : ((ProcessItem) routeItem).getProcess().getNode()) {
+                    if (obj instanceof NodeType) {
+                    	NodeType node = (NodeType) obj;
+                        if (ProcessUtils.isRouteletNode(node)) {
+                        	
+                            String jobIds = ProcessUtils.getParameterValue(node.getElementParameter(), "PROCESS_TYPE:PROCESS_TYPE_PROCESS");
+                            String jobVersion = ProcessUtils.getParameterValue(node.getElementParameter(), "PROCESS_TYPE:PROCESS_TYPE_VERSION"); //$NON-NLS-1$
+                            ProcessItem routeletItem = ItemCacheManager.getProcessItem(jobIds, jobVersion);
+                            
+                            routeletItem.setParent(routeItem);
+                            CorePlugin.getDefault().getRunProcessService().generatePom(routeletItem);
+                        }
+                    }
+                }
+            }
+        }
+    }
 }
--- a/main/plugins/org.talend.repository/src/main/java/org/talend/repository/model/migration/RemoveUnwantedUsageDataMigrationTask.java
+++ b/main/plugins/org.talend.repository/src/main/java/org/talend/repository/model/migration/RemoveUnwantedUsageDataMigrationTask.java
@@ -1,82 +0,0 @@
-package org.talend.repository.model.migration;
-
-import java.util.Date;
-import java.util.GregorianCalendar;
-import java.util.HashMap;
-import java.util.Map;
-import java.util.Map.Entry;
-import org.eclipse.jface.preference.IPreferenceStore;
-import org.talend.core.model.general.Project;
-import org.talend.core.model.migration.AbstractProjectMigrationTask;
-import org.talend.repository.RepositoryPlugin;
-import com.fasterxml.jackson.core.JsonProcessingException;
-import com.fasterxml.jackson.databind.JsonMappingException;
-import com.fasterxml.jackson.databind.ObjectMapper;
-
-import us.monoid.json.JSONObject;
-
-public class RemoveUnwantedUsageDataMigrationTask extends AbstractProjectMigrationTask {
-
-	private static final String PREF_TOS_JOBS_RECORDS = "TOS_Jobs_Records";
-
-	@SuppressWarnings("unchecked")
-	@Override
-	public ExecutionResult execute(Project project) {
-
-		boolean isDataUpdated = false;
-
-		IPreferenceStore preferenceStore = RepositoryPlugin.getDefault().getPreferenceStore();
-		String oldData = preferenceStore.getString(PREF_TOS_JOBS_RECORDS);
-		try {
-			ObjectMapper objectMapper = new ObjectMapper();
-			HashMap<String,Object> result = (HashMap<String,Object>) objectMapper.readValue(oldData, Map.class);
-			
-			isDataUpdated = deletedUnwantedData(result, "nb.route.osgi");
-			
-			// store the updated value
-			if(isDataUpdated) {
-				JSONObject jsonObject = new JSONObject(result);
-				preferenceStore.setValue(PREF_TOS_JOBS_RECORDS, jsonObject.toString());
-			}
-			
-			return ExecutionResult.SUCCESS_NO_ALERT;
-			
-		} catch (Exception e) {
-			// the value is not set, or is empty
-			e.printStackTrace();
-		}
-
-		return ExecutionResult.NOTHING_TO_DO;
-	}
-
-	@Override
-	public Date getOrder() {
-		GregorianCalendar gc = new GregorianCalendar(2017, 4, 17, 12, 0, 0);
-		return gc.getTime();
-	}
-
-	@SuppressWarnings("unchecked")
-	private static boolean deletedUnwantedData(HashMap<String, Object> result, String keyToRemove) throws JsonProcessingException, JsonMappingException {
-
-		boolean isDataUpdated = false;
-		
-		for(Entry<String, Object> entry : result.entrySet()) {
-			
-			HashMap<String,Object> mainValue = (HashMap<String, Object>) entry.getValue();
-			HashMap<String,Object> projectsObj = (HashMap<String, Object>) mainValue.get("projects");
-
-			if(null != projectsObj) {
-				HashMap<String,Object> processObject = (HashMap<String, Object>) projectsObj.get("PROCESS");
-				if(null != processObject) {
-					HashMap<String,Object> detailsObject = (HashMap<String, Object>) processObject.get("details");
-					if(null != detailsObject && detailsObject.containsKey(keyToRemove)) {
-							detailsObject.remove(keyToRemove);
-							isDataUpdated = true;
-					}
-				}
-			}
-		}
-		
-		return isDataUpdated;
-	}
-}
--- a/main/plugins/org.talend.repository/src/main/java/org/talend/repository/ui/wizards/exportjob/scriptsmanager/esb/DataSourceConfig.java
+++ b/main/plugins/org.talend.repository/src/main/java/org/talend/repository/ui/wizards/exportjob/scriptsmanager/esb/DataSourceConfig.java
@@ -65,7 +65,9 @@ public class DataSourceConfig {
        }
        Collection<String> aliases = new HashSet<String>();
        getJobletAliases(processItem, aliases);
-        getAliases(processItem.getId(), aliases);
+        if (processItem != null ) {
+            getAliases(processItem.getId(), aliases);
+        }
        return aliases;
    }

--- a/main/plugins/org.talend.repository/src/main/java/org/talend/repository/ui/wizards/exportjob/scriptsmanager/esb/JobJavaScriptOSGIForESBManager.java
+++ b/main/plugins/org.talend.repository/src/main/java/org/talend/repository/ui/wizards/exportjob/scriptsmanager/esb/JobJavaScriptOSGIForESBManager.java
@@ -282,6 +282,9 @@ public class JobJavaScriptOSGIForESBManager extends JobJavaScriptsManager {
                if (processItem.eIsProxy() || processItem.getProcess().eIsProxy()) {
                    try {
                        Property property = ProxyRepositoryFactory.getInstance().getUptodateProperty(processItem.getProperty());
+                        if (property != null && processItem.getProperty() != null) {
+                            property.setParentItem(processItem.getProperty().getParentItem());	
+                        }
                        processItem = (ProcessItem) property.getItem();
                    } catch (PersistenceException e) {
                        throw new ProcessorException(e);
--- a/main/plugins/org.talend.sdk.component.studio-integration/pom.xml
+++ b/main/plugins/org.talend.sdk.component.studio-integration/pom.xml
@@ -14,7 +14,7 @@
  <description>Studio integration of the Talend Component Kit framework.</description>

  <properties>
-    <component-runtime.version>1.38.9</component-runtime.version>
+    <component-runtime.version>1.38.12</component-runtime.version>
    <commons-lang3.version>3.11</commons-lang3.version>
    <mockito.version>2.23.0</mockito.version>
    <oro.version>2.0.8</oro.version>
--- a/test/plugins/org.talend.designer.scd.test/.gitignore
+++ b/test/plugins/org.talend.designer.scd.test/.gitignore
@@ -0,0 +1 @@
+/targets/
Author	SHA1	Message	Date
jzhao	94c206797b	chore(TDI-50507): bump component-runtime to 1.38.12 (#9309 )	2023-11-23 10:47:21 +08:00
Oleksandr Zhelezniak	92e6817ce0	fix(TDI-50482): cve bump activemq-client 5.15.16 (#9240 ) * cve bump activemq-client 5.15.16 * jdk 8 compliant lib	2023-11-20 14:30:19 +02:00
sponomarova	1b6a41de1c	fix(TBD-15624): CVE Fixes for R2023-11 (#9241 )	2023-11-20 08:42:12 +02:00
jzhao	c0ccaba450	fix(TDI-50399): Json:20230227 \| CVE-2023-5072 (#9275 )	2023-11-20 11:51:08 +08:00
Jill Yan	1e3121e930	APPINT-35964 remove usless migration task (#9227 )	2023-11-06 19:27:29 +08:00
apoltavtsev	8fe2ddceae	APPINT-35880: Port inconsistency in SAM events between 7.3 and 8.0 (#9189 )	2023-10-26 09:05:05 +02:00
apoltavtsev	18bed0b1e8	APPINT-35122: Migration task for routelets is corrected (#9155 )	2023-10-10 18:05:53 +02:00
apoltavtsev	18138f5b3e	APPINT-35418: Refer to wrong route in blueprint.xml when two routes use same routelet and deploy by CI (#9131 )	2023-10-05 16:06:24 +02:00
Abdulhamid Rashankar	55437f6540	APPINT-35812: publishing a service as a release try to create twice the release (#9051 ) Co-authored-by: jillyan <yan95599@gmail.com>	2023-09-28 07:42:33 +02:00
zyuan-talend	1b26fd23ee	fix(TUP-39924): upgrade org.codehaus.plexus:plexus-archiver to 4.8.0, (#9040 ) plexus-io to 3.4.1 , maven-assembly-plugin to 3.6.0 and plexus-util to 4.0.0 for incompatibility.	2023-09-21 16:30:55 +08:00
Emmanuel GALLOIS	5214a87362	feat(TDI-50266): bump component-runtime to 1.38.11 (#9112 )	2023-09-20 10:55:09 +02:00
Oleksandr Zhelezniak	4150a146ae	fix(TDI-49941): bump guava 32.1.2-jre (#9093 ) * fix(TDI-49941): bump guava 32.1.2-jre * fix(TDI-49941): fix the NoClassDefFoundException. --------- Co-authored-by: jzhao-talend <jzhao@talend.com>	2023-09-20 10:15:15 +08:00
pyzhou	39ed48be5d	fix(TDI-50253):Backport xmlreader CVE to 7.3 (#9095 ) * fix(TDI-50253):Backport xmlreader CVE to 7.3 * fix plugin	2023-09-14 10:31:39 +08:00
Emmanuel GALLOIS	57c9c309f7	feat(TDI-48822): bump component-runtime to 1.38.10 (#9092 )	2023-09-12 10:59:37 +02:00