Talend Connect
Virtual Summit
JOIN US!
And visit the Customer
& Community Lounge.
May 27-28, wherever you are.

tJDBCConnection with Redbrick.jar

Highlighted
Four Stars

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

 

Highlighted
Moderator

Re: tJDBCConnection with Redbrick.jar

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
Four Stars

Re: tJDBCConnection with Redbrick.jar

I use  JDK 1.8.

 

Regards

Arnaud

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog