JDBC Compliance

The ActiveSpaces JDBC driver is not a fully compliant implementation of JDBC.

SQL command support is provided by ActiveSpaces and the driver does not implement any additional support. The following SQL commands are supported:
  • CREATE TABLE
  • CREATE INDEX
  • DROP TABLE
  • DROP INDEX
  • SELECT
The following are the known limitations of the driver:
  • Entry Level SQL92 is not fully supported.
  • Transactions are not supported.
  • Batch updates are not supported.
  • javax.sql.DataSource is not implemented.
  • Escape syntax is not supported.
The following JDBC driver features are not supported:
  • Connection Pooling
  • Schemas
  • Foreign Keys
  • Procedures
  • Functions
  • Callable Statements
  • Savepoints
  • Parameter Metadata
  • Named Parameters
  • Transactions
  • Updatable ResultSets
  • Multiple ResultSets From a Single Execute Call
  • Joins
  • Subqueries