topic Re: Not able to create mysql table using talend in Talend Studio

Not able to create mysql table using talend

kuwaryogi27 — Sat, 16 Nov 2024 02:50:42 GMT

Hello All,

I am not able to create mysql table while execution of talend job, below are the steps that I have performed :
1] Created Metadata connection -> Connection is successful
2] Created a talend job in which I am reading excel file and inserting it to Mysql database [mysql table that I am creating does not exist in mysql database only database named 'database_name' exists.]
3] Sharing below the configuration of tDBOutput:
i) mysql1.png -> job screenshot
ii) mysql2.png -> error screenshot

Your guidance is much needed.

Kind Regards,
Yogesh.

Re: Not able to create mysql table using talend

vapukov — Mon, 30 Mar 2020 12:55:28 GMT

Hi,

this is not a Talend error (or not only Talend)

you need to know little more about your MySQL configuration, the real error is there:

and this is MySQL error, you need to check default storage engine for your server and it limitations relation with column

Re: Not able to create mysql table using talend

kuwaryogi27 — Mon, 30 Mar 2020 13:04:20 GMT

Hello @vapukov ,

Yes java.sql.SQLSyntaxErrorException: The used storage engine can't index column 'pxp_att_id' is the error I am aware of just shared the whole screenshot.

Can you please guide me further.

Thanks in advance,
Yogesh.

Re: Not able to create mysql table using talend

kuwaryogi27 — Mon, 30 Mar 2020 13:10:07 GMT

Hello @vapukov ,

I have checked the default store engine and that is InnoDB currently.
Sharing the screenshot please have a look.
Kindly guide me for further steps.

Kind Regards,
Yogesh.

mysql3.PNG

Re: Not able to create mysql table using talend

kuwaryogi27 — Mon, 30 Mar 2020 13:17:21 GMT

Hello @vapukov ,

Just adding one more point to above shared response:
If table is created first and then we execute the talend job it works fine.

Kind Regards,
Yogesh.