使用Kettle5.2从SQLServer7.0同步到Oracle11g 因SQLServer含image字段，同步出现错误

Question

使用Kettle5.2从SQLServer7.0同步到Oracle11g   因SQLServer含image字段，同步出现错误。Oracle对应的是Blob字段。

错误描述如下所示：

Couldn't get row from result set
 at java.lang.Thread.run (Thread.java:619)
 at org.pentaho.di.trans.step.RunThread.run (RunThread.java:62)
 at org.pentaho.di.trans.steps.tableinput.TableInput.processRow (TableInput.java:138)
 at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery (TableInput.java:247)
 at org.pentaho.di.core.database.Database.getRow (Database.java:2356)
 at org.pentaho.di.core.database.Database.getRow (Database.java:2380)
 at org.pentaho.di.core.database.Database.getRow (Database.java:2402)
 at org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet (DatabaseMeta.java:2852)
 at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet (BaseDatabaseMeta.java:2086)
 at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet (ValueMetaBase.java:4712)
 at sun.jdbc.odbc.JdbcOdbcResultSet.getBlob (JdbcOdbcResultSet.java:4386)

	at org.pentaho.di.core.database.Database.getRow(Database.java:2410)
	at org.pentaho.di.core.database.Database.getRow(Database.java:2380)
	at org.pentaho.di.core.database.Database.getRow(Database.java:2356)
	at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:247)
	at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:138)
	at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
	at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.UnsupportedOperationException
	at sun.jdbc.odbc.JdbcOdbcResultSet.getBlob(JdbcOdbcResultSet.java:4386)
	at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:4712)
	at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:2086)
	at org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet(DatabaseMeta.java:2852)
	at org.pentaho.di.core.database.Database.getRow(Database.java:2402)
	... 6 more

Answer 1

可能大家遇到的问题不一样，我出现这个问题是因为，先使用的ODBC连接的SQL Server，后续改为Native （JDBC），就不再出现这个问题了。Oracle肯定是使用Blob字段接收的。

Answer 2

怎么解决的，求说明

Answer 3

怎么解决的，求说明

Answer 4

问题已解决，做相应转化即可。