Testing in TIBCO Business Studio™ for BusinessWorks™

This section describes how to setup a JDBC Connection to Query and Update tables.

1. From the File Explorer, navigate to the samples directory and select samples > Container > docker > palette > jdbc > Basic and then double-click tibco.bwce.sample.palette.jdbc.Basic.
2. From the Project Explorer expand the tibco.bwce.sample.palette.jdbc.Basic project.
3. Expand the Module Descriptors folder and double-click Module Properties.
   
   The JDBC properties defined for the application are defined in the dialog. Provide a valid username, password, and database URL to connect to your database.
4. Update the values under Module properties and save your project.
5. Expand the Processes directory and double-click JDBC_TEST.bwp.
   
6. Verify your JDBC connection.
   1. Expand the Resource directory.
   2. Double-click JDBCConnection_Oracle.jdbcResource
   3. Select the TIBCO DataDirect Driver and a provide valid access credential.
   4. Click the Test Connection button to verify the connection.
7. Click File > Save to save the project.
8. Click Run > Debug Configurations.
9. At the left hand tree of Debug Configuration wizard, expand BusinessWorks Application and select BWApplication.
10. Click the Applications tab and then click the Deselect All button if you have multiple applications. Select the check box next to tibco.bwce.sample.palette.jdbc.Basic.application.
11. Click Debug.
    This will run the sample in Debug mode.
12. Click the Terminate icon to stop the process.