Sriram Dandapani wrote:
The target table has triggers that route data to appropriate tables. The tables to which data is routed has check constraints that do further inserts. (All of this happens in 1 jdbc transaction)I expect JDBC Batching to generate fewer transactions depending on batch size.
Have you turned autocommit off? -O