Not able to create mysql table using talend

[kuwaryogi27]

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.

[vapukov]

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

[kuwaryogi27]

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.

[kuwaryogi27]

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

[kuwaryogi27]

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.