JPQL

Jump to bottom Edit New page

Amresh edited this page May 23, 2013 · 5 revisions

Below table lists different JPA query language constructs and whether they are supported for given datastore in Kundera.

JPA-QL Clause	Cassandra	HBase	MongoDB	Neo4j	Redis	OracleNoSQL	RDBMS
SELECT	✔	✔	✔				✔
UPDATE	✔	✔	✔				✔
DELETE	✔	✔	✔				✔
ORDER BY	X	X	✔				✔
AND	✔	✔	✔				✔
OR	X (Yes with Lucene)	✔	✔				✔
BETWEEN	✔	✔	✔				✔
LIKE	X (Yes with Lucene)	✔	✔				✔
IN	X	X	X	X	X	X	X
=	✔	✔	✔				✔
>	✔	✔	✔				✔
<	✔	✔	✔				✔
>=	✔	✔	✔				✔
<=	✔	✔	✔				✔

Please Note:

Kundera supports all above query operations/ clauses on primary key attributes (@Id) and column attributes (@Column).
Queries that contain combination for primary key attribute and columns are supported.

Examples on using JPQL can be found here.