Open topic with navigation

TIBCO BusinessEvents® Enterprise Edition 6.3.1

# 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 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 UserName 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.

Did you find this helpful?

YesNo
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO BusinessEvents® Enterprise Edition

Copyright © 2004-2024. Cloud Software Group, Inc. All Rights Reserved.