Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Implementing ISQLServerBulkRecord in Pentaho (User Defined Java Class)

  1. #1
    Join Date
    Oct 2017
    Posts
    1

    Question Implementing ISQLServerBulkRecord in Pentaho (User Defined Java Class)

    Hi
    I Want to use ISQLServerBulkRecord interface for a streaming of data. As there is scanty doc on implementing ISQLServerBulkRecord interface, and for need, added extra methods addDataRow().
    But this complains at

    writeToServer() complains about ": Unable to retrieve column metadata" What do you suggest "How to add Metadata info" before adding data?
    Object[] r = getRow();
    RowMetaInterface inputRowMeta = getInputRowMeta();
    //BulkCopy implements ISQLServerBulkRecord
    BulkCopy blkRecord = new BulkCopy();
    blkRecord.addDataRow(inputRowMeta.toString()); //Currently using this way
    blkRecord.addDataRow(r[0]+","+r[1]);
    ssBulkCopy.writeToServer(blkRecord); //Errors out Unable to retrieve column metadata
    Waiting for suggestion!
    Thanks
    Saanvi S
    Last edited by gutlez; 12-06-2017 at 07:54 PM.

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Your mentioning "BulkCopy implements ISQLServerBulkRecord" makes me stare at a TechNet article in disbelieve ...
    So long, and thanks for all the fish.

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.