feng1990liu 2015-03-23 03:25 采纳率: 50%
浏览 9290
已采纳

kettle,把oracle的数据迁移到Mysql中是报错，感觉是字段方面的错误，求大神指教

2015/03/23 11:25:52 - 表输出.0 - Connected to database local_hsps1
2015/03/23 11:25:52 - 表输出.0 - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : Unexpected batch update error committing the database connection.
2015/03/23 11:25:52 - 表输出.0 - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseBatchException:
2015/03/23 11:25:52 - 表输出.0 - Error updating batch
2015/03/23 11:25:52 - 表输出.0 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MAXVALUE, MINVALUE, MODIFIER, MODIFYTIME, NAME, RANK, RECORDTIME, RECORDER, STAT' at line 1
2015/03/23 11:25:52 - 表输出.0 -
2015/03/23 11:25:52 - 表输出.0 - at org.pentaho.di.core.database.Database.createKettleDatabaseBatchException(Database.java:1351)
2015/03/23 11:25:52 - 表输出.0 - at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1340)
2015/03/23 11:25:52 - 表输出.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:571)
2015/03/23 11:25:52 - 表输出.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:96)
2015/03/23 11:25:52 - 表输出.0 - at java.lang.Thread.run(Thread.java:745)
2015/03/23 11:25:52 - 表输出.0 - Caused by: java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MAXVALUE, MINVALUE, MODIFIER, MODIFYTIME, NAME, RANK, RECORDTIME, RECORDER, STAT' at line 1
2015/03/23 11:25:52 - 表输出.0 - at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1815)
2015/03/23 11:25:52 - 表输出.0 - at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1277)
2015/03/23 11:25:52 - 表输出.0 - at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1327)
2015/03/23 11:25:52 - 表输出.0 - ... 3 more
2015/03/23 11:25:52 - 表输出.0 - Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MAXVALUE, MINVALUE, MODIFIER, MODIFYTIME, NAME, RANK, RECORDTIME, RECORDER, STAT' at line 1
2015/03/23 11:25:52 - 表输出.0 - at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2015/03/23 11:25:52 - 表输出.0 - at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
2015/03/23 11:25:52 - 表输出.0 - at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
2015/03/23 11:25:52 - 表输出.0 - at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
2015/03/23 11:25:52 - 表输出.0 - at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
2015/03/23 11:25:52 - 表输出.0 - at com.mysql.jdbc.Util.getInstance(Util.java:360)
2015/03/23 11:25:52 - 表输出.0 - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
2015/03/23 11:25:52 - 表输出.0 - at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
2015/03/23 11:25:52 - 表输出.0 - at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
2015/03/23 11:25:52 - 表输出.0 - at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
2015/03/23 11:25:52 - 表输出.0 - at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
2015/03/23 11:25:52 - 表输出.0 - at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)
2015/03/23 11:25:52 - 表输出.0 - at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)
2015/03/23 11:25:52 - 表输出.0 - at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2141)
2015/03/23 11:25:52 - 表输出.0 - at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1773)
2015/03/23 11:25:52 - 表输出.0 - ... 5 more
2015/03/23 11:25:52 - 表输出.0 - 完成处理 (I=0, O=0, R=15, W=0, U=0, E=1

  • 写回答

1条回答 默认 最新

  • 大河行脚 2015-03-23 03:38
    关注

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MAXVALUE, MINVALUE, MODIFIER, MODIFYTIME, NAME, RANK, RECORDTIME, RECORDER, STAT' at line 1

    这个错误产生的原因是你sql语句哪里写的有小毛病造成的,你仔细找找就可以了

    如果回答对您有帮助,请采纳

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题？