OQL stands for "Object Query Language". It is defined by the Object Data Management Group (ODMG).
Questions tagged [oql]
87 questions
2
votes
1 answer
JVisualVM HeapDump OQL rendering array inside an Object
I am trying to write a query such as this:
select {r: referrers(f), count:count(referrers(f))}
from com.a.b.myClass f
However, the output doesn't show the actual objects:
{
count = 3.0,
r = [object Object]
}
Removing the Javascript Object notation…
mvd
- 2,596
- 2
- 33
- 47
2
votes
0 answers
Is there a Linq to OQL provider?
I want to convert Linq query to OQL.
Is there a Linq to OQL provider?
user1393608
- 1,299
- 3
- 16
- 29
2
votes
2 answers
How to use "AND operator (&&)" in OQL in MAT Eclipse
I am working on performance tuning of a java rmi application and
using OQL to execute below query :
select tpoint.host.value.toString() from sun.rmi.transport.tcp.TCPEndpoint tpoint
where (tpoint.host!=null && tpoint.csf!=null)
Above query…
mogli
- 1,549
- 4
- 29
- 57
1
vote
2 answers
Filter on current date within Castor OQL
I'm running the java cocoon 2 and castor oql. I'm trying to filter my oql query by today's date, but I can't seem to figure out (or find in google) the syntax of the date. The database is mySql, but the oql is mapped by the java classes... so…
cocooner
1
vote
1 answer
Sorting OQL result set by object parameter in VisualVm
Have opened a Java heap dump in VisualVm and I'm trying to formulate an OQL query to return all objects of a specific class (se.greger.sven.olof.node.Task) ordered by one of the objects parameters (refid). Have tried variations of the two queries…
joaerl
- 1,012
- 1
- 10
- 21
1
vote
1 answer
Can I use OQL with an Oracle Text Index?
I have a database with an Oracle Text index and I would like to use an access layer with the Object Query Language (OQL).
I would like to use statements as
SELECT id FROM table WHERE CONTAINS(column, 'search term') > 0;
in my OQL access layer.
Is…
guerda
- 23,388
- 27
- 97
- 146
1
vote
0 answers
How to make $lookup in MongoDB work with _id?
Hi I have problem with not working lookup when I use _id from produkt. I store produkt id's in kategoria id_produktow array. I want to show kategoria nazwa and id_produktow as produkt nazwa.
Kategoria:
[
{
"_id": "5fbbf3c9f3a7db3368a78f3c",
…
Vainnq
- 11
- 1
1
vote
1 answer
Eclipse MAT OQL list of classes in a certain package
using Eclipse MAT 1.9.1 OQL
I want to list all the classes in the heap dump in a certain package.
I am trying the query:
SELECT c.getName() as name, c.getName().indexOf("com.mycompany") as idx FROM java.lang.Class c WHERE idx > 0…
David Abragimov
- 524
- 2
- 6
- 24
1
vote
2 answers
Using Jhat heap built-in object
Can anybody show an example of how to use heap.heapForEachClass in a select statement?
It would be great if you could provide some links with different examples of queries (other than those in the oqlhelp page of course :) )
Eugen
- 2,292
- 3
- 29
- 43
1
vote
1 answer
Trouble with OQL 'unique' function of 'jhat' in Java 1.6.0_24
this is my first posted question. I have a fairly complicated OQL query which lists static fields of classes loaded in our packages. One problem I'm seeing with running the query against 'jhat' of Java 1.6.0_24 is that the 'unique' function doesn't…
karmakaze
- 34,689
- 1
- 30
- 32
1
vote
1 answer
OQL in VisualVM - recursively print static data from a package
I'd like to build an OQL query with which to recursively print out all the static data of a JVM heap dump from classes within a specific package. I'm aware that there are potentially lots of issues in going recursively through memory references, but…
clausavram
- 546
- 8
- 14
1
vote
1 answer
JPA Query return List of Entites
I have a class Event
@Entity
public class Event {
@Id // PrimaryKey
@GeneratedValue(strategy = GenerationType.AUTO)
private int event_id;
private String bezeichnung;
private Date startzeitpunkt;
private Date endzeitpunkt;
private boolean…
Max Muster
- 53
- 6
1
vote
1 answer
Formatting the result of oql in VisualVM
I have the following oql query running on visualvm against a heap dump and would like the creationTime field formatted as a date time field (its stored as Long).
select { id: s.id.toString(), createdAt: new Date(s.creationTime) }
from…
calvinkrishy
- 3,798
- 8
- 30
- 45
1
vote
1 answer
GemFire : OQL problems
I want to perform this query in GemFire
select a from /regionA a,/regionB b where sqrt(sqr(a.x-b.x)+sqr(a.y-b.y)) < a.d
but some operators are not supported such as +, - ...
is there any solution to perform such queries ?
I.Scale
- 35
- 5
1
vote
1 answer
I am trying to execute jql query but i am getting error
I am trying to execute jql query but i am getting error as follow
i am using visual vm where i dump a file of java application.
query syntax error: identifier should follow class name
com.sun.tools.hat.internal.oql.OQLException: query syntax error:…
Vikas Suryawanshi
- 522
- 1
- 5
- 12