topic Re: Getting error "String literal is not properly closed by a double-quote" while tOracleOutput in Talend Studio

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

Anonymous — Wed, 14 Nov 2018 06:16:41 GMT

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

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

Anonymous — Wed, 14 Nov 2018 06:49:09 GMT

Hi @e_garbar,

Could you show us the settings in tOracleOutput component.

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

Anonymous — Wed, 14 Nov 2018 06:56:27 GMT

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

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

Anonymous — Wed, 14 Nov 2018 07:07:52 GMT

Hi @e_garbar,

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

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

Anonymous — Wed, 14 Nov 2018 07:20:33 GMT

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

escape characters used only in this query in regexp_like

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

Anonymous — Thu, 15 Nov 2018 11:06:01 GMT

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.

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

esafonov — Tue, 26 Mar 2019 04:18:54 GMT

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