JDBC Backing Store Configuration : Adding a JDBC Connection Resource to the Studio Project

Adding a JDBC Connection Resource to the Studio Project
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.
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:
jdbc:oracle:thin:@<host>:<port#>:<db_instancename>
Check the product readme file to ensure you are using the correct database and driver versions.
3.
jdbc:oracle:thin:@localhost:1521:ORCL
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).
6.
7.