fix(APPINT-36075) The default image name and tag are lost when build job as docker image (#9497)

* fix(TUP-41511): throw exception

* fix(TUP-41511): add connect error message

* fix(TUP-41511): add connect error message

* fix(TUP-41511): fix list projects

* fix(TUP-41511): update error message

main/features/org.talend.studio.components.tck.jdbc.feature/.project

@@ -0,0 +1,23 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<projectDescription>
+	<name>org.talend.studio.components.tck.jdbc.feature</name>
+	<comment></comment>
+	<projects>
+	</projects>
+	<buildSpec>
+		<buildCommand>
+			<name>org.eclipse.pde.FeatureBuilder</name>
+			<arguments>
+			</arguments>
+		</buildCommand>
+		<buildCommand>
+			<name>org.eclipse.m2e.core.maven2Builder</name>
+			<arguments>
+			</arguments>
+		</buildCommand>
+	</buildSpec>
+	<natures>
+		<nature>org.eclipse.m2e.core.maven2Nature</nature>
+		<nature>org.eclipse.pde.FeatureNature</nature>
+	</natures>
+</projectDescription>

main/features/org.talend.studio.components.tck.jdbc.feature/build.properties

@@ -0,0 +1 @@
+bin.includes = feature.xml

main/features/org.talend.studio.components.tck.jdbc.feature/feature.xml

@@ -0,0 +1,41 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<feature
+      id="org.talend.studio.components.tck.jdbc.feature"
+      label="JDBC"
+      version="8.0.1.qualifier">
+
+   <description url="http://www.example.com/description">
+      JDBC
+   </description>
+
+   <copyright url="http://www.example.com/copyright">
+      [Enter Copyright Description here.]
+   </copyright>
+
+   <license url="http://www.example.com/license">
+      JDBC
+Copyright (c) 2006-2021 Talend Inc. - www.talend.com
+All rights reserved.
+
+This product includes software developed at
+GlassFish Community (https://glassfish.dev.java.net)
+Licensed under the CDDL,GPL-2.0-only license.
+
+
+This product includes software developed at
+The Apache Software Foundation (http://jakarta.apache.org/)
+Licensed under the Apache-2.0 license.
+
+
+This product includes software developed at
+FasterXML
+Licensed under the Apache-2.0 license.
+   </license>
+
+   <requires>
+      <import plugin="org.talend.designer.maven.repo.tck"/>
+      <import plugin="org.talend.studio.components.tck.jdbc"/>
+      <import plugin="org.talend.components.jdbc.definition"/>
+   </requires>
+
+</feature>

main/features/org.talend.studio.components.tck.jdbc.feature/pom.xml

@@ -0,0 +1,12 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<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>
+  <parent>
+    <groupId>org.talend.studio</groupId>
+    <artifactId>tdi-studio-se</artifactId>
+    <version>8.0.1-SNAPSHOT</version>
+    <relativePath>../../../</relativePath>
+  </parent>
+  <artifactId>org.talend.studio.components.tck.jdbc.feature</artifactId>
+  <packaging>eclipse-feature</packaging>
+</project>

main/features/org.talend.studio.components.tcompv0.jdbc.feature/feature.xml

@@ -15,17 +15,5 @@
    <license url="http://www.example.com/license">
       [Enter License Description here.]
    </license>
-   <plugin
-         id="org.talend.studio.components.tcompv0.jdbc"
-         download-size="0"
-         install-size="0"
-         version="0.0.0"/>
-
-   <plugin
-         id="org.talend.components.jdbc.definition"
-         download-size="0"
-         install-size="0"
-         version="0.0.0"
-         unpack="false"/>
 
 </feature>

main/features/org.talend.tos.components.feature/feature.xml

@@ -19,7 +19,6 @@
    <requires>
       <import feature="org.talend.studio.components.tck.jira.feature" version="0.0.0" match="greaterOrEqual"/>
       <import feature="org.talend.studio.components.tck.splunk.feature" version="0.0.0" match="greaterOrEqual"/>
-      <import feature="org.talend.studio.components.tcompv0.jdbc.feature" version="0.0.0" match="greaterOrEqual"/>
       <import feature="org.talend.studio.components.tcompv0.netsuite.feature" version="0.0.0" match="greaterOrEqual"/>
       <import feature="org.talend.studio.components.tcompv0.googledrive.feature" version="0.0.0" match="greaterOrEqual"/>
       <import feature="org.talend.studio.components.tcompv0.marketo.feature" version="0.0.0" match="greaterOrEqual"/>
@@ -158,7 +157,7 @@
          install-size="0"
          version="0.0.0"
          unpack="false"/>
-         
+
    <plugin
          id="org.talend.designer.filemultischemas"
          download-size="0"
@@ -242,12 +241,18 @@
          install-size="0"
          version="0.0.0"
          unpack="false"/>
-		 
-	<plugin
+
+   <plugin
          id="org.talend.designer.esb.components.rs.consumer"
          download-size="0"
          install-size="0"
          version="0.0.0"
          unpack="false"/>
 
+   <plugin
+         id="org.talend.studio.components.tck.jdbc"
+         download-size="0"
+         install-size="0"
+         version="0.0.0"/>
+
 </feature>

main/plugins/org.talend.designer.codegen/jet_stub/footer.javajet

@@ -87,12 +87,12 @@
         "tIngresConnection",
         "tInterbaseConnection",
         "tJDBCConnection",
+        "JDBCConnection",
         "tMSSqlConnection",
         "tMysqlConnection",
         "tNetezzaConnection",
         "tOracleConnection",
         "tParAccelConnection",
-        "tPostgresPlusConnection",
         "tPostgresqlConnection",
         "tRedshiftConnection",
         "tSQLiteConnection",

main/plugins/org.talend.designer.codegen/jet_stub/subprocess_header.javajet

@@ -224,7 +224,7 @@ public static class <%=conn.getName() %>Struct<%=templateOrigin %> implements ro
 				<% if (column.getOriginalDbColumnName() == null) { %>
 				    return null;
 				<% } else { %>
-					return "<%=TalendTextUtils.escapeJavaText(TalendTextUtils.removeQuotes(column.getOriginalDbColumnName()))%>";
+					return "<%=TalendTextUtils.escapeJavaText(column.getOriginalDbColumnName())%>";
 				<% } %>
 				}
 

main/plugins/org.talend.designer.codegen/src/main/java/messages_ja.properties

@@ -126,7 +126,7 @@ FAMILY.MySQL=MySQL
 FAMILY.Netezza=Netezza
 FAMILY.OLAP_Cube=OLAP\u30AD\u30E5\u30FC\u30D6
 FAMILY.Oracle=Oracle
-FAMILY.Orchestration=\u30D7\u30ED\u30BB\u30B9\u5236\u5FA1
+FAMILY.Orchestration=\u30AA\u30FC\u30B1\u30B9\u30C8\u30EC\u30FC\u30B7\u30E7\u30F3\u5316
 FAMILY.Output=\u51FA\u529B
 FAMILY.ParAccel=ParAccel
 FAMILY.PostgreSQL=PostgreSQL

main/plugins/org.talend.designer.codegen/src/main/java/org/talend/designer/codegen/CodeGenerator.java

@@ -599,6 +599,13 @@ public class CodeGenerator implements ICodeGenerator {
 
                 } else {
                     // if (!isIterate) {
+                    if (isTacokitProcessor(node)) {
+                        codeComponent.append(generateComponentCode(subProcess, node, ECodePart.PROCESS_RECORDS_END, incomingName, typeGen));
+                        codeComponent.append(generateComponentCode(subProcess, node, ECodePart.PROCESS_DATA_BEGIN, incomingName, typeGen));
+                        codeComponent.append(generatesTreeCode(subProcess, node, ECodePart.MAIN, typeGen));
+                        codeComponent.append(generateComponentCode(subProcess, node, ECodePart.PROCESS_DATA_END, incomingName, typeGen));
+                    }
+                	
                     codeComponent.append(generateComponentCode(subProcess, node, ECodePart.END, incomingName, typeGen));
                     // }
                     if (node.getComponent() instanceof Component) {
@@ -629,12 +636,6 @@ public class CodeGenerator implements ICodeGenerator {
                         }
                     }
 
-                    if (isTacokitProcessor(node)) {
-                        codeComponent.append(generateComponentCode(subProcess, node, ECodePart.PROCESS_RECORDS_END, incomingName, typeGen));
-                        codeComponent.append(generateComponentCode(subProcess, node, ECodePart.PROCESS_DATA_BEGIN, incomingName, typeGen));
-                        codeComponent.append(generatesTreeCode(subProcess, node, ECodePart.MAIN, typeGen));
-                        codeComponent.append(generateComponentCode(subProcess, node, ECodePart.PROCESS_DATA_END, incomingName, typeGen));
-                    }
                     codeComponent.append(generatesTreeCode(subProcess, node, part, typeGen));
                     // if (isIterate) {
                     // codeComponent.append(generateComponentCode(node,
@@ -655,11 +656,14 @@ public class CodeGenerator implements ICodeGenerator {
         return codeComponent;
     }
 
+    private static final String TACOKIT_PROCESSOR_CODE_DIR = "tacokit/jet_stub/generic/processor";
+    
     private boolean isTacokitProcessor(final INode node) {
-        return "org.talend.sdk.component.studio.ComponentModel".equals(node.getComponent().getClass().getName())
-                && !NodeUtil.getIncomingConnections(node, IConnectionCategory.DATA).isEmpty(); //has input data
+        final String componentModelClass = node.getComponent().getClass().getName();
+        return ("org.talend.sdk.component.studio.ComponentModel".equals(componentModelClass) || "org.talend.sdk.component.studio.AdditionalJDBCComponentModel".equals(componentModelClass))
+                && (!NodeUtil.getIncomingConnections(node, IConnectionCategory.DATA).isEmpty() || TACOKIT_PROCESSOR_CODE_DIR.equals(node.getComponent().getTemplateFolder()));
     }
-
+    
     private StringBuffer generateSeperateEndCode(NodesSubTree subProcess, INode node, String incomingName, ETypeGen typeGen)
             throws CodeGeneratorException {
         StringBuffer codeComponent = new StringBuffer();

main/plugins/org.talend.designer.codegen/src/main/java/org/talend/designer/codegen/components/model/ComponentsFactory.java

@@ -59,7 +59,9 @@ import org.talend.core.model.components.IComponentsFactory;
 import org.talend.core.model.components.IComponentsHandler;
 import org.talend.core.model.components.filters.ComponentsFactoryProviderManager;
 import org.talend.core.model.components.filters.IComponentFactoryFilter;
+import org.talend.core.runtime.services.IGenericService;
 import org.talend.core.runtime.util.ComponentsLocationProvider;
+import org.talend.core.service.ITCKUIService;
 import org.talend.core.ui.IJobletProviderService;
 import org.talend.core.ui.ISparkJobletProviderService;
 import org.talend.core.ui.ISparkStreamingJobletProviderService;
@@ -73,6 +75,7 @@ import org.talend.designer.core.model.components.EmfComponent;
 import org.talend.designer.core.model.process.AbstractProcessProvider;
 import org.talend.designer.core.model.process.GenericProcessProvider;
 import org.talend.designer.core.ui.editor.jobletcontainer.JobletUtil;
+import org.talend.designer.core.utils.UnifiedComponentUtil;
 
 /**
  * Component factory that look for each component and load their information. <br/>
@@ -231,7 +234,15 @@ public class ComponentsFactory implements IComponentsFactory {
             if (StringUtils.isEmpty(componentName)) {
                 continue;
             }
+            if (IGenericService.getService().isTcompv0(component)
+                    && (UnifiedComponentUtil.isAdditionalJDBCComponent(component.getName())
+                            || component.getName().contains(ITCKUIService.get().getTCKJDBCType().getLabel()))) {
+                continue;
+            }
             String componentNameLowerCase = componentName.toLowerCase();
+            if (componentNameLowerCase.startsWith(ITCKUIService.get().getTCKJDBCType().getLabel().toLowerCase())) {
+                componentNameLowerCase = "t" + componentNameLowerCase;
+            }
             Map<String, Set<IComponent>> map = componentNameMap.get(componentNameLowerCase);
             if (map == null) {
                 map = new HashMap<String, Set<IComponent>>();

main/plugins/org.talend.designer.codegen/src/main/java/org/talend/designer/codegen/config/TalendJetEmitter.java

@@ -378,7 +378,7 @@ public class TalendJetEmitter extends JETEmitter {
                         // Construct a proper URL for relative lookup.
                         //
                         URL url = new File(project.getLocation() + "/" + "runtime" + "/") //$NON-NLS-1$ //$NON-NLS-2$
-                                .toURL();
+                                .toURI().toURL();
                         URLClassLoader theClassLoader = new URLClassLoader(new URL[] { url }, jetEmitter.classLoader);
                         Class theClass = theClassLoader.loadClass((packageName.length() == 0 ? "" : packageName + ".") //$NON-NLS-1$ //$NON-NLS-2$
                                 + jetCompiler.getSkeleton().getClassName());
@@ -633,7 +633,7 @@ public class TalendJetEmitter extends JETEmitter {
             final IWorkspace workspace = ResourcesPlugin.getWorkspace();
             IProject project = workspace.getRoot().getProject(projectName);
 
-            URL url = new File(project.getLocation() + "/runtime").toURL(); //$NON-NLS-1$
+            URL url = new File(project.getLocation() + "/runtime").toURI().toURL(); //$NON-NLS-1$
             currentClassLoader = jetbean.getClassLoader();
             theClassLoader = new URLClassLoader(new URL[] { url }, jetbean.getClassLoader());
         }

main/plugins/org.talend.designer.codegen/src/main/java/org/talend/designer/codegen/model/JetSkeletonManager.java

@@ -38,9 +38,7 @@ import org.eclipse.core.runtime.FileLocator;
 import org.eclipse.core.runtime.IStatus;
 import org.eclipse.core.runtime.NullProgressMonitor;
 import org.eclipse.core.runtime.Path;
-import org.eclipse.core.runtime.Platform;
 import org.eclipse.core.runtime.Status;
-import org.osgi.framework.Bundle;
 import org.talend.commons.exception.ExceptionHandler;
 import org.talend.commons.runtime.utils.io.IOUtils;
 import org.talend.core.model.components.ComponentCompilations;
@@ -138,9 +136,6 @@ public final class JetSkeletonManager {
         }
         project.open(new NullProgressMonitor());
         IFile file = project.getFile("SkeletonUpdateCache"); //$NON-NLS-1$
-        if (!file.exists()) {
-            file.create(null, true, new NullProgressMonitor());
-        }
         return file.getLocation().toFile();
     }
 

main/plugins/org.talend.designer.components.libs/libs_src/AddressDoctorClient/build.xml

@@ -16,8 +16,8 @@
 		<pathelement location="${component.plugin.home}/tWebServiceInput/axis.jar" />
 		<pathelement location="${component.plugin.home}/tWebServiceInput/commons-discovery-0.2.jar" />
 		<pathelement location="${component.plugin.home}/tWebServiceInput/wsdl4j-1.5.1.jar" />
-		<pathelement location="${component.plugin.home}/tWebServiceInput/saaj.jar" />
-		<pathelement location="${component.plugin.home}/tWebServiceInput/jaxrpc.jar" />
+		<pathelement location="${component.plugin.home}/tWebServiceInput/axis-saaj-1.4.jar" />
+		<pathelement location="${component.plugin.home}/tWebServiceInput/axis-jaxrpc-1.4.jar" />
 		<pathelement location="${component.plugin.home}/tXMLRPCInput/commons-logging-1.1.jar" />
 	</path>
 

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>

main/plugins/org.talend.designer.components.libs/libs_src/mqrfh2header/build.xml

@@ -17,7 +17,7 @@
 		<pathelement location="${component.plugin.home}/tMomInput/activemq-all-5.1.0.jar" />
 		<pathelement location="${component.plugin.home}/tMomInput/jnp-client.jar" />
 		<pathelement location="${component.plugin.home}/tMomInput/websphere-connector-1_5.jar" />
-		<pathelement location="${component.plugin.home}/tMomInput/trove.jar" />
+		<pathelement location="${component.plugin.home}/tMomInput/trove-1.0.2.jar" />
 		<pathelement location="${component.plugin.home}/tMomInput/log4j-1.2.13.jar" />
 	</path>
 

main/plugins/org.talend.designer.components.libs/libs_src/servicenow/pom.xml

@@ -1,135 +0,0 @@
-<!--
-  Copyright (C) 2006-2021 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-20210428</version>
-    <properties>
-        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
-
-        <talend.nexus.url>https://artifacts-oss.talend.com</talend.nexus.url>
-
-        <httpcore.version>4.4.13</httpcore.version>
-        <httpclient.version>4.5.13</httpclient.version>
-        <httpclient-cache.version>4.5.13</httpclient-cache.version>
-        <httpmime.version>4.5.13</httpmime.version>
-        <junit.version>4.13.2</junit.version>
-        <commons-codec.version>1.14</commons-codec.version>
-        <commons-logging.version>1.1.3</commons-logging.version>
-    </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>${commons-codec.version}</version>
-            <type>jar</type>
-        </dependency>
-        <dependency>
-            <groupId>commons-logging</groupId>
-            <artifactId>commons-logging</artifactId>
-            <version>${commons-logging.version}</version>
-            <type>jar</type>
-        </dependency>
-        <dependency>
-            <groupId>org.apache.httpcomponents</groupId>
-            <artifactId>httpclient</artifactId>
-            <version>${httpclient.version}</version>
-            <type>jar</type>
-        </dependency>
-        <dependency>
-            <groupId>org.apache.httpcomponents</groupId>
-            <artifactId>httpclient-cache</artifactId>
-            <version>${httpclient-cache.version}</version>
-            <type>jar</type>
-        </dependency>
-        <dependency>
-            <groupId>org.apache.httpcomponents</groupId>
-            <artifactId>httpmime</artifactId>
-            <version>${httpmime.version}</version>
-            <type>jar</type>
-        </dependency>
-        <dependency>
-            <groupId>org.apache.httpcomponents</groupId>
-            <artifactId>httpcore</artifactId>
-            <version>${httpcore.version}</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>${junit.version}</version>
-            <type>jar</type>
-            <scope>test</scope>
-            <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.8</source>
-                    <target>1.8</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>

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-2021 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");
-    }
-}

main/plugins/org.talend.designer.components.libs/libs_src/sugarCRMManagement/build.xml

@@ -16,8 +16,8 @@
 		<pathelement location="${component.plugin.home}/tWebServiceInput/axis.jar" />
 		<pathelement location="${component.plugin.home}/tWebServiceInput/commons-discovery-0.2.jar" />
 		<pathelement location="${component.plugin.home}/tWebServiceInput/wsdl4j-1.5.1.jar" />
-		<pathelement location="${component.plugin.home}/tWebServiceInput/saaj.jar" />
-		<pathelement location="${component.plugin.home}/tWebServiceInput/jaxrpc.jar" />
+		<pathelement location="${component.plugin.home}/tWebServiceInput/axis-saaj-1.4.jar" />
+		<pathelement location="${component.plugin.home}/tWebServiceInput/axis-jaxrpc-1.4.jar" />
 		<pathelement location="${component.plugin.home}/tXMLRPCInput/commons-logging-1.1.jar" />
 	</path>
 

main/plugins/org.talend.designer.components.libs/libs_src/talendssl/pom.xml

@@ -4,7 +4,7 @@
 	<modelVersion>4.0.0</modelVersion>
 	<groupId>org.talend.components</groupId>
 	<artifactId>talendssl</artifactId>
-	<version>1.0-20190118</version>
+	<version>1.0-20231128</version>
 	<packaging>jar</packaging>
 
 	<properties>
@@ -52,4 +52,4 @@
 			</plugin>
 		</plugins>
 	</build>
-</project> 
+</project> 

main/plugins/org.talend.designer.components.libs/libs_src/talendssl/src/main/java/talend/ssl/Truster.java

@@ -103,7 +103,11 @@ public class Truster implements X509TrustManager {
             } catch (IOException _ex) {
             }
         try {
-            ks.load(in, certStorePwd);
+            if (in == null) {
+                ks = null;
+            } else {
+                ks.load(in, certStorePwd);
+            }
         } catch (Exception e) {
             System.err.println("ASF Truster: Failed to load the cert store : " + e.getMessage());
             return;

main/plugins/org.talend.designer.components.localprovider/META-INF/MANIFEST.MF

@@ -1,6 +1,6 @@
 Manifest-Version: 1.0
 Bundle-ManifestVersion: 2
-Bundle-Name: Components Local provider Plug-in
+Bundle-Name: Components Local provider Plug-in R2023-12
 Bundle-SymbolicName: org.talend.designer.components.localprovider;singleton:=true
 Bundle-Version: 8.0.1.qualifier
 Bundle-Activator: org.talend.designer.components.ComponentsLocalProviderPlugin

main/plugins/org.talend.designer.components.localprovider/build.properties

@@ -16,12 +16,12 @@ bin.excludes = components/tAlfrescoOutput/wstx-lgpl-3.2.7.jar,\
                components/tNamedPipeOutput/namedpipe_jni_64bit.dll,\
                components/tNetezzaNzLoad/namedpipe_jni_64bit.dll,\
                components/tGreenplumGPLoad/namedpipe-1.0.jar,\
-               components/tRSSInput/nekohtml.jar,\
+               components/tRSSInput/nekohtml-0.9.5.jar,\
                components/tAlfrescoOutput/wstx-lgpl-3.2.7.jar,\
-               components/tAdvancedXMLMapHash/trove.jar,\
+               components/tAdvancedXMLMapHash/trove-1.0.2.jar,\
                components/tLineChart/jcommon-1.0.6.jar,\
                components/tMomInput/jnp-client.jar,\
-               components/tMomInput/javassist.jar,\
+               components/tMomInput/javassist-3.10.0.GA.jar,\
                components/tBonitaDeploy/cglib-nodep-2.1_3.jar,\
                components/tBonitaDeploy/javassist-3.12.0.GA.jar,\
                components/tBonitaDeploy/javassist-3.8.0.GA.jar,\

main/plugins/org.talend.designer.components.localprovider/components/tAS400Row/tAS400Row_messages_fr.properties

@@ -35,7 +35,7 @@ SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.BigDecimal=BigDecimal
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Blob=Blob
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Boolean=Bool\u00E9en
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Byte=Octet
-SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Bytes=Bytes
+SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Bytes=Octets
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Clob=Clob
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Date=Date
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Double=Double

main/plugins/org.talend.designer.components.localprovider/components/tAccessConnection/tAccessConnection_java.xml

@@ -118,7 +118,7 @@
 		<IMPORT NAME="Driver-JACKCESS" MODULE="jackcess-2.1.12.jar" MVN="mvn:com.healthmarketscience.jackcess/jackcess/2.1.12" REQUIRED="true"/>
 		
 		<IMPORT NAME="jackcess-encrypt-2.1.4" MODULE="jackcess-encrypt-2.1.4.jar" MVN="mvn:com.healthmarketscience.jackcess/jackcess-encrypt/2.1.4" REQUIRED="true"/>
-		<IMPORT NAME="bcprov-jdk15on-1.70" MODULE="bcprov-jdk15on-1.70.jar" MVN="mvn:org.bouncycastle/bcprov-jdk15on/1.70" REQUIRED="true"/>
+		<IMPORT NAME="bcprov-jdk18on-1.74" MODULE="bcprov-jdk18on-1.74.jar" MVN="mvn:org.bouncycastle/bcprov-jdk18on/1.74" REQUIRED="true"/>
 		<IMPORT NAME="talend-ucanaccess-utils-1.0.0" MODULE="talend-ucanaccess-utils-1.0.0.jar" MVN="mvn:org.talend.libraries/talend-ucanaccess-utils-1.0.0/6.4.0" REQUIRED="true"/>
 		
 		<IMPORT NAME="common2.6" MODULE="commons-lang-2.6.jar" MVN="mvn:commons-lang/commons-lang/2.6"   UrlPath="platform:/plugin/org.talend.libraries.apache.common/lib/commons-lang-2.6.jar" REQUIRED="true"/>

main/plugins/org.talend.designer.components.localprovider/components/tAccessInput/tAccessInput_java.xml

@@ -121,7 +121,7 @@
 		<IMPORT NAME="Driver-JACKCESS" MODULE="jackcess-2.1.12.jar" MVN="mvn:com.healthmarketscience.jackcess/jackcess/2.1.12" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false')"/>
 		
 		<IMPORT NAME="jackcess-encrypt-2.1.4" MODULE="jackcess-encrypt-2.1.4.jar" MVN="mvn:com.healthmarketscience.jackcess/jackcess-encrypt/2.1.4" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false')"/>
-		<IMPORT NAME="bcprov-jdk15on-1.70" MODULE="bcprov-jdk15on-1.70.jar" MVN="mvn:org.bouncycastle/bcprov-jdk15on/1.70" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false')"/>
+		<IMPORT NAME="bcprov-jdk18on-1.74" MODULE="bcprov-jdk18on-1.74.jar" MVN="mvn:org.bouncycastle/bcprov-jdk18on/1.74" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false')"/>
 		<IMPORT NAME="talend-ucanaccess-utils-1.0.0" MODULE="talend-ucanaccess-utils-1.0.0.jar" MVN="mvn:org.talend.libraries/talend-ucanaccess-utils-1.0.0/6.4.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false')"/>
 		
 		<IMPORT NAME="common2.6" MODULE="commons-lang-2.6.jar" MVN="mvn:commons-lang/commons-lang/2.6"   UrlPath="platform:/plugin/org.talend.libraries.apache.common/lib/commons-lang-2.6.jar" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false')"/>

main/plugins/org.talend.designer.components.localprovider/components/tAccessOutput/tAccessOutput_java.xml

@@ -207,7 +207,7 @@
 		<IMPORT NAME="Driver-JACKCESS" MODULE="jackcess-2.1.12.jar" MVN="mvn:com.healthmarketscience.jackcess/jackcess/2.1.12" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false')"/>
 		
 		<IMPORT NAME="jackcess-encrypt-2.1.4" MODULE="jackcess-encrypt-2.1.4.jar" MVN="mvn:com.healthmarketscience.jackcess/jackcess-encrypt/2.1.4" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false')"/>
-		<IMPORT NAME="bcprov-jdk15on-1.70" MODULE="bcprov-jdk15on-1.70.jar" MVN="mvn:org.bouncycastle/bcprov-jdk15on/1.70" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false')"/>
+		<IMPORT NAME="bcprov-jdk18on-1.74" MODULE="bcprov-jdk18on-1.74.jar" MVN="mvn:org.bouncycastle/bcprov-jdk18on/1.74" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false')"/>
 		<IMPORT NAME="talend-ucanaccess-utils-1.0.0" MODULE="talend-ucanaccess-utils-1.0.0.jar" MVN="mvn:org.talend.libraries/talend-ucanaccess-utils-1.0.0/6.4.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false')"/>
 		
 		<IMPORT NAME="common2.6" MODULE="commons-lang-2.6.jar" MVN="mvn:commons-lang/commons-lang/2.6"   UrlPath="platform:/plugin/org.talend.libraries.apache.common/lib/commons-lang-2.6.jar" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false')"/>

main/plugins/org.talend.designer.components.localprovider/components/tAccessRow/tAccessRow_java.xml

@@ -181,7 +181,7 @@
 		<IMPORT NAME="Driver-JACKCESS" MODULE="jackcess-2.1.12.jar" MVN="mvn:com.healthmarketscience.jackcess/jackcess/2.1.12" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false')"/>
 		
 		<IMPORT NAME="jackcess-encrypt-2.1.4" MODULE="jackcess-encrypt-2.1.4.jar" MVN="mvn:com.healthmarketscience.jackcess/jackcess-encrypt/2.1.4" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false')"/>
-		<IMPORT NAME="bcprov-jdk15on-1.70" MODULE="bcprov-jdk15on-1.70.jar" MVN="mvn:org.bouncycastle/bcprov-jdk15on/1.70" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false')"/>
+		<IMPORT NAME="bcprov-jdk18on-1.74" MODULE="bcprov-jdk18on-1.74.jar" MVN="mvn:org.bouncycastle/bcprov-jdk18on/1.74" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false')"/>
 		<IMPORT NAME="talend-ucanaccess-utils-1.0.0" MODULE="talend-ucanaccess-utils-1.0.0.jar" MVN="mvn:org.talend.libraries/talend-ucanaccess-utils-1.0.0/6.4.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false')"/>
 		
 		<IMPORT NAME="common2.6" MODULE="commons-lang-2.6.jar" MVN="mvn:commons-lang/commons-lang/2.6"   UrlPath="platform:/plugin/org.talend.libraries.apache.common/lib/commons-lang-2.6.jar" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false')"/>

main/plugins/org.talend.designer.components.localprovider/components/tAccessRow/tAccessRow_messages_fr.properties

@@ -28,7 +28,7 @@ SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.BigDecimal=BigDecimal
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Blob=Blob
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Boolean=Bool\u00E9en
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Byte=Octet
-SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Bytes=Bytes
+SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Bytes=Octets
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Clob=Clob
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Date=Date
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Double=Double

main/plugins/org.talend.designer.components.localprovider/components/tAdvancedHash/tAdvancedHash_java.xml

@@ -46,7 +46,7 @@
 
    <CODEGENERATION>
     <IMPORTS>
-        <IMPORT NAME="Advanced_Persistent_Lookup" MODULE="advancedPersistentLookupLib-1.5.jar" MVN="mvn:org.talend.libraries/advancedPersistentLookupLib/1.5" UrlPath="platform:/plugin/org.talend.libraries.persist.lookup/lib/advancedPersistentLookupLib-1.5.jar" REQUIRED="true"/>
+        <IMPORT NAME="Advanced_Persistent_Lookup" MODULE="advancedPersistentLookupLib-1.5.jar" MVN="mvn:org.talend.components.lib/advancedPersistentLookupLib/1.5/jar" UrlPath="platform:/plugin/org.talend.libraries.persist.lookup/lib/advancedPersistentLookupLib-1.5.jar" REQUIRED="true"/>
         <IMPORT NAME="ApacheCommonsCollection32" MODULE="commons-collections-3.2.2.jar" MVN="mvn:commons-collections/commons-collections/3.2.2" UrlPath="platform:/plugin/org.talend.libraries.apache.common/lib/commons-collections-3.2.2.jar" REQUIRED="true" BundleID=""/>
         <IMPORT NAME="Jboss_Marshalling" MODULE="jboss-marshalling-2.0.12.Final.jar" MVN="mvn:org.jboss.marshalling/jboss-marshalling/2.0.12.Final" REQUIRED="true"/>
         <IMPORT NAME="Jboss_River" MODULE="jboss-marshalling-river-2.0.12.Final.jar" MVN="mvn:org.jboss.marshalling/jboss-marshalling-river/2.0.12.Final" REQUIRED="true"/>

main/plugins/org.talend.designer.components.localprovider/components/tAdvancedXMLMapHash/tAdvancedXMLMapHash_java.xml

@@ -47,8 +47,8 @@
     <IMPORTS>
       <IMPORT
         NAME="Advanced_Persistent_Lookup"
-        MODULE="advancedPersistentLookupLib-1.5.jar" MVN="mvn:org.talend.libraries/advancedPersistentLookupLib/1.5" 
-        UrlPath="platform:/plugin/org.talend.libraries.persist.lookup/lib/advancedPersistentLookupLib-1.5.jar" 
+        MODULE="advancedPersistentLookupLib-1.5.jar" MVN="mvn:org.talend.components.lib/advancedPersistentLookupLib/1.5/jar"
+        UrlPath="platform:/plugin/org.talend.libraries.persist.lookup/lib/advancedPersistentLookupLib-1.5.jar"
         REQUIRED="true"
       />
       <IMPORT

main/plugins/org.talend.designer.components.localprovider/components/tAggregateIn/tAggregateIn_messages_ja.properties

@@ -3,7 +3,7 @@ GROUPBYS.ITEM.INPUT_COLUMN=\u5165\u529B\u30AB\u30E9\u30E0\u4F4D\u7F6E
 GROUPBYS.ITEM.OUTPUT_COLUMN=\u51FA\u529B\u30AB\u30E9\u30E0
 GROUPBYS.NAME=\u30B0\u30EB\u30FC\u30D7\u57FA\u6E96:
 HELP=org.talend.help.tAggregateRowOptOut
-LIST_DELIMITER.NAME=\u533A\u5207\u308A(\u30EA\u30B9\u30C8\u64CD\u4F5C\u5C02\u7528)
+LIST_DELIMITER.NAME=\u533A\u5207\u308A(\u64CD\u4F5C\u30EA\u30B9\u30C8\u5C02\u7528)
 USE_FINANCIAL_PRECISION.NAME=\u91D1\u878D\u8A08\u7B97\u7CBE\u5EA6\u3092\u4F7F\u7528\u3057\u307E\u3059\u3002\u3053\u308C\u306F""sum""\u64CD\u4F5C\u3068""avg""\u64CD\u4F5C\u306E\u6700\u5927\u7CBE\u5EA6\u3067\u3059\u3002\u30AA\u30D7\u30B7\u30E7\u30F3\u3092\u30AA\u30F3\u306B\u3059\u308B\u3068\u3001\u30AA\u30D5\u306B\u3057\u305F\u5834\u5408\u3068\u6BD4\u3079\u3066\u30D2\u30FC\u30D7\u30E1\u30E2\u30EA\u304C\u5897\u3057\u3001\u51E6\u7406\u304C\u9045\u304F\u306A\u308A\u307E\u3059\u3002
 CHECK_TYPE_OVERFLOW.NAME=\u30AA\u30FC\u30D0\u30FC\u30D5\u30ED\u30FC\u30C1\u30A7\u30C3\u30AF(\u9045\u3044)
 CHECK_ULP.NAME=ULP (Unit in the Last Place)\u3092\u30C1\u30A7\u30C3\u30AF\u3057\u3066\u3001\u5024\u304C\u5897\u52A0\u3059\u308B\u304B\u6E1B\u5C11\u3059\u308B\u304B\u3092\u6B63\u3057\u304F\u4FDD\u8A3C\u3059\u308B\u3001fload\u578B\u3068double\u578B\u306E\u307F\u5BFE\u5FDC\u3002(\u3088\u308A\u9045\u3044)

main/plugins/org.talend.designer.components.localprovider/components/tAggregateOut/tAggregateOut_messages_ja.properties

@@ -3,7 +3,7 @@ GROUPBYS.ITEM.INPUT_COLUMN=\u5165\u529B\u30AB\u30E9\u30E0\u4F4D\u7F6E
 GROUPBYS.ITEM.OUTPUT_COLUMN=\u51FA\u529B\u30AB\u30E9\u30E0
 GROUPBYS.NAME=\u30B0\u30EB\u30FC\u30D7\u57FA\u6E96:
 HELP=org.talend.help.tAggregateOut
-LIST_DELIMITER.NAME=\u533A\u5207\u308A(\u30EA\u30B9\u30C8\u64CD\u4F5C\u5C02\u7528)
+LIST_DELIMITER.NAME=\u533A\u5207\u308A(\u64CD\u4F5C\u30EA\u30B9\u30C8\u5C02\u7528)
 USE_FINANCIAL_PRECISION.NAME=\u91D1\u878D\u8A08\u7B97\u7CBE\u5EA6\u3092\u4F7F\u7528\u3057\u307E\u3059\u3002\u3053\u308C\u306F""sum""\u64CD\u4F5C\u3068""avg""\u64CD\u4F5C\u306E\u6700\u5927\u7CBE\u5EA6\u3067\u3059\u3002\u30AA\u30D7\u30B7\u30E7\u30F3\u3092\u30AA\u30F3\u306B\u3059\u308B\u3068\u3001\u30AA\u30D5\u306B\u3057\u305F\u5834\u5408\u3068\u6BD4\u3079\u3066\u30D2\u30FC\u30D7\u30E1\u30E2\u30EA\u304C\u5897\u3057\u3001\u51E6\u7406\u304C\u9045\u304F\u306A\u308A\u307E\u3059\u3002
 CHECK_TYPE_OVERFLOW.NAME=\u30AA\u30FC\u30D0\u30FC\u30D5\u30ED\u30FC\u30C1\u30A7\u30C3\u30AF(\u9045\u3044)
 CHECK_ULP.NAME=ULP (Unit in the Last Place)\u3092\u30C1\u30A7\u30C3\u30AF\u3057\u3066\u3001\u5024\u304C\u5897\u52A0\u3059\u308B\u304B\u6E1B\u5C11\u3059\u308B\u304B\u3092\u6B63\u3057\u304F\u4FDD\u8A3C\u3059\u308B\u3001fload\u578B\u3068double\u578B\u306E\u307F\u5BFE\u5FDC\u3002(\u3088\u308A\u9045\u3044)

main/plugins/org.talend.designer.components.localprovider/components/tAggregateRow/tAggregateRow_messages_ja.properties

@@ -3,7 +3,7 @@ GROUPBYS.ITEM.INPUT_COLUMN=\u5165\u529B\u30AB\u30E9\u30E0\u4F4D\u7F6E
 GROUPBYS.ITEM.OUTPUT_COLUMN=\u51FA\u529B\u30AB\u30E9\u30E0
 GROUPBYS.NAME=\u30B0\u30EB\u30FC\u30D7\u57FA\u6E96:
 HELP=org.talend.help.tAggregateRow
-LIST_DELIMITER.NAME=\u533A\u5207\u308A(\u30EA\u30B9\u30C8\u64CD\u4F5C\u5C02\u7528)
+LIST_DELIMITER.NAME=\u533A\u5207\u308A(\u64CD\u4F5C\u30EA\u30B9\u30C8\u5C02\u7528)
 USE_FINANCIAL_PRECISION.NAME=\u91D1\u878D\u8A08\u7B97\u7CBE\u5EA6\u3092\u4F7F\u7528\u3057\u307E\u3059\u3002\u3053\u308C\u306F""sum""\u64CD\u4F5C\u3068""avg""\u64CD\u4F5C\u306E\u6700\u5927\u7CBE\u5EA6\u3067\u3059\u3002\u30AA\u30D7\u30B7\u30E7\u30F3\u3092\u30AA\u30F3\u306B\u3059\u308B\u3068\u3001\u30AA\u30D5\u306B\u3057\u305F\u5834\u5408\u3068\u6BD4\u3079\u3066\u30D2\u30FC\u30D7\u30E1\u30E2\u30EA\u304C\u5897\u3057\u3001\u51E6\u7406\u304C\u9045\u304F\u306A\u308A\u307E\u3059\u3002
 CHECK_TYPE_OVERFLOW.NAME=\u30AA\u30FC\u30D0\u30FC\u30D5\u30ED\u30FC\u30C1\u30A7\u30C3\u30AF(\u9045\u3044)
 CHECK_ULP.NAME=ULP (Unit in the Last Place)\u3092\u30C1\u30A7\u30C3\u30AF\u3057\u3066\u3001\u5024\u304C\u5897\u52A0\u3059\u308B\u304B\u6E1B\u5C11\u3059\u308B\u304B\u3092\u6B63\u3057\u304F\u4FDD\u8A3C\u3059\u308B\u3001fload\u578B\u3068double\u578B\u306E\u307F\u5BFE\u5FDC\u3002(\u3088\u308A\u9045\u3044)

main/plugins/org.talend.designer.components.localprovider/components/tAmazonAuroraRow/tAmazonAuroraRow_messages_fr.properties

@@ -46,7 +46,7 @@ SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.BigDecimal=BigDecimal
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Blob=Blob
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Boolean=Bool\u00E9en
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Byte=Octet
-SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Bytes=Bytes
+SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Bytes=Octets
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Clob=Clob
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Date=Date
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Double=Double

main/plugins/org.talend.designer.components.localprovider/components/tAmazonMysqlConnection/tAmazonMysqlConnection_java.xml

@@ -163,7 +163,7 @@
   <CODEGENERATION>
      <IMPORTS>
        <IMPORT NAME="Driver-MysqlConnector" MODULE="mysql-connector-java-5.1.49.jar" MVN="mvn:mysql/mysql-connector-java/5.1.49"  REQUIRED_IF="DB_VERSION == 'MYSQL_5'" />
-       <IMPORT NAME="Driver-MysqlConnector_Old" MODULE="mysql-connector-java-5.1.0-bin.jar" MVN="mvn:org.talend.libraries/mysql-connector-java-5.1.0-bin/6.0.0"  REQUIRED="false" />
+       <IMPORT NAME="Driver-MysqlConnector_Old" MODULE="mysql-connector-java-5.1.13.jar" MVN="mvn:mysql/mysql-connector-java/5.1.13"  REQUIRED="false" />
        <IMPORT NAME="slf4j-api-1.7.34.jar" MODULE="slf4j-api-1.7.34.jar" MVN="mvn:org.slf4j/slf4j-api/1.7.34" REQUIRED_IF="USE_SHARED_CONNECTION =='true'" />
        <IMPORT NAME="slf4j-reload4j-1.7.34.jar" MODULE="slf4j-reload4j-1.7.34.jar" MVN="mvn:org.slf4j/slf4j-reload4j/1.7.34" REQUIRED_IF="USE_SHARED_CONNECTION =='true'" />
      </IMPORTS>

main/plugins/org.talend.designer.components.localprovider/components/tAmazonMysqlRow/tAmazonMysqlRow_messages_fr.properties

@@ -47,7 +47,7 @@ SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.BigDecimal=BigDecimal
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Blob=Blob
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Boolean=Bool\u00E9en
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Byte=Octet
-SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Bytes=Bytes
+SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Bytes=Octets
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Clob=Clob
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Date=Date
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Double=Double

main/plugins/org.talend.designer.components.localprovider/components/tAmazonOracleConnection/tAmazonOracleConnection_java.xml

@@ -242,7 +242,7 @@
        <IMPORT NAME="TNS" MODULE="tns.jar" MVN="mvn:org.talend.libraries/tns/6.0.0"  REQUIRED="true" />
        <IMPORT NAME="ORACLE_18"     MODULE="ojdbc8-19.19.0.0.jar" MVN="mvn:com.oracle.database.jdbc/ojdbc8/19.19.0.0" REQUIRED_IF="(DB_VERSION == 'ORACLE_18')" />
        <IMPORT NAME="Driver-Ojdbc7" MODULE="ojdbc7.jar" MVN="mvn:org.talend.libraries/ojdbc7/6.0.0"  REQUIRED_IF="(DB_VERSION == 'ORACLE_12')" />
-       <IMPORT NAME="Driver-Ojdbc6" MODULE="ojdbc6.jar" MVN="mvn:org.talend.libraries/ojdbc6/6.0.0"  REQUIRED_IF="(DB_VERSION == 'ORACLE_11')" />
+       <IMPORT NAME="Driver-Ojdbc6" MODULE="ojdbc6-11.2.0.4.jar" MVN="mvn:com.oracle.database.jdbc/ojdbc6/11.2.0.4"  REQUIRED_IF="(DB_VERSION == 'ORACLE_11')" />
        <IMPORT NAME="slf4j-api-1.7.34.jar" MODULE="slf4j-api-1.7.34.jar" MVN="mvn:org.slf4j/slf4j-api/1.7.34" REQUIRED_IF="USE_SHARED_CONNECTION =='true'" />
        <IMPORT NAME="slf4j-reload4j-1.7.34.jar" MODULE="slf4j-reload4j-1.7.34.jar" MVN="mvn:org.slf4j/slf4j-reload4j/1.7.34" REQUIRED_IF="USE_SHARED_CONNECTION =='true'" />
     </IMPORTS>

main/plugins/org.talend.designer.components.localprovider/components/tAmazonOracleInput/tAmazonOracleInput_java.xml

@@ -167,7 +167,7 @@
 	</ADVANCED_PARAMETERS>
 	<CODEGENERATION>
      <IMPORTS>
-       <IMPORT NAME="Driver-Oracle11" MODULE="ojdbc6.jar" MVN="mvn:org.talend.libraries/ojdbc6/6.0.0"  REQUIRED_IF="(DB_VERSION == 'ORACLE_11') AND (USE_EXISTING_CONNECTION == 'false')" />
+       <IMPORT NAME="Driver-Oracle11" MODULE="ojdbc6-11.2.0.4.jar" MVN="mvn:com.oracle.database.jdbc/ojdbc6/11.2.0.4"  REQUIRED_IF="(DB_VERSION == 'ORACLE_11') AND (USE_EXISTING_CONNECTION == 'false')" />
 	   <IMPORT NAME="Driver-Oracle-XDB" MODULE="xdb.jar" MVN="mvn:org.talend.libraries/xdb/6.0.0"  REQUIRED_IF="SCHEMA.DB_TYPE IN ['XMLTYPE']" />
 	   <IMPORT NAME="Driver-Oracle-XMLPARSERV2" BundleID="" MODULE="xmlparserv2.jar" MVN="mvn:org.talend.libraries/xmlparserv2/6.0.0"  REQUIRED_IF="SCHEMA.DB_TYPE IN ['XMLTYPE']" />
        <IMPORT NAME="Driver-Oracle12c" MODULE="ojdbc7.jar" MVN="mvn:org.talend.libraries/ojdbc7/6.0.0"  REQUIRED_IF="(DB_VERSION == 'ORACLE_12') AND (USE_EXISTING_CONNECTION == 'false')" />

main/plugins/org.talend.designer.components.localprovider/components/tAmazonOracleOutput/tAmazonOracleOutput_java.xml

@@ -459,7 +459,7 @@
             <IMPORT NAME="Driver-Oracle-XMLPARSERV2" BundleID="" MODULE="xmlparserv2.jar" MVN="mvn:org.talend.libraries/xmlparserv2/6.0.0"  REQUIRED_IF="SCHEMA.DB_TYPE IN ['XMLTYPE']" />
             <IMPORT NAME="ORACLE_18"     MODULE="ojdbc8-19.19.0.0.jar" MVN="mvn:com.oracle.database.jdbc/ojdbc8/19.19.0.0" REQUIRED_IF="(DB_VERSION == 'ORACLE_18') AND (USE_EXISTING_CONNECTION == 'false')" />
             <IMPORT NAME="Driver-Ojdbc7" MODULE="ojdbc7.jar" MVN="mvn:org.talend.libraries/ojdbc7/6.0.0"  REQUIRED_IF="(DB_VERSION == 'ORACLE_12') AND (USE_EXISTING_CONNECTION == 'false')" />
-            <IMPORT NAME="Driver-Ojdbc6" MODULE="ojdbc6.jar" MVN="mvn:org.talend.libraries/ojdbc6/6.0.0"  REQUIRED_IF="(DB_VERSION == 'ORACLE_11') AND (USE_EXISTING_CONNECTION == 'false')" />
+            <IMPORT NAME="Driver-Ojdbc6" MODULE="ojdbc6-11.2.0.4.jar" MVN="mvn:com.oracle.database.jdbc/ojdbc6/11.2.0.4"  REQUIRED_IF="(DB_VERSION == 'ORACLE_11') AND (USE_EXISTING_CONNECTION == 'false')" />
        </IMPORTS>
   </CODEGENERATION>
 

main/plugins/org.talend.designer.components.localprovider/components/tAmazonOracleRow/tAmazonOracleRow_java.xml

@@ -341,7 +341,7 @@
     <IMPORTS>
        <IMPORT NAME="Driver-OjdbcConnector8" MODULE="ojdbc8-19.19.0.0.jar" MVN="mvn:com.oracle.database.jdbc/ojdbc8/19.19.0.0" REQUIRED_IF="(DB_VERSION == 'ORACLE_18') AND (USE_EXISTING_CONNECTION == 'false')" />
        <IMPORT NAME="Driver-OjdbcConnector7" MODULE="ojdbc7.jar" MVN="mvn:org.talend.libraries/ojdbc7/6.0.0"  REQUIRED_IF="(DB_VERSION == 'ORACLE_12') AND (USE_EXISTING_CONNECTION == 'false')" />
-       <IMPORT NAME="Driver-OjdbcConnector6" MODULE="ojdbc6.jar" MVN="mvn:org.talend.libraries/ojdbc6/6.0.0"  REQUIRED_IF="(DB_VERSION == 'ORACLE_11') AND (USE_EXISTING_CONNECTION == 'false')" />
+       <IMPORT NAME="Driver-OjdbcConnector6" MODULE="ojdbc6-11.2.0.4.jar" MVN="mvn:com.oracle.database.jdbc/ojdbc6/11.2.0.4"  REQUIRED_IF="(DB_VERSION == 'ORACLE_11') AND (USE_EXISTING_CONNECTION == 'false')" />
     </IMPORTS>
    </CODEGENERATION>
 

main/plugins/org.talend.designer.components.localprovider/components/tAmazonOracleRow/tAmazonOracleRow_messages_fr.properties

@@ -52,7 +52,7 @@ SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.BigDecimal=BigDecimal
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Blob=Blob
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Boolean=Bool\u00E9en
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Byte=Octet
-SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Bytes=Bytes
+SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Bytes=Octets
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Clob=Clob
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Date=Date
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Double=Double

main/plugins/org.talend.designer.components.localprovider/components/tAzureSynapseRow/tAzureSynapseRow_messages_fr.properties

@@ -39,7 +39,7 @@ SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.BigDecimal=BigDecimal
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Blob=Blob
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Boolean=Bool\u00E9en
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Byte=Octet
-SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Bytes=Bytes
+SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Bytes=Octets
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Clob=Clob
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Date=Date
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Double=Double

main/plugins/org.talend.designer.components.localprovider/components/tBarChart/tBarChart_java.xml

@@ -87,8 +87,8 @@
 
 <CODEGENERATION>
   <IMPORTS>
-    <IMPORT NAME="JFreeChart" MODULE="jfreechart-1.0.3.jar" MVN="mvn:org.talend.libraries/jfreechart-1.0.3/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.jfreechart/lib/jfreechart-1.0.3.jar" REQUIRED="true"/>
-    <IMPORT NAME="JCommon" MODULE="jcommon-1.0.6.jar" MVN="mvn:org.talend.libraries/jcommon-1.0.6/6.0.0"  REQUIRED="true"/>
+    <IMPORT NAME="JFreeChart" MODULE="jfreechart-1.0.3.jar" MVN="mvn:jfree/jfreechart/1.0.3"  UrlPath="platform:/plugin/org.talend.libraries.jfreechart/lib/jfreechart-1.0.3.jar" REQUIRED="true"/>
+    <IMPORT NAME="JCommon" MODULE="jcommon-1.0.6.jar" MVN="mvn:jfree/jcommon/1.0.6"  REQUIRED="true"/>
   </IMPORTS>
 </CODEGENERATION>
 

main/plugins/org.talend.designer.components.localprovider/components/tBigQueryBulkExec/tBigQueryBulkExec_begin.javajet

@@ -197,21 +197,30 @@ globalMap.put("<%=cid%>_ERROR_MESSAGE",ee_<%=cid%>.getMessage());
 		/* ----END-CREATING-CLIENT (OAuth 2.0)---- */
 
 	<%
-	} else if (authMode.equals("SERVICEACCOUNT")) {
+	} else if (authMode.equals("SERVICEACCOUNT") || authMode.equals("APPLICATION_DEFAULT_CREDENTIALS")) {
 	%>
 		/* ----START-CREATING-CLIENT (Cloud API)---- */
+		<% // Fix verifyError for a huge file TDI-50379 %>
+		class BigQueryBuilder_<%=cid%> {
+			public com.google.cloud.bigquery.BigQuery newBigQuery() throws java.io.IOException {
+				com.google.auth.oauth2.GoogleCredentials credentials_<%=cid%>;
+                <%if ("APPLICATION_DEFAULT_CREDENTIALS".equals(authMode)) { %>
+                        credentials_<%=cid%> = com.google.auth.oauth2.GoogleCredentials.getApplicationDefault();
+                <%} else { %>
+                    java.io.File credentialsFile_<%=cid%> = new java.io.File(<%=credentialsFile%>);
+                    try(java.io.FileInputStream credentialsStream_<%=cid%> = new java.io.FileInputStream(credentialsFile_<%=cid%>)) {
+                        credentials_<%=cid%> = com.google.auth.oauth2.ServiceAccountCredentials.fromStream(credentialsStream_<%=cid%>);
+                    }
+                <%}%>
 
-		com.google.auth.oauth2.GoogleCredentials credentials_<%=cid%>;
-		java.io.File credentialsFile_<%=cid%> = new java.io.File(<%=credentialsFile%>);
-		try(java.io.FileInputStream credentialsStream_<%=cid%> = new java.io.FileInputStream(credentialsFile_<%=cid%>)) {
-		    credentials_<%=cid%> = com.google.auth.oauth2.ServiceAccountCredentials.fromStream(credentialsStream_<%=cid%>);
+				com.google.cloud.bigquery.BigQueryOptions.Builder bigQueryOptionsBuilder_<%=cid%> = com.google.cloud.bigquery.BigQueryOptions.newBuilder().setCredentials(credentials_<%=cid%>).setProjectId(<%=projectId%>);
+				<% if( "true".equals(ElementParameterParser.getValue(node, "__USE_REGION_ENDPOINT__")) ){ %>
+					bigQueryOptionsBuilder_<%=cid%>.setHost( <%= ElementParameterParser.getValue(node, "__REGION_ENDPOINT_BQ__")%> );
+				<%  } %>
+				return bigQueryOptionsBuilder_<%=cid%>.build().getService();
+			}
 		}
-				
-		com.google.cloud.bigquery.BigQueryOptions.Builder bigQueryOptionsBuilder_<%=cid%> = com.google.cloud.bigquery.BigQueryOptions.newBuilder().setCredentials(credentials_<%=cid%>).setProjectId(<%=projectId%>);
-		<% if( "true".equals(ElementParameterParser.getValue(node, "__USE_REGION_ENDPOINT__")) ){ %>
-			bigQueryOptionsBuilder_<%=cid%>.setHost( <%= ElementParameterParser.getValue(node, "__REGION_ENDPOINT_BQ__")%> );
-		<%  } %>
-		com.google.cloud.bigquery.BigQuery bigquery_<%=cid%> = bigQueryOptionsBuilder_<%=cid%>.build().getService();
+		com.google.cloud.bigquery.BigQuery bigquery_<%=cid%> = new BigQueryBuilder_<%=cid%>().newBigQuery();
 
 		/* ----END-CREATING-CLIENT (Cloud API)---- */
 
@@ -244,7 +253,7 @@ globalMap.put("<%=cid%>_ERROR_MESSAGE",ee_<%=cid%>.getMessage());
 	/* ----END-CREATING-CLIENT (OAuth based Token)---- */
 	<%
 	} else {
-		throw new IllegalArgumentException("authentication mode should be either \"SERVICEACCOUNT\", \"OAUTH\" or \"TOKEN\", but it is " + authMode);
+		throw new IllegalArgumentException("authentication mode should be either \"SERVICEACCOUNT\", \"APPLICATION_DEFAULT_CREDENTIALS\", \"OAUTH\" or \"TOKEN\", but it is " + authMode);
 	}
 	boolean bulkFileAlreadyExists = ElementParameterParser.getBooleanValue(node, "__BULK_FILE_ALREADY_EXIST__");
 	String accessKey = ElementParameterParser.getValue(node, "__GS_ACCESS_KEY__");
@@ -662,7 +671,7 @@ globalMap.put("<%=cid%>_ERROR_MESSAGE",ee_<%=cid%>.getMessage());
 		}
 		/* ----END-CREATING-JOB (OAuth 2.0)---- */
 	<%
-	} else if (authMode.equals("SERVICEACCOUNT")) {
+	} else if (authMode.equals("SERVICEACCOUNT") || authMode.equals("APPLICATION_DEFAULT_CREDENTIALS")) {
 	%>
 		/* ----START-CREATING-JOB (Cloud API)---- */
 		com.google.cloud.bigquery.TableId tableId_<%=cid%> = com.google.cloud.bigquery.TableId.of(<%=projectId%>, <%=dataset%>, <%=table%>);
@@ -869,6 +878,6 @@ globalMap.put("<%=cid%>_ERROR_MESSAGE",ee_<%=cid%>.getMessage());
 		/* ----END-CREATING-JOB (Cloud API)---- */
 	<%
 	} else {
-		throw new IllegalArgumentException("authentication mode should be either \"SERVICEACCOUNT\", \"OAUTH\" or \"TOKEN\", but it is " + authMode);
+		throw new IllegalArgumentException("authentication mode should be either \"SERVICEACCOUNT\", \"APPLICATION_DEFAULT_CREDENTIALS\", \"OAUTH\" or \"TOKEN\", but it is " + authMode);
 	}
 	%>

main/plugins/org.talend.designer.components.localprovider/components/tBigQueryBulkExec/tBigQueryBulkExec_java.xml

@@ -45,7 +45,8 @@
     <PARAMETER NAME="AUTH_MODE" FIELD="CLOSED_LIST" NUM_ROW="3" REQUIRED="true" GROUP="AUTHENTICATION" REPOSITORY_VALUE="AUTH_MODE">
 			<ITEMS DEFAULT="SERVICEACCOUNT">
 				<ITEM NAME="SERVICEACCOUNT" VALUE="SERVICEACCOUNT" />
-				<ITEM NAME="OAUTH" VALUE="OAUTH" />
+                <ITEM NAME="APPLICATION_DEFAULT_CREDENTIALS" VALUE="APPLICATION_DEFAULT_CREDENTIALS"/>
+                <ITEM NAME="OAUTH" VALUE="OAUTH" />
 				<ITEM NAME="TOKEN" VALUE="TOKEN" />
 			</ITEMS>
 	</PARAMETER>
@@ -175,6 +176,7 @@
       >
       <ITEMS DEFAULT="GS_SERVICE_ACCOUNT">
         <ITEM NAME="GS_SERVICE_ACCOUNT" VALUE="GS_SERVICE_ACCOUNT"/>
+        <ITEM NAME="GS_APPLICATION_DEFAULT_CREDENTIALS" VALUE="GS_APPLICATION_DEFAULT_CREDENTIALS"/>
         <ITEM NAME="TOKEN" VALUE="TOKEN" />
       </ITEMS>
     </PARAMETER>
@@ -247,7 +249,7 @@
        EQUIRED="true"  
        GROUP="REGION_ENDPOINT_GROUP"
        REPOSITORY_VALUE="USE_REGION_ENDPOINT"
-       SHOW_IF="(AUTH_MODE == 'SERVICEACCOUNT')" >
+       SHOW_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')" >
             <DEFAULT>false</DEFAULT>
     </PARAMETER>
     <PARAMETER  NAME="REGION_ENDPOINT_GS" 
@@ -255,7 +257,7 @@
        NUM_ROW="5" 
        REQUIRED="false" 
        GROUP="REGION_ENDPOINT_GROUP" 
-       SHOW_IF="(AUTH_MODE == 'SERVICEACCOUNT') AND (USE_REGION_ENDPOINT == 'true')" >
+       SHOW_IF="((AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')) AND (USE_REGION_ENDPOINT == 'true')" >
        <DEFAULT>"https://storage.googleapis.com"</DEFAULT>
     </PARAMETER>
     <PARAMETER  NAME="REGION_ENDPOINT_BQ" 
@@ -263,7 +265,7 @@
        NUM_ROW="6" 
        REQUIRED="false" 
        GROUP="REGION_ENDPOINT_GROUP" REPOSITORY_VALUE="REGION_ENDPOINT_BQ"
-       SHOW_IF="(AUTH_MODE == 'SERVICEACCOUNT') AND (USE_REGION_ENDPOINT == 'true')" >
+       SHOW_IF="((AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')) AND (USE_REGION_ENDPOINT == 'true')" >
        <DEFAULT>"https://bigquery.googleapis.com"</DEFAULT>
     </PARAMETER>
     <PARAMETER NAME="TOKEN_NAME" FIELD="FILE" NUM_ROW="8"
@@ -308,36 +310,36 @@
 		<IMPORT NAME="httpclient-4.5.13" MODULE="httpclient-4.5.13.jar" MVN="mvn:org.apache.httpcomponents/httpclient/4.5.13" 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 NAME="commons-codec-1.14" MODULE="commons-codec-1.14.jar" MVN="mvn:commons-codec/commons-codec/1.14" 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') OR (AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN')" />
+		<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') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'GS_APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'TOKEN')" />
 		
 		<!-- TODO remove it -->
