This documentation relates to an earlier version of Bamboo.
View

Unknown macro: {spacejump}

or visit the current documentation home.

These instructions will help you connect Bamboo to an Oracle 10g or 11g database. Oracle 9i is no longer a supported database for use with Bamboo and the 11.2.x drivers from Oracle do not support 9i.

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.

(info) Please note, the JDBC driver for Oracle 10g/11g (Oracle 11.2.0.1.0) is bundled with Bamboo. You do not have to download and install the driver.

Connecting via JBDC

To connect Bamboo to a Oracle database, via JDBC,

  1. Run the Setup Wizard and choose the 'Custom Installation' method.
  2. At the 'Choose a Database Configuration' step, choose 'External Database' and select 'Oracle 10g/11g' 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, e.g. jdbc:oracle:thin:@localhost:1521:SID. For syntax, please see the Oracle documentation.
    • '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. Run the Setup Wizard and choose the 'Custom Installation' method.
  3. At the 'Choose a Database Configuration' step, choose 'External Database' and select 'Oracle 10g/11g' from the list.
  4. The 'Select Database Connection' screen will appear. Select 'Connect via a datasource (configured in the application server)'.
  5. 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.
    (warning) If java:comp/env/jdbc/DataSourceName doesn't work, try jdbc/DataSourceName (and vice versa).
  6. Select the 'Overwrite existing data' checkbox if you wish Bamboo to overwrite any tables that already exist in the database.
  7. Click 'Continue' to finish specifying your connection settings.

Screenshot 2: 'Setup Datasource Connection'

  • ラベルなし



Log a request with our support team.



Raise an issue for our developers.



See answers from the community.



Tweet, blog and update our documentation.

Except where otherwise noted, content in this space is licensed under a Creative Commons Attribution 2.5 Australia License.