jpql « Update « JPA Q&A

  1. JPA Q&A
  2. Update
  3. jpql




1. JPQL TEMEDIFF equvalent    stackoverflow.com

Is there an equvalent of the SQL TIMEDIFF functionality in JPQL? Is that possible to query with JPQL to find the records in specific time range?

2. JPA / JPQL - bulk update    stackoverflow.com

I have to perform a bulk update on a table. Making a fast example : 

 UPDATE Book b SET b.amount = b.amount + 1 WHERE b IN ( :books )
The problem is ...

3. UPDATE and JOIN with JPQL    stackoverflow.com

Tutorials and samples about JPQL always deal with SELECT statement and sometimes, simple UPDATE statements. I need to update a table with a join. I have simplified my env : KEY
= id
- ...

4. Update value with join    stackoverflow.com

using Hibernate, I'd like to update a data in the database based on conditions, but I got the following error : "node to traverse cannot be null" Here is my database description ...

5. JPA: Join across two persistence units    stackoverflow.com

I have two different persistence units in my application. I'm using JPA 2.0 with Hibernate as my entity provider. In one of my database schemas, I have a table which contains ...