OQL stands for "Object Query Language". It is defined by the Object Data Management Group (ODMG).
Questions tagged [oql]
87 questions
0
votes
0 answers
javax.el.PropertyNotFoundException: The class 'java.lang.String' does not have the property 'hotelName'
This is table in database
TblUser entity:
@Id
@Basic(optional = false)
@Column(name = "hotelID", nullable = false)
private Integer hotelID;
@Basic(optional = false)
@Column(name = "hotelName", nullable = false, length = 50)
private String…
Trung Thành
- 11
- 1
- 3
0
votes
1 answer
Java JPA OQL recursive filter
Is there any way in OQL (Object Query Language) to select an object, by filtering out all objects matching a certain property?
To access Category objects recursively I just retrieve the root-Category. Later I access its children-property through…
Socrates
- 8,724
- 25
- 66
- 113
0
votes
1 answer
How can you determine whether a Spring Data Gemfire query is using a Gemfire index?
I am trying to determine whether all of my Spring Data Gemfire queries are using the indexes defined on the Gemfire server.
With OQL, I know I can add "" and in the gemfire logs it will show whether an index is being used:
@Query("…
GeekChick
- 118
- 1
- 2
- 10
0
votes
1 answer
Can GemFire OQL query be done on all the child-regions of a parent-region, in a single query
I need to make a hierarchy of regions like following, as usually I query by country and type. I put all data in country level regions. Sometimes I query across countries in NAM_Type1 and sometimes Global.
Global_Type1
-> NAM_Type1
--> USA
--> …
Ashish Awasthi
- 1,302
- 11
- 23
0
votes
1 answer
Invoking a Method on an Object in an OQL Query on a Gemfire 6.5 Region
I am using the below Java 6 code to query a Gemfire 6.5 cache.
My problem is I am trying to filter my results with a WHERE using a method call from the objects in the regionbut for some reason it is complaining about java.lang.String not containing…
Waldomagician
- 1
- 3
0
votes
1 answer
how to write a OQL query comparing with number
this is the OQL query i have written
select * from myClass.Session ses where ses.creationTime <= 1391171576144
I get following error when i execute the query
java.lang.NumberFormatException: For input string: "1391171576144"
at…
kumar
- 8,207
- 20
- 85
- 176
0
votes
1 answer
OQL: Tomcat threads with retained heap
I'm having trouble with joining two OQL statements. Since the sub select syntax in OQL is a little quirky could someone help me out?
Select 1
SELECT thread.name.toString(), thread.@retainedHeapSize
FROM java.lang.Thread thread
Will return a…
Philip Gloyne
- 49
- 1
- 6
0
votes
1 answer
in OQL, or JQL, how do you do this type of outerjoin
Say we have two completely unrelated entities EntityX and EntityY both with column age. How do I in OQL do a join like so
select x,y from EntityX as x full outer join EntityY as y on x.age = y.age
Is this not possible?
thanks,
Dean
Dean Hiller
- 19,235
- 25
- 129
- 212
0
votes
1 answer
sort and limit castor query
I am attempting to return a single object via castor query that has the earliest date.
This is the sort of thing I have been trying:
SELECT p FROM model.objects.Product p LIMIT $1 WHERE p.status=$2 ORDER BY p.statusDate;
This results in:…
cemlo
- 135
- 1
- 11
0
votes
1 answer
Object Query Language referrers
I'm trying to analyze a heap dump to determine if my hibernate cache settings are the cause.
Many instances of the object in question are referred to by "org.hibernate.internal.util.collections.IdentityMap". How can I construct an OQL query to…
tdimmig
- 680
- 9
- 24
-1
votes
3 answers
Fetch Last 24 hour data using Gemfire OQL
Can anyone help me with fecthing exactly last 24 hr data directly using gemfire OQL or some custom java code.
i tried using LIKE query and fetch two days of data but i am not sure how two pass dynamic data in gemfire query since everything is…
ayush srivastava
- 11
- 1
-1
votes
1 answer
OQL and SQL queries. Select all department numbers whose employees have the same salary
So, I have two tables:
EMP {EMP_NO, EMP_SALARY, EMP_DEPT_NO}
DEPT {DEPT_NO, DEPT_MNG}
EMP_NO, DEPT_NO - primary keys, EMP_DEPT_NO - external key to DEPT, DEPT_MNG - external key to EMP.
I need to find all departments where every employee has the…
Oliver Wayne
- 39
- 8