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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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