Ask Your Question
0

jdbc producer for MySQL - enclose object names

asked 2021-05-20 11:43:01 -0500

KateF gravatar image

Hi, I'm building a pipeline to move data into MySQL, with a JDBC multitable origin and JDBC producer.

This is just a straight copy, trying to move data from the source to the destination, all fields are identically named.

Unfortunately several of the fields are reserved words in MySQL. So for instance, I am inserting into a column called "type".

With any other RDBMS you would solve this by checking the "enclose object names" field on the JDBC producer, but for MySQL, it won't recognize the " character and instead requires the ` character to enclose fields.

I tried using a field renamer to add the enclosing marks manually but that caused it to not copy any fields over - presumably because of the information_schema lookups.

Any suggestions? Is there a way to configure the quote character for the enclose object names behavior?

Thanks!

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2021-05-20 12:11:52 -0500

KateF gravatar image

OK found the answer after focusing on a MySQL-centered solution for this:

In JDBC Producer, enable "Enclose Object Names" and add the following JDBC Configuration Property:

image description

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2021-05-20 11:43:01 -0500

Seen: 126 times

Last updated: May 20