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 as an example a local instance of Oracle 10g Express Edition database. Adapt the instructions as needed for your database. A reference to the fields is provided in the section JDBC Connection, in TIBCO BusinessEvents Developer’s Guide
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 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>
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 BusinessEvents Studio).
6.
7.