Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Oracle Parameter 'setFloatAndDoubleUseBinary'

  1. #1
    Join Date
    Sep 2006
    Posts
    5

    Default Oracle Parameter 'setFloatAndDoubleUseBinary'

    Hi,

    I have a problem importing data into an Oracle 8 database with KETTLE 2.4. For one of a couple Number(13,2) fields the double value is set to the Prepared Statement properly, but saved to the database with irregular bytes.
    I asked Oracle support for help and they asked me if the Oracle Parameter 'setFloatAndDoubleUseBinary' is set to true:

    ACTION PLAN
    ============
    1. There is a connection property called SETFLOATANDDOUBLEUSEBINARY. When this property is set to true, setDouble will convert to canonical values. Can you check if your code has this property set?

    I searched for it but without success, does anybody know if this parameter is touched at any place within Kettle-Transformations?

    Thanks in advance
    Markus

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

    Default

    setFloatAndDoubleUseBinary is not touched as far as I know. As little as possible database specific code is used.

    First try version 2.5.1 of Kettle. If that fails replace your output by a text output step and check the data that you try to load to oracle.

    Regards,
    Sven

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.