Talend community forum / Simple Truncate Table job fail

geuder · 2012-05-23 10:27:28

I'm trying to recreate a simple TRUNCATE Table-job in Talend.

Manual queryning works fine with Turning off FK constraints, Truncate Table, Turning on FK constraints.

But when this is put together as:

MySQL Connection -> MySQLRow (Set fk =0) -> MYSQLRow (Trunctae table) -> MySQLRow (Set fk =1) -> MysqlCommit.

It gives me "Connection Link Failure"

Same if I use a MySQL Output with action on table: Truncate
-> Same error.

pedro · 2012-05-23 10:39:23

Hi

Please check the parameters of mysql connection.
I don't think this is due to "truncate".

Regards,
Pedro

janhess · 2012-05-23 10:52:49

Have you selected 'use existing connection'?

geuder · 2012-05-23 11:02:43

Thanks all,

but seems like my problem is way bigger...
Not even getting Internet access from my Talend computer :-/

Announcement

Unanswered posts

#1 2012-05-23 10:27:28

Simple Truncate Table job fail

#2 2012-05-23 10:39:23

Re: Simple Truncate Table job fail

#3 2012-05-23 10:52:49

Re: Simple Truncate Table job fail

#4 2012-05-23 11:02:43

Re: Simple Truncate Table job fail

Board footer