Versions Compared

Old Version 38

changes.mady.by.user Pavel Tupitsyn

Saved on

compared with

New Version 39

changes.mady.by.user Pavel Tupitsyn

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Request
CacheConfigurationCache config (see format above)

 Empty response.

 


 

OP_QUERY_SQL = 36 

Performs SQL query. 

...

OP_QUERY_SQL_CURSOR_GET_PAGE = 37 

Retrieves next SQL query cursor page by cursor id from OP_QUERY_SQL. 

Request
longCursor id

 

 

Response
longCursor id
intRow count
(Object + Object) * countCache entries, key + value
bool

Indicates whether more results are available to be fetched with OP_QUERY_SQL_CURSOR_GET_PAGE.

When true, query cursor is closed automatically.

...

 

OP_QUERY_SQL_FIELDS = 38OP_QUERY_SQL_FIELDS_CURSOR_GET_PAGE = 39

Performs SQL fields query

Request
intCache ID: Java-style hash code of the cache name
stringDefault schema for the query, can be null
intQuery cursor page size
intMax rows
stringSQL
intArgument count
BinaryObject * countArguments
byteStatement type, ANY = 0, SELECT = 1, UPDATE = 2
boolDistributed joins
boolLocal
boolReplicated Only
boolEnforce Join Order
boolColocated
boolLazy
longTimeout (milliseconds)
boolInclude field names
Response
longCursor id. Can be closed with OP_RESOURCE_CLOSE.
intField (column) count

Optionally, when IncludeFieldNames is true in request

string * count

Column names
intFirst page row count
BinaryObject * columnCountColumn (field) values
boolIndicates whether more results are available to be retrieved with OP_QUERY_SQL_FIELDS_CURSOR_GET_PAGE



OP_QUERY_SQL_FIELDS_CURSOR_GET_PAGE = 39

Request
longCursor id
Response
intRow count
BinaryObject * columnCountColumn values
boolIndicates whether more results are available to be retrieved with OP_QUERY_SQL_FIELDS_CURSOR_GET_PAGE



OP_GET_BINARY_TYPE_NAME = 2
OP_GET_BINARY_TYPE = 3
OP_REGISTER_BINARY_TYPE_NAME = 5
OP_PUT_BINARY_TYPE = 6
OP_QUERY_SCAN = 7
OP_QUERY_SCAN_CURSOR_GET_PAGE = 8

...