java - faster insertion to oracle -

java - faster insertion to oracle -

there view on sql server host has 100 columns , every 4 hours 40000 new records inserted it. have written java application using netbeans first reads info sql server host , inserts oracle database table on different host.

reading time short , never exceeds 20 seconds insertion takes more 10 minutes! can not utilize batches because need go on insertion if exception occurs if utilize batch terminates after first exception.

how can create process faster?

you can utilize mass processing in oracle. save exceptions. when mass operation completes , there @ to the lowest degree 1 exception, exception raised giving chance handle them.

for explanation , illustration see morgans library scroll downwards exceptions.

java sql-server oracle