Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Identity Fields

  1. #1

    Default Identity Fields

    Using JDBC, if I need the auto-generated keys for an insert statement, I'll just call statement.getGeneratedKeys(). Using MS SQL Server I'd try SELECT @@IDENTITY FROM <tablename> after each insert. How do I get and associate all generated keys with their corresponding inserted rows in Spoon?

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

    Default RE: Identity Fields

    Hi Mark,

    We didn&#39;t really need this so far, but I guess it&#39;s not that hard to add support for this.
    Can you add a tracker? We&#39;ll try to squeeze it into the 2.3.0 release for next month.

    Thanks,
    Matt

  3. #3

    Default RE: Identity Fields

    I just saw the change. I&#39;ll test it out sometime tonight.

    Marc

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

    Default RE: Identity Fields

    Marc,

    It&#39;s only doing ONE key in a table (most database only support 1 by the way) at the moment, but we could extend this easily in the future.

    Also, it doesn&#39;t do this with batch processing turned on. There is a way to do it, but it&#39;s pretty complex stuff to make that happen. At the moment I don&#39;t want to break anything as we&#39;re doing development at 1104 commits over the last 30 days. :-)

    Matt

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.