Summary: Supported and non-supported features by GigaSpaces JDBC.

Supported Features

GigaSpaces JDBC supports the following:

  • All Basic SQL statements: SELECT, INSERT, DELETE, UPDATE, CREATE TABLE, DROP TABLE.
  • AND/OR operators to join two or more conditions in a WHERE clause.
  • Aggregate functions: COUNT, MAX, MIN, SUM, AVG.
  • All basic logical operations to create conditions: =, <>, <,>, >=, <=, [NOT] like, is [NOT] null, IN.
  • Multiple tables select – the join feature is now available, allowing selection from two tables, as well as the possibility of interrelated conditions.
  • ORDER BY for multiple columns.
  • Table aliases – tables are allowed to use aliases throughout the query.
  • sysdate - a keyword suggesting current time and date.
  • rownum - a keyword to use in WHERE clauses, setting the number of rows to select.
  • Select for update – allowing the locking of rows in order to update them later.
  • Remote and embedded query processes configuration – allows fast access to the space using embedded mode.
  • Optimistic locking.
  • A statement caching mechanism is provided to speed up statement parsing.
  • Meta Data API.
  • Connection pool.
  • All JDBC basic types including Blob and Clob.
  • GROUP BY for multiple columns.
  • DISTINCT

Non-Supported Features

GigaSpaces JDBC does not support the following:

  • The SQL statements: HAVING, VIEW, TRIGGERS, EXISTS, BETWEEN, NOT, CREATE USER, GRANT, REVOKE, SET PASSWORD, CONNECT USER, ON.
  • CREATE Database.
  • CREATE Index, DROP Index.
  • Constraints: NOT NULL, IDENTITY, UNIQUE, PRIMARY KEY, Foreign Key/REFERENCES, NO ACTION, CASCADE, SET NULL, SET DEFAULT, CHECK.
  • Batch Processing.
  • Set operations: Union, Minus, Union All.
  • Aggregate Functions: STDEV, STDEVP, VAR, VARP, FIRST, LAST.
  • The UPDATE statement does not allow the use of an expression or a null value in the SET clause.
  • Using a constant instead of the column name.
  • The INSERT statement does not allow the use of an expression in the VALUES clause.
  • "." used to indicate a double data type.
  • Joining more than 2 tables.
  • Using mathematical expressions in the WHERE clause.
  • In the join selection, a column is not supported without its table name prefix.
  • Columns alias.
  • Using a sub-query in the FROM clause.
  • LEFT [OUTER] JOIN
  • RIGHT [OUTER] JOIN
  • [INNER] JOIN
When having SELECT count (*) FROM myClass JDBC query – myClass sub classes object count are not taken into consideration when processing the query result. The SELECT count (*) FROM myClass WHERE X=Y and SELECT (*) from myClass do take into consideration myClass sub classes objects when processing the result. Future versions will resolve this inconsistency.

As a workaround, construct a JDBC query that includes a relevant WHERE part.

GigaSpaces.com - Legal Notice - 3rd Party Licenses - Site Map - API Docs - Forum - Downloads - Blog - White Papers - Contact Tech Writing - Gen. by Atlassian Confluence