-		<IMPORT NAME="google-http-client-jackson-1.25.0.jar" MODULE="google-http-client-jackson-1.25.0.jar" MVN="mvn:com.google.http-client/google-http-client-jackson/1.25.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN')" />
+		<IMPORT NAME="google-http-client-jackson-1.25.0.jar" MODULE="google-http-client-jackson-1.25.0.jar" MVN="mvn:com.google.http-client/google-http-client-jackson/1.25.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'GS_APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'TOKEN')" />
 		
-		<IMPORT NAME="threetenbp-1.3.3.jar" MODULE="threetenbp-1.3.3.jar" MVN="mvn:org.threeten/threetenbp/1.3.3" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN')" />
-		<IMPORT NAME="google-auth-library-credentials-0.20.0.jar" MODULE="google-auth-library-credentials-0.20.0.jar" MVN="mvn:com.google.auth/google-auth-library-credentials/0.20.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN')" />
-		<IMPORT NAME="gax-httpjson-0.44.0.jar" MODULE="gax-httpjson-0.44.0.jar" MVN="mvn:com.google.api/gax-httpjson/0.44.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN')" />
-		<IMPORT NAME="jackson-core-asl-1.9.13.jar" MODULE="jackson-core-asl-1.9.13.jar" MVN="mvn:org.codehaus.jackson/jackson-core-asl/1.9.13" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN')" />
-		<IMPORT NAME="google-auth-library-oauth2-http-0.20.0.jar" MODULE="google-auth-library-oauth2-http-0.20.0.jar" MVN="mvn:com.google.auth/google-auth-library-oauth2-http/0.20.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN')" />
-		<IMPORT NAME="google-cloud-core-1.93.4.jar" MODULE="google-cloud-core-1.93.4.jar" MVN="mvn:com.google.cloud/google-cloud-core/1.93.4" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN')" />
-		<IMPORT NAME="google-cloud-core-http-1.32.0.jar" MODULE="google-cloud-core-http-1.32.0.jar" MVN="mvn:com.google.cloud/google-cloud-core-http/1.32.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN')" />
-		<IMPORT NAME="gax-1.27.0.jar" MODULE="gax-1.27.0.jar" MVN="mvn:com.google.api/gax/1.27.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN')" />
-		<IMPORT NAME="google-http-client-appengine-1.38.0.jar" MODULE="google-http-client-appengine-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client-appengine/1.38.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN')" />
-		<IMPORT NAME="api-common-1.6.0.jar" MODULE="api-common-1.6.0.jar" MVN="mvn:com.google.api/api-common/1.6.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN')" />
+		<IMPORT NAME="threetenbp-1.3.3.jar" MODULE="threetenbp-1.3.3.jar" MVN="mvn:org.threeten/threetenbp/1.3.3" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'GS_APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'TOKEN')" />
+		<IMPORT NAME="google-auth-library-credentials-0.20.0.jar" MODULE="google-auth-library-credentials-0.20.0.jar" MVN="mvn:com.google.auth/google-auth-library-credentials/0.20.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'GS_APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'TOKEN')" />
+		<IMPORT NAME="gax-httpjson-0.44.0.jar" MODULE="gax-httpjson-0.44.0.jar" MVN="mvn:com.google.api/gax-httpjson/0.44.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'GS_APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'TOKEN')" />
+		<IMPORT NAME="jackson-core-asl-1.9.13.jar" MODULE="jackson-core-asl-1.9.13.jar" MVN="mvn:org.codehaus.jackson/jackson-core-asl/1.9.13" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'GS_APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'TOKEN')" />
+		<IMPORT NAME="google-auth-library-oauth2-http-0.20.0.jar" MODULE="google-auth-library-oauth2-http-0.20.0.jar" MVN="mvn:com.google.auth/google-auth-library-oauth2-http/0.20.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'GS_APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'TOKEN')" />
+		<IMPORT NAME="google-cloud-core-1.93.4.jar" MODULE="google-cloud-core-1.93.4.jar" MVN="mvn:com.google.cloud/google-cloud-core/1.93.4" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'GS_APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'TOKEN')" />
+		<IMPORT NAME="google-cloud-core-http-1.32.0.jar" MODULE="google-cloud-core-http-1.32.0.jar" MVN="mvn:com.google.cloud/google-cloud-core-http/1.32.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'GS_APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'TOKEN')" />
+		<IMPORT NAME="gax-1.27.0.jar" MODULE="gax-1.27.0.jar" MVN="mvn:com.google.api/gax/1.27.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_TYPE == 'APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_MODE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'GS_APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'TOKEN')" />
+		<IMPORT NAME="google-http-client-appengine-1.38.0.jar" MODULE="google-http-client-appengine-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client-appengine/1.38.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'GS_APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'TOKEN')" />
+		<IMPORT NAME="api-common-1.6.0.jar" MODULE="api-common-1.6.0.jar" MVN="mvn:com.google.api/api-common/1.6.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'GS_APPLICATION_DEFAULT_CREDENTIALS') 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 == 'GS_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 == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'GS_APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'TOKEN')" />
       <!-- Transitive dependencies of google-cloud-storage -->
