4.2.1

2 In the workflows hierarchical list, open Library > JDBC > JDBC Examples to navigate to the JDBC delete
all from table example workflow.
3 Right-click the JDBC delete all from table example workflow and select Start workflow.
4 Provide the required information to delete all all entries from a table.
a Type a JDBC connection URL.
b Type a user name to access the database.
c Type a password to access the database.
d Type an SQL delete statement.
An example syntax is:
DELETE FROM "table_name"
5 Click Submit to run the workflow.
Drop a JDBC Table
You can run a workflow from the Orchestrator client to test the dropping of a JDBC table.
Prerequisites
n
The Database plug-in must be enabled in the Orchestrator configuration interface.
n
You must be logged in to the Orchestrator client as a user who can run JDBC workflows.
Procedure
1 Click the Workflows view in the Orchestrator client.
2 In the workflows hierarchical list, open Library > JDBC > JDBC Examples to navigate to the JDBC drop
table example workflow.
3 Right-click the JDBC drop table example workflow and select Start workflow.
4 Provide the required information to drop a table from the database.
a Type a password to access the database.
b Type a JDBC connection URL.
c Type a user name to access the database.
d Type an SQL drop statement.
An example syntax is:
DROP TABLE "table_name"
5 Click Submit to run the workflow.
Run a Complete JDBC Cycle
You can run a workflow from the Orchestrator client to test all JDBC example workflows in one full cycle.
Prerequisites
n
The Database plug-in must be enabled in the Orchestrator configuration interface.
n
You must be logged in to the Orchestrator client as a user who can run JDBC workflows.
Procedure
1 Click the Workflows view in the Orchestrator client.
Chapter 4 Using the Database Plug-In
VMware, Inc. 39