Error while loading XML file to Mysql db

[TSahoo]

HiTeam,

I am loading from one xml file to mysql data base but getting below error.

Starting job CategoryTable at 12:42 25/04/2023.

[statistics] connecting to socket on port 3533

[statistics] connected

Exception in component tDBOutput_1 (CategoryTable)

java.sql.SQLSyntaxErrorException: Unknown table 'xyx.category'

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)

at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)

at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764)

at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)

at talend_project.categorytable_0_1.CategoryTable.tFileInputXML_1Process(CategoryTable.java:732)

at talend_project.categorytable_0_1.CategoryTable.runJobInTOS(CategoryTable.java:1620)

at talend_project.categorytable_0_1.CategoryTable.main(CategoryTable.java:1458)

[statistics] disconnected

Job CategoryTable ended at 12:42 25/04/2023. [Exit code = 1]

[Anonymous]

Hello @Tulu Sahoo​ ,

Regarding to the error log, the problem is that the mysql table 'xyx.category' does not exists

could you please input an existing mysql tablename for tDBOutput component?

or

setup the Action on table to "Drop table if exists and create" as the below