-      <IMPORT NAME="google-api-services-storage-v1-rev20201112-1.31.0" MODULE="google-api-services-storage-v1-rev20201112-1.31.0.jar" MVN="mvn:com.google.apis/google-api-services-storage/v1-rev20201112-1.31.0" REQUIRED_IF="(AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN')" />
+      <IMPORT NAME="google-api-services-storage-v1-rev20201112-1.31.0" MODULE="google-api-services-storage-v1-rev20201112-1.31.0.jar" MVN="mvn:com.google.apis/google-api-services-storage/v1-rev20201112-1.31.0" REQUIRED_IF="(AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'GS_APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'TOKEN')" />
       <IMPORT NAME="gson-2.8.9" MODULE="gson-2.8.9.jar" MVN="mvn:com.google.code.gson/gson/2.8.9" REQUIRED="true" />
-      <IMPORT NAME="javax.annotation-api" MODULE="javax.annotation-api-1.3.jar" MVN="mvn:javax.annotation/javax.annotation-api/1.3" REQUIRED_IF="(AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN')" />
-      <IMPORT NAME="protobuf-java-3.19.6" MODULE="protobuf-java-3.19.6.jar" MVN="mvn:com.google.protobuf/protobuf-java/3.19.6" REQUIRED_IF="(AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN')" />
-      <IMPORT NAME="error_prone_annotation-2.1.3" MODULE="error_prone_annotation-2.1.3.jar" MVN="mvn:com.google.errorprone/error_prone_annotations/2.1.3" REQUIRED_IF="(AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN')" />
+      <IMPORT NAME="javax.annotation-api" MODULE="javax.annotation-api-1.3.jar" MVN="mvn:javax.annotation/javax.annotation-api/1.3" REQUIRED_IF="(AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'GS_APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'TOKEN')" />
+      <IMPORT NAME="protobuf-java-3.19.6" MODULE="protobuf-java-3.19.6.jar" MVN="mvn:com.google.protobuf/protobuf-java/3.19.6" REQUIRED_IF="(AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'GS_APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'TOKEN')" />
+      <IMPORT NAME="error_prone_annotation-2.1.3" MODULE="error_prone_annotation-2.1.3.jar" MVN="mvn:com.google.errorprone/error_prone_annotations/2.1.3" REQUIRED_IF="(AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'GS_APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'TOKEN')" />
       <IMPORT NAME="opencensus-api-0.24.0" MODULE="opencensus-api-0.24.0.jar" MVN="mvn:io.opencensus/opencensus-api/0.24.0" REQUIRED="true" />
       <IMPORT NAME="opencensus-contrib-http-util-0.24.0" MODULE="opencensus-contrib-http-util-0.24.0.jar" MVN="mvn:io.opencensus/opencensus-contrib-http-util/0.24.0" REQUIRED="true" />
       <IMPORT NAME="grpc-context-1.22.1" MODULE="grpc-context-1.22.1.jar" MVN="mvn:io.grpc/grpc-context/1.22.1" REQUIRED="true" />
-      <IMPORT NAME="proto-google-common-protos-1.17.0" MODULE="proto-google-common-protos-1.17.0.jar" MVN="mvn:com.google.api.grpc/proto-google-common-protos/1.17.0" REQUIRED_IF="(AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN')" />
-      <IMPORT NAME="proto-google-iam-v1-0.13.0" MODULE="proto-google-iam-v1-0.13.0.jar" MVN="mvn:com.google.api.grpc/proto-google-iam-v1/0.13.0" REQUIRED_IF="(AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN')" />
-      <IMPORT NAME="protobuf-java-util-3.19.6" MODULE="protobuf-java-util-3.19.6.jar" MVN="mvn:com.google.protobuf/protobuf-java-util/3.19.6" REQUIRED_IF="(AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN')" />
-      <IMPORT NAME="annotation-1.1.0" MODULE="annotation-1.1.0.jar" MVN="mvn:androidx.annotation/annotation/1.1.0" REQUIRED_IF="(AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'TOKEN')" />
+      <IMPORT NAME="proto-google-common-protos-1.17.0" MODULE="proto-google-common-protos-1.17.0.jar" MVN="mvn:com.google.api.grpc/proto-google-common-protos/1.17.0" REQUIRED_IF="(AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'GS_APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'TOKEN')" />
+      <IMPORT NAME="proto-google-iam-v1-0.13.0" MODULE="proto-google-iam-v1-0.13.0.jar" MVN="mvn:com.google.api.grpc/proto-google-iam-v1/0.13.0" REQUIRED_IF="(AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'GS_APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'TOKEN')" />
+      <IMPORT NAME="protobuf-java-util-3.19.6" MODULE="protobuf-java-util-3.19.6.jar" MVN="mvn:com.google.protobuf/protobuf-java-util/3.19.6" REQUIRED_IF="(AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'GS_APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'TOKEN')" />
+      <IMPORT NAME="annotation-1.1.0" MODULE="annotation-1.1.0.jar" MVN="mvn:androidx.annotation/annotation/1.1.0" REQUIRED_IF="(AUTH_TYPE == 'GS_SERVICE_ACCOUNT') OR (AUTH_TYPE == 'GS_APPLICATION_DEFAULT_CREDENTIALS') OR (AUTH_TYPE == 'TOKEN')" />
      </IMPORTS>
    </CODEGENERATION>
    <RETURNS>

main/plugins/org.talend.designer.components.localprovider/components/tBigQueryBulkExec/tBigQueryBulkExec_messages.properties

@@ -4,6 +4,7 @@ AUTHENTICATION.NAME=Authentication
 SERVICE_ACCOUNT_CREDENTIALS_FILE.NAME=Service account credentials file
 AUTH_MODE.NAME=Authentication mode
 AUTH_MODE.ITEM.SERVICEACCOUNT=Service account
+AUTH_MODE.ITEM.APPLICATION_DEFAULT_CREDENTIALS=Application Default Credentials
 AUTH_MODE.ITEM.OAUTH=OAuth 2.0
 AUTH_MODE.ITEM.TOKEN=OAuth Access Token
 CLIENT_ID.NAME=Client Id
@@ -38,6 +39,7 @@ DIE_ON_ERROR.NAME=Die on error
 AUTH_TYPE.NAME=Credential type
 AUTH_TYPE.ITEM.GS_SERVICE_ACCOUNT=Service account
 GS_SERVICE_ACCOUNT_KEY.NAME=Service account key
+AUTH_TYPE.ITEM.GS_APPLICATION_DEFAULT_CREDENTIALS=Application Default Credentials
 GS_ACCESS_TOKEN.NAME=OAuth Access Token
 AUTH_TYPE.ITEM.TOKEN=OAuth Access Token
 JOBID.NAME=BigQuery JobId

main/plugins/org.talend.designer.components.localprovider/components/tBigQueryBulkExec/tBigQueryBulkExec_messages_fr.properties

@@ -4,6 +4,7 @@ AUTHENTICATION.NAME=Authentification
 SERVICE_ACCOUNT_CREDENTIALS_FILE.NAME=Fichier d'identifiants du compte de service
 AUTH_MODE.NAME=Mode d'authentification
 AUTH_MODE.ITEM.SERVICEACCOUNT=Compte de service
+AUTH_MODE.ITEM.APPLICATION_DEFAULT_CREDENTIALS=Identifiants par d\u00E9faut pour l'application
 AUTH_MODE.ITEM.OAUTH=OAuth 2.0
 AUTH_MODE.ITEM.TOKEN=Jeton d'acc\u00E8s OAuth
 CLIENT_ID.NAME=ID client
@@ -38,6 +39,7 @@ DIE_ON_ERROR.NAME=Arr\u00EAter en cas d'erreur
 AUTH_TYPE.NAME=Type d'identifiant
 AUTH_TYPE.ITEM.GS_SERVICE_ACCOUNT=Compte de service
 GS_SERVICE_ACCOUNT_KEY.NAME=Cl\u00E9 du compte de service
+AUTH_TYPE.ITEM.GS_APPLICATION_DEFAULT_CREDENTIALS=Identifiants par d\u00E9faut pour l'application
 GS_ACCESS_TOKEN.NAME=Jeton d'acc\u00E8s OAuth
 AUTH_TYPE.ITEM.TOKEN=Jeton d'acc\u00E8s OAuth
 JOBID.NAME=ID du Job BigQuery

main/plugins/org.talend.designer.components.localprovider/components/tBigQueryBulkExec/tBigQueryBulkExec_messages_ja.properties

@@ -4,6 +4,7 @@ AUTHENTICATION.NAME=\u8A8D\u8A3C
 SERVICE_ACCOUNT_CREDENTIALS_FILE.NAME=\u30B5\u30FC\u30D3\u30B9\u30A2\u30AB\u30A6\u30F3\u30C8\u8A8D\u8A3C\u60C5\u5831\u30D5\u30A1\u30A4\u30EB
 AUTH_MODE.NAME=\u8A8D\u8A3C\u30E2\u30FC\u30C9
 AUTH_MODE.ITEM.SERVICEACCOUNT=\u30B5\u30FC\u30D3\u30B9\u30A2\u30AB\u30A6\u30F3\u30C8
+AUTH_MODE.ITEM.APPLICATION_DEFAULT_CREDENTIALS=\u30A2\u30D7\u30EA\u30B1\u30FC\u30B7\u30E7\u30F3\u306E\u30C7\u30D5\u30A9\u30EB\u30C8\u8A8D\u8A3C\u60C5\u5831
 AUTH_MODE.ITEM.OAUTH=OAuth2.0
 AUTH_MODE.ITEM.TOKEN=OAuth\u30A2\u30AF\u30BB\u30B9\u30C8\u30FC\u30AF\u30F3
 CLIENT_ID.NAME=\u30AF\u30E9\u30A4\u30A2\u30F3\u30C8ID
@@ -38,6 +39,7 @@ DIE_ON_ERROR.NAME=\u30A8\u30E9\u30FC\u767A\u751F\u6642\u306B\u5F37\u5236\u7D42\u
 AUTH_TYPE.NAME=\u8A8D\u8A3C\u60C5\u5831\u306E\u30BF\u30A4\u30D7
 AUTH_TYPE.ITEM.GS_SERVICE_ACCOUNT=\u30B5\u30FC\u30D3\u30B9\u30A2\u30AB\u30A6\u30F3\u30C8
 GS_SERVICE_ACCOUNT_KEY.NAME=\u30B5\u30FC\u30D3\u30B9\u30A2\u30AB\u30A6\u30F3\u30C8\u30AD\u30FC
+AUTH_TYPE.ITEM.GS_APPLICATION_DEFAULT_CREDENTIALS=\u30A2\u30D7\u30EA\u30B1\u30FC\u30B7\u30E7\u30F3\u306E\u30C7\u30D5\u30A9\u30EB\u30C8\u8A8D\u8A3C\u60C5\u5831
 GS_ACCESS_TOKEN.NAME=OAuth\u30A2\u30AF\u30BB\u30B9\u30C8\u30FC\u30AF\u30F3
 AUTH_TYPE.ITEM.TOKEN=OAuth\u30A2\u30AF\u30BB\u30B9\u30C8\u30FC\u30AF\u30F3
 JOBID.NAME=BigQuery JobId

main/plugins/org.talend.designer.components.localprovider/components/tBigQueryBulkExec/tBigQueryBulkExec_messages_zh_CN.properties

@@ -4,6 +4,7 @@ AUTHENTICATION.NAME=\u8EAB\u4EFD\u9A8C\u8BC1
 SERVICE_ACCOUNT_CREDENTIALS_FILE.NAME=\u670D\u52A1\u5E10\u6237\u7528\u6237\u540D\u548C\u5BC6\u7801\u6587\u4EF6
 AUTH_MODE.NAME=\u8EAB\u4EFD\u9A8C\u8BC1\u6A21\u5F0F
 AUTH_MODE.ITEM.SERVICEACCOUNT=\u670D\u52A1\u5E10\u6237
+AUTH_MODE.ITEM.APPLICATION_DEFAULT_CREDENTIALS=\u5E94\u7528\u7A0B\u5E8F\u9ED8\u8BA4\u51ED\u636E
 AUTH_MODE.ITEM.OAUTH=OAuth 2.0
 AUTH_MODE.ITEM.TOKEN=OAuth \u8BBF\u95EE\u4EE4\u724C
 CLIENT_ID.NAME=\u5BA2\u6237\u7AEF ID
@@ -38,6 +39,7 @@ DIE_ON_ERROR.NAME=\u9519\u8BEF\u65F6\u7EC8\u6B62
 AUTH_TYPE.NAME=\u51ED\u8BC1\u7C7B\u578B
 AUTH_TYPE.ITEM.GS_SERVICE_ACCOUNT=\u670D\u52A1\u5E10\u6237
 GS_SERVICE_ACCOUNT_KEY.NAME=\u670D\u52A1\u5E10\u6237\u5BC6\u94A5
+AUTH_TYPE.ITEM.GS_APPLICATION_DEFAULT_CREDENTIALS=\u5E94\u7528\u7A0B\u5E8F\u9ED8\u8BA4\u51ED\u636E
 GS_ACCESS_TOKEN.NAME=OAuth \u8BBF\u95EE\u4EE4\u724C
 AUTH_TYPE.ITEM.TOKEN=OAuth \u8BBF\u95EE\u4EE4\u724C
 JOBID.NAME=BigQuery JobId

main/plugins/org.talend.designer.components.localprovider/components/tBigQueryInput/ServiceAccountBigQueryHelper.javajet

@@ -14,10 +14,14 @@ class ServiceAccountBigQueryUtil_<%=cid%> {
 			return bigQuery;
 		}
 		com.google.auth.oauth2.GoogleCredentials credentials;
-		java.io.File credentialsFile = new java.io.File(<%=credentialsFile%>);
-		try(java.io.FileInputStream credentialsStream = new java.io.FileInputStream(credentialsFile)) {
-			credentials = com.google.auth.oauth2.ServiceAccountCredentials.fromStream(credentialsStream);
-		}
+		<% if(authMode.equals("APPLICATION_DEFAULT_CREDENTIALS")) { %>
+			credentials = com.google.auth.oauth2.GoogleCredentials.getApplicationDefault();
+		<% } else { %>
+			java.io.File credentialsFile = new java.io.File(<%=credentialsFile%>);
+			try(java.io.FileInputStream credentialsStream = new java.io.FileInputStream(credentialsFile)) {
+				credentials = com.google.auth.oauth2.ServiceAccountCredentials.fromStream(credentialsStream);
+			}
+		<% } %>
 
         com.google.cloud.bigquery.BigQueryOptions.Builder bigQueryOptionsBuilder = com.google.cloud.bigquery.BigQueryOptions.newBuilder()
             .setCredentials(credentials)

main/plugins/org.talend.designer.components.localprovider/components/tBigQueryInput/tBigQueryInput_begin.javajet

@@ -295,7 +295,7 @@ globalMap.put("<%=cid%>_ERROR_MESSAGE",ee_<%=cid%>.getMessage());
 		%>
 		//Dynamic end
 	<%
-	} else if (authMode.equals("SERVICEACCOUNT")) {
+	} else if (authMode.equals("SERVICEACCOUNT") || authMode.equals("APPLICATION_DEFAULT_CREDENTIALS")) {
 	%>
 
 		<%@ include file="@{org.talend.designer.components.localprovider}/components/tBigQueryInput/ServiceAccountBigQueryHelper.javajet"%>
@@ -390,7 +390,7 @@ globalMap.put("<%=cid%>_ERROR_MESSAGE",ee_<%=cid%>.getMessage());
 		//Dynamic end
 	<%
 	} else {
-		throw new IllegalArgumentException("authentication mode should be either \"SERVICEACCOUNT\", \"OAUTH\" or \"TOKEN\", but it is " + authMode);
+		throw new IllegalArgumentException("authentication mode should be either \"SERVICEACCOUNT\", \"APPLICATION_DEFAULT_CREDENTIALS\", \"OAUTH\" or \"TOKEN\", but it is " + authMode);
 	}
 
 	if (authMode.equals("OAUTH") || authMode.equals("TOKEN")) {
@@ -441,14 +441,14 @@ globalMap.put("<%=cid%>_ERROR_MESSAGE",ee_<%=cid%>.getMessage());
                     Object value_<%=cid%> = null;
                     nb_line_<%=cid%> ++;
     <%
-	} else if (authMode.equals("SERVICEACCOUNT")) {
+	} else if (authMode.equals("SERVICEACCOUNT") || authMode.equals("APPLICATION_DEFAULT_CREDENTIALS")) {
 	%>
 		for (com.google.cloud.bigquery.FieldValueList field_<%=cid %> : result_<%=cid%>.iterateAll()) {
 			Object value_<%=cid%>;
 			nb_line_<%=cid%> ++;
 	<%
 	} else {
-		throw new IllegalArgumentException("authentication mode should be either \"SERVICEACCOUNT\", \"OAUTH\" or \"TOKEN\", but it is " + authMode);
+		throw new IllegalArgumentException("authentication mode should be either \"SERVICEACCOUNT\", \"APPLICATION_DEFAULT_CREDENTIALS\", \"OAUTH\" or \"TOKEN\", but it is " + authMode);
 	}
 		%>
 		int fieldsCount_<%=cid %> = field_<%=cid %>.size();
@@ -500,12 +500,12 @@ globalMap.put("<%=cid%>_ERROR_MESSAGE",ee_<%=cid%>.getMessage());
 								%>
 								value_<%=cid%> = field_<%=cid %>.get(column_index_<%=cid%>).getV();
 								<%
-								} else if (authMode.equals("SERVICEACCOUNT")) {
+								} else if (authMode.equals("SERVICEACCOUNT") || authMode.equals("APPLICATION_DEFAULT_CREDENTIALS")) {
 								%>
 								value_<%=cid%> = field_<%=cid %>.get(column_index_<%=cid%>).getValue();
 								<%
 								} else {
-									throw new IllegalArgumentException("authentication mode should be either \"SERVICEACCOUNT\", \"OAUTH\" or \"TOKEN\", but it is " + authMode);
+									throw new IllegalArgumentException("authentication mode should be either \"SERVICEACCOUNT\", \"APPLICATION_DEFAULT_CREDENTIALS\", \"OAUTH\" or \"TOKEN\", but it is " + authMode);
 								}
 								%>
 								if(com.google.api.client.util.Data.isNull(value_<%=cid%>)) value_<%=cid%> = null;

main/plugins/org.talend.designer.components.localprovider/components/tBigQueryInput/tBigQueryInput_end.javajet

@@ -26,7 +26,7 @@ imports="
         }
     }
   	<%
-  	} else if (authMode.equals("SERVICEACCOUNT")) {
+  	} else if (authMode.equals("SERVICEACCOUNT") || authMode.equals("APPLICATION_DEFAULT_CREDENTIALS")) {
   	%>
             }
             if (child_statistics_<%=cid%> != null) {
@@ -35,7 +35,7 @@ imports="
         //}
 <%
       } else {
-          throw new IllegalArgumentException("authentication mode should be either \"SERVICEACCOUNT\" or \"OAUTH\" or \"TOKEN\", but it is " + authMode);
+          throw new IllegalArgumentException("authentication mode should be either \"SERVICEACCOUNT\", \"APPLICATION_DEFAULT_CREDENTIALS\" or \"OAUTH\" or \"TOKEN\", but it is " + authMode);
       }
       log4jFileUtil.retrievedDataNumberInfo(node);
       // Else job has finished successfully with the results. Finish }.

main/plugins/org.talend.designer.components.localprovider/components/tBigQueryInput/tBigQueryInput_java.xml

@@ -62,7 +62,8 @@
     <PARAMETER NAME="AUTH_MODE" FIELD="CLOSED_LIST" NUM_ROW="3" REQUIRED="true" GROUP="AUTHENTICATION" REPOSITORY_VALUE="AUTH_MODE">
 			<ITEMS DEFAULT="SERVICEACCOUNT">
 				<ITEM NAME="SERVICEACCOUNT" VALUE="SERVICEACCOUNT" />
-				<ITEM NAME="OAUTH" VALUE="OAUTH" />
+                <ITEM NAME="APPLICATION_DEFAULT_CREDENTIALS" VALUE="APPLICATION_DEFAULT_CREDENTIALS"/>
+                <ITEM NAME="OAUTH" VALUE="OAUTH" />
 				<ITEM NAME="TOKEN" VALUE="TOKEN" />
 			</ITEMS>
 	</PARAMETER>
@@ -188,7 +189,7 @@
        EQUIRED="true"  
        GROUP="REGION_ENDPOINT_GROUP"
        REPOSITORY_VALUE="USE_REGION_ENDPOINT"
-       SHOW_IF="(AUTH_MODE == 'SERVICEACCOUNT')" >
+       SHOW_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')" >
             <DEFAULT>false</DEFAULT>
     </PARAMETER>
     <PARAMETER  NAME="REGION_ENDPOINT_BQ" 
@@ -196,7 +197,7 @@
        NUM_ROW="6" 
        REQUIRED="false" 
        GROUP="REGION_ENDPOINT_GROUP" REPOSITORY_VALUE="REGION_ENDPOINT_BQ"
-       SHOW_IF="(AUTH_MODE == 'SERVICEACCOUNT') AND (USE_REGION_ENDPOINT == 'true')" >
+       SHOW_IF="((AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')) AND (USE_REGION_ENDPOINT == 'true')" >
        <DEFAULT>"https://bigquery.googleapis.com"</DEFAULT>
     </PARAMETER>
     <PARAMETER NAME="TOKEN_NAME" FIELD="FILE" NUM_ROW="8"
@@ -249,25 +250,25 @@
 		 <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.14.3.jar" MODULE="jackson-core-2.14.3.jar" MVN="mvn:com.fasterxml.jackson.core/jackson-core/2.14.3" 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'" />
+		<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') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')" />
 
 		<!-- TODO remove it -->
-		<IMPORT NAME="google-http-client-jackson-1.25.0.jar" MODULE="google-http-client-jackson-1.25.0.jar" MVN="mvn:com.google.http-client/google-http-client-jackson/1.25.0" REQUIRED_IF="AUTH_MODE == 'SERVICEACCOUNT'" />
+		<IMPORT NAME="google-http-client-jackson-1.25.0.jar" MODULE="google-http-client-jackson-1.25.0.jar" MVN="mvn:com.google.http-client/google-http-client-jackson/1.25.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')" />
 
