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.

このページの内容:

 

重要

  • 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.

関連情報記載ページ:

Troubleshooting Databases

Configuring Oracle

  1. Ensure that you have a database instance available for Bamboo (either create a new one or use an existing one).
  2. Within that database instance, create a user which Bamboo will connect as (e.g. bamboo-user). (tick) Remember this database user name, as it will be used to configure Bamboo's connection to this database.
    (info) When you create a user in Oracle, Oracle will create a 'schema' automatically.

    create user bamboo-user identified by password;
    
  3. ユーザーが次の権限を持つことを確認します :

    grant connect, resource, create table to bamboo-user;
    

Connecting using JDBC

  1. Run the Setup Wizard and choose the Custom Installation method.
  2. At the 'Choose a Database Configuration' step, choose External Database > Oracle.
  3. 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.

  4. Select Overwrite existing data if you wish Bamboo to overwrite any tables that already exist in the database.
  5. Click Continue.

Screenshot: Setup JDBC Connection (Oracle)

Connecting using 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 > Oracle.
  4. Select Connect using a datasource (configured in the application server)
  5. 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 Overwrite existing data if you wish Bamboo to overwrite any tables that already exist in the database.
  7. 続行をクリックします。

Screenshot Setup Datasource Connection

最終更新日 2017 年 7 月 20 日

この翻訳に満足しましたか?

はい
いいえ
この記事についてのフィードバックを送信する

お探しの情報が見つかりませんか?

コミュニティへの質問

Powered by Confluence and Scroll Viewport.