RE: Batch inserts changed to row by row

Can you show an example of the batch java batch code and the java parameter file?    

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Pap Sent: Thursday, September 12, 2024 8:00 PM To: Oracle L <oracle-l_at_freelists.org> Subject: Batch inserts changed to row by row  

Hello,
While trying to upgrade the drivers from Ojdbc6 to ojdbc8, we encountered an issue in which the batch inserts code which were happening by our Java application initially are now being converted to all row by row. The Java code has not been changed though, but it's just the driver upgrade which is happening. And reaching out to the dev team , they mentioned that the batch size has been mentioned in a properties file in Java and there have been no code changes done, it's just the driver upgrade.  

 So wanted to check , if anybody encountered such issues while upgrading drivers? We are verifying the batch size from the v$sql by dividing "rows_processed/executions" statistics for that query and its coming as ~1 in the ojdbc-8 driver and thus the inserts are happening very slow ojdbc8. Wondering how we can get to the root cause here?  

Regards

Pap

--
http://www.freelists.org/webpage/oracle-l