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 10g Express Edition database. Adapt the instructions as needed for your database product.
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).
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.
Optionally, enter a description such as
JDBC Connection for the backing store tutorial.
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:
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 10G Express. (The default instance name for Oracle Database 10g is
ORCL.)
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
Run the Initialize Database Script as the DBA or System User).