Questions tagged [jdoql]

JDOQL is the query language of the JDO persistence API. JDOQL is designed as the Java developers way of having the power of SQL queries, yet retaining the Java object relationship that exist in their application model.

JDOQL is the query language of the JDO persistence API. JDOQL is designed as the Java developers way of having the power of SQL queries, yet retaining the Java object relationship that exist in their application model.

84 questions
0
votes
1 answer

Declarative JDOQL vs Single-String JDOQL : performance

When querying with JDOQL is there a performance difference between using the declarative version and the Single-String version: Example from the JDOQL doc: //Declarative JDOQL : Query q = pm.newQuery(org.jpox.Person.class, "lastName == \"Jones\" &&…
Jla
  • 11,304
  • 14
  • 61
  • 84
0
votes
0 answers

Multitable queries jdo unowned relationships

I need some help I'm working with gae, datastore and jdo Country 1 - N department; Department 1 - N provinces, unowned relationship, as knowing country data at province Entity Pais: @PersistenceCapable(detachable = "true") public class Pais…
0
votes
0 answers

datanucleus-mongodb performance issues on 1-1 Relations

Again, I'm creating this thread to see if someone has the same issues or if someone knows how to improve performance. Let me explain first the scenario: I have a JDO entity named for example Product. In that product I have a field of another entity,…
0
votes
1 answer

AppEngine JDO-QL : Problem with multiple AND and OR in query

I'm working with App Engine(Java/JDO) and are trying to do some querying with lists. So I have the following class: @PersistenceCapable(identityType = IdentityType.APPLICATION, detachable="true") public class MyEntity { @PrimaryKey …
KlasE
  • 142
  • 11
0
votes
1 answer

How to delete specific record from Google Datastore (in Java)?

I have some records in datastore, I want to delete a specific record from the table. for example in SQL , we use delete * from table1 where name ="mike" what is the equivalent code in java (I m using Eclipse with Google appengine API plugin)? or any…
Srivi
  • 407
  • 3
  • 7
  • 20
0
votes
2 answers

JDOQL Any way to avoid multiple .contains() calls in the query when searching for the presence of one or more elements in a member List variable?

The question pretty much says it all. If I have a class Class A public class A { ... private List keys; ... } And I want to select all A instances from the DataStore that have atleast one of a List of keys, is there a better way…
Finbarr
  • 31,350
  • 13
  • 63
  • 94
0
votes
1 answer

Is it possible to write Join Condition explicitly?

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?
Nadendla
  • 712
  • 2
  • 7
  • 17
0
votes
1 answer

JDO Query inside transactions: yes or no?

I've always used transactions when querying the database, but recently i wondered why. What are the benefits / drawbacks of using / not using transactions on a "read-only" query? Transactional: public int count() { PersistenceManager…
marcolopes
  • 9,232
  • 14
  • 54
  • 65
0
votes
1 answer

Store java.util.Calendar field into one column

How to store java.util.Calendar field into one column with Datanucleus JDO. By default it is stored into two columns (millisecs, Timezone) with following JDO metadata. field name="startDate" serialized="true" embedded="true" …
Rasika
  • 1
  • 1
0
votes
1 answer

Filter a date property between a begin and end Dates with JDOQL

I want to code a function to get a list of Entry objects whose date field is between a beginPeriod and endPeriod I post below a code snippet which works with a HACK. I have to substract a day from the begin period date. It seems the condition great…
Sergio del Amo
  • 76,835
  • 68
  • 152
  • 179
0
votes
0 answers

How to write JDOQL Query to get data from multiple objects(Relational Objects)

I want to write a JDOQL query(JDOQL Delarative or JDOQL Single String ). Here are my classes public class Customer { String Cid; String Name; String Email; String City; Set
addresses=new HashSet
(); } public class Address…
Nadendla
  • 712
  • 2
  • 7
  • 17
0
votes
0 answers

unable to fetch data from app engine datastore(using JDO Queries)

I am trying to fetch data from app engine with no success. The Async call is a success but there are no data printed. There are no errors either. It worked fine when I was using backend database. Now I am trying to get the same project to work with…
suprasad
  • 1,411
  • 3
  • 18
  • 40
0
votes
1 answer

GAE Query with Collection Parameter

I have verified that the entity I am looking for is in the datastore. I have verified that the list I pass as a method parameter contains this entity. I am trying to find all objects that have their 'userGmail' contained in the list of strings I…
PSchuette
  • 4,463
  • 3
  • 19
  • 21
0
votes
1 answer

What is the benefit of using Email GAE Datastore type instead of String type on POJOs with JDO persistence?

I am migrating an existing web app to GAE, and I am very new on GAE too. I am using App Engine Datastore and JDO as persistence API. Reading about App Engine Datastore supported types, I noted that there is a Email type. So, I open the Email class…
nashuald
  • 805
  • 3
  • 14
  • 31
0
votes
1 answer

Ordering using a declared variable's property

I have a ScInfo class that exists in many different classes. This class also has a list of ScDetails which has a Date member variable called nextExecution. I need to continuously look up eligible objects with their ScDetails object's nextExecution…
Muhammad Gelbana
  • 3,890
  • 3
  • 43
  • 81