Published on InterSystems Developer Community (https://community.intersystems.com)

Home > JDBC batch insert

Question
Guillaume Rongier · Jan 21, 2019

JDBC batch insert

Hi, I'm looking for a way to implement the JDBC pattern "executeBatch" in ObjectScript: https://www.tutorialspoint.com/jdbc/jdbc-batch-processing.htm

Since Ensemble 2017.2.2 there is a new method called executeParametersBatch : https://docs.intersystems.com/ens20172/csp/docbook/relnotes/index.html#D...

Even in the Ensemble 2018.1 change log, mention a patch on this method: https://docs.intersystems.com/ens20181/csp/docbook/relnotes/index.html#J...

Do you have any examples or tracks to use the executeParametersBatch method of %Net.Remote.Java.JDBCGateway?
Otherwise have you found other workaround for batch insert in JDBC through an EnsLib.SQL.OutboundAdapter?

Thank you in advance for your answers.

#JDBC #SQL #Ensemble

Source URL:https://community.intersystems.com/post/jdbc-batch-insert