Add a JDBC Connection resource to your project and configure it to connect to the backing store. Details below use Oracle 10g database as an example. Adapt the instructions as needed for your database. The main section for the JDBC Connection Resource is provided in TIBCO BusinessEvents Developer’s Guide. See the section JDBC Connection in that guide for a reference to the fields.
• The value of the CDD Cluster tab > Backing Store > Connection > Max Size field overrides the value of the JDBC Connection Resource Max Connections setting.
• You must first add your DBMS product’s libraries to the TIBCO BusinessEvents Studio classpath. See Adding External Libraries to the BusinessEvents Studio Classpath in TIBCO BusinessEvents Developer’s Guide.
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. In the JDBC Driver field, select the driver for your database, for example, oracle.jdbc.OracleDriver. The driver appears in the JDBC Driver field and a Database URL format appears according to the driver you selected. For the Oracle thin driver, the format is:Check the product readme file to ensure you are using the correct database and driver versions.where 1521 is the default port, and ORCL is the default instance name for Oracle Database 10g.
4.
5. Click Apply, then click Test Connection. If the database is running and the details are correct, you see a success message. (True only if you add the JDBC driver to the project libraries in TIBCO BusinessEvents Studio).
Copyright © TIBCO Software Inc. All Rights Reserved.