Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]
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