Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Get Object Kettle row from database!

  1. #1

    Default Get Object Kettle row from database!

    Hellow all!
    Before PDI 3, i get Row from kettle datasourece for table log

    ResultSet resultSet = databaseLog.openQuery("SELECT * FROM "+jobMeta.getLogTable()+" WHERE JOBNAME = ? ORDER BY ID_JOB desc", params)
    after
    Row row = databaseLog.getRow(resultSet); - IS ERROR!!!!
    Object [] row = databaseLog.getRow(resultSet); - IS TRUE in PDI 3.0

    jStore.setLRead(new Long(row.getString("LINES_READ", ""))); - is Error :-(
    Where is JavaDoc? Help!!

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

    Default

    The Object[] contains the actual values so you don't have to do getString() anymore. If you don't know the type or order of a value you can normally go over the ValueMetaInterface, but if you call openQuery yourself that may not be available.

    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.