topic Re: How to get response from Talend Community - MICROSFT vs JDBC using dynamic schema in Talend Studio

How to get response from Talend Community - MICROSFT vs JDBC using dynamic schema

sarora1 — Sat, 16 Nov 2024 04:42:59 GMT

When I use MSSQL DB Input and Output component, tmap to map dynamic schema, job works fine.

When I use JDBC DB Input and Output component, tmap to map dynamic schema, job returns this warning and no row gets inserted.

[WARN ]: org.talend.components.jdbc.runtime.writer.JDBCOutputWriter - Incorrect syntax near ')'.

Based on the warning message, it's something to do with how JDBC builds the insert statement.

Can someone help me figure out how to fix this? How can I look at the query that JDBC Output component (tDBOutput) is building

Re: How to get response from Talend Community - MICROSFT vs JDBC using dynamic schema

sarora1 — Thu, 12 Sep 2019 14:56:03 GMT

@xdshi Help please!

Re: How to get response from Talend Community - MICROSFT vs JDBC using dynamic schema

Anonymous — Thu, 12 Sep 2019 16:03:50 GMT

hello,

please share screenshots and more details...!

thanks,

Re: How to get response from Talend Community - MICROSFT vs JDBC using dynamic schema

sarora1 — Thu, 12 Sep 2019 18:38:30 GMT

@vitspltalend I have added the screenshots.

I am using JDBC connection, JDBC input/output, source and destination table schema is exactly same, and I am using dynamic type in tmap

Re: How to get response from Talend Community - MICROSFT vs JDBC using dynamic schema

sarora1 — Thu, 12 Sep 2019 21:16:37 GMT

This log is confusing me. That warning is really a warning or an error that's causing insert to fail?

Starting job jdbc_test at 15:13 12/09/2019.

[INFO ]: transporter.jdbc_test_0_1.jdbc_test - TalendJob: 'jdbc_test' - Start.
[statistics] connecting to socket on port 3925
[statistics] connected
[DEBUG]: transporter.jdbc_test_0_1.jdbc_test - tMap_1 - Start to work.
[DEBUG]: transporter.jdbc_test_0_1.jdbc_test - tMap_1 - Parameters:LINK_STYLE = LINE | TEMPORARY_DATA_DIRECTORY =  | ROWS_BUFFER_SIZE = 2000000 | CHANGE_HASH_AND_EQUALS_FOR_BIGDECIMAL = true | 
[TRACE]: transporter.jdbc_test_0_1.jdbc_test - row1 - 1 - 1 - Jam - Lyn - Won - abc - xyz|
[DEBUG]: transporter.jdbc_test_0_1.jdbc_test - tMap_1 - Outputting the record 1 of the output table 'out1'.
[TRACE]: transporter.jdbc_test_0_1.jdbc_test - out1 - 1 - 1 - Jam - Lyn - Won - abc - xyz|
[WARN ]: org.talend.components.jdbc.runtime.writer.JDBCOutputWriter - Incorrect syntax near ')'.
[DEBUG]: transporter.jdbc_test_0_1.jdbc_test - tMap_1 - Written records count in the table 'out1': 1.
[DEBUG]: transporter.jdbc_test_0_1.jdbc_test - tMap_1 - Done.
[statistics] disconnected
[INFO ]: transporter.jdbc_test_0_1.jdbc_test - TalendJob: 'jdbc_test' - Done.

Job jdbc_test ended at 15:13 12/09/2019. [exit code=0]

Re: How to get response from Talend Community - MICROSFT vs JDBC using dynamic schema

Anonymous — Fri, 13 Sep 2019 14:16:11 GMT

hello,

1) in tDbinput-> query-> guess query and also schema as per your query put column or table name.

2)in the tMap please select same date pattern for output.

thanks,

Warm Regards,
Manish

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: How to get response from Talend Community - MICROSFT vs JDBC using dynamic schema

sarora1 — Fri, 13 Sep 2019 15:36:21 GMT

The solution you mentioned doesn't work for dynamic Mapping.