Post a reply

Write your message and submit

Options

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

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 :-/

janhess
2012-05-23 10:52:49

Have you selected 'use existing connection'?

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

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.

Board footer

Powered by FluxBB