Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a problem with component tJDBCConnection and an external driver.
When I run job in studio, all work fine.
But when I Build job, I obtain this error :
2019-02-19 09:47:16|nzaX3q|nzaX3q|nzaX3q|8844|SPEED|Main_DMT1|_2U7TYPr5EeSoW91VC
Y-daA|1.0|QA||begin||
Exception in component tJDBCConnection_1 (Load_DMT1_data)
java.sql.SQLException: ** ERROR ** (1802) Locale value English_UnitedStates.MS12
52 contains an invalid code set specification.
at redbrick.protocol.SfexResult.getSfexResultErrors(SfexResult.java:218)
at redbrick.jdbc.RBWConnection.examineSfexResult(RBWConnection.java:958)
at redbrick.jdbc.RBWConnection.getServerResponse(RBWConnection.java:930)
at redbrick.jdbc.RBWConnection.<init>(RBWConnection.java:209)
at redbrick.jdbc.RBWDriver.connect(RBWDriver.java:283)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at speed.load_dmt1_data_1_0.Load_DMT1_data.tJDBCConnection_1Process(Load
_DMT1_data.java:12721)
at speed.load_dmt1_data_1_0.Load_DMT1_data.tLibraryLoad_1Process(Load_DM
T1_data.java:12601)
at speed.load_dmt1_data_1_0.Load_DMT1_data.tPrejob_1Process(Load_DMT1_da
ta.java:12426)
at speed.load_dmt1_data_1_0.Load_DMT1_data.runJobInTOS(Load_DMT1_data.ja
va:17261)
at speed.load_dmt1_data_1_0.Load_DMT1_data.runJob(Load_DMT1_data.java:16
936)
at speed.main_dmt1_1_0.Main_DMT1.tRunJob_1Process(Main_DMT1.java:1748)
at speed.main_dmt1_1_0.Main_DMT1.tMysqlRow_1Process(Main_DMT1.java:1499)
at speed.main_dmt1_1_0.Main_DMT1.tMysqlInput_1Process(Main_DMT1.java:128
4)
at speed.main_dmt1_1_0.Main_DMT1.runJobInTOS(Main_DMT1.java:7062)
at speed.main_dmt1_1_0.Main_DMT1.main(Main_DMT1.java:6749)
2019-02-19 09:49:39|bHOPPg|nzaX3q|nzaX3q|SPEED|Load_DMT1_data|QA|5|tDie|tDie_1|J
ob Load DMT1 : Connexion DB KO|50
Job Load DMT1 : Connexion DB KO
My PC is a windows 7 64 bits US
Talend Studio 6.5.1, java 1.
Have you already had same problem ?
Thanks
Arnaud
Hello,
@ArnaudP wrote:
Hello,
I have a problem with component tJDBCConnection and an external driver.
When I run job in studio, all work fine.
But when I Build job, I obtain this error :
2019-02-19 09:47:16|nzaX3q|nzaX3q|nzaX3q|8844|SPEED|Main_DMT1|_2U7TYPr5EeSoW91VC
Y-daA|1.0|QA||begin||
Exception in component tJDBCConnection_1 (Load_DMT1_data)
java.sql.SQLException: ** ERROR ** (1802) Locale value English_UnitedStates.MS12
52 contains an invalid code set specification.
at redbrick.protocol.SfexResult.getSfexResultErrors(SfexResult.java:218)at redbrick.jdbc.RBWConnection.examineSfexResult(RBWConnection.java:958)
at redbrick.jdbc.RBWConnection.getServerResponse(RBWConnection.java:930)
at redbrick.jdbc.RBWConnection.<init>(RBWConnection.java:209)
at redbrick.jdbc.RBWDriver.connect(RBWDriver.java:283)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at speed.load_dmt1_data_1_0.Load_DMT1_data.tJDBCConnection_1Process(Load
_DMT1_data.java:12721)
at speed.load_dmt1_data_1_0.Load_DMT1_data.tLibraryLoad_1Process(Load_DM
T1_data.java:12601)
at speed.load_dmt1_data_1_0.Load_DMT1_data.tPrejob_1Process(Load_DMT1_da
ta.java:12426)
at speed.load_dmt1_data_1_0.Load_DMT1_data.runJobInTOS(Load_DMT1_data.ja
va:17261)
at speed.load_dmt1_data_1_0.Load_DMT1_data.runJob(Load_DMT1_data.java:16
936)
at speed.main_dmt1_1_0.Main_DMT1.tRunJob_1Process(Main_DMT1.java:1748)
at speed.main_dmt1_1_0.Main_DMT1.tMysqlRow_1Process(Main_DMT1.java:1499)at speed.main_dmt1_1_0.Main_DMT1.tMysqlInput_1Process(Main_DMT1.java:128
4)
at speed.main_dmt1_1_0.Main_DMT1.runJobInTOS(Main_DMT1.java:7062)
at speed.main_dmt1_1_0.Main_DMT1.main(Main_DMT1.java:6749)
2019-02-19 09:49:39|bHOPPg|nzaX3q|nzaX3q|SPEED|Load_DMT1_data|QA|5|tDie|tDie_1|J
ob Load DMT1 : Connexion DB KO|50
Job Load DMT1 : Connexion DB KO
My PC is a windows 7 64 bits US
Talend Studio 6.5.1, java 1.
Have you already had same problem ?
Thanks
Arnaud
What's JDK version are you using? JDK 1.8?
Best regards
Sabrina
I use JDK 1.8.
Regards
Arnaud