Oracle
This page describes how to connect Bamboo to an Oracle database.
Bamboo provides two ways to connect to an Oracle database — using JDBC or using a datasource. JDBC is generally simpler and is the recommended method.
See Supported platforms for other information about the versions of Oracle supported by Bamboo.
On this page:
Important
- For JDBC or JNDI connections, please ensure that the user connecting to the database will have total permissions over it. This includes DBMS_LOB package and other resources available.
Related pages:
Configuring Oracle
- Ensure that you have a database instance available for Bamboo (either create a new one or use an existing one).
Within that database instance, create a user which Bamboo will connect as (e.g.
bamboo-user
). Remember this database user name, as it will be used to configure Bamboo's connection to this database.
When you create a user in Oracle, Oracle will create a 'schema' automatically.create user bamboo-user identified by password;
Ensure that the user has the following permissions:
grant connect, resource, create table to bamboo-user;
Connecting using JDBC
- Run the Setup Wizard and choose the Custom Installation method.
- At the 'Choose a Database Configuration' step, choose External Database > Oracle.
Select Direct JDBC connection and complete the form:
Setting Description Driver Class Name Type: 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. - Select Overwrite existing data if you wish Bamboo to overwrite any tables that already exist in the database.
- Click Continue.
Screenshot: Setup JDBC Connection (Oracle)
Connecting using a datasource
- 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.
- Run the Setup Wizard and choose the Custom Installation method.
- At the 'Choose a Database Configuration' step, choose External Database > Oracle.
- Select Connect using a datasource (configured in the application server).
- In the JNDI name field, type the JNDI name of your datasource, as configured in your application server.
Ifjava:comp/env/jdbc/DataSourceName
doesn't work, tryjdbc/DataSourceName
(and vice versa). - Select Overwrite existing data if you wish Bamboo to overwrite any tables that already exist in the database.
- Click Continue.
Screenshot Setup Datasource Connection