Open topic with navigation

TIBCO ActiveSpaces® - Enterprise Edition 5.0.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 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 value is `5` seconds).

If the insert values list does not match the 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

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO ActiveSpaces® - Enterprise Edition

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