CODEWITHSUNDEEP
jpa
javydreamercsw
javydreamercsw

Reputation: 5099

JPA insert statement

What's the correct syntax 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?

Upvotes: 36

Views: 85164

Answers (5)

javydreamercsw
javydreamercsw

Reputation: 5099

The option that looks more promising so far is using Flyway. It is a more automated way of doing it and handles the upgrade process of databases basically automatically.

Upvotes: 2

memozac
memozac

Reputation: 91

If you want to insert data to the database outside Java, you need to use native SQL. Use SQL Standard to make sure most databases can execute the script. When the application runs, JPA will make the mapping of the new data and convert it into objects when needed.

How to make sure the script works in all databases? Well that's the same problem any DBA has when making Store Procedures or native queries... that's why JPA exists, to avoid making it directly in SQL, but I know sometimes it's needed that way.

I suggest you to make 3 main scripts. One for Oracle, one for SQL Server (there are some issues in the date datatypes from 2005 to 2008 versions so be careful), and one for MySQL. Start your script with standard SQL and when you test it in these databases you will find some fixes you will need to do for each DBMS.

Once you got it, you can make a file script (*.sql file) and run it with the DB manager. If it works, run the server, put the app online and the data will be integrated just fine.

Upvotes: 5

Shipra
Shipra

Reputation: 101

No need to write a separate INSERT query in JPA. JpaRepository has inbuilt saveAndFlush() method which you can use to insert into the database. Hope this works for you.

Upvotes: 2

Ben Hoffstein
Ben Hoffstein

Reputation: 103325

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();

Upvotes: 22

frm
frm

Reputation: 3486

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.

Upvotes: 36

Related Questions