Using PreparedStatement objects to query data
This scenario describes a four component job which allows you to link a table
column with a client file. The MySQL table contains a list of all the American States along
with the State ID, while the file contains the customer information including the ID of the
State in which they live. We want to retrieve the name of the State for each client, using an
SQL query. In order to process a large volume of data quickly, we use a PreparedStatement
object which means that the query is executed only once rather than against each row in turn.
Then each row is sent as a parameter. Note that PreparedStatement object can also be used in
avoiding SQL injection.
For this scenario, we use a file and a database for which we have already
stored the connection and properties in the Rerpository metadata. For
further information concerning the creation of metadata in delimited files, the creation of
database connection metadata and the usage of metadata, see