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
tibco.bwce.sample.palette.jdbc.Basic
. and double-click - 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 displayed 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 Resources directory.
- Double-click JDBCConnection_Oracle.jdbcResource
- In JDBC Driver section, click Click Here to Set Preferences.
- Click Browse to choose the location of TIBCO DataDirect Driver and then click Apply and the click OK.
- 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.