none
Multivalued generates SQL delete all -> SQL insert all values RRS feed

  • Question

  • Hello
    I have a master table in Oracle with a multivalued table associated.
    Imports are OK, and multivalue attributes flow to metaverse.

    In the Extension Project I add a value using the simplest code I know:
    csentry.Item("multivaluedAttribute").Values.Add("NewValue")

    If I search for pending exports for that object in MA Connector Space, it seems OK, N unchanged values and 1 value to Add.
    The problem is the actual export. It generates N SQL deletes and N+1 SQL inserts into the multivalue table.
    The resulting database rows are the same, of course, but it's not acceptable in this case. There are triggers, security checks... that should not be launched N times.

    Can I avoid this behaviour?

    Thank you!

    Wednesday, May 8, 2013 9:45 AM

Answers

All replies

  • ManuelM1,

    I can only speak to the behavior for a MS SQL server MA, but unfortunatly, this is the default (and only) behavior for this type of connector.  You can see my blog article http://www.apollojack.com/2011/04/file-based-management-agents-in.html for a little bit more information.  The only way around this limitation would be to write your own MA. Sorry I couldn't give you better news!

    Rebecca

    • Marked as answer by ManuelM1 Friday, May 10, 2013 8:05 AM
    Thursday, May 9, 2013 4:41 PM
  • Thank you. Good answer and good article

    Bad news :(

    We'll have to think other way to sync these data, buy it's difficult.

    Thank you.

    Friday, May 10, 2013 8:05 AM