Open topic with navigation

TIBCO ActiveSpaces® - Enterprise Edition 5.0.0

# Parameters

Parameters serve as placeholders for values in a SQL command. Parameters are used to separate the data of a SQL command from the command itself. This can be useful when the same command can be run multiple times by just varying the data of the command and increasing the performance of the data grid. Parameters can be used to prevent SQL injection attacks in queries.

Parameters in a SQL command are specified by using `'?`' (question mark). For SELECT and DELETE statements, parameters are supported for the values of comparisons in `WHERE` clauses. For the INSERT statements, parameters are supported for column values. For UPDATE statements, parameters are supported for the values in SET clauses and for the values in WHERE clauses.

The Statement interface provides methods for setting the values of any parameters used in a SQL command. Separate methods for setting parameter values are provided for each data type supported by ActiveSpaces. The setNull() method is provided to specify that a parameter's value must be empty (SQL NULL). All parameter values must be specified before running the statement or an error is returned. Parameters are numbered starting with 1.

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.