Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Problem with ORacle data type

  1. #1
    Join Date
    Aug 2007
    Posts
    9

    Default Problem with ORacle data type

    Hello,
    I'm using an oracle database and I discovered an error:
    I have a table in my database like this:
    table dummyTable(
    col1 varchar2(50),
    col2 varchar2(50),
    col3 number);
    Number without precision and scale represent the datatype 'Double'
    I use a 'Table input' step to run this query:
    Select * from dummyTable;
    When I now want to see the preview rows I get this message:

    2007/08/06 11:48:11 - be.ibridge.kettle.trans.Trans - Transformation is in preview mode...
    2007/08/06 11:48:11 - be.ibridge.kettle.trans.Trans - This is not a replay transformation
    2007/08/06 11:48:11 - be.ibridge.kettle.trans.Trans - This transformation can be replayed with replay date: 2007/08/06 11:48:11
    2007/08/06 11:48:11 - be.ibridge.kettle.trans.Trans - Initialising 2 steps...
    2007/08/06 11:48:12 - Table input.0 - Starting to run...
    2007/08/06 11:48:12 - dummy.0 - Starting to run...
    2007/08/06 11:48:12 - Table input.0 - Unexpected error in 'java.lang.NumberFormatException
    2007/08/06 11:48:12 - Table input.0 - java.lang.NumberFormatException
    2007/08/06 11:48:12 - Table input.0 - at java.math.BigDecimal.<init>(Unknown Source)
    2007/08/06 11:48:12 - Table input.0 - at java.math.BigDecimal.<init>(Unknown Source)
    2007/08/06 11:48:12 - Table input.0 - at sun.jdbc.odbc.JdbcOdbcResultSet.getBigDecimal(Unknown Source)
    2007/08/06 11:48:12 - Table input.0 - at be.ibridge.kettle.core.database.Database.getRow(Database.java:3073)
    2007/08/06 11:48:12 - Table input.0 - at be.ibridge.kettle.core.database.Database.getRow(Database.java:3045)
    2007/08/06 11:48:12 - Table input.0 - at be.ibridge.kettle.trans.step.tableinput.TableInput.doQuery(TableInput.java:200)
    2007/08/06 11:48:12 - Table input.0 - at be.ibridge.kettle.trans.step.tableinput.TableInput.processRow(TableInput.java:114)
    2007/08/06 11:48:12 - Table input.0 - at be.ibridge.kettle.trans.step.tableinput.TableInput.run(TableInput.java:290)
    2007/08/06 11:48:12 - Table input.0 - Finished reading query, closing connection.
    2007/08/06 11:48:12 - dummy.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
    2007/08/06 11:48:12 - Table input.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1)

    I think this error is thrown by the column with the datatype 'Number', because
    When I run the query: Select col1,col2 From dummyTable - I get the preview rows.

    Does anybody can help me to solve this problem?
    Thanks a lot
    Regards
    Judith

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Try using Native JDBC.

    Regards,
    Sven

  3. #3
    Join Date
    Aug 2007
    Posts
    9

    Default

    Thanks. That works!

    Regards
    Judith

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.