Adding a JDBC Connection Resource (Now or Later)

Add a JDBC Connection resource to your project and configure it to connect to the backing store. You can do this before or after you configure the database itself. These settings are ignored by the setup utility during the database setup process.

Details below use Oracle 10g database as an example. Adapt the instructions as needed for your database. .

Note:
  • The value of the CDD Cluster tab > Backing Store > Connection > Max Size field overrides the value of the JDBC Connection Resource Maximum Connections setting.
  • For design time features, such as the Test Connection feature, to work correctly, you must add your DBMS product’s libraries to the TIBCO BusinessEvents Studio classpath.
  • For correct runtime operation, see TIBCO BusinessEvents Administration.

Procedure

  1. In TIBCO BusinessEvents Studio, open your project, and open the folder where you keep shared resources and select New > Other > TIBCO Shared Resources > JDBC Connection.
  2. At the New JDBC Connection Wizard dialog, provide a name for the shared connection and click Finish.
    You will see the JDBC Connection resource editor.
  3. In the JDBC Driver field, select the driver for your database from the selection box on the right, for example, oracle.jdbc.OracleDriver.
    The driver name appears in the box, and a Database URL format appears to the left of the selection box, according to the driver you selected. For the Oracle thin driver, the format is:

    jdbc:oracle:thin:@<host>:<port#>:<db_instancename>

    Check the product readme file to ensure you are using the correct database and driver versions.

  4. In the Database URL field, configure the provided format. For example:

    jdbc:oracle:thin:@localhost:1521:ORCL

    where 1521 is the default port, and ORCL is the default instance name for Oracle Database 10g.

  5. In the User Name and Password fields, enter the username and password of the database user (see Run the Initialize Database Script as the DBA or System User).
  6. Save the resource.
    Tip: After you have configured the database and it is running, you can test the connection. Click the Test Connection button. If the database is running and the details are correct, you see a success message.

    Before you can use this feature, you must first add the JDBC driver to the project Properties > Build Path > Java Libraries area in TIBCO BusinessEvents Studio. See note in introduction).