Add a JDBC Connection resource to your project and configure it to connect to the backing store. Details below explain how to connect to a local instance of Oracle 10g Express Edition database. Adapt the instructions as needed for your database.
1. In TIBCO Designer, open your project, and open the folder where you keep shared resources. Add a JDBC Connection resource (from the JDBC palette).
2. In the drop-down list to the right of the JDBC Driver field, select oracle.jdbc.driver.OracleDriver (thin). The driver appears in the JDBC Driver field and the Database URL format appears as:where 1521 is the default port, and XE is the default instance name for Oracle Database 10g Express Edition. (The default instance name for Oracle Database 10g is ORCL).
4. In the User Name and Password fields, enter the username and password of the database user you created (see Task D, Run the Initialize Database Script to Create the Oracle User). The example username and password used in the documentation are both be_user.
5. Click Apply, then click Test Connection. If the details are correct, you see a success message. Save the project.
6. Add the resource to the shared archive as follows. Select the Shared Archive resource (SAR) within the EAR resource. Select the Resources tab, browse to the location of the JDBC Connection resource you just configured, and select it.
7. Click Apply then click Save to save the project. When you build the EAR file, the JDBC Connection resource is packaged into the shared archive (SAR) file.
Copyright © TIBCO Software Inc. All Rights Reserved.