I want to write join condition explicitly on non key columns using JDOQL in datanucleus.Is it Possible to write in datanucleus?If yes how can we write using JDOQL?
Is it possible to write Join Condition explicitly?
76 views Asked by Nadendla At
1
There are 1 answers
Related Questions in JAVA
- I need the BIRT.war that is compatible with Java 17 and Tomcat 10
- Creating global Class holder
- No method found for class java.lang.String in Kafka
- Issue edit a jtable with a pictures
- getting error when trying to launch kotlin jar file that use supabase "java.lang.NoClassDefFoundError"
- Does the && (logical AND) operator have a higher precedence than || (logical OR) operator in Java?
- Mixed color rendering in a JTable
- HTTPS configuration in Spring Boot, server returning timeout
- How to use Layout to create textfields which dont increase in size?
- Function for making the code wait in javafx
- How to create beans of the same class for multiple template parameters in Spring
- How could you print a specific String from an array with the values of an array from a double array on the same line, using iteration to print all?
- org.telegram.telegrambots.meta.exceptions.TelegramApiException: Bot token and username can't be empty
- Accessing Secret Variables in Classic Pipelines through Java app in Azure DevOps
- Postgres && statement Error in Mybatis Mapper?
Related Questions in DATANUCLEUS
- jboss.jca.common.api.validator.ValidateException: IJ010075: The resource adapter metadata must contain either an outbound or inbound configuration
- GAE / java11 / Datastore / DataNucleus getting runtime exception: org.datanucleus.metadata.InvalidMemberMetaDataException
- JDO Composite Key join
- How do I enable sql logging using DataNucleus with JBOSS 7.2
- Datanucleus 6 enhancer clone method causes infinite loop
- When should I call javax.jdo.Query.close(Object) and Persistence Manager in JDO?
- How to resolve a required class was missing while executing : java/sql/SQLException
- Saving parent and child in separate transactions with JDO (Datanucleus)
- DataNucleus relationship fetch group confusion
- App Engine Datanucleus JPA throwing javax.persistence.PersistenceException on Collection properties of Entities
- Compilation failure after adding Lombok NonNull annotation to JDO Entity fields
- Datanucleus 5.2.x 6.0.0-m1 JDO Enum usage, generated code not compiling
- Eclipse Apache ISIS HelloWorld archetype errors: flatten, QHelloWorldObject, maven build java.sql.SQLException missing
- Amazon S3 Datastores using Datanucleus
- How to do range query with Datanucleus/JDO?
Related Questions in JDOQL
- How to do range query with Datanucleus/JDO?
- JDO Delete parent row without deleting the children rows
- Using String.matches() as a Query filter in JDO Query yields no results
- How to remove discriminators from where clause in request?
- How to fetch data as parent from child object with one to many relation in JDO query in Google cloud datastore?
- Selecting single distinct column from GAE datastore and order by date
- JDOQL subqueries - Class name _ could not be resolved
- How to fetch related object using JDOQL named query?
- Excluding properties when persisting unowned entity relation jdo (gae)
- How can I use DataNucleus JDOQL API to Query Object within Collection?
- FetchPlan does not work
- Multitable queries jdo unowned relationships
- datanucleus-mongodb performance issues on 1-1 Relations
- Is it possible to write Join Condition explicitly?
- JDO Query inside transactions: yes or no?
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Popular Tags
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
You don't write JOINs in JDOQL. That is the whole point of JDOQL ... it is Java syntax, and using object relationaships. If your object "model" has assorted longs/ints around that you think are relationships then you need to revisit your design, since that is not O-O. The same applies to JPA also FWIW, except that you can do explicit joins but what is joined on is to all intents and purposes the relation field only (i.e not on non-key columns).
You could obviously put an extra condition (for the non-key columns) into the FILTER of the JDOQL query (as long as they have a field in the persistable class) that equates to what you want to do.