-		<IMPORT NAME="threetenbp-1.3.3.jar" MODULE="threetenbp-1.3.3.jar" MVN="mvn:org.threeten/threetenbp/1.3.3" REQUIRED_IF="AUTH_MODE == 'SERVICEACCOUNT'" />
-		<IMPORT NAME="google-auth-library-credentials-0.20.0.jar" MODULE="google-auth-library-credentials-0.20.0.jar" MVN="mvn:com.google.auth/google-auth-library-credentials/0.20.0" REQUIRED_IF="AUTH_MODE == 'SERVICEACCOUNT'" />
-		<IMPORT NAME="gax-httpjson-0.44.0.jar" MODULE="gax-httpjson-0.44.0.jar" MVN="mvn:com.google.api/gax-httpjson/0.44.0" REQUIRED_IF="AUTH_MODE == 'SERVICEACCOUNT'" />
-		<IMPORT NAME="jackson-core-asl-1.9.13.jar" MODULE="jackson-core-asl-1.9.13.jar" MVN="mvn:org.codehaus.jackson/jackson-core-asl/1.9.13" REQUIRED_IF="AUTH_MODE == 'SERVICEACCOUNT'" />
-		<IMPORT NAME="google-auth-library-oauth2-http-0.20.0.jar" MODULE="google-auth-library-oauth2-http-0.20.0.jar" MVN="mvn:com.google.auth/google-auth-library-oauth2-http/0.20.0" REQUIRED_IF="AUTH_MODE == 'SERVICEACCOUNT'" />
-		<IMPORT NAME="google-cloud-core-1.93.4.jar" MODULE="google-cloud-core-1.93.4.jar" MVN="mvn:com.google.cloud/google-cloud-core/1.93.4" REQUIRED_IF="AUTH_MODE == 'SERVICEACCOUNT'" />
-		<IMPORT NAME="google-cloud-core-http-1.32.0.jar" MODULE="google-cloud-core-http-1.32.0.jar" MVN="mvn:com.google.cloud/google-cloud-core-http/1.32.0" REQUIRED_IF="AUTH_MODE == 'SERVICEACCOUNT'" />
-		<IMPORT NAME="gax-1.27.0.jar" MODULE="gax-1.27.0.jar" MVN="mvn:com.google.api/gax/1.27.0" REQUIRED_IF="AUTH_MODE == 'SERVICEACCOUNT'" />
-		<IMPORT NAME="google-http-client-appengine-1.38.0.jar" MODULE="google-http-client-appengine-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client-appengine/1.38.0" REQUIRED_IF="AUTH_MODE == 'SERVICEACCOUNT'" />
-		<IMPORT NAME="api-common-1.6.0.jar" MODULE="api-common-1.6.0.jar" MVN="mvn:com.google.api/api-common/1.6.0" REQUIRED_IF="AUTH_MODE == 'SERVICEACCOUNT'" />
+		<IMPORT NAME="threetenbp-1.3.3.jar" MODULE="threetenbp-1.3.3.jar" MVN="mvn:org.threeten/threetenbp/1.3.3" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')" />
+		<IMPORT NAME="google-auth-library-credentials-0.20.0.jar" MODULE="google-auth-library-credentials-0.20.0.jar" MVN="mvn:com.google.auth/google-auth-library-credentials/0.20.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')" />
+		<IMPORT NAME="gax-httpjson-0.44.0.jar" MODULE="gax-httpjson-0.44.0.jar" MVN="mvn:com.google.api/gax-httpjson/0.44.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')" />
+		<IMPORT NAME="jackson-core-asl-1.9.13.jar" MODULE="jackson-core-asl-1.9.13.jar" MVN="mvn:org.codehaus.jackson/jackson-core-asl/1.9.13" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')" />
+		<IMPORT NAME="google-auth-library-oauth2-http-0.20.0.jar" MODULE="google-auth-library-oauth2-http-0.20.0.jar" MVN="mvn:com.google.auth/google-auth-library-oauth2-http/0.20.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')" />
+		<IMPORT NAME="google-cloud-core-1.93.4.jar" MODULE="google-cloud-core-1.93.4.jar" MVN="mvn:com.google.cloud/google-cloud-core/1.93.4" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')" />
+		<IMPORT NAME="google-cloud-core-http-1.32.0.jar" MODULE="google-cloud-core-http-1.32.0.jar" MVN="mvn:com.google.cloud/google-cloud-core-http/1.32.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')" />
+		<IMPORT NAME="gax-1.27.0.jar" MODULE="gax-1.27.0.jar" MVN="mvn:com.google.api/gax/1.27.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')" />
+		<IMPORT NAME="google-http-client-appengine-1.38.0.jar" MODULE="google-http-client-appengine-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client-appengine/1.38.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')" />
+		<IMPORT NAME="api-common-1.6.0.jar" MODULE="api-common-1.6.0.jar" MVN="mvn:com.google.api/api-common/1.6.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')" />
 		<IMPORT NAME="opencensus-api-0.24.0" MODULE="opencensus-api-0.24.0.jar" MVN="mvn:io.opencensus/opencensus-api/0.24.0" REQUIRED="true" />
 		<IMPORT NAME="opencensus-contrib-http-util-0.24.0" MODULE="opencensus-contrib-http-util-0.24.0.jar" MVN="mvn:io.opencensus/opencensus-contrib-http-util/0.24.0" REQUIRED="true" />
 		<IMPORT NAME="grpc-context-1.22.1" MODULE="grpc-context-1.22.1.jar" MVN="mvn:io.grpc/grpc-context/1.22.1" REQUIRED="true" />
-        <IMPORT NAME="gson-2.8.9" MODULE="gson-2.8.9.jar" MVN="mvn:com.google.code.gson/gson/2.8.9" REQUIRED_IF="AUTH_MODE == 'SERVICEACCOUNT'" />
+        <IMPORT NAME="gson-2.8.9" MODULE="gson-2.8.9.jar" MVN="mvn:com.google.code.gson/gson/2.8.9" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')" />
      </IMPORTS>
    </CODEGENERATION>
    <RETURNS>

main/plugins/org.talend.designer.components.localprovider/components/tBigQueryInput/tBigQueryInput_messages.properties

@@ -4,6 +4,7 @@ AUTHENTICATION.NAME=Authentication
 SERVICE_ACCOUNT_CREDENTIALS_FILE.NAME=Service account credentials file
 AUTH_MODE.NAME=Authentication mode
 AUTH_MODE.ITEM.SERVICEACCOUNT=Service account
+AUTH_MODE.ITEM.APPLICATION_DEFAULT_CREDENTIALS=Application Default Credentials
 AUTH_MODE.ITEM.OAUTH=OAuth 2.0
 AUTH_MODE.ITEM.TOKEN=OAuth Access Token
 CLIENT_ID.NAME=Client Id

main/plugins/org.talend.designer.components.localprovider/components/tBigQueryInput/tBigQueryInput_messages_fr.properties

@@ -4,6 +4,7 @@ AUTHENTICATION.NAME=Authentification
 SERVICE_ACCOUNT_CREDENTIALS_FILE.NAME=Fichier d'identifiants du compte de service
 AUTH_MODE.NAME=Mode d'authentification
 AUTH_MODE.ITEM.SERVICEACCOUNT=Compte de service
+AUTH_MODE.ITEM.APPLICATION_DEFAULT_CREDENTIALS=Identifiants par d\u00E9faut pour l'application
 AUTH_MODE.ITEM.OAUTH=OAuth 2.0
 AUTH_MODE.ITEM.TOKEN=Jeton d'acc\u00E8s OAuth
 CLIENT_ID.NAME=ID client

main/plugins/org.talend.designer.components.localprovider/components/tBigQueryInput/tBigQueryInput_messages_ja.properties

@@ -4,6 +4,7 @@ AUTHENTICATION.NAME=\u8A8D\u8A3C
 SERVICE_ACCOUNT_CREDENTIALS_FILE.NAME=\u30B5\u30FC\u30D3\u30B9\u30A2\u30AB\u30A6\u30F3\u30C8\u8A8D\u8A3C\u60C5\u5831\u30D5\u30A1\u30A4\u30EB
 AUTH_MODE.NAME=\u8A8D\u8A3C\u30E2\u30FC\u30C9
 AUTH_MODE.ITEM.SERVICEACCOUNT=\u30B5\u30FC\u30D3\u30B9\u30A2\u30AB\u30A6\u30F3\u30C8
+AUTH_MODE.ITEM.APPLICATION_DEFAULT_CREDENTIALS=\u30A2\u30D7\u30EA\u30B1\u30FC\u30B7\u30E7\u30F3\u306E\u30C7\u30D5\u30A9\u30EB\u30C8\u8A8D\u8A3C\u60C5\u5831
 AUTH_MODE.ITEM.OAUTH=OAuth2.0
 AUTH_MODE.ITEM.TOKEN=OAuth\u30A2\u30AF\u30BB\u30B9\u30C8\u30FC\u30AF\u30F3
 CLIENT_ID.NAME=\u30AF\u30E9\u30A4\u30A2\u30F3\u30C8ID

main/plugins/org.talend.designer.components.localprovider/components/tBigQueryInput/tBigQueryInput_messages_zh_CN.properties

@@ -4,6 +4,7 @@ AUTHENTICATION.NAME=\u8EAB\u4EFD\u9A8C\u8BC1
 SERVICE_ACCOUNT_CREDENTIALS_FILE.NAME=\u670D\u52A1\u5E10\u6237\u7528\u6237\u540D\u548C\u5BC6\u7801\u6587\u4EF6
 AUTH_MODE.NAME=\u8EAB\u4EFD\u9A8C\u8BC1\u6A21\u5F0F
 AUTH_MODE.ITEM.SERVICEACCOUNT=\u670D\u52A1\u5E10\u6237
+AUTH_MODE.ITEM.APPLICATION_DEFAULT_CREDENTIALS=\u5E94\u7528\u7A0B\u5E8F\u9ED8\u8BA4\u51ED\u636E
 AUTH_MODE.ITEM.OAUTH=OAuth 2.0
 AUTH_MODE.ITEM.TOKEN=OAuth \u8BBF\u95EE\u4EE4\u724C
 CLIENT_ID.NAME=\u5BA2\u6237\u7AEF ID

main/plugins/org.talend.designer.components.localprovider/components/tBigQueryOutput/tBigQueryOutput_java.xml

@@ -58,7 +58,8 @@
     <PARAMETER NAME="AUTH_MODE" FIELD="CLOSED_LIST" NUM_ROW="15" REQUIRED="true" GROUP="AUTHENTICATION" REPOSITORY_VALUE="AUTH_MODE">
 			<ITEMS DEFAULT="SERVICEACCOUNT">
 				<ITEM NAME="SERVICEACCOUNT" VALUE="SERVICEACCOUNT" />
-				<ITEM NAME="OAUTH" VALUE="OAUTH" />
+                <ITEM NAME="APPLICATION_DEFAULT_CREDENTIALS" VALUE="APPLICATION_DEFAULT_CREDENTIALS"/>
+                <ITEM NAME="OAUTH" VALUE="OAUTH" />
 				<ITEM NAME="TOKEN" VALUE="TOKEN" />
 			</ITEMS>
 	</PARAMETER>
@@ -186,6 +187,7 @@
       SHOW_IF="(BULK_FILE_ALREADY_EXIST=='false')">
       <ITEMS DEFAULT="GS_SERVICE_ACCOUNT">
         <ITEM NAME="GS_SERVICE_ACCOUNT" VALUE="GS_SERVICE_ACCOUNT"/>
+        <ITEM NAME="GS_APPLICATION_DEFAULT_CREDENTIALS" VALUE="GS_APPLICATION_DEFAULT_CREDENTIALS"/>
         <ITEM NAME="TOKEN" VALUE="TOKEN" />
       </ITEMS>
     </PARAMETER>
@@ -253,10 +255,10 @@
        NAME="USE_REGION_ENDPOINT" 
        FIELD="CHECK" 
        NUM_ROW="4" 
-       EQUIRED="true"  
+       EQUIRED="true"
        GROUP="REGION_ENDPOINT_GROUP"
        REPOSITORY_VALUE="USE_REGION_ENDPOINT"
-       SHOW_IF="(AUTH_MODE == 'SERVICEACCOUNT')" >
+       SHOW_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')" >
             <DEFAULT>false</DEFAULT>
     </PARAMETER>
     <PARAMETER  
@@ -265,7 +267,7 @@
        NUM_ROW="5" 
        REQUIRED="false" 
        GROUP="REGION_ENDPOINT_GROUP" 
-       SHOW_IF="(AUTH_MODE == 'SERVICEACCOUNT') AND (USE_REGION_ENDPOINT == 'true')" >
+       SHOW_IF="((AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')) AND (USE_REGION_ENDPOINT == 'true')" >
        <DEFAULT>"https://storage.googleapis.com"</DEFAULT>
     </PARAMETER>
     <PARAMETER  
@@ -275,7 +277,7 @@
        REQUIRED="false" 
        GROUP="REGION_ENDPOINT_GROUP"
        REPOSITORY_VALUE="REGION_ENDPOINT_BQ"
-       SHOW_IF="(AUTH_MODE == 'SERVICEACCOUNT') AND (USE_REGION_ENDPOINT == 'true')" >
+       SHOW_IF="((AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')) AND (USE_REGION_ENDPOINT == 'true')" >
        <DEFAULT>"https://bigquery.googleapis.com"</DEFAULT>
     </PARAMETER>
     <PARAMETER NAME="TOKEN_NAME" FIELD="FILE" NUM_ROW="8"
@@ -301,7 +303,7 @@
       <DEFAULT>","</DEFAULT>
     </PARAMETER>
 
-    <PARAMETER NAME="DROP" FIELD="CHECK" REQUIRED="true" NUM_ROW="33" SHOW_IF="AUTH_MODE == 'SERVICEACCOUNT'">
+    <PARAMETER NAME="DROP" FIELD="CHECK" REQUIRED="true" NUM_ROW="33" SHOW_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')">
       <DEFAULT>false</DEFAULT>
     </PARAMETER>
 

main/plugins/org.talend.designer.components.localprovider/components/tBigQueryOutput/tBigQueryOutput_messages.properties

@@ -19,6 +19,7 @@ AUTHENTICATION.NAME=Authentication
 SERVICE_ACCOUNT_CREDENTIALS_FILE.NAME=Service account credentials file
 AUTH_MODE.NAME=Authentication mode
 AUTH_MODE.ITEM.SERVICEACCOUNT=Service account
+AUTH_MODE.ITEM.APPLICATION_DEFAULT_CREDENTIALS=Application Default Credentials
 AUTH_MODE.ITEM.OAUTH=OAuth 2.0
 AUTH_MODE.ITEM.TOKEN=OAuth Access Token
 CLIENT_ID.NAME=Client Id
@@ -49,6 +50,7 @@ CHECK_DISK_SPACE.NAME=Check disk space
 DIE_ON_ERROR.NAME=Die on error
 AUTH_TYPE.NAME=Credential type
 AUTH_TYPE.ITEM.GS_SERVICE_ACCOUNT=Service account
+AUTH_TYPE.ITEM.GS_APPLICATION_DEFAULT_CREDENTIALS=Application Default Credentials
 AUTH_TYPE.ITEM.TOKEN=OAuth Access Token
 GS_SERVICE_ACCOUNT_KEY.NAME=Service account key
 GS_ACCESS_TOKEN.NAME=OAuth Access Token

main/plugins/org.talend.designer.components.localprovider/components/tBigQueryOutput/tBigQueryOutput_messages_fr.properties

@@ -19,6 +19,7 @@ AUTHENTICATION.NAME=Authentification
 SERVICE_ACCOUNT_CREDENTIALS_FILE.NAME=Fichier d'identifiants du compte de service
 AUTH_MODE.NAME=Mode d'authentification
 AUTH_MODE.ITEM.SERVICEACCOUNT=Compte de service
+AUTH_MODE.ITEM.APPLICATION_DEFAULT_CREDENTIALS=Identifiants par d\u00E9faut pour l'application
 AUTH_MODE.ITEM.OAUTH=OAuth 2.0
 AUTH_MODE.ITEM.TOKEN=Jeton d'acc\u00E8s OAuth
 CLIENT_ID.NAME=ID client
@@ -49,6 +50,7 @@ CHECK_DISK_SPACE.NAME=V\u00E9rifier l'espace disque
 DIE_ON_ERROR.NAME=Arr\u00EAter en cas d'erreur
 AUTH_TYPE.NAME=Type d'identifiant
 AUTH_TYPE.ITEM.GS_SERVICE_ACCOUNT=Compte de service
+AUTH_TYPE.ITEM.GS_APPLICATION_DEFAULT_CREDENTIALS=Identifiants par d\u00E9faut pour l'application
 AUTH_TYPE.ITEM.TOKEN=Jeton d'acc\u00E8s OAuth
 GS_SERVICE_ACCOUNT_KEY.NAME=Cl\u00E9 du compte de service
 GS_ACCESS_TOKEN.NAME=Jeton d'acc\u00E8s OAuth

main/plugins/org.talend.designer.components.localprovider/components/tBigQueryOutput/tBigQueryOutput_messages_ja.properties

@@ -19,6 +19,7 @@ AUTHENTICATION.NAME=\u8A8D\u8A3C
 SERVICE_ACCOUNT_CREDENTIALS_FILE.NAME=\u30B5\u30FC\u30D3\u30B9\u30A2\u30AB\u30A6\u30F3\u30C8\u8A8D\u8A3C\u60C5\u5831\u30D5\u30A1\u30A4\u30EB
 AUTH_MODE.NAME=\u8A8D\u8A3C\u30E2\u30FC\u30C9
 AUTH_MODE.ITEM.SERVICEACCOUNT=\u30B5\u30FC\u30D3\u30B9\u30A2\u30AB\u30A6\u30F3\u30C8
+AUTH_MODE.ITEM.APPLICATION_DEFAULT_CREDENTIALS=\u30A2\u30D7\u30EA\u30B1\u30FC\u30B7\u30E7\u30F3\u306E\u30C7\u30D5\u30A9\u30EB\u30C8\u8A8D\u8A3C\u60C5\u5831
 AUTH_MODE.ITEM.OAUTH=OAuth2.0
 AUTH_MODE.ITEM.TOKEN=OAuth\u30A2\u30AF\u30BB\u30B9\u30C8\u30FC\u30AF\u30F3
 CLIENT_ID.NAME=\u30AF\u30E9\u30A4\u30A2\u30F3\u30C8ID
@@ -49,6 +50,7 @@ CHECK_DISK_SPACE.NAME=\u30C7\u30A3\u30B9\u30AF\u5BB9\u91CF\u306E\u78BA\u8A8D
 DIE_ON_ERROR.NAME=\u30A8\u30E9\u30FC\u767A\u751F\u6642\u306B\u5F37\u5236\u7D42\u4E86
 AUTH_TYPE.NAME=\u8A8D\u8A3C\u60C5\u5831\u306E\u30BF\u30A4\u30D7
 AUTH_TYPE.ITEM.GS_SERVICE_ACCOUNT=\u30B5\u30FC\u30D3\u30B9\u30A2\u30AB\u30A6\u30F3\u30C8
+AUTH_TYPE.ITEM.GS_APPLICATION_DEFAULT_CREDENTIALS=\u30A2\u30D7\u30EA\u30B1\u30FC\u30B7\u30E7\u30F3\u306E\u30C7\u30D5\u30A9\u30EB\u30C8\u8A8D\u8A3C\u60C5\u5831
 AUTH_TYPE.ITEM.TOKEN=OAuth\u30A2\u30AF\u30BB\u30B9\u30C8\u30FC\u30AF\u30F3
 GS_SERVICE_ACCOUNT_KEY.NAME=\u30B5\u30FC\u30D3\u30B9\u30A2\u30AB\u30A6\u30F3\u30C8\u30AD\u30FC
 GS_ACCESS_TOKEN.NAME=OAuth\u30A2\u30AF\u30BB\u30B9\u30C8\u30FC\u30AF\u30F3

main/plugins/org.talend.designer.components.localprovider/components/tBigQueryOutput/tBigQueryOutput_messages_zh_CN.properties

@@ -19,6 +19,7 @@ AUTHENTICATION.NAME=\u8EAB\u4EFD\u9A8C\u8BC1
 SERVICE_ACCOUNT_CREDENTIALS_FILE.NAME=\u670D\u52A1\u5E10\u6237\u7528\u6237\u540D\u548C\u5BC6\u7801\u6587\u4EF6
 AUTH_MODE.NAME=\u8EAB\u4EFD\u9A8C\u8BC1\u6A21\u5F0F
 AUTH_MODE.ITEM.SERVICEACCOUNT=\u670D\u52A1\u5E10\u6237
+AUTH_MODE.ITEM.APPLICATION_DEFAULT_CREDENTIALS=\u5E94\u7528\u7A0B\u5E8F\u9ED8\u8BA4\u51ED\u636E
 AUTH_MODE.ITEM.OAUTH=OAuth 2.0
 AUTH_MODE.ITEM.TOKEN=OAuth \u8BBF\u95EE\u4EE4\u724C
 CLIENT_ID.NAME=\u5BA2\u6237\u7AEF ID
@@ -49,6 +50,7 @@ CHECK_DISK_SPACE.NAME=\u68C0\u67E5\u78C1\u76D8\u7A7A\u95F4
 DIE_ON_ERROR.NAME=\u9519\u8BEF\u65F6\u7EC8\u6B62
 AUTH_TYPE.NAME=\u51ED\u8BC1\u7C7B\u578B
 AUTH_TYPE.ITEM.GS_SERVICE_ACCOUNT=\u670D\u52A1\u5E10\u6237
+AUTH_TYPE.ITEM.GS_APPLICATION_DEFAULT_CREDENTIALS=\u5E94\u7528\u7A0B\u5E8F\u9ED8\u8BA4\u51ED\u636E
 AUTH_TYPE.ITEM.TOKEN=OAuth \u8BBF\u95EE\u4EE4\u724C
 GS_SERVICE_ACCOUNT_KEY.NAME=\u670D\u52A1\u5E10\u6237\u5BC6\u94A5
 GS_ACCESS_TOKEN.NAME=OAuth \u8BBF\u95EE\u4EE4\u724C

main/plugins/org.talend.designer.components.localprovider/components/tBigQuerySQLRow/tBigQuerySQLRow_begin.javajet

@@ -179,13 +179,17 @@ globalMap.put("<%=cid%>_ERROR_MESSAGE",ee.getMessage());
 
 		BigQueryUtil_<%=cid%> bigQueryUtil_<%=cid%> = new BigQueryUtil_<%=cid%>(PROJECT_ID_<%=cid%>, bigqueryclient_<%=cid%>,  <% if (authMode.equals("OAUTH")) { %> tokenFile_<%=cid%> <% } else { %> null <%}%>);
 	<%
-	} else if (authMode.equals("SERVICEACCOUNT")) {
+	} else if (authMode.equals("SERVICEACCOUNT") || authMode.equals("APPLICATION_DEFAULT_CREDENTIALS")) {
 	%>
 		com.google.auth.oauth2.GoogleCredentials credentials_<%=cid%>;
+		<% if(authMode.equals("APPLICATION_DEFAULT_CREDENTIALS")) { %>
+            credentials_<%=cid%> = com.google.auth.oauth2.GoogleCredentials.getApplicationDefault();
+        <% } else { %>
 		java.io.File credentialsFile_<%=cid%> = new java.io.File(<%=credentialsFile%>);
 		try(java.io.FileInputStream credentialsStream_<%=cid%> = new java.io.FileInputStream(credentialsFile_<%=cid%>)) {
 		    credentials_<%=cid%> = com.google.auth.oauth2.ServiceAccountCredentials.fromStream(credentialsStream_<%=cid%>);
 		}
+		<% } %>
 
 		com.google.cloud.bigquery.BigQueryOptions.Builder bigQueryOptionsBuilder_<%=cid%> = com.google.cloud.bigquery.BigQueryOptions.newBuilder().setCredentials(credentials_<%=cid%>).setProjectId(<%=projectId%>);
 		<% if( "true".equals(ElementParameterParser.getValue(node, "__USE_REGION_ENDPOINT__")) ){ %>
@@ -195,6 +199,6 @@ globalMap.put("<%=cid%>_ERROR_MESSAGE",ee.getMessage());
 
 	<%
 	} else {
-		throw new IllegalArgumentException("authentication mode should be either \"SERVICEACCOUNT\" or \"OAUTH\", but it is " + authMode);
+		throw new IllegalArgumentException("authentication mode should be either \"SERVICEACCOUNT\", \"APPLICATION_DEFAULT_CREDENTIALS\" or \"OAUTH\", but it is " + authMode);
 	}
 		%>

main/plugins/org.talend.designer.components.localprovider/components/tBigQuerySQLRow/tBigQuerySQLRow_java.xml

@@ -50,6 +50,7 @@
                    REPOSITORY_VALUE="AUTH_MODE">
             <ITEMS DEFAULT="SERVICEACCOUNT">
                 <ITEM NAME="SERVICEACCOUNT" VALUE="SERVICEACCOUNT"/>
+                <ITEM NAME="APPLICATION_DEFAULT_CREDENTIALS" VALUE="APPLICATION_DEFAULT_CREDENTIALS"/>
                 <ITEM NAME="OAUTH" VALUE="OAUTH"/>
         				<ITEM NAME="TOKEN" VALUE="TOKEN" />
         			</ITEMS>
@@ -156,7 +157,7 @@
 					NUM_ROW="4" 
 					EQUIRED="true"	
 					GROUP="REGION_ENDPOINT_GROUP" REPOSITORY_VALUE="USE_REGION_ENDPOINT"
-					SHOW_IF="(AUTH_MODE == 'SERVICEACCOUNT')" >
+					SHOW_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')" >
 			<DEFAULT>false</DEFAULT>
 		</PARAMETER>
 		<PARAMETER 	NAME="REGION_ENDPOINT_BQ" 
@@ -164,7 +165,7 @@
 					NUM_ROW="6" 
 					REQUIRED="false" 
 					GROUP="REGION_ENDPOINT_GROUP" REPOSITORY_VALUE="REGION_ENDPOINT_BQ"
-					SHOW_IF="(AUTH_MODE == 'SERVICEACCOUNT') AND (USE_REGION_ENDPOINT == 'true')" >
+					SHOW_IF="((AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')) AND (USE_REGION_ENDPOINT == 'true')" >
 		  <DEFAULT>"https://bigquery.googleapis.com"</DEFAULT>
 		</PARAMETER>
 		
@@ -226,25 +227,25 @@
             <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.14.3.jar" MODULE="jackson-core-2.14.3.jar" MVN="mvn:com.fasterxml.jackson.core/jackson-core/2.14.3" 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'"/>
+            <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') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')"/>
 
             <!-- TODO remove it -->
-            <IMPORT NAME="google-http-client-jackson-1.25.0.jar" MODULE="google-http-client-jackson-1.25.0.jar" MVN="mvn:com.google.http-client/google-http-client-jackson/1.25.0" REQUIRED_IF="AUTH_MODE == 'SERVICEACCOUNT'"/>
+            <IMPORT NAME="google-http-client-jackson-1.25.0.jar" MODULE="google-http-client-jackson-1.25.0.jar" MVN="mvn:com.google.http-client/google-http-client-jackson/1.25.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')"/>
 
-            <IMPORT NAME="threetenbp-1.3.3.jar" MODULE="threetenbp-1.3.3.jar" MVN="mvn:org.threeten/threetenbp/1.3.3" REQUIRED_IF="AUTH_MODE == 'SERVICEACCOUNT'"/>
-            <IMPORT NAME="google-auth-library-credentials-0.20.0.jar" MODULE="google-auth-library-credentials-0.20.0.jar" MVN="mvn:com.google.auth/google-auth-library-credentials/0.20.0" REQUIRED_IF="AUTH_MODE == 'SERVICEACCOUNT'"/>
-            <IMPORT NAME="gax-httpjson-0.44.0.jar" MODULE="gax-httpjson-0.44.0.jar" MVN="mvn:com.google.api/gax-httpjson/0.44.0" REQUIRED_IF="AUTH_MODE == 'SERVICEACCOUNT'"/>
-            <IMPORT NAME="jackson-core-asl-1.9.13.jar" MODULE="jackson-core-asl-1.9.13.jar" MVN="mvn:org.codehaus.jackson/jackson-core-asl/1.9.13" REQUIRED_IF="AUTH_MODE == 'SERVICEACCOUNT'"/>
-            <IMPORT NAME="google-auth-library-oauth2-http-0.20.0.jar" MODULE="google-auth-library-oauth2-http-0.20.0.jar" MVN="mvn:com.google.auth/google-auth-library-oauth2-http/0.20.0" REQUIRED_IF="AUTH_MODE == 'SERVICEACCOUNT'"/>
-            <IMPORT NAME="google-cloud-core-1.93.4.jar" MODULE="google-cloud-core-1.93.4.jar" MVN="mvn:com.google.cloud/google-cloud-core/1.93.4" REQUIRED_IF="AUTH_MODE == 'SERVICEACCOUNT'"/>
-            <IMPORT NAME="google-cloud-core-http-1.32.0.jar" MODULE="google-cloud-core-http-1.32.0.jar" MVN="mvn:com.google.cloud/google-cloud-core-http/1.32.0" REQUIRED_IF="AUTH_MODE == 'SERVICEACCOUNT'"/>
-            <IMPORT NAME="gax-1.27.0.jar" MODULE="gax-1.27.0.jar" MVN="mvn:com.google.api/gax/1.27.0" REQUIRED_IF="AUTH_MODE == 'SERVICEACCOUNT'"/>
-            <IMPORT NAME="google-http-client-appengine-1.38.0.jar" MODULE="google-http-client-appengine-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client-appengine/1.38.0" REQUIRED_IF="AUTH_MODE == 'SERVICEACCOUNT'"/>
-            <IMPORT NAME="api-common-1.6.0.jar" MODULE="api-common-1.6.0.jar" MVN="mvn:com.google.api/api-common/1.6.0" REQUIRED_IF="AUTH_MODE == 'SERVICEACCOUNT'"/>
+            <IMPORT NAME="threetenbp-1.3.3.jar" MODULE="threetenbp-1.3.3.jar" MVN="mvn:org.threeten/threetenbp/1.3.3" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')"/>
+            <IMPORT NAME="google-auth-library-credentials-0.20.0.jar" MODULE="google-auth-library-credentials-0.20.0.jar" MVN="mvn:com.google.auth/google-auth-library-credentials/0.20.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')"/>
+            <IMPORT NAME="gax-httpjson-0.44.0.jar" MODULE="gax-httpjson-0.44.0.jar" MVN="mvn:com.google.api/gax-httpjson/0.44.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')"/>
+            <IMPORT NAME="jackson-core-asl-1.9.13.jar" MODULE="jackson-core-asl-1.9.13.jar" MVN="mvn:org.codehaus.jackson/jackson-core-asl/1.9.13" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')"/>
+            <IMPORT NAME="google-auth-library-oauth2-http-0.20.0.jar" MODULE="google-auth-library-oauth2-http-0.20.0.jar" MVN="mvn:com.google.auth/google-auth-library-oauth2-http/0.20.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')"/>
+            <IMPORT NAME="google-cloud-core-1.93.4.jar" MODULE="google-cloud-core-1.93.4.jar" MVN="mvn:com.google.cloud/google-cloud-core/1.93.4" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')"/>
+            <IMPORT NAME="google-cloud-core-http-1.32.0.jar" MODULE="google-cloud-core-http-1.32.0.jar" MVN="mvn:com.google.cloud/google-cloud-core-http/1.32.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')"/>
+            <IMPORT NAME="gax-1.27.0.jar" MODULE="gax-1.27.0.jar" MVN="mvn:com.google.api/gax/1.27.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')"/>
+            <IMPORT NAME="google-http-client-appengine-1.38.0.jar" MODULE="google-http-client-appengine-1.38.0.jar" MVN="mvn:com.google.http-client/google-http-client-appengine/1.38.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')"/>
+            <IMPORT NAME="api-common-1.6.0.jar" MODULE="api-common-1.6.0.jar" MVN="mvn:com.google.api/api-common/1.6.0" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')"/>
             <IMPORT NAME="opencensus-api-0.24.0" MODULE="opencensus-api-0.24.0.jar" MVN="mvn:io.opencensus/opencensus-api/0.24.0" REQUIRED="true" />
             <IMPORT NAME="opencensus-contrib-http-util-0.24.0" MODULE="opencensus-contrib-http-util-0.24.0.jar" MVN="mvn:io.opencensus/opencensus-contrib-http-util/0.24.0" REQUIRED="true" />
             <IMPORT NAME="grpc-context-1.22.1" MODULE="grpc-context-1.22.1.jar" MVN="mvn:io.grpc/grpc-context/1.22.1" REQUIRED="true" />
