Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover the Trends Shaping AI in 2026: Register Here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tJDBCConnection with Redbrick.jar

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

 

Labels (5)
2 Replies
Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

I use  JDK 1.8.

 

Regards

Arnaud