forked from Impetus/kundera
-
Notifications
You must be signed in to change notification settings - Fork 0
JPQL
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 | ✔ | X | X | X | ✔ |
AND | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ |
OR | X (Yes with Lucene) | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ |
BETWEEN | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ |
LIKE | X (Yes with Lucene) | ✔ | ✔ | ✔ | X | X | ✔ |
IN | X | X | X | X | X | X | X |
= | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ |
> | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ |
< | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ |
>= | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ |
<= | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ |
- 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.
-
Datastores Supported
- Releases
-
Architecture
-
Concepts
-
Getting Started in 5 minutes
-
Features
- Object Mapper
- Polyglot Persistence
- Queries Support
- JPQL (JPA Query Language)
- Native Queries
- Batch insert update
- Schema Generation
- Primary Key Auto generation
- Transaction Management
- REST Based Access
- Geospatial Persistence and Queries
- Graph Database Support
-
Composite Keys
-
No hard annotation for schema required
-
Support for Mapped Superclass
- Configuration
- [Kundera with OracleNoSQL] (https://github.com/impetus-opensource/Kundera/wiki/Kundera-OracleNoSQL)
-
Extend Kundera
-
Sample Codes and Examples
- [Blogs and Articles] (https://github.com/impetus-opensource/Kundera/wiki/Blogs--and-Articles)
-
Performance
-
Troubleshooting
-
FAQ
- Feedback