Open topic with navigation

TIBCO ActiveSpaces® 4.8.0

# Adding Rows to a Table by Using the SQL INSERT Statement

Procedure
1. Formulate a SQL INSERT string for adding rows of data to a table.
2. Call the `createStatement()` method of the `Session` object. Pass the SQL INSERT string as an argument.
3. If the SQL INSERT string contains parameter markers, call the `Statement` methods to set the parameter values.
4. Run the INSERT statement by calling the `executeUpdate()` method of the `Statement` object.
5. Check the result of the `executeUpdate()` method to verify that the correct number of rows have been inserted into the table.
6. Set different parameter values and rerun the INSERT statement by repeating steps 3 to 5.
7. Close the `Statement` object.

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