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.Use of all shared resources is documented 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 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. See the section Working with External Library and Custom Function Paths in TIBCO BusinessEvents Developer’s Guide. For correct runtime operation, see Update Classpath and Environment Variables.
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 At the New JDBC Connection Wizard dialog, provide a name for the shared connection and click Finish. You 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: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.
5.
6. 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 Properties > Build Path > Java Libraries area in TIBCO BusinessEvents Studio. See note in introduction).
Copyright © TIBCO Software Inc. All Rights Reserved.