BulkInsert

Stable Version 2.1.3 (O11)
Also available for 10, 9.1
Published on 10 May by 
Created on 24 November 2015
Details
Quickly insert large quantities of records into a database table.
Read More

Quickly insert large quantities of records into a database table.

  • Supports MySQL, Oracle and SQL Server.
  • Doesn't support simultaneous inserts into multiple entities - the record list passed into the extension must contain only one entity type.
  • Supports inserting data into additional catalogs, if they are added in Service Center.

The bulk insert operations use mechanisms that are specific to each DBMS and Application Server, so the performance may vary.

  • For SQL Server, we used the SqlBulkCopy class
  • For Oracle + .NET, we used ODP.NET’s array binding
  • For Oracle + Java we used JDBC’s batch statements
  • For MySQL + .NET we used the MySQLDataAdapter class
  • MySQL + Java wasn't tested, so it probably doesn't work
What’s new (2.1.3)
  • Fixed an error that left an open iterator when the input record list was empty. Thanks to Luís Marques from OutSystems Support for pointing this out.
Reviews (0)
Category
Libraries, Components
Support Options
This component is not supported by OutSystems. You may use the discussion forums to leave suggestions or obtain best-effort support from the community, including from João Pedro Abreu who created this component.
Dependencies
BulkInsert has no dependencies.
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
Component Consumers
No consumers yet.
Weekly Downloads