Update Insert using dynamic SQL or custom SQL.

Has any tried doing batch insert/update using dynamic or custom SQL.

I have a requirement where i have to develop a generic code which transfer data across multiple plant database having different database name and schema name. I cannot use JDBC batch insert template because it does not give flexibility to change schema name at run time.

One of the way to achieve this is looping over the list of records and generating SQL query by string concatation method. And passing this SQL to dynamic JDBC template.

Any other ways to do it ?

Thanks !