Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Difference between revisions of "EclipseLink/UserGuide/JPA/Advanced JPA Development/NoSQL/Querying"
(New page: {{EclipseLink_UserGuide |info=y |toc=n |eclipselink=y |eclipselinktype=JPA |nativeapi=y |nativeapis= *[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/eis/EISInteract...) |
|||
| Line 6: | Line 6: | ||
|nativeapi=y | |nativeapi=y | ||
|nativeapis= | |nativeapis= | ||
| − | *[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/eis/EISInteraction EISInteraction] | + | *[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/eis/interactions/EISInteraction.html EISInteraction] |
| − | *[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/eis/MappedInteraction MappedInteraction] | + | *[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/eis/interactions/MappedInteraction.html MappedInteraction] |
| − | *[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/eis/ | + | *[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/eis/interactions/XMLInteraction.html XMLInteraction] |
| − | *[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/descriptors/DescriptorQueryManager DescriptorQueryManager]}} | + | *[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/descriptors/DescriptorQueryManager.html DescriptorQueryManager]}} |
= Querying = | = Querying = | ||
| Line 17: | Line 17: | ||
<source lang="sql"> | <source lang="sql"> | ||
Select o from Order o | Select o from Order o | ||
| − | <source | + | </source> |
<source lang="sql"> | <source lang="sql"> | ||
Select o from Order o where o.id = :id | Select o from Order o where o.id = :id | ||
| − | <source | + | </source> |
| − | + | ||
| − | + | ||
<blockquote> | <blockquote> | ||
Revision as of 10:31, 2 May 2012
EclipseLink JPA
| EclipseLink | |
| Website | |
| Download | |
| Community | |
| Mailing List • Forums • IRC • mattermost | |
| Issues | |
| Open • Help Wanted • Bug Day | |
| Contribute | |
| Browse Source |
Native API
Querying
Querying in NoSQL is dependent on the NoSQL platform. Some NoSQL data-sources may support dynamic querying through their own query language, others may not support querying at all. EclipseLink does its best to support as much of JPQL and the Criteria API on a NoSQL platform as possible. Almost all NoSQL platforms allow querying by Id, so find() can be used to look-up objects by Id. Most NoSQL platforms also allow a find everything operation, this allows EclipseLink to support JPQL and Criteria queries that are by Id, of have no where clause.
For example:
SELECT o FROM ORDER o
SELECT o FROM ORDER o WHERE o.id = :id
MongoDB - JPQL and Criteria are supported with some restrictions. Joins, sub-selects and certain database functions are not supported.
Oracle NoSQL - find() and JPQL and Criteria by Id or with no WHERE clause are supported.
