Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Database Join error: invalid column index

  1. #1

    Question Database Join error: invalid column index

    When I send a stream to a Database join and then to a "filter rows", I get this error:

    ---------------
    Error obtaining fields for this step
    Couldn't get field info from [SELECT COUNT(*) AS CANTSHIPPING
    FROM SHIPPING_ORDER
    WHERE CUSTOMER_ID=?
    AND COMMENTS LIKE '%?%'
    AND TYPE=17
    ]

    offending row : [CustomerID Integer(9)], [SC1 String(17)]
    Error setting value #2 [SC1 String(17)] on prepared statement (String)
    java.sql.SQLException: Invalid column index
    Invalid column index
    ------------------

    I have included the 2 fields to be replaced in the original sql sentence.. So, what do you think?

    Regards,
    Luis

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    LIKE ?

    is possible, not your LIKE clause.

  3. #3

    Thumbs up Delayed thanks :-(

    Dear Matt:

    Thank you very much! Now I understand what you meant... Sorry for the delay in my answer.

    Regards,
    Luis

Tags for this Thread

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.