This page last changed on Oct 16, 2008 by alui.

Bamboo provides two ways to connect to an Oracle database — via JDBC or via a datasource. JDBC is generally simpler and is the recommended method.

Drivers for Oracle connectivity

We recommend using the following configuration to run Bamboo with Oracle:

  • Regardless of what version of the Oracle database you are using, you should use the Oracle 10g JDBC drivers. (Note: Oracle 10g JDBC drivers will not work with Oracle 8.1.6. For further reference, see  Oracle FAQ)
  • We highly recommend using the thin drivers.


Connecting via JBDC

To connect Bamboo to a Oracle database, via JDBC,

  1. Put the Oracle JDBC driver jar file into your application server's classpath:
    • For the Bamboo Standalone distribution, copy the jar file into the webapp/WEB-INF/lib directory.
    • For the Bamboo EAR-WAR distribution, the location will depend on which application server you are using.
  2. At Step 2 of the Bamboo Setup Wizard, choose 'External Database' and select 'Oracle' from the list.
  3. The 'Select Database Connection' screen will appear. Select 'Direct JDBC connection'.
  4. The 'Setup JDBC Connection' screen will appear as shown in the screenshot below.
    • 'Driver Class Name' — Type the following: oracle.jdbc.driver.OracleDriver
    • 'Database URL' — Type the URL where Bamboo will access your database. For syntax, please see the Oracle documentation, e.g. jdbc:oracle:thin:@localhost:1521:SID
    • 'Username' — Type the username that Bamboo will use to access your database.
    • 'Password' — Type the password that Bamboo will use to access your database.
  5. Select the 'Overwrite existing data' checkbox if you wish Bamboo to overwrite any tables that already exist in the database.
  6. Click 'Continue' to finish specifying your connection settings.

Screenshot 1: 'Setup JDBC Connection (Oracle)'




Connecting via a datasource

To connect Bamboo to a Oracle database, via a datasource,

  1. Configure a datasource in your application server (consult your application server documentation for details). For the syntax of the JDBC URL to use, please see the Oracle documentation.
  2. At Step 2 of the Bamboo Setup Wizard, choose 'External Database' and select 'Oracle' from the list.
  3. The 'Select Database Connection' screen will appear. Select 'Connect via a datasource (configured in the application server)'.
  4. The 'Setup Datasource Connection' screen will appear as shown in the screenshot below. In the 'JNDI name' field, type the JNDI name of your datasource, as configured in your application server.
    If java:comp/env/jdbc/DataSourceName doesn't work, try jdbc/DataSourceName (and vice versa).
  5. Select the 'Overwrite existing data' checkbox if you wish Bamboo to overwrite any tables that already exist in the database.
  6. Click 'Continue' to finish specifying your connection settings.

Screenshot 2: 'Setup Datasource Connection'


Document generated by Confluence on Mar 09, 2009 17:06