tianyufeixiang9 2013-11-09 07:20 采纳率: 0%
浏览 7086

KETTLE SQLSERVER到ORACLE 数据迁移问题 IMAGE类型转BLOB

最近需要从SQLSERVER中向ORACLE中做数据迁移，遇到sqlserver中字段类型为image,向oracle中转化为blob 类型，增加了字段选择，不知道怎么操作，老是报错，求解，错误信息如下：
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : Unexpected error
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : org.pentaho.di.core.exception.KettleDatabaseException:
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : Couldn't get row from result set
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) :
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : Unable to get value 'String(9999999)' from database resultset, index 12
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : 不支持的特性
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) :
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) :
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : at org.pentaho.di.core.database.Database.getRow(Database.java:2824)
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : at org.pentaho.di.core.database.Database.getRow(Database.java:2796)
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : at org.pentaho.di.core.database.Database.getRow(Database.java:2770)
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:257)
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:143)
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : at java.lang.Thread.run(Thread.java:722)
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : Unable to get value 'String(9999999)' from database resultset, index 12
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : 不支持的特性
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) :
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:1900)
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : at org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet(DatabaseMeta.java:2613)
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : at org.pentaho.di.core.database.Database.getRow(Database.java:2816)
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : ... 6 more
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : Caused by: java.sql.SQLException: 不支持的特性
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : at oracle.jdbc.driver.DatabaseError.throwUnsupportedFeatureSqlException(DatabaseError.java:499)
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : at oracle.jdbc.driver.ClobAccessor.getBytes(ClobAccessor.java:279)
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : at oracle.jdbc.driver.OracleResultSetImpl.getBytes(OracleResultSetImpl.java:708)
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:1868)
2013/11/09 15:16:34 - 接收方数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : ... 8 more
2013/11/09 15:16:34 - 接收方数据库.0 - Finished reading query, closing connection.
2013/11/09 15:16:34 - 接收方数据库.0 - 完成处理 (I=0, O=0, R=0, W=0, U=0, E=1
2013/11/09 15:16:34 - CY_HD_YCCYFZSQB - CY_HD_YCCYFZSQB
2013/11/09 15:16:34 - CY_HD_YCCYFZSQB - CY_HD_YCCYFZSQB
2013/11/09 15:16:34 - 源数据库.0 - Finished reading query, closing connection.
2013/11/09 15:16:34 - 源数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : Unexpected error closing query : org.pentaho.di.core.exception.KettleDatabaseException:
2013/11/09 15:16:34 - 源数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : Couldn't close query: resultset or prepared statements
2013/11/09 15:16:34 - 源数据库.0 - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : Cancel has been invoked on this Statement.
2013/11/09 15:16:34 - 源数据库.0 - 完成处理 (I=2, O=0, R=0, W=0, U=0, E=1
2013/11/09 15:16:34 - Spoon - 转换完成!!
2013/11/09 15:16:34 - CY_HD_YCCYFZSQB - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : 错误被检测到!
2013/11/09 15:16:34 - CY_HD_YCCYFZSQB - ERROR (version 4.3.0, build 1 from 2012-07-24 10.59.03 by Administrator) : 错误被检测到!

  • 写回答

1条回答 默认 最新

  • Ok'" 2022-02-28 18:21
    关注

    这个是clob 或者blob 字段问题 请问解决了吗

    评论

报告相同问题？

悬赏问题

  • ¥15 yolov7训练自己的数据集
  • ¥15 esp8266与51单片机连接问题(标签-单片机|关键词-串口)（相关搜索：51单片机|单片机|测试代码）
  • ¥15 电力市场出清matlab yalmip kkt 双层优化问题
  • ¥30 ros小车路径规划实现不了，如何解决？(操作系统-ubuntu)
  • ¥20 matlab yalmip kkt 双层优化问题
  • ¥15 如何在3D高斯飞溅的渲染的场景中获得一个可控的旋转物体
  • ¥88 实在没有想法，需要个思路
  • ¥15 MATLAB报错输入参数太多
  • ¥15 python中合并修改日期相同的CSV文件并按照修改日期的名字命名文件
  • ¥15 有赏，i卡绘世画不出