The SQLUpdateReceiver connects to a database and performs batched updates. This Receiver is useful for data replacement of values within a database table to guarantee data security.
The SQLUpdateReceiver requires that the following parameters are defined:
- resourceName - Defines the path and name of the resource that contains the database connection information on a user's local machine.
Receiver Attribute Property Keys
The Receiver defines two property keys that can be modified on any of its associated Domain Attributes:
- columnName - Defines the name of the column as it is in the actual database table.
- variable - Determines if the Attribute will be used as a variable within the update statement. Up to 20 attributes may be assigned to a variable (var1 - var20). The default is 'noVar', meaning the attribute will not be used.
Defining an SQL Update statement
The update statement is defined on the Receiver's 'Data' tab.
Example SQL Update Statment
Attributes whose values will be used in the update statement are assigned a variable from var1 to var20.
JDBC Configuration File
This Receiver uses a configuration file, located on the user's local computer, as a resource to attain the necessary information for connecting to a user's local database via JDBC. The required properties to connect to a database via JDBC are the following:
- driver - the path and file name of the JDBC library for the database to connect to.
- user - the name used to connect as a user to the database.
- password - the password used to connect as the given user to the database.
- url - the JDBC universal resource locator required to connect to the given database.
- batchCount - defines the number of rows of generated data that are batched together before writing to the database.
Example JDBC Configuration File
Below is an example of a JDBC configuration file defined to connect to a MySQL database called, acme:
driver=com.mysql.jdbc.Driver user=root password=openSaysMe url=jdbc:mysql://localhost:3306/acme batchCount=1000