java - running batch statements in Oracle: sendBatch() vs executeBatch() -
i'm writing java code execute batch of insert statements oracle database. i've seen in of documentation (http://docs.oracle.com/cd/b28359_01/java.111/b31224/oraperf.htm) can use sendbatch()
or executebatch()
this. i'm little confused differences between 2 approaches are, or why choose on over other. maybe missed in readings.
is there can explain differences are, , how can decide when should use 1 approach instead of other?
sendbatch()
oracle version of batching. oracle says using better fitting oracle , gives higher performance. oracle batching supports preparedstatement
.
executebatch()
jdbc standard version. if program should jdbc compliant use method batching. might less performant (according oracle documentation), code compatible other jdbc drivers.
Comments
Post a Comment