org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get row from result set Unable to get value 'Binary' from database resultset, index 9 The conversion from binary to BLOB is unsupported.

Pentaho BI Platform Tracking | Matt Tucker | 1 year ago
  1. 0

    It is not possible to return binary data from a Microsoft SQL Server table. Instead, an error is thrown that the Binary value could not be converted to a BLOB object. This works fine for a jTDS-based connection (the non-"Native" database type), but it fails for Native (Microsoft-provided JDBC driver) connections. {noformat} 2015/11/11 11:24:47 - Table input.0 - ERROR (version 5.4.0.3-143, build 1 from 2015-08-06 14.29.30 by buildguy) : Unexpected error 2015/11/11 11:24:47 - Table input.0 - ERROR (version 5.4.0.3-143, build 1 from 2015-08-06 14.29.30 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2015/11/11 11:24:47 - Table input.0 - Couldn't get row from result set 2015/11/11 11:24:47 - Table input.0 - 2015/11/11 11:24:47 - Table input.0 - Unable to get value 'Binary' from database resultset, index 9 2015/11/11 11:24:47 - Table input.0 - The conversion from binary to BLOB is unsupported. 2015/11/11 11:24:47 - Table input.0 - 2015/11/11 11:24:47 - Table input.0 - 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2414) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2384) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2362) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:247) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:138) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2015/11/11 11:24:47 - Table input.0 - at java.lang.Thread.run(Thread.java:745) 2015/11/11 11:24:47 - Table input.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2015/11/11 11:24:47 - Table input.0 - Unable to get value 'Binary' from database resultset, index 9 2015/11/11 11:24:47 - Table input.0 - The conversion from binary to BLOB is unsupported. 2015/11/11 11:24:47 - Table input.0 - 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:4708) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:2086) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet(DatabaseMeta.java:2853) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2406) 2015/11/11 11:24:47 - Table input.0 - ... 6 more 2015/11/11 11:24:47 - Table input.0 - Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from binary to BLOB is unsupported. 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.DataTypes.throwConversionError(DataTypes.java:1117) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.ServerDTVImpl.getValue(dtv.java:2481) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.DTV.getValue(dtv.java:193) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.Column.getValue(Column.java:132) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:2082) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:2067) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getBlob(SQLServerResultSet.java:2571) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:4677) 2015/11/11 11:24:47 - Table input.0 - ... 9 more {noformat} According to the [Microsoft SQL Server JDBC driver reference|https://msdn.microsoft.com/en-us/library/ms378680(v=sql.110).aspx], the majority of binary data types are not supported with the use of the JDBC getBlob() method, even though we say it's supported in the DatabaseMeta class.

    Pentaho BI Platform Tracking | 1 year ago | Matt Tucker
    org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get row from result set Unable to get value 'Binary' from database resultset, index 9 The conversion from binary to BLOB is unsupported.
  2. 0

    It is not possible to return binary data from a Microsoft SQL Server table. Instead, an error is thrown that the Binary value could not be converted to a BLOB object. This works fine for a jTDS-based connection (the non-"Native" database type), but it fails for Native (Microsoft-provided JDBC driver) connections. {noformat} 2015/11/11 11:24:47 - Table input.0 - ERROR (version 5.4.0.3-143, build 1 from 2015-08-06 14.29.30 by buildguy) : Unexpected error 2015/11/11 11:24:47 - Table input.0 - ERROR (version 5.4.0.3-143, build 1 from 2015-08-06 14.29.30 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2015/11/11 11:24:47 - Table input.0 - Couldn't get row from result set 2015/11/11 11:24:47 - Table input.0 - 2015/11/11 11:24:47 - Table input.0 - Unable to get value 'Binary' from database resultset, index 9 2015/11/11 11:24:47 - Table input.0 - The conversion from binary to BLOB is unsupported. 2015/11/11 11:24:47 - Table input.0 - 2015/11/11 11:24:47 - Table input.0 - 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2414) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2384) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2362) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:247) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:138) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2015/11/11 11:24:47 - Table input.0 - at java.lang.Thread.run(Thread.java:745) 2015/11/11 11:24:47 - Table input.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2015/11/11 11:24:47 - Table input.0 - Unable to get value 'Binary' from database resultset, index 9 2015/11/11 11:24:47 - Table input.0 - The conversion from binary to BLOB is unsupported. 2015/11/11 11:24:47 - Table input.0 - 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:4708) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:2086) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet(DatabaseMeta.java:2853) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2406) 2015/11/11 11:24:47 - Table input.0 - ... 6 more 2015/11/11 11:24:47 - Table input.0 - Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from binary to BLOB is unsupported. 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.DataTypes.throwConversionError(DataTypes.java:1117) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.ServerDTVImpl.getValue(dtv.java:2481) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.DTV.getValue(dtv.java:193) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.Column.getValue(Column.java:132) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:2082) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:2067) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getBlob(SQLServerResultSet.java:2571) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:4677) 2015/11/11 11:24:47 - Table input.0 - ... 9 more {noformat} According to the [Microsoft SQL Server JDBC driver reference|https://msdn.microsoft.com/en-us/library/ms378680(v=sql.110).aspx], the majority of binary data types are not supported with the use of the JDBC getBlob() method, even though we say it's supported in the DatabaseMeta class.

    Pentaho BI Platform Tracking | 1 year ago | Matt Tucker
    org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get row from result set Unable to get value 'Binary' from database resultset, index 9 The conversion from binary to BLOB is unsupported.
  3. 0

    Does JDBI accept UUID parameters?

    Stack Overflow | 4 years ago | Fernando Correia
    com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from UNKNOWN to UNKNOWN is unsupported.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    MS SQL Server :: Jdbc Type 4 Driver Error

    bigresource.com | 7 months ago
    com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from int to DATE is unsupported.

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. com.microsoft.sqlserver.jdbc.SQLServerException

      The conversion from binary to BLOB is unsupported.

      at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError()
    2. com.microsoft.sqlserver
      SQLServerResultSet.getBlob
      1. com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
      2. com.microsoft.sqlserver.jdbc.DataTypes.throwConversionError(DataTypes.java:1117)
      3. com.microsoft.sqlserver.jdbc.ServerDTVImpl.getValue(dtv.java:2481)
      4. com.microsoft.sqlserver.jdbc.DTV.getValue(dtv.java:193)
      5. com.microsoft.sqlserver.jdbc.Column.getValue(Column.java:132)
      6. com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:2082)
      7. com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:2067)
      8. com.microsoft.sqlserver.jdbc.SQLServerResultSet.getBlob(SQLServerResultSet.java:2571)
      8 frames
    3. org.pentaho.di
      RunThread.run
      1. org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:4677)
      2. org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:2086)
      3. org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet(DatabaseMeta.java:2853)
      4. org.pentaho.di.core.database.Database.getRow(Database.java:2406)
      5. org.pentaho.di.core.database.Database.getRow(Database.java:2384)
      6. org.pentaho.di.core.database.Database.getRow(Database.java:2362)
      7. org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:247)
      8. org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:138)
      9. org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
      9 frames
    4. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame