TMysqlRow cannot read data from crossengine Tables

[Anonymous]

Hi guys,

I'm using Talend7 Java version 8

I got this error when i am trying to perform SQL query from two tables with different engine(MariaDB Column store and INNO DB

It says : (CONN=952) Internal error: CAL0002: Delete Failed:  fatal error reading result from cross engine client lib(4294967295)(null pointer)
however ,the query works normal when i am using the other administration tool

Any idea how to fix this?
Thanks

[Anonymous]

Hello,

What does your sql query look like in tMySqlRow? I haven't see this error before. Could you please give us more information to diagnose your issue?

Best regards

Sabrina

[Anonymous · Accepted solution]

something like

"

DELETE a FROM main_table a inner join temp_table b on b.PrimKey = a.PrimKey

"
well,i have found the solution,

apparently i just have to put commit at the second line,

thanks