topic tJDBCConnection with Redbrick.jar in Talend Studio

tJDBCConnection with Redbrick.jar

Anonymous — Sat, 16 Nov 2024 06:33:39 GMT

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)

My PC is a windows 7 64 bits US

Talend Studio 6.5.1, java 1.

Have you already had same problem ?

Thanks

Arnaud

Re: tJDBCConnection with Redbrick.jar

Anonymous — Mon, 04 Mar 2019 08:42:59 GMT

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

Re: tJDBCConnection with Redbrick.jar

Anonymous — Fri, 08 Mar 2019 16:33:02 GMT

I use JDK 1.8.

Regards

Arnaud