I am trying to insert data into a table having columns (NAME, VALUE) with
Query query = em.createQuery("INSERT INTO TestDataEntity (NAME, VALUE) VALUES (:name, :value)");
query.setParameter("name", name);
query.setParameter("value", value);
query.executeUpdate();
and getting the following exception:
ERROR org.hibernate.hql.internal.ast.ErrorCounter - line 1:42: unexpected token: VALUES
Also, I cannot insert a record using a native query either:
Query query = em.createNativeQuery("INSERT INTO TEST_DATA (NAME, VALUE) VALUES (:name, :value);");
query.setParameter("name", name);
query.setParameter("value", value);
query.executeUpdate();
Another exception is being thrown:
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
The question is:
Many thanks.
I found two examples where the author uses the insert in a native query (first and second). Then, your query could be:
Query query = em.createQuery("INSERT INTO TestDataEntity (NAME, VALUE) VALUES (?, ?)");
query.setParameter(1, name);
query.setParameter(2, value);
query.executeUpdate();
Try this.
I was able to do this using the below - I just had a Table name Bike with 2 fields id and name . I used the below to insert that into the database.
Query query = em.createNativeQuery("INSERT INTO Bike (id, name) VALUES (:id , :name);");
em.getTransaction().begin();
query.setParameter("id", "5");
query.setParameter("name", "Harley");
query.executeUpdate();
em.getTransaction().commit();