-            <IMPORT NAME="gson-2.8.9" MODULE="gson-2.8.9.jar" MVN="mvn:com.google.code.gson/gson/2.8.9" REQUIRED_IF="AUTH_MODE == 'SERVICEACCOUNT'" />
+            <IMPORT NAME="gson-2.8.9" MODULE="gson-2.8.9.jar" MVN="mvn:com.google.code.gson/gson/2.8.9" REQUIRED_IF="(AUTH_MODE == 'SERVICEACCOUNT') OR (AUTH_MODE == 'APPLICATION_DEFAULT_CREDENTIALS')" />
         </IMPORTS>
     </CODEGENERATION>
     <RETURNS>

main/plugins/org.talend.designer.components.localprovider/components/tBigQuerySQLRow/tBigQuerySQLRow_main.javajet

@@ -78,7 +78,7 @@
                 insert_jobs_<%=cid%> = java.util.Collections.singletonList(insert_<%=cid%>);
             }
 	<%
-	} else if (authMode.equals("SERVICEACCOUNT")) {
+	} else if (authMode.equals("SERVICEACCOUNT") || authMode.equals("APPLICATION_DEFAULT_CREDENTIALS")) {
 	%>
 		com.google.cloud.bigquery.QueryJobConfiguration queryConfiguration_<%=cid%> = com.google.cloud.bigquery.QueryJobConfiguration.newBuilder(<%=query%>).setUseLegacySql(<%=useLegacySql%>).build();
 		com.google.cloud.bigquery.JobId jobId_<%=cid%> = com.google.cloud.bigquery.JobId.of(java.util.UUID.randomUUID().toString());
@@ -143,7 +143,7 @@
 		%>
 	<%
 	} else {
-		throw new IllegalArgumentException("authentication mode should be either \"SERVICEACCOUNT\", \"OAUTH\" or \"TOKEN\", but it is " + authMode);
+		throw new IllegalArgumentException("authentication mode should be either \"SERVICEACCOUNT\", \"APPLICATION_DEFAULT_CREDENTIALS\", \"OAUTH\" or \"TOKEN\", but it is " + authMode);
 	}
 
 		List< ? extends IConnection> conns = node.getOutgoingSortedConnections();
@@ -184,7 +184,7 @@
 								Object value_<%=cid%> = null;
 								nb_line_<%=cid%> ++;
 						<%
-					} else if (authMode.equals("SERVICEACCOUNT")) {
+					} else if (authMode.equals("SERVICEACCOUNT") || authMode.equals("APPLICATION_DEFAULT_CREDENTIALS")) {
 						%>
                         long nb_line_<%=cid%> = 0;
                         for (com.google.cloud.bigquery.Job job_iterable_<%=cid%> : childJobs_<%=cid%>) {
@@ -202,7 +202,7 @@
                                 nb_line_<%=cid%> ++;
 					<%
 					} else {
-						throw new IllegalArgumentException("authentication mode should be either \"SERVICEACCOUNT\", \"OAUTH\" or \"TOKEN\", but it is " + authMode);
+						throw new IllegalArgumentException("authentication mode should be either \"SERVICEACCOUNT\", \"APPLICATION_DEFAULT_CREDENTIALS\", \"OAUTH\" or \"TOKEN\", but it is " + authMode);
 					}
 
 					List<IMetadataTable> metadatas = node.getMetadataList();
@@ -228,12 +228,12 @@
 								%>
 								value_<%=cid%> = field_<%=cid %>.get(<%=i%>).getV();
 								<%
-								} else if (authMode.equals("SERVICEACCOUNT")) {
+								} else if (authMode.equals("SERVICEACCOUNT") || authMode.equals("APPLICATION_DEFAULT_CREDENTIALS")) {
 								%>
 								value_<%=cid%> = field_<%=cid %>.get(<%=i%>).getValue();
 								<%
 								} else {
-									throw new IllegalArgumentException("authentication mode should be either \"SERVICEACCOUNT\", \"OAUTH\" or \"TOKEN\", but it is " + authMode);
+									throw new IllegalArgumentException("authentication mode should be either \"SERVICEACCOUNT\", \"APPLICATION_DEFAULT_CREDENTIALS\", \"OAUTH\" or \"TOKEN\", but it is " + authMode);
 								}
 								%>
 								if(com.google.api.client.util.Data.isNull(value_<%=cid%>)) value_<%=cid%> = null;

main/plugins/org.talend.designer.components.localprovider/components/tBigQuerySQLRow/tBigQuerySQLRow_messages.properties

@@ -4,6 +4,7 @@ AUTHENTICATION.NAME=Authentication
 SERVICE_ACCOUNT_CREDENTIALS_FILE.NAME=Service account credentials file
 AUTH_MODE.NAME=Authentication mode
 AUTH_MODE.ITEM.SERVICEACCOUNT=Service account
+AUTH_MODE.ITEM.APPLICATION_DEFAULT_CREDENTIALS=Application Default Credentials
 AUTH_MODE.ITEM.OAUTH=OAuth 2.0
 AUTH_MODE.ITEM.TOKEN=OAuth Access Token
 CLIENT_ID.NAME=Client Id

main/plugins/org.talend.designer.components.localprovider/components/tBigQuerySQLRow/tBigQuerySQLRow_messages_fr.properties

@@ -4,6 +4,7 @@ AUTHENTICATION.NAME=Authentification
 SERVICE_ACCOUNT_CREDENTIALS_FILE.NAME=Fichier d'identifiants du compte de service
 AUTH_MODE.NAME=Mode d'authentification
 AUTH_MODE.ITEM.SERVICEACCOUNT=Compte de service
+AUTH_MODE.ITEM.APPLICATION_DEFAULT_CREDENTIALS=Identifiants par d\u00E9faut pour l'application
 AUTH_MODE.ITEM.OAUTH=OAuth 2.0
 AUTH_MODE.ITEM.TOKEN=Jeton d'acc\u00E8s OAuth
 CLIENT_ID.NAME=ID client

main/plugins/org.talend.designer.components.localprovider/components/tBigQuerySQLRow/tBigQuerySQLRow_messages_ja.properties

@@ -4,6 +4,7 @@ AUTHENTICATION.NAME=\u8A8D\u8A3C
 SERVICE_ACCOUNT_CREDENTIALS_FILE.NAME=\u30B5\u30FC\u30D3\u30B9\u30A2\u30AB\u30A6\u30F3\u30C8\u8A8D\u8A3C\u60C5\u5831\u30D5\u30A1\u30A4\u30EB
 AUTH_MODE.NAME=\u8A8D\u8A3C\u30E2\u30FC\u30C9
 AUTH_MODE.ITEM.SERVICEACCOUNT=\u30B5\u30FC\u30D3\u30B9\u30A2\u30AB\u30A6\u30F3\u30C8
+AUTH_MODE.ITEM.APPLICATION_DEFAULT_CREDENTIALS=\u30A2\u30D7\u30EA\u30B1\u30FC\u30B7\u30E7\u30F3\u306E\u30C7\u30D5\u30A9\u30EB\u30C8\u8A8D\u8A3C\u60C5\u5831
 AUTH_MODE.ITEM.OAUTH=OAuth2.0
 AUTH_MODE.ITEM.TOKEN=OAuth\u30A2\u30AF\u30BB\u30B9\u30C8\u30FC\u30AF\u30F3
 CLIENT_ID.NAME=\u30AF\u30E9\u30A4\u30A2\u30F3\u30C8ID

main/plugins/org.talend.designer.components.localprovider/components/tBigQuerySQLRow/tBigQuerySQLRow_messages_zh_CN.properties

@@ -4,6 +4,7 @@ AUTHENTICATION.NAME=\u8EAB\u4EFD\u9A8C\u8BC1
 SERVICE_ACCOUNT_CREDENTIALS_FILE.NAME=\u670D\u52A1\u5E10\u6237\u7528\u6237\u540D\u548C\u5BC6\u7801\u6587\u4EF6
 AUTH_MODE.NAME=\u8EAB\u4EFD\u9A8C\u8BC1\u6A21\u5F0F
 AUTH_MODE.ITEM.SERVICEACCOUNT=\u670D\u52A1\u5E10\u6237
+AUTH_MODE.ITEM.APPLICATION_DEFAULT_CREDENTIALS=\u5E94\u7528\u7A0B\u5E8F\u9ED8\u8BA4\u51ED\u636E
 AUTH_MODE.ITEM.OAUTH=OAuth 2.0
 AUTH_MODE.ITEM.TOKEN=OAuth \u8BBF\u95EE\u4EE4\u724C
 CLIENT_ID.NAME=\u5BA2\u6237\u7AEF ID

main/plugins/org.talend.designer.components.localprovider/components/tBigQuerySQLRow/tBigQuerySQLRow_process_data_end.javajet

@@ -31,20 +31,20 @@ imports="
                 }
             }
                 <%
-                } else if (authMode.equals("SERVICEACCOUNT")) {
+                } else if (authMode.equals("SERVICEACCOUNT") || authMode.equals("APPLICATION_DEFAULT_CREDENTIALS")) {
                 %>
                     }
                 }
 
                 <%
                 } else {
-                    throw new IllegalArgumentException("authentication mode should be either \"SERVICEACCOUNT\" or \"OAUTH\"or \"TOKEN\", but it is " + authMode);
+                    throw new IllegalArgumentException("authentication mode should be either \"SERVICEACCOUNT\", \"APPLICATION_DEFAULT_CREDENTIALS\" or \"OAUTH\"or \"TOKEN\", but it is " + authMode);
                 }
                 log4jFileUtil.retrievedDataNumberInfo(node);
             }
         }
     }
-                if (authMode.equals("SERVICEACCOUNT")) {
+                if (authMode.equals("SERVICEACCOUNT") || authMode.equals("APPLICATION_DEFAULT_CREDENTIALS")) {
                     %>
                             if (job_<%=cid%>.getStatistics().getNumChildJobs() != null) {
                                 globalMap.put("<%=cid%>_STATISTICS_CHILD", childJobs_<%=cid%>.stream()

main/plugins/org.talend.designer.components.localprovider/components/tBonitaDeploy/tBonitaDeploy_java.xml

@@ -119,8 +119,8 @@
 
 			<!-- Bonita 6.5.2 HTTP API -->
 			<IMPORT NAME="talend-bonita-client-1.0.1.jar" MODULE="talend-bonita-client-1.0.1.jar" MVN="mvn:org.talend.bonita/talend-bonita-client/1.0.1" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='HTTP_CLIENT')" />
-			<IMPORT NAME="bonita-client-6.5.2.jar" MODULE="bonita-client-6.5.2.jar" MVN="mvn:org.talend.libraries/bonita-client-6.5.2/6.0.0" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='HTTP_CLIENT')" />
-			<IMPORT NAME="bonita-common-6.5.2.jar" MODULE="bonita-common-6.5.2.jar" MVN="mvn:org.talend.libraries/bonita-common-6.5.2/6.0.0" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='HTTP_CLIENT')" />
+			<IMPORT NAME="bonita-client-6.5.2.jar" MODULE="bonita-client-6.5.2.jar" MVN="mvn:org.bonitasoft.engine/bonita-client/6.5.2" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='HTTP_CLIENT')" />
+			<IMPORT NAME="bonita-common-6.5.2.jar" MODULE="bonita-common-6.5.2.jar" MVN="mvn:org.bonitasoft.engine/bonita-common/6.5.2" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='HTTP_CLIENT')" />
 			
 			<IMPORT NAME="httpmime-4.2.5.jar" MODULE="httpmime-4.2.5.jar" MVN="mvn:org.apache.httpcomponents/httpmime/4.2.5" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='HTTP_CLIENT')" />
 			<IMPORT NAME="httpclient-4.5.13.jar" MODULE="httpclient-4.5.13.jar" MVN="mvn:org.apache.httpcomponents/httpclient/4.5.13" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='HTTP_CLIENT')" />
@@ -130,10 +130,10 @@
 			
 			<!-- Bonita 6.5.2 JAVA API -->
 			<IMPORT NAME="talend-bonita-client-1.0.1.jar" MODULE="talend-bonita-client-1.0.1.jar" MVN="mvn:org.talend.bonita/talend-bonita-client/1.0.1" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='JAVA_CLIENT')" />
-			<IMPORT NAME="bonita-client-6.5.2.jar" MODULE="bonita-client-6.5.2.jar" MVN="mvn:org.talend.libraries/bonita-client-6.5.2/6.0.0" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='JAVA_CLIENT')" />
-			<IMPORT NAME="bonita-common-6.5.2.jar" MODULE="bonita-common-6.5.2.jar" MVN="mvn:org.talend.libraries/bonita-common-6.5.2/6.0.0" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='JAVA_CLIENT')" />
-			<IMPORT NAME="bonita-server-6.5.2.jar" MODULE="bonita-server-6.5.2.jar" MVN="mvn:org.talend.libraries/bonita-server-6.5.2/6.0.0" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='JAVA_CLIENT')" />
-			<IMPORT NAME="xpp3-1.1.6.jar" MODULE="xpp3-1.1.6.jar" MVN="mvn:org.talend.libraries/xpp3-1.1.6/6.0.0" UrlPath="platform:/plugin/org.talend.libraries.xml/lib/xpp3-1.1.6.jar" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='JAVA_CLIENT')" />
+			<IMPORT NAME="bonita-client-6.5.2.jar" MODULE="bonita-client-6.5.2.jar" MVN="mvn:org.bonitasoft.engine/bonita-client/6.5.2" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='JAVA_CLIENT')" />
+			<IMPORT NAME="bonita-common-6.5.2.jar" MODULE="bonita-common-6.5.2.jar" MVN="mvn:org.bonitasoft.engine/bonita-common/6.5.2" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='JAVA_CLIENT')" />
+			<IMPORT NAME="bonita-server-6.5.2.jar" MODULE="bonita-server-6.5.2.jar" MVN="mvn:org.bonitasoft.engine/bonita-server/6.5.2" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='JAVA_CLIENT')" />
+			<IMPORT NAME="xpp3-1.1.6.jar" MODULE="xpp3-1.1.6.jar" MVN="mvn:org.ogce/xpp3/1.1.6" UrlPath="platform:/plugin/org.talend.libraries.xml/lib/xpp3-1.1.6.jar" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='JAVA_CLIENT')" />
 			
 			<IMPORT NAME="httpmime-4.2.5.jar" MODULE="httpmime-4.2.5.jar" MVN="mvn:org.apache.httpcomponents/httpmime/4.2.5" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='JAVA_CLIENT')" />
 			<IMPORT NAME="httpclient-4.5.13.jar" MODULE="httpclient-4.5.13.jar" MVN="mvn:org.apache.httpcomponents/httpclient/4.5.13" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='JAVA_CLIENT')" />
@@ -144,7 +144,7 @@
 			<!-- Bonita 7.2.4 HTTP API -->
 			<IMPORT NAME="talend-bonita-client-1.0.1.jar" MODULE="talend-bonita-client-1.0.1.jar" MVN="mvn:org.talend.bonita/talend-bonita-client/1.0.1" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='HTTP_CLIENT')" />
 			<IMPORT NAME="bonita-client-7.2.4.jar" MODULE="bonita-client-7.2.4.jar" MVN="mvn:org.talend.libraries/bonita-client-7.2.4/6.3.0" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='HTTP_CLIENT')" />
-			<IMPORT NAME="bonita-common-7.2.4.jar" MODULE="bonita-common-7.2.4.jar" MVN="mvn:org.talend.libraries/bonita-common-7.2.4/6.3.0" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='HTTP_CLIENT')" />
+			<IMPORT NAME="bonita-common-7.2.4.jar" MODULE="bonita-common-7.2.4.jar" MVN="mvn:org.bonitasoft.engine/bonita-common/7.2.4" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='HTTP_CLIENT')" />
 			
 			<IMPORT NAME="httpmime-4.2.5.jar" MODULE="httpmime-4.2.5.jar" MVN="mvn:org.apache.httpcomponents/httpmime/4.2.5" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='HTTP_CLIENT')" />
 			<IMPORT NAME="httpclient-4.5.13.jar" MODULE="httpclient-4.5.13.jar" MVN="mvn:org.apache.httpcomponents/httpclient/4.5.13" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='HTTP_CLIENT')" />
@@ -155,9 +155,9 @@
 			<!-- Bonita 7.2.4 JAVA API -->
 			<IMPORT NAME="talend-bonita-client-1.0.1.jar" MODULE="talend-bonita-client-1.0.1.jar" MVN="mvn:org.talend.bonita/talend-bonita-client/1.0.1" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='JAVA_CLIENT')" />
 			<IMPORT NAME="bonita-client-7.2.4.jar" MODULE="bonita-client-7.2.4.jar" MVN="mvn:org.talend.libraries/bonita-client-7.2.4/6.3.0" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='JAVA_CLIENT')" />
-			<IMPORT NAME="bonita-common-7.2.4.jar" MODULE="bonita-common-7.2.4.jar" MVN="mvn:org.talend.libraries/bonita-common-7.2.4/6.3.0" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='JAVA_CLIENT')" />
+			<IMPORT NAME="bonita-common-7.2.4.jar" MODULE="bonita-common-7.2.4.jar" MVN="mvn:org.bonitasoft.engine/bonita-common/7.2.4" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='JAVA_CLIENT')" />
 			<IMPORT NAME="bonita-server-7.2.4.jar" MODULE="bonita-server-7.2.4.jar" MVN="mvn:org.talend.libraries/bonita-server-7.2.4/6.3.0" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='JAVA_CLIENT')" />
-			<IMPORT NAME="xpp3-1.1.6.jar" MODULE="xpp3-1.1.6.jar" MVN="mvn:org.talend.libraries/xpp3-1.1.6/6.0.0" UrlPath="platform:/plugin/org.talend.libraries.xml/lib/xpp3-1.1.6.jar" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='JAVA_CLIENT')" />
+			<IMPORT NAME="xpp3-1.1.6.jar" MODULE="xpp3-1.1.6.jar" MVN="mvn:org.ogce/xpp3/1.1.6" UrlPath="platform:/plugin/org.talend.libraries.xml/lib/xpp3-1.1.6.jar" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='JAVA_CLIENT')" />
 			
 			<IMPORT NAME="httpmime-4.2.5.jar" MODULE="httpmime-4.2.5.jar" MVN="mvn:org.apache.httpcomponents/httpmime/4.2.5" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='JAVA_CLIENT')" />
 			<IMPORT NAME="httpclient-4.5.13.jar" MODULE="httpclient-4.5.13.jar" MVN="mvn:org.apache.httpcomponents/httpclient/4.5.13" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='JAVA_CLIENT')" />

main/plugins/org.talend.designer.components.localprovider/components/tBonitaInstantiateProcess/tBonitaInstantiateProcess_java.xml

@@ -158,8 +158,8 @@
 
 			<!-- Bonita 6.5.2 HTTP API -->
 			<IMPORT NAME="talend-bonita-client-1.0.1.jar" MODULE="talend-bonita-client-1.0.1.jar" MVN="mvn:org.talend.bonita/talend-bonita-client/1.0.1" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='HTTP_CLIENT')" />
-			<IMPORT NAME="bonita-client-6.5.2.jar" MODULE="bonita-client-6.5.2.jar" MVN="mvn:org.talend.libraries/bonita-client-6.5.2/6.0.0" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='HTTP_CLIENT')" />
-			<IMPORT NAME="bonita-common-6.5.2.jar" MODULE="bonita-common-6.5.2.jar" MVN="mvn:org.talend.libraries/bonita-common-6.5.2/6.0.0" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='HTTP_CLIENT')" />
+			<IMPORT NAME="bonita-client-6.5.2.jar" MODULE="bonita-client-6.5.2.jar" MVN="mvn:org.bonitasoft.engine/bonita-client/6.5.2" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='HTTP_CLIENT')" />
+			<IMPORT NAME="bonita-common-6.5.2.jar" MODULE="bonita-common-6.5.2.jar" MVN="mvn:org.bonitasoft.engine/bonita-common/6.5.2" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='HTTP_CLIENT')" />
 			
 			<IMPORT NAME="httpmime-4.2.5.jar" MODULE="httpmime-4.2.5.jar" MVN="mvn:org.apache.httpcomponents/httpmime/4.2.5" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='HTTP_CLIENT')" />
 			<IMPORT NAME="httpclient-4.5.13.jar" MODULE="httpclient-4.5.13.jar" MVN="mvn:org.apache.httpcomponents/httpclient/4.5.13" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='HTTP_CLIENT')" />
@@ -170,10 +170,10 @@
 			
 			<!-- Bonita 6.5.2 JAVA API -->
 			<IMPORT NAME="talend-bonita-client-1.0.1.jar" MODULE="talend-bonita-client-1.0.1.jar" MVN="mvn:org.talend.bonita/talend-bonita-client/1.0.1" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='JAVA_CLIENT')" />
-			<IMPORT NAME="bonita-client-6.5.2.jar" MODULE="bonita-client-6.5.2.jar" MVN="mvn:org.talend.libraries/bonita-client-6.5.2/6.0.0" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='JAVA_CLIENT')" />
-			<IMPORT NAME="bonita-common-6.5.2.jar" MODULE="bonita-common-6.5.2.jar" MVN="mvn:org.talend.libraries/bonita-common-6.5.2/6.0.0" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='JAVA_CLIENT')" />
-			<IMPORT NAME="bonita-server-6.5.2.jar" MODULE="bonita-server-6.5.2.jar" MVN="mvn:org.talend.libraries/bonita-server-6.5.2/6.0.0" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='JAVA_CLIENT')" />
-			<IMPORT NAME="xpp3-1.1.6.jar" MODULE="xpp3-1.1.6.jar" MVN="mvn:org.talend.libraries/xpp3-1.1.6/6.0.0" UrlPath="platform:/plugin/org.talend.libraries.xml/lib/xpp3-1.1.6.jar" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='JAVA_CLIENT')" />
+			<IMPORT NAME="bonita-client-6.5.2.jar" MODULE="bonita-client-6.5.2.jar" MVN="mvn:org.bonitasoft.engine/bonita-client/6.5.2" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='JAVA_CLIENT')" />
+			<IMPORT NAME="bonita-common-6.5.2.jar" MODULE="bonita-common-6.5.2.jar" MVN="mvn:org.bonitasoft.engine/bonita-common/6.5.2" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='JAVA_CLIENT')" />
+			<IMPORT NAME="bonita-server-6.5.2.jar" MODULE="bonita-server-6.5.2.jar" MVN="mvn:org.bonitasoft.engine/bonita-server/6.5.2" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='JAVA_CLIENT')" />
+			<IMPORT NAME="xpp3-1.1.6.jar" MODULE="xpp3-1.1.6.jar" MVN="mvn:org.ogce/xpp3/1.1.6" UrlPath="platform:/plugin/org.talend.libraries.xml/lib/xpp3-1.1.6.jar" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='JAVA_CLIENT')" />
 			
 			<IMPORT NAME="httpmime-4.2.5.jar" MODULE="httpmime-4.2.5.jar" MVN="mvn:org.apache.httpcomponents/httpmime/4.2.5" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='JAVA_CLIENT')" />
 			<IMPORT NAME="httpclient-4.5.13.jar" MODULE="httpclient-4.5.13.jar" MVN="mvn:org.apache.httpcomponents/httpclient/4.5.13" REQUIRED_IF="(DB_VERSION=='BONITA_652') AND (CLIENT_MODE=='JAVA_CLIENT')" />
@@ -184,7 +184,7 @@
 			<!-- Bonita 7.2.4 HTTP API -->
 			<IMPORT NAME="talend-bonita-client-1.0.1.jar" MODULE="talend-bonita-client-1.0.1.jar" MVN="mvn:org.talend.bonita/talend-bonita-client/1.0.1" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='HTTP_CLIENT')" />
 			<IMPORT NAME="bonita-client-7.2.4.jar" MODULE="bonita-client-7.2.4.jar" MVN="mvn:org.talend.libraries/bonita-client-7.2.4/6.3.0" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='HTTP_CLIENT')" />
-			<IMPORT NAME="bonita-common-7.2.4.jar" MODULE="bonita-common-7.2.4.jar" MVN="mvn:org.talend.libraries/bonita-common-7.2.4/6.3.0" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='HTTP_CLIENT')" />
+			<IMPORT NAME="bonita-common-7.2.4.jar" MODULE="bonita-common-7.2.4.jar" MVN="mvn:org.bonitasoft.engine/bonita-common/7.2.4" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='HTTP_CLIENT')" />
 			
 			<IMPORT NAME="httpmime-4.2.5.jar" MODULE="httpmime-4.2.5.jar" MVN="mvn:org.apache.httpcomponents/httpmime/4.2.5" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='HTTP_CLIENT')" />
 			<IMPORT NAME="httpclient-4.5.13.jar" MODULE="httpclient-4.5.13.jar" MVN="mvn:org.apache.httpcomponents/httpclient/4.5.13" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='HTTP_CLIENT')" />
@@ -196,9 +196,9 @@
 			<!-- Bonita 7.2.4 JAVA API -->
 			<IMPORT NAME="talend-bonita-client-1.0.1.jar" MODULE="talend-bonita-client-1.0.1.jar" MVN="mvn:org.talend.bonita/talend-bonita-client/1.0.1" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='JAVA_CLIENT')" />
 			<IMPORT NAME="bonita-client-7.2.4.jar" MODULE="bonita-client-7.2.4.jar" MVN="mvn:org.talend.libraries/bonita-client-7.2.4/6.3.0" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='JAVA_CLIENT')" />
-			<IMPORT NAME="bonita-common-7.2.4.jar" MODULE="bonita-common-7.2.4.jar" MVN="mvn:org.talend.libraries/bonita-common-7.2.4/6.3.0" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='JAVA_CLIENT')" />
+			<IMPORT NAME="bonita-common-7.2.4.jar" MODULE="bonita-common-7.2.4.jar" MVN="mvn:org.bonitasoft.engine/bonita-common/7.2.4" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='JAVA_CLIENT')" />
 			<IMPORT NAME="bonita-server-7.2.4.jar" MODULE="bonita-server-7.2.4.jar" MVN="mvn:org.talend.libraries/bonita-server-7.2.4/6.3.0" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='JAVA_CLIENT')" />
-			<IMPORT NAME="xpp3-1.1.6.jar" MODULE="xpp3-1.1.6.jar" MVN="mvn:org.talend.libraries/xpp3-1.1.6/6.0.0" UrlPath="platform:/plugin/org.talend.libraries.xml/lib/xpp3-1.1.6.jar" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='JAVA_CLIENT')" />
+			<IMPORT NAME="xpp3-1.1.6.jar" MODULE="xpp3-1.1.6.jar" MVN="mvn:org.ogce/xpp3/1.1.6" UrlPath="platform:/plugin/org.talend.libraries.xml/lib/xpp3-1.1.6.jar" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='JAVA_CLIENT')" />
 			
 			<IMPORT NAME="httpmime-4.2.5.jar" MODULE="httpmime-4.2.5.jar" MVN="mvn:org.apache.httpcomponents/httpmime/4.2.5" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='JAVA_CLIENT')" />
 			<IMPORT NAME="httpclient-4.5.13.jar" MODULE="httpclient-4.5.13.jar" MVN="mvn:org.apache.httpcomponents/httpclient/4.5.13" REQUIRED_IF="(DB_VERSION=='BONITA_724') AND (CLIENT_MODE=='JAVA_CLIENT')" />

main/plugins/org.talend.designer.components.localprovider/components/tCombinedSQLOutput/tCombinedSQLOutput_java.xml

@@ -49,7 +49,6 @@
 				<ITEM NAME="MYSQL" VALUE="MYSQL" />
 				<ITEM NAME="DBORACLE" VALUE="DBORACLE" />
 				<ITEM NAME="PARACCEL" VALUE="PARACCEL" />
-				<ITEM NAME="POSTGREPLUS" VALUE="POSTGREPLUS" />
 				<ITEM NAME="POSTGRE" VALUE="POSTGRE" />
 				<ITEM NAME="SQLITE" VALUE="SQLITE" />
 				<ITEM NAME="SYBASE" VALUE="SYBASE" />
@@ -63,7 +62,7 @@
 		<PARAMETER 
 			NAME="CONNECTION_AS400" 
 			FIELD="COMPONENT_LIST"
-			FILTER="REGEXP:^tAS400Connection|tJDBCConnection$" 
+			FILTER="REGEXP:^tAS400Connection|JDBCConnection$"
 			REQUIRED="true"
 			NUM_ROW="3"
 			SHOW_IF="DBTYPE=='AS400'" 
@@ -73,7 +72,7 @@
 		<PARAMETER 
 			NAME="CONNECTION_DB2" 
 			FIELD="COMPONENT_LIST"
-			FILTER="REGEXP:^tDB2Connection|tJDBCConnection$" 
+			FILTER="REGEXP:^tDB2Connection|JDBCConnection$"
 			REQUIRED="true"
 			NUM_ROW="3"
 			SHOW_IF="DBTYPE=='DB2'" 
@@ -83,7 +82,7 @@
 		<PARAMETER 
 			NAME="CONNECTION_FIREBIRD" 
 			FIELD="COMPONENT_LIST"
-			FILTER="REGEXP:^tFirebirdConnection|tJDBCConnection$" 
+			FILTER="REGEXP:^tFirebirdConnection|JDBCConnection$"
 			REQUIRED="true"
 			NUM_ROW="3"
 			SHOW_IF="DBTYPE=='FIREBIRD'" 
