https://community.qlik.com/t5/Talend-Studio/JavaRow-to-MySQLOutput-quot-newColumn-quot-error/m-p/2243328#M29870 Hi <BR />In your schema of tMysqlOutput component, there is a 'Db Column' field, you should set the column name as the same column which you define in your database. <BR />Best regards <BR /> shong Thu, 15 Nov 2007 02:02:25 GMT Anonymous 2007-11-15T02:02:25Z https://community.qlik.com/t5/Talend-Studio/JavaRow-to-MySQLOutput-quot-newColumn-quot-error/m-p/2243327#M29869 I am trying to load a file into a MySQL DB. I succesfully load the file and use a tJavaRow module to parse and enhance the data. The output of this function looks good when I use tLogRow to show me the output. I then replace the tLogRow with a tMySqlOutput, sync up the column names (I made sure the names are identical to the DB column names) and hit run. I then get <BR />Exception in component tMysqlOutput_1 <BR />com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'newColumn' in 'field list' <BR /> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) <BR /> at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) <BR /> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) <BR /> at java.lang.reflect.Constructor.newInstance(Unknown Source) <BR /> at com.mysql.jdbc.Util.handleNewInstance(Util.java:353) <BR /> at com.mysql.jdbc.Util.getInstance(Util.java:336) <BR /> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1031) <BR /> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957) <BR /> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2938) <BR /> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1601) <BR /> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1710) <BR /> at com.mysql.jdbc.Connection.execSQL(Connection.java:2436) <BR /> at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1402) <BR /> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1694) <BR /> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1608) <BR /> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1593) <BR /> at control_1.z_development.Z_Development.tFileList_1Process(Z_Development.java:1525) <BR /> at control_1.z_development.Z_Development.runJob(Z_Development.java:1707) <BR /> at control_1.z_development.Z_Development.main(Z_Development.java:1651) <BR />Job Z_Development ended at 11:22 15/11/2007. <BR />Looking at the code I found a line that looks like this <BR /> pstmt_tMysqlOutput_1 = conn_tMysqlOutput_1 <BR /> .prepareStatement("INSERT INTO `" <BR /> + "sdf_acrm_log" <BR /> + "` (`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn`,`newColumn1`,`newColumn2`,`newColumn3`,`newColumn4`,`newColumn`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"); <BR /> <BR />Why is this so? Sat, 16 Nov 2024 14:30:54 GMT https://community.qlik.com/t5/Talend-Studio/JavaRow-to-MySQLOutput-quot-newColumn-quot-error/m-p/2243327#M29869 Anonymous 2024-11-16T14:30:54Z https://community.qlik.com/t5/Talend-Studio/JavaRow-to-MySQLOutput-quot-newColumn-quot-error/m-p/2243328#M29870 Hi <BR />In your schema of tMysqlOutput component, there is a 'Db Column' field, you should set the column name as the same column which you define in your database. <BR />Best regards <BR /> shong Thu, 15 Nov 2007 02:02:25 GMT https://community.qlik.com/t5/Talend-Studio/JavaRow-to-MySQLOutput-quot-newColumn-quot-error/m-p/2243328#M29870 Anonymous 2007-11-15T02:02:25Z