0

From my spring java code, i am trying to insert 13,500 rows into a table in oracle database through below step.

NamedParameterJdbsTemplate.batchupdate(insert quert, listname. Toarray(new map(list.size());

But the process gets freeze at this step, it does not throw any error.

Observed this only when inserting more number of records into table.

Able to insert successfully with above step when I try to insert 12000 or less rows.

But when I try to insert 13500 rows, the process gets freeze and do not throw any error either.

Able to insert even 40k rows at once into the same table from database. Db table does not causing any issue, but facing this issue only from batchupdate form java that too only for rows above 12000.

Could you please help me how to figure what causing this issue?

0 Answers0