Open topic with navigation

TIBCO ActiveSpaces® 4.8.0

# 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
- INSERT
- INSERT OR REPLACE
- DELETE

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.

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

Copyright © 2009-2022. Cloud Software Group, Inc. All Rights Reserved.