1. SELECT NEW in JPQL stackoverflow.com
I'm having an issue with a SELECT NEW query.
2. Help with JPQL query stackoverflow.com
I have to query a
3. sql query with space in the value stackoverflow.com
How do I write where clause where the value has spaces: Actually I am using openJPA and I have to set parameter. The value i will be setting has a space, eg: String somevalue="firstname ...
4. select from two tables using JPQL stackoverflow.com
I m using JPQL to retrieve data. I can get data using the statement
5. Can we assign custom Query Hints to JPA NamedQueries stackoverflow.com
We are required to append query numbers to each and every query our application executes. EX: SELECT * FROM ... WHERE ... QUERYNO 123456; OpenJPA supports query hints, but only for ...
6. OpenJPA: how to construct a GROUP BY query with a group count stackoverflow.com
In JPQL I want to construct the equivalent query to this:
7. Slow Performing OpenJPA Query stackoverflow.com
I have the following query method that has slow performance:
8. why is OpenJPA 2.1 throwing ArgumentException when using a critera query and equal(x,object)? stackoverflow.com
Why does this work:
9. How to write named native subqueries in JPA? stackoverflow.com
I was given a task to write a named native subquery like
The entities are company
10. Subqueries in JPA is not working with OpenJPA coderanch.com
Does JPA support subqueries in the select part of the main query. For example : SELECT record1.txnId, record1.accessTime, (SELECT record2.accessTime FROM Metering record2 WHERE record2.txnId=record1.txnId AND record2.action='END') FROM Metering record1 WHERE record1.action='START' The above query is properly working with Hibernate implementation. But when i use OpenJPA implementation instead of Hibernate implementation it is giving the following error: org.springframework.dao.InvalidDataAccessApiUsageException: Encountered "(" at ...
11. having trouble writing a select statement openJpa coderanch.com
12. OPENJPA-1941 Criteria query returns wrong result when query forum.hibernate.org