Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: ArrayIndexOutOfBoundsException in Database.getRow

  1. #1
    screttet Guest

    Default ArrayIndexOutOfBoundsException in Database.getRow

    Hi
    i have the following exception when i run Pentaho Data Integration.
    If i restart i always have the exception but not on the same row

    Can you explain me what's happen

    Thank you

    ERROR (version 3.1.0-RC1, build 771 from 2007/11/14 00:11:43) :
    Unexpected error :
    java.lang.ArrayIndexOutOfBoundsException: 1
    at oracle.sql.NUMBER.toBigDecimal(NUMBER.java:656)
    at oracle.jdbc.dbaccess.DBConversion.NumberBytesToBigDecimal(DBConversion.java:2805)
    at oracle.jdbc.driver.OracleStatement.getBigDecimalValue(OracleStatement.java:4728)
    at oracle.jdbc.driver.OracleResultSetImpl.getBigDecimal(OracleResultSetImpl.java:1249)
    at org.pentaho.di.core.database.Database.getRow(Database.java:2785)
    at org.pentaho.di.core.database.Database.getRow(Database.java:2760)
    at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:137)
    at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2654)
    at org.pentaho.di.trans.steps.tableinput.TableInput.run(TableInput.java:343)

  2. #2

    Default

    Hi screttet,
    what does the following say to you?
    Quote Originally Posted by screttet View Post
    java.lang.ArrayIndexOutOfBoundsException: 1
    at oracle.sql.NUMBER.toBigDecimal(NUMBER.java:656)
    at oracle.jdbc.dbaccess.DBConversion.NumberBytesToBigDecimal(DBConversion.java:2805)
    at oracle.jdbc.driver.OracleStatement.getBigDecimalValue(OracleStatement.java:4728)
    at oracle.jdbc.driver.OracleResultSetImpl.getBigDecimal(OracleResultSetImpl.java:1249)
    ...
    Yes, it is code from Oracle. Should Kettle people know that?
    It looks like there are conversions from Number into BigDecimal which your Oracle JDBC driver can not handle.

    The only thing we can do is oracle about this error.
    If you provide your Table Input step and the DDL for involved tables maybe someone can help.

    You should also execute the same SQL statement in a Java program connected via same JDBC driver. What is the result?

    Christoph
    21 is only half the truth

  3. #3
    Join Date
    Nov 1999
    Posts
    459

    Default Oracle JDBC driver issue

    Most likely: Try to use the correct Oracle JDBC driver that fits to your Oracle server version, replace the driver in libext/JDBC.

    HTH,
    Jens

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.