Connect Bamboo to an Oracle database
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. We recommend to use JDBC because this method is simpler.
See Supported platforms for other information about the versions of Oracle supported by Bamboo.
このページの内容
重要
- For JDBC or JNDI connections, please ensure that the user connecting to the database will have total permissions. This includes the DBMS_LOB package and other resources available.
Install Oracle
If you don't already have an operational Oracle server, download and install it now. See the Oracle documentation for instructions.
Oracle サーバーを設定する場合、次の点にご注意ください。
- Character encoding must be set to AL32UTF8 (this is the Oracle equivalent of Unicode UTF-8).
- Collation should be set to
BINARY.
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 whom Bamboo will connect (for example:
bamboo-user).
Remember this database user name, as it will be used to configure Bamboo's connection to this database.Oracle でユーザーを作成すると、Oracle は自動的に「スキーマ」を作成します。create user bamboo-user identified by password;ユーザーが次の権限を持つことを確認します :
grant connect, resource, create table to bamboo-user;
Connecting using JDBC
The JDBC drivers for Oracle Server are no longer bundled with Bamboo due to licensing restrictions. You need to download and install the driver yourself.
Download and install the JDBC driver
To download and install the JDBC driver:
- Take a backup of the ojdbc8.jar file from the following location:
<Bamboo installation directory>/lib - Download the Oracle JDBC driver ojdbc8.jar from the Oracle download site.
- Copy the ojdbc8.jar file from the extracted directory to the
{{ <Bamboo installation directory>/lib }}directory
If thelib/directory doesn't exist, you can create it.
If you are using the Java Service Wrapper, to start your Bamboo instance (Bamboo/wrapper/run-bamboo start), copy the ojdbc8.jar file to the<Bamboo installation directory> /wrapper/libdirectory. - Stop Bamboo on Windows, Linux, or Mac.
- Restart Bamboo on Windows, Linux, or Mac.
Connect Bamboo to an Oracle database using JDBC
To connect Bamboo to an Oracle database 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:
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.
- Select 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/DataSourceNamedoesn'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.
- Select Continue.
Screenshot Setup Datasource Connection