multi-row inserts and updates

• bfortune

  Grasshopper

  Points: 13

  More actions

  March 16, 2004 at 6:15 pm

  #107335

  I am doing bulk inserts and updates to tables via JDBC.

  Currently I sending these in batches of CallableStatements invoking simple insert and update stored procedures.

  I am considering an alternative using XML - write a stored procedure that takes an XML document containing the inserted or updated data as a String parameter. The stored proc then uses the OpenXML() method to load the XML document as a virtual table, and then uses set-based operations to insert or update the tables.

  I would like to know if anyone used this approach, and how the performance would compare?

• fhanlon

  SSChampion

  Points: 13131

  More actions

  March 23, 2004 at 2:43 pm

  #500114

  See http://www.eggheadcafe.com/articles/20030627c.asp for sample code on passing XML to stored procs

  Francis