fix(TUP-28009): Save relationship index after version change (#4987)

Fix:TUP-27879 Shared user can't write library index file library_data.index
https://jira.talendforge.org/browse/TUP-27879
Improve the code fix a spelling errors

i18n/plugins/org.talend.designer.business.diagram.nl/src/messages_en.properties

@@ -8,7 +8,7 @@ BusinessAbstractParser.StringIntegerConvertError=String value cannot be converte
 BusinessPaletteFactory.CreateGear=Create new Gear
 SimpleBusinessCreationWizardPage.Title=New Business Model
 BusinessNewDiagramFileWizard.CreateNewDiagram=Create new diagram based on {0}  model content
-BusinessAbstractParser.UnknownLiteral=Unknown literal: 
+BusinessAbstractParser.UnknownLiteral=Unknown literal:
 BusinessAbstractParser.StringLongConverError=String value cannot be converted to Long value
 AssignmentPropertySection.DeleteAssignment=Delete Assignment
 AssignmentPropertySection.Type=Type
@@ -20,7 +20,7 @@ AssignmentPropertySection.Name=Name
 CreateAssignmentCommand.CannotAssign=Cannot Assign.
 BusinessNewDiagramFileWizard.DiagramRootElement=Diagram root element
 BusinessNewDiagramFileWizard.NoDiagramRootElementSelectedError=No diagram root element selected
-BusinessVisualIDRegistry.ParseError=Unable to parse view type as a visualID number: 
+BusinessVisualIDRegistry.ParseError=Unable to parse view type as a visualID number:
 OpenDiagramAction.EditBusinessModel=Edit Business Model
 BusinessAbstractParser.ValueOfTypeByteIsExpected=Value of type Byte is expected
 BusinessAbstractParser.ValueOfTypeCharacterIsExpected=Value of type Character is expected
@@ -35,11 +35,11 @@ BusinessPaletteFactory.DatabaseComment=Create new Database
 AssignmentPropertySection.Comment=Comment
 SimpleBusinessCreationWizard.NewBusinessModel=New Business Model
 BusinessNewDiagramFileWizard.InvalidDiagramRootElementSelected=Invalid diagram root element was selected
-BusinessInitDiagramFileAction.IntialNew=Initialize new 
+BusinessInitDiagramFileAction.IntialNew=Initialize new
 FindAssignmentAction.FindAssignments=Find Assignments
 RepositoryFactoryProxyLabelProvider.NotFound= (Not Found)
 BusinessPaletteFactory.Terminal=Terminal
-BusinessAbstractParser.InvalidInputAt=Invalid input at 
+BusinessAbstractParser.InvalidInputAt=Invalid input at
 BusinessPaletteFactory.Gear=Gear
 BusinessPaletteFactory.InputComment=Create new Input
 BusinessPaletteFactory.Data=Data
@@ -54,7 +54,7 @@ BusinessModelingAssistantProvider.SelectDomainModelElement=Select domain model e
 BusinessPaletteFactory.CreateActor=Create new Actor
 BusinessAbstractParser.StringDoubleConvertError=String value cannot be converted to Double value
 BusinessPaletteFactory.Actor=Actor
-EditAction.Edit=Edit 
+EditAction.Edit=Edit
 BusinessCreationWizardPage.CreateBusinessDiagram=Create a Business diagram
 BusinessPaletteFactory.Database=Datasource
 BusinessPaletteFactory.ListComment=Create new List
@@ -66,7 +66,7 @@ BusinessInitDiagramFileAction.LoadFaild=Model file loading failed
 BusinessPaletteFactory.DecisionComment=Create new Decision
 BusinessAbstractParser.ValueOfDoubleIsExpected=Value of type Double is expected
 OpenDiagramAction.ReadBusinessModel=Read Business Model
-BusinessInitDiagramFileAction.UnableToLoadResource=Unable to load resource: 
+BusinessInitDiagramFileAction.UnableToLoadResource=Unable to load resource:
 BusinessPaletteFactory.CreateEllipse=Create new Ellipse
 BusinessNewDiagramFileWizard.DiagramFile=Diagram file
 BusinessAbstractParser.StringShortConverError=String value cannot be converted to Short value

i18n/plugins/org.talend.designer.codegen.nl/src/main/java/messages_en.properties

@@ -2,7 +2,7 @@ JavaRoutineSynchronizer.UnsupportedOperation.Exception1=method not implemented:
 CodeGeneratorEmittersPoolFactory.JETEmitters.NoPresent=JETEmitters Project not present, full reinitialize is needed
 generatedcode.footerprocess.nbcharsgenerated={0} characters generated by {1}
 CodeGeneratorEmittersPoolFactory.Class.NotFound=Template still present, but class {0} has disapeared from workspace. This unit needs to be recompiled.
-CodeGeneratorEmittersPoolFactory.PersitentData.Error=Persitent data cannot be saved : 
+CodeGeneratorEmittersPoolFactory.PersitentData.Error=Persitent data cannot be saved :
 generatedcode.copyright.title=Copyright (c) 2005-2011, Talend Inc.
 CodeGeneratorEmittersPoolFactory.initMessage=Generation Engine Initialization in progress...
 generatedcode.copyright.body5=(http://www.gnu.org/licenses/lgpl.html).
@@ -35,7 +35,7 @@ CodeGenInit.removeLink=Remove linked resources
 CodeGenInit.saveWorkspace=Saving workspace
 DocumentRootImpl.mixed=\ (mixed:
 NodesSubTree.enableParallel=__ENABLE_PARALLEL__
-PoolTypeImpl.persistentPool=\ (persistentPool:
+PoolTypeImpl.persistentPool= \ (persistentPool:
 TalendJetEmitter.compileFail=\ compile fail : {0} : {1}
 TalendJetEmitter.exception=Exception on
 JetFilesProviderManager.unableLoad=Unable to load {0}JetFilesProviderManager.unableLoad
@@ -84,7 +84,7 @@ FAMILY.eXist=eXist
 FAMILY.FTP=FTP
 FAMILY.Fields=Fields
 FAMILY.File=File
-FAMILY.FireBird=Firebird
+FAMILY.FireBird=FireBird
 FAMILY.Greenplum=Greenplum
 FAMILY.HSQLDb=HSQLDb
 FAMILY.Healthcare=Healthcare

i18n/plugins/org.talend.designer.codegen.nl/src/main/java/messages_fr.properties

@@ -139,3 +139,7 @@ ComponentsPreferencePage_SuccessMessage1=Red\u00E9marrez le Studio pour charger
 ComponentsPreferencePage_SuccessMessage2=Red\u00E9marrer maintenant ?
 ComponentsPreferencePage.installComponentsFailure=\u00C9chec de l'installation des composants
 ComponentsFactory.init.waitForFinish.timeout=Impossible d\'initialiser ComponentsFactory, veuillez r\u00E9essayer.
+ComponentsPreferencePage.enableOnLineHelp=Activer l\'aide en ligne pour les composants
+ComponentsPreferencePage.titleInstallHelp=Installer la fonctionnalit\u00E9 d\'aide hors ligne\u00A0?
+ComponentsPreferencePage.msgInstallHelp=Cela va ouvrir une bo\u00EEte de dialogue de packages suppl\u00E9mentaires pour installer la fonctionnalit\u00E9 d\'aide hors ligne, continuer ?
+ComponentsPreferencePage.grpHelp=Aide

i18n/plugins/org.talend.designer.core.nl/src/main/java/messages_en.properties

@@ -1,7 +1,7 @@
 FileController.decoration.description=Content taken from the repository
 AdvancedContextComposite.Name=Name
 EParameterName.tableMeter=Meter Table
-EParameterName.password=Password 
+EParameterName.password=Password
 DesignerPreferencePage.display.useRepositoryName=Use the Repository name as label for the components dragged and dropped from the Repository Metadata.
 UpdateDetectionDialog.Expand=Expand All
 EParameterName.CurrentOS=Current OS
@@ -94,7 +94,7 @@ ExecuteSystemCommandCommand.Command=Execute...
 UpdateDetectionDialog.Operations=Operations
 ChangeConnectionStatusCommand.setLinkRef=set Link as Ref
 Note.DefaultText=text
-DesignerColorsPreferencePage.ConnectionColorMessages=If you change link colors, you should restart the current job to apply changes. 
+DesignerColorsPreferencePage.ConnectionColorMessages=If you change link colors, you should restart the current job to apply changes.
 MultiPageEditorContributor.runMenu=Run
 EParameterName.uniqueName=Unique Name
 ExternalNodeChangeCommand.propagateMessage=Would you like to propagate changes ?
@@ -109,7 +109,7 @@ ConfigureConnParamDialog.ContextText=With Context:
 EParameterName.UseStatistics=Use statistics (tStatCatcher)
 StatsAndLogsComposite.StatsLogsSettings=Stats & Logs Settings
 NodesPasteCommand.label=Paste
-ExternalNodeChangeCommand.modifaicationFrom=Modification from 
+ExternalNodeChangeCommand.modifaicationFrom=Modification from
 EmfComponent.Time=Time
 ContextParameterExtractor.ExistedMessages=Some context parameters have be existed in {0}.
 TextController.decoration.description=Value taken from the repository
@@ -229,10 +229,10 @@ ContextParameterPage.title=Context parameter
 NodeReturn.Availability.AFTER=After
 EmfComponent.repository=Repository
 EParameterName.ConnectionFormat=Connection format
-ExecuteSystemCommandCommand.Title=Executed command 
+ExecuteSystemCommandCommand.Title=Executed command
 EParameterName.Description=Description
 Process.IfToUpgradeMetadata=The metadata used in the following component(s) has been modified.\nSelect the component(s) that you want to update from the repository.
-NewProcessWizard.title=New Job
+NewProcessWizard.title=New job
 CheckController.decoration.description=Value taken from the repository
 ContextParameterPage.comment=Comment
 EParameterName.onConsoleFlag=On Console
@@ -268,7 +268,7 @@ ContextParameterPage.nameExists=Parameter name already exists.
 ExecuteSystemCommandCommand.Label=Executes special commands which were set by user or defined in component.
 ContextParameterPage.defaultValue=Default value
 MergeOrderDialog.MoveDown=Move Down
-EParameterName.dbName=Db Name 
+EParameterName.dbName=Db Name
 TalendEditorContextMenuProvider.Row=Row
 EParameterName.catchUserWarning=Catch user warnings
 StatsAndLogsComposite.Save=&Save to preferences
@@ -502,7 +502,7 @@ TraceEnableAction.TraceEnableDesc=Set Trace Enable
 TraceEnableAction.TraceEnableTitle=Trace Enable
 UpdateManagerUtils.updateMOfification=Update manager modification
 WSDL2JAVAController.TOS=Talend Open Studio
-WSDL2JAVAController.generateFileFailed=Generate java files failed \n{0} \:
+WSDL2JAVAController.generateFileFailed=Generate java files failed \n{0} :
 WSDL2JAVAController.generateFileFailedFromWSDL=Generate java files from the wsdl file\: {0} successfully.
 JobSettingProjectSettingPage.implictLabel=Implicit context load
 JobSettingProjectSettingPage.statAndLog=Stats and logs
@@ -673,7 +673,7 @@ ModifyMergeOrderAction.ERROE=Error
 ConnectionDeleteCommand.COLLAPSE=Warning
 ConnectionDeleteCommand.COLLAPSEJOBLET=Can not delete the connections of the expanded Joblet in Job.
 MultiPageTalendEditor.DIRTY=Dirty joblet
-MultiPageTalendEditor.DIRTYMESSAGE=\ is dirty, Please save joblet first, otherwise you will lose the modification in joblet?
+MultiPageTalendEditor.DIRTYMESSAGE= is dirty, Please save joblet first, otherwise you will lose the modification in joblet?
 UpdateDetectionDialog.jobletMessage=Job closed will be updated automatically.
 ImportExportPreferencePage.addClasspathJar=Add classpath jar in exported jobs (not compatible with JobServer)
 DbTableController.dialog.title=Error
@@ -717,7 +717,7 @@ TalendEditorDropTargetListener.updateHadoopCfgDialog.msg=The hadoop configuratio
 CodeView.initMessage=Generation Engine Initialization in progress...
 Connection.paral_queuesize=QUEUE_SIZE
 ModulesInstaller_text1=Component {0} requires the following third party modules;
-ModulesInstaller_title1=List of modules not installed for component 
+ModulesInstaller_title1=List of modules not installed for component
 ModulesInstaller_text2=Selected components require the following third party modules
 ModulesInstaller_title2=List of modules not installed for the selected components
 PropertiesWizardPage.ItemExistsError=This item already exists. Check the Recycle bin and empty it if needed.
@@ -1005,3 +1005,5 @@ PerformancePreferencePage.propagateContext=Propagate contexts added in repositor
 LicenseKeyController.NewLicenseKey=Enter a new license key
 ReconcilerStyledText.illegalArgs=Input args are bigger than text length:{0}, original input <{1}, {2}>, changed to <{3}, {4}>.
 JobLaunchConfigurationDelegate.waitProcessRunning=Waiting for running process...
+StitchDataLoaderConstants.descriptionForIntegrationSource=Extract {0} data and ingest it in the cloud destination of your choice using Stitch Data Loader. Select this option to open your browser and try it for free.
+StitchDataLoaderConstants.descriptionForDataWarehouseDestination=Ingest data from over 100 popular sources to {0} using Stitch Data Loader. Select this option to open your browser and try it for free.

i18n/plugins/org.talend.designer.core.nl/src/main/java/messages_fr.properties

@@ -975,3 +975,29 @@ PerformancePreferencePage.defaultTimeout.read=Valeur du d\u00E9lai avant expirat
 Node.hasMoreThenOneSourceKey=Ce composant n\'a pas de source cl\u00E9 d\u00E9finie.
 DatabaseForm.checkFailure=\u00C9chec de la connexion
 DatabaseForm.checkFailureTip=Vous devez modifier les param\u00E8tres de la base de donn\u00E9es.
+AbstractPreferenceComposite.textContent2=Appliquer aux sous-Jobs
+AbstractPreferenceComposite.tipContent2=Appliquer aux sous-Jobs
+ActivateSubjobAction.ActivateComplete2=Activer le sous-Job complet
+ActivateSubjobAction.ActivatePart2=Activer le sous-Job courant
+ActivateSubjobAction.DeactivateComplete2=D\u00E9sactiver le sous-Job complet
+ActivateSubjobAction.DeactivatePart2=D\u00E9sactiver le sous-Job courant
+ChangeActivateStatusSubjobCommand.Label.ActiveComplete2=Activer le sous-Job complet
+ChangeActivateStatusSubjobCommand.Label.ActivePart2=Activer le sous-Job courant
+ChangeActivateStatusSubjobCommand.Label.DeactiveComplete2=D\u00E9sactiver le sous-Job complet
+ChangeActivateStatusSubjobCommand.Label.DeactivePart2=D\u00E9sactiver le sous-Job courant
+ComponentSettingsView.subjob2=Sous-Job
+ConnectionSetAsMainRef.ConnectionModifyError2=Impossible de modifier la connexion lorsque le composant de d\u00E9but a un lien subJob.
+DisplaySubjobCommand.DisplaySubjob2=Afficher le sous-Job
+DisplaySubjobCommand.HideSubjob2=Masquer le sous-Job
+EParameterName.OverrideEncodingFlag=\u00C9craser l\'encodage
+EParameterName.showSubjob2=Afficher le titre du sous-Job
+ModifyMergeOrderAction.ConnectionModifyError2=Impossible de modifier la connexion lorsque le composant de d\u00E9but a un lien subJob.
+Node.notSubjobStartNode2=Ce composant \"{0}\" n\'est pas un n\u00BDud de d\u00E9but de sous-Job.
+Node.inLoop=Le n\u00BDud ({0}) est dans une boucle r\u00E9cursive.
+ToggleSubjobsAction.LABEL2=D\u00E9velopper/r\u00E9duire les sous-Jobs
+PerformancePreferencePage.propagateContext=Propager les contextes ajout\u00E9s aux groupes de contextes du r\u00E9f\u00E9rentiel
+LicenseKeyController.NewLicenseKey=Saisissez une nouvelle cl\u00E9 de licence
+ReconcilerStyledText.illegalArgs=Les arguments d\'entr\u00E9e sont plus grands que la longueur du texte\u00A0:{0}, entr\u00E9e originale <{1}, {2}>, modifi\u00E9e en <{3}, {4}>.
+JobLaunchConfigurationDelegate.waitProcessRunning=En attente du processus en cours d\'ex\u00E9cution...
+StitchDataLoaderConstants.descriptionForIntegrationSource=Extrait des donn\u00E9es {0} et les ing\u00E8re dans la destination Cloud de votre choix \u00E0 l'aide de Stitch Data Loader. S\u00E9lectionnez cette option pour ouvrir votre navigateur et l'essayer gratuitement.
+StitchDataLoaderConstants.descriptionForDataWarehouseDestination=Ing\u00E8re des donn\u00E9es de plus de 100 sources populaires dans {0} \u00E0 l'aide de Stitch Data Loader. S\u00E9lectionnez cette option pour ouvrir votre navigateur et l'essayer gratuitement.

i18n/plugins/org.talend.designer.core.nl/src/main/java/messages_ja.properties

@@ -84,7 +84,7 @@ SqlMemoController.QueryError.mainMsg=\u30AF\u30A8\u30EA\u30B9\u30C6\u30FC\u30C8\
 ContextRepositoryCommand.modifyContext=\u30B3\u30F3\u30C6\u30AD\u30B9\u30C8\u306E\u5909\u66F4
 EParameterName.DisableWarnings=\u8B66\u544A\u306E\u7121\u52B9\u5316
 ChangeConnTextCommand.Label=\u63A5\u7D9A\u30E9\u30D9\u30EB\u306E\u5909\u66F4
-TalendEditorPaletteFactory.Note=\u30CE\u30FC\u30C8
+TalendEditorPaletteFactory.Note=\u6CE8
 EParameterName.tStatCatcherStats=tStatCatcher\u7D71\u8A08\u60C5\u5831
 EParameterName.LoadNewVariableLabel=\u5909\u6570\u3092\u30ED\u30FC\u30C9\u3059\u308B\u5834\u5408\u306F\u3001\u30B3\u30F3\u30C6\u30AD\u30B9\u30C8\u306B\u306A\u3051\u308C\u3070\u306A\u308A\u307E\u305B\u3093
 EParameterName.startable=\u958B\u59CB\u53EF\u80FD
@@ -1005,3 +1005,5 @@ PerformancePreferencePage.propagateContext=\u30EA\u30DD\u30B8\u30C8\u30EA\u30FC\
 LicenseKeyController.NewLicenseKey=\u65B0\u3057\u3044\u30E9\u30A4\u30BB\u30F3\u30B9\u30AD\u30FC\u3092\u5165\u529B
 ReconcilerStyledText.illegalArgs=\u5165\u529B\u5F15\u6570\u304C\u30C6\u30AD\u30B9\u30C8\u9577\u3092\u8D85\u3048\u3066\u3044\u307E\u3059:{0}\u3001\u5143\u306E\u5165\u529B<{1}\u3001{2}>\u3001\u5909\u66F4\u3057\u3066<{3}\u3001{4}>\u3068\u306A\u308A\u307E\u3057\u305F\u3002
 JobLaunchConfigurationDelegate.waitProcessRunning=\u5B9F\u884C\u30D7\u30ED\u30BB\u30B9\u3092\u5F85\u6A5F\u4E2D...
+StitchDataLoaderConstants.descriptionForIntegrationSource=Stitch Data Loader\u3092\u4F7F\u3044\u3001100\u3092\u8D85\u3048\u308B\u4EBA\u6C17\u306E\u30BD\u30FC\u30B9\u304B\u3089\u30C7\u30FC\u30BF\u3092{0}\u306B\u53D6\u308A\u8FBC\u307F\u307E\u3059\u3002\u3053\u306E\u30AA\u30D7\u30B7\u30E7\u30F3\u306F\u30D6\u30E9\u30A6\u30B6\u30FC\u3067\u304A\u8A66\u3057\u3044\u305F\u3060\u3051\u307E\u3059\u3002
+StitchDataLoaderConstants.descriptionForDataWarehouseDestination=Stitch Data Loader\u3092\u4F7F\u3044\u3001{0}\u30C7\u30FC\u30BF\u3092\u62BD\u51FA\u3057\u3066\u6307\u5B9A\u306E\u30AF\u30E9\u30A6\u30C9\u30C7\u30B9\u30C6\u30A3\u30CD\u30FC\u30B7\u30E7\u30F3\u306B\u53D6\u308A\u8FBC\u307F\u307E\u3059\u3002\u3053\u306E\u30AA\u30D7\u30B7\u30E7\u30F3\u306F\u30D6\u30E9\u30A6\u30B6\u30FC\u3067\u304A\u8A66\u3057\u3044\u305F\u3060\u3051\u307E\u3059\u3002

i18n/plugins/org.talend.designer.dbmap.nl/src/main/java/messages_en.properties

@@ -36,7 +36,7 @@ TableEntriesManager.exceptionMessage.caseNotFound=case not found
 ToolbarInputZone.widgetTooltip.addAlias=Add alias
 ToolbarOutputZone.widgetTooltip.removeOutputTable=Remove selected output table
 InputDataMapTableView.columnTitle.ExplicitJoin=Explicit join
-AliasDialog.addNewAlias=Add a new alias 
+AliasDialog.addNewAlias=Add a new alias
 MapperManager.exceptionMessage.useOtherSignature=Use other signature method to add entry
 UIManager.propagateTitle=Propagate
 MapperManager.removeOutputTableTitle=Remove output table
@@ -69,7 +69,7 @@ InputDataMapTableView.columnTitle.Operator=Operator
 ProblemsManager.operatorNotSet=Operator of input entry '{0}' is not set.
 VarsTable.invalidTip=' is invalid.
 UIManager.3= doesn't exist !
-UIManager.2=The zone 
+UIManager.2=The zone
 DbMapComponent.unknowValue=Value of element parameter NAME is unknown :
 UIManager.nameExistOrNull=The name already exists or is null.
 AliasDialog.inputValid=Input is invalid.

i18n/plugins/org.talend.designer.fileoutputxml.nl/src/main/java/messages_en.properties

@@ -27,11 +27,11 @@ FOXUI.2=Related Column
 FOXUI.1=XML Tree
 FOXUI.0=Link target
 DragAndDrogDialog.AddAttributes=Create as attribute of target node
-FOXUI.19=Linker source
+FOXUI.19=Linker Source
 FOXUI.18=Remove Group Element
 FOXUI.17=Set As Group Element
 FOXUI.16=Set As Loop Element
-FOXUI.15=Guess loop element
+FOXUI.15=Guess Loop Element
 Schema2XMLDragAndDropHandler.IsNotElementWarning=isn't a Element, can not create sub-elements or attributes.
 FOXUI.14=Import XML Tree
 FooterComposite.AutoMap=Auto map!

i18n/plugins/org.talend.designer.mapper.nl/src/main/java/messages_en.properties

@@ -67,12 +67,12 @@ MapperManager.removeOutputTableTitleMessage=Are you sure you want to remove the
 ToolbarOutputZone.moveupTooltip=Move up selected output table
 DataMapTableView.buttonTooltip.minimize=Minimize
 EntryContentProposal.column=Column:
-Problem.warning.setExpressionKey=Try to set an Expression key if possible in the lookup table '{0}' to improve performance. 
+Problem.warning.setExpressionKey=Try to set an Expression key if possible in the lookup table '{0}' to improve performance.
 ToolbarInputZone.restoreTooltip=Restore all input tables
 VarsTable.invalidTip=' is invalid.
-Problem.warning.unusableReject=As no filter is defined in table(s) {0}, the output rejection cannot be used. 
+Problem.warning.unusableReject=As no filter is defined in table(s) {0}, the output rejection cannot be used.
 UIManager.3= does'nt exist !
-UIManager.2=The zone 
+UIManager.2=The zone
 OutputDataMapTableView.columnTitle.filterCondition=Filters conditions (AND)
 MapperComponent.generationNotInitial=generationManager is not initialized by the perljet/javajet\!
 VarsDataMapTableView.nullable=Nullable
@@ -105,11 +105,11 @@ InputDataMapTableView.removeGlobalMapVar.Title=Remove globalMap variable
 InputDataMapTableView.removeGlobalMapVar.Message=Are you sure to remove the globalMap variable {0}?
 InputDataMapTableView.globalMapKey=globalMap Key
 InputDataMapTableView.invalid=<Invalid>
-InputDataMapTableView.invalidConfiguration=Invalid configuration, choose another lookup mode or set an expression in the lookup key column "{0}\\"
+InputDataMapTableView.invalidConfiguration=Invalid configuration, choose another lookup mode or set an expression in the lookup key column "{0}\"
 FooterComposite.button.APPLY=Apply
 InputDataMapTableView.columnTitle.Operator=Operator
 HTMLDocGenerator_generate_document=Generated documentation
-HTMLDocGenerator.author=AUTHOR
+HTMLDocGenerator.author=Author
 HTMLDocGenerator.author1=Author
 HTMLDocGenerator.column=Column
 HTMLDocGenerator.comment=Comment

i18n/plugins/org.talend.designer.rowgenerator.nl/src/main/java/messages_en.properties

@@ -2,7 +2,7 @@ RowGenPreivewCodeMain.Process.Generate=Process tRowGenerator generate...
 RowGenPreivewCodeMain.PreviewBtn.Text=Preview
 TabFolderEditors.FunParamTab.TitleText=Function parameters
 MetadataToolbarEditorViewExt.Columns.Text=Columns
-RowGenProcess.ConnectionName.NotValid=The name of the connection is not valid: 
+RowGenProcess.ConnectionName.NotValid=The name of the connection is not valid:
 RowGenProcess.BeseName.BeNull=baseName can't be null
 UIManager.MessageBox.Content=Do you want to close the tRowGenerator without saving the current settings?
 RowGenTableEditor2.Preview.TitleText=Preview

i18n/plugins/org.talend.designer.runprocess.nl/src/main/java/messages_en.properties

@@ -1,7 +1,7 @@
 ProcessComposite2.statsComposite=Stats && Traces
 ProcessComposite.clearBefore=Clear before run
 ProcessComposite.kill=Kill
-ProcessComposite.confirmText=Do you really want to launch the job with context {0} ? 
+ProcessComposite.confirmText=Do you really want to launch the job with context {0} ?
 Processor.perlModuleNotFound=Perl Module Plugin not found.
 PromptDialog.title=Run Context {0} with parameters:
 ProcessComposite.execTimeHint=Show the time of running this job
@@ -9,7 +9,7 @@ Processor.tempFailed=Failed to generate temporary files.
 ProcessComposite.exec=Run
 ProcessView.subtitleEmpty=No job to run
 ProcessComposite.statHint=Statistics on job execution will be shown
-prefs.clientTracePortBound2=to 
+prefs.clientTracePortBound2=to
 prefs.clientTracePortBound1=Trace port range :
 ProcessComposite.execGroup=Execution
 ProcessView.gainFocusLog=Run process gain focus
@@ -20,7 +20,7 @@ prefs.clientStatInvalidRange=Client stats port must be between 1024 and 65535 in
 Processor.commandLineLog=Command line:
 ProcessView.jobName=Job
 JavaProcessor.notFoundedProjectException=Java project not found.
-prefs.clientStatsPortBound2=to 
+prefs.clientStatsPortBound2=to
 ProcessView.titleEmpty=Run job
 RunProcessContext.PortErrorTraces=Traces
 prefs.clientStatsPortBound1=Stats port range :
@@ -30,7 +30,7 @@ ProcessComposite.trace=Traces
 RunProcessContext.PortErrorTitle={0} Port Error!
 ProcessDebugDialog.title=Debug job {0}
 ProcessComposite.killHint=Stop immediatly the execution of the job
-ProcessComposite.buildTask=Building Job
+ProcessComposite.buildTask=Building job
 ProcessComposite.execFailed=Execution failed : 
 Processor.execFailed=Job execution failed.
 ProcessComposite.stat=Statistics
@@ -55,13 +55,13 @@ prefs.clientConfiguration=Talend client configuration
 ProcessView.title=Run ({0})
 Processor.configurePerl=Perl interpreter not configured.
 JavaProcessor.notFoundedFolderException=Folder within .Java project not found
-ProcessComposite.execHint=Run the job 
+ProcessComposite.execHint=Run the job
 ProcessComposite.valueCol=Value
 ProcessComposite.saveBeforeRunHint=Saves the Job before the execution.
 ProcessDebugDialog.debugBtn=Debug
 prefs.configuration.title=Run process configuration :
 DefaultRunProcessService.methodCalledError=This method should'nt be called here, use it on RunProcessService class.
-ErrorDetailDialog.errorExist=\ \ Warning\! Some errors exist in job. Would you like to continue?
+ErrorDetailDialog.errorExist=  Warning! Some errors exist in job. Would you like to continue?
 ErrorDetailDialog.findError=Error found
 ProcessComposite.hideContext=hide the Context
 ProcessComposite.lineLimited=Line limit
@@ -96,7 +96,7 @@ CamelJobErrorsChecker_compile_errors=Route compile errors
 CamelJobErrorsChecker_compile_error_content=At least Route "{0}" has compile errors, please fix and export again.
 RunProcessPreferencePage.RouteVmArgument=Route Run VM arguments
 ProcessComposite.wrapbutton=Wrap
-JavaProcessorUtilities.msg.missingjar.forProcess=Missing jars: 
+JavaProcessorUtilities.msg.missingjar.forProcess=Missing jars:
 JavaProcessorUtilities.msg.missingjar.note=Note:
 JavaProcessorUtilities.msg.missingjar.onlyforroutine=The following jars are also required by compiler:
 JavaProcessorUtilities.msg.missingjar.warningtitle=Warning!

i18n/plugins/org.talend.designer.runprocess.nl/src/main/java/messages_fr.properties

@@ -1,7 +1,7 @@
 ProcessComposite2.statsComposite=Stats && Traces
 ProcessComposite.clearBefore=Effacer avant l\'ex\u00E9cution
 ProcessComposite.kill=Arr\u00EAter
-ProcessComposite.confirmText=Voulez-vous vraiment lancer le Job avec le contexte {0} ?
+ProcessComposite.confirmText=Voulez-vous lancer le Job avec le contexte {0}\u00A0?
 Processor.perlModuleNotFound=Impossible de trouver le plug-in du module Perl.
 PromptDialog.title=Ex\u00E9cuter le contexte {0} avec les param\u00E8tres \:
 ProcessComposite.execTimeHint=Afficher le temps d'ex\u00E9cution du job
@@ -96,7 +96,7 @@ CamelJobErrorsChecker_compile_errors=Erreurs de compilation de la route
 CamelJobErrorsChecker_compile_error_content=Au moins la route "{0}" a des erreurs de compilation, fixez-les et exportez \u00E0 nouveau.
 RunProcessPreferencePage.RouteVmArgument=Arguments VM d\'ex\u00E9cution des jobs
 ProcessComposite.wrapbutton=Retour automatique \u00E0 la ligne
-JavaProcessorUtilities.msg.missingjar.forProcess=Jars manquants : 
+JavaProcessorUtilities.msg.missingjar.forProcess=Jars manquants\u00A0:
 JavaProcessorUtilities.msg.missingjar.note=Remarque :
 JavaProcessorUtilities.msg.missingjar.onlyforroutine=Les Jar suivants sont aussi requis par le compilateur :
 JavaProcessorUtilities.msg.missingjar.warningtitle=Attention !
@@ -134,3 +134,6 @@ Processor.memoryRun.searchJvmInfo=Recherche de la JVM active du Job actuel.
 Processor.memoryRun.jvmInfo=Le JVM est d\u00E9connect\u00E9e.
 ShellPs1SettingPreferencePage_Title=Scripts ps1
 JobErrorsChecker_compile_error_errormessage=Message d\'erreur
+ProcessComposite.endJobPattern=Job {0} termin\u00E9 \u00E0 {1}.
+ProcessComposite.endExitCode=Code de sortie {0}
+ProcessComposite.startJobPattern=D\u00E9marrage du Job {0} \u00E0 {1}.

i18n/plugins/org.talend.repository.ftp.nl/src/messages_fr.properties

@@ -26,3 +26,6 @@ FTPForm_proxyPortText=Port du proxy
 FTPForm_proxyUsernameText=Utilisateur du proxy
 FTPForm_proxyPasswordText=Mot de passe du proxy
 FTPForm_filepathAlert=Le chemin du fichier doit \u00EAtre sp\u00E9cifi\u00E9
+FTPForm_conn_timeout=Expiration de la connexion
+FTPForm_conn_timeunit=Unit\u00E9\u00A0: millisecondes
+FTPForm_ftpTimeoutText_check=Le d\u00E9lai avant expiration doit \u00EAtre un nombre.

i18n/plugins/org.talend.repository.nl/plugin_en.properties

@@ -8,7 +8,7 @@ migrationtask.upgradetWarntDiePriority.title=Upgrade tWarn and tDie priority
 migrationtask.renametDbInputToPostgresql.title=Rename tDBxxTotPostgresqlxx
 migrationtask.renametFTPtoFTP.title=Rename tFTP to specialized tFTP
 prefsStatusName=Status
-migrationtask.renametFileZipUnzip.description=Rename tFileZip and tFileUnzip components to tFileArchive and tFileUnarchive 
+migrationtask.renametFileZipUnzip.description=Rename tFileZip and tFileUnzip components to tFileArchive and tFileUnarchive
 migrationtask.renametDbInputToMySQL.description=Migrate database generic components connected to a MySQL database to the corresponding specific MySQL components.
 migrationtask.renameNormalize.description=Rename all components tNormalizer to tNormalize
 migrationtask.updatetRowGenerator.description=Migrate simple interface tRowGenerator components to advanced interface.
@@ -21,7 +21,7 @@ migrationtask.RenametMapPersistentMigrationTask.title=Rename tMapPersistent to t
 migrationtask.renametDbInputToOracle.title=Rename tDBxxTotOraclexx
 migrationtask.UpgradetAdvancedFileOutputXMLMigrationTask.title=Upgrade mapping tAdvancedFileOutputXML
 migrationtask.changetUniqRowLinks.description=Change the link type of all tUniqRow components from "Main" to "Unique".
-migrationtask.AddPerlRefArrayPointer2.desc=Replace this syntax "$xxx[" by "$xxx->[" and "@xxx" by "@$xxx" only for known existing Talend connections and components  
+migrationtask.AddPerlRefArrayPointer2.desc=Replace this syntax "$xxx[" by "$xxx->[" and "@xxx" by "@$xxx" only for known existing Talend connections and components
 migrationtask.renametDbInputToPostgresql.description=Migrate database generic components connected to a PostgreSQL database to the corresponding specific PostgreSQL components.
 migrationtask.AddPerlRefArrayPointer2.title=Add ref array pointers and unreference arrays contained in Table fields
 migrationtask.AddQuotesToModuleList.desc=Add quotes to module list if needed.
@@ -39,12 +39,12 @@ migrationtask.renametDbInputToMssql.title=Rename tDBxxTotMssqlxx
 migrationtask.RenameTheClassnameofTheRoutinesFileMigrationTask.title=Rename the classes named __CLASS_NAME__
 migrationtask.AddPerlRefArrayPointer.title=Add ref array pointers and unreference arrays contained in Text fields
 migrationtask.renametFileZipUnzip.title=Rename tFileZip and tFileUnzip components
-migrationtask.renametDbInputToMySQL.title=Rename tDBxxTotMySQLxx 
+migrationtask.renametDbInputToMySQL.title=Rename tDBxxTotMySQLxx
 deleteProjectsAction.title=Delete projects
 repository.prop.version=Version
 prefsRepositoryName=Repository
 migrationtask.renametDbInputToMssql.description=Migrate database generic components connected to a Microsoft SQL Server database to the corresponding specific Microsoft SQL Server components.
-migrationtask.convertOldPerlTypes.title=Convert the old Perl types to new types. 
+migrationtask.convertOldPerlTypes.title=Convert the old Perl types to new types.
 migrationtask.renameFlowMeter.description=Rename all components tMetter to tFlowMeter
 migrationtask.UpgradetAdvancedFileOutputXMLMigrationTask.description=Upgrade mapping tAdvancedFileOutputXML, change the level architecture to path.
 migrationtask.RenametXMLRPCMigrationTask.description=Rename all components tXMLRPC to tXMLRPCInput in all jobs in repository
@@ -54,7 +54,7 @@ migrationtask.ReplaceMultiFlowBytReplicate.desc=Replace Multi-flow by tReplicate
 migrationtask.upgradetWarntDiePriority.description=Upgrade priority to switch from text field to dialog field.
 migrationtask.renameFlowMeterCatcher.description=Rename all components tMetterCatcher to tFlowMeterCatcher
 providerName=www.example.org
-migrationtask.AddPerlRefArrayPointer.desc=Replace this syntax "$xxx[" by "$xxx->[" and "@xxx" by "@$xxx" only for known existing Talend connections and components  
+migrationtask.AddPerlRefArrayPointer.desc=Replace this syntax "$xxx[" by "$xxx->[" and "@xxx" by "@$xxx" only for known existing Talend connections and components
 projectsetting.General=General
 projectsetting.Designer=Designer
 projectsetting.VersionManagement=Version Management

i18n/plugins/org.talend.repository.nl/plugin_fr.properties

@@ -85,3 +85,4 @@ projectSetting.projectRefSettingPage=Projets de r\u00E9f\u00E9rence
 ProjectSetting.groupId=GroupId du d\u00E9ploiement
 projectSetting.deploymentConfiguration=Configuration du d\u00E9ploiement
 projectsetting.Audit=Audit
+projectSetting.ArtifactProxy=Configuration du proxy d\'artefacts

i18n/plugins/org.talend.repository.nl/src/main/java/messages_en.properties

@@ -85,7 +85,7 @@ SelectorTableForm.ColumnNumber=Column number
 CommonWizard.persistenceException=Access to the data failure
 JavaJobScriptsExportWSWizardPage.AxisLib=Axis 1.4 Lib
 FileStep2.escapeCharAlert=Escape Char must be specified
-CreateFileXmlAction.action.createTitle=Create file XML
+CreateFileXmlAction.action.createTitle=Create XML file
 FileStep2.fieldPosition=Marker position
 FileStep3.guessIsDone=Guess successful
 FileStep2.fieldSeparatorAlert=The field separator must be specified. To be valid, it must be surrounded by quotation marks.
@@ -153,7 +153,7 @@ LoginComposite.manageProjectPre=Or
 ConfigExternalPerlModulePage.moduleFieldLabel=Module
 ImportDemoProjectAction.actionTooltip=Import demo project
 CreateConnectionAction.action.openTitle=Open connection
-FileStep2.previewIsDone=Preview successful... 
+FileStep2.previewIsDone=Preview successful...
 FileStep3.guessConfirmation=Confirm changes ?
 VersionManagementDialog.Version=Version
 CreateDocumentationAction.createDocActionTipText.addDocItem=Add a new documentation item
@@ -193,7 +193,7 @@ ConfigExternalJarPage.inputJARName=Input a library's name
 FileStep1.serverAlert=Server must be specified
 RefreshAction.toolTipText=Refresh
 ProjectSettingsWizardPage.PaletteSettings=Palette Settings
-PositionalTextTest.println.fieldValue=Field Value 
+PositionalTextTest.println.fieldValue=Field Value
 VersionManagementDialog.EachVersion=Update the version of each item.
 RepositoryPreferencePage.RefreshTitle=Repository Refresh
 DocumentationPage.option=Option
@@ -241,7 +241,7 @@ ImportProjectAsWizardPage.form.browse=Browse
 ImportProjectAsWizardPage.form.selectDirectory=Select root directory
 CreateFileRegexpAction.action.createTitle=Create file regex
 EditPropertiesAction.action.title=Edit properties
-ImportDemoProjectAction.actionTitle=Demos  
+ImportDemoProjectAction.actionTitle=Demos
 FileStep1.formatAlert=Format must be specified
 JobScriptsExportWizardPage.jobPerlScripts=Perl scripts
 DetecteViewImpactAction.Label=Detect dependencies
@@ -279,7 +279,7 @@ ImportExternalJarPage.pageMessage=Configuration of external libraries for routin
 CommonWizard.next=Next
 FileStep2.empty=Empty
 DocumentationPage.LinkLabel= Copy documentation to repository.
-LoginComposite.buttons.importProject=Import   
+LoginComposite.buttons.importProject=Import
 EditContextAction.readContext=Read context group
 NewProjectWizard.failureTitle=Error
 XmlToXPathLinker.exceptionReturn.xPathInvalid=The current XPath expression is invalid
@@ -297,7 +297,7 @@ ConfigExternalJarPage.jarFile.label=Library File:
 DatabaseTableForm.name=Name
 EditContextAction.editContext=Edit context group
 FileStep1.noExist=doesn't exist
-DatabaseTableForm.connectionIsDone=Connection successful. 
+DatabaseTableForm.connectionIsDone=Connection successful.
 ImportProjectsUtilities.task.importingProject=Importing project...
 FileStep2.fieldPositionTip=You must define here the position of each column. The positions must be presented in ascending order.
 FileStep2.headerTip=Header
@@ -308,7 +308,7 @@ connections.form.emptyField.repository=Repository must be selected
 LibraryField.requiredColumn=Required
 SelectDeleteProjectDialog.SelectAll=Select All
 SelectorTableForm.selectAllTables=Select All
-LoginComposite.buttons.deleteProject=Delete   
+LoginComposite.buttons.deleteProject=Delete
 ImportDemoProjectAction.alertDialog.messageTitle=Message
 ConfigExternalJarPage.title=New Module
 FileStep2.rowSeparator=Row Separator
@@ -351,7 +351,7 @@ SelectDeleteProjectDialog.DeselectAll=Deselect All
 LoginComposite.buttons.newProject.desc=Create a new local project
 FileStep1.server=Server
 JavaJobScriptsExportWSWizardPage.WSDLFile=Web Service files
-FileStep2.quoteDelimitedTip=The character " is unusable without escape character. Use: \"
+FileStep2.quoteDelimitedTip=The character " is unusable without escape character. Use: "
 FileStep3.metadataComment=Comment
 FileStep2.settingsIncomplete=The settings must be completed to show the preview
 CreateTableAction.action.editTitle=Edit Schema
@@ -393,8 +393,8 @@ connections.form.emptyField.username=A username is needed.
 FileStep2.escapeCharTip=Escape Char
 ItemsVersionChangedDialog.Title=Confirm the new version of items
 LicenseWizard.windowTitle=License
-FileStep2.fieldPositionNotValidate=Field Position must contain only numbers and comma.  The positions must be presented in the ascending order 
-LoginComposite.buttons.newProject=Create   
+FileStep2.fieldPositionNotValidate=Field Position must contain only numbers and comma.  The positions must be presented in the ascending order
+LoginComposite.buttons.newProject=Create
 ConfigExternalPerlModulePage.required.label=If the module is required
 CommonWizard.cancel=Cancel
 NewProjectWizardPage.comment=Project description
@@ -404,7 +404,7 @@ connections.form.emptyField.connname=A connection name is needed.
 VersionManagementDialog.Revert=Revert
 VersionManagementDialog.ConfirmTitle=Confirm
 LoginComposite.existing=Select
-CommonWizard.nameAlreadyExist=This name already exists 
+CommonWizard.nameAlreadyExist=This name already exists
 FileStep1.groupFileViewer=File Viewer
 GenerateDocAsHTMLWizardPage.generateDocAsHTML=Generate job information to an archive file on the local file system.
 JobPerlScriptsManager.allInterpreter=All
@@ -412,7 +412,7 @@ CreateFilePositionalAction.action.openTitle=Open file positional
 ReplaceRunBeforeAfterWithThenRunMigrationTask.ThenRun=ThenRun
 NewProjectWizardPage.technicalName=Technical Name
 RepositoryPreferencePage.RefreshCreated=Refresh when creating an item
-ConnectionsListButtonsToolBar.copyLabelPrefix=Copy of 
+ConnectionsListButtonsToolBar.copyLabelPrefix=Copy of
 FileStep3.guessProgress=Guess in progress...
 ExtractionFieldsWithXPathEditorView.columnTitle.columnName=Column Name
 NewFolderWizard.label=Label
@@ -596,7 +596,7 @@ CreateSandboxProjectDialog.Settings=Settings
 LoginComposite.DIFFERENT_WORKSPACES=Workspace has been changed. Please restart.
 LoginComposite.PROJECT_NEED=A project is needed...
 LoginComposite.TisWorkspace_welcome=Welcome to {0}!
-VersionManagementDialog.AllDependencies=select all dependencies
+VersionManagementDialog.AllDependencies=Select all dependencies
 VersionManagementDialog.FixVersion=Fix tRunJob versions if Latest
 VersionManagementDialog.FixLastVersion=When update the version, if all tRunJob are setup by default with Latest version, this will fix the version to the previous version.\nFor example : father 1.0 (tRunJob<child, Latest>).\nIf upgrade to version 1.1: \n  - the father version 1.0 will contain : (tRunJob<child, 1.0>). To run the child with version 1.0 also.\n  - the father version 1.1 will contain : (tRunJob<child, Latest>). To keep using the latest version.\n\nNote: this won't do anything if the versions are already fixed, and if doesn't use Latest.
 ImportItemAction.Label=Import items
@@ -883,7 +883,7 @@ VersionManagementDialog.applyVersion=Apply version
 VersionManagementDialog.useJobVersion=Use job versions.
 JavaVersionProjectSettingPage.versionLabel=JDK Compiler compliance level:
 BuildJobManager.mavenErrorMessage=Job was not built successfully, please check the logs for more details available on {0}
-VersionManagementDialog.projectVersion=Project Version
+VersionManagementDialog.projectVersion=Project version
 VersionManagementDialog.useSnapshot=Use snapshot
 VersionManagementDialog.applyDetail=Apply
 VersionManagementDialog.eachMavenVersion=Change the version of each item individually.
@@ -893,7 +893,7 @@ VersionManagementDialog.remove=Remove
 JavaJobScriptsExportWSWizardPage.MSESB=Microservice (Spring Boot) For ESB
 LimitRESTRequestJobChecker.limit_ESBJobForMS=Only ESB Job with "{0}" could build using [Microservice (Spring Boot) For ESB] type.
 LoginProjectPage.project_need.remote.cloud=Can't retrieve any project from Cloud, please ask for help from the administrator.
-NetworkErrorRetryForm.connectTimeout.label=Connection Timeout (seconds)
+NetworkErrorRetryForm.connectTimeout.label=Connection timeout (seconds)
 NetworkErrorRetryForm.connectTimeout.error.bound=Please input an integer between {0} and {1}
 NetworkErrorRetryForm.details=Details
 NetworkErrorRetryForm.toggle.message=Always don't retry before restart
@@ -939,12 +939,12 @@ MavenDeploymentConfigurationProjectSettingPage.removeWarning=Do you want to dele
 MavenDeploymentConfigurationProjectSettingPage.nameExistedWarning={0} is existed!
 FileStep2.fieldSeparatorPositionalTip=You must defined here the position of each column. The positions must be presented in the ascending order
 FileStep2.stop=Stop
-JobScriptsExportWizardPage.requiredTalendPerlModules=Required talend modules
+JobScriptsExportWizardPage.requiredTalendPerlModules=Required Talend modules
 PropertiesWizardPage.Description=Description
 PropertiesWizardPage.Name=Name
 ReferenceProjectSetupPage.ErrorMissingReferencedProject=Missing referenced project [{0}].
 MavenGroupIdProjectSettingPage.skipGroupIdLabel=Skip base groupID if the item has folder
-AuditProjectSettingPage.selectAuditReportFolder=Please select a generate audit report folder\!
+AuditProjectSettingPage.selectAuditReportFolder=Please select a generate audit report folder!
 AuditProjectSettingPage.generateAuditReportProgressBar=Generating Audit Report!
 LimitRESTRequestJobChecker.limit_ESBJobForOSGI=Job without ESB components could not build using [OSGI Bundle For ESB] type.
 AuditProjectSettingPage.generateButtonText=Generate Audit Report
@@ -1008,3 +1008,7 @@ ProjectSettingPage.ArtifactProxySetting.checkConnection=Check Connection
 ProjectSettingPage.ArtifactProxySetting.connectionFailureMsg=Connection failure,please check the proxy configuration
 LoginHelper.connectUserLibraryTitle=Check user libraries connection.
 LoginHelper.connectUserLibraryFailureWarning=Cannot connect to the user libraries artifact repository set in administrator. Do you want to open the project anyway?
+ReferenceProjectSetupPage.ButtonTooltipStrict=Use strict references to find joblets in target project.
+ConnectionsDialog.usernameOrPasswordInvalid=Check your username or password or contact your administrator.
+LoginProjectPage.authorizationErrorMessage=Invalid username or password for the remote connection. Do you want to fix it now?
+LoginProjectPage.errorMessageTitle=Error

i18n/plugins/org.talend.repository.nl/src/main/java/messages_fr.properties

@@ -193,7 +193,7 @@ ConfigExternalJarPage.inputJARName=Saisissez un nom de biblioth\u00E8que
 FileStep1.serverAlert=Le serveur doit \u00EAtre sp\u00E9cifi\u00E9
 RefreshAction.toolTipText=Rafra\u00EEchir
 ProjectSettingsWizardPage.PaletteSettings=Param\u00E8tres de la Palette
-PositionalTextTest.println.fieldValue=Valeur du champs
+PositionalTextTest.println.fieldValue=Valeur du champ
 VersionManagementDialog.EachVersion=Mettre \u00E0 jour la version de chaque \u00E9l\u00E9ment.
 RepositoryPreferencePage.RefreshTitle=Rafra\u00EEchir le r\u00E9f\u00E9rentiel
 DocumentationPage.option=Option
@@ -985,3 +985,25 @@ connections.form.field.token=Jeton
 connections.form.field.token.browse=Ouvrir la page de g\u00E9n\u00E9ration de jetons dans le navigateur
 connections.form.getTokenUrl.failed=V\u00E9rifiez l'URL du serveur.
 ImportProjectAsWizardPage.importDescription=Saisir un nom de projet et sp\u00E9cifer le projet {0} \u00E0 importer.
+LoginProjectPage.cloud.aws_us=AWS - Est des \u00C9tats-Unis
+LoginProjectPage.cloud.aws_eu=AWS - Europe
+LoginProjectPage.cloud.aws_apac=AWS - Asie-Pacifique
+LoginProjectPage.cloud.usa_west=Azure - Ouest des \u00C9tats-Unis
+LoginProjectPage.cloud.cloud_custom=Cloud personnalis\u00E9
+LoginDialog.logonDenyTitle=Informations
+LoginDialog.logonDenyMsg=La version du produit est expir\u00E9e.\\nInstallez d\'abord [{0}].
+VersionManagementDialog.subjob2=S\u00E9lectionner tous les sous-Jobs
+Log4jSettingPage.Log4jVersionChangedWarn=La synchronisation des POM est requise apr\u00E8s modification de la version log4j. Changer maintenant\u00A0?
+Log4jSettingPage.ActivateLog4j2=Activer Log4j2 dans les composants
+Log4jSettingPage.Log4jVersion=Version de Log4j
+ProjectSettingPage.ArtifactProxySetting.groupNameTalendLib=Configuration du proxy des biblioth\u00E8ques Talend
+ProjectSettingPage.ArtifactProxySetting.artifactType=Type\u00A0:
+ProjectSettingPage.ArtifactProxySetting.url=URL\u00A0:
+ProjectSettingPage.ArtifactProxySetting.username=Utilisateur\u00A0:
+ProjectSettingPage.ArtifactProxySetting.password=Mot de passe\u00A0:
+ProjectSettingPage.ArtifactProxySetting.repositoryId=ID du r\u00E9f\u00E9rentiel\u00A0:
+ProjectSettingPage.ArtifactProxySetting.enableProxySetting=Activer les param\u00E8tres de proxy
+ProjectSettingPage.ArtifactProxySetting.checkConnection=V\u00E9rifier la connexion
+ProjectSettingPage.ArtifactProxySetting.connectionFailureMsg=\u00C9chec de la connexion, v\u00E9rifiez la configuration du proxy.
+LoginHelper.connectUserLibraryTitle=V\u00E9rifier la connexion aux biblioth\u00E8ques utilisateurs.
+LoginHelper.connectUserLibraryFailureWarning=Impossible de se connecter au r\u00E9f\u00E9rentiel d\'artefacts contenant les biblioth\u00E8ques utilisateur en mode administrateur. Ouvrir le projet malgr\u00E9 tout\u00A0?

i18n/plugins/org.talend.repository.nl/src/main/java/messages_ja.properties

@@ -688,7 +688,7 @@ JobScriptsExportWSWizardPage.newJobVersion.Label=\u30B8\u30E7\u30D6\u30D0\u30FC\
 JobScriptsExportWizardPage.newExportJob0=\u30A8\u30AF\u30B9\u30DD\u30FC\u30C8 {0}: {1}_{2}
 JobScriptsExportWizardPage.newExportJob1=\u30A8\u30AF\u30B9\u30DD\u30FC\u30C8 {0}: {1}_{2}
 JobScriptsExportWizardPage.newExportJobScript={0}\u306E\u30A8\u30AF\u30B9\u30DD\u30FC\u30C8\u4E2D
-JobScriptsExportWizardPage.newExportJobSucessful=\u30A8\u30AF\u30B9\u30DD\u30FC\u30C8{0}: {1}_{2}\u304C\u6210\u529F\u3057\u307E\u3057\u305F!
+JobScriptsExportWizardPage.newExportJobSucessful=\u30A8\u30AF\u30B9\u30DD\u30FC\u30C8 {0}: {1}_{2}\u304C\u6210\u529F\u3057\u307E\u3057\u305F!
 JobScriptsExportWizardPage.newExportSuccess={0} \u306E\u30A8\u30AF\u30B9\u30DD\u30FC\u30C8\u306B\u6210\u529F\u3057\u307E\u3057\u305F\uFF01
 LoginComposite.NewCreate=\u4F5C\u6210...
 LoginComposite.NewImport=\u30A4\u30F3\u30DD\u30FC\u30C8...
@@ -1007,4 +1007,4 @@ ProjectSettingPage.ArtifactProxySetting.enableProxySetting=\u30D7\u30ED\u30AD\u3
 ProjectSettingPage.ArtifactProxySetting.checkConnection=\u63A5\u7D9A\u3092\u30C1\u30A7\u30C3\u30AF
 ProjectSettingPage.ArtifactProxySetting.connectionFailureMsg=\u63A5\u7D9A\u304C\u5931\u6557\u3057\u307E\u3057\u305F\u3002\u30D7\u30ED\u30AD\u30B7\u8A2D\u5B9A\u3092\u30C1\u30A7\u30C3\u30AF\u3057\u3066\u304F\u3060\u3055\u3044\u3002
 LoginHelper.connectUserLibraryTitle=\u30E6\u30FC\u30B6\u30FC\u30E9\u30A4\u30D6\u30E9\u30EA\u30FC\u63A5\u7D9A\u3092\u30C1\u30A7\u30C3\u30AF\u3057\u3066\u304F\u3060\u3055\u3044\u3002
-LoginHelper.connectUserLibraryFailureWarning=\u7BA1\u7406\u8005\u306E\u30E6\u30FC\u30B6\u30FC\u30E9\u30A4\u30D6\u30E9\u30EA\u30FC\u306E\u30A2\u30FC\u30C6\u30A3\u30D5\u30A1\u30AF\u30C8\u30EA\u30DD\u30B8\u30C8\u30EA\u30FC\u30BB\u30C3\u30C8\u306B\u63A5\u7D9A\u3067\u304D\u307E\u305B\u3093\u3002\u7D9A\u884C\u3057\u3066\u30D7\u30ED\u30B8\u30A7\u30AF\u30C8\u3092\u958B\u304D\u307E\u3059\u304B?
+LoginHelper.connectUserLibraryFailureWarning=\u7BA1\u7406\u8005\u306E\u30E6\u30FC\u30B6\u30FC\u30E9\u30A4\u30D6\u30E9\u30EA\u30FC\u306E\u30A2\u30FC\u30C6\u30A3\u30D5\u30A1\u30AF\u30C8\u30EA\u30DD\u30B8\u30C8\u30EA\u30FC\u30BB\u30C3\u30C8\u306B\u63A5\u7D9A\u3067\u304D\u307E\u305B\u3093\u3002\u3053\u306E\u307E\u307E\u30D7\u30ED\u30B8\u30A7\u30AF\u30C8\u3092\u958B\u304D\u307E\u3059\u304B?

i18n/plugins/org.talend.repository.nl/src/main/java/messages_zh_CN.properties

@@ -1007,4 +1007,4 @@ ProjectSettingPage.ArtifactProxySetting.enableProxySetting=\u542F\u7528\u4EE3\u7
 ProjectSettingPage.ArtifactProxySetting.checkConnection=\u68C0\u67E5\u8FDE\u63A5
 ProjectSettingPage.ArtifactProxySetting.connectionFailureMsg=\u8FDE\u63A5\u5931\u8D25\uFF0C\u8BF7\u68C0\u67E5\u4EE3\u7406\u914D\u7F6E
 LoginHelper.connectUserLibraryTitle=\u68C0\u67E5\u7528\u6237\u5E93\u8FDE\u63A5\u3002
-LoginHelper.connectUserLibraryFailureWarning=\u65E0\u6CD5\u8FDE\u63A5 Administrator \u4E2D\u7684\u7528\u6237\u5E93\u6784\u4EF6\u5E93\u96C6\uFF0C\u60F3\u8981\u7EE7\u7EED\u6253\u5F00\u5DE5\u7A0B\u5417\uFF1F
+LoginHelper.connectUserLibraryFailureWarning=\u65E0\u6CD5\u8FDE\u63A5\u81F3 Administrator \u4E2D\u7684\u7528\u6237\u5E93\u6784\u4EF6\u5E93\u96C6\u3002\u662F\u5426\u4ECD\u8981\u7EE7\u7EED\u6253\u5F00\u5DE5\u7A0B\uFF1F

i18n/plugins/org.talend.sbi.engines.client.nl/src/messages_en.properties

@@ -3,14 +3,14 @@ JobScriptsExportWizardPage.contextPerlScripts=Context scripts
 SpagoBiServerEditor.descriptionColumnTitle=Short description
 SpagoBiServerEditor.hostColumnTitle=Host
 SpagoBiServerDialog.host=Host
-SpagoBiServerDialog.shellText.editServer=Edit SpagoBi server
+SpagoBiServerDialog.shellText.editServer=Edit SpagoBI server
 PublishOnSpagoExportWizardPage.publishResourceError=Deploy Resource Error
 PublishOnSpagoExportWizardPage.Settings=Settings
 SpagoBiServerDialog.engineNameText=Engine name
 PublishOnSpagoExportWizardPage.publishJob=Deploy job scripts to SpagoBI.
 PublishOnSpagoExportWizardPage.jobLabel=Label
 SpagoBiServerEditor.engineColumnTitle=Engine name
-SpagoBiServerDialog.shellText.createNewServer=Create new SpagoBi server
+SpagoBiServerDialog.shellText.createNewServer=Create new SpagoBI server
 PublishOnSpagoExportWizardPage.chooseResource=Choose at least one resource to export
 PublishOnSpagoExportWizardPage.jobDescription=Description
 PublishOnSpagoExportWizard.publishJob=Deploy on SpagoBI

i18n/plugins/org.talend.spagic.engines.client.nl/src/main/java/messages_en.properties

@@ -26,4 +26,4 @@ SpagicServerDialog.shortDescription=Short description
 DataTransferMessages.ZipExport_mustBeFile=Export destination must be a file, not a directory.
 DataTransferMessages.ZipExport_alreadyExists=Target file already exists.  Would you like to overwrite it?
 DataTransferMessages.ZipExport_alreadyExistsError=Export destination already exists and cannot be overwritten.
-SpagicDeployWizardPage.requiredTalendPerlModules=Required talend modules
+SpagicDeployWizardPage.requiredTalendPerlModules=Required Talend modules

i18n/plugins/org.talend.sqlbuilder.nl/src/main/java/messages_de.properties

@@ -5,7 +5,6 @@ AbstractDataSetTab.logMessage1=DataSetTab Exception
 MultiPageSqlBuilderEditor.DesignerTab.Text=Designer
 SQLResultsView.Count.Prefix=Anzahl zur\u00FCckgelieferter Zeilen:
 SQLResultsView.NoResults=F\u00FChren Sie eine Query aus, um deren Ergebnis hier zu sehen...
-GUIModificationQueryAction.ButtonText=\u00C4ndern der Abfrage mit Hilfe des graphischen Editors
 TableNode.logMessage1=Konnte Spaltennamen nicht laden
 EditQueriesAction.textEditQueries=Queries bearbeiten
 BuildInDBStructure.CurrentSchema=Aktuelles Schema
@@ -251,7 +250,6 @@ ConnectionInfoTab.property76=Unterst\u00FCtzt Full Outer Joins
 ConnectionInfoTab.property75=Unterst\u00FCtzt Outer Joins
 ConnectionInfoTab.property73=Unterst\u00FCtzt ANSI92 Full SQL
 ConnectionInfoTab.property72=Unterst\u00FCtzt ANSI92 Intermediate SQL
-GUIModificationQueryAction.Dialog.TitleText=\u00C4ndern der Abfrage mit Hilfe des graphischen Editors
 ConnectionInfoTab.property70=Unterst\u00FCtzt erweiterte SQL Grammatik
 DatabaseDetailView.Tab.Preview.status=Inhaltsvorschau f\u00FCr {0}.
 DatabaseDetailView.Tab.ConnectionInfo.CommitOnClose=Commit beim Schlie\u00DFen
@@ -314,7 +312,6 @@ ConnectionInfoTab.logMessage1=Fehler bei getMaxStatementLength
 ConnectionInfoTab.property29=Max. L\u00E4nge Spaltenname
 ConnectionInfoTab.property28=Max. L\u00E4nge Literale
 ConnectionInfoTab.property27=Max. L\u00E4nge Binary-Literale
-GUIModificationQueryAction.TextDialog.TitleText=Abfrage bearbeiten
 DBStructureComposite.NewEditor=Neuer Ausdruckseditor
 SQLBuilderEditorComposite.titleQuery=Abfrage:
 ConnectionInfoTab.property22=Unterst\u00FCtzt Statement-Pooling

i18n/plugins/org.talend.sqlbuilder.nl/src/main/java/messages_el.properties

@@ -7,7 +7,6 @@ SQLResultsView.Count.Prefix=\u0391\u03C1\u03B9\u03B8\u03BC\u03CC\u03C2 \u03B3\u0
 SQLResultsView.NoResults=\u0395\u03BA\u03C4\u03B5\u03BB\u03AD\u03C3\u03C4\u03B5 \u03AD\u03BD\u03B1 \u03B5\u03C1\u03CE\u03C4\u03B7\u03BC\u03B1 \u03B3\u03B9\u03B1 \u03BD\u03B1 \u03B4\u03B5\u03AF\u03C4\u03B5 \u03C4\u03B1 \u03B1\u03C0\u03BF\u03C4\u03B5\u03BB\u03AD\u03C3\u03BC\u03B1\u03C4\u03B1 \u03B5\u03B4\u03CE...
 TableNode.logMessage4=\u0394\u03B5 \u03BC\u03C0\u03CC\u03C1\u03B5\u03C3\u03B1\u03BD \u03BD\u03B1 \u03B4\u03B7\u03BC\u03B9\u03BF\u03C5\u03C1\u03B3\u03B7\u03B8\u03BF\u03CD\u03BD \u03BA\u03CC\u03BC\u03B2\u03BF\u03B9 \u03C0\u03B1\u03B9\u03B4\u03B9\u03CE\u03BD \u03B3\u03B9\u03B1
 TableNode.logMessage3=\u0394\u03B5 \u03BC\u03C0\u03CC\u03C1\u03B5\u03C3\u03B1\u03BD \u03BD\u03B1 \u03C6\u03BF\u03C1\u03C4\u03C9\u03B8\u03BF\u03CD\u03BD \u03BF\u03BD\u03CC\u03BC\u03B1\u03C4\u03B1 \u03C0\u03C1\u03C9\u03C4\u03B5\u03CD\u03BF\u03BD\u03C4\u03C9\u03BD \u03BA\u03BB\u03B5\u03B9\u03B4\u03B9\u03CE\u03BD
-GUIModificationQueryAction.ButtonText=\u03A4\u03C1\u03BF\u03C0\u03BF\u03C0\u03BF\u03AF\u03B7\u03C3\u03B7 \u03C4\u03BF\u03C5 \u03B5\u03C1\u03C9\u03C4\u03AE\u03BC\u03B1\u03C4\u03BF\u03C2 \u03C7\u03C1\u03B7\u03C3\u03B9\u03BC\u03BF\u03C0\u03BF\u03B9\u03CE\u03BD\u03C4\u03B1\u03C2 \u03C4\u03BF \u03B3\u03C1\u03B1\u03C6\u03B9\u03BA\u03CC \u03BB\u03BF\u03B3\u03B9\u03C3\u03BC\u03B9\u03BA\u03CC \u03B5\u03C0\u03B9\u03BC\u03AD\u03BB\u03B5\u03B9\u03B1\u03C2 \u03AD\u03BA\u03B4\u03BF\u03C3\u03B7\u03C2
 TableNode.logMessage2=\u0394\u03B5 \u03BC\u03C0\u03CC\u03C1\u03B5\u03C3\u03B1\u03BD \u03BD\u03B1 \u03C6\u03BF\u03C1\u03C4\u03C9\u03B8\u03BF\u03CD\u03BD \u03BF\u03BD\u03CC\u03BC\u03B1\u03C4\u03B1 \u03BE\u03AD\u03BD\u03C9\u03BD \u03BA\u03BB\u03B5\u03B9\u03B4\u03B9\u03CE\u03BD
 TableNode.logMessage1=\u0394\u03B5 \u03BC\u03C0\u03CC\u03C1\u03B5\u03C3\u03B1\u03BD \u03BD\u03B1 \u03C6\u03BF\u03C1\u03C4\u03C9\u03B8\u03BF\u03CD\u03BD \u03BF\u03BD\u03CC\u03BC\u03B1\u03C4\u03B1 \u03C3\u03C4\u03B7\u03BB\u03CE\u03BD
 EditQueriesAction.textEditQueries=\u0395\u03C0\u03B5\u03BE\u03B5\u03C1\u03B3\u03B1\u03C3\u03AF\u03B1 \u03B5\u03C1\u03C9\u03C4\u03B7\u03BC\u03AC\u03C4\u03C9\u03BD
@@ -314,7 +313,6 @@ ConnectionInfoTab.property75=\u03A5\u03C0\u03BF\u03C3\u03C4\u03B7\u03C1\u03AF\u0
 ConnectionInfoTab.property73=\u03A5\u03C0\u03BF\u03C3\u03C4\u03B7\u03C1\u03AF\u03B6\u03B5\u03B9 ANSI92 Full SQL
 ConnectionInfoTab.property72=\u03A5\u03C0\u03BF\u03C3\u03C4\u03B7\u03C1\u03AF\u03B6\u03B5\u03B9 ANSI92 Intermediate SQL
 ConnectionInfoTab.property71=\u03A5\u03C0\u03BF\u03C3\u03C4\u03B7\u03C1\u03AF\u03B6\u03B5\u03B9 ANSI92 Entry Level SQL
-GUIModificationQueryAction.Dialog.TitleText=\u03A4\u03C1\u03BF\u03C0\u03BF\u03C0\u03BF\u03AF\u03B7\u03C3\u03B7 \u03C4\u03BF\u03C5 \u03B5\u03C1\u03C9\u03C4\u03AE\u03BC\u03B1\u03C4\u03BF\u03C2 \u03C7\u03C1\u03B7\u03C3\u03B9\u03BC\u03BF\u03C0\u03BF\u03B9\u03CE\u03BD\u03C4\u03B1\u03C2 \u03C4\u03BF \u03B3\u03C1\u03B1\u03C6\u03B9\u03BA\u03CC \u03BB\u03BF\u03B3\u03B9\u03C3\u03BC\u03B9\u03BA\u03CC \u03B5\u03C0\u03B9\u03BC\u03AD\u03BB\u03B5\u03B9\u03B1\u03C2 \u03AD\u03BA\u03B4\u03BF\u03C3\u03B7\u03C2
 ConnectionInfoTab.property70=\u03A5\u03C0\u03BF\u03C3\u03C4\u03B7\u03C1\u03AF\u03B6\u03B5\u03B9 Extended SQL \u0393\u03C1\u03B1\u03BC\u03BC\u03B1\u03C4\u03B9\u03BA\u03AE
 DatabaseDetailView.Tab.Preview.status=\u03A0\u03C1\u03BF\u03B5\u03C0\u03B9\u03C3\u03BA\u03CC\u03C0\u03B7\u03C3\u03B7 \u03C0\u03B5\u03C1\u03B9\u03B5\u03C7\u03BF\u03BC\u03AD\u03BD\u03BF\u03C5 \u03B3\u03B9\u03B1 {0}.
 DatabaseDetailView.Tab.ConnectionInfo.CommitOnClose=\u039F\u03BB\u03BF\u03BA\u03BB\u03AE\u03C1\u03C9\u03C3\u03B7 \u03A3\u03C4\u03BF \u039A\u03BB\u03B5\u03AF\u03C3\u03B9\u03BC\u03BF
@@ -395,7 +393,6 @@ ConnectionInfoTab.logMessage2=\u03A3\u03C6\u03AC\u03BB\u03BC\u03B1 \u03C3\u03C4\
 ConnectionInfoTab.logMessage1=\u03A3\u03C6\u03AC\u03BB\u03BC\u03B1 \u03C3\u03C4\u03BF getMaxStatementLength
 DictionaryLoader.teseedOk=\u03B5\u03BB\u03AD\u03B3\u03B8\u03B7\u03BA\u03B5 \u03BA\u03B1\u03B9 \u03B5\u03AF\u03BD\u03B1\u03B9 ok
 ConnectionInfoTab.property29=\u039C\u03AD\u03B3\u03B9\u03C3\u03C4\u03BF \u039C\u03AE\u03BA\u03BF\u03C2 \u039F\u03BD\u03CC\u03BC\u03B1\u03C4\u03BF\u03C2 \u03A3\u03C4\u03AE\u03BB\u03B7\u03C2
-GUIModificationQueryAction.TextDialog.TitleText=\u03A4\u03C1\u03BF\u03C0\u03BF\u03C0\u03BF\u03AF\u03B7\u03C3\u03B7 \u03C4\u03BF\u03C5 \u03B5\u03C1\u03C9\u03C4\u03AE\u03BC\u03B1\u03C4\u03BF\u03C2
 ConnectionInfoTab.property26=\u03A5\u03C0\u03BF\u03C3\u03C4\u03B7\u03C1\u03AF\u03B6\u03B5\u03B9 \u0386\u03BD\u03BF\u03B9\u03B3\u03BC\u03B1 \u0394\u03B7\u03BB\u03CE\u03C3\u03B5\u03C9\u03BD \u039A\u03B1\u03C4\u03AC \u03A4\u03B7\u03BD \u0391\u03BA\u03CD\u03C1\u03C9\u03C3\u03B7 \u03A3\u03C5\u03BD\u03B1\u03BB\u03BB\u03B1\u03B3\u03AE\u03C2
 ConnectionInfoTab.property25=\u03A5\u03C0\u03BF\u03C3\u03C4\u03B7\u03C1\u03AF\u03B6\u03B5\u03B9 \u0391\u03BD\u03BF\u03B9\u03BA\u03C4\u03AD\u03C2 \u0394\u03B7\u03BB\u03CE\u03C3\u03B5\u03B9\u03C2 \u03A3\u03B5 \u038C\u03BB\u03B7 \u03A4\u03B7\u03BD \u039F\u03BB\u03BF\u03BA\u03BB\u03AE\u03C1\u03C9\u03C3\u03B7
 ConnectionInfoTab.property24=\u03A5\u03C0\u03BF\u03C3\u03C4\u03B7\u03C1\u03AF\u03B6\u03B5\u03B9 \u0386\u03BD\u03BF\u03B9\u03B3\u03BC\u03B1 \u0394\u03C1\u03BF\u03BC\u03AD\u03C9\u03BD \u039A\u03B1\u03C4\u03AC \u03A4\u03B7\u03BD \u0391\u03BA\u03CD\u03C1\u03C9\u03C3\u03B7 \u03A3\u03C5\u03BD\u03B1\u03BB\u03BB\u03B1\u03B3\u03AE\u03C2

i18n/plugins/org.talend.sqlbuilder.nl/src/main/java/messages_en.properties

@@ -4,11 +4,10 @@ AbstractDataSetTab.logMessage2=Error creating ResultSetTab:
 AbstractDataSetTab.logMessage1=DataSetTab Exception
 MultiPageSqlBuilderEditor.DesignerTab.Text=Designer
 SQLResultsView.Count.Prefix=Number of rows returned:
-MultiPageSqlBuilderEditor.ErrorInfo=Parse Sql Statement Error: 
+MultiPageSqlBuilderEditor.ErrorInfo=Parse Sql Statement Error:
 SQLResultsView.NoResults=Execute a query to view the results here...
-TableNode.logMessage4=Could not create child nodes for 
+TableNode.logMessage4=Could not create child nodes for
 TableNode.logMessage3=Could not load primary key names
-GUIModificationQueryAction.ButtonText=Modify the query using graphical editor
 TableNode.logMessage2=Could not load foreign key names
 TableNode.logMessage1=Could not load column names
 EditQueriesAction.textEditQueries=Edit queries
@@ -26,8 +25,8 @@ Images.SqlEditorIcon=icons/edittsk_tsk.gif
 Open_2=Open
 Open_1=Open
 MultiPageSqlBuilderEditor.AddComment.Info=Get the query from the Designer tab?
-ImageUtil.logMessage3=Could not create image for 
-ImageUtil.logMessage2=Missing image path for 
+ImageUtil.logMessage3=Could not create image for
+ImageUtil.logMessage2=Missing image path for
 ImageUtil.logMessage1=Error while disposing images
 OpenDialogJob.Waitdatabase=Waiting for SqlBuilderDialog to open in built-in mode...
 DatabaseDetailView.Tab.ColumnPrefix=, col:
@@ -35,7 +34,7 @@ SessionTreeNodeUtils.logMessage=Database connection closed
 SQLEditor.Actions.ChooseSession.ToolTip=Choose Connection
 DBTreeProvider.logMessage=PersistenceException: 
 DBStructureComposite.exceptionMessage=This repository list should not be empty.
-IndexFolderNode.logMessage2=Could not create child nodes for 
+IndexFolderNode.logMessage2=Could not create child nodes for
 IndexFolderNode.logMessage1=Could not load index names
 Images.PrimaryKeyIcon=icons/pkColumn.gif
 Progress.Dictionary.Cancelled=Operation cancelled by User
@@ -45,10 +44,10 @@ DBTreeProvider.sourceName=Stored Queries
 DatabaseDetailView.Tab.ExportedKeys=Exported Keys
 DatabaseDetailView.Tab.RowCount=Row Count
 AddTablesComposite.textTables=Tables
-SessionTreeNode.logMessage6=Error while getting the alias name 
-SessionTreeNode.logMessage5=Error while rollbacking 
+SessionTreeNode.logMessage6=Error while getting the alias name
+SessionTreeNode.logMessage5=Error while rollbacking
 SessionTreeNode.logMessage4=Could not perform commit/rollback or catalog change.
-SessionTreeNode.logMessage3=Error while committing 
+SessionTreeNode.logMessage3=Error while committing
 SessionTreeNode.logMessage2=Error while closing background database connection
 SessionTreeNode.logMessage1=Error while closing interactive database connection
 DatabaseDetailView.Tab.ColumnInfo.status=Columns for {0}.
@@ -66,7 +65,7 @@ DB2ExplainPlanAction.logMessage1=Get SessionTreeNode failed
 db2.editor.actions.explain=Show DB2 Explain Plan
 SQLBuilderRepositoryNodeManager.exceptionMessage=RepositoryNode with folder info should not call this.
 DatabaseDetailView.Tab.ConnectionInfo=Connection Info
-CopyTableAction.logMessage=Error exporting to clipboard 
+CopyTableAction.logMessage=Error exporting to clipboard
 Images.ForeignKeyIcon=icons/fk_rdbcolumn.gif
 Images.title=icons/sqlbuildertitle.png
 Images.RefreshIcon=icons/update.gif
@@ -106,37 +105,37 @@ DatabaseDetailView.Tab.Unavailable=No detail information available for
 MultiPageSqlBuilderEditor.NoticeTitle.Text=Note
 Clear_2=Clear
 Clear_1=Clear
-TableFolderNode.logMessage=Could not load child nodes for 
+TableFolderNode.logMessage=Could not load child nodes for
 SQLEditor.LimitRows.Error=Invalid row limit, value should be between 0 and 5000.
 Images.ExecSQLIcon=icons/run_exc.gif
 SQLEditor.Actions.Execute=Execute SQL
 SQLBuilderDialog.SaveAllQueries.Title=Save all queries
-ConnectionInfoTab.logMessage99=Error on getting supportsOrderByUnrelated 
-ConnectionInfoTab.logMessage98=Error on getting supportsExpressionsInOrderBy 
-ConnectionInfoTab.logMessage97=Error on getting supportsDifferentTableCorrelationNames 
-ConnectionInfoTab.logMessage96=Error on getting supportsTableCorrelationNames 
-ConnectionInfoTab.logMessage95=Error on getting supportsConvert 
+ConnectionInfoTab.logMessage99=Error on getting supportsOrderByUnrelated
+ConnectionInfoTab.logMessage98=Error on getting supportsExpressionsInOrderBy
+ConnectionInfoTab.logMessage97=Error on getting supportsDifferentTableCorrelationNames
+ConnectionInfoTab.logMessage96=Error on getting supportsTableCorrelationNames
+ConnectionInfoTab.logMessage95=Error on getting supportsConvert
 Images.TableIcon=icons/table.gif
-ConnectionInfoTab.logMessage94=Error on getting nullPlusNonNullIsNull 
+ConnectionInfoTab.logMessage94=Error on getting nullPlusNonNullIsNull
 Preferences=Preferences
-ConnectionInfoTab.logMessage93=Error on getting supportsColumnAliasing 
+ConnectionInfoTab.logMessage93=Error on getting supportsColumnAliasing
 OpenSQLBuilderDialogProgress.exceptionMessage=Opening of SqlBuilderDialog cancelled
-ConnectionInfoTab.logMessage92=Error on getting supportsAlterTableWithDropColumn 
-ConnectionInfoTab.logMessage91=Error on getting supportsAlterTableWithAddColumn 
-ConnectionInfoTab.logMessage90=Error on getExtraNameCharacters 
+ConnectionInfoTab.logMessage92=Error on getting supportsAlterTableWithDropColumn
+ConnectionInfoTab.logMessage91=Error on getting supportsAlterTableWithAddColumn
+ConnectionInfoTab.logMessage90=Error on getExtraNameCharacters
 Images.ExportIcon=icons/ExportData.gif
 DatabaseDetailView.Tab.ConnectionInfo.NullsSortedHigh=Nulls Are Sorted High
 DataSetTableActionGroup.logMessage1=Could not create menu action
-ConnectionInfoTab.logMessage89=Error on getSearchStringEscape 
-ConnectionInfoTab.logMessage88=Error on getIdentifierQuoteString 
-ConnectionInfoTab.logMessage87=Error on getting storesMixedCaseQuotedIdentifiers 
-ConnectionInfoTab.logMessage86=Error on getting storesLowerCaseQuotedIdentifiers 
-ConnectionInfoTab.logMessage85=Error on getting storesUpperCaseQuotedIdentifiers 
-ConnectionInfoTab.logMessage84=Error on getting supportsMixedCaseQuotedIdentifiers 
-ConnectionInfoTab.logMessage83=Error on getting storesMixedCaseIdentifiers 
-ConnectionInfoTab.logMessage82=Error on getCatalogSeparator 
-ConnectionInfoTab.logMessage81=Error on getting isCatalogAtStart 
-ConnectionInfoTab.logMessage80=Error on getCatalogTerm 
+ConnectionInfoTab.logMessage89=Error on getSearchStringEscape
+ConnectionInfoTab.logMessage88=Error on getIdentifierQuoteString
+ConnectionInfoTab.logMessage87=Error on getting storesMixedCaseQuotedIdentifiers
+ConnectionInfoTab.logMessage86=Error on getting storesLowerCaseQuotedIdentifiers
+ConnectionInfoTab.logMessage85=Error on getting storesUpperCaseQuotedIdentifiers
+ConnectionInfoTab.logMessage84=Error on getting supportsMixedCaseQuotedIdentifiers
+ConnectionInfoTab.logMessage83=Error on getting storesMixedCaseIdentifiers
+ConnectionInfoTab.logMessage82=Error on getCatalogSeparator
+ConnectionInfoTab.logMessage81=Error on getting isCatalogAtStart
+ConnectionInfoTab.logMessage80=Error on getCatalogTerm
 OpenFileAction.logTextErrorLoadingDoc=Error while loading document
 ConnectionInfoTab.property108=Stores Lower Case Identifiers
 ConnectionInfoTab.property107=Stores Upper Case Identifiers
@@ -150,30 +149,30 @@ ConnectionInfoTab.property102=Supports Group By Beyond Select
 ConnectionInfoTab.property101=Supports Group By Unrelated
 ConnectionInfoTab.property100=Supports Group By
 SQLEditor.Actions.SaveSQL=Save as
-ConnectionInfoTab.logMessage79=Error on getProcedureTerm 
-ConnectionInfoTab.logMessage78=Error on getSchemaTerm 
-ConnectionInfoTab.logMessage77=Error on getting supportsLimitedOuterJoins 
-ConnectionInfoTab.logMessage76=Error on getting supportsFullOuterJoins 
-ConnectionInfoTab.logMessage75=Error on getting supportsOuterJoins 
-ConnectionInfoTab.logMessage74=Error on getting supportsIntegrityEnhancementFacility 
-ConnectionInfoTab.logMessage73=Error on getting supportsANSI92FullSQL 
-ConnectionInfoTab.logMessage72=Error on getting supportsANSI92IntermediateSQL 
-ConnectionInfoTab.logMessage71=Error on getting supportsANSI92EntryLevelSQL 
-ConnectionInfoTab.logMessage70=Error on getting supportsExtendedSQLGrammar 
+ConnectionInfoTab.logMessage79=Error on getProcedureTerm
+ConnectionInfoTab.logMessage78=Error on getSchemaTerm
+ConnectionInfoTab.logMessage77=Error on getting supportsLimitedOuterJoins
+ConnectionInfoTab.logMessage76=Error on getting supportsFullOuterJoins
+ConnectionInfoTab.logMessage75=Error on getting supportsOuterJoins
+ConnectionInfoTab.logMessage74=Error on getting supportsIntegrityEnhancementFacility
+ConnectionInfoTab.logMessage73=Error on getting supportsANSI92FullSQL
+ConnectionInfoTab.logMessage72=Error on getting supportsANSI92IntermediateSQL
+ConnectionInfoTab.logMessage71=Error on getting supportsANSI92EntryLevelSQL
+ConnectionInfoTab.logMessage70=Error on getting supportsExtendedSQLGrammar
 GUIModificationQueryAction.Error.Notice=Note
 DatabaseDetailView.Tab.ConnectionInfo.AutocommitMode=Autocommit Mode
 IndexNode.logMessage=Could not load column names
-ConnectionInfoTab.logMessage69=Error on getting supportsCoreSQLGrammar 
+ConnectionInfoTab.logMessage69=Error on getting supportsCoreSQLGrammar
 SQLResultsView.Error.Title=Error while executing SQL
-ConnectionInfoTab.logMessage68=Error on getting supportsMinimumSQLGrammar 
-ConnectionInfoTab.logMessage67=Error on getting supportsNonNullableColumns 
-ConnectionInfoTab.logMessage66=Error on getting supportsMultipleTransactions 
-ConnectionInfoTab.logMessage65=Error on getting supportsMultipleOpenResults 
-ConnectionInfoTab.logMessage64=Error on getting supportsMultipleResultSets 
-ConnectionInfoTab.logMessage63=Error on getting supportsLikeEscapeClause 
-ConnectionInfoTab.logMessage62=Error on getting supportsUnionAll 
-ConnectionInfoTab.logMessage61=Error on getting supportsUnion 
-ConnectionInfoTab.logMessage60=Error on getting supportsCorrelatedSubqueries 
+ConnectionInfoTab.logMessage68=Error on getting supportsMinimumSQLGrammar
+ConnectionInfoTab.logMessage67=Error on getting supportsNonNullableColumns
+ConnectionInfoTab.logMessage66=Error on getting supportsMultipleTransactions
+ConnectionInfoTab.logMessage65=Error on getting supportsMultipleOpenResults
+ConnectionInfoTab.logMessage64=Error on getting supportsMultipleResultSets
+ConnectionInfoTab.logMessage63=Error on getting supportsLikeEscapeClause
+ConnectionInfoTab.logMessage62=Error on getting supportsUnionAll
+ConnectionInfoTab.logMessage61=Error on getting supportsUnion
+ConnectionInfoTab.logMessage60=Error on getting supportsCorrelatedSubqueries
 MetadataRefreshAction.textSynchronize=Synchronize
 DatabaseDetailView.Tab.ConnectionInfo.UserName=User Name
 DB2ExplainPlanExecution.tableColumnText2=Cardinality
@@ -183,84 +182,84 @@ Images.CopyIcon=icons/copy_edit.gif
 DBStructureComposite.TakeALongTime=It'll take a long time. Continue?
 Images.IndexIcon=icons/index.gif
 AbstractSQLExecution.Executing.Error=Error Executing SQL
-ConnectionInfoTab.logMessage59=Error on getting supportsSubqueriesInQuantifieds 
-ConnectionInfoTab.logMessage58=Error on getting supportsSubqueriesInIns 
-ConnectionInfoTab.logMessage57=Error on getting supportsSubqueriesInExists 
-ConnectionInfoTab.logMessage56=Error on getting supportsSubqueriesInComparisons 
+ConnectionInfoTab.logMessage59=Error on getting supportsSubqueriesInQuantifieds
+ConnectionInfoTab.logMessage58=Error on getting supportsSubqueriesInIns
+ConnectionInfoTab.logMessage57=Error on getting supportsSubqueriesInExists
+ConnectionInfoTab.logMessage56=Error on getting supportsSubqueriesInComparisons
 DatabaseDetailView.Tab.RowPrefix=row:
-ConnectionInfoTab.logMessage55=Error on getting supportsStoredProcedures 
-ConnectionInfoTab.logMessage54=Error on getting supportsPositionedUpdate 
-ConnectionInfoTab.logMessage53=Error on getting supportsPositionedDelete 
-ConnectionInfoTab.logMessage52=Error on getting supportsCatalogsInPrivilegeDefinitions 
-ConnectionInfoTab.logMessage51=Error on getting supportsCatalogsInIndexDefinitions 
-ConnectionInfoTab.logMessage50=Error on getting supportsCatalogsInTableDefinitions 
+ConnectionInfoTab.logMessage55=Error on getting supportsStoredProcedures
+ConnectionInfoTab.logMessage54=Error on getting supportsPositionedUpdate
+ConnectionInfoTab.logMessage53=Error on getting supportsPositionedDelete
+ConnectionInfoTab.logMessage52=Error on getting supportsCatalogsInPrivilegeDefinitions
+ConnectionInfoTab.logMessage51=Error on getting supportsCatalogsInIndexDefinitions
+ConnectionInfoTab.logMessage50=Error on getting supportsCatalogsInTableDefinitions
 DataSetTable.PopUp.Find=Scroll To Column:   (ENTER: find next)
 SqlBuilderPreferencePage.AddQuotes=add quotes, when you generate sql statement
-ConnectionInfoTab.LogMessage25=Error on getting supportsOpenStatementsAcrossCommit 
+ConnectionInfoTab.LogMessage25=Error on getting supportsOpenStatementsAcrossCommit
 ConnectionInfoTab.property9=Supports Data Manipulation Transactions Only
 ConnectionInfoTab.property8=Supports Data Definition and Data Manipulation Transactions
 ConnectionInfoTab.property7=Supports Transactions
 ConnectionInfoTab.property6=Default Transaction Isolation
 ConnectionInfoTab.property5=Max User Name Length
-ConnectionInfoTab.logMessage49=Error on getting supportsCatalogsInProcedureCalls 
+ConnectionInfoTab.logMessage49=Error on getting supportsCatalogsInProcedureCalls
 ConnectionInfoTab.property4=Max Tables In Select
-ConnectionInfoTab.logMessage48=Error on getting supportsCatalogsInDataManipulation 
+ConnectionInfoTab.logMessage48=Error on getting supportsCatalogsInDataManipulation
 ConnectionInfoTab.property3=Max Table Name Length
-ConnectionInfoTab.logMessage47=Error on getting supportsSchemasInPrivilegeDefinitions 
+ConnectionInfoTab.logMessage47=Error on getting supportsSchemasInPrivilegeDefinitions
 ConnectionInfoTab.property2=Max Statements
-ConnectionInfoTab.logMessage46=Error on getting supportsSchemasInIndexDefinitions 
+ConnectionInfoTab.logMessage46=Error on getting supportsSchemasInIndexDefinitions
 ConnectionInfoTab.property1=Max Statement Length
-ConnectionInfoTab.logMessage45=Error on getting supportsSchemasInTableDefinitions 
-ConnectionInfoTab.logMessage44=Error on getting supportsSchemasInProcedureCalls 
-ConnectionInfoTab.logMessage43=Error on getting supportsSchemasInDataManipulation 
-ConnectionInfoTab.logMessage42=Error on getting doesMaxRowSizeIncludeBlobs 
-CopyCellAction.logMessage=Error exporting cell to clipboard 
-ConnectionInfoTab.logMessage41=Error on getMaxRowSize 
-ConnectionInfoTab.logMessage40=Error on getMaxCatalogNameLength 
+ConnectionInfoTab.logMessage45=Error on getting supportsSchemasInTableDefinitions
+ConnectionInfoTab.logMessage44=Error on getting supportsSchemasInProcedureCalls
+ConnectionInfoTab.logMessage43=Error on getting supportsSchemasInDataManipulation
+ConnectionInfoTab.logMessage42=Error on getting doesMaxRowSizeIncludeBlobs
+CopyCellAction.logMessage=Error exporting cell to clipboard
+ConnectionInfoTab.logMessage41=Error on getMaxRowSize
+ConnectionInfoTab.logMessage40=Error on getMaxCatalogNameLength
 Images.DefaultNodeImage=icons/app_obj.gif
 SqlBuilderPreferencePage.ActivedTimeoutSetting=Activate the timeout for database connection.
 DatabaseDetailView.Tab.RowCount.status=Row Count for {0}.
 SQLResultsView.Time.Postfix=ms.
-ConnectionInfoTab.logMessage39=Error on getMaxProcedureNameLength 
-ConnectionInfoTab.logMessage38=Error on getMaxSchemaNameLength 
+ConnectionInfoTab.logMessage39=Error on getMaxProcedureNameLength
+ConnectionInfoTab.logMessage38=Error on getMaxSchemaNameLength
 UnsignedWordRule.logMessage=Error while getting column names
-ConnectionInfoTab.logMessage37=Error on getMaxIndexLength 
-ConnectionInfoTab.logMessage36=Error on getMaxCursorNameLength 
-ConnectionInfoTab.logMessage35=Error on getMaxConnections 
-ConnectionInfoTab.logMessage34=Error on getMaxColumnsInTable 
+ConnectionInfoTab.logMessage37=Error on getMaxIndexLength
+ConnectionInfoTab.logMessage36=Error on getMaxCursorNameLength
+ConnectionInfoTab.logMessage35=Error on getMaxConnections
+ConnectionInfoTab.logMessage34=Error on getMaxColumnsInTable
 Images.OpenFolder=icons/openFolder.gif
-ConnectionInfoTab.logMessage33=Error on getMaxColumnsInSelect 
-ConnectionInfoTab.logMessage32=Error on getMaxColumnsInOrderBy 
-ConnectionInfoTab.logMessage31=Error on getMaxColumnsInIndex 
-ConnectionInfoTab.logMessage30=Error on getMaxColumnsInGroupBy 
+ConnectionInfoTab.logMessage33=Error on getMaxColumnsInSelect
+ConnectionInfoTab.logMessage32=Error on getMaxColumnsInOrderBy
+ConnectionInfoTab.logMessage31=Error on getMaxColumnsInIndex
+ConnectionInfoTab.logMessage30=Error on getMaxColumnsInGroupBy
 DatabaseDetailView.Tab.ConnectionInfo.NullsSortedLow=Nulls Are Sorted Low
 ErDiagramDialog.textGenerateSelectStatement=Generate Select Statement
 Images.RedIcon=icons/red.gif
 MultiPageSqlBuilderEditor.EditTab.Text=Edit
-ConnectionInfoTab.logMessage29=Error on getMaxColumnNameLength 
-ConnectionInfoTab.logMessage28=Error on getMaxCharLiteralLength 
-ConnectionInfoTab.logMessage27=Error on getMaxBinaryLiteralLength 
-ConnectionInfoTab.logMessage26=Error on getting supportsOpenStatementsAcrossRollback 
-ConnectionInfoTab.logMessage24=Error on getting supportsOpenCursorsAcrossRollback 
-ConnectionInfoTab.logMessage23=Error on getting supportsOpenCursorsAcrossCommit 
-ConnectionInfoTab.logMessage22=Error on getting isReadOnly 
-ConnectionInfoTab.logMessage21=Error on getting supportsStatementPooling 
-ConnectionInfoTab.logMessage20=Error on getting locatorsUpdateCopy 
-CopyColumnNameAction.logMessage=Error exporting cell to clipboard 
+ConnectionInfoTab.logMessage29=Error on getMaxColumnNameLength
+ConnectionInfoTab.logMessage28=Error on getMaxCharLiteralLength
+ConnectionInfoTab.logMessage27=Error on getMaxBinaryLiteralLength
+ConnectionInfoTab.logMessage26=Error on getting supportsOpenStatementsAcrossRollback
+ConnectionInfoTab.logMessage24=Error on getting supportsOpenCursorsAcrossRollback
+ConnectionInfoTab.logMessage23=Error on getting supportsOpenCursorsAcrossCommit
+ConnectionInfoTab.logMessage22=Error on getting isReadOnly
+ConnectionInfoTab.logMessage21=Error on getting supportsStatementPooling
+ConnectionInfoTab.logMessage20=Error on getting locatorsUpdateCopy
+CopyColumnNameAction.logMessage=Error exporting cell to clipboard
 DatabaseNode.logMessage=Error loading children
 Images.OpenFileIcon=icons/open.gif
 AbstractNode.logMessage=Could not load child nodes for {0}.
 EMFRepositoryNodeManager.Notice.title3=Note
-ConnectionInfoTab.logMessage19=Error on getSQLStateType 
-ConnectionInfoTab.logMessage18=Error on getJDBCMajorVersion 
-ConnectionInfoTab.logMessage17=Error on getJDBCMinorVersion 
-ConnectionInfoTab.logMessage16=Error on getDatabaseMinorVersion 
-ConnectionInfoTab.logMessage15=Error on getDatabaseMajorVersion 
-ConnectionInfoTab.logMessage14=Error on getting supportsGetGeneratedKeys 
-ConnectionInfoTab.logMessage13=Error on getting supportsNamedParameters 
-ConnectionInfoTab.logMessage12=Error on getting supportsSavepoints 
-ConnectionInfoTab.logMessage11=Error on getting supportsBatchUpdates 
-ConnectionInfoTab.logMessage10=Error on getting dataDefinitionIgnoredInTransactions 
+ConnectionInfoTab.logMessage19=Error on getSQLStateType
+ConnectionInfoTab.logMessage18=Error on getJDBCMajorVersion
+ConnectionInfoTab.logMessage17=Error on getJDBCMinorVersion
+ConnectionInfoTab.logMessage16=Error on getDatabaseMinorVersion
+ConnectionInfoTab.logMessage15=Error on getDatabaseMajorVersion
+ConnectionInfoTab.logMessage14=Error on getting supportsGetGeneratedKeys
+ConnectionInfoTab.logMessage13=Error on getting supportsNamedParameters
+ConnectionInfoTab.logMessage12=Error on getting supportsSavepoints
+ConnectionInfoTab.logMessage11=Error on getting supportsBatchUpdates
+ConnectionInfoTab.logMessage10=Error on getting dataDefinitionIgnoredInTransactions
 SQLEditor.Actions.SaveAs=Export as
 SqlBuilderPreferencePage.SystemSQL=System SQL Statement
 Images.GrayIcon=icons/gray.gif
@@ -285,7 +284,7 @@ SQLEditor.Actions.DuplicateNameMessage=Item with the same name already exists.
 Images.ExportToClipBoardIcon=icons/copy_edit.gif
 DatabaseDetailView.Tab.ImportedKeys.status=Imported Keys for
 DataSetTableKeyListener.logMessage2=Error refreshing
-DataSetTableKeyListener.logMessage1=Error exporting cell to clipboard 
+DataSetTableKeyListener.logMessage1=Error exporting cell to clipboard
 SQLEditor.Actions.SaveMessage=Save
 Images.Explain=icons/explain.gif
 AbstractSQLSourceTab.logMessage2=Error closing statement
@@ -314,8 +313,8 @@ ConnectionInfoTab.property83=Stores Mixed Case Identifiers
 ConnectionInfoTab.property82=Catalog Separator
 ConnectionInfoTab.property81=Is Catalog at Start
 ConnectionInfoTab.property80=Catalog Term
-SortedList.exceptionMessage=Index is greater than size or below zero for remove 
-ColumnFolderNode.logMessage=Could not create child nodes for 
+SortedList.exceptionMessage=Index is greater than size or below zero for remove
+ColumnFolderNode.logMessage=Could not create child nodes for
 ConnectionInfoTab.property79=Procedure Term
 SqlBuilderPreferencePage.ConnectionTimeout=Connection timeout (seconds)
 ConnectionInfoTab.property78=Schema Term
@@ -326,7 +325,6 @@ ConnectionInfoTab.property74=Supports Integrity Enhancement Facility
 ConnectionInfoTab.property73=Supports ANSI92 Full SQL
 ConnectionInfoTab.property72=Supports ANSI92 Intermediate SQL
 ConnectionInfoTab.property71=Supports ANSI92 Entry Level SQL
-GUIModificationQueryAction.Dialog.TitleText=Modify The Query using graphical editor
 ConnectionInfoTab.property70=Supports Extended SQL Grammar
 DatabaseDetailView.Tab.Preview.status=Content preview for {0}.
 DatabaseDetailView.Tab.ConnectionInfo.CommitOnClose=Commit On Close
@@ -337,7 +335,7 @@ ConnectionInfoTab.property68=Supports Minimum SQL Grammar
 ConnectionInfoTab.property67=Supports Non Nullable Columns
 ConnectionInfoTab.property66=Supports Multiple Transactions
 SQLBuilderEditorComposite.assertMessage=This node cannot be null
-ConnectionInfoTab.property65=Supports Multiple Open Results 
+ConnectionInfoTab.property65=Supports Multiple Open Results
 ConnectionInfoTab.property64=Supports Multiple Result Sets
 ConnectionInfoTab.property63=Supports Like Escape Clause
 ConnectionInfoTab.property62=Supports Union All
@@ -348,7 +346,7 @@ ConnectionInfoTab.property60=Supports Correlated Subqueries
 DBStructureComposite.Property=Property
 Images.DefaultParentNodeIcon=icons/outline.gif
 SQLEditor.SaveAsDialog.Title=Export query as
-DataSetTable.invalidExcepitonMessage=Invalid columnLabel or columnTypes in DataSet 
+DataSetTable.invalidExcepitonMessage=Invalid columnLabel or columnTypes in DataSet
 DataSetTable.Actions.Export.XLS=Export to .xls
 DataSetTable.Actions.Export.CSV=Export to .csv
 ConnectionInfoTab.property59=Supports Subqueries in Quantified Expressions
@@ -381,7 +379,7 @@ ConnectionInfoTab.property40=Max Catalog Name Length
 oracle.editor.actions.explain.notFound.Title=Plan Table not found
 Images.ConnectionIcon=icons/connection.png
 DatabaseDetailView.Tab.ImportedKeys=Imported Keys
-SchemaNode.logMessage4=Could not load child nodes for 
+SchemaNode.logMessage4=Could not load child nodes for
 SchemaNode.logMessage3=Loading all tables at once is not supported
 SchemaNode.logMessage2=Could not create child node
 SchemaNode.logMessage1=Could not create child node
@@ -399,21 +397,20 @@ ConnectionInfoTab.property31=Max Columns In Index
 ConnectionInfoTab.property30=Max Columns In Group By
 SQLEditor.Actions.SaveAsToolTip=Export query as
 DataSetTable.Actions.CopyCell=Copy Cell
-ConnectionInfoTab.logMessage9=Error on getting dataDefinitionCausesTransactionCommit 
-ConnectionInfoTab.logMessage8=Error on getting supportsDataManipulationTransactionsOnly 
-ConnectionInfoTab.logMessage7=Error on getting supportsDataDefinitionAndDataManipulationTransactions 
-ConnectionInfoTab.logMessage6=Error on getting supportsTransactions 
-ConnectionInfoTab.logMessage5=Error on getMaxUserNameLength 
+ConnectionInfoTab.logMessage9=Error on getting dataDefinitionCausesTransactionCommit
+ConnectionInfoTab.logMessage8=Error on getting supportsDataManipulationTransactionsOnly
+ConnectionInfoTab.logMessage7=Error on getting supportsDataDefinitionAndDataManipulationTransactions
+ConnectionInfoTab.logMessage6=Error on getting supportsTransactions
+ConnectionInfoTab.logMessage5=Error on getMaxUserNameLength
 TableNode.exceptionMessage=Only Table will call this.
-ConnectionInfoTab.logMessage4=Error on getMaxTablesInSelect 
-ConnectionInfoTab.logMessage3=Error on getMaxTableNameLength 
-ConnectionInfoTab.logMessage2=Error on getMaxStatements 
-ConnectionInfoTab.logMessage1=Error on getMaxStatementLength 
-DictionaryLoader.teseedOk=tested ok 
+ConnectionInfoTab.logMessage4=Error on getMaxTablesInSelect
+ConnectionInfoTab.logMessage3=Error on getMaxTableNameLength
+ConnectionInfoTab.logMessage2=Error on getMaxStatements
+ConnectionInfoTab.logMessage1=Error on getMaxStatementLength
+DictionaryLoader.teseedOk=tested ok
 ConnectionInfoTab.property29=Max Column Name Length
 ConnectionInfoTab.property28=Max Char Literal Length
 ConnectionInfoTab.property27=Max Binary Literal Length
-GUIModificationQueryAction.TextDialog.TitleText=Modify the query
 ConnectionInfoTab.property26=Supports Open Statements Across Rollback
 ConnectionInfoTab.property25=Supports Open Statements Across Commit
 ConnectionInfoTab.property24=Supports Open Cursors Across Rollback
@@ -469,7 +466,7 @@ Images.CatalogNodeIcon=icons/schema.gif
 db2.editor.actions.explain.notFound.Title=Plan Table not found
 DatabaseDetailView.Tab.ConnectionInfo.DriverName=Driver Name
 DatabaseDetailView.Tab.ConnectionInfo.NullsSortedEnd=Nulls Are Sorted At End
-CloseSQLResultTabAction.logMessageMissingImagePath=Missing image path for 
+CloseSQLResultTabAction.logMessageMissingImagePath=Missing image path for
 DatabaseDetailView.Tab.ConnectionInfo.URL=URL
 DatabaseDetailView.Tab.ConnectionInfo.ProceduresCallable=All Procedures Are Callable
 OracleExplainPlanAction.logMessage5=Error while creating sql execution tab
@@ -478,43 +475,43 @@ oracle.editor.actions.explain=Show Oracle Explain Plan
 OracleExplainPlanAction.logMessage3=Error while closing statement
 EMFRepositoryNodeManager.Notice.info=You must input one Sql Statement!
 OracleExplainPlanAction.logMessage2=Error while creating the plan table
-OracleExplainPlanAction.logMessage1=Failed to get SessionTreeNode 
+OracleExplainPlanAction.logMessage1=Failed to get SessionTreeNode
 Images.ColumnNodeIcon=icons/columns.gif
 SQLBuilderDialog.SaveAllQueries.Info=Are you sure you want to save all queries?
 SQLResultsView.Executing=Executing...
 DBTreeActionGroup.logMessage=Could not create menu action
-ConnectionInfoTab.logMessage123=Error on getting storesLowerCaseIdentifiers 
-ConnectionInfoTab.logMessage122=Error on getting storesUpperCaseIdentifiers 
-ConnectionInfoTab.logMessage121=Error on getting supportsMixedCaseIdentifiers 
-ConnectionInfoTab.logMessage120=Error on getting usesLocalFilePerTable 
+ConnectionInfoTab.logMessage123=Error on getting storesLowerCaseIdentifiers
+ConnectionInfoTab.logMessage122=Error on getting storesUpperCaseIdentifiers
+ConnectionInfoTab.logMessage121=Error on getting supportsMixedCaseIdentifiers
+ConnectionInfoTab.logMessage120=Error on getting usesLocalFilePerTable
 SQLEditor.SQLPropertyDialog.Name=Name
 SqlBuilderPreferencePage.StandardSQL=Standard SQL Statement
 SQLEditor.LimitRows.ConfirmNoLimit.Message=Allowing a large number of rows may result in poor performance. Continue?
-ConnectionInfoTab.logMessage119=Error on getting usesLocalFiles 
-ConnectionInfoTab.logMessage118=Error on getResultSetHoldability 
+ConnectionInfoTab.logMessage119=Error on getting usesLocalFiles
+ConnectionInfoTab.logMessage118=Error on getResultSetHoldability
 DBStructureComposite.Repository=Repository
 ConnectionInfoTab.logMessage117=Error on getting nullsAreSortedAtEnd
-ConnectionInfoTab.logMessage116=Error on getting nullsAreSortedAtStart 
+ConnectionInfoTab.logMessage116=Error on getting nullsAreSortedAtStart
 ConnectionInfoTab.logMessage115=Error on getting nullsAreSortedLow
-ConnectionInfoTab.logMessage114=Error on getting nullsAreSortedHigh 
+ConnectionInfoTab.logMessage114=Error on getting nullsAreSortedHigh
 Images.DefaultNodeIcon=icons/defaultview_misc.gif
-ConnectionInfoTab.logMessage113=Error on getting allTablesAreSelectable 
-ConnectionInfoTab.logMessage112=Error on getting allProceduresAreCallable 
-ConnectionInfoTab.logMessage111=Error on getCommitOnClose 
-ConnectionInfoTab.logMessage110=Error on getAutoCommit 
+ConnectionInfoTab.logMessage113=Error on getting allTablesAreSelectable
+ConnectionInfoTab.logMessage112=Error on getting allProceduresAreCallable
+ConnectionInfoTab.logMessage111=Error on getCommitOnClose
+ConnectionInfoTab.logMessage110=Error on getAutoCommit
 DatabaseDetailView.Tab.Source=Source
 RefreshTable.Refresh_1=Refresh Table
-ConnectionInfoTab.logMessage109=Error on getURL 
-ConnectionInfoTab.logMessage108=Error on getUserName 
-ConnectionInfoTab.logMessage107=Error on getDriverVersion 
-ConnectionInfoTab.logMessage106=Error on getDriverName 
-ConnectionInfoTab.logMessage105=Error on getDriverMinorVersion 
-ConnectionInfoTab.logMessage104=Error on getDriverMajorVersion 
-ConnectionInfoTab.logMessage103=Error on getDatabaseProductName 
+ConnectionInfoTab.logMessage109=Error on getURL
+ConnectionInfoTab.logMessage108=Error on getUserName
+ConnectionInfoTab.logMessage107=Error on getDriverVersion
+ConnectionInfoTab.logMessage106=Error on getDriverName
+ConnectionInfoTab.logMessage105=Error on getDriverMinorVersion
+ConnectionInfoTab.logMessage104=Error on getDriverMajorVersion
+ConnectionInfoTab.logMessage103=Error on getDatabaseProductName
 Progress.Dictionary.Title=Loading content assistant
-ConnectionInfoTab.logMessage102=Error on getting supportsGroupByBeyondSelect 
-ConnectionInfoTab.logMessage101=Error on getting supportsGroupByUnrelated 
-ConnectionInfoTab.logMessage100=Error on getting supportsGroupBy 
+ConnectionInfoTab.logMessage102=Error on getting supportsGroupByBeyondSelect
+ConnectionInfoTab.logMessage101=Error on getting supportsGroupByUnrelated
+ConnectionInfoTab.logMessage100=Error on getting supportsGroupBy
 Image.sqlAliasIcon=icons/sql_alias.gif
 DBStructureComposite.DatabaseStructure=Database Structure
 OracleExplainPlanExecution.tableColumnText2=Cardinality
@@ -543,3 +540,5 @@ SQLResultComposite.Result=Result
 UIUtils.DBConnectionFailure=Connection failure, check the database settings or contact your database administrator.
 SQLEditor.SQLPropertyDialog.ShowQueryProperty.title=Show Query Property
 SQLEditor.SQLPropertyDialog.ShowQueryProperty.message=Show Query Property name and comment.
+GUIModificationQueryAction.GraphicalEditorDialog.TitleText=Modify query using graphical editor
+GUIModificationQueryAction.TextEditorDialog.TitleText=Modify query

i18n/plugins/org.talend.sqlbuilder.nl/src/main/java/messages_fr.properties

@@ -8,7 +8,6 @@ MultiPageSqlBuilderEditor.ErrorInfo=Analyse de l\'erreur de l\'instruction SQL :
 SQLResultsView.NoResults=Visualisez ici le r\u00E9sultat de la requ\u00EAte...
 TableNode.logMessage4=Impossible de cr\u00E9er des n\u0153uds fils pour 
 TableNode.logMessage3=Ne peut pas charger le nom des cl\u00E9s primaires
-GUIModificationQueryAction.ButtonText=Modifier la requ\u00EAte \u00E0 l'aide de l'\u00E9diteur graphique
 TableNode.logMessage2=Ne peut pas charger le nom des cl\u00E9s \u00E9trang\u00E8res
 TableNode.logMessage1=Ne peut pas charger le nom des colonnes
 EditQueriesAction.textEditQueries=\u00C9diter les requ\u00EAtes
@@ -326,7 +325,6 @@ ConnectionInfoTab.property74=Supporte la fonction d'am\u00E9lioration d'int\u00E
 ConnectionInfoTab.property73=Supporte le SQL ANSI92 complet
 ConnectionInfoTab.property72=Supporte le SQL ANSI92 niveau int\u00E9rm\u00E9diaire
 ConnectionInfoTab.property71=Supporte le SQL ANSI92 niveau d'entr\u00E9e
-GUIModificationQueryAction.Dialog.TitleText=Modifier la requ\u00EAte \u00E0 l'aide de l'\u00E9diteur graphique
 ConnectionInfoTab.property70=Supporte la grammaire SQL \u00E9tendue
 DatabaseDetailView.Tab.Preview.status=Pr\u00E9visualisation du contenu de {0}.
 DatabaseDetailView.Tab.ConnectionInfo.CommitOnClose=Commit \u00E0 la fermeture
@@ -413,7 +411,6 @@ DictionaryLoader.teseedOk=test\u00E9 ok
 ConnectionInfoTab.property29=Longueur maximale du nom de colonne
 ConnectionInfoTab.property28=Longueur maximale du caract\u00E8re litt\u00E9ral
 ConnectionInfoTab.property27=Longueur maximale binaire litt\u00E9rale
-GUIModificationQueryAction.TextDialog.TitleText=Modifier la requ\u00EAte
 ConnectionInfoTab.property26=Supporte les instructions ouvertes sur Rollback
 ConnectionInfoTab.property25=Supporte les instructions ouvertes sur Commit
 ConnectionInfoTab.property24=Supporte les curseurs ouverts sur Rollback

i18n/plugins/org.talend.sqlbuilder.nl/src/main/java/messages_ja.properties

@@ -8,7 +8,6 @@ MultiPageSqlBuilderEditor.ErrorInfo=SQL\u6587\u30A8\u30E9\u30FC\u306E\u89E3\u679
 SQLResultsView.NoResults=\u30AF\u30A8\u30EA\u3092\u5B9F\u884C\u3059\u308B\u3068\u7D50\u679C\u304C\u3053\u3053\u306B\u8868\u793A\u3055\u308C\u307E\u3059...
 TableNode.logMessage4=\u5B50\u30CE\u30FC\u30C9\u3092\u4F5C\u6210\u3067\u304D\u307E\u305B\u3093\u3067\u3057\u305F
 TableNode.logMessage3=\u30D7\u30E9\u30A4\u30DE\u30EA\u30AD\u30FC\u540D\u3092\u30ED\u30FC\u30C9\u3067\u304D\u307E\u305B\u3093\u3067\u3057\u305F\u3002
-GUIModificationQueryAction.ButtonText=SQL\u30A8\u30C7\u30A3\u30BF\u3092\u4F7F\u7528\u3057\u3066\u30AF\u30A8\u30EA\u3092\u7DE8\u96C6
 TableNode.logMessage2=\u5916\u90E8\u30AD\u30FC\u540D\u3092\u30ED\u30FC\u30C9\u3067\u304D\u307E\u305B\u3093\u3067\u3057\u305F
 TableNode.logMessage1=\u30AB\u30E9\u30E0\u540D\u3092\u30ED\u30FC\u30C9\u3067\u304D\u307E\u305B\u3093\u3067\u3057\u305F
 EditQueriesAction.textEditQueries=\u30AF\u30A8\u30EA\u306E\u7DE8\u96C6
@@ -326,7 +325,6 @@ ConnectionInfoTab.property74=Integrity Enhancement Facility\u306E\u30B5\u30DD\u3
 ConnectionInfoTab.property73=ANSI92 Full SQL\u306E\u30B5\u30DD\u30FC\u30C8
 ConnectionInfoTab.property72=ANSI92 Intermediate SQL\u306E\u30B5\u30DD\u30FC\u30C8
 ConnectionInfoTab.property71=ANSI92\u30A8\u30F3\u30C8\u30EA\u30EC\u30D9\u30EBSQL\u306E\u30B5\u30DD\u30FC\u30C8
-GUIModificationQueryAction.Dialog.TitleText=SQL\u30A8\u30C7\u30A3\u30BF\u3092\u4F7F\u7528\u3057\u3066\u30AF\u30A8\u30EA\u3092\u7DE8\u96C6
 ConnectionInfoTab.property70=\u62E1\u5F35SQL\u6587\u6CD5\u306E\u30B5\u30DD\u30FC\u30C8
 DatabaseDetailView.Tab.Preview.status=\u30B3\u30F3\u30C6\u30F3\u30C4\u30D7\u30EC\u30D3\u30E5\u30FC\uFF5B0\uFF5D
 DatabaseDetailView.Tab.ConnectionInfo.CommitOnClose=\u9589\u3058\u308B\u6642\u306B\u30B3\u30DF\u30C3\u30C8
@@ -413,7 +411,6 @@ DictionaryLoader.teseedOk=\u30C6\u30B9\u30C8\u6210\u529F
 ConnectionInfoTab.property29=\u6700\u5927\u30AB\u30E9\u30E0\u540D\u9577
 ConnectionInfoTab.property28=\u6700\u5927Char\u6587\u5B57\u5217\u9577
 ConnectionInfoTab.property27=\u6700\u5927\u30D0\u30A4\u30CA\u30EA\u6587\u5B57\u5217\u9577
-GUIModificationQueryAction.TextDialog.TitleText=\u30AF\u30A8\u30EA\u3092\u7DE8\u96C6
 ConnectionInfoTab.property26=Open Statements Across Rollback\u306E\u30B5\u30DD\u30FC\u30C8
 ConnectionInfoTab.property25=\u30B3\u30DF\u30C3\u30C8\u51E6\u7406\u4E2D\u306E\u30B9\u30C6\u30FC\u30C8\u30E1\u30F3\u30C8\u30AA\u30FC\u30D7\u30F3\u306E\u30B5\u30DD\u30FC\u30C8
 ConnectionInfoTab.property24=\u30ED\u30FC\u30EB\u30D0\u30C3\u30AF\u51E6\u7406\u4E2D\u306E\u30AB\u30FC\u30BD\u30EB\u30AA\u30FC\u30D7\u30F3\u306E\u30B5\u30DD\u30FC\u30C8

i18n/plugins/org.talend.sqlbuilder.nl/src/main/java/messages_pt_BR.properties

@@ -3,7 +3,6 @@ AbstractDataSetTab.logMessage2=Erro ao criar ResultSetTab:
 AbstractDataSetTab.logMessage1=Exce\u00E7\u00E3o DataSetTab
 MultiPageSqlBuilderEditor.DesignerTab.Text=Designer
 MultiPageSqlBuilderEditor.ErrorInfo=Parse Sql argumento erro:
-GUIModificationQueryAction.ButtonText=Modificar a consulta usando editor gr\u00E1fico
 EditQueriesAction.textEditQueries=Editar consultas
 BuildInDBStructure.CurrentSchema=Esquema atual
 oracle.editor.actions.explain.createError.Title=Tabela n\u00E3o criada
@@ -196,7 +195,6 @@ ConnectionInfoTab.property74=Suporta Facilidade de Melhoramento de Integridade
 ConnectionInfoTab.property73=Suporta o SQL ANSI92 Completo
 ConnectionInfoTab.property72=Suporta ANSI92 \u00E0 N\u00EDvel Intermedi\u00E1rio
 ConnectionInfoTab.property71=Suporta SQL ANSI92 \u00E0 N\u00EDvel Entrada
-GUIModificationQueryAction.Dialog.TitleText=Modificar a consulta usando editor gr\u00E1fico
 ConnectionInfoTab.property70=Suporta Gram\u00E1tica Extendida SQL
 DatabaseDetailView.Tab.Preview.status=Contem vizualiza\u00E7\u00E3o para {0}
 DatabaseDetailView.Tab.ConnectionInfo.CommitOnClose=Commit e fecha
@@ -264,7 +262,6 @@ ConnectionInfoTab.logMessage1=Erro ao getMaxStatementLength
 ConnectionInfoTab.property29=Tam. M\u00E1x do nome da Coluna
 ConnectionInfoTab.property28=Tam. M\u00E1x. do Char Literal
 ConnectionInfoTab.property27=Tamanho m\u00E1ximo do Literal bin\u00E1rio
-GUIModificationQueryAction.TextDialog.TitleText=Modificar consulta
 ConnectionInfoTab.property26=Suporta Statement Aberto no Rollback
 ConnectionInfoTab.property25=Suporta Statement Aberto no Commit
 ConnectionInfoTab.property24=Suporta Cursor Aberto no Rollback

i18n/plugins/org.talend.sqlbuilder.nl/src/main/java/messages_ru.properties

@@ -289,7 +289,6 @@ ConnectionInfoTab.logMessage1=\u041E\u0448\u0438\u0431\u043A\u0430 \u0432 getMax
 ConnectionInfoTab.property29=\u041C\u0430\u043A\u0441\u0438\u043C\u0430\u043B\u044C\u043D\u0430\u044F \u0434\u043B\u0438\u043D\u0430 \u0438\u043C\u0435\u043D\u0438 \u043A\u043E\u043B\u043E\u043D\u043A\u0438
 ConnectionInfoTab.property28=\u041C\u0430\u043A\u0441\u0438\u043C\u0430\u043B\u044C\u043D\u0430\u044F \u0434\u043B\u0438\u043D\u0430 \u043B\u0438\u0442\u0435\u0440\u0430\u043B\u0430 \u0442\u0438\u043F\u0430 Char
 ConnectionInfoTab.property27=\u041C\u0430\u043A\u0441\u0438\u043C\u0430\u043B\u044C\u043D\u0430\u044F \u0434\u043B\u0438\u043D\u0430 \u0431\u0438\u043D\u0430\u0440\u043D\u043E\u0433\u043E \u043B\u0438\u0442\u0435\u0440\u0430\u043B\u0430
-GUIModificationQueryAction.TextDialog.TitleText=\u0418\u0437\u043C\u0435\u043D\u0438\u0442\u044C \u0437\u0430\u043F\u0440\u043E\u0441
 ConnectionInfoTab.property26=\u041F\u043E\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u0442 \u043E\u0442\u043A\u0440\u044B\u0442\u044B\u0435 Statements \u043F\u0440\u0438 Rollback
 ConnectionInfoTab.property25=\u041F\u043E\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u0442 \u043E\u0442\u043A\u0440\u044B\u0442\u044B\u0435 Statements \u043F\u0440\u0438 Commit
 ConnectionInfoTab.property24=\u041F\u043E\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u0442 \u043E\u0442\u043A\u0440\u044B\u0442\u044B\u0435 \u043A\u0443\u0440\u0441\u043E\u0440\u044B \u043F\u0440\u0438 Rollback

i18n/plugins/org.talend.sqlbuilder.nl/src/main/java/messages_zh_CN.properties

@@ -8,7 +8,6 @@ MultiPageSqlBuilderEditor.ErrorInfo=\u89E3\u6790SQL\u8BED\u53E5\u51FA\u9519\uFF1
 SQLResultsView.NoResults=\u6267\u884C\u4E00\u4E2A\u67E5\u8BE2\u663E\u793A\u7ED3\u679C...
 TableNode.logMessage4=\u65E0\u6CD5\u4E3A\u4EE5\u4E0B\u9879\u521B\u5EFA\u5B50\u8282\u70B9\uFF1A
 TableNode.logMessage3=\u4E0D\u80FD\u52A0\u8F7D\u4E3B\u952E\u540D
-GUIModificationQueryAction.ButtonText=\u56FE\u5F62\u754C\u9762\u4FEE\u6539\u67E5\u8BE2
 TableNode.logMessage2=\u4E0D\u80FD\u52A0\u8F7D\u5916\u952E\u540D
 TableNode.logMessage1=\u65E0\u6CD5\u52A0\u8F7D\u5217\u540D
 EditQueriesAction.textEditQueries=\u7F16\u8F91\u67E5\u8BE2
@@ -326,7 +325,6 @@ ConnectionInfoTab.property74=\u652F\u6301\u5B8C\u6574\u6027\u589E\u5F3A\u5DE5\u5
 ConnectionInfoTab.property73=\u652F\u6301 ANSI92 \u5168\u90E8 SQL
 ConnectionInfoTab.property72=\u652F\u6301 ANSI92 \u4E2D\u7EA7 SQL
 ConnectionInfoTab.property71=\u652F\u6301 ANSI92 \u5165\u95E8\u7EA7 SQL
-GUIModificationQueryAction.Dialog.TitleText=\u56FE\u5F62\u754C\u9762\u4FEE\u6539\u67E5\u8BE2
 ConnectionInfoTab.property70=\u652F\u6301\u6269\u5C55 SQL \u8BED\u6CD5
 DatabaseDetailView.Tab.Preview.status={0}\u7684\u5185\u5BB9\u9884\u89C8\u3002
 DatabaseDetailView.Tab.ConnectionInfo.CommitOnClose=\u5173\u95ED\u65F6\u63D0\u4EA4
@@ -413,7 +411,6 @@ DictionaryLoader.teseedOk=\u6D4B\u8BD5\u786E\u5B9A
 ConnectionInfoTab.property29=\u6700\u5927\u5217\u540D\u957F\u5EA6
 ConnectionInfoTab.property28=\u6700\u5927\u5B57\u7B26\u6587\u5B57\u957F\u5EA6
 ConnectionInfoTab.property27=\u6700\u5927\u4E8C\u8FDB\u5236\u6587\u5B57\u957F\u5EA6
-GUIModificationQueryAction.TextDialog.TitleText=\u6587\u672C\u4FEE\u6539\u67E5\u8BE2
 ConnectionInfoTab.property26=\u652F\u6301\u6253\u5F00\u8BED\u53E5\u56DE\u6EDA
 ConnectionInfoTab.property25=\u652F\u6301\u6253\u5F00\u8BED\u53E5\u63D0\u4EA4
 ConnectionInfoTab.property24=\u652F\u6301\u6253\u5F00\u9F20\u6807\u56DE\u6EDA

main/plugins/org.talend.designer.components.libs/libs_src/google-storage-utils/src/main/java/org/talend/gs/util/GSObjectUtil.java

@@ -3,6 +3,7 @@ package org.talend.gs.util;
 import java.io.File;
 import java.io.IOException;
 import java.io.InputStream;
+import java.nio.file.FileSystems;
 import java.security.NoSuchAlgorithmException;
 import java.util.ArrayList;
 import java.util.Arrays;
@@ -182,7 +183,7 @@ public class GSObjectUtil {
 
     private String combineTwoNames(String coreDir, String targetDir, File file){
         String filePath = file.getAbsolutePath();
-        String relativePath =  targetDir + filePath.replace(coreDir + "/", "");
-        return relativePath;
+        String relativePath =  targetDir + filePath.replace(coreDir + FileSystems.getDefault().getSeparator(), "");
+        return relativePath.replaceAll("\\\\","/");
     }
 }

main/plugins/org.talend.designer.components.libs/libs_src/google-storage-utils/src/test/java/util/GSObjectUtilTest.java

@@ -4,6 +4,8 @@ import org.junit.jupiter.api.Test;
 import org.talend.gs.util.GSObjectUtil;
 
 import java.io.File;
+import java.nio.file.Path;
+import java.nio.file.Paths;
 import java.util.Map;
 
 import static org.junit.jupiter.api.Assertions.*;
@@ -12,26 +14,26 @@ class GSObjectUtilTest {
 
     @Test
     void checkSizeOfFilesInFolderTest() {
-        String pathToDirectory = "src/test/resources/dirWithThreeFiles";
-        String pathToFile1 = "src/test/resources/dirWithThreeFiles/1.csv";
-        String pathToFile2 = "src/test/resources/dirWithThreeFiles/2.csv";
-        String pathToFile3 = "src/test/resources/dirWithThreeFiles/3.csv";
-        String pathToFile4 = "src/test/resources/dirWithThreeFiles/inner/1.csv";
+        Path pathToDirectory = Paths.get("src", "test", "resources", "dirWithThreeFiles");
+        Path pathToFile1 = Paths.get("src", "test", "resources", "dirWithThreeFiles", "1.csv");
+        Path pathToFile2 = Paths.get("src", "test", "resources", "dirWithThreeFiles", "2.csv");
+        Path pathToFile3 = Paths.get("src", "test", "resources", "dirWithThreeFiles", "3.csv");
+        Path pathToFile4 = Paths.get("src", "test", "resources", "dirWithThreeFiles", "inner", "1.csv");
 
         String expectedRelativePathToFile1 = "/1.csv";
         String expectedRelativePathToFile2 = "/2.csv";
         String expectedRelativePathToFile3 = "/3.csv";
         String expectedRelativePathToFile4 = "/inner/1.csv";
 
-        File rootFile = new File(pathToDirectory);
+        File rootFile = new File(pathToDirectory.toUri());
         GSObjectUtil gsObjectUtil = new GSObjectUtil();
         Map<String, File> files = gsObjectUtil.generateFileMap(rootFile, "/");
         assertEquals(4, files.size());
 
-        File expectedFile1 = new File(pathToFile1);
-        File expectedFile2 = new File(pathToFile2);
-        File expectedFile3 = new File(pathToFile3);
-        File expectedFile4 = new File(pathToFile4);
+        File expectedFile1 = new File(pathToFile1.toUri());
+        File expectedFile2 = new File(pathToFile2.toUri());
+        File expectedFile3 = new File(pathToFile3.toUri());
+        File expectedFile4 = new File(pathToFile4.toUri());
 
         assertTrue(files.containsKey(expectedRelativePathToFile1));
         assertTrue(files.containsKey(expectedRelativePathToFile2));
@@ -46,26 +48,26 @@ class GSObjectUtilTest {
 
     @Test
     void checkSizeOfFilesInFolder2Test() {
-        String pathToDirectory = "src/test/resources/dirWithThreeFiles";
-        String pathToFile1 = "src/test/resources/dirWithThreeFiles/1.csv";
-        String pathToFile2 = "src/test/resources/dirWithThreeFiles/2.csv";
-        String pathToFile3 = "src/test/resources/dirWithThreeFiles/3.csv";
-        String pathToFile4 = "src/test/resources/dirWithThreeFiles/inner/1.csv";
+        Path pathToDirectory = Paths.get("src", "test", "resources", "dirWithThreeFiles");
+        Path pathToFile1 = Paths.get("src", "test", "resources", "dirWithThreeFiles", "1.csv");
+        Path pathToFile2 = Paths.get("src", "test", "resources", "dirWithThreeFiles", "2.csv");
+        Path pathToFile3 = Paths.get("src", "test", "resources", "dirWithThreeFiles", "3.csv");
+        Path pathToFile4 = Paths.get("src", "test", "resources", "dirWithThreeFiles", "inner", "1.csv");
 
         String expectedRelativePathToFile1 = "1.csv";
         String expectedRelativePathToFile2 = "2.csv";
         String expectedRelativePathToFile3 = "3.csv";
         String expectedRelativePathToFile4 = "inner/1.csv";
 
-        File rootFile = new File(pathToDirectory);
+        File rootFile = new File(pathToDirectory.toUri());
         GSObjectUtil gsObjectUtil = new GSObjectUtil();
         Map<String, File> files = gsObjectUtil.generateFileMap(rootFile, "");
         assertEquals(4, files.size());
 
-        File expectedFile1 = new File(pathToFile1);
-        File expectedFile2 = new File(pathToFile2);
-        File expectedFile3 = new File(pathToFile3);
-        File expectedFile4 = new File(pathToFile4);
+        File expectedFile1 = new File(pathToFile1.toUri());
+        File expectedFile2 = new File(pathToFile2.toUri());
+        File expectedFile3 = new File(pathToFile3.toUri());
+        File expectedFile4 = new File(pathToFile4.toUri());
 
         assertTrue(files.containsKey(expectedRelativePathToFile1));
         assertTrue(files.containsKey(expectedRelativePathToFile2));
@@ -80,9 +82,9 @@ class GSObjectUtilTest {
 
     @Test
     void oneFileWithCustomPathTest(){
-        String pathToFile = "src/test/resources/empty.csv";
+        Path pathToFile = Paths.get("src","test", "resources", "empty.csv");
         String pathToFolder = "/folder/folder";
-        File expectedFile = new File(pathToFile);
+        File expectedFile = new File(pathToFile.toUri());
         GSObjectUtil gsObjectUtil = new GSObjectUtil();
 
         Map<String, File> files = gsObjectUtil.generateFileMap(expectedFile, pathToFolder);
@@ -96,9 +98,9 @@ class GSObjectUtilTest {
 
     @Test
     void oneFileWithOtherCustomPathTest(){
-        String pathToFile = "src/test/resources/empty.csv";
+        Path pathToFile = Paths.get("src","test", "resources", "empty.csv");
         String pathToFolder = "folder/folder";
-        File expectedFile = new File(pathToFile);
+        File expectedFile = new File(pathToFile.toUri());
         GSObjectUtil gsObjectUtil = new GSObjectUtil();
 
         Map<String, File> files = gsObjectUtil.generateFileMap(expectedFile, pathToFolder);
@@ -112,9 +114,9 @@ class GSObjectUtilTest {
 
     @Test
     void folderWithOtherCustomPathTest(){
-        String pathToFolder = "src/test/resources/dirWithThreeFiles/inner";
+        Path pathToFolder = Paths.get("src", "test", "resources", "dirWithThreeFiles", "inner");
         String pathToGSFolder = "folder";
-        File folder = new File(pathToFolder);
+        File folder = new File(pathToFolder.toUri());
         GSObjectUtil gsObjectUtil = new GSObjectUtil();
 
         Map<String, File> files = gsObjectUtil.generateFileMap(folder, pathToGSFolder);

main/plugins/org.talend.designer.components.libs/libs_src/json-lib-talend/pom.xml

@@ -170,7 +170,7 @@
       <dependency>
          <groupId>commons-beanutils</groupId>
          <artifactId>commons-beanutils</artifactId>
-         <version>1.8.0</version>
+         <version>1.9.4</version>
          <scope>compile</scope>
       </dependency>
       <dependency>
@@ -310,7 +310,7 @@
                   <link>http://java.sun.com/j2se/1.5.0/docs/api/</link>
                   <link>http://www.junit.org/junit/javadoc/</link>
                   <link>
-                     http://jakarta.apache.org/commons/beanutils/commons-beanutils-1.7.0/docs/api/
+                     http://jakarta.apache.org/commons/beanutils/commons-beanutils-1.9.4/docs/api/
                   </link>
                   <link>
                      http://jakarta.apache.org/commons/lang/api-2.2/

main/plugins/org.talend.designer.components.libs/libs_src/json-lib-talend/src/test/java/net/sf/json/AbstractJSONObjectStaticBuildersTestCase.java

@@ -51,7 +51,8 @@ public abstract class AbstractJSONObjectStaticBuildersTestCase extends TestCase
       jsonConfig.setIgnoreDefaultExcludes( true );
       JSONObject json = JSONObject.fromObject( getSource(), jsonConfig );
       assertJSONObject( json, getProperties() );
-      assertTrue( json.has( "class" ) );
+      //see : https://github.com/apache/commons-beanutils/compare/BEANUTILS_1_9_3...commons-beanutils-1.9.4#diff-dbeaa70d3a09169fb5a1e42e5b319037R34-R43
+      //assertTrue( json.has( "class" ) );
       assertTrue( !json.has( "pexcluded" ) );
    }
 

main/plugins/org.talend.designer.components.libs/libs_src/json-lib-talend/src/test/java/net/sf/json/TestJSONObject.java

@@ -199,7 +199,8 @@ public class TestJSONObject extends TestCase {
       jsonConfig.setIgnoreDefaultExcludes( true );
       jsonObject.element( "bean", new ObjectBean(), jsonConfig );
       JSONObject actual = jsonObject.getJSONObject( "bean" );
-      Assertions.assertTrue( actual.has( "class" ) );
+      //see : https://github.com/apache/commons-beanutils/compare/BEANUTILS_1_9_3...commons-beanutils-1.9.4#diff-dbeaa70d3a09169fb5a1e42e5b319037R34-R43
+      //Assertions.assertTrue( actual.has( "class" ) );
       Assertions.assertTrue( !actual.has( "pexcluded" ) );
    }
 
@@ -258,7 +259,8 @@ public class TestJSONObject extends TestCase {
       jsonObject.element( "list", list, jsonConfig );
       JSONObject actual = jsonObject.getJSONArray( "list" )
             .getJSONObject( 0 );
-      Assertions.assertTrue( actual.has( "class" ) );
+      //see : https://github.com/apache/commons-beanutils/compare/BEANUTILS_1_9_3...commons-beanutils-1.9.4#diff-dbeaa70d3a09169fb5a1e42e5b319037R34-R43
+      //Assertions.assertTrue( actual.has( "class" ) );
       Assertions.assertTrue( !actual.has( "pexcluded" ) );
    }
 

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

@@ -18,7 +18,7 @@
 		<pathelement location="${component.plugin.home}/tMicrosoftCrmInput/commons-logging-1.1.1.jar" />
 		<pathelement location="${component.plugin.home}/tWriteJSONFieldIn/commons-lang-2.6.jar" />
 		<pathelement location="${component.plugin.home}/tWebService/commons-collections-3.2.1.jar" />
-		<pathelement location="${component.plugin.home}/tWebService/commons-beanutils-1.7.0.jar" />
+		<pathelement location="${component.plugin.home}/tWebService/commons-beanutils-1.9.4.jar" />
 		<pathelement location="${component.plugin.home}/tWebService/cxf-2.6.0-modified.jar" />
 		<pathelement location="${component.plugin.home}/tWebService/jaxb-xjc-2.2.5-modified.jar" />
 		<pathelement location="${component.plugin.home}/tWebService/jaxb-impl-2.2.5-modified.jar" />

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

@@ -85,7 +85,7 @@
 		<dependency>
 			<groupId>commons-beanutils</groupId>
 			<artifactId>commons-beanutils</artifactId>
-			<version>1.8.3</version>
+			<version>1.9.4</version>
 		</dependency>
 		<dependency>
 			<groupId>org.apache.cxf</groupId>

main/plugins/org.talend.designer.components.localprovider/components/tAS400Output/tAS400Output_begin.javajet

@@ -132,7 +132,7 @@ int tmp_batchUpdateCount_<%=cid%> = 0;
 int deletedCount_<%=cid%>=0;
 int updatedCount_<%=cid%>=0;
 int insertedCount_<%=cid%>=0;
-
+int rowsToCommitCount_<%=cid%>=0;
 String tableName_<%=cid%> = <%=table%>;
 boolean whetherReject_<%=cid%> = false;
 

main/plugins/org.talend.designer.components.localprovider/components/tAS400Output/tAS400Output_end.javajet

@@ -102,10 +102,12 @@ imports="
         if(("true").equals(useCommitControl)) {
             if(!("").equals(commitEvery) && !("0").equals(commitEvery)) {
                 %>
-                if(commitCounter_<%=cid%> > 0) {
-                	<%dbLog.commit().commitTry(null, dbLog.var("commitCounter"));%>
+                if(commitCounter_<%=cid%> > 0 && rowsToCommitCount_<%=cid%> != 0) {
+                    <%dbLog.commit().commitTry(null, dbLog.var("rowsToCommitCount"));%>
                     conn_<%=cid%>.commit();
                     <%dbLog.commit().commitDone(null);%>
+                    rowsToCommitCount_<%=cid%> = 0;
+                    commitCounter_<%=cid%> = 0;
                 }
                 <%
             }

main/plugins/org.talend.designer.components.localprovider/components/tAS400Output/tAS400Output_main.javajet

@@ -310,7 +310,9 @@ skeleton="../templates/db_output_bulk.skeleton"
             try {
                 nb_line_<%=cid%>++;
                 <%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-                insertedCount_<%=cid%> = insertedCount_<%=cid%> + pstmt_<%=cid %>.executeUpdate();
+                int processedCount_<%=cid%> = pstmt_<%=cid %>.executeUpdate();
+                insertedCount_<%=cid%> += processedCount_<%=cid%>;
+                rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
                 <%dbLog.data().inserting(dbLog.var("nb_line"));%>
             } catch(java.sql.SQLException e) {
                 whetherReject_<%=cid%> = true;
@@ -442,7 +444,9 @@ skeleton="../templates/db_output_bulk.skeleton"
              try {
                 nb_line_<%=cid%>++;
                 <%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-                updatedCount_<%=cid%> = updatedCount_<%=cid%> + pstmt_<%=cid %>.executeUpdate();
+                int processedCount_<%=cid%> = pstmt_<%=cid %>.executeUpdate();
+                updatedCount_<%=cid%> += processedCount_<%=cid%>;
+                rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
                 <%dbLog.data().updating(dbLog.var("nb_line"));%>
             } catch(java.sql.SQLException e) {
                 whetherReject_<%=cid%> = true;
@@ -589,7 +593,9 @@ skeleton="../templates/db_output_bulk.skeleton"
                 }
     			%>
         			<%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-        			updatedCount_<%=cid%> = updatedCount_<%=cid%> + pstmtUpdate_<%=cid %>.executeUpdate();
+        			int processedCount_<%=cid%> = pstmtUpdate_<%=cid %>.executeUpdate();
+        			updatedCount_<%=cid%> += processedCount_<%=cid%>;
+        			rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
         			nb_line_<%=cid%>++;
         			<%dbLog.data().updating(dbLog.var("nb_line"));%>
                 } catch(java.sql.SQLException e) {
@@ -665,7 +671,9 @@ skeleton="../templates/db_output_bulk.skeleton"
                 }
     			%>
                     <%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-                    insertedCount_<%=cid%> = insertedCount_<%=cid%> + pstmtInsert_<%=cid %>.executeUpdate();
+                    int processedCount_<%=cid%> = pstmtInsert_<%=cid %>.executeUpdate();
+                    insertedCount_<%=cid%> += processedCount_<%=cid%>;
+                    rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
                     nb_line_<%=cid%>++;
                     <%dbLog.data().inserting(dbLog.var("nb_line"));%>
                 } catch(java.sql.SQLException e) {
@@ -795,6 +803,7 @@ skeleton="../templates/db_output_bulk.skeleton"
     		%>
                 updateFlag_<%=cid%>=pstmtUpdate_<%=cid %>.executeUpdate();
                 updatedCount_<%=cid%> = updatedCount_<%=cid%>+updateFlag_<%=cid%>;
+                rowsToCommitCount_<%=cid%> += updateFlag_<%=cid%>;
 
             if(updateFlag_<%=cid%> == 0) {
 
@@ -840,7 +849,9 @@ skeleton="../templates/db_output_bulk.skeleton"
                 }
         		%>
                     <%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-                    insertedCount_<%=cid%> = insertedCount_<%=cid%> + pstmtInsert_<%=cid %>.executeUpdate();
+                    int processedCount_<%=cid%> = pstmtInsert_<%=cid %>.executeUpdate();
+                    insertedCount_<%=cid%> += processedCount_<%=cid%>;
+                    rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
                     nb_line_<%=cid%>++;
                     <%dbLog.data().inserting(dbLog.var("nb_line"));%>
     			}else{
@@ -930,7 +941,9 @@ skeleton="../templates/db_output_bulk.skeleton"
     		%>
             try {
                 <%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-                deletedCount_<%=cid%> = deletedCount_<%=cid%> + pstmt_<%=cid %>.executeUpdate();
+                int processedCount_<%=cid%> = pstmt_<%=cid %>.executeUpdate();
+                deletedCount_<%=cid%> += processedCount_<%=cid%>;
+                rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
                 nb_line_<%=cid%>++;
 				<%dbLog.data().deleting(dbLog.var("nb_line"));%>
             } catch(java.sql.SQLException e) {
@@ -1014,10 +1027,13 @@ skeleton="../templates/db_output_bulk.skeleton"
                     }
 	                <%
 	                }%>
-	                	<%dbLog.commit().commitTry(null, dbLog.var("commitCounter"));%>
-                        conn_<%=cid%>.commit();
-                        <%dbLog.commit().commitDone(null);%>
-                        commitCounter_<%=cid%>=0;
+	                if(rowsToCommitCount_<%=cid%> != 0){
+	                	<%dbLog.commit().commitTry(null, dbLog.var("rowsToCommitCount"));%>
+	                	conn_<%=cid%>.commit();
+	                	<%dbLog.commit().commitDone(null);%>
+	                	rowsToCommitCount_<%=cid%> = 0;
+	                }
+	                commitCounter_<%=cid%>=0;
                     }
                     <%
                 }

main/plugins/org.talend.designer.components.localprovider/components/tAccessOutput/tAccessOutput_begin.javajet

@@ -100,7 +100,7 @@ int nb_line_rejected_<%=cid%> = 0;
 int deletedCount_<%=cid%>=0;
 int updatedCount_<%=cid%>=0;
 int insertedCount_<%=cid%>=0;
-
+int rowsToCommitCount_<%=cid%>=0;
 String tableName_<%=cid%> = <%=tableName%>;
 boolean whetherReject_<%=cid%> = false;
 java.sql.Connection conn_<%=cid%> = null;

main/plugins/org.talend.designer.components.localprovider/components/tAccessOutput/tAccessOutput_end.javajet

@@ -61,9 +61,13 @@ imports="
 	{
         if(!("").equals(commitEvery)&&!("0").equals(commitEvery)){
         %>
-        <%dbLog.commit().commitTry(null, dbLog.var("commitCounter"));%>
-        conn_<%=cid%>.commit();
-        <%dbLog.commit().commitDone(null);%>
+        if(rowsToCommitCount_<%=cid%> != 0){
+            <%dbLog.commit().commitTry(null, dbLog.var("rowsToCommitCount"));%>
+            conn_<%=cid%>.commit();
+            <%dbLog.commit().commitDone(null);%>
+            rowsToCommitCount_<%=cid%> = 0;
+        }
+        commitCounter_<%=cid%> = 0;
         <%
     	}
     	%>

main/plugins/org.talend.designer.components.localprovider/components/tAccessOutput/tAccessOutput_main.javajet

@@ -140,7 +140,9 @@ skeleton="../templates/db_output_bulk.skeleton"
     		%>
             try {
             	<%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-            	insertedCount_<%=cid%> = insertedCount_<%=cid%> + pstmt_<%=cid %>.executeUpdate();
+            	int processedCount_<%=cid%> = pstmt_<%=cid %>.executeUpdate();
+            	insertedCount_<%=cid%> += processedCount_<%=cid%>;
+            	rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
             	nb_line_<%=cid%>++;
             	<%dbLog.data().inserting(dbLog.var("nb_line"));%>
             } catch(java.lang.Exception e) {
@@ -230,7 +232,9 @@ skeleton="../templates/db_output_bulk.skeleton"
             %>
             try {
             	<%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-            	updatedCount_<%=cid%> = updatedCount_<%=cid%> + pstmt_<%=cid %>.executeUpdate();
+            	int processedCount_<%=cid%> = pstmt_<%=cid %>.executeUpdate();
+            	updatedCount_<%=cid%> += processedCount_<%=cid%>;
+            	rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
             	nb_line_<%=cid%>++;
             	<%dbLog.data().updating(dbLog.var("nb_line"));%>
             } catch(java.lang.Exception e) {
@@ -348,7 +352,9 @@ skeleton="../templates/db_output_bulk.skeleton"
     			%>
                 try {
     				<%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-    				updatedCount_<%=cid%> = updatedCount_<%=cid%> + pstmtUpdate_<%=cid %>.executeUpdate();
+    				int processedCount_<%=cid%> = pstmtUpdate_<%=cid %>.executeUpdate();
+    				updatedCount_<%=cid%> += processedCount_<%=cid%>;
+    				rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
     				nb_line_<%=cid%>++;
     				<%dbLog.data().updating(dbLog.var("nb_line"));%>
                 } catch(java.lang.Exception e) {
@@ -410,7 +416,9 @@ skeleton="../templates/db_output_bulk.skeleton"
     			%>
                 try{
         			<%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-        			insertedCount_<%=cid%> = insertedCount_<%=cid%> + pstmtInsert_<%=cid %>.executeUpdate();
+        			int processedCount_<%=cid%> = pstmtInsert_<%=cid %>.executeUpdate();
+        			insertedCount_<%=cid%> = processedCount_<%=cid%>;
+        			rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
         			nb_line_<%=cid%>++;
                     <%dbLog.data().inserting(dbLog.var("nb_line"));%>
                 } catch(java.lang.Exception e) {
@@ -511,7 +519,8 @@ skeleton="../templates/db_output_bulk.skeleton"
             		nb_line_<%=cid%>++;
     				<%dbLog.data().updating(dbLog.var("nb_line"));%>
                  }
-                 updatedCount_<%=cid%> = updatedCount_<%=cid%>+updateFlag_<%=cid%>;
+                 updatedCount_<%=cid%> += updateFlag_<%=cid%>;
+                 rowsToCommitCount_<%=cid%> += updateFlag_<%=cid%>;
              } catch(java.lang.Exception e) {
                  whetherReject_<%=cid%> = true;
                  <%
@@ -573,7 +582,9 @@ skeleton="../templates/db_output_bulk.skeleton"
                  %>
                  try {
         			<%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-        			insertedCount_<%=cid%> = insertedCount_<%=cid%> + pstmtInsert_<%=cid %>.executeUpdate();
+        			int processedCount_<%=cid%> = pstmtInsert_<%=cid %>.executeUpdate();
+        			insertedCount_<%=cid%> += processedCount_<%=cid%>;
+        			rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
         			nb_line_<%=cid%>++;
                 	<%dbLog.data().inserting(dbLog.var("nb_line"));%>
                  } catch(java.lang.Exception e) {
@@ -585,7 +596,7 @@ skeleton="../templates/db_output_bulk.skeleton"
                          <%
                      } else {
                      %>
-                    	nb_line_<%=cid%>++; 					
+                    	nb_line_<%=cid%>++;
                      	<%
                          if(rejectConnName != null && rejectColumnList != null && rejectColumnList.size() > 0) {
                              %>
@@ -652,7 +663,8 @@ skeleton="../templates/db_output_bulk.skeleton"
     		%>
             try {
                 <%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-                deletedCount_<%=cid%> = deletedCount_<%=cid%> + pstmt_<%=cid %>.executeUpdate();
+                int processedCount_<%=cid%> = pstmt_<%=cid %>.executeUpdate();
+                deletedCount_<%=cid%> += processedCount_<%=cid%>;
                 nb_line_<%=cid%>++;
                 <%dbLog.data().deleting(dbLog.var("nb_line"));%>
             } catch(java.lang.Exception e) {
@@ -697,7 +709,7 @@ skeleton="../templates/db_output_bulk.skeleton"
             <%
                 for(IConnection outgoingConn : outgoingConns) {
                     if(rejectConnName == null || (rejectConnName != null && !outgoingConn.getName().equals(rejectConnName))) {
-                        if(outgoingConn.getLineStyle().hasConnectionCategory(IConnectionCategory.DATA)) {                            
+                        if(outgoingConn.getLineStyle().hasConnectionCategory(IConnectionCategory.DATA)){                            
                             %>
                             <%=outgoingConn.getName()%> = new <%=outgoingConn.getName()%>Struct();
                             <%
@@ -720,12 +732,15 @@ skeleton="../templates/db_output_bulk.skeleton"
 	    	    %>
 	            commitCounter_<%=cid%>++;
 	            
-	            if(commitEvery_<%=cid%><=commitCounter_<%=cid%>) {
-	            	<%dbLog.commit().commitTry(null, dbLog.var("commitCounter"));%>
-	            	conn_<%=cid%>.commit();
-	            	<%dbLog.commit().commitDone(null);%>    
-	            	commitCounter_<%=cid%>=0;	
-	            }	
+	            if(commitEvery_<%=cid%> <= commitCounter_<%=cid%>){
+	            	if(rowsToCommitCount_<%=cid%> != 0){
+	                	<%dbLog.commit().commitTry(null, dbLog.var("rowsToCommitCount"));%>
+	                	conn_<%=cid%>.commit();
+	                	<%dbLog.commit().commitDone(null);%>
+	                	rowsToCommitCount_<%=cid%> = 0;
+	            	}
+	            	commitCounter_<%=cid%>=0;
+	            }
 	            <%
 	    	}
 		}

main/plugins/org.talend.designer.components.localprovider/components/tAmazonEMRListInstances/tAmazonEMRListInstances_messages_en.properties

@@ -19,7 +19,7 @@ REGION.ITEM.CN_NORTH_1=China (Beijing)
 REGION.ITEM.AP_SOUTHEAST_1=Asia Pacific (Singapore)
 REGION.ITEM.AP_SOUTHEAST_2=Asia Pacific (Sydney)
 REGION.ITEM.AP_NORTHEAST_1=Asia Pacific (Tokyo)
-REGION.ITEM.SA_EAST_1=South America (Sao Paulo)
+REGION.ITEM.SA_EAST_1=South America (S\u00E3o Paulo)
 CLUSTER_ID.NAME=Cluster id
 ENABLE_LOG.NAME=Enable log
 ENABLE_KEY_PAIR.NAME=Use EC2 key pair
@@ -36,3 +36,36 @@ ARN.NAME=Role ARN
 ROLE_SESSION_NAME.NAME=Role session name
 SESSION_DURATION.NAME=Session duration
 SET_STS_ENDPOINT.NAME=STS Endpoint
+ASSUME_ROLE_CONFIG.NAME=Assume Role Configuration
+EXTERNALID.NAME=External Id
+SERIALNUMBER.NAME=Serial number
+TOKENCODE.NAME=Token code
+POLICY_TABLE.NAME=IAM Policy ARNs
+POLICY_TABLE.ITEM.POLICY_ARN=Policy ARN
+POLICY.NAME=Policy
+TAGS.NAME=Tags
+TAGS.ITEM.TAG_KEY=Key
+TAGS.ITEM.TAG_VALUE=Value
+TAGS.ITEM.TAG_TRANSITIVE=Transitive
+SIGNING_REGION.NAME=Signing region
+SIGNING_REGION.ITEM.DEFAULT=DEFAULT
+SIGNING_REGION.ITEM.GovCloud=AWS GovCloud (US)
+SIGNING_REGION.ITEM.US_EAST_1=US Standard
+SIGNING_REGION.ITEM.US_WEST_1=US West (N. California)
+SIGNING_REGION.ITEM.US_WEST_2=US West (Oregon)
+SIGNING_REGION.ITEM.US_EAST_2=US East (Ohio)
+SIGNING_REGION.ITEM.SA_EAST_1=South America (S\u00E3o Paulo) 
+SIGNING_REGION.ITEM.EU_WEST_1=EU (Ireland)
+SIGNING_REGION.ITEM.EU_CENTRAL_1=EU (Frankfurt)
+SIGNING_REGION.ITEM.EU_WEST_2=EU (London)
+SIGNING_REGION.ITEM.EU_WEST_3=EU (Paris)
+SIGNING_REGION.ITEM.EU_NORTH_1=EU (Stockholm)
+SIGNING_REGION.ITEM.CN_NORTH_1=China (Beijing)
+SIGNING_REGION.ITEM.CN_NORTHWEST_1=China (Ningxia)
+SIGNING_REGION.ITEM.AP_EAST_1=Asia Pacific (Hong Kong)
+SIGNING_REGION.ITEM.AP_SOUTHEAST_1=Asia Pacific (Singapore)
+SIGNING_REGION.ITEM.AP_SOUTHEAST_2=Asia Pacific (Sydney)
+SIGNING_REGION.ITEM.AP_NORTHEAST_1=Asia Pacific (Tokyo)
+SIGNING_REGION.ITEM.AP_NORTHEAST_2=Asia Pacific (Seoul)
+SIGNING_REGION.ITEM.AP_SOUTH_1=Asia Pacific (Mumbai)
+SIGNING_REGION.ITEM.CA_CENTRAL_1=Canada (Central)

main/plugins/org.talend.designer.components.localprovider/components/tAmazonEMRListInstances/tAmazonEMRListInstances_messages_fr.properties

@@ -17,7 +17,7 @@ REGION.ITEM.CN_NORTH_1=Chine (P\u00E9kin)
 REGION.ITEM.AP_SOUTHEAST_1=Asie Pacifique (Singapour)
 REGION.ITEM.AP_SOUTHEAST_2=Asie Pacifique (Sydney)
 REGION.ITEM.AP_NORTHEAST_1=Asie Pacifique (Tokyo)
-REGION.ITEM.SA_EAST_1=South America (Sao Paulo)
+REGION.ITEM.SA_EAST_1=Am\u00E9rique du Sud (S\u00E3o Paulo)
 CLUSTER_ID.NAME=iD du cluster
 ENABLE_LOG.NAME=Activer le log
 ENABLE_KEY_PAIR.NAME=Utiliser la paire de cl\u00E9s EC2

main/plugins/org.talend.designer.components.localprovider/components/tAmazonEMRManage/app_mapping.javajet

@@ -5,7 +5,7 @@ if(!use_customize_version){
 %>String[] applications_<%=cid%> = <%
 	String application = ElementParameterParser.getValue(node, "__APPLICATION__");
 	if("ALL_APPLICATIONS".equals(application)) {
-		if("\"emr-4.6.0\",\"emr-4.9.2\",\"emr-5.11.0\",\"emr-5.15.0\"".contains(cluster_version)) {
+		if("\"emr-4.6.0\",\"emr-4.9.2\",\"emr-5.11.0\",\"emr-5.15.0\", \"emr-5.29.0\"".contains(cluster_version)) {
 		%>
 		{}
 		<%
@@ -15,7 +15,7 @@ if(!use_customize_version){
 		<%
 		}
 	} else if("CORE_HADOOP".equals(application)) {
-	    if("\"emr-5.11.0\"".equals(cluster_version) || "\"emr-5.15.0\"".equals(cluster_version)){%>
+	    if("\"emr-5.11.0\"".equals(cluster_version) || "\"emr-5.15.0\"".equals(cluster_version) || "\"emr-5.29.0\"".equals(cluster_version)){%>
 	    {"Ganglia","Hadoop","Hive","Hue","Mahout","Pig","Tez"}
 	    <%
 	    }else if("\"emr-4.6.0\"".equals(cluster_version) || "\"emr-4.9.2\"".equals(cluster_version)) {
@@ -38,7 +38,7 @@ if(!use_customize_version){
 		<%
 		}
     } else if("PRESTO".equals(application)) {
-        if("\"emr-5.11.0\"".equals(cluster_version) || "\"emr-5.15.0\"".equals(cluster_version)){%>
+        if("\"emr-5.11.0\"".equals(cluster_version) || "\"emr-5.15.0\"".equals(cluster_version) || "\"emr-5.29.0\"".equals(cluster_version)){%>
         {"Hadoop","Hive","Presto"}
     <% } else { %>
         if(true) {
@@ -47,7 +47,7 @@ if(!use_customize_version){
         <%
         }
 	} else if("SPARK".equals(application)) {
-	    if("\"emr-5.11.0\"".equals(cluster_version) || "\"emr-5.15.0\"".equals(cluster_version)){%>
+	    if("\"emr-5.11.0\"".equals(cluster_version) || "\"emr-5.15.0\"".equals(cluster_version) || "\"emr-5.29.0\"".equals(cluster_version)){%>
         {"Ganglia","Hadoop","Spark","Zeppelin"}
         <%  
         } else if("\"emr-4.6.0\"".equals(cluster_version) || "\"emr-4.9.2\"".equals(cluster_version)) {
@@ -60,7 +60,7 @@ if(!use_customize_version){
 		<%
 		}
 	} else if("HBASE".equals(application)) {
-	    if("\"emr-5.11.0\"".equals(cluster_version) || "\"emr-4.9.2\"".equals(cluster_version) || "\"emr-5.15.0\"".equals(cluster_version)){%>
+	    if("\"emr-5.11.0\"".equals(cluster_version) || "\"emr-4.9.2\"".equals(cluster_version) || "\"emr-5.15.0\"".equals(cluster_version) || "\"emr-5.29.0\"".equals(cluster_version)){%>
         {"HBase","Ganglia","Hadoop","Hive","Hue","Phoenix","ZooKeeper"}
         <%  
         } else if("\"emr-4.6.0\"".equals(cluster_version)) {

main/plugins/org.talend.designer.components.localprovider/components/tAmazonEMRManage/tAmazonEMRManage_begin.javajet

@@ -403,7 +403,7 @@
 	if(wait_for_cluster_ready) {
 	%>
 		boolean clusterIsAlive_<%=cid%> = false;
-        System.out.println("Wating for cluster to become available.");
+        System.out.println("Waiting for cluster to become available.");
         while (true) {
             com.amazonaws.services.elasticmapreduce.model.DescribeClusterResult result2_<%=cid%> = emr_<%=cid%>.describeCluster(
             	new com.amazonaws.services.elasticmapreduce.model.DescribeClusterRequest()
@@ -433,7 +433,7 @@
 		boolean waitForStep_<%=cid%> = clusterIsAlive_<%=cid%> && (steps_<%=cid %>.size() > 1);
 		
 		if(waitForStep_<%=cid%>) {
-        	System.out.println("Wating for steps to complete.");
+        	System.out.println("Waiting for steps to complete.");
         }
         
         while (waitForStep_<%=cid%>) {

main/plugins/org.talend.designer.components.localprovider/components/tAmazonEMRManage/tAmazonEMRManage_java.xml

@@ -97,7 +97,8 @@
 
 		<PARAMETER NAME="CLUSTER_VERSION" FIELD="OPENED_LIST"
 			NUM_ROW="32" SHOW_IF="(ACTION=='START') AND (USE_CUSTOMIZE_VERSION == 'false')" GROUP="CONFIGURATION">
-			<ITEMS DEFAULT="EMR5_15_0">
+			<ITEMS DEFAULT="EMR5_29_0">
+				<ITEM NAME="EMR5_29_0" VALUE="&quot;emr-5.29.0&quot;" />
 			    <ITEM NAME="EMR5_15_0" VALUE="&quot;emr-5.15.0&quot;" />
 			    <ITEM NAME="EMR5_11_0" VALUE="&quot;emr-5.11.0&quot;" />
 			    <ITEM NAME="EMR4_9_2" VALUE="&quot;emr-4.9.2&quot;" />
@@ -112,14 +113,14 @@
 		</PARAMETER>
 		
 		<PARAMETER NAME="APPLICATION" FIELD="CLOSED_LIST" NUM_ROW="32"
-			SHOW_IF="(ACTION=='START') AND (USE_CUSTOMIZE_VERSION == 'false') AND ((CLUSTER_VERSION=='EMR5_15_0') OR (CLUSTER_VERSION=='EMR5_11_0') OR (CLUSTER_VERSION=='EMR4_9_2') OR (CLUSTER_VERSION=='EMR4_6_0') OR (CLUSTER_VERSION=='EMR4_5_0'))" GROUP="CONFIGURATION">
+			SHOW_IF="(ACTION=='START') AND (USE_CUSTOMIZE_VERSION == 'false') AND ((CLUSTER_VERSION=='EMR5_29_0') OR (CLUSTER_VERSION=='EMR5_15_0') OR (CLUSTER_VERSION=='EMR5_11_0') OR (CLUSTER_VERSION=='EMR4_9_2') OR (CLUSTER_VERSION=='EMR4_6_0') OR (CLUSTER_VERSION=='EMR4_5_0'))" GROUP="CONFIGURATION">
 
 			<ITEMS DEFAULT="CORE_HADOOP">
-				<ITEM NAME="ALL_APPLICATIONS" VALUE="ALL_APPLICATIONS" NOT_SHOW_IF="(CLUSTER_VERSION=='EMR4_6_0') OR (CLUSTER_VERSION=='EMR4_9_2') OR (CLUSTER_VERSION=='EMR5_11_0') OR (CLUSTER_VERSION=='EMR5_15_0')"/>
+				<ITEM NAME="ALL_APPLICATIONS" VALUE="ALL_APPLICATIONS" NOT_SHOW_IF="(CLUSTER_VERSION=='EMR4_6_0') OR (CLUSTER_VERSION=='EMR4_9_2') OR (CLUSTER_VERSION=='EMR5_11_0') OR (CLUSTER_VERSION=='EMR5_15_0') OR (CLUSTER_VERSION=='EMR5_29_0')"/>
 				<ITEM NAME="CORE_HADOOP" VALUE="CORE_HADOOP" />
-				<ITEM NAME="HBASE" VALUE="HBASE" SHOW_IF="(CLUSTER_VERSION=='EMR5_11_0') OR (CLUSTER_VERSION=='EMR4_9_2') OR (CLUSTER_VERSION=='EMR4_6_0') OR (CLUSTER_VERSION=='EMR5_15_0')"/>
-				<ITEM NAME="PRESTO_SANDBOX" VALUE="PRESTO_SANDBOX" NOT_SHOW_IF="(CLUSTER_VERSION=='EMR5_11_0') OR (CLUSTER_VERSION=='EMR5_15_0')"/>
-				<ITEM NAME="PRESTO" VALUE="PRESTO" SHOW_IF="(CLUSTER_VERSION=='EMR5_11_0') OR (CLUSTER_VERSION=='EMR5_15_0')"/>
+				<ITEM NAME="HBASE" VALUE="HBASE" SHOW_IF="(CLUSTER_VERSION=='EMR5_29_0') OR (CLUSTER_VERSION=='EMR5_11_0') OR (CLUSTER_VERSION=='EMR4_9_2') OR (CLUSTER_VERSION=='EMR4_6_0') OR (CLUSTER_VERSION=='EMR5_15_0')"/>
+				<ITEM NAME="PRESTO_SANDBOX" VALUE="PRESTO_SANDBOX" NOT_SHOW_IF="(CLUSTER_VERSION=='EMR5_11_0') OR (CLUSTER_VERSION=='EMR5_15_0') OR (CLUSTER_VERSION=='EMR5_29_0')"/>
+				<ITEM NAME="PRESTO" VALUE="PRESTO" SHOW_IF="(CLUSTER_VERSION=='EMR5_11_0') OR (CLUSTER_VERSION=='EMR5_15_0') OR (CLUSTER_VERSION=='EMR5_29_0')"/>
 				<ITEM NAME="SPARK" VALUE="SPARK" />
 			</ITEMS>
 		</PARAMETER>
@@ -406,7 +407,7 @@
 		
 		<PARAMETER NAME="CUSTOMIZE_VERSION" FIELD="TEXT"
 			NUM_ROW="35" SHOW_IF="(ACTION=='START') AND (USE_CUSTOMIZE_VERSION =='true')" GROUP="CUSTOMIZE_APPLICATION_GROUP">
-			<DEFAULT>"emr-5.15.0"</DEFAULT>
+			<DEFAULT>"emr-5.29.0"</DEFAULT>
 		</PARAMETER>
 		
 		<PARAMETER NAME="CUSTOMIZE_APPLICATION_TABLE" FIELD="TABLE" NUM_ROW="40" NB_LINES="5" GROUP="CUSTOMIZE_APPLICATION_GROUP"

main/plugins/org.talend.designer.components.localprovider/components/tAmazonEMRManage/tAmazonEMRManage_messages.properties

@@ -29,6 +29,7 @@ REGION.ITEM.SA_EAST_1=South America (Sao Paulo)
 CLUSTER_NAME.NAME=Cluster name
 
 CLUSTER_VERSION.NAME=Cluster version
+CLUSTER_VERSION.ITEM.EMR5_29_0=EMR 5.29.0
 CLUSTER_VERSION.ITEM.EMR5_15_0=EMR 5.15.0
 CLUSTER_VERSION.ITEM.EMR5_11_0=EMR 5.11.0
 CLUSTER_VERSION.ITEM.EMR4_9_2=EMR 4.9.2

main/plugins/org.talend.designer.components.localprovider/components/tAmazonEMRManage/tAmazonEMRManage_messages_en.properties

@@ -19,7 +19,7 @@ REGION.ITEM.CN_NORTH_1=China (Beijing)
 REGION.ITEM.AP_SOUTHEAST_1=Asia Pacific (Singapore)
 REGION.ITEM.AP_SOUTHEAST_2=Asia Pacific (Sydney)
 REGION.ITEM.AP_NORTHEAST_1=Asia Pacific (Tokyo)
-REGION.ITEM.SA_EAST_1=South America (Sao Paulo)
+REGION.ITEM.SA_EAST_1=South America (S\u00E3o Paulo)
 CLUSTER_NAME.NAME=Cluster name
 CLUSTER_VERSION.NAME=Cluster version
 CLUSTER_VERSION.ITEM.AMI3_10_0=AMI 3.10.0
@@ -189,3 +189,37 @@ CUSTOMIZE_APPLICATION_TABLE.ITEM.NAME.ITEM.ZEPPELIN-SANDBOX=Zeppelin-Sandbox
 CUSTOMIZE_APPLICATION_TABLE.ITEM.NAME.ITEM.ZOOKEEPER-SANDBOX=ZooKeeper-Sandbox
 CUSTOMIZE_APPLICATION_TABLE.ITEM.NAME.ITEM.OOZIE-SANDBOX=Oozie-Sandbox
 CLUSTER_VERSION.ITEM.EMR5_15_0=EMR 5.15.0
+ASSUME_ROLE_CONFIG.NAME=Assume Role Configuration
+EXTERNALID.NAME=External Id
+SERIALNUMBER.NAME=Serial number
+TOKENCODE.NAME=Token code
+POLICY_TABLE.NAME=IAM Policy ARNs
+POLICY_TABLE.ITEM.POLICY_ARN=Policy ARN
+POLICY.NAME=Policy
+TAGS.NAME=Tags
+TAGS.ITEM.TAG_KEY=Key
+TAGS.ITEM.TAG_VALUE=Value
+TAGS.ITEM.TAG_TRANSITIVE=Transitive
+SIGNING_REGION.NAME=Signing region
+SIGNING_REGION.ITEM.DEFAULT=DEFAULT
+SIGNING_REGION.ITEM.GovCloud=AWS GovCloud (US)
+SIGNING_REGION.ITEM.US_EAST_1=US Standard
+SIGNING_REGION.ITEM.US_WEST_1=US West (N. California)
+SIGNING_REGION.ITEM.US_WEST_2=US West (Oregon)
+SIGNING_REGION.ITEM.US_EAST_2=US East (Ohio)
+SIGNING_REGION.ITEM.SA_EAST_1=South America (S\u00E3o Paulo) 
+SIGNING_REGION.ITEM.EU_WEST_1=EU (Ireland)
+SIGNING_REGION.ITEM.EU_CENTRAL_1=EU (Frankfurt)
+SIGNING_REGION.ITEM.EU_WEST_2=EU (London)
+SIGNING_REGION.ITEM.EU_WEST_3=EU (Paris)
+SIGNING_REGION.ITEM.EU_NORTH_1=EU (Stockholm)
+SIGNING_REGION.ITEM.CN_NORTH_1=China (Beijing)
+SIGNING_REGION.ITEM.CN_NORTHWEST_1=China (Ningxia)
+SIGNING_REGION.ITEM.AP_EAST_1=Asia Pacific (Hong Kong)
+SIGNING_REGION.ITEM.AP_SOUTHEAST_1=Asia Pacific (Singapore)
+SIGNING_REGION.ITEM.AP_SOUTHEAST_2=Asia Pacific (Sydney)
+SIGNING_REGION.ITEM.AP_NORTHEAST_1=Asia Pacific (Tokyo)
+SIGNING_REGION.ITEM.AP_NORTHEAST_2=Asia Pacific (Seoul)
+SIGNING_REGION.ITEM.AP_SOUTH_1=Asia Pacific (Mumbai)
+SIGNING_REGION.ITEM.CA_CENTRAL_1=Canada (Central)
+CLUSTER_VERSION.ITEM.EMR5_29_0=EMR 5.29.0

main/plugins/org.talend.designer.components.localprovider/components/tAmazonEMRManage/tAmazonEMRManage_messages_fr.properties

@@ -18,7 +18,7 @@ REGION.ITEM.CN_NORTH_1=Chine (P\u00E9kin)
 REGION.ITEM.AP_SOUTHEAST_1=Asie Pacifique (Singapour)
 REGION.ITEM.AP_SOUTHEAST_2=Asie Pacifique (Sydney)
 REGION.ITEM.AP_NORTHEAST_1=Asie Pacifique (Tokyo)
-REGION.ITEM.SA_EAST_1=South America (Sao Paulo)
+REGION.ITEM.SA_EAST_1=Am\u00E9rique du Sud (S\u00E3o Paulo)
 CLUSTER_NAME.NAME=Nom du cluster
 CLUSTER_VERSION.NAME=Version du cluster
 CLUSTER_VERSION.ITEM.AMI3_10_0=AMI 3.10.0
@@ -173,3 +173,4 @@ CUSTOMIZE_APPLICATION_TABLE.ITEM.NAME.ITEM.SQOOP-SANDBOX=Sqoop-Sandbox
 CUSTOMIZE_APPLICATION_TABLE.ITEM.NAME.ITEM.ZEPPELIN-SANDBOX=Zeppelin-Sandbox
 CUSTOMIZE_APPLICATION_TABLE.ITEM.NAME.ITEM.ZOOKEEPER-SANDBOX=ZooKeeper-Sandbox
 CUSTOMIZE_APPLICATION_TABLE.ITEM.NAME.ITEM.OOZIE-SANDBOX=Oozie-Sandbox
+CLUSTER_VERSION.ITEM.EMR5_15_0=EMR 5.15.0

main/plugins/org.talend.designer.components.localprovider/components/tAmazonEMRResize/tAmazonEMRResize_messages_en.properties

@@ -19,7 +19,7 @@ REGION.ITEM.CN_NORTH_1=China (Beijing)
 REGION.ITEM.AP_SOUTHEAST_1=Asia Pacific (Singapore)
 REGION.ITEM.AP_SOUTHEAST_2=Asia Pacific (Sydney)
 REGION.ITEM.AP_NORTHEAST_1=Asia Pacific (Tokyo)
-REGION.ITEM.SA_EAST_1=South America (Sao Paulo)
+REGION.ITEM.SA_EAST_1=South America (S\u00E3o Paulo)
 CLUSTER_ID.NAME=Cluster id
 GROUP_ID.NAME=Group id
 GROUP_NAME.NAME=Group name
@@ -75,3 +75,36 @@ ARN.NAME=Role ARN
 ROLE_SESSION_NAME.NAME=Role session name
 SESSION_DURATION.NAME=Session duration
 SET_STS_ENDPOINT.NAME=STS Endpoint
+ASSUME_ROLE_CONFIG.NAME=Assume Role Configuration
+EXTERNALID.NAME=External Id
+SERIALNUMBER.NAME=Serial number
+TOKENCODE.NAME=Token code
+POLICY_TABLE.NAME=IAM Policy ARNs
+POLICY_TABLE.ITEM.POLICY_ARN=Policy ARN
+POLICY.NAME=Policy
+TAGS.NAME=Tags
+TAGS.ITEM.TAG_KEY=Key
+TAGS.ITEM.TAG_VALUE=Value
+TAGS.ITEM.TAG_TRANSITIVE=Transitive
+SIGNING_REGION.NAME=Signing region
+SIGNING_REGION.ITEM.DEFAULT=DEFAULT
+SIGNING_REGION.ITEM.GovCloud=AWS GovCloud (US)
+SIGNING_REGION.ITEM.US_EAST_1=US Standard
+SIGNING_REGION.ITEM.US_WEST_1=US West (N. California)
+SIGNING_REGION.ITEM.US_WEST_2=US West (Oregon)
+SIGNING_REGION.ITEM.US_EAST_2=US East (Ohio)
+SIGNING_REGION.ITEM.SA_EAST_1=South America (S\u00E3o Paulo) 
+SIGNING_REGION.ITEM.EU_WEST_1=EU (Ireland)
+SIGNING_REGION.ITEM.EU_CENTRAL_1=EU (Frankfurt)
+SIGNING_REGION.ITEM.EU_WEST_2=EU (London)
+SIGNING_REGION.ITEM.EU_WEST_3=EU (Paris)
+SIGNING_REGION.ITEM.EU_NORTH_1=EU (Stockholm)
+SIGNING_REGION.ITEM.CN_NORTH_1=China (Beijing)
+SIGNING_REGION.ITEM.CN_NORTHWEST_1=China (Ningxia)
+SIGNING_REGION.ITEM.AP_EAST_1=Asia Pacific (Hong Kong)
+SIGNING_REGION.ITEM.AP_SOUTHEAST_1=Asia Pacific (Singapore)
+SIGNING_REGION.ITEM.AP_SOUTHEAST_2=Asia Pacific (Sydney)
+SIGNING_REGION.ITEM.AP_NORTHEAST_1=Asia Pacific (Tokyo)
+SIGNING_REGION.ITEM.AP_NORTHEAST_2=Asia Pacific (Seoul)
+SIGNING_REGION.ITEM.AP_SOUTH_1=Asia Pacific (Mumbai)
+SIGNING_REGION.ITEM.CA_CENTRAL_1=Canada (Central)

main/plugins/org.talend.designer.components.localprovider/components/tAmazonEMRResize/tAmazonEMRResize_messages_fr.properties

@@ -18,7 +18,7 @@ REGION.ITEM.CN_NORTH_1=Chine (P\u00E9kin)
 REGION.ITEM.AP_SOUTHEAST_1=Asie Pacifique (Singapour)
 REGION.ITEM.AP_SOUTHEAST_2=Asie Pacifique (Sydney)
 REGION.ITEM.AP_NORTHEAST_1=Asie Pacifique (Tokyo)
-REGION.ITEM.SA_EAST_1=South America (Sao Paulo)
+REGION.ITEM.SA_EAST_1=Am\u00E9rique du Sud (S\u00E3o Paulo)
 CLUSTER_ID.NAME=iD du cluster
 GROUP_ID.NAME=ID du groupe
 GROUP_NAME.NAME=Nom du groupe

main/plugins/org.talend.designer.components.localprovider/components/tAmazonMysqlOutput/tAmazonMysqlOutput_begin.javajet

@@ -163,7 +163,7 @@ int nb_line_rejected_<%=cid%> = 0;
 int deletedCount_<%=cid%>=0;
 int updatedCount_<%=cid%>=0;
 int insertedCount_<%=cid%>=0;
-
+int rowsToCommitCount_<%=cid%>=0;
 int rejectedCount_<%=cid%>=0;
 
 String tableName_<%=cid%> = <%=table%>;

main/plugins/org.talend.designer.components.localprovider/components/tAmazonMysqlOutput/tAmazonMysqlOutput_end.javajet

@@ -37,7 +37,7 @@ skeleton="../templates/db_output_bulk.skeleton"
 	String dataAction = ElementParameterParser.getValue(node,"__DATA_ACTION__");
 
 	String commitEvery = ElementParameterParser.getValue(node, "__COMMIT_EVERY__");
-	
+
 	boolean setAutoCommit = false;
 
 	boolean useExistingConnection = "true".equals(ElementParameterParser.getValue(node,"__USE_EXISTING_CONNECTION__"));
@@ -121,6 +121,7 @@ skeleton="../templates/db_output_bulk.skeleton"
 							for(int countEach_<%=cid%>: pstmt_<%=cid %>.executeBatch()) {
 								countSum_<%=cid%> += (countEach_<%=cid%> < 0 ? 0 : 1);
 							}
+							rowsToCommitCount_<%=cid%> += countSum_<%=cid%>;
 							<%dbLog.batch().executeDone(dbLog.str(dataAction));%>
 	            	    	<%if (("INSERT").equals(dataAction)) {
 	            	    	%>
@@ -141,6 +142,7 @@ skeleton="../templates/db_output_bulk.skeleton"
 					for(int countEach_<%=cid%>: e.getUpdateCounts()) {
 						countSum_<%=cid%> += (countEach_<%=cid%> < 0 ? 0 : countEach_<%=cid%>);
 					}
+					rowsToCommitCount_<%=cid%> += countSum_<%=cid%>;
 					<%if (("INSERT").equals(dataAction)) {
             	    %>
             	    insertedCount_<%=cid%> += countSum_<%=cid%>;
@@ -196,6 +198,7 @@ skeleton="../templates/db_output_bulk.skeleton"
 			for(int countEach_<%=cid%>: pstmt_<%=cid %>.executeBatch()) {
 				countSum_<%=cid%> += (countEach_<%=cid%> < 0 ? 0 : <%=("INSERT").equals(dataAction)? "1" : "countEach_" +cid%>);
 			}
+			rowsToCommitCount_<%=cid%> += countSum_<%=cid%>;
 			<%dbLog.batch().executeDone(dbLog.str(dataAction));%>
 	    	<%if (("INSERT").equals(dataAction)) {
 	    	%>
@@ -221,6 +224,7 @@ skeleton="../templates/db_output_bulk.skeleton"
 		for(int countEach_<%=cid%>: e.getUpdateCounts()) {
 			countSum_<%=cid%> += (countEach_<%=cid%> < 0 ? 0 : countEach_<%=cid%>);
 		}
+		rowsToCommitCount_<%=cid%> += countSum_<%=cid%>;
 		<%if (("INSERT").equals(dataAction)) {
     	%>
     	insertedCount_<%=cid%> += countSum_<%=cid%>;
@@ -254,10 +258,12 @@ skeleton="../templates/db_output_bulk.skeleton"
 		if(!("").equals(commitEvery) && !("0").equals(commitEvery))
 		{
     		%>
-    		if (commitCounter_<%=cid%> > 0) {
-        		<%dbLog.commit().commitTry(null, dbLog.var("commitCounter"));%>
+    		if (commitCounter_<%=cid%> > 0 && rowsToCommitCount_<%=cid%> != 0) {
+        		<%dbLog.commit().commitTry(null, dbLog.var("rowsToCommitCount"));%>
         		conn_<%=cid%>.commit();
         		<%dbLog.commit().commitDone(null);%>
+        		rowsToCommitCount_<%=cid%> = 0;
+        		commitCounter_<%=cid%> = 0;
     		}
     		<%
 		}

main/plugins/org.talend.designer.components.localprovider/components/tAmazonMysqlOutput/tAmazonMysqlOutput_main.javajet

@@ -631,7 +631,9 @@ if(columnList != null && columnList.size() > 0) {
 	                try {
 	                    nb_line_<%=cid%>++;
 	                    <%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-	                    insertedCount_<%=cid%> = insertedCount_<%=cid%> + pstmt_<%=cid %>.executeUpdate();
+	                    int processedCount_<%=cid%> = pstmt_<%=cid %>.executeUpdate();
+	                    insertedCount_<%=cid%> += processedCount_<%=cid%>;
+	                    rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
 	                    <%dbLog.data().inserting(dbLog.var("nb_line"));%>
 	                } catch(java.lang.Exception e) {
 	                    whetherReject_<%=cid%> = true;
@@ -709,7 +711,9 @@ if(columnList != null && columnList.size() > 0) {
                 try {
                     nb_line_<%=cid%>++;
                     <%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-                    insertedCount_<%=cid%> = insertedCount_<%=cid%> + pstmt_<%=cid %>.executeUpdate();
+                    int processedCount_<%=cid%> = pstmt_<%=cid %>.executeUpdate();
+                    insertedCount_<%=cid%> += processedCount_<%=cid%>;
+                    rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
                     <%dbLog.data().inserting(dbLog.var("nb_line"));%>
                 } catch(java.lang.Exception e) {
                     whetherReject_<%=cid%> = true;
@@ -844,7 +848,9 @@ if(columnList != null && columnList.size() > 0) {
             try {
                 nb_line_<%=cid%>++;
                 <%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-                updatedCount_<%=cid%> = updatedCount_<%=cid%> + pstmt_<%=cid %>.executeUpdate();
+                int processedCount_<%=cid%> = pstmt_<%=cid %>.executeUpdate();
+                updatedCount_<%=cid%> += processedCount_<%=cid%>;
+                rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
                 <%dbLog.data().updating(dbLog.var("nb_line"));%>
             } catch(java.lang.Exception e) {
                 whetherReject_<%=cid%> = true;
@@ -996,7 +1002,9 @@ if(columnList != null && columnList.size() > 0) {
     			%>
                 try {
                     <%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-                    updatedCount_<%=cid%> = updatedCount_<%=cid%> + pstmtUpdate_<%=cid %>.executeUpdate();
+                    int processedCount_<%=cid%> = pstmtUpdate_<%=cid %>.executeUpdate();
+                    updatedCount_<%=cid%> += processedCount_<%=cid%>;
+                    rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
                     nb_line_<%=cid%>++;
         			<%dbLog.data().updating(dbLog.var("nb_line"));%>
                 } catch(java.lang.Exception e) {
@@ -1072,7 +1080,9 @@ if(columnList != null && columnList.size() > 0) {
     			%>
                 try {
                     <%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-                    insertedCount_<%=cid%> = insertedCount_<%=cid%> + pstmtInsert_<%=cid %>.executeUpdate();
+                    int processedCount_<%=cid%> = pstmtInsert_<%=cid %>.executeUpdate();
+                    insertedCount_<%=cid%> += processedCount_<%=cid%>;
+                    rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
                     nb_line_<%=cid%>++;
                     <%dbLog.data().inserting(dbLog.var("nb_line"));%>
                 } catch(java.lang.Exception e) {
@@ -1204,7 +1214,7 @@ if(columnList != null && columnList.size() > 0) {
             try {
                 updateFlag_<%=cid%>=pstmtUpdate_<%=cid %>.executeUpdate();
                 updatedCount_<%=cid%> = updatedCount_<%=cid%>+updateFlag_<%=cid%>;
-
+                rowsToCommitCount_<%=cid%> += updateFlag_<%=cid%>;
             if(updateFlag_<%=cid%> == 0) {
 
             	<%
@@ -1250,7 +1260,9 @@ if(columnList != null && columnList.size() > 0) {
                 }
         		%>
              		<%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-                    insertedCount_<%=cid%> = insertedCount_<%=cid%> + pstmtInsert_<%=cid %>.executeUpdate();
+                    int processedCount_<%=cid%> = pstmtInsert_<%=cid %>.executeUpdate();
+                    insertedCount_<%=cid%> += processedCount_<%=cid%>;
+                    rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
              		nb_line_<%=cid%>++;
                     <%dbLog.data().inserting(dbLog.var("nb_line"));%>
     			}else{
@@ -1342,7 +1354,9 @@ if(columnList != null && columnList.size() > 0) {
     		%>
             try {
             	<%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-        	    deletedCount_<%=cid%> = deletedCount_<%=cid%> + pstmt_<%=cid %>.executeUpdate();
+                int processedCount_<%=cid%> = pstmt_<%=cid %>.executeUpdate();
+                deletedCount_<%=cid%> += processedCount_<%=cid%>;
+                rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
             	nb_line_<%=cid%>++;
             	<%dbLog.data().deleting(dbLog.var("nb_line"));%>
             } catch(java.lang.Exception e) {
@@ -1410,7 +1424,9 @@ if(columnList != null && columnList.size() > 0) {
             %>
             int replaceCount_<%=cid%> = 0;
             try {
-                replaceCount_<%=cid%> = pstmt_<%=cid %>.executeUpdate();
+                int processedCount_<%=cid%> = pstmt_<%=cid %>.executeUpdate();
+                replaceCount_<%=cid%> += processedCount_<%=cid%>;
+                rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
                 <%dbLog.data().replacing(null);%>
             } catch(java.lang.Exception e) {
                 whetherReject_<%=cid%> = true;
@@ -1490,7 +1506,9 @@ if(columnList != null && columnList.size() > 0) {
             int count_on_duplicate_key_<%=cid%> = 0;
             try {
                 <%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-                count_on_duplicate_key_<%=cid%> = pstmt_<%=cid %>.executeUpdate();
+                int processedCount_<%=cid%> = pstmt_<%=cid %>.executeUpdate();
+                count_on_duplicate_key_<%=cid%> += processedCount_<%=cid%>;
+                rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
                 <%dbLog.data().insertingOnDuplicateKeyUpdating(null);%>
             } catch(java.lang.Exception e) {
                 whetherReject_<%=cid%> = true;
@@ -1556,7 +1574,9 @@ if(columnList != null && columnList.size() > 0) {
                 try {
                     nb_line_<%=cid%>++;
                     <%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-                    insertedCount_<%=cid%> = insertedCount_<%=cid%> + pstmt_<%=cid %>.executeUpdate();
+                    int processedCount_<%=cid%> = pstmt_<%=cid %>.executeUpdate();
+                    insertedCount_<%=cid%> += processedCount_<%=cid%>;
+                    rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
                     <%dbLog.data().insertingOnDuplicateKeyUpdating(dbLog.var("nb_line"));%>
                 } catch(java.lang.Exception e) {
                     whetherReject_<%=cid%> = true;
@@ -1627,6 +1647,7 @@ if(columnList != null && columnList.size() > 0) {
 						for(int countEach_<%=cid%>: pstmt_<%=cid %>.executeBatch()) {
 							countSum_<%=cid%> += (countEach_<%=cid%> < 0 ? 0 : 1);
 						}
+						rowsToCommitCount_<%=cid%> += countSum_<%=cid%>;
 						<%dbLog.batch().executeDone(dbLog.str(dataAction));%>
             	    	<%if (("INSERT").equals(dataAction)) {
             	    	%>
@@ -1645,6 +1666,7 @@ if(columnList != null && columnList.size() > 0) {
 					for(int countEach_<%=cid%>: e.getUpdateCounts()) {
 						countSum_<%=cid%> += (countEach_<%=cid%> < 0 ? 0 : countEach_<%=cid%>);
 					}
+					rowsToCommitCount_<%=cid%> += countSum_<%=cid%>;
 					<%if (("INSERT").equals(dataAction)) {
             	    %>
             	    insertedCount_<%=cid%> += countSum_<%=cid%>;
@@ -1674,6 +1696,7 @@ if(columnList != null && columnList.size() > 0) {
 						for(int countEach_<%=cid%>: pstmt_<%=cid %>.executeBatch()) {
 							countSum_<%=cid%> += (countEach_<%=cid%> < 0 ? 0 : countEach_<%=cid%>);
 						}
+						rowsToCommitCount_<%=cid%> += countSum_<%=cid%>;
 						<%dbLog.batch().executeDone(dbLog.str(dataAction));%>
             	    	<%
             	    	 if (("UPDATE").equals(dataAction)) {
@@ -1697,6 +1720,7 @@ if(columnList != null && columnList.size() > 0) {
 					for(int countEach_<%=cid%>: e.getUpdateCounts()) {
 						countSum_<%=cid%> += (countEach_<%=cid%> < 0 ? 0 : countEach_<%=cid%>);
 					}
+					rowsToCommitCount_<%=cid%> += countSum_<%=cid%>;
 					<%if (("UPDATE").equals(dataAction)) {%>
             	    updatedCount_<%=cid%> += countSum_<%=cid%>;
             	    <% }else if (("DELETE").equals(dataAction)) {%>
@@ -1727,6 +1751,7 @@ if(columnList != null && columnList.size() > 0) {
 						for(int countEach_<%=cid%>: pstmt_<%=cid %>.executeBatch()) {
 							countSum_<%=cid%> += (countEach_<%=cid%> < 0 ? 0 : <%=("INSERT").equals(dataAction)? "1" : "countEach_" +cid%>);
 						}
+						rowsToCommitCount_<%=cid%> += countSum_<%=cid%>;
 						<%dbLog.batch().executeDone(dbLog.str(dataAction));%>
             	    	<%if (("INSERT").equals(dataAction)) {
             	    	%>
@@ -1753,6 +1778,7 @@ if(columnList != null && columnList.size() > 0) {
 					for(int countEach_<%=cid%>: e.getUpdateCounts()) {
 						countSum_<%=cid%> += (countEach_<%=cid%> < 0 ? 0 : countEach_<%=cid%>);
 					}
+					rowsToCommitCount_<%=cid%> += countSum_<%=cid%>;
 					<%if (("INSERT").equals(dataAction)) {
         	    	%>
         	    	insertedCount_<%=cid%> += countSum_<%=cid%>;
@@ -1775,9 +1801,12 @@ if(columnList != null && columnList.size() > 0) {
                 <%
                 }
                 %>
-                	<%dbLog.commit().commitTry(null, dbLog.var("commitCounter"));%>
-                	conn_<%=cid%>.commit();
-            		<%dbLog.commit().commitDone(null);%>
+                    if(rowsToCommitCount_<%=cid%> != 0){
+                    	<%dbLog.commit().commitTry(null, dbLog.var("rowsToCommitCount"));%>
+                    	conn_<%=cid%>.commit();
+                    	<%dbLog.commit().commitDone(null);%>
+                    	rowsToCommitCount_<%=cid%> = 0;
+                    }
                 	commitCounter_<%=cid%>=0;
                 }
                 <%

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

@@ -27,7 +27,6 @@ CONNECTION.NAME=Komponenten Liste
 SCHEMA_FLOW.NAME=Schema
 QUERYSTORE.NAME=Abfragetyp
 DB_VERSION.NAME=Datenbankversion
-DB_VERSION.ITEM.MYSQL_4=Mysql 4
 DB_VERSION.ITEM.MYSQL_5=Mysql 5
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.BigDecimal=BigDecimal
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Blob=Blob

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

@@ -34,7 +34,6 @@ SCHEMA_FLOW.NAME=\u03A3\u03C7\u03AE\u03BC\u03B1
 SCHEMA_REJECT.NAME=\u0391\u03C0\u03CC\u03C1\u03C1\u03B9\u03C8\u03B7 \u03A3\u03C7\u03AE\u03BC\u03B1\u03C4\u03BF\u03C2
 QUERYSTORE.NAME=\u03A4\u03CD\u03C0\u03BF\u03C2 \u0395\u03C1\u03C9\u03C4\u03AE\u03BC\u03B1\u03C4\u03BF\u03C2
 DB_VERSION.NAME=\u0388\u03BA\u03B4\u03BF\u03C3\u03B7 \u0392\u03B4
-DB_VERSION.ITEM.MYSQL_4=Mysql 4
 DB_VERSION.ITEM.MYSQL_5=Mysql 5
 SET_PREPAREDSTATEMENT_PARAMETERS.NAME=\u039F\u03C1\u03B9\u03C3\u03BC\u03CC\u03C2 \u03A0\u03B1\u03C1\u03B1\u03BC\u03AD\u03C4\u03C1\u03C9\u03BD PreparedStatement
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_INDEX=\u0395\u03C5\u03C1\u03B5\u03C4\u03AE\u03C1\u03B9\u03BF \u03A0\u03B1\u03C1\u03B1\u03BC\u03AD\u03C4\u03C1\u03BF\u03C5

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

@@ -37,7 +37,6 @@ SCHEMA_FLOW.NAME=Schema
 SCHEMA_REJECT.NAME=Reject Schema
 QUERYSTORE.NAME=Query Type
 DB_VERSION.NAME=DB Version
-DB_VERSION.ITEM.MYSQL_4=Mysql 4
 DB_VERSION.ITEM.MYSQL_5=Mysql 5
 USE_PREPAREDSTATEMENT.NAME=Use PreparedStatement
 SET_PREPAREDSTATEMENT_PARAMETERS.NAME=Set PreparedStatement Parameters

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

@@ -36,7 +36,6 @@ SCHEMA_FLOW.NAME=Sch\u00E9ma
 SCHEMA_REJECT.NAME=Rejet du sch\u00E9ma
 QUERYSTORE.NAME=Type de requ\u00EAte
 DB_VERSION.NAME=Version de la base de donn\u00E9es
-DB_VERSION.ITEM.MYSQL_4=MySQL 4
 DB_VERSION.ITEM.MYSQL_5=MySQL 5
 USE_PREPAREDSTATEMENT.NAME=Utiliser l'instruction pr\u00E9par\u00E9e
 SET_PREPAREDSTATEMENT_PARAMETERS.NAME=D\u00E9finir les param\u00E8tres de l'instruction pr\u00E9par\u00E9e

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

@@ -37,7 +37,6 @@ SCHEMA_FLOW.NAME=\u30B9\u30AD\u30FC\u30DE
 SCHEMA_REJECT.NAME=\u30B9\u30AD\u30FC\u30DE\u306E\u62D2\u5426
 QUERYSTORE.NAME=\u30AF\u30A8\u30EA\u30BF\u30A4\u30D7
 DB_VERSION.NAME=DB\u30D0\u30FC\u30B8\u30E7\u30F3
-DB_VERSION.ITEM.MYSQL_4=Mysql4
 DB_VERSION.ITEM.MYSQL_5=Mysql5
 USE_PREPAREDSTATEMENT.NAME=PreparedStatement\u306E\u4F7F\u7528
 SET_PREPAREDSTATEMENT_PARAMETERS.NAME=PreparedStatement\u306E\u30D1\u30E9\u30E1\u30FC\u30BF\u8A2D\u5B9A

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

@@ -3,5 +3,4 @@ DBTABLE.NAME=Tabelnaam
 PASS.NAME=Wachtwoord
 USER.NAME=Gebruikersnaam
 TABLE.NAME=Tabelnaam
-DB_VERSION.ITEM.MYSQL_4=Mysql 4
 DB_VERSION.ITEM.MYSQL_5=Mysql 5

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

@@ -24,7 +24,6 @@ CONNECTION.NAME=Lista komponent\u00F3w
 SCHEMA_FLOW.NAME=Schemat
 QUERYSTORE.NAME=Typ zapytania
 DB_VERSION.NAME=Wersja bazy danych
-DB_VERSION.ITEM.MYSQL_4=Mysql 4
 DB_VERSION.ITEM.MYSQL_5=Mysql 5
 USE_PREPAREDSTATEMENT.NAME=U\u017Cyj PreparedStatement
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Blob=Blob

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

@@ -24,7 +24,6 @@ SCHEMA_FLOW.NAME=\u0421\u0445\u0435\u043C\u0430
 SCHEMA_REJECT.NAME=\u041E\u0442\u0432\u0435\u0440\u0433\u043D\u0443\u0442\u044C \u0441\u0445\u0435\u043C\u0443
 QUERYSTORE.NAME=\u0422\u0438\u043F \u0437\u0430\u043F\u0440\u043E\u0441\u0430
 DB_VERSION.NAME=\u0412\u0435\u0440\u0441\u0438\u044F \u0411\u0414
-DB_VERSION.ITEM.MYSQL_4=Mysql 4
 DB_VERSION.ITEM.MYSQL_5=Mysql 5
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Blob=Blob
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Clob=Clob

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

@@ -8,7 +8,6 @@ STATEMENT_PARAMS.NAME=Parametre
 USER.NAME=U\u017E\u00EDvate\u013Esk\u00E9 Meno
 TABLE.NAME=N\u00E1zov Tabu\u013Eky
 SCHEMA_FLOW.NAME=Sch\u00E9ma
-DB_VERSION.ITEM.MYSQL_4=Mysql 4
 DB_VERSION.ITEM.MYSQL_5=Mysql 5
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Date=D\u00E1tum
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.String=String

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

@@ -3,7 +3,6 @@ TYPE.ITEM.MSSQL_ODBC=Micrososft SQL (Odbc driver)
 TYPE.ITEM.MYSQL=MySQL
 TYPE.ITEM.PGSQL=Postgre SQL
 SCHEMA_FLOW.NAME=Schema
-DB_VERSION.ITEM.MYSQL_4=Mysql 4
 DB_VERSION.ITEM.MYSQL_5=Mysql 5
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.String=String
 SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Null=Null

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

@@ -37,7 +37,6 @@ SCHEMA_FLOW.NAME=Schema
 SCHEMA_REJECT.NAME=\u62D2\u7EDD Schema
 QUERYSTORE.NAME=\u67E5\u8BE2\u7C7B\u578B
 DB_VERSION.NAME=\u6570\u636E\u5E93\u7248\u672C
-DB_VERSION.ITEM.MYSQL_4=Mysql 4
 DB_VERSION.ITEM.MYSQL_5=Mysql 5
 USE_PREPAREDSTATEMENT.NAME=\u4F7F\u7528 PreparedStatement
 SET_PREPAREDSTATEMENT_PARAMETERS.NAME=\u8BBE\u7F6E PreparedStatement \u53C2\u6570

main/plugins/org.talend.designer.components.localprovider/components/tAmazonOracleOutput/tAmazonOracleOutput_begin.javajet

@@ -188,6 +188,7 @@ int tmp_batchUpdateCount_<%=cid%> = 0;
 int deletedCount_<%=cid%>=0;
 int updatedCount_<%=cid%>=0;
 int insertedCount_<%=cid%>=0;
+int rowsToCommitCount_<%=cid%>=0;
 int rejectedCount_<%=cid%>=0;
 
 boolean whetherReject_<%=cid%> = false;

main/plugins/org.talend.designer.components.localprovider/components/tAmazonOracleOutput/tAmazonOracleOutput_end.javajet

@@ -209,6 +209,7 @@ imports="
 	    	    	<%
 	    	    	}%>
 	    	    	+= (tmp_batchUpdateCount_<%=cid%>!=-1?tmp_batchUpdateCount_<%=cid%>:0);
+	    	    	rowsToCommitCount_<%=cid%> += tmp_batchUpdateCount_<%=cid%> != -1 ? tmp_batchUpdateCount_<%=cid%> : 0;
                 }
             }
         <% } %>
@@ -226,10 +227,12 @@ imports="
 		if(!("").equals(commitEvery) && !("0").equals(commitEvery))
 		{
 		    %>
-		    if (commitCounter_<%=cid%> > 0 ) {
-    		    <%dbLog.commit().commitTry(null, dbLog.var("commitCounter"));%>
+		    if (commitCounter_<%=cid%> > 0 && rowsToCommitCount_<%=cid%> != 0) {
+    		    <%dbLog.commit().commitTry(null, dbLog.var("rowsToCommitCount"));%>
     		    conn_<%=cid%>.commit();
     		    <%dbLog.commit().commitDone(null);%>
+    		    rowsToCommitCount_<%=cid%> = 0;
+    		    commitCounter_<%=cid%> = 0;
 		    }
 		    <%
 		}

main/plugins/org.talend.designer.components.localprovider/components/tAmazonOracleOutput/tAmazonOracleOutput_main.javajet

@@ -454,7 +454,9 @@ IMetadataColumn talendDynCol = null;
             try {
                 nb_line_<%=cid%>++;
                 <%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-                insertedCount_<%=cid%> = insertedCount_<%=cid%> + pstmt_<%=cid %>.executeUpdate();
+                int processedCount_<%=cid%> = pstmt_<%=cid %>.executeUpdate();
+                insertedCount_<%=cid%> += processedCount_<%=cid%>;
+                rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
                 <%dbLog.data().inserting(dbLog.var("nb_line"));%>
             } catch(java.lang.Exception e) {
                 whetherReject_<%=cid%> = true;
@@ -596,7 +598,9 @@ IMetadataColumn talendDynCol = null;
              try {
                 nb_line_<%=cid%>++;
                 <%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-                updatedCount_<%=cid%> = updatedCount_<%=cid%> + pstmt_<%=cid %>.executeUpdate();
+                int processedCount_<%=cid%> = pstmt_<%=cid %>.executeUpdate();
+                updatedCount_<%=cid%> += processedCount_<%=cid%>;
+                rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
                 <%dbLog.data().updating(dbLog.var("nb_line"));%>
             } catch(java.lang.Exception e) {
                 whetherReject_<%=cid%> = true;
@@ -761,7 +765,9 @@ IMetadataColumn talendDynCol = null;
     			%>
                 try {
         			<%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-        			updatedCount_<%=cid%> = updatedCount_<%=cid%> + pstmtUpdate_<%=cid %>.executeUpdate();
+        			int processedCount_<%=cid%> = pstmtUpdate_<%=cid %>.executeUpdate();
+        			updatedCount_<%=cid%> += processedCount_<%=cid%>;
+        			rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
         			nb_line_<%=cid%>++;
         			<%dbLog.data().updating(dbLog.var("nb_line"));%>
                 } catch(java.lang.Exception e) {
@@ -842,7 +848,9 @@ IMetadataColumn talendDynCol = null;
     			%>
                 try {
                     <%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-                    insertedCount_<%=cid%> = insertedCount_<%=cid%> + pstmtInsert_<%=cid %>.executeUpdate();
+                    int processedCount_<%=cid%> = pstmtInsert_<%=cid %>.executeUpdate();
+                    insertedCount_<%=cid%> += processedCount_<%=cid%>;
+                    rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
                     nb_line_<%=cid%>++;
                     <%dbLog.data().inserting(dbLog.var("nb_line"));%>
                 } catch(java.lang.Exception e) {
@@ -980,6 +988,7 @@ IMetadataColumn talendDynCol = null;
             try {
                 updateFlag_<%=cid%> = pstmtUpdate_<%=cid %>.executeUpdate();
                 updatedCount_<%=cid%> = updatedCount_<%=cid%>+updateFlag_<%=cid%>;
+                rowsToCommitCount_<%=cid%> += updateFlag_<%=cid%>;
             if(updateFlag_<%=cid%> == 0) {
 
 				<%
@@ -1028,7 +1037,9 @@ IMetadataColumn talendDynCol = null;
                 }
         		%>
                     <%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-                    insertedCount_<%=cid%> = insertedCount_<%=cid%> + pstmtInsert_<%=cid %>.executeUpdate();
+                    int processedCount_<%=cid%> = pstmtInsert_<%=cid %>.executeUpdate();
+                    insertedCount_<%=cid%> += processedCount_<%=cid%>;
+                    rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
                     nb_line_<%=cid%>++;
                     <%dbLog.data().inserting(dbLog.var("nb_line"));%>
     			}else{
@@ -1123,7 +1134,9 @@ IMetadataColumn talendDynCol = null;
     		%>
             try {
                 <%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-                deletedCount_<%=cid%> = deletedCount_<%=cid%> + pstmt_<%=cid %>.executeUpdate();
+                int processedCount_<%=cid%> = pstmt_<%=cid %>.executeUpdate();
+                deletedCount_<%=cid%> += processedCount_<%=cid%>;
+                rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
                 nb_line_<%=cid%>++;
                 <%dbLog.data().deleting(dbLog.var("nb_line"));%>
             } catch(java.lang.Exception e) {
@@ -1222,6 +1235,7 @@ IMetadataColumn talendDynCol = null;
         	    	<%
         	    	}%>
         	    	+= (tmp_batchUpdateCount_<%=cid%>!=-1?tmp_batchUpdateCount_<%=cid%>:0);
+        	    	rowsToCommitCount_<%=cid%> += tmp_batchUpdateCount_<%=cid%> != -1 ? tmp_batchUpdateCount_<%=cid%> : 0;
         	    	batchSizeCounter_<%=cid%> = 0;
     			}
 	    		<%
@@ -1271,15 +1285,19 @@ IMetadataColumn talendDynCol = null;
 		    	    	<%
 		    	    	}%>
 		    	    	+= (tmp_batchUpdateCount_<%=cid%>!=-1?tmp_batchUpdateCount_<%=cid%>:0);
+		    	    	rowsToCommitCount_<%=cid%> += tmp_batchUpdateCount_<%=cid%> != -1 ? tmp_batchUpdateCount_<%=cid%> : 0;
 		    	    	batchSizeCounter_<%=cid%> = 0;
 		    	    	}
 	                <%
 	                }
 	                %>
-	                <%dbLog.commit().commitTry(null, dbLog.var("commitCounter"));%>
-                	conn_<%=cid%>.commit();
-    				<%dbLog.commit().commitDone(null);%>
-                	commitCounter_<%=cid%>=0;
+	                if(rowsToCommitCount_<%=cid%> != 0){
+	                	<%dbLog.commit().commitTry(null, dbLog.var("rowsToCommitCount"));%>
+	                	conn_<%=cid%>.commit();
+	                	<%dbLog.commit().commitDone(null);%>
+	                	rowsToCommitCount_<%=cid%> = 0;
+	                }
+	                commitCounter_<%=cid%>=0;
                 }
                 <%
     		}

main/plugins/org.talend.designer.components.localprovider/components/tAmazonOracleOutput/tAmazonOracleOutput_messages_fr.properties

@@ -105,3 +105,5 @@ USE_TIMESTAMP_FOR_DATE_TYPE.NAME=Utiliser la date et l'heure comme type de date
 DB_VERSION.ITEM.ORACLE_12=Oracle 12-7
 NB_LINE_REJECTED.NAME=Nombre de lignes rejet\u00E9es
 DBNAME.NAME=Base de donn\u00E9es
+USE_ALTERNATE_SCHEMA.NAME=Utiliser un sch\u00E9ma alternatif
+ALTERNATE_SCHEMA.NAME=Sch\u00E9ma

main/plugins/org.talend.designer.components.localprovider/components/tAmazonRedshiftManage/tAmazonRedshiftManage_messages_en.properties

@@ -21,7 +21,7 @@ REGION.ITEM.CN_NORTH_1=China (Beijing)
 REGION.ITEM.AP_SOUTHEAST_1=Asia Pacific (Singapore)
 REGION.ITEM.AP_SOUTHEAST_2=Asia Pacific (Sydney)
 REGION.ITEM.AP_NORTHEAST_1=Asia Pacific (Tokyo)
-REGION.ITEM.SA_EAST_1=South America (Sao Paulo)
+REGION.ITEM.SA_EAST_1=South America (S\u00E3o Paulo)
 CREATE_SNAPSHOT_WHEN_DELETE_CLUSTER.NAME=Create snapshot
 SNAPSHOT_ID.NAME=Snapshot id
 CLUSTER_ID.NAME=Cluster id
@@ -55,3 +55,36 @@ ARN.NAME=Role ARN
 ROLE_SESSION_NAME.NAME=Role session name
 SESSION_DURATION.NAME=Session duration
 SET_STS_ENDPOINT.NAME=STS Endpoint
+ASSUME_ROLE_CONFIG.NAME=Assume Role Configuration
+EXTERNALID.NAME=External Id
+SERIALNUMBER.NAME=Serial number
+TOKENCODE.NAME=Token code
+POLICY_TABLE.NAME=IAM Policy ARNs
+POLICY_TABLE.ITEM.POLICY_ARN=Policy ARN
+POLICY.NAME=Policy
+TAGS.NAME=Tags
+TAGS.ITEM.TAG_KEY=Key
+TAGS.ITEM.TAG_VALUE=Value
+TAGS.ITEM.TAG_TRANSITIVE=Transitive
+SIGNING_REGION.NAME=Signing region
+SIGNING_REGION.ITEM.DEFAULT=DEFAULT
+SIGNING_REGION.ITEM.GovCloud=AWS GovCloud (US)
+SIGNING_REGION.ITEM.US_EAST_1=US Standard
+SIGNING_REGION.ITEM.US_WEST_1=US West (N. California)
+SIGNING_REGION.ITEM.US_WEST_2=US West (Oregon)
+SIGNING_REGION.ITEM.US_EAST_2=US East (Ohio)
+SIGNING_REGION.ITEM.SA_EAST_1=South America (S\u00E3o Paulo)
+SIGNING_REGION.ITEM.EU_WEST_1=EU (Ireland)
+SIGNING_REGION.ITEM.EU_CENTRAL_1=EU (Frankfurt)
+SIGNING_REGION.ITEM.EU_WEST_2=EU (London)
+SIGNING_REGION.ITEM.EU_WEST_3=EU (Paris)
+SIGNING_REGION.ITEM.EU_NORTH_1=EU (Stockholm)
+SIGNING_REGION.ITEM.CN_NORTH_1=China (Beijing)
+SIGNING_REGION.ITEM.CN_NORTHWEST_1=China (Ningxia)
+SIGNING_REGION.ITEM.AP_EAST_1=Asia Pacific (Hong Kong)
+SIGNING_REGION.ITEM.AP_SOUTHEAST_1=Asia Pacific (Singapore)
+SIGNING_REGION.ITEM.AP_SOUTHEAST_2=Asia Pacific (Sydney)
+SIGNING_REGION.ITEM.AP_NORTHEAST_1=Asia Pacific (Tokyo)
+SIGNING_REGION.ITEM.AP_NORTHEAST_2=Asia Pacific (Seoul)
+SIGNING_REGION.ITEM.AP_SOUTH_1=Asia Pacific (Mumbai)
+SIGNING_REGION.ITEM.CA_CENTRAL_1=Canada (Central)

main/plugins/org.talend.designer.components.localprovider/components/tAmazonRedshiftManage/tAmazonRedshiftManage_messages_fr.properties

@@ -20,7 +20,7 @@ REGION.ITEM.CN_NORTH_1=Chine (P\u00E9kin)
 REGION.ITEM.AP_SOUTHEAST_1=Asie Pacifique (Singapour)
 REGION.ITEM.AP_SOUTHEAST_2=Asie Pacifique (Sydney)
 REGION.ITEM.AP_NORTHEAST_1=Asie Pacifique (Tokyo)
-REGION.ITEM.SA_EAST_1=South America (Sao Paulo)
+REGION.ITEM.SA_EAST_1=Am\u00E9rique du Sud (S\u00E3o Paulo)
 CREATE_SNAPSHOT_WHEN_DELETE_CLUSTER.NAME=Cr\u00E9er un snapshot
 SNAPSHOT_ID.NAME=ID du Snapshot
 CLUSTER_ID.NAME=iD du cluster

main/plugins/org.talend.designer.components.localprovider/components/tAzureSynapseBulkExec/tAzureSynapseBulkExec_messages_en.properties

@@ -0,0 +1,134 @@
+ACCOUNT_NAME.NAME=Account Name
+AZURE_CONNECTION.NAME=Azure Storage Connection
+AZURE_LOCATION.NAME=Azure Storage Location
+AZURE_STORAGE.ITEM.ADLS=Data Lake Storage Gen1
+AZURE_STORAGE.ITEM.ADLS_GEN2=Data Lake Storage Gen2
+AZURE_STORAGE.ITEM.BLOB=Blob Storage
+AZURE_STORAGE.NAME=Azure Storage
+CLIENT_ID.NAME=Client Id
+COMPRESS.NAME=Compressed by
+COMPRESSION_ORC.ITEM.DEFAULT=Default
+COMPRESSION_ORC.ITEM.SNAPPY=Snappy
+COMPRESSION_PARQUET.ITEM.GZIP=GZip
+COMPRESSION_PARQUET.ITEM.SNAPPY=Snappy
+COMPRESSION_RC.ITEM.DEFAULT=Default
+COMPRESSION_TEXT.ITEM.DEFAULT=Default
+COMPRESSION_TEXT.ITEM.GZIP=GZip
+CONNECTION.NAME=Component List
+CONTAINER.NAME=Container
+DATE_FORMAT.ITEM.NONE=None
+DATE_FORMAT.ITEM.PATTERN=Pattern
+DATE_FORMAT.NAME=Date format
+DBNAME.NAME=Database
+DBTABLE.NAME=Table Name
+DB_CONFIG.NAME=Database settings
+DB_SCHEMA.NAME=Schema
+DIE_ON_ERROR.NAME=Die on error
+DISTRIBUTION.ITEM.HASH=Hash
+DISTRIBUTION.ITEM.REPLICATE=Replicate
+DISTRIBUTION.ITEM.ROUND_ROBIN=Round Robin
+DISTRIBUTION.NAME=Distribution Option
+DISTRIBUTION_COLUMN_NAME.NAME=Distribution Column Name
+DRIVER.NAME=JDBC Provider
+DRIVER.ITEM.MSSQL_PROP=Microsoft
+DW_TABLE_PROPERTIES.NAME=Synapse Analytics table properties
+ENABLE_SSL.NAME=Secure transfer required
+ENDPOINT.NAME=OAuth 2.0 token endpoint
+EXT_TABLE_OPTIONS.NAME=Data import reject options
+FIELDSEPARATOR.NAME=Field separator
+FILENAME.NAME=Filepath at local
+HELP=org.talend.help.tAzureSynapseBulkExec
+HOST.NAME=Host
+IMPORT_TYPE.ITEM.DELIMITED_TEXT=Delimited Text
+IMPORT_TYPE.ITEM.HIVE_ORC=Hive ORC
+IMPORT_TYPE.ITEM.HIVE_RCFILE=Hive RCFile
+IMPORT_TYPE.ITEM.PARQUET=Parquet
+IMPORT_TYPE.NAME=File format
+INDEX_COLUMNS.NAME=Index column(s)
+LOAD_DETAILS.NAME=Load Parameters
+LONG_NAME=Load data into Azure Synapse Analytics with PolyBase
+MAPPING.NAME=Mapping
+NB_LINE_INSERTED.NAME=Number of lines inserted
+PARTITION.NAME=Partition
+PARTITION_COLUMN_NAME.NAME=Partition column name
+PARTITION_COLUMN_NAME_RANGE.ITEM.LEFT=Left
+PARTITION_COLUMN_NAME_RANGE.ITEM.RIGHT=Right
+PARTITION_COLUMN_NAME_RANGE.NAME=Range
+PARTITION_VALUES.NAME=Partition For Values
+PASS.NAME=Password
+PORT.NAME=Port
+PRINCIPAL_KEY.NAME=Authentication key
+PROPERTIES.NAME=Additional JDBC Parameters
+PROPERTY.NAME=Property Type
+QUERY.NAME=Query
+REJECT.LINK=Rejects
+REJECT.MENU=Rejects
+REJECT_SAMPLE_VALUE.NAME=Reject sample value
+REJECT_TYPE.ITEM.Percentage=Percentage
+REJECT_TYPE.ITEM.Value=Value
+REJECT_TYPE.NAME=Reject type
+REJECT_VALUE.NAME=Reject value
+ROWSEPARATOR.NAME=Row separator
+SCHEMA_FLOW.NAME=Schema
+SECRET_KEY.NAME=Access key
+SERDE_METHOD.ITEM.COLUMNAR=Columnar
+SERDE_METHOD.ITEM.LAZY=Lazy Binary
+SERDE_METHOD.NAME=Serde Method
+SQL_SYNTAX.NAME=Sql Syntax
+STRING_QUOTE.NAME=String Quote
+TABLE.NAME=Table
+TABLE_ACTION.ITEM.CLEAR=Clear table
+TABLE_ACTION.ITEM.CREATE=Create table
+TABLE_ACTION.ITEM.CREATE_IF_NOT_EXISTS=Create table if not exists
+TABLE_ACTION.ITEM.DROP_CREATE=Drop and create table
+TABLE_ACTION.ITEM.DROP_IF_EXISTS_AND_CREATE=Drop table if exists and create
+TABLE_ACTION.ITEM.NONE=None
+TABLE_ACTION.ITEM.TRUNCATE=Truncate table
+TABLE_ACTION.NAME=Action on table
+TABLE_OPTION.ITEM.CLUSTERED_COLUMNSTORE_INDEX=Clustered Columnstore Index
+TABLE_OPTION.ITEM.CLUSTERED_INDEX=Clustered Index
+TABLE_OPTION.ITEM.HEAP=Heap
+TABLE_OPTION.NAME=Table Option
+TYPE.NAME=Database Driver
+USER.NAME=Username
+USE_EXISTING_CONNECTION.NAME=Use an existing connection
+USE_STRING_DELIMITER.NAME=Enclosed by
+USE_TYPE_DEFAULT.ITEM.FALSE=False
+USE_TYPE_DEFAULT.ITEM.TRUE=True
+USE_TYPE_DEFAULT.NAME=Use type default
+ACTIVE_DIR_AUTH.NAME=Authenticate using Azure Active Directory
+LOAD_METHOD.NAME=Load method
+LOAD_METHOD.ITEM.POLYBASE=PolyBase
+LOAD_METHOD.ITEM.COPY=Copy
+AUTH_METHOD.NAME=Authentication method
+AUTH_METHOD.ITEM.SAS=Shared Access Signatures
+AUTH_METHOD.ITEM.KEY=Storage account key
+AUTH_METHOD.ITEM.AAD=Azure Active Directory
+SAS_TOKEN.NAME=SAS token
+ENDPOINT_SUFFIX.NAME=Endpoint suffix
+EXTERNAL_LOCATIONS.NAME=External paths
+EXTERNAL_LOCATIONS.ITEM.EXTERNAL_LOCATION=Path
+SPECIFY_FIELDS_MAPPING.NAME=Specify map to source data fields
+COLUMN_MAP_FIELD.ITEM.FIELD_INDEX=Source field index
+FILE_TYPE.NAME=File type
+FILE_TYPE.ITEM.CSV=CSV
+FILE_TYPE.ITEM.ORC=ORC
+FILE_TYPE.ITEM.PARQUET=PARQUET
+FIRST_ROW.NAME=First row
+FIELD_QUOTE.NAME=Field quote
+FIELD_TERMINATOR.NAME=Field terminator
+ROW_TERMINATOR.NAME=Row terminator
+COPY_CSV_DATE_FORMAT.NAME=Date format
+COPY_CSV_DATE_FORMAT.ITEM.SESSION_DATEFORMAT=Session date format
+COPY_CSV_DATE_FORMAT.ITEM.MDY=mdy
+COPY_CSV_DATE_FORMAT.ITEM.DMY=dmy
+COPY_CSV_DATE_FORMAT.ITEM.YMD=ymd
+COPY_CSV_DATE_FORMAT.ITEM.YDM=ydm
+COPY_CSV_DATE_FORMAT.ITEM.MYD=myd
+COPY_CSV_DATE_FORMAT.ITEM.DYM=dym
+ENCODING.NAME=Encoding
+ENCODING.ITEM.UTF8=UTF8
+ENCODING.ITEM.UTF16=UTF16
+IDENTITY_INSERT.NAME=Identity insert
+MAX_ERRORS.NAME=Max errors
+ERROR_FILE.NAME=Error file location

main/plugins/org.talend.designer.components.localprovider/components/tAzureSynapseBulkExec/tAzureSynapseBulkExec_messages_fr.properties

@@ -0,0 +1,4 @@
+AZURE_STORAGE.ITEM.ADLS=Data Lake Storage Gen1
+AZURE_STORAGE.ITEM.ADLS_GEN2=Data Lake Storage Gen2
+ENABLE_SSL.NAME=Transfert s\u00E9curis\u00E9 requis
+HELP=org.talend.help.tAzureSynapseBulkExec

main/plugins/org.talend.designer.components.localprovider/components/tAzureSynapseBulkExec/tAzureSynapseBulkExec_messages_ja.properties

@@ -0,0 +1,4 @@
+AZURE_STORAGE.ITEM.ADLS=Data Lake Storage Gen1
+AZURE_STORAGE.ITEM.ADLS_GEN2=Data Lake Storage Gen2
+ENABLE_SSL.NAME=\u30BB\u30AD\u30E5\u30A2\u306A\u8EE2\u9001\u304C\u5FC5\u8981
+HELP=org.talend.help.tAzureSynapseBulkExec

main/plugins/org.talend.designer.components.localprovider/components/tAzureSynapseClose/tAzureSynapseClose_messages_en.properties

@@ -0,0 +1,3 @@
+HELP=org.talend.help.tAzureSynapseClose
+LONG_NAME=Close a selected MSSql connection.
+CONNECTION.NAME=Component List

main/plugins/org.talend.designer.components.localprovider/components/tAzureSynapseClose/tAzureSynapseClose_messages_fr.properties

@@ -0,0 +1 @@
+HELP=org.talend.help.tAzureSynapseClose

main/plugins/org.talend.designer.components.localprovider/components/tAzureSynapseClose/tAzureSynapseClose_messages_ja.properties

@@ -0,0 +1 @@
+HELP=org.talend.help.tAzureSynapseClose

main/plugins/org.talend.designer.components.localprovider/components/tAzureSynapseCommit/tAzureSynapseCommit_messages_en.properties

@@ -0,0 +1,4 @@
+HELP=org.talend.help.tAzureSynapseCommit
+LONG_NAME=Commits all transactions not already commited in a selected MSSQL connection
+CLOSE.NAME=Close Connection
+CONNECTION.NAME=Component List

main/plugins/org.talend.designer.components.localprovider/components/tAzureSynapseCommit/tAzureSynapseCommit_messages_fr.properties

@@ -0,0 +1,2 @@
+HELP=org.talend.help.tAzureSynapseCommit
+LONG_NAME=Commite toutes les transactions n'ayant pas encore \u00E9t\u00E9 commit\u00E9es dans une connexion MSSQL s\u00E9lectionn\u00E9e

main/plugins/org.talend.designer.components.localprovider/components/tAzureSynapseCommit/tAzureSynapseCommit_messages_ja.properties

@@ -0,0 +1 @@
+HELP=org.talend.help.tAzureSynapseCommit

main/plugins/org.talend.designer.components.localprovider/components/tAzureSynapseConnection/tAzureSynapseConnection_messages_en.properties

@@ -0,0 +1,26 @@
+DBNAME.NAME=Database
+ENCODING.NAME=Encoding
+HELP=org.talend.help.tAzureSynapseConnection
+HOST.NAME=Host
+LONG_NAME=Creates a connection to an MSSQL database
+NB_LINE.NAME=Number of line
+NULL_CHAR.NAME=Null Char
+PASS.NAME=Password
+PORT.NAME=Port
+USER.NAME=Username
+INSTANCE.NAME=Instance
+PROPERTIES.NAME=Additional JDBC Parameters
+SCHEMA_DB.NAME=Schema
+USE_SHARED_CONNECTION.NAME=Use or register a shared DB Connection
+SHARED_CONNECTION_NAME.NAME=Shared DB Connection Name
+AUTO_COMMIT.NAME=Auto Commit
+SHARE_IDENTITY_SETTING.NAME=Share identity insert in multi table
+TYPE.NAME=Database Driver
+PROPERTY.NAME=Property Type
+SPECIFY_DATASOURCE_ALIAS.NAME=Specify a data source alias
+DATASOURCE.NAME=Data source
+DATASOURCE_ALIAS.NAME=Data source alias
+DRIVER.NAME=JDBC Provider
+DRIVER.ITEM.JTDS=Open source JTDS
+DRIVER.ITEM.MSSQL_PROP=Microsoft
+ACTIVE_DIR_AUTH.NAME=Authenticate using Azure Active Directory

main/plugins/org.talend.designer.components.localprovider/components/tAzureSynapseConnection/tAzureSynapseConnection_messages_fr.properties

@@ -0,0 +1,2 @@
+HELP=org.talend.help.tAzureSynapseConnection
+LONG_NAME=Cr\u00E9e une connexion \u00E0 une base de donn\u00E9es MSSQL

main/plugins/org.talend.designer.components.localprovider/components/tAzureSynapseConnection/tAzureSynapseConnection_messages_ja.properties

@@ -0,0 +1 @@
+HELP=org.talend.help.tAzureSynapseConnection

main/plugins/org.talend.designer.components.localprovider/components/tAzureSynapseInput/tAzureSynapseInput_messages_en.properties

@@ -0,0 +1,49 @@
+DBD-ODBC.INFO=Required for ODBC-like connection
+DBD-Oracle.INFO=Required for Oracle
+DBD-Pg.INFO=Required for PostgresSQL
+DBD-mysql.INFO=Required for MySQL
+DBNAME.NAME=Database
+DSN.NAME=Datasource
+ENCODING.NAME=Encoding
+HELP=org.talend.help.tAzureSynapseInput
+HOST.NAME=Host
+LONG_NAME=Reads an MSSQL table and extracts fields based on an SQL query
+NB_LINE.NAME=Number of line
+NULL_CHAR.NAME=Null Char
+PASS.NAME=Password
+PORT.NAME=Port
+QUERY.NAME=Query
+QUERYSTORE.NAME=Query Type
+SCHEMA.NAME=Schema
+SCHEMA_DB.NAME=Schema
+SQL_SYNTAX.NAME=Sql Syntax
+STRING_QUOTE.NAME=String Quote
+TYPE.ITEM.MSSQL_ODBC=Microsoft SQL (Odbc driver)
+TYPE.ITEM.MYSQL=MySQL
+TYPE.ITEM.ODBC=Generic ODBC
+TYPE.ITEM.ORACLE=Oracle
+TYPE.ITEM.PGSQL=PostgreSQL
+TYPE.NAME=Database Driver
+USER.NAME=Username
+DBTABLE.NAME=Table Name
+USE_EXISTING_CONNECTION.NAME=Use an existing connection
+INSTANCE.NAME=Instance
+PROPERTIES.NAME=Additional JDBC Parameters
+DB_SCHEMA.NAME=Schema
+TRIM_ALL_COLUMN.NAME=Trim all the String/Char columns
+TRIM_COLUMN.NAME=Trim column
+TRIM_COLUMN.ITEM.TRIM=Trim
+TABLE.NAME=Table Name
+USE_FETCH.NAME=Use Fetch
+FETCH_SIZE.NAME=Fetch Size
+PROPERTY.NAME=Property Type
+GUESS_SCHEMA.NAME=Guess Schema
+CONNECTION.NAME=Component List
+MAPPING.NAME=Mapping
+SPECIFY_DATASOURCE_ALIAS.NAME=Specify a data source alias
+DATASOURCE.NAME=Data source
+DATASOURCE_ALIAS.NAME=Data source alias
+DRIVER.NAME=JDBC Provider
+DRIVER.ITEM.JTDS=Open source JTDS
+DRIVER.ITEM.MSSQL_PROP=Microsoft
+ACTIVE_DIR_AUTH.NAME=Authenticate using Azure Active Directory

main/plugins/org.talend.designer.components.localprovider/components/tAzureSynapseInput/tAzureSynapseInput_messages_fr.properties

@@ -0,0 +1,2 @@
+HELP=org.talend.help.tAzureSynapseInput
+LONG_NAME=Lit une table MSSQL et extrait les champs \u00E0 partir d'une requ\u00EAte SQL

main/plugins/org.talend.designer.components.localprovider/components/tAzureSynapseInput/tAzureSynapseInput_messages_ja.properties

@@ -0,0 +1 @@
+HELP=org.talend.help.tAzureSynapseInput

main/plugins/org.talend.designer.components.localprovider/components/tAzureSynapseOutput/tAzureSynapseOutput_begin.javajet

@@ -94,6 +94,7 @@ int nb_line_rejected_<%=cid%> = 0;
 int deletedCount_<%=cid%>=0;
 int updatedCount_<%=cid%>=0;
 int insertedCount_<%=cid%>=0;
+int rowsToCommitCount_<%=cid%>=0;
 int rejectedCount_<%=cid%>=0;
 String dbschema_<%=cid%> = null;
 String tableName_<%=cid%> = null;

main/plugins/org.talend.designer.components.localprovider/components/tAzureSynapseOutput/tAzureSynapseOutput_end.javajet

@@ -77,7 +77,7 @@ skeleton="../templates/db_output_bulk.skeleton"
 
     String connection = ElementParameterParser.getValue(node,"__CONNECTION__");
     if(useExistingConnection) {
-        List<? extends INode> nodes = process.getNodesOfType("tInformixConnection");
+        List<? extends INode> nodes = process.getNodesOfType("tAzureSynapseConnection");
         for (INode ne:nodes) {
             if (connection.equals(ne.getUniqueName())) {
                 setAutoCommit = "true".equals(ElementParameterParser.getValue(ne, "__AUTO_COMMIT__"));
@@ -376,7 +376,9 @@ skeleton="../templates/db_output_bulk.skeleton"
 
 		    row2Count<%=cid%>++;
 		}
-		insertedCount_<%=cid%> = insertedCount_<%=cid%> + pstmt_<%=cid %>.executeUpdate();
+		int processedCount_<%=cid%> = pstmt_<%=cid %>.executeUpdate();
+		insertedCount_<%=cid%> += processedCount_<%=cid%>;
+		rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
 		}
    <% }else {
    %>
@@ -393,6 +395,7 @@ skeleton="../templates/db_output_bulk.skeleton"
 								}
 								countSum_<%=cid%> += countEach_<%=cid%>;
 							}
+							rowsToCommitCount_<%=cid%> += countSum_<%=cid%>;
 							<%dbLog.batch().executeDone(dbLog.str(dataAction));%>
 						}
             	    	<%if (("INSERT").equals(dataAction)) {
@@ -419,6 +422,7 @@ skeleton="../templates/db_output_bulk.skeleton"
 					for(int countEach_<%=cid%>: e.getUpdateCounts()) {
 						countSum_<%=cid%> += (countEach_<%=cid%> < 0 ? 0 : countEach_<%=cid%>);
 					}
+					rowsToCommitCount_<%=cid%> += countSum_<%=cid%>;
 					<%if (("INSERT").equals(dataAction)) {
             	    	%>
             	    		insertedCount_<%=cid%> += countSum_<%=cid%>;
@@ -475,9 +479,13 @@ if(identityInsert){
         if(!("").equals(commitEvery) && !("0").equals(commitEvery))
         {
             %>
-            <%dbLog.commit().commitTry(null, dbLog.var("commitCounter"));%>
-            conn_<%=cid%>.commit();
-			<%dbLog.commit().commitDone(null);%>
+            if(rowsToCommitCount_<%=cid%> != 0){
+            	<%dbLog.commit().commitTry(null, dbLog.var("rowsToCommitCount"));%>
+            	conn_<%=cid%>.commit();
+            	<%dbLog.commit().commitDone(null);%>
+            	rowsToCommitCount_<%=cid%> = 0;
+            	commitCounter_<%=cid%> = 0;
+            }
             <%
         }
 

main/plugins/org.talend.designer.components.localprovider/components/tAzureSynapseOutput/tAzureSynapseOutput_main.javajet

@@ -581,7 +581,9 @@ if((cid.equals("talendLogs_DB") || cid.equals("talendStats_DB") || cid.equals("t
 %>
                 nb_line_<%=cid%>++;
                 <%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-                insertedCount_<%=cid%> = insertedCount_<%=cid%> + pstmt_<%=cid %>.executeUpdate();
+                int processedCount_<%=cid%> = pstmt_<%=cid %>.executeUpdate();
+                insertedCount_<%=cid%> += processedCount_<%=cid%>;
+                rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
                 <%dbLog.data().inserting(dbLog.var("nb_line"));%>
             } catch(java.lang.Exception e) {
                 whetherReject_<%=cid%> = true;
@@ -703,7 +705,9 @@ if((cid.equals("talendLogs_DB") || cid.equals("talendStats_DB") || cid.equals("t
 				}
 		%>
 		                if(rowCount<%=cid%> == <%=batchSize%>){
-		                    insertedCount_<%=cid%> = insertedCount_<%=cid%> + pstmt_<%=cid %>.executeUpdate();
+		                    int processedCount_<%=cid%> = pstmt_<%=cid %>.executeUpdate();
+		                    insertedCount_<%=cid%> += processedCount_<%=cid%>;
+		                    rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
 		                    sInsertColValueList<%=cid%>.clear();
 		                    rowCount<%=cid%> = 0;
 		                    counter<%=cid%>=1;
@@ -828,7 +832,9 @@ if((cid.equals("talendLogs_DB") || cid.equals("talendStats_DB") || cid.equals("t
 %>
                 nb_line_<%=cid%>++;
                 <%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-                updatedCount_<%=cid%> = updatedCount_<%=cid%> + pstmt_<%=cid %>.executeUpdate();
+                int processedCount_<%=cid%> = pstmt_<%=cid %>.executeUpdate();
+                updatedCount_<%=cid%> += processedCount_<%=cid%>;
+                rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
         	    <%dbLog.data().updating(dbLog.var("nb_line"));%>
             } catch(java.lang.Exception e) {
                 whetherReject_<%=cid%> = true;
@@ -998,7 +1004,9 @@ if((cid.equals("talendLogs_DB") || cid.equals("talendStats_DB") || cid.equals("t
 				}//end issue0010403 date type
 %>
                     <%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-                    updatedCount_<%=cid%> = updatedCount_<%=cid%> + pstmtUpdate_<%=cid %>.executeUpdate();
+                    int processedCount_<%=cid%> = pstmtUpdate_<%=cid %>.executeUpdate();
+                    updatedCount_<%=cid%> += processedCount_<%=cid%>;
+                    rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
                     nb_line_<%=cid%>++;
         			<%dbLog.data().updating(dbLog.var("nb_line"));%>
                 } catch(java.lang.Exception e) {
@@ -1090,7 +1098,9 @@ if((cid.equals("talendLogs_DB") || cid.equals("talendStats_DB") || cid.equals("t
 				}//end issue0010403 date type
 %>
                     <%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-                    insertedCount_<%=cid%> = insertedCount_<%=cid%> + pstmtInsert_<%=cid %>.executeUpdate();
+                    int processedCount_<%=cid%> = pstmtInsert_<%=cid %>.executeUpdate();
+                    insertedCount_<%=cid%> += processedCount_<%=cid%>;
+                    rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
                     nb_line_<%=cid%>++;
                     <%dbLog.data().inserting(dbLog.var("nb_line"));%>
                 } catch(java.lang.Exception e) {
@@ -1237,6 +1247,7 @@ if((cid.equals("talendLogs_DB") || cid.equals("talendStats_DB") || cid.equals("t
 %>
                 updateFlag_<%=cid%>=pstmtUpdate_<%=cid %>.executeUpdate();
                 updatedCount_<%=cid%> = updatedCount_<%=cid%>+updateFlag_<%=cid%>;
+                rowsToCommitCount_<%=cid%> += updateFlag_<%=cid%>;
             if(updateFlag_<%=cid%> == 0) {
             	<%
             	if(isEnableDebug) {
@@ -1283,7 +1294,9 @@ if((cid.equals("talendLogs_DB") || cid.equals("talendStats_DB") || cid.equals("t
                 }
                 %>
 					<%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-                    insertedCount_<%=cid%> = insertedCount_<%=cid%> + pstmtInsert_<%=cid %>.executeUpdate();
+                    int processedCount_<%=cid%> = pstmtInsert_<%=cid %>.executeUpdate();
+                    insertedCount_<%=cid%> += processedCount_<%=cid%>;
+                    rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
 					nb_line_<%=cid%>++;
                     <%dbLog.data().inserting(dbLog.var("nb_line"));%>
     			}else{
@@ -1393,7 +1406,9 @@ if((cid.equals("talendLogs_DB") || cid.equals("talendStats_DB") || cid.equals("t
 				}//end issue0010403 date type
 %>
                 <%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-                deletedCount_<%=cid%> = deletedCount_<%=cid%> + pstmt_<%=cid %>.executeUpdate();
+                int processedCount_<%=cid%> = pstmt_<%=cid %>.executeUpdate();
+                deletedCount_<%=cid%> += processedCount_<%=cid%>;
+                rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
                 nb_line_<%=cid%>++;
                 <%dbLog.data().deleting(dbLog.var("nb_line"));%>
             } catch(java.lang.Exception e) {
@@ -1512,7 +1527,9 @@ if((cid.equals("talendLogs_DB") || cid.equals("talendStats_DB") || cid.equals("t
 				}//end issue0010403 date type
 %>
                 <%if(isEnableDebug){dbLog.data().sqlDebugPrint("globalMap.get(\""+cid+"_QUERY\")");}%>
-                insertedCount_<%=cid%> = insertedCount_<%=cid%> + pstmtInsert_<%=cid %>.executeUpdate();
+                int processedCount_<%=cid%> = pstmtInsert_<%=cid %>.executeUpdate();
+                insertedCount_<%=cid%> += processedCount_<%=cid%>;
+                rowsToCommitCount_<%=cid%> += processedCount_<%=cid%>;
                 nb_line_<%=cid%>++;
                 <%dbLog.data().inserting(dbLog.var("nb_line"));%>
             } catch(java.lang.Exception e) {
@@ -1686,14 +1703,17 @@ if((cid.equals("talendLogs_DB") || cid.equals("talendStats_DB") || cid.equals("t
     		            <%if (("INSERT").equals(dataAction)) {
             	    	%>
             	    		insertedCount_<%=cid%> = new LimitBytesHelper_<%=cid%>().limitBytePart1(insertedCount_<%=cid%>,pstmt_<%=cid %>);
+            	    		rowsToCommitCount_<%=cid%> = insertedCount_<%=cid%>;
             	    	<%
             	    	}else if (("UPDATE").equals(dataAction)) {
             	    	%>
             	    		updatedCount_<%=cid%> = new LimitBytesHelper_<%=cid%>().limitBytePart1(updatedCount_<%=cid%>,pstmt_<%=cid %>);
+            	    		rowsToCommitCount_<%=cid%> = updatedCount_<%=cid%>;
             	    	<%
             	    	}else if (("DELETE").equals(dataAction)) {
             	    	%>
             	    	    deletedCount_<%=cid%> = new LimitBytesHelper_<%=cid%>().limitBytePart1(deletedCount_<%=cid%>,pstmt_<%=cid %>);
+            	    	    rowsToCommitCount_<%=cid%> = deletedCount_<%=cid%>;
             	    	<%
             	    	}%>
             	batchSizeCounter_<%=cid%> = 0;
@@ -1701,9 +1721,12 @@ if((cid.equals("talendLogs_DB") || cid.equals("talendStats_DB") || cid.equals("t
         <%
         }
         %>
-                	<%dbLog.commit().commitTry(null, dbLog.var("commitCounter"));%>
-                	conn_<%=cid%>.commit();
-            		<%dbLog.commit().commitDone(null);%>
+                	if(rowsToCommitCount_<%=cid%> != 0){
+                		<%dbLog.commit().commitTry(null, dbLog.var("rowsToCommitCount"));%>
+                		conn_<%=cid%>.commit();
+                		<%dbLog.commit().commitDone(null);%>
+                		rowsToCommitCount_<%=cid%> = 0;
+                	}
                 	commitCounter_<%=cid%>=0;
                 }
                 <%

main/plugins/org.talend.designer.components.localprovider/components/tAzureSynapseOutput/tAzureSynapseOutput_messages_en.properties

@@ -0,0 +1,96 @@
+ADD_COLS.ITEM.DATATYPE=Data type
+ADD_COLS.ITEM.NAME=Name
+ADD_COLS.ITEM.OPERATOR=Operator
+ADD_COLS.ITEM.OPERATOR.ITEM.EQUAL=\=
+ADD_COLS.ITEM.OPERATOR.ITEM.GREAT_EQUAL_THAN=>\=
+ADD_COLS.ITEM.OPERATOR.ITEM.GREAT_THAN=>
+ADD_COLS.ITEM.OPERATOR.ITEM.IS=IS
+ADD_COLS.ITEM.OPERATOR.ITEM.IS_NOT=IS NOT
+ADD_COLS.ITEM.OPERATOR.ITEM.LESS_EQUAL_THAN=<\=
+ADD_COLS.ITEM.OPERATOR.ITEM.LESS_THAN=<
+ADD_COLS.ITEM.OPERATOR.ITEM.NOT_EQUAL=<>
+ADD_COLS.ITEM.POS=Position
+ADD_COLS.ITEM.POS.ITEM.AFTER=After
+ADD_COLS.ITEM.POS.ITEM.BEFORE=Before
+ADD_COLS.ITEM.POS.ITEM.REPLACE=Replace
+ADD_COLS.ITEM.REFCOL=Reference column
+ADD_COLS.ITEM.SQL=SQL expression
+ADD_COLS.NAME=Additional columns
+CLEAR_TABLE.NAME=Clear data in table
+COMMIT_EVERY.NAME=Commit every
+DATA_ACTION.ITEM.DELETE=Delete
+DATA_ACTION.ITEM.INSERT=Insert
+DATA_ACTION.ITEM.SINGLE_INSERT=Single Insert Query
+DATA_ACTION.ITEM.INSERT_OR_UPDATE=Insert or update
+DATA_ACTION.ITEM.UPDATE=Update
+DATA_ACTION.ITEM.UPDATE_OR_INSERT=Update or insert
+DATA_ACTION.ITEM.INSERT_IF_NOT_EXIST=Insert if not exist
+DATA_ACTION.NAME=Action on data
+DBD-ODBC.INFO=Required for ODBC-like connection
+DBD-Oracle.INFO=Required for Oracle
+DBD-Pg.INFO=Required for PostgreSQL
+DBD-mysql.INFO=Required for MySQL
+DBNAME.NAME=Database
+DBTABLE.NAME=Table Name
+DB_SCHEMA.NAME=Schema
+DIE_ON_ERROR.NAME=Die on error
+DSN.NAME=Datasource
+ENCODING.NAME=Encoding
+FIELD_OPTIONS.ITEM.DELETE_KEY=Key in delete
+FIELD_OPTIONS.ITEM.INSERTABLE=Insertable
+FIELD_OPTIONS.ITEM.UPDATABLE=Updatable
+FIELD_OPTIONS.ITEM.UPDATE_KEY=Key in update
+FIELD_OPTIONS.NAME=Field options
+HELP=org.talend.help.tAzureSynapseOutput
+HOST.NAME=Host
+IDENTITY_INSERT.NAME=Turn on identity insert
+INSTANCE.NAME=Instance
+LONG_NAME=Inserts or updates lines into an MSSQL table
+NB_LINE.NAME=Number of line
+NULL_CHAR.NAME=Null Char
+PASS.NAME=Password
+PORT.NAME=Port
+PROPERTIES.NAME=Additional JDBC Parameters
+QUERY.NAME=Query
+REJECT.LINK=Rejects
+REJECT.MENU=Rejects
+SCHEMA_FLOW.NAME=Schema
+SCHEMA_REJECT.NAME=Reject Schema
+SQL_SYNTAX.NAME=Sql Syntax
+STRING_QUOTE.NAME=String Quote
+TABLE.NAME=Table
+TABLE_ACTION.ITEM.CLEAR=Clear table
+TABLE_ACTION.ITEM.TRUNCATE=Truncate table
+TABLE_ACTION.ITEM.CREATE=Create table
+TABLE_ACTION.ITEM.CREATE_IF_NOT_EXISTS=Create table if not exists
+TABLE_ACTION.ITEM.DROP_CREATE=Drop and create table
+TABLE_ACTION.ITEM.DROP_IF_EXISTS_AND_CREATE=Drop table if exists and create
+TABLE_ACTION.ITEM.NONE=None
+TABLE_ACTION.NAME=Action on table
+USER.NAME=Username
+USE_EXISTING_CONNECTION.NAME=Use an existing connection
+USE_FIELD_OPTIONS.NAME=Use field options
+ENABLE_DEBUG_MODE.NAME=Debug query mode
+SPECIFY_IDENTITY_FIELD.NAME=Specify identity field
+IDENTITY_FIELD.NAME=Identity field
+START_VALUE.NAME=Start value
+STEP.NAME=Step
+NB_LINE_UPDATED.NAME=NB Line Updated
+NB_LINE_INSERTED.NAME=NB Line Inserted
+NB_LINE_DELETED.NAME=NB Line Deleted
+SUPPORT_NULL_WHERE.NAME=Support null in "SQL WHERE" statement
+USE_BATCH_SIZE.NAME=Use Batch Size
+BATCH_SIZE.NAME=Batch Size
+PROPERTY.NAME=Property Type
+TYPE.NAME=Database Driver
+MAPPING.NAME=Mapping
+CONNECTION.NAME=Component List
+IGNORE_DATE_OUTOF_RANGE.NAME=Ignore Date validation
+NB_LINE_REJECTED.NAME=Number Of Rejected Lines
+SPECIFY_DATASOURCE_ALIAS.NAME=Specify a data source alias
+DATASOURCE.NAME=Data source
+DATASOURCE_ALIAS.NAME=Data source alias
+DRIVER.NAME=JDBC Provider
+DRIVER.ITEM.JTDS=Open source JTDS
+DRIVER.ITEM.MSSQL_PROP=Microsoft
+ACTIVE_DIR_AUTH.NAME=Authenticate using Azure Active Directory

main/plugins/org.talend.designer.components.localprovider/components/tAzureSynapseOutput/tAzureSynapseOutput_messages_fr.properties

@@ -0,0 +1,2 @@
+HELP=org.talend.help.tAzureSynapseOutput
+LONG_NAME=Ins\u00E8re ou met \u00E0 jour des lignes dans une table MSSQL

main/plugins/org.talend.designer.components.localprovider/components/tAzureSynapseOutput/tAzureSynapseOutput_messages_ja.properties

@@ -0,0 +1 @@
+HELP=org.talend.help.tAzureSynapseOutput

main/plugins/org.talend.designer.components.localprovider/components/tAzureSynapseRollback/tAzureSynapseRollback_messages_en.properties

@@ -0,0 +1,4 @@
+HELP=org.talend.help.tAzureSynapseRollback
+LONG_NAME=Rollbacks all transactions not already commited in a selected MSSql connection
+CLOSE.NAME=Close Connection
+CONNECTION.NAME=Component List

main/plugins/org.talend.designer.components.localprovider/components/tAzureSynapseRollback/tAzureSynapseRollback_messages_fr.properties

@@ -0,0 +1,2 @@
+HELP=org.talend.help.tAzureSynapseRollback
+LONG_NAME=Annule toutes les transactions n'ayant pas encore \u00E9t\u00E9 commit\u00E9es dans une connexion MSSQL s\u00E9lectionn\u00E9e

main/plugins/org.talend.designer.components.localprovider/components/tAzureSynapseRollback/tAzureSynapseRollback_messages_ja.properties

@@ -0,0 +1 @@
+HELP=org.talend.help.tAzureSynapseRollback

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

@@ -0,0 +1,60 @@
+COMMIT_EVERY.NAME=Commit every
+DBD-ODBC.INFO=Required
+DBNAME.NAME=Database
+DBTABLE.NAME=Table Name
+DB_SCHEMA.NAME=Schema
+DIE_ON_ERROR.NAME=Die on error
+DSN.NAME=Datasource
+ENCODING.NAME=Encoding
+HELP=org.talend.help.tAzureSynapseRow
+HOST.NAME=Host
+IDENTITY_INSERT.NAME=Turn on identity insert
+INSTANCE.NAME=Instance
+LONG_NAME=Executes an SQL query at each of Talend flow's iterations
+NB_LINE.NAME=Number of line
+PASS.NAME=Password
+PORT.NAME=Port
+PROPERTIES.NAME=Additional JDBC Parameters
+QUERY.NAME=Query
+REJECT.LINK=Rejects
+REJECT.MENU=Rejects
+SCHEMA_DB.NAME=Schema
+USER.NAME=Username
+USE_EXISTING_CONNECTION.NAME=Use an existing connection
+PROPAGATE_RECORD_SET.NAME=Propagate QUERY's recordset
+RECORD_SET_COLUMN.NAME=use column
+TABLE.NAME=Table Name
+TYPE.NAME=Database Driver
+PROPERTY.NAME=Property Type
+CONNECTION.NAME=Component List
+SCHEMA_FLOW.NAME=Schema
+SCHEMA_REJECT.NAME=Reject Schema
+QUERYSTORE.NAME=Query Type
+USE_PREPAREDSTATEMENT.NAME=Use PreparedStatement
+SET_PREPAREDSTATEMENT_PARAMETERS.NAME=Set PreparedStatement Parameters
+SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_INDEX=Parameter Index
+SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE=Parameter Type
+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=Boolean
+SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Byte=Byte
+SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Bytes=Bytes
+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
+SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Float=Float
+SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Int=Int
+SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Long=Long
+SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Object=Object
+SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Short=Short
+SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.String=String
+SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Time=Time
+SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_TYPE.ITEM.Null=Null
+SET_PREPAREDSTATEMENT_PARAMETERS.ITEM.PARAMETER_VALUE=Parameter Value
+SPECIFY_DATASOURCE_ALIAS.NAME=Specify a data source alias
+DATASOURCE.NAME=Data source
+DATASOURCE_ALIAS.NAME=Data source alias
+DRIVER.NAME=JDBC Provider
+DRIVER.ITEM.JTDS=Open source JTDS
+DRIVER.ITEM.MSSQL_PROP=Microsoft
+ACTIVE_DIR_AUTH.NAME=Authenticate using Azure Active Directory

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

@@ -0,0 +1 @@
+HELP=org.talend.help.tAzureSynapseRow

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

@@ -0,0 +1 @@
+HELP=org.talend.help.tAzureSynapseRow

main/plugins/org.talend.designer.components.localprovider/components/tBarChart/tBarChart_messages_en.properties

@@ -6,10 +6,10 @@ INCLUDE_LEGEND.NAME=Include legende
 3D_FORMAT.NAME=3Dimensions
 IMAGE_WIDTH.NAME=Image width
 IMAGE_HEIGHT.NAME=Image height
-CATEGORY_AXIS.NAME=category axis name
-VALUE_AXIS.NAME=value axis name
+CATEGORY_AXIS.NAME=Category axis name
+VALUE_AXIS.NAME=Value axis name
 FORE_GROUND_ALPHA.NAME=Foreground alpha
-PLOT_ORIENTATION.NAME=plot orientation
+PLOT_ORIENTATION.NAME=Plot orientation
 PLOT_ORIENTATION.ITEM.VERTICAL=VERTICAL
 PLOT_ORIENTATION.ITEM.HORIZONTAL=HORIZONTAL
 LONG_NAME=Build a bar chart