Getting error "String literal is not properly closed by a double-quote" while tOracleOutput

[Anonymous]

I have some problem with tOracleOutput component using Talend Open Studio for Data Integration,Version: 7.1.1.

My job contains a couple of Oracle components and tSchemaComplianceCheck and looks like "input - schemacompliancecheck - output", all Oracle db.

The problem is in TOracleOutput, when i try to run this job with this component, error is displaying.

As soon as i delete this component and swap it to, example, tFileOutputPositional - no errors.

What can i do with this issue, it stops a work a lot.

A few screenshots are attached

Thanks in advance and best regards

error log

job

place in code where an error occurs

[Anonymous]

Hi @e_garbar,

Could you show us the settings in tOracleOutput component.

[Anonymous]

 hi, here they are "Вставить" is Insert in data action parameter

[Anonymous]

Hi @e_garbar,

What kind of data is coming from the source ? Are you using/any escape character (back-slash) anywhere?

[Anonymous]

here is query from talend, data is Tools with it's properties

escape characters used only in this query in regexp_like

[Anonymous · Accepted solution]

Okay, for all who follow this discussion, i've solved this issue.

I don't know the reason why this is a solution, but i've deleted last column from schema and it works.

I think that the main problem in this case is that the input and output schemas have a different number of columns.

[esafonov]

Morning, all.

This frustrating issue is not solved, and I have the same issue.
Talend Open Studio generates code with the syntax error. This example, it inserts new line at the character position 295, without appropriate quoting:

// This source code has been automatically generated by_Talend Open Studio for Data Integration
String insert_tDBOutput_1 = "INSERT INTO " + tableName_tDBOutput_1 + " (address,addresstype,parentaddresscode,name1,name2,name3,address1,address2,contact,zipcode,city,state,country,blacklist,blacklistsince,blacklisttext,deliverycond,shipmentcond,paymentcond,currency,returngoods
via,resourcetype,billcond,billtext) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";

 Currently, Java does not support multi-line strings. If you want your string to span multiple lines, you have to concatenate multiple strings:

String myString = "What the hell are you trying?" +
        " Now I know there is something more " +
        "What happened to you ";

Does anyone know how that behaviour of code-generator could be corrected ?

talend multile line string is not double quoted error.jpg