Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 30 JDBC Backing Store Setup : Add a JDBC Connection Resource (Now or Later)

Add 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.
See the section JDBC Connection for a reference to the fields.
Task C Add a JDBC Connection Resource (Now or Later)
1.
2.
 
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.
jdbc:oracle:thin:@localhost:1521:ORCL
where 1521 is the default port, and ORCL is the default instance name for Oracle Database 10g.
5.
6.
Test Connection. 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.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved