Hi,

I'm using JPA and before insert there is a select for each Entity. Is it possible to do insert (or update/delete) without select, because it just kills performance.

TIA

your id property seems to be broken preventing hibernate to guess the state correctly, consider using a surrogate key

as for update, you'll need to use session.saveOrUpdate rather than em.merge

Thank for your reply.

The scenario:

1. I get collection of Entities from one EntityManagerFactory/EntityManager

2. In loop I set some values and I want to insert the Entities into
second DB using different EntityManagerFactory/EntityManager using merge(). It works, however there is select for each insert, which affects performance.

The solution is to use persist(). Now there are no selects!

Thanks