JPA insert statement

Question

What's the correct sintax of a JPA insert statement? This might sound like an easy question but I haven't been able to find an answer.

I know how to do it from Java code but I'm looking for a way to insert objects into the database if the database was created.

Any ideas?

Answer 1

There is no INSERT statement in JPA. You have to insert new entities using an EntityManager. The only statements allowed in JPA are SELECT, UPDATE and DELETE.

Answer 2

Here is a good reference on persisting JPA objects using an EntityManager. As an example, this is how to insert objects using the persist method:

EntityManager em = getEntityManager();
em.getTransaction().begin();

Employee employee = new Employee();
employee.setFirstName("Bob");
Address address = new Address();
address.setCity("Ottawa");
employee.setAddress(address);

em.persist(employee);

em.getTransaction().commit();