Adding a JDBC Connection Shared Resource

In this task, you add a JDBC Connection shared resource to your project and configure it to connect to the backing store database. You can do this before creating the database if the necessary details are known.)

The following details assume you will connect to a local instance of Oracle Database 12c Enterprise Edition. Adapt the instructions as needed for your database product.

Note: You will specify the location of this JDBC Connection resource in the CDD, in Renaming and Configuring the CDD and Building the EAR .
    Procedure
  1. In TIBCO BusinessEvents Studio, open your project (if it is not already open), right-click the SharedResources folder and select New > Other > TIBCO Shared Resources > JDBC Connection (or select the folder and press Ctrl-N as in earlier tutorials).
  2. At the New JDBC Connection Wizard dialog, name the connection ForBackingStore, and click Finish.

    You see the JDBC Connection resource editor.

    Tip: The globe icons to the right of the settings in this resource type indicate that you can use global variables in the field value. To learn more about this topic, see Working with Global Variables in TIBCO BusinessEvents Developer’s Guide.
  3. Optionally, enter a description such as JDBC Connection for the backing store tutorial.
  4. In the JDBC Driver field, select the appropriate driver for your database. The tutorial example uses oracle.jdbc.OracleDriver. The database URL format appears in the Database URL field just below: 
    jdbc:oracle:thin:@<host>:<port#>:<db_instancename>
  5. In the Database URL field, configure the URL with your actual values. The tutorial uses these values: 
    jdbc:oracle:thin:@localhost:1521:XE

    Where 1521 is the default port, and XE is the default instance name for Oracle Database 12c Enterprise Edition. (The default instance name for Oracle Database 12c is ORCL.)

  6. In the User Name and Password fields, type the name BE_USER and password BE_USER. (The password field does not display the text.). These are the username and password of the database user you will create (in Running the Initialize Database Script as the DBA or System User).
  7. Save and close the resource.