Stack Overflow
Stack Overflow

Questions tagged [oql]

OQL stands for "Object Query Language". It is defined by the Object Data Management Group (ODMG).

https://en.wikipedia.org/wiki/Object_Query_Language

87 questions
0
votes
0 answers

GemFire Select * Query with index returns inconsistent results

I have a GemFire Query, something like "SELECT * FROM /someregion WHERE fieldX IN SET('123')". This query returns inconsistent results. For example, it will return the same record many times, etc. If I change the query to "SELECT key FROM…
RO RO
  • 3
  • 1
0
votes
1 answer

Using HINT and TRACE with GemfireTemplate.query method

I am trying to add a Trace to an OQL Query as mentioned in the docs, using GemfireTemplate query method. But the OQL validation fails with QueryInvalidException "unexpected tokern: <". Any ideas?
RO RO
  • 3
  • 1
0
votes
1 answer

Show String contents in the OQL result when using MAT

When I execute the following OQL in Eclipse Memory Analyzer SELECT key FROM com.google.common.cache.LocalCache$StrongAccessWriteEntry I got the following result key --------------------------------- java.lang.String…
Searene
  • 25,920
  • 39
  • 129
  • 186
0
votes
1 answer

Can Eclipse MAT's ParseHeapDump utility run OQL?

Typically I use Eclipse MAT GUI to run OQL on a heap dump to extract data. I was just wondering if there is any way to run any OQL with ParseHeapDump utility? Basically, I wanted to go beyond those four standard reports and run my own OQLs to find…
suv3ndu
  • 221
  • 5
  • 12
0
votes
0 answers

In Java, while debugging, how can I search all objects in heap for text

I am trying to find a hidden piece of data inside some large maps in a Java program. It would be very easy if I could (in a way) "sed" or "grep" through all the objects in the heap and determine where a specific line of ASCII text exists. Can this…
E.S.
  • 2,733
  • 6
  • 36
  • 71
0
votes
1 answer

How to Access OQL Query on a Gemfire 9.6 Region in java

I am using Gemfire pivotal for the first time and I need someone who can help me with below question. The Gemfire Pivotal 9.6 is installed on Unix server and I am able to connect to Unix with no issue. I am inside unix now, but I can't access…
S Akin Sabak
  • 57
  • 1
  • 2
  • 10
0
votes
1 answer

How to use NVL to get data from GemFire when query result is null

I am using Spring Data GemFire in a project and I am using a Repository to fetch query results from a cache as mentioned here: https://docs.spring.io/spring-gemfire/docs/1.3.3.RELEASE/reference/html/gemfire-repositories.html Below is my Repository…
KCK
  • 2,015
  • 2
  • 17
  • 35
0
votes
1 answer

How to access gemfire cache from jdbc driver

I have a gemfire cache v8.2.1 from which I want to access data using a third party tool which can only access data using jdbc driver only. Does anyone know how can I connect to gemfire cache for accessing data using jdbc? I don't require to write to…
KCK
  • 2,015
  • 2
  • 17
  • 35
0
votes
1 answer

VisualVM OQL: find object that has (indirect) reachables/references to two object IDs?

My question is rather short and compact: If I find two objects with VisualVM, what kind of OQL query can I perform to find all objects that have (indirect) reachables or references to these two objects? Update for JB: After editing your code, I came…
Tom
  • 8,536
  • 31
  • 133
  • 232
0
votes
1 answer

VisualVM OQL filter not working as expected

I am wondering why the following OQL query is not simply returning the maximum amount of returns: filter(heap.objects(), function(it) { return true; }); In fact, I only get 1 random object returned. Does this make any sense? My heap has 31.000…
Tom
  • 8,536
  • 31
  • 133
  • 232
0
votes
1 answer

OQL to Query a List in GemFire

I am trying to form a OQL in GemFire which would query a particular attribute within the list. I have huge number of Employee objects in GemFire with employeeId as the key. On querying by ID we receive the following object. We convert the object…
Arijit Dasgupta
  • 325
  • 3
  • 14
0
votes
1 answer

OQL query to find Spring ApplicationContext holding specific bean

I use Spring Boot and have problem with beans instantiating (they created twice). How can I find reference to ApplicationContext from bean reference in OQL query? In other word find out holding Context for given bean. PS Basic troubleshooting query…
gavenkoa
  • 45,285
  • 19
  • 251
  • 303
0
votes
1 answer

IN vs OR in OQL pivotal gemfire

When dealing with content spanned across multiple tables (regions in terms of gemfire) on different nodes in a cluster, which operator provides faster results. Let's say, for now my search OQL query looks like following: select * from…
ms_27
  • 1,484
  • 15
  • 22
0
votes
0 answers

Accessing object fields with VisualVM not working

I'm using VisualVM 1.3.8 to analyze a heap dump and the following query shows up with 0 results: select s from java.lang.String s where s.count >= 0 Doing select s from java.lang.String shows several strings of size >= 0 so I don't see why this…
user3927950
  • 23
  • 5
0
votes
1 answer

Could not write data in gemfire

I am trying to write to gemfire server in region 'trade'. My class is like : public class TradeDetails{ String exchange; String Product; String Account; String Quantity; //getter and setter } I have deployed the jar in the gfsh console. The query I…
Pratik Kumar
  • 81
  • 10
1 2 3 4
5
6