@@ -93,7 +92,7 @@
 		<PARAMETER 
 			NAME="CONNECTION_GREENPLUM" 
 			FIELD="COMPONENT_LIST"
-			FILTER="REGEXP:^tGreenplumConnection|tJDBCConnection$" 
+			FILTER="REGEXP:^tGreenplumConnection|JDBCConnection$"
 			REQUIRED="true"
 			NUM_ROW="3"
 			SHOW_IF="DBTYPE=='GREENPLUM'" 
@@ -103,7 +102,7 @@
 		<PARAMETER 
 			NAME="CONNECTION_HIVE" 
 			FIELD="COMPONENT_LIST"
-			FILTER="REGEXP:^tHiveConnection|tJDBCConnection$" 
+			FILTER="REGEXP:^tHiveConnection|JDBCConnection$"
 			REQUIRED="true"
 			NUM_ROW="3"
 			SHOW_IF="DBTYPE=='HIVE'" 
@@ -113,7 +112,7 @@
 		<PARAMETER 
 			NAME="CONNECTION_INGRES" 
 			FIELD="COMPONENT_LIST"
-			FILTER="REGEXP:^tIngresConnection|tJDBCConnection$" 
+			FILTER="REGEXP:^tIngresConnection|JDBCConnection$"
 			REQUIRED="true"
 			NUM_ROW="3"
 			SHOW_IF="DBTYPE=='INGRES'" 
@@ -123,7 +122,7 @@
 		<PARAMETER 
 			NAME="CONNECTION_INTERBASE" 
 			FIELD="COMPONENT_LIST"
-			FILTER="REGEXP:^tInterbaseConnection|tJDBCConnection$" 
+			FILTER="REGEXP:^tInterbaseConnection|JDBCConnection$"
 			REQUIRED="true"
 			NUM_ROW="3"
 			SHOW_IF="DBTYPE=='INTERBASE'" 
@@ -133,7 +132,7 @@
 		<PARAMETER 
 			NAME="CONNECTION_MSSQL" 
 			FIELD="COMPONENT_LIST"
-			FILTER="REGEXP:^tMSSqlConnection|tJDBCConnection$" 
+			FILTER="REGEXP:^tMSSqlConnection|JDBCConnection$"
 			REQUIRED="true"
 			NUM_ROW="3"
 			SHOW_IF="DBTYPE=='MSSQL'" 
@@ -143,7 +142,7 @@
 		<PARAMETER 
 			NAME="CONNECTION_MYSQL" 
 			FIELD="COMPONENT_LIST"
-			FILTER="REGEXP:^tMysqlConnection|tJDBCConnection$" 
+			FILTER="REGEXP:^tMysqlConnection|JDBCConnection$"
 			REQUIRED="true"
 			NUM_ROW="3"
 			SHOW_IF="DBTYPE=='MYSQL'" 
@@ -153,7 +152,7 @@
 		<PARAMETER 
 			NAME="CONNECTION_DBORACLE" 
 			FIELD="COMPONENT_LIST"
-			FILTER="REGEXP:^tOracleConnection|tJDBCConnection$" 
+			FILTER="REGEXP:^tOracleConnection|JDBCConnection$"
 			REQUIRED="true"
 			NUM_ROW="3"
 			SHOW_IF="DBTYPE=='DBORACLE'" 
@@ -163,27 +162,17 @@
 		<PARAMETER 
 			NAME="CONNECTION_PARACCEL" 
 			FIELD="COMPONENT_LIST"
-			FILTER="REGEXP:^tParAccelConnection|tJDBCConnection$" 
+			FILTER="REGEXP:^tParAccelConnection|JDBCConnection$"
 			REQUIRED="true"
 			NUM_ROW="3"
 			SHOW_IF="DBTYPE=='PARACCEL'" 
-		/>		
-		
-		<!-- Postgreplus -->
-		<PARAMETER 
-			NAME="CONNECTION_POSTGREPLUS" 
-			FIELD="COMPONENT_LIST"
-			FILTER="REGEXP:^tPostgresPlusConnection|tJDBCConnection$" 
-			REQUIRED="true"
-			NUM_ROW="3"
-			SHOW_IF="DBTYPE=='POSTGREPLUS'" 
-		/>		
-		
+		/>
+
 		<!-- PostgreSQL -->
 		<PARAMETER 
 			NAME="CONNECTION_POSTGRE" 
 			FIELD="COMPONENT_LIST"
-			FILTER="REGEXP:^tPostgresqlConnection|tJDBCConnection$" 
+			FILTER="REGEXP:^tPostgresqlConnection|JDBCConnection$"
 			REQUIRED="true"
 			NUM_ROW="3"
 			SHOW_IF="DBTYPE=='POSTGRE'" 
@@ -193,7 +182,7 @@
 		<PARAMETER 
 			NAME="CONNECTION_SQLITE" 
 			FIELD="COMPONENT_LIST"
-			FILTER="REGEXP:^tSQLiteConnection|tJDBCConnection$" 
+			FILTER="REGEXP:^tSQLiteConnection|JDBCConnection$"
 			REQUIRED="true"
 			NUM_ROW="3"
 			SHOW_IF="DBTYPE=='SQLITE'" 
@@ -203,7 +192,7 @@
 		<PARAMETER 
 			NAME="CONNECTION_SYBASE" 
 			FIELD="COMPONENT_LIST"
-			FILTER="REGEXP:^tSybaseConnection|tJDBCConnection$" 
+			FILTER="REGEXP:^tSybaseConnection|JDBCConnection$"
 			REQUIRED="true"
 			NUM_ROW="3"
 			SHOW_IF="DBTYPE=='SYBASE'" 
@@ -213,7 +202,7 @@
 		<PARAMETER 
 			NAME="CONNECTION_TERADATA" 
 			FIELD="COMPONENT_LIST"
-			FILTER="REGEXP:^tTeradataConnection|tJDBCConnection$" 
+			FILTER="REGEXP:^tTeradataConnection|JDBCConnection$"
 			REQUIRED="true"
 			NUM_ROW="3"
 			SHOW_IF="DBTYPE=='TERADATA'" 
@@ -223,7 +212,7 @@
 		<PARAMETER 
 			NAME="CONNECTION_VERTICA" 
 			FIELD="COMPONENT_LIST"
-			FILTER="REGEXP:^tVerticaConnection|tJDBCConnection$" 
+			FILTER="REGEXP:^tVerticaConnection|JDBCConnection$"
 			REQUIRED="true"
 			NUM_ROW="3"
 			SHOW_IF="DBTYPE=='VERTICA'" 
@@ -247,7 +236,6 @@
       		<DEFAULT IF="DBTYPE=='MYSQL'">mysql_id</DEFAULT>
       		<DEFAULT IF="DBTYPE=='DBORACLE'">oracle_id</DEFAULT>
       		<DEFAULT IF="DBTYPE=='POSTGRE'">postgres_id</DEFAULT>
-      		<DEFAULT IF="DBTYPE=='POSTGREPLUS'">postgresplus_id</DEFAULT>
       		<DEFAULT IF="DBTYPE=='SQLITE'">sqlite_id</DEFAULT>
       		<DEFAULT IF="DBTYPE=='PARACCEL'">paraccel_id</DEFAULT>
       		<DEFAULT IF="DBTYPE=='SYBASE'">sybase_id</DEFAULT>

main/plugins/org.talend.designer.components.localprovider/components/tCreateTable/tCreateTable_java.xml

@@ -46,9 +46,9 @@
     			or (DBTYPE=='INGRES' and USE_EXISTING_CONNECTION == 'true') or (DBTYPE=='INTERBASE' and USE_EXISTING_CONNECTION == 'true')
     			or (DBTYPE=='SQLITE' and USE_EXISTING_CONNECTION == 'true') or (DBTYPE=='SYBASE' and USE_EXISTING_CONNECTION == 'true')
     			or (DBTYPE=='TERADATA' and USE_EXISTING_CONNECTION == 'true') or (DBTYPE=='NETEZZA' and USE_EXISTING_CONNECTION == 'true')
-    			or (DBTYPE=='POSTGREPLUS' and USE_EXISTING_CONNECTION == 'true') or (DBTYPE=='ACCESS' and USE_EXISTING_CONNECTION == 'true')
-    			or (DBTYPE=='GREENPLUM' and USE_EXISTING_CONNECTION == 'true')or (DBTYPE=='VERTICA' and USE_EXISTING_CONNECTION == 'true')
-    			or (DBTYPE=='REDSHIFT' and USE_EXISTING_CONNECTION == 'true') or (DBTYPE=='SNOWFLAKE' and USE_EXISTING_CONNECTION == 'true')"
+    			or (DBTYPE=='ACCESS' and USE_EXISTING_CONNECTION == 'true') or (DBTYPE=='GREENPLUM' and USE_EXISTING_CONNECTION == 'true')
+    			or (DBTYPE=='VERTICA' and USE_EXISTING_CONNECTION == 'true') or (DBTYPE=='REDSHIFT' and USE_EXISTING_CONNECTION == 'true')
+    			or (DBTYPE=='SNOWFLAKE' and USE_EXISTING_CONNECTION == 'true')"
   />
 
   <PARAMETER
@@ -74,7 +74,6 @@
 		<ITEM NAME="NETEZZA"   VALUE="NETEZZA"/>
         <ITEM NAME="ODBC"      VALUE="ODBC"/>
         <ITEM NAME="DBORACLE"      VALUE="DBORACLE"/>
-        <ITEM NAME="POSTGREPLUS"   VALUE="POSTGREPLUS"/>
         <ITEM NAME="POSTGRE"      VALUE="POSTGRE"/>
         <ITEM NAME="REDSHIFT"   VALUE="REDSHIFT"/>
         <ITEM NAME="SNOWFLAKE"      VALUE="SNOWFLAKE"/>
@@ -109,7 +108,7 @@
 
 	<PARAMETER NAME="USE_EXISTING_CONNECTION" FIELD="CHECK" NUM_ROW="30"
 		SHOW_IF="(DBTYPE=='MSSQL') or (DBTYPE=='MYSQL') or (DBTYPE=='DBORACLE') or (DBTYPE=='POSTGRE')
-				or (DBTYPE=='POSTGREPLUS') or (DBTYPE=='TERADATA') or (DBTYPE=='NETEZZA') or (DBTYPE=='AS400')
+				or (DBTYPE=='TERADATA') or (DBTYPE=='NETEZZA') or (DBTYPE=='AS400')
 				or (DBTYPE=='DB2') or (DBTYPE=='FIREBIRD') or (DBTYPE=='INFORMIX') or (DBTYPE=='INGRES')
 				or (DBTYPE=='SQLITE') or (DBTYPE=='SYBASE') or (DBTYPE=='ACCESS') or (DBTYPE=='GREENPLUM') or (DBTYPE=='VERTICA') 
 				or (DBTYPE=='EXASOL') or (DBTYPE=='REDSHIFT') or (DBTYPE=='SNOWFLAKE')">
@@ -121,7 +120,7 @@
 		NOT_SHOW_IF="(DBTYPE=='ACCESS') or (DBTYPE=='SQLITE') or (DBTYPE == 'ODBC') or (DBTYPE == 'JAVADB' and FRAMEWORK_TYPE=='EMBEDED')
 					or (DBTYPE == 'HSQLDB' and RUNNING_MODE == 'HSQLDB_INPROGRESS_PERSISTENT') or (DBTYPE=='MYSQL' and USE_EXISTING_CONNECTION=='TRUE')
 					or (DBTYPE=='MSSQL' and USE_EXISTING_CONNECTION == 'true') or (DBTYPE=='DBORACLE' and USE_EXISTING_CONNECTION=='TRUE')
-					or (DBTYPE=='POSTGRE' and USE_EXISTING_CONNECTION=='TRUE') or (DBTYPE=='POSTGREPLUS' and USE_EXISTING_CONNECTION=='TRUE')
+					or (DBTYPE=='POSTGRE' and USE_EXISTING_CONNECTION=='TRUE')
 					or (DBTYPE=='TERADATA' and USE_EXISTING_CONNECTION=='TRUE') or (DBTYPE=='NETEZZA' and USE_EXISTING_CONNECTION=='TRUE')
 					or (DBTYPE=='AS400' and USE_EXISTING_CONNECTION=='TRUE') or (DBTYPE=='DB2' and USE_EXISTING_CONNECTION=='TRUE')
 					or (DBTYPE=='FIREBIRD' and USE_EXISTING_CONNECTION=='TRUE') or (DBTYPE=='INFORMIX' and USE_EXISTING_CONNECTION=='TRUE')
@@ -138,7 +137,7 @@
 		NOT_SHOW_IF="(DBTYPE=='FIREBIRD') or (DBTYPE=='ACCESS') or (DBTYPE=='SQLITE') or (DBTYPE == 'HSQLDB')
 					or (DBTYPE == 'JAVADB') or (DBTYPE == 'ODBC') or (DBTYPE=='MYSQL' and USE_EXISTING_CONNECTION=='TRUE')
 					or (DBTYPE=='MSSQL' and USE_EXISTING_CONNECTION == 'true') or (DBTYPE=='DBORACLE' and USE_EXISTING_CONNECTION=='TRUE')
-					or (DBTYPE=='POSTGRE' and USE_EXISTING_CONNECTION=='TRUE') or (DBTYPE=='POSTGREPLUS' and USE_EXISTING_CONNECTION=='TRUE')
+					or (DBTYPE=='POSTGRE' and USE_EXISTING_CONNECTION=='TRUE')
 					or (DBTYPE=='TERADATA' and USE_EXISTING_CONNECTION=='TRUE') or (DBTYPE=='NETEZZA' and USE_EXISTING_CONNECTION=='TRUE')
 					or (DBTYPE=='AS400' and USE_EXISTING_CONNECTION=='TRUE') or (DBTYPE=='DB2' and USE_EXISTING_CONNECTION=='TRUE')
 					or (DBTYPE=='INFORMIX' and USE_EXISTING_CONNECTION=='TRUE') or (DBTYPE=='INGRES' and USE_EXISTING_CONNECTION == 'true')
@@ -174,7 +173,7 @@
 		REPOSITORY_VALUE="USERNAME" REQUIRED="true"
 		NOT_SHOW_IF="(DBTYPE=='SQLITE') or (DBTYPE=='MSSQL' and USE_EXISTING_CONNECTION == 'true') or (DBTYPE=='MYSQL' and USE_EXISTING_CONNECTION=='TRUE')
 					or (DBTYPE=='DBORACLE' and USE_EXISTING_CONNECTION=='TRUE') or (DBTYPE=='POSTGRE' and USE_EXISTING_CONNECTION=='TRUE')
-					or (DBTYPE=='POSTGREPLUS' and USE_EXISTING_CONNECTION=='TRUE') or (DBTYPE=='TERADATA' and USE_EXISTING_CONNECTION=='TRUE')
+					or (DBTYPE=='TERADATA' and USE_EXISTING_CONNECTION=='TRUE')
 					or (DBTYPE=='NETEZZA' and USE_EXISTING_CONNECTION=='TRUE') or (DBTYPE=='AS400' and USE_EXISTING_CONNECTION=='TRUE')
 					or (DBTYPE=='DB2' and USE_EXISTING_CONNECTION=='TRUE') or (DBTYPE=='FIREBIRD' and USE_EXISTING_CONNECTION=='TRUE')
 					or (DBTYPE=='INFORMIX' and USE_EXISTING_CONNECTION=='TRUE') or (DBTYPE=='INGRES' and USE_EXISTING_CONNECTION == 'true')
@@ -190,7 +189,7 @@
 		REPOSITORY_VALUE="PASSWORD" REQUIRED="true"
 		NOT_SHOW_IF="(DBTYPE=='SQLITE') or (DBTYPE=='MSSQL' and USE_EXISTING_CONNECTION == 'true') or (DBTYPE=='MYSQL' and USE_EXISTING_CONNECTION=='TRUE')
 					or (DBTYPE=='DBORACLE' and USE_EXISTING_CONNECTION=='TRUE') or (DBTYPE=='POSTGRE' and USE_EXISTING_CONNECTION=='TRUE')
-					or (DBTYPE=='POSTGREPLUS' and USE_EXISTING_CONNECTION=='TRUE') or (DBTYPE=='TERADATA' and USE_EXISTING_CONNECTION=='TRUE')
+					or (DBTYPE=='TERADATA' and USE_EXISTING_CONNECTION=='TRUE')
 					or (DBTYPE=='NETEZZA' and USE_EXISTING_CONNECTION=='TRUE') or (DBTYPE=='AS400' and USE_EXISTING_CONNECTION=='TRUE')
 					or (DBTYPE=='DB2' and USE_EXISTING_CONNECTION=='TRUE') or (DBTYPE=='FIREBIRD' and USE_EXISTING_CONNECTION=='TRUE')
 					or (DBTYPE=='INFORMIX' and USE_EXISTING_CONNECTION=='TRUE') or (DBTYPE=='INGRES' and USE_EXISTING_CONNECTION == 'true')
@@ -211,7 +210,7 @@
 	  NOT_SHOW_IF="(DBTYPE=='AS400') or (DBTYPE=='FIREBIRD') or (DBTYPE=='ACCESS') or (DBTYPE=='SQLITE') or (DBTYPE=='TERADATA')
 	  				or (DBTYPE=='MSSQL' and USE_EXISTING_CONNECTION == 'true') or (DBTYPE=='MYSQL' and USE_EXISTING_CONNECTION=='TRUE')
 	  				or (DBTYPE=='DBORACLE' and USE_EXISTING_CONNECTION=='TRUE') or (DBTYPE=='NETEZZA' and USE_EXISTING_CONNECTION=='TRUE')
-	  				or (DBTYPE=='POSTGRE' and USE_EXISTING_CONNECTION=='TRUE') or (DBTYPE=='POSTGREPLUS' and USE_EXISTING_CONNECTION=='TRUE')
+	  				or (DBTYPE=='POSTGRE' and USE_EXISTING_CONNECTION=='TRUE')
 	  				or (DBTYPE == 'JAVADB' and FRAMEWORK_TYPE=='EMBEDED') or (DBTYPE == 'ODBC')
 	  				or (DBTYPE == 'HSQLDB' and RUNNING_MODE == 'HSQLDB_INPROGRESS_PERSISTENT')
 	  				or (DBTYPE=='DB2' and USE_EXISTING_CONNECTION=='TRUE') or (DBTYPE=='INFORMIX' and USE_EXISTING_CONNECTION=='TRUE')
@@ -229,7 +228,7 @@
       FIELD="TEXT"
       NUM_ROW="70"
       REPOSITORY_VALUE="SCHEMA"
-      SHOW_IF="(DBTYPE=='DBORACLE' or DBTYPE=='POSTGRE' or DBTYPE=='POSTGREPLUS' or DBTYPE=='INFORMIX' or DBTYPE=='DB2' or DBTYPE=='GREENPLUM' or DBTYPE=='VERTICA' or DBTYPE=='MSSQL' or DBTYPE=='SYBASE' 
+      SHOW_IF="(DBTYPE=='DBORACLE' or DBTYPE=='POSTGRE' or DBTYPE=='INFORMIX' or DBTYPE=='DB2' or DBTYPE=='GREENPLUM' or DBTYPE=='VERTICA' or DBTYPE=='MSSQL' or DBTYPE=='SYBASE'
       				or DBTYPE=='EXASOL' or DBTYPE=='REDSHIFT' or DBTYPE=='SNOWFLAKE') 
       			and (USE_EXISTING_CONNECTION == 'false')"
     >
@@ -543,7 +542,7 @@
 		FIELD="CLOSED_LIST"
 		NUM_ROW="50"
 		REPOSITORY_VALUE="DB_VERSION"
-		SHOW_IF="((DBTYPE=='POSTGRE') or (DBTYPE=='POSTGREPLUS')) and (USE_EXISTING_CONNECTION == 'false')">
+		SHOW_IF="(DBTYPE=='POSTGRE') and (USE_EXISTING_CONNECTION == 'false')">
 		<ITEMS DEFAULT="V9_X">
 			<ITEM NAME="PRIOR_TO_V9" VALUE="PRIOR_TO_V9" />
 			<ITEM NAME="V9_X" VALUE="V9_X" />
@@ -560,17 +559,6 @@
     </PARAMETER>
 	<!--Postgre configuration end-->
 
-	<!--PostgrePlus configuration start-->
-    <PARAMETER
-      NAME="CONNECTION_POSTGREPLUS"
-      FIELD="COMPONENT_LIST"
-      FILTER="tPostgresPlusConnection"
-	  REQUIRED="true"
-      NUM_ROW="30"
-      SHOW_IF="(DBTYPE=='POSTGREPLUS') and (USE_EXISTING_CONNECTION == 'true')"
-    />
-	<!--PostgrePlus configuration end-->
-
 	<!--SQLite configuration start-->
 	<PARAMETER
       NAME="CONNECTION_SQLITE"
@@ -739,7 +727,6 @@
       <DEFAULT IF="DBTYPE=='MYSQL'">mysql_id</DEFAULT>
       <DEFAULT IF="DBTYPE=='DBORACLE'">oracle_id</DEFAULT>
       <DEFAULT IF="DBTYPE=='POSTGRE'">postgres_id</DEFAULT>
-      <DEFAULT IF="DBTYPE=='POSTGREPLUS'">postgresplus_id</DEFAULT>
       <DEFAULT IF="DBTYPE=='SQLITE'">sqlite_id</DEFAULT>
       <DEFAULT IF="DBTYPE=='TERADATA'">teradata_id</DEFAULT>
 	  <DEFAULT IF="DBTYPE=='NETEZZA'">netezza_id</DEFAULT>
@@ -865,12 +852,12 @@
 		<IMPORT NAME="Driver-MYSQL5" MODULE="mysql-connector-java-5.1.49.jar" MVN="mvn:mysql/mysql-connector-java/5.1.49"  REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') and (DBTYPE=='MYSQL') and (DB_MYSQL_VERSION=='MYSQL_5')"/>
 		<IMPORT NAME="Driver-MYSQL8"  MODULE="mysql-connector-j-8.0.33.jar" MVN="mvn:com.mysql/mysql-connector-j/8.0.33" REQUIRED_IF="(DB_MYSQL_VERSION == 'MYSQL_8') AND (USE_EXISTING_CONNECTION == 'false') AND (DBTYPE=='MYSQL')" />
 		<IMPORT NAME="Driver-MARIADB"  MODULE="mariadb-java-client-3.1.4.jar" MVN="mvn:org.mariadb.jdbc/mariadb-java-client/3.1.4"  REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') and (DBTYPE=='MYSQL') and (DB_MYSQL_VERSION=='MARIADB')" />
-        <IMPORT NAME="Driver-Oracle11g" MODULE="ojdbc6.jar" MVN="mvn:org.talend.libraries/ojdbc6/6.0.0"  REQUIRED_IF="(DBTYPE=='DBORACLE') AND (DB_VERSION == 'ORACLE_11') AND (USE_EXISTING_CONNECTION == 'false')" />
+        <IMPORT NAME="Driver-Oracle11g" MODULE="ojdbc6-11.2.0.4.jar" MVN="mvn:com.oracle.database.jdbc/ojdbc6/11.2.0.4"  REQUIRED_IF="(DBTYPE=='DBORACLE') AND (DB_VERSION == 'ORACLE_11') AND (USE_EXISTING_CONNECTION == 'false')" />
         <IMPORT NAME="Driver-Oracle12c" MODULE="ojdbc7.jar" MVN="mvn:org.talend.libraries/ojdbc7/6.0.0"  REQUIRED_IF="(DBTYPE=='DBORACLE') AND (DB_VERSION == 'ORACLE_12') AND (USE_EXISTING_CONNECTION == 'false')" />
         <IMPORT NAME="ORACLE_18"        MODULE="ojdbc8-19.19.0.0.jar" MVN="mvn:com.oracle.database.jdbc/ojdbc8/19.19.0.0" REQUIRED_IF="(DBTYPE=='DBORACLE') AND (DB_VERSION == 'ORACLE_18') AND (USE_EXISTING_CONNECTION == 'false')" />
-		<IMPORT NAME="Driver-POSTGRESQL" MODULE="postgresql-8.4-703.jdbc4.jar" MVN="mvn:postgresql/postgresql/8.4-703.jdbc4" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((((DBTYPE=='POSTGRE') or (DBTYPE=='POSTGREPLUS')) AND (DB_POSTGRE_VERSION =='PRIOR_TO_V9')) or (DBTYPE=='GREENPLUM'))" />
-		<IMPORT NAME="Driver-Postgres9" MODULE="postgresql-42.6.0.jar" MVN="mvn:org.postgresql/postgresql/42.6.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND (((DBTYPE=='POSTGRE') or (DBTYPE=='POSTGREPLUS')) AND (DB_POSTGRE_VERSION =='V9_X'))" />
-		<IMPORT NAME="Driver-FIREBIRD" MODULE="jaybird-full-2.1.1.jar" MVN="mvn:org.talend.libraries/jaybird-full-2.1.1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.jdbc.firebird/lib/jaybird-full-2.1.1.jar" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND (DBTYPE=='FIREBIRD')" />
+		<IMPORT NAME="Driver-POSTGRESQL" MODULE="postgresql-8.4-703.jdbc4.jar" MVN="mvn:postgresql/postgresql/8.4-703.jdbc4" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND (((DBTYPE=='POSTGRE') AND (DB_POSTGRE_VERSION =='PRIOR_TO_V9')) or (DBTYPE=='GREENPLUM'))" />
+		<IMPORT NAME="Driver-Postgres9" MODULE="postgresql-42.6.0.jar" MVN="mvn:org.postgresql/postgresql/42.6.0" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND ((DBTYPE=='POSTGRE') AND (DB_POSTGRE_VERSION =='V9_X'))" />
+		<IMPORT NAME="Driver-FIREBIRD" MODULE="jaybird-2.1.1.jar" MVN="mvn:net.sf.squirrel-sql.thirdparty-non-maven/jaybird/2.1.1"  UrlPath="platform:/plugin/org.talend.libraries.jdbc.firebird/lib/jaybird-full-2.1.1.jar" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND (DBTYPE=='FIREBIRD')" />
 		<IMPORT NAME="Driver-HSQLDb" MODULE="hsqldb-2.7.1.jar" MVN="mvn:org.hsqldb/hsqldb/2.7.1" REQUIRED_IF="DBTYPE=='HSQLDB'"/>
 		<IMPORT NAME="Driver-INFORMIX-JDBC" MODULE="ifxjdbc.jar" MVN="mvn:org.talend.libraries/ifxjdbc/6.0.0"  REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND (DBTYPE=='INFORMIX')" />
 		<IMPORT NAME="Driver-INFORMIX-JDBCX" MODULE="ifxjdbcx.jar" MVN="mvn:org.talend.libraries/ifxjdbcx/6.0.0"  REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND (DBTYPE=='INFORMIX')" />
@@ -879,9 +866,9 @@
 		<IMPORT NAME="Driver-INFORMIX-SQLJ" MODULE="ifxsqlj.jar" MVN="mvn:org.talend.libraries/ifxsqlj/6.0.0"  REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND (DBTYPE=='INFORMIX')" />
 		<IMPORT NAME="Driver-INFORMIX-TOOLS" MODULE="ifxtools.jar" MVN="mvn:org.talend.libraries/ifxtools/6.0.0"  REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND (DBTYPE=='INFORMIX')"/>
 		<IMPORT NAME="Driver-Ingres" MODULE="iijdbc-10.2-4.1.10.jar" MVN="mvn:com.ingres.jdbc/iijdbc/10.2-4.1.10" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND (DBTYPE=='INGRES')"/>
-		<IMPORT NAME="Driver-JAVADB-DERBY" MODULE="derby.jar" MVN="mvn:org.talend.libraries/derby/6.0.0" REQUIRED_IF="DBTYPE=='JAVADB'"/>
-		<IMPORT NAME="Driver-JAVADB-DERBYCLIENT" MODULE="derbyclient.jar" MVN="mvn:org.talend.libraries/derbyclient/6.0.0" REQUIRED_IF="DBTYPE=='JAVADB'"/>
-		<IMPORT NAME="Driver-JAVADB-DERBYNET" MODULE="derbynet.jar" MVN="mvn:org.talend.libraries/derbynet/6.0.0" REQUIRED_IF="DBTYPE=='JAVADB'"/>
+		<IMPORT NAME="Driver-JAVADB-DERBY" MODULE="derby-10.14.2.0.jar" MVN="mvn:org.apache.derby/derby/10.14.2.0" REQUIRED_IF="DBTYPE=='JAVADB'"/>
+		<IMPORT NAME="Driver-JAVADB-DERBYCLIENT" MODULE="derbyclient-10.14.2.0.jar" MVN="mvn:org.apache.derby/derbyclient/10.14.2.0" REQUIRED_IF="DBTYPE=='JAVADB'"/>
+		<IMPORT NAME="Driver-JAVADB-DERBYNET" MODULE="derbynet-10.14.2.0.jar" MVN="mvn:org.apache.derby/derbynet/10.14.2.0" REQUIRED_IF="DBTYPE=='JAVADB'"/>
 		<IMPORT NAME="Driver-SQLite" MODULE="sqlite-jdbc-3.40.0.0.jar" MVN="mvn:org.xerial/sqlite-jdbc/3.40.0.0"  REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND (DBTYPE=='SQLITE')" />
 		<IMPORT NAME="Driver-SYBASE-JCONN3" MODULE="jconn3.jar" MVN="mvn:org.talend.libraries/jconn3/6.0.0" BundleID="" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND (DBTYPE=='SYBASE') AND (DB_SYBASE_VERSION == 'SYBSEIQ_12_15')" />
 		<IMPORT NAME="Driver-SYBASE-JCONN4" MODULE="jconn4.jar" MVN="mvn:org.talend.libraries/jconn4/6.0.0" BundleID="" REQUIRED_IF="(USE_EXISTING_CONNECTION == 'false') AND (DBTYPE=='SYBASE') AND (DB_SYBASE_VERSION == 'SYBSEIQ_16')" />

main/plugins/org.talend.designer.components.localprovider/components/tCreateTable/tCreateTable_main.javajet

@@ -176,7 +176,7 @@ abstract class Manager {
                 }
                 createTableSQL.append(suffix);
             } else {
-                boolean isPostgresishDB = ("postgres_id".equalsIgnoreCase(getDBMSId()) || "postgresplus_id".equalsIgnoreCase(getDBMSId()) || "greenplum_id".equalsIgnoreCase(getDBMSId()) );
+                boolean isPostgresishDB = ("postgres_id".equalsIgnoreCase(getDBMSId()) || "greenplum_id".equalsIgnoreCase(getDBMSId()) );
                 if(!lengthIgnored) {
                     if (isPostgresishDB && metadataColumn.getLength() == null) {
                     }else {
@@ -1354,69 +1354,6 @@ class PostgreManager extends Manager {
         return javaCode.toString();        
     }
 }
-class PostgrePlusManager extends Manager {
-    private String host;
-    private String port;
-    private String dbSchema;
-    private boolean useExistingConnection;
-    private String connection;   
-    
-    public PostgrePlusManager(String host, String port, String dbName, String tableName, String dbSchema, String userName, boolean useExistingConnection, String connection, String cid, String additionalParams) {
-        super(dbName, tableName, userName, cid, additionalParams);
-        this.host = host;
-        this.port = port;
-        this.dbSchema = dbSchema;
-        this.useExistingConnection = useExistingConnection;
-        this.connection = connection;
-    }
-    protected String getDriver() {
-        return "org.postgresql.Driver";
-    }
-    public String getSpecificConnectionURL() {
-        return "\"jdbc:postgresql://\" + " + host + " + \":\" + " + port + " + \"/\" + " + dbName;
-    }
-    public String getConnection() {
-        StringBuilder javaCode = new StringBuilder();
-        if(useExistingConnection) {
-            javaCode.append(retrieveTable());
-            javaCode.append("java.sql.Connection conn_" + cid + " = (java.sql.Connection)globalMap.get(\"conn_" + connection + "\");");
-        } else {
-            javaCode.append(super.getConnection());
-        }
-        return javaCode.toString();
-    }        
-    protected String getDBMSId() {
-        return "postgresplus_id";
-    }
-    protected String getLProtectedChar() {
-        return "\\\"";
-    }
-    protected String getRProtectedChar() {
-        return "\\\"";
-    }
-    public String closeConnection() {
-        StringBuilder javaCode = new StringBuilder();
-        if(useExistingConnection) {
-            javaCode.append("");
-        } else {
-            javaCode.append(super.closeConnection());            
-        }
-        return javaCode.toString();
-    }
-    protected String retrieveTable() {
-        StringBuilder javaCode = new StringBuilder();
-        javaCode.append(super.retrieveTable());
-        if(useExistingConnection) {
-            javaCode.append("String dbSchema_" + cid + " = (String)globalMap.get(\"schema_" + connection + "\");\r\n"); 
-        } else {
-            javaCode.append("String dbSchema_" + cid + " = " + dbSchema + ";\r\n");            
-        }
-        javaCode.append("if(dbSchema_" + cid + " != null && dbSchema_" + cid + ".trim().length() != 0) {");
-        javaCode.append("tableName_" + cid + " = dbSchema_" + cid + " + \"" + getLProtectedChar() + "." + getRProtectedChar() + "\" + tableName_" + cid + ";\r\n");
-        javaCode.append("}");
-        return javaCode.toString();        
-    }    
-}
 class SQLiteManager extends Manager {
 	private boolean useExistingConnection;
 	private String connection;
@@ -1695,7 +1632,7 @@ class TeradataManager extends Manager {
                 createTableSQL.append(suffix);
             } else {
                 if(!lengthIgnored) {                
-                	if (("postgres_id".equalsIgnoreCase(getDBMSId()) || "postgresplus_id".equalsIgnoreCase(getDBMSId()) || "greenplum_id".equalsIgnoreCase(getDBMSId()) ) && metadataColumn.getLength() == null) {
+                	if (("postgres_id".equalsIgnoreCase(getDBMSId()) || "greenplum_id".equalsIgnoreCase(getDBMSId()) ) && metadataColumn.getLength() == null) {
                 	}else {
 	                    prefix = "(";
 	                    suffix = ") ";
@@ -1714,7 +1651,7 @@ class TeradataManager extends Manager {
                     createTableSQL.append(comma + precision);
                 }
                 
-                if (("postgres_id".equalsIgnoreCase(getDBMSId()) || "postgresplus_id".equalsIgnoreCase(getDBMSId()) ||"greenplum_id".equalsIgnoreCase(getDBMSId()) ) && metadataColumn.getLength() == null) {                	
+                if (("postgres_id".equalsIgnoreCase(getDBMSId()) ||"greenplum_id".equalsIgnoreCase(getDBMSId()) ) && metadataColumn.getLength() == null) {
                 } else {
                 	createTableSQL.append(suffix);
                 }
@@ -2339,15 +2276,6 @@ class ManagerFactory {
             boolean tempTable = ("true").equals(ElementParameterParser.getValue(node, "__TEMPTABLE__"));
             boolean unloggedTable = ("true").equals(ElementParameterParser.getValue(node, "__UNLOGGED__"));
             manager = new PostgreManager(host, port, dbName, tableName, dbSchema, userName, useExistingConnection, connection, cid, tempTable, unloggedTable, additionalParams);
-        } else if(("POSTGREPLUS").equals(dbType)) {
-            String host = ElementParameterParser.getValue(node, "__HOST__");
-            String port = ElementParameterParser.getValue(node, "__PORT__");
-            String dbSchema = ElementParameterParser.getValue(node, "__SCHEMA_DB__");
-            String dbName = ElementParameterParser.getValue(node, "__DBNAME__");
-            String userName = ElementParameterParser.getValue(node, "__USER__");
-            boolean useExistingConnection = ("true").equals(ElementParameterParser.getValue(node, "__USE_EXISTING_CONNECTION__"));
-            String connection = stringUtil.getString(ElementParameterParser.getValue(node, "__CONNECTION_POSTGREPLUS__"));
-            manager = new PostgrePlusManager(host, port, dbName, tableName, dbSchema, userName, useExistingConnection, connection, cid, additionalParams);            
         } else if(("SQLITE").equals(dbType)) {
             String dbName = ElementParameterParser.getValue(node, "__DBFILE_SQLITE__");
             String userName = ElementParameterParser.getValue(node, "__USER__");
@@ -2446,7 +2374,7 @@ if(columnList != null && columnList.size() > 0) {
     String cid = node.getUniqueName();
     boolean isLog4jEnabled = ("true").equals(ElementParameterParser.getValue(node.getProcess(), "__LOG4J_ACTIVATE__"));
     boolean tableNameCaseSensitive=false;
-    if("DB2".equalsIgnoreCase(dbType)||"POSTGRE".equalsIgnoreCase(dbType)||"POSTGREPLUS".equalsIgnoreCase(dbType)||"GREENPLUM".equalsIgnoreCase(dbType)){
+    if("DB2".equalsIgnoreCase(dbType)||"POSTGRE".equalsIgnoreCase(dbType)||"GREENPLUM".equalsIgnoreCase(dbType)){
     	tableNameCaseSensitive=true;
     }
     if(("HSQLDB").equals(dbType)){
@@ -2555,7 +2483,7 @@ if(columnList != null && columnList.size() > 0) {
                     }
                 }
 <%
-            } else if ("GREENPLUM".equalsIgnoreCase(dbType) || "POSTGRE".equalsIgnoreCase(dbType) || "POSTGREPLUS".equalsIgnoreCase(dbType)) {
+            } else if ("GREENPLUM".equalsIgnoreCase(dbType) || "POSTGRE".equalsIgnoreCase(dbType)) {
                 if ("true".equals(ElementParameterParser.getValue(node, "__TEMPTABLE__"))) {
 %>
                     java.sql.PreparedStatement tempTablePs_<%=cid %> = conn_<%=cid %>.prepareStatement("SELECT * FROM information_schema.tables WHERE table_type='LOCAL TEMPORARY' AND table_name = ?");

main/plugins/org.talend.designer.components.localprovider/components/tDB2Row/tDB2Row_messages_fr.properties

@@ -45,7 +45,7 @@ SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.BigDecimal=BigDecimal
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Blob=Blob
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Boolean=Bool\u00E9en
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Byte=Octet
-SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Bytes=Bytes
+SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Bytes=Octets
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Clob=Clob
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Date=Date
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Double=Double

main/plugins/org.talend.designer.components.localprovider/components/tDropboxConnection/tDropboxConnection_java.xml

@@ -58,7 +58,7 @@
    <CODEGENERATION>
    		<IMPORTS>
                <IMPORT NAME="dropbox-core-sdk"
-                    MODULE="dropbox-core-sdk-2.1.2.jar" MVN="mvn:org.talend.libraries/dropbox-core-sdk-2.1.2/6.3.0" 
+                    MODULE="dropbox-core-sdk-2.1.2.jar" MVN="mvn:com.dropbox.core/dropbox-core-sdk/2.1.2" 
                     REQUIRED="true" />
                <IMPORT NAME="jackson-core"
                     MODULE="jackson-core-2.14.3.jar" MVN="mvn:com.fasterxml.jackson.core/jackson-core/2.14.3"

main/plugins/org.talend.designer.components.localprovider/components/tDropboxDelete/tDropboxDelete_java.xml

@@ -68,7 +68,7 @@
    <CODEGENERATION>
       	<IMPORTS>
                <IMPORT NAME="dropbox-core-sdk"
-                    MODULE="dropbox-core-sdk-2.1.2.jar" MVN="mvn:org.talend.libraries/dropbox-core-sdk-2.1.2/6.3.0" 
+                    MODULE="dropbox-core-sdk-2.1.2.jar" MVN="mvn:com.dropbox.core/dropbox-core-sdk/2.1.2" 
                     REQUIRED_IF="USE_EXISTING_CONNECTION == 'false'" />
                <IMPORT NAME="jackson-core"
                     MODULE="jackson-core-2.14.3.jar" MVN="mvn:com.fasterxml.jackson.core/jackson-core/2.14.3"

main/plugins/org.talend.designer.components.localprovider/components/tDropboxGet/tDropboxGet_java.xml

@@ -82,7 +82,7 @@
    <CODEGENERATION>
       	<IMPORTS>
                <IMPORT NAME="dropbox-core-sdk"
-                    MODULE="dropbox-core-sdk-2.1.2.jar" MVN="mvn:org.talend.libraries/dropbox-core-sdk-2.1.2/6.3.0" 
+                    MODULE="dropbox-core-sdk-2.1.2.jar" MVN="mvn:com.dropbox.core/dropbox-core-sdk/2.1.2" 
                     REQUIRED_IF="USE_EXISTING_CONNECTION == 'false'" />
                <IMPORT NAME="jackson-core"
                     MODULE="jackson-core-2.14.3.jar" MVN="mvn:com.fasterxml.jackson.core/jackson-core/2.14.3"

main/plugins/org.talend.designer.components.localprovider/components/tDropboxList/tDropboxList_java.xml

@@ -80,7 +80,7 @@
    <CODEGENERATION>
       	<IMPORTS>
                <IMPORT NAME="dropbox-core-sdk"
-                    MODULE="dropbox-core-sdk-2.1.2.jar" MVN="mvn:org.talend.libraries/dropbox-core-sdk-2.1.2/6.3.0" 
+                    MODULE="dropbox-core-sdk-2.1.2.jar" MVN="mvn:com.dropbox.core/dropbox-core-sdk/2.1.2" 
                     REQUIRED_IF="USE_EXISTING_CONNECTION == 'false'" />
                <IMPORT NAME="jackson-core"
                     MODULE="jackson-core-2.14.3.jar" MVN="mvn:com.fasterxml.jackson.core/jackson-core/2.14.3"

main/plugins/org.talend.designer.components.localprovider/components/tDropboxPut/tDropboxPut_java.xml

@@ -107,7 +107,7 @@
    <CODEGENERATION>
       	<IMPORTS>
                <IMPORT NAME="dropbox-core-sdk"
-                    MODULE="dropbox-core-sdk-2.1.2.jar" MVN="mvn:org.talend.libraries/dropbox-core-sdk-2.1.2/6.3.0" 
+                    MODULE="dropbox-core-sdk-2.1.2.jar" MVN="mvn:com.dropbox.core/dropbox-core-sdk/2.1.2" 
                     REQUIRED_IF="USE_EXISTING_CONNECTION == 'false'" />
                <IMPORT NAME="jackson-core"
                     MODULE="jackson-core-2.14.3.jar" MVN="mvn:com.fasterxml.jackson.core/jackson-core/2.14.3"

main/plugins/org.talend.designer.components.localprovider/components/tEDIFACTtoXML/tEDIFACTtoXML_java.xml

@@ -104,79 +104,79 @@
 
   <CODEGENERATION>
 	<IMPORTS>
-			<IMPORT NAME="d00a-mapping-1.4" MODULE="d00a-mapping-1.4-20101230.181140-1.jar" MVN="mvn:org.talend.libraries/d00a-mapping-1.4-20101230.181140-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d00a-mapping-1.4-20101230.181140-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d00b-mapping-1.4" MODULE="d00b-mapping-1.4-20101230.182448-1.jar" MVN="mvn:org.talend.libraries/d00b-mapping-1.4-20101230.182448-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d00b-mapping-1.4-20101230.182448-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d01a-mapping-1.4" MODULE="d01a-mapping-1.4-20101230.183534-1.jar" MVN="mvn:org.talend.libraries/d01a-mapping-1.4-20101230.183534-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d01a-mapping-1.4-20101230.183534-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d01b-mapping-1.4" MODULE="d01b-mapping-1.4-20101230.185159-1.jar" MVN="mvn:org.talend.libraries/d01b-mapping-1.4-20101230.185159-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d01b-mapping-1.4-20101230.185159-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d01c-mapping-1.4" MODULE="d01c-mapping-1.4-20101230.190625-1.jar" MVN="mvn:org.talend.libraries/d01c-mapping-1.4-20101230.190625-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d01c-mapping-1.4-20101230.190625-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d02a-mapping-1.4" MODULE="d02a-mapping-1.4-20101230.191840-1.jar" MVN="mvn:org.talend.libraries/d02a-mapping-1.4-20101230.191840-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d02a-mapping-1.4-20101230.191840-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d02b-mapping-1.4" MODULE="d02b-mapping-1.4-20101230.193459-1.jar" MVN="mvn:org.talend.libraries/d02b-mapping-1.4-20101230.193459-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d02b-mapping-1.4-20101230.193459-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d03a-mapping-1.4" MODULE="d03a-mapping-1.4-20101230.195010-1.jar" MVN="mvn:org.talend.libraries/d03a-mapping-1.4-20101230.195010-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d03a-mapping-1.4-20101230.195010-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d03b-mapping-1.4" MODULE="d03b-mapping-1.4-20101230.201023-1.jar" MVN="mvn:org.talend.libraries/d03b-mapping-1.4-20101230.201023-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d03b-mapping-1.4-20101230.201023-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d04a-mapping-1.4" MODULE="d04a-mapping-1.4-20101230.202950-1.jar" MVN="mvn:org.talend.libraries/d04a-mapping-1.4-20101230.202950-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d04a-mapping-1.4-20101230.202950-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d04b-mapping-1.4" MODULE="d04b-mapping-1.4-20101230.204717-1.jar" MVN="mvn:org.talend.libraries/d04b-mapping-1.4-20101230.204717-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d04b-mapping-1.4-20101230.204717-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d05a-mapping-1.4" MODULE="d05a-mapping-1.4-20101230.210746-1.jar" MVN="mvn:org.talend.libraries/d05a-mapping-1.4-20101230.210746-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d05a-mapping-1.4-20101230.210746-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d05b-mapping-1.4" MODULE="d05b-mapping-1.4-20101230.212643-1.jar" MVN="mvn:org.talend.libraries/d05b-mapping-1.4-20101230.212643-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d05b-mapping-1.4-20101230.212643-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d06a-mapping-1.4" MODULE="d06a-mapping-1.4-20101230.214557-1.jar" MVN="mvn:org.talend.libraries/d06a-mapping-1.4-20101230.214557-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d06a-mapping-1.4-20101230.214557-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d06b-mapping-1.4" MODULE="d06b-mapping-1.4-20101230.220647-1.jar" MVN="mvn:org.talend.libraries/d06b-mapping-1.4-20101230.220647-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d06b-mapping-1.4-20101230.220647-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d07a-mapping-1.4" MODULE="d07a-mapping-1.4-20101230.222824-1.jar" MVN="mvn:org.talend.libraries/d07a-mapping-1.4-20101230.222824-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d07a-mapping-1.4-20101230.222824-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d07b-mapping-1.4" MODULE="d07b-mapping-1.4-20101230.224645-1.jar" MVN="mvn:org.talend.libraries/d07b-mapping-1.4-20101230.224645-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d07b-mapping-1.4-20101230.224645-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d08a-mapping-1.4" MODULE="d08a-mapping-1.4-20101230.230844-1.jar" MVN="mvn:org.talend.libraries/d08a-mapping-1.4-20101230.230844-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d08a-mapping-1.4-20101230.230844-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d08b-mapping-1.4" MODULE="d08b-mapping-1.4-20101230.231449-1.jar" MVN="mvn:org.talend.libraries/d08b-mapping-1.4-20101230.231449-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d08b-mapping-1.4-20101230.231449-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d09a-mapping-1.4" MODULE="d09a-mapping-1.4-20101230.233910-1.jar" MVN="mvn:org.talend.libraries/d09a-mapping-1.4-20101230.233910-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d09a-mapping-1.4-20101230.233910-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d09b-mapping-1.4" MODULE="d09b-mapping-1.4-20101231.000627-1.jar" MVN="mvn:org.talend.libraries/d09b-mapping-1.4-20101231.000627-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d09b-mapping-1.4-20101231.000627-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d93a-mapping-1.4" MODULE="d93a-mapping-1.4-20101231.003027-1.jar" MVN="mvn:org.talend.libraries/d93a-mapping-1.4-20101231.003027-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d93a-mapping-1.4-20101231.003027-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d94a-mapping-1.4" MODULE="d94a-mapping-1.4-20101231.004159-1.jar" MVN="mvn:org.talend.libraries/d94a-mapping-1.4-20101231.004159-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d94a-mapping-1.4-20101231.004159-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d94b-mapping-1.4" MODULE="d94b-mapping-1.4-20101231.005548-1.jar" MVN="mvn:org.talend.libraries/d94b-mapping-1.4-20101231.005548-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d94b-mapping-1.4-20101231.005548-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d95a-mapping-1.4" MODULE="d95a-mapping-1.4-20101231.010614-1.jar" MVN="mvn:org.talend.libraries/d95a-mapping-1.4-20101231.010614-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d95a-mapping-1.4-20101231.010614-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d95b-mapping-1.4" MODULE="d95b-mapping-1.4-20101231.012144-1.jar" MVN="mvn:org.talend.libraries/d95b-mapping-1.4-20101231.012144-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d95b-mapping-1.4-20101231.012144-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d96a-mapping-1.4" MODULE="d96a-mapping-1.4-20101231.013900-1.jar" MVN="mvn:org.talend.libraries/d96a-mapping-1.4-20101231.013900-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d96a-mapping-1.4-20101231.013900-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d96b-mapping-1.4" MODULE="d96b-mapping-1.4-20101231.015118-1.jar" MVN="mvn:org.talend.libraries/d96b-mapping-1.4-20101231.015118-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d96b-mapping-1.4-20101231.015118-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d97a-mapping-1.4" MODULE="d97a-mapping-1.4-20101231.020712-1.jar" MVN="mvn:org.talend.libraries/d97a-mapping-1.4-20101231.020712-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d97a-mapping-1.4-20101231.020712-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d97b-mapping-1.4" MODULE="d97b-mapping-1.4-20101231.022307-1.jar" MVN="mvn:org.talend.libraries/d97b-mapping-1.4-20101231.022307-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d97b-mapping-1.4-20101231.022307-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d98a-mapping-1.4" MODULE="d98a-mapping-1.4-20101231.023634-1.jar" MVN="mvn:org.talend.libraries/d98a-mapping-1.4-20101231.023634-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d98a-mapping-1.4-20101231.023634-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d98b-mapping-1.4" MODULE="d98b-mapping-1.4-20101231.025003-1.jar" MVN="mvn:org.talend.libraries/d98b-mapping-1.4-20101231.025003-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d98b-mapping-1.4-20101231.025003-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d99a-mapping-1.4" MODULE="d99a-mapping-1.4-20101231.030914-1.jar" MVN="mvn:org.talend.libraries/d99a-mapping-1.4-20101231.030914-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d99a-mapping-1.4-20101231.030914-1.jar"
-				REQUIRED="true" />
-			<IMPORT NAME="d99b-mapping-1.4" MODULE="d99b-mapping-1.4-20101231.032348-1.jar" MVN="mvn:org.talend.libraries/d99b-mapping-1.4-20101231.032348-1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.edifact/lib/d99b-mapping-1.4-20101231.032348-1.jar"
-				REQUIRED="true" />
+			<IMPORT NAME="d00a-mapping-1.4" MODULE="d00a-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d00a-mapping/1.4" 
+			    REQUIRED="true" />
+			<IMPORT NAME="d00b-mapping-1.4" MODULE="d00b-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d00b-mapping/1.4" 
+			    REQUIRED="true" />
+			<IMPORT NAME="d01a-mapping-1.4" MODULE="d01a-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d01a-mapping/1.4" 
+			    REQUIRED="true" />
+			<IMPORT NAME="d01b-mapping-1.4" MODULE="d01b-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d01b-mapping/1.4" 
+			    REQUIRED="true" />
+			<IMPORT NAME="d01c-mapping-1.4" MODULE="d01c-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d01c-mapping/1.4" 
+			    REQUIRED="true" />
+			<IMPORT NAME="d02a-mapping-1.4" MODULE="d02a-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d02a-mapping/1.4" 
+			    REQUIRED="true" />
+			<IMPORT NAME="d02b-mapping-1.4" MODULE="d02b-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d02b-mapping/1.4" 
+			    REQUIRED="true" />
+			<IMPORT NAME="d03a-mapping-1.4" MODULE="d03a-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d03a-mapping/1.4" 
+			    REQUIRED="true" />
+			<IMPORT NAME="d03b-mapping-1.4" MODULE="d03b-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d03b-mapping/1.4" 
+			    REQUIRED="true" />
+			<IMPORT NAME="d04a-mapping-1.4" MODULE="d04a-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d04a-mapping/1.4" 
+			    REQUIRED="true" />
+			<IMPORT NAME="d04b-mapping-1.4" MODULE="d04b-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d04b-mapping/1.4" 
+			    REQUIRED="true" />
+			<IMPORT NAME="d05a-mapping-1.4" MODULE="d05a-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d05a-mapping/1.4" 
+			    REQUIRED="true" />
+			<IMPORT NAME="d05b-mapping-1.4" MODULE="d05b-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d05b-mapping/1.4" 
+			    REQUIRED="true" />
+			<IMPORT NAME="d06a-mapping-1.4" MODULE="d06a-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d06a-mapping/1.4" 
+			    REQUIRED="true" />
+			<IMPORT NAME="d06b-mapping-1.4" MODULE="d06b-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d06b-mapping/1.4" 
+			    REQUIRED="true" />
+			<IMPORT NAME="d07a-mapping-1.4" MODULE="d07a-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d07a-mapping/1.4" 
+			    REQUIRED="true" />
+			<IMPORT NAME="d07b-mapping-1.4" MODULE="d07b-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d07b-mapping/1.4" 
+			    REQUIRED="true" />
+			<IMPORT NAME="d08a-mapping-1.4" MODULE="d08a-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d08a-mapping/1.4" 
+			    REQUIRED="true" />
+			<IMPORT NAME="d08b-mapping-1.4" MODULE="d08b-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d08b-mapping/1.4" 
+			    REQUIRED="true" />
+			<IMPORT NAME="d09a-mapping-1.4" MODULE="d09a-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d09a-mapping/1.4" 
+			    REQUIRED="true" />
+			<IMPORT NAME="d09b-mapping-1.4" MODULE="d09b-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d09b-mapping/1.4" 
+			    REQUIRED="true" />
+			<IMPORT NAME="d93a-mapping-1.4" MODULE="d93a-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d93a-mapping/1.4" 
+			    REQUIRED="true" />
+			<IMPORT NAME="d94a-mapping-1.4" MODULE="d94a-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d94a-mapping/1.4" 
+			    REQUIRED="true" />
+			<IMPORT NAME="d94b-mapping-1.4" MODULE="d94b-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d94b-mapping/1.4" 
+			    REQUIRED="true" />
+			<IMPORT NAME="d95a-mapping-1.4" MODULE="d95a-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d95a-mapping/1.4" 
+			    REQUIRED="true" />
+			<IMPORT NAME="d95b-mapping-1.4" MODULE="d95b-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d95b-mapping/1.4" 
+			    REQUIRED="true" />
+			<IMPORT NAME="d96a-mapping-1.4" MODULE="d96a-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d96a-mapping/1.4" 
+			    REQUIRED="true" />
+			<IMPORT NAME="d96b-mapping-1.4" MODULE="d96b-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d96b-mapping/1.4"
+			    REQUIRED="true" />
+			<IMPORT NAME="d97a-mapping-1.4" MODULE="d97a-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d97a-mapping/1.4"
+			    REQUIRED="true" />
+			<IMPORT NAME="d97b-mapping-1.4" MODULE="d97b-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d97b-mapping/1.4"
+			    REQUIRED="true" />
+			<IMPORT NAME="d98a-mapping-1.4" MODULE="d98a-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d98a-mapping/1.4"
+			    REQUIRED="true" />
+			<IMPORT NAME="d98b-mapping-1.4" MODULE="d98b-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d98b-mapping/1.4"
+			    REQUIRED="true" />
+			<IMPORT NAME="d99a-mapping-1.4" MODULE="d99a-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d99a-mapping/1.4"
+			    REQUIRED="true" />
+			<IMPORT NAME="d99b-mapping-1.4" MODULE="d99b-mapping-1.4.jar" MVN="mvn:org.milyn.edi.unedifact/d99b-mapping/1.4"
+			    REQUIRED="true" />
 			<IMPORT NAME="mylin-smooks" MODULE="milyn-smooks-all-1.7.0.jar" MVN="mvn:org.talend.libraries/milyn-smooks-all-1.7.0/6.0.0"
 				REQUIRED="true" />
 			<IMPORT NAME="jaxen" MODULE="jaxen-1.1.6.jar" MVN="mvn:jaxen/jaxen/1.1.6" BundleID="org.apache.servicemix.bundles.jaxen"
 				REQUIRED="true" />
-			<IMPORT NAME="commons-logging" MODULE="commons-logging-1.1.jar" MVN="mvn:org.talend.libraries/commons-logging-1.1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.apache.common/lib/commons-logging-1.1.jar"
+			<IMPORT NAME="commons-logging" MODULE="commons-logging-1.1.jar" MVN="mvn:commons-logging/commons-logging/1.1"  UrlPath="platform:/plugin/org.talend.libraries.apache.common/lib/commons-logging-1.1.jar"
 				REQUIRED="true" />
 			<IMPORT NAME="commons-collections" MODULE="commons-collections-3.2.2.jar" MVN="mvn:commons-collections/commons-collections/3.2.2"  UrlPath="platform:/plugin/org.talend.libraries.apache.common/lib/commons-collections-3.2.2.jar"
 				REQUIRED="true" />

main/plugins/org.talend.designer.components.localprovider/components/tEDIFACTtoXML/tEDIFACTtoXML_main.javajet

@@ -23,7 +23,7 @@ imports="
 	String ignoreNewLines = ElementParameterParser.getValue(node, "__IGNORE_NEW_LINE__");
 %>
 
-String modelURI_<%=cid%> = "urn:org.milyn.edi.unedifact:"+"<%=version%>"+"-mapping:1.4-SNAPSHOT";
+String modelURI_<%=cid%> = "urn:org.milyn.edi.unedifact:"+"<%=version%>"+"-mapping:1.4";
 
 org.milyn.edisax.unedifact.UNEdifactInterchangeParser parser_<%=cid%> = new org.milyn.edisax.unedifact.UNEdifactInterchangeParser();
 

main/plugins/org.talend.designer.components.localprovider/components/tELTMap/tELTMap_java.xml

@@ -56,7 +56,7 @@
 	   <PARAMETER
 	     NAME="CONNECTION"
 	     FIELD="COMPONENT_LIST"
-	     REQUIRED="true" FILTER="REGEXP:^tJDBCConnection|tSnowflakeConnection|tSAPHanaConnection|tDeltaLakeConnection$"
+	     REQUIRED="true" FILTER="REGEXP:^JDBCConnection|tSnowflakeConnection|tSAPHanaConnection|tDeltaLakeConnection$"
 	     NUM_ROW="2"
 	     SHOW_IF="(#LINK@CONNECTOR.OUT.TABLE_REF == '0') AND (USE_EXISTING_CONNECTION == 'true')"
 	     DYNAMIC_SETTINGS="true"/>

main/plugins/org.talend.designer.components.localprovider/components/tELTNode/tELTNode_begin.javajet

@@ -221,7 +221,7 @@
         	} else if("MYSQL".equals(dbType)){
         		return "`";
         	}
-        	String[] array_types = new String[]{"DB2","GREENPLUM","POSTGRE","POSTGREPLUS","PARACCEL","INGRES","SQLITE","TERADATA","INTERBASE"};
+        	String[] array_types = new String[]{"DB2","GREENPLUM","POSTGRE","PARACCEL","INGRES","SQLITE","TERADATA","INTERBASE"};
         	for(String db :array_types){
         		if(db.equals(dbType)){
         			return "\\\"";

main/plugins/org.talend.designer.components.localprovider/components/tELTOracleMap/tELTOracleMap_java.xml

@@ -259,7 +259,7 @@
      <IMPORTS>
        <IMPORT NAME="ORACLE_18" MODULE="ojdbc8-19.19.0.0.jar" MVN="mvn:com.oracle.database.jdbc/ojdbc8/19.19.0.0" REQUIRED_IF="(DB_VERSION == 'ORACLE_18') AND (USE_EXISTING_CONNECTION == 'false')" />
        <IMPORT NAME="ORACLE_12" MODULE="ojdbc7.jar" MVN="mvn:org.talend.libraries/ojdbc7/6.0.0"  REQUIRED_IF="(DB_VERSION == 'ORACLE_12') AND (USE_EXISTING_CONNECTION == 'false')" />
-       <IMPORT NAME="ORACLE_11" MODULE="ojdbc6.jar" MVN="mvn:org.talend.libraries/ojdbc6/6.0.0"  REQUIRED_IF="(DB_VERSION == 'ORACLE_11') AND (USE_EXISTING_CONNECTION == 'false')" />
+       <IMPORT NAME="ORACLE_11" MODULE="ojdbc6-11.2.0.4.jar" MVN="mvn:com.oracle.database.jdbc/ojdbc6/11.2.0.4"  REQUIRED_IF="(DB_VERSION == 'ORACLE_11') AND (USE_EXISTING_CONNECTION == 'false')" />
      </IMPORTS>
    </CODEGENERATION>
 

main/plugins/org.talend.designer.components.localprovider/components/tExtractJSONFields/tExtractJSONFields_java.xml

@@ -184,15 +184,15 @@
             <IMPORT NAME="Java_JAXEN_1.1.6" MODULE="jaxen-1.1.6.jar" MVN="mvn:jaxen/jaxen/1.1.6" REQUIRED_IF="READ_BY == 'XPATH'" BundleID="" />
             <IMPORT NAME="json-lib" MODULE="json-lib-2.4.8-talend.jar" MVN="mvn:net.sf.json-lib/json-lib/2.4.8-talend" REQUIRED_IF="READ_BY == 'XPATH'" />
             <IMPORT NAME="commons_lang" MODULE="commons-lang-2.6.jar" MVN="mvn:commons-lang/commons-lang/2.6"  UrlPath="platform:/plugin/org.talend.libraries.apache.common/lib/commons-lang-2.6.jar" REQUIRED_IF="READ_BY == 'XPATH'" />
-            <IMPORT NAME="commons_logging" MODULE="commons-logging-1.1.1.jar" MVN="mvn:org.talend.libraries/commons-logging-1.1.1/6.0.0"  UrlPath="platform:/base/plugins/org.apache.commons.logging_1.1.1.v201101211721.jar" REQUIRED_IF="READ_BY == 'XPATH'" />
-            <IMPORT NAME="ezmorph" MODULE="ezmorph-1.0.6.jar" MVN="mvn:org.talend.libraries/ezmorph-1.0.6/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.jackson/lib/ezmorph-1.0.6.jar" REQUIRED_IF="READ_BY == 'XPATH'" />
+            <IMPORT NAME="commons_logging" MODULE="commons-logging-1.1.1.jar" MVN="mvn:commons-logging/commons-logging/1.1.1"  UrlPath="platform:/base/plugins/org.apache.commons.logging_1.1.1.v201101211721.jar" REQUIRED_IF="READ_BY == 'XPATH'" />
+            <IMPORT NAME="ezmorph" MODULE="ezmorph-1.0.6.jar" MVN="mvn:net.sf.ezmorph/ezmorph/1.0.6"  UrlPath="platform:/plugin/org.talend.libraries.jackson/lib/ezmorph-1.0.6.jar" REQUIRED_IF="READ_BY == 'XPATH'" />
             <IMPORT NAME="xom" MODULE="xom-1.2.7.jar" MVN="mvn:org.talend.libraries/xom-1.2.7/6.0.0"  REQUIRED_IF="READ_BY == 'XPATH'" />
             <IMPORT NAME="commons_beanutils" MODULE="commons-beanutils-1.9.4.jar" MVN="mvn:commons-beanutils/commons-beanutils/1.9.4" REQUIRED_IF="READ_BY == 'XPATH'" />
             <IMPORT NAME="commons_collections" MODULE="commons-collections-3.2.2.jar" MVN="mvn:commons-collections/commons-collections/3.2.2"  UrlPath="platform:/plugin/org.talend.libraries.apache.common/lib/commons-collections-3.2.2.jar" REQUIRED_IF="READ_BY == 'XPATH'" />
-            <IMPORT NAME="staxon" MODULE="staxon-1.2.jar" MVN="mvn:org.talend.libraries/staxon-1.2/6.0.0" UrlPath="platform:/plugin/org.talend.libraries.json/lib/staxon-1.2.jar" REQUIRED_IF="READ_BY == 'XPATH'" />
+            <IMPORT NAME="staxon" MODULE="staxon-1.2.jar" MVN="mvn:de.odysseus.staxon/staxon/1.2" UrlPath="platform:/plugin/org.talend.libraries.json/lib/staxon-1.2.jar" REQUIRED_IF="READ_BY == 'XPATH'" />
             
-            <IMPORT NAME="json-path-2.1.0.jar" MODULE="json-path-2.1.0.jar" MVN="mvn:org.talend.libraries/json-path-2.1.0/6.0.0" UrlPath="platform:/plugin/org.talend.libraries.json/lib/json-path-2.1.0.jar" REQUIRED_IF="(READ_BY == 'JSONPATH') AND (JSON_PATH_VERSION == '2_1_0')" />
-            <IMPORT NAME="json-path-1.2.0.jar" MODULE="json-path-1.2.0.jar" MVN="mvn:org.talend.libraries/json-path-1.2.0/6.0.0" UrlPath="platform:/plugin/org.talend.libraries.json/lib/json-path-1.2.0.jar" REQUIRED_IF="(READ_BY == 'JSONPATH') AND (JSON_PATH_VERSION == '1_2_0')" />
+            <IMPORT NAME="json-path-2.1.0.jar" MODULE="json-path-2.1.0.jar" MVN="mvn:com.jayway.jsonpath/json-path/2.1.0" UrlPath="platform:/plugin/org.talend.libraries.json/lib/json-path-2.1.0.jar" REQUIRED_IF="(READ_BY == 'JSONPATH') AND (JSON_PATH_VERSION == '2_1_0')" />
+            <IMPORT NAME="json-path-1.2.0.jar" MODULE="json-path-1.2.0.jar" MVN="mvn:com.jayway.jsonpath/json-path/1.2.0" UrlPath="platform:/plugin/org.talend.libraries.json/lib/json-path-1.2.0.jar" REQUIRED_IF="(READ_BY == 'JSONPATH') AND (JSON_PATH_VERSION == '1_2_0')" />
             
             <IMPORT NAME="json-smart-2.4.11.jar" MODULE="json-smart-2.4.11.jar" MVN="mvn:net.minidev/json-smart/2.4.11"  REQUIRED_IF="READ_BY == 'JSONPATH'" />
             <IMPORT NAME="accessors-smart-2.4.11.jar" MODULE="accessors-smart-2.4.11.jar" MVN="mvn:net.minidev/accessors-smart/2.4.11"  REQUIRED_IF="READ_BY == 'JSONPATH'" />

main/plugins/org.talend.designer.components.localprovider/components/tFTPPut/tFTPPut_java.xml

@@ -346,7 +346,15 @@ COMPATIBILITY="ALL"
 			NUM_ROW="100" SHOW_IF="USE_EXISTING_CONNECTION == 'false'" REPOSITORY_VALUE="USE_STRICT_REPLY_PARSING">
 			<DEFAULT>true</DEFAULT>
 		</PARAMETER>
-		
+
+		<PARAMETER
+			NAME="RENAME_AFTER"
+			FIELD="CHECK"
+			NUM_ROW="105"
+			SHOW="true"
+		>
+			<DEFAULT>false</DEFAULT>
+		</PARAMETER>
 		<PARAMETER
 	        NAME="CONFIG_CLIENT"
 	        FIELD="CHECK"

main/plugins/org.talend.designer.components.localprovider/components/tFTPPut/tFTPPut_main.javajet

@@ -21,6 +21,7 @@
     String connection = ElementParameterParser.getValue(node, "__CONNECTION__");
     String useExistingConn = ElementParameterParser.getValue(node, "__USE_EXISTING_CONNECTION__");
     boolean sftp = false;
+    boolean renameAfterUpload = ("true").equals(ElementParameterParser.getValue(node, "__RENAME_AFTER__"));
     boolean ftps = false;
     boolean isLog4jEnabled = ("true").equals(ElementParameterParser.getValue(node.getProcess(), "__LOG4J_ACTIVATE__"));
     boolean useGlob = ("true").equals(ElementParameterParser.getValue(node, "__PERL5_REGEX__"));
@@ -105,12 +106,21 @@ try{
                         }
                         String destRename_<%= cid %> =  map<%=cid %>.get(key<%=cid %>);
                         final String dest_<%=cid%>;
-                        if (destRename_<%= cid %> == null || destRename_<%= cid %>.isEmpty()) {
-                            dest_<%=cid%> = remoteDir_<%=cid%> + "/" + listings<%=cid %>[m<%=cid %>].getName();
-                        }
-                        else {
-                            dest_<%=cid%> = remoteDir_<%=cid%> + "/" + destRename_<%= cid %>;
-                        }
+<%
+                            if (renameAfterUpload) {
+%>
+                                dest_<%=cid%> = remoteDir_<%=cid%>+"/"+listings<%=cid %>[m<%=cid %>].getName();
+<%
+                            } else {
+%>
+                                if (destRename_<%= cid %> == null || destRename_<%= cid %>.isEmpty()) {
+                                    dest_<%=cid%> = remoteDir_<%=cid%> + "/" + listings<%=cid %>[m<%=cid %>].getName();
+                                } else {
+                                    dest_<%=cid%> = remoteDir_<%=cid%> + "/" + destRename_<%= cid %>;
+                                }
+<%
+                            }
+%>
                         
                         try{
                             c_<%=cid%>.put(listings<%=cid %>[m<%=cid %>].getAbsolutePath(), dest_<%=cid%>, monitor<%=cid%>, mode<%=cid%>);
@@ -171,6 +181,32 @@ globalMap.put("<%=cid%>_ERROR_MESSAGE",e_<%=cid%>.getMessage());
                 <%}%>
                 System.err.println("No matches found for mask '" + key<%=cid %> + "'!");
             }
+<%
+            if (renameAfterUpload) {
+%>
+                //do rename
+                if (!((map<%=cid %>.get(key<%=cid %>) == null) || map<%=cid %>.get(key<%=cid %>).isEmpty() || key<%=cid %>.equals(map<%=cid %>.get(key<%=cid %>)))){
+                    <%
+                    if(("overwrite").equals(sftpoverwrite) || ("resume").equals(sftpoverwrite)){
+                    %>
+                        try{
+                            c_<%=cid%>.rm(<%=remotedir %>+"/"+map<%=cid %>.get(key<%=cid %>));
+                        }catch(com.jcraft.jsch.SftpException e_<%=cid%>){
+                        }
+                    <%
+                    }
+                    %>
+                    try{
+                        c_<%=cid%>.rename(<%=remotedir %>+"/"+key<%=cid %>, <%=remotedir %>+"/"+map<%=cid %>.get(key<%=cid %>));
+                        globalMap.put("<%=cid %>_CURRENT_STATUS", "File rename OK.");
+                    }catch(com.jcraft.jsch.SftpException e_<%=cid%>){
+                        globalMap.put("<%=cid %>_CURRENT_STATUS", "File rename fail.");
+                        throw e_<%=cid%>;
+                    }
+                }
+<%
+            }
+%>
                     }
 
 <%
@@ -292,12 +328,21 @@ globalMap.put("<%=cid%>_ERROR_MESSAGE",e_<%=cid%>.getMessage());
                         
                         final String destRename_<%= cid %> =  map<%=cid %>.get(key<%=cid %>);
                         final String dest_<%=cid%>;
-                        if (destRename_<%= cid %> == null || destRename_<%= cid %>.isEmpty()) {
+<%
+                        if (renameAfterUpload) {
+%>
                             dest_<%=cid%> = listings<%=cid %>[m<%=cid %>].getName();
+<%
+                        } else {
+%>
+                            if (destRename_<%= cid %> == null || destRename_<%= cid %>.isEmpty()) {
+                                dest_<%=cid%> = listings<%=cid %>[m<%=cid %>].getName();
+                            } else {
+                                dest_<%=cid%> = destRename_<%= cid %>;
+                            }
+<%
                         }
-                        else {
-                            dest_<%=cid%> = destRename_<%= cid %>;
-                        }
+%>
                         globalMap.put("<%=cid %>_CURRENT_FILE_EXISTS", remoteExistsFiles_<%=cid%>.contains(dest_<%=cid%>));
                         
 <%
@@ -360,6 +405,26 @@ globalMap.put("<%=cid%>_ERROR_MESSAGE",e_<%=cid%>.getMessage());
                                             + file_in_localDir_<%=cid%>.length() + " bytes upload successfully");
 <%
                         }
+%>
+<%
+                        if (renameAfterUpload) {
+%>
+                            //do rename
+                            if (destRename_<%= cid %> != null && !destRename_<%= cid %>.isEmpty() && ! destRename_<%= cid %>.equals(dest_<%=cid%>)) {
+<%
+                                if(!"never".equals(ftpsoverwrite)){
+%>
+                                    if ((remoteExistsFiles_<%=cid%>.contains(destRename_<%=cid%>))){
+                                        ftpExecutorAndChecker_<%=cid %>.executeAndCheckResult(() -> effectivelyFinalFtp_<%=cid %>.deleteFile(destRename_<%= cid %>));
+                                    }
+<%
+                                }
+%>
+                                ftpExecutorAndChecker_<%=cid %>.executeAndCheckResult(() -> effectivelyFinalFtp_<%=cid %>.rename(dest_<%=cid%>, destRename_<%= cid %>));
+                                globalMap.put("<%=cid %>_CURRENT_STATUS", "File rename OK.");
+                            }
+<%
+                        }
 %>
                         nb_file_<%=cid%>++;
                     }

main/plugins/org.talend.designer.components.localprovider/components/tFTPPut/tFTPPut_messages.properties

@@ -71,3 +71,4 @@ CONFIG_CLIENT.NAME=Config client
 CLIENT_PARAMETERS.NAME=
 CLIENT_PARAMETERS.ITEM.PARAMETER=Client parameter
 CLIENT_PARAMETERS.ITEM.VALUE=Value
+RENAME_AFTER.NAME=Rename after upload/on remote

main/plugins/org.talend.designer.components.localprovider/components/tFTPPut/tFTPPut_messages_fr.properties

@@ -71,3 +71,4 @@ CONFIG_CLIENT.NAME=Config client
 CLIENT_PARAMETERS.NAME=
 CLIENT_PARAMETERS.ITEM.PARAMETER=Param\u00E8tre client
 CLIENT_PARAMETERS.ITEM.VALUE=Valeur
+RENAME_AFTER.NAME=Renommer apr\u00E8s chargement/\u00E0 distance

main/plugins/org.talend.designer.components.localprovider/components/tFTPPut/tFTPPut_messages_ja.properties

@@ -71,3 +71,4 @@ CONFIG_CLIENT.NAME=\u30AF\u30E9\u30A4\u30A2\u30F3\u30C8\u8A2D\u5B9A
 CLIENT_PARAMETERS.NAME=
 CLIENT_PARAMETERS.ITEM.PARAMETER=\u30AF\u30E9\u30A4\u30A2\u30F3\u30C8\u30D1\u30E9\u30E1\u30FC\u30BF\u30FC
 CLIENT_PARAMETERS.ITEM.VALUE=\u5024
+RENAME_AFTER.NAME=\u30A2\u30C3\u30D7\u30ED\u30FC\u30C9\u5F8C/\u30EA\u30E2\u30FC\u30C8\u3067\u540D\u524D\u3092\u5909\u66F4

main/plugins/org.talend.designer.components.localprovider/components/tFTPPut/tFTPPut_messages_zh_CN.properties

@@ -71,3 +71,4 @@ CONFIG_CLIENT.NAME=\u914D\u7F6E\u5BA2\u6237\u7AEF
 CLIENT_PARAMETERS.NAME=
 CLIENT_PARAMETERS.ITEM.PARAMETER=\u5BA2\u6237\u7AEF\u53C2\u6570
 CLIENT_PARAMETERS.ITEM.VALUE=\u503C
+RENAME_AFTER.NAME=\u4E0A\u4F20\u540E/\u8FDC\u7A0B\u65F6\u91CD\u547D\u540D

main/plugins/org.talend.designer.components.localprovider/components/tFileFetch/tFileFetch_java.xml

@@ -433,7 +433,7 @@
             <IMPORT NAME="httpclient-4.5.13" MODULE="httpclient-4.5.13.jar" MVN="mvn:org.apache.httpcomponents/httpclient/4.5.13" REQUIRED_IF="(PROTO == 'HTTP_PROTO') or (PROTO == 'HTTPS_PROTO')" />
             <IMPORT NAME="httpcore-4.4.13" MODULE="httpcore-4.4.13.jar" MVN="mvn:org.apache.httpcomponents/httpcore/4.4.13" REQUIRED_IF="(PROTO == 'HTTP_PROTO') or (PROTO == 'HTTPS_PROTO')" />
             <IMPORT NAME="httpmime-4.5.13" MODULE="httpmime-4.5.13.jar" MVN="mvn:org.apache.httpcomponents/httpmime/4.5.13" REQUIRED_IF="(PROTO == 'HTTP_PROTO') or (PROTO == 'HTTPS_PROTO')" />
-            <IMPORT NAME="COMMONS-Logging" MODULE="commons-logging-1.1.jar" MVN="mvn:org.talend.libraries/commons-logging-1.1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.apache.common/lib/commons-logging-1.1.jar" REQUIRED_IF="(PROTO == 'HTTP_PROTO') or (PROTO == 'HTTPS_PROTO')" />
+            <IMPORT NAME="COMMONS-Logging" MODULE="commons-logging-1.1.jar" MVN="mvn:commons-logging/commons-logging/1.1"  UrlPath="platform:/plugin/org.talend.libraries.apache.common/lib/commons-logging-1.1.jar" REQUIRED_IF="(PROTO == 'HTTP_PROTO') or (PROTO == 'HTTPS_PROTO')" />
             <IMPORT NAME="commons-codec-1.14" MODULE="commons-codec-1.14.jar" MVN="mvn:commons-codec/commons-codec/1.14" REQUIRED_IF="(PROTO == 'HTTP_PROTO') or (PROTO == 'HTTPS_PROTO')" />
             <IMPORT NAME="jcifs-samba" MODULE="jcifs-1.3.0.jar" MVN="mvn:org.talend.libraries/jcifs-1.3.0/6.0.0"  REQUIRED_IF="(PROTO == 'SAMBA_PROTO')" />
         </IMPORTS>

main/plugins/org.talend.designer.components.localprovider/components/tFileFetch/tFileFetch_main.javajet

@@ -244,11 +244,6 @@ org.apache.http.client.CredentialsProvider credsProvider_<%=cid %> = new org.apa
 	<%}%>
 	final org.apache.http.client.config.RequestConfig.Builder builder_<%=cid%> = org.apache.http.client.config.RequestConfig.custom();
 	builder_<%=cid%>.setConnectTimeout(<%=timeout %>);
-	<%if(isLog4jEnabled){%>
-		log.info("<%=cid%> - Connection to '" +  <%=uri %> + "' has succeeded.");
-	<%
-	}
-	%>
         org.apache.http.conn.util.PublicSuffixMatcher publicSuffixMatcher_<%=cid%> = org.apache.http.conn.util.PublicSuffixMatcherLoader.getDefault();
         org.apache.http.config.Registry<org.apache.http.cookie.CookieSpecProvider> cookieSpecReg_<%=cid%> = org.apache.http.config.RegistryBuilder.<org.apache.http.cookie.CookieSpecProvider>create()
                 .register(org.apache.http.client.config.CookieSpecs.DEFAULT, new org.apache.http.impl.cookie.DefaultCookieSpecProvider(org.apache.http.impl.cookie.DefaultCookieSpecProvider.CompatibilityLevel.DEFAULT, publicSuffixMatcher_<%=cid%>, null, <%=singleCookie%>))
@@ -258,7 +253,7 @@ org.apache.http.client.CredentialsProvider credsProvider_<%=cid %> = new org.apa
         final org.apache.http.client.protocol.HttpClientContext context_<%=cid%> = org.apache.http.client.protocol.HttpClientContext.create();
         context_<%=cid%>.setCookieSpecRegistry(cookieSpecReg_<%=cid%>);
         context_<%=cid%>.setCookieStore(cookieStore_<%=cid%>);
-
+        context_<%=cid%>.setRequestConfig(builder_<%=cid%>.build());
 
 	<%if (readCookie) {%>
 		List<org.apache.http.cookie.Cookie> cookieList_<%=cid%> = null;

main/plugins/org.talend.designer.components.localprovider/components/tFileInputExcel/tFileInputExcel_begin.javajet

@@ -300,8 +300,8 @@ globalMap.put("<%=cid%>_ERROR_MESSAGE",e.getMessage());
         	}
         }
 		sheetList_<%= cid %> = sheet_FilterNullList_<%= cid %>;
-	if(sheetList_<%= cid %>.size()>0){
         int nb_line_<%= cid %> = 0;
+	if(sheetList_<%= cid %>.size()>0){
 
         int begin_line_<%= cid %> = <%if(("").equals(header.trim())){%>0<%}else{%><%= header %><%}%>;
 
@@ -755,8 +755,8 @@ globalMap.put("<%=cid%>_ERROR_MESSAGE",e.getMessage());
 			}
 		}
 		sheetList_<%=cid%> = sheetList_FilterNull_<%=cid%>;
-	if(sheetList_<%= cid %>.size()>0){
 		int nb_line_<%= cid %> = 0;
+	if(sheetList_<%= cid %>.size()>0){
 
         int begin_line_<%= cid %> = <%if(("").equals(header.trim())){%>0<%}else{%><%= header %><%}%>;
 

main/plugins/org.talend.designer.components.localprovider/components/tFileInputExcel/tFileInputExcel_end.javajet

@@ -40,11 +40,12 @@ globalMap.put("<%=cid%>_ERROR_MESSAGE",e_<%=cid%>.getMessage());
 			<%}%>
 			<%log4jFileUtil.retrievedDataNumberInfo(node);%>
 			
-			globalMap.put("<%=cid %>_NB_LINE",nb_line_<%=cid %>);
 			<%if((version07 && !eventMode) || !version07) {%>
 				}
 			<%}//Bug TDI-25655%>
-		} finally { 
+
+			globalMap.put("<%=cid %>_NB_LINE",nb_line_<%=cid %>);
+		} finally {
 				<%if(!version07){%>
 					if(!(source_<%=cid %> instanceof java.io.InputStream)){
 						workbook_<%=cid %>.close();

main/plugins/org.talend.designer.components.localprovider/components/tFileInputExcel/tFileInputExcel_java.xml

@@ -186,7 +186,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="Java_Excel" MODULE="jxl-2.6.12.jar" MVN="mvn:net.sourceforge.jexcelapi/jxl/2.6.12"  UrlPath="platform:/plugin/org.talend.libraries.jexcel/lib/jxl.jar" REQUIRED_IF="(VERSION_2007 == 'false')" />
 			<IMPORT NAME="simpleexcel" MODULE="simpleexcel-2.9-20230830.jar" MVN="mvn:org.talend.components/simpleexcel/2.9-20230830" UrlPath="platform:/plugin/org.talend.libraries.excel/lib/simpleexcel-2.9-20230830.jar" 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.22" MODULE="reload4j-1.2.22.jar" MVN="mvn:ch.qos.reload4j/reload4j/1.2.22" REQUIRED_IF="(VERSION_2007 == 'true')" BundleID="" />

main/plugins/org.talend.designer.components.localprovider/components/tFileInputJSON/tFileInputJSON_java.xml

@@ -164,7 +164,7 @@
 	<CODEGENERATION>
 		<IMPORTS>
 			<!-- json path by javascript api -->
-			<IMPORT NAME="json_simple" MODULE="json_simple-1.1.jar" MVN="mvn:org.talend.libraries/json_simple-1.1/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.jackson/lib/json_simple-1.1.jar"
+			<IMPORT NAME="json_simple" MODULE="json-simple-1.1.jar" MVN="mvn:com.googlecode.json-simple/json-simple/1.1"  UrlPath="platform:/plugin/org.talend.libraries.jackson/lib/json_simple-1.1.jar"
 				REQUIRED_IF="(READ_BY == 'JSONPATH_WITHOUTPUT_LOOP')" />
 			<IMPORT NAME="jsonpath" MODULE="jsonpath.jar" MVN="mvn:org.talend.libraries/jsonpath/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.jackson/lib/jsonpath.jar"
 			    REQUIRED_IF="(READ_BY == 'JSONPATH_WITHOUTPUT_LOOP')" />
@@ -175,9 +175,9 @@
 			<IMPORT NAME="json-lib" MODULE="json-lib-2.4.8-talend.jar" MVN="mvn:net.sf.json-lib/json-lib/2.4.8-talend" REQUIRED_IF="(READ_BY == 'XPATH')" />
 			<IMPORT NAME="commons_lang" MODULE="commons-lang-2.6.jar" MVN="mvn:commons-lang/commons-lang/2.6"  UrlPath="platform:/plugin/org.talend.libraries.apache.common/lib/commons-lang-2.6.jar"
 				REQUIRED_IF="(READ_BY == 'XPATH')" />
-			<IMPORT NAME="commons_logging" MODULE="commons-logging-1.1.1.jar" MVN="mvn:org.talend.libraries/commons-logging-1.1.1/6.0.0"  UrlPath="platform:/base/plugins/org.apache.commons.logging_1.1.1.v201101211721.jar"
+			<IMPORT NAME="commons_logging" MODULE="commons-logging-1.1.1.jar" MVN="mvn:commons-logging/commons-logging/1.1.1"  UrlPath="platform:/base/plugins/org.apache.commons.logging_1.1.1.v201101211721.jar"
 				REQUIRED_IF="(READ_BY == 'XPATH')" BundleID="" />
-			<IMPORT NAME="ezmorph" MODULE="ezmorph-1.0.6.jar" MVN="mvn:org.talend.libraries/ezmorph-1.0.6/6.0.0"  UrlPath="platform:/plugin/org.talend.libraries.jackson/lib/ezmorph-1.0.6.jar"
+			<IMPORT NAME="ezmorph" MODULE="ezmorph-1.0.6.jar" MVN="mvn:net.sf.ezmorph/ezmorph/1.0.6"  UrlPath="platform:/plugin/org.talend.libraries.jackson/lib/ezmorph-1.0.6.jar"
 			    REQUIRED_IF="(READ_BY == 'XPATH')" />
 			<IMPORT NAME="xom" MODULE="xom-1.2.7.jar" MVN="mvn:org.talend.libraries/xom-1.2.7/6.0.0"
 			    REQUIRED_IF="(READ_BY == 'XPATH')" />
@@ -185,13 +185,13 @@
 				REQUIRED_IF="(READ_BY == 'XPATH')" />
 			<IMPORT NAME="commons_collections" MODULE="commons-collections-3.2.2.jar" MVN="mvn:commons-collections/commons-collections/3.2.2"  UrlPath="platform:/plugin/org.talend.libraries.apache.common/lib/commons-collections-3.2.2.jar"
 				REQUIRED_IF="(READ_BY == 'XPATH')" />
-			<IMPORT NAME="staxon" MODULE="staxon-1.2.jar" MVN="mvn:org.talend.libraries/staxon-1.2/6.0.0" UrlPath="platform:/plugin/org.talend.libraries.json/lib/staxon-1.2.jar"
+			<IMPORT NAME="staxon" MODULE="staxon-1.2.jar" MVN="mvn:de.odysseus.staxon/staxon/1.2" UrlPath="platform:/plugin/org.talend.libraries.json/lib/staxon-1.2.jar"
 			    REQUIRED_IF="(READ_BY == 'XPATH')" />
 
 			<!-- json path -->
-			<IMPORT NAME="json-path-2.1.0.jar" MODULE="json-path-2.1.0.jar" MVN="mvn:org.talend.libraries/json-path-2.1.0/6.0.0" UrlPath="platform:/plugin/org.talend.libraries.json/lib/json-path-2.1.0.jar"
+			<IMPORT NAME="json-path-2.1.0.jar" MODULE="json-path-2.1.0.jar" MVN="mvn:com.jayway.jsonpath/json-path/2.1.0" UrlPath="platform:/plugin/org.talend.libraries.json/lib/json-path-2.1.0.jar"
 			    REQUIRED_IF="(READ_BY == 'JSONPATH') AND (JSON_PATH_VERSION == '2_1_0')" />
-			<IMPORT NAME="json-path-1.2.0.jar" MODULE="json-path-1.2.0.jar" MVN="mvn:org.talend.libraries/json-path-1.2.0/6.0.0" UrlPath="platform:/plugin/org.talend.libraries.json/lib/json-path-1.2.0.jar"
+			<IMPORT NAME="json-path-1.2.0.jar" MODULE="json-path-1.2.0.jar" MVN="mvn:com.jayway.jsonpath/json-path/1.2.0" UrlPath="platform:/plugin/org.talend.libraries.json/lib/json-path-1.2.0.jar"
                 REQUIRED_IF="(READ_BY == 'JSONPATH') AND (JSON_PATH_VERSION == '1_2_0')" />
             <IMPORT NAME="json-smart-2.4.11.jar" MODULE="json-smart-2.4.11.jar" MVN="mvn:net.minidev/json-smart/2.4.11"
                 REQUIRED_IF="(READ_BY == 'JSONPATH')" />