Quote:
Is it possible to load all data in memory using JPA or Hibernate directly
It depends if you have enough memory (-Xmx) in your java virtual machine in way to hold all your entities without running into OutOfMemory.
But generally speaking it makes only sense for performance reasons by configuring an appropriate sencond level cache implementation.
Quote:
do many transactions like create, delete, update and finally make a commit when I want?.
You can do this in Hibernate (as well as with JPA or Hibernate directly)
Hibernate offers different ways for doing transaction demarcation.
One of it is manual transaction demarcation.