Testing in TIBCO Business Studio for BusinessWorks
This section describes how to setup a JDBC Connection to Query and Update tables.
Before you begin
- Access to a database.
- Procedure
- From the File Explorer, navigate to the samples directory and select and then double-click tibco.bwce.sample.palette.jdbc.Basic.
- From the
Project Explorer expand the
tibco.bwce.sample.palette.jdbc.Basic
project. - 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.
- Update the values under Module properties and save your project.
- Expand the Processes directory and double-click
JDBC_TEST.bwp.
- Verify your JDBC connection.
- Expand the Resource directory.
- Double-click JDBCConnection_Oracle.jdbcResource
- Select the TIBCO DataDirect Driver and a provide valid access credential.
- Click the Test Connection button to verify the connection.
- Click to save the project.
- Click Configurations.
- At the left hand tree of Debug Configuration wizard, expand BusinessWorks Application and select BWApplication.
- Click the Applications tab and then click the Deselect All button if you have multiple applications. Select the checkbox next to tibco.bwce.sample.palette.jdbc.Basic.application.
- Click
Debug.
This runs the sample in Debug mode.
- Click the
Terminate
icon to stop the process.