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. |
|