Error while loading XML file to Mysql db

TSahoo — Fri, 15 Nov 2024 21:52:16 GMT

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]

Re: Error while loading XML file to Mysql db

Anonymous — Wed, 26 Apr 2023 00:50:15 GMT

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?

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