You might need to configure process applications that run SQL statements for the specific database infrastructure. These SQL statements can come from information service activities or they can be statements that you run during process installation or instance startup.
The data source required to run an SQL snippet activity is defined in a BPEL variable of type tDataSource. The database schema and table names that are required by an SQL snippet activity are defined in BPEL variables of type tSetReference. You can configure the initial values of both of these variables.
You can use the wsadmin tool to specify the data sources.
In the Updating data sources task, you can change data source values for initial variable values and statements that are used during installation of the process or when the process starts. In the Updating set references task, you can configure the settings related to the database schema and the table names.
Task [24]: Updating data sources //Change data source values for initial variable values at process start Process name: Test // Name of the process template Process start or installation time: Process start // Indicates whether the specified value is evaluated //at process startup or process installation Statement or variable: Variable // Indicates that a data source variable is to be changed Data source name: MyDataSource // Name of the variable JNDI name:[jdbc/sample]:jdbc/newName // Sets the JNDI name to jdbc/newName
Task [25]: Updating set references // Change set reference values that are used as initial values for BPEL variables Process name: Test // Name of the process template Variable: SetRef // The BPEL variable name JNDI name:[jdbc/sample]:jdbc/newName // Sets the JNDI name of the data source of the set reference to jdbc/newName Schema name: [IISAMPLE] // The name of the database schema Schema prefix: []: // The schema name prefix. // This setting applies only if the schema name is generated. Table name: [SETREFTAB]: NEWTABLE // Sets the name of the database table to NEWTABLE Table prefix: []: // The table name prefix. // This setting applies only if the prefix name is generated.
(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)