Open topic with navigation

TIBCO ActiveSpaces® 4.8.0

# Errors for INSERT Statement

By default, when an error occurs for an INSERT statement, changes made by the statement are undone. If the INSERT statement is called from within an existing transaction, the entire transaction is rolled back. ActiveSpaces does not impose a limit to the number of rows in a multi-row insertion. However, the number of rows must be processed within the time specified by the `client request timeout` property of the data grid (The default is `5` seconds).

If the insert values list does not match column list, a SQL command error is returned. Errors due to a conflict with the following constraints:

Constraints | Error Description
--- | ---
PRIMARY KEY | Values are not provided for all primary key columns

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