David-
Batching functionality was not included in the OpenJPA code
contribution made by BEA, but you are correct that the infrastructure
necessary for its support is in place.
I can't comment on whether BEA could be persuaded to contribute that
code as well beyond saying that they are always open to community
suggestions and feedback.
On Jan 10, 2007, at 5:11 PM, David Wisneski wrote:
Does OpenJPA support sql batching (i.e. the jdbc addBatch api on a
prepared Statement)? The user's guide shows how to set the addBatch
limit, but it does not work. It would appear that if there was code
to do this it was removed.
I think that most ORM runtimes support this feature and we will be at
a competitive disadvantage with Hibernate and TopLink without it. It
is very important when creating and persist many new object of the
same type in one transaction (i.e. persisting 1000 new Customer beans)
or doing many updates ( updating the salary on 1000 Employee beans).
I know that addBatch performance vs. doing multiple jdbc executeUpdate
makes a big differrent in DB2 -- and I would assume also other
databases.
If the code was there and removed -- any thoughts about adding it
back in? Otherwise we would most likely have to develop it for our
enterprise customer.
