This documentation relates to an earlier version of Bamboo.
View

Unknown macro: {spacejump}

or visit the current documentation home.

We strongly recommend that you use Bamboo with one of the databases that we support (see Supported Platforms for details). However, if you wish to connect Bamboo to an unsupported database, you can do so via the instructions below.

First, you need to choose how you will connect to your database. Please follow the instructions for your chosen method:

JDBC is generally simpler, and is therefore the recommended method.

Connecting via JBDC


To connect Bamboo to an unsupported database, via JDBC,

  1. Put the appropriate JDBC driver jarfile into your application server's classpath:
    • For the Bamboo 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. The Setup Wizard no longer offers "Unsupported Database" as a selectable option when choosing to connect to an external database. If you are using an unsupported database, you will need to set the following system property before starting your upgraded Bamboo server to enable "Unsupported Database" as a selectable option in the Setup Wizard:
    -Dbamboo.enable.unsupported.db=true
  3. At Step 2 of the Bamboo Setup Wizard, choose 'External Database' and select 'Unsupported Database' from the list.
  4. The 'Select Database Connection' screen will appear. Select 'Direct JDBC connection'.
  5. The 'Setup JDBC Connection' screen will appear as shown in the screenshot below.
    • 'Driver Class Name' — Type the classname of your JDBC driver (consult your JDBC driver documentation for details).
    • 'Database URL' — Type the URL where Bamboo will access your database (consult your JDBC driver documentation for details).
    • 'User Name' — Type the username that Bamboo will use to access your database.
    • 'Password' — Type the password (if required) that Bamboo will use to access your database.

    • 'Hibernate Dialect' — Type the Hibernate dialect for your particular database:
      (warning) NOTE: the databases on this list are not supported by Atlassian. Using these databases is not recommended as there is no guarantee that they will operate correctly with Bamboo. Please consider using a supported databaseinstead.

      Database

      Dialect

      DB2

      net.sf.hibernate.dialect.DB2Dialect

      DB2 AS/400

      net.sf.hibernate.dialect.DB2400Dialect

      DB2 OS390

      net.sf.hibernate.dialect.DB2390Dialect

      Oracle 9/10g

      net.sf.hibernate.dialect.Oracle9Dialect

      Oracle (other versions)

      net.sf.hibernate.dialect.OracleDialect

      Sybase

      net.sf.hibernate.dialect.SybaseDialect

      Sybase Anywhere

      net.sf.hibernate.dialect.SybaseAnywhereDialect

      Microsoft SQL Server

      net.sf.hibernate.dialect.SQLServerDialect

      SAP DB

      net.sf.hibernate.dialect.SAPDBDialect

      Informix

      net.sf.hibernate.dialect.InformixDialect

      Ingres

      net.sf.hibernate.dialect.IngresDialect

      Progress

      net.sf.hibernate.dialect.ProgressDialect

      Mckoi SQL

      net.sf.hibernate.dialect.MckoiDialect

      Interbase

      net.sf.hibernate.dialect.InterbaseDialect

      Pointbase

      net.sf.hibernate.dialect.PointbaseDialect

      FrontBase

      net.sf.hibernate.dialect.FrontbaseDialect

      Firebird

      net.sf.hibernate.dialect.FirebirdDialect

  6. Select the 'Overwrite existing data' checkbox if you wish Bamboo to overwrite any tables that already exist in the database.
  7. Go to Step 3 of the Setup Wizard.

Connecting via a datasource

To connect Bamboo to an unsupported 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 your JDBC driver documentation.
  2. By default, the Setup Wizard does not offer Unsupported Database as a selectable option when choosing to connect to an external database. If you are using an unsupported database (see Supported Platforms for more information), you will need to set the following system property before starting your upgraded Bamboo server to enable the Unsupported Database as a selectable option in the Setup Wizard:
    -Dbamboo.enable.unsupported.db=true
  3. At Step 2 of the Bamboo Setup Wizard, choose 'External Database' and select 'Unsupported Database' 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. Go to Step 3 of the Setup Wizard.



Log a request with our support team.



Raise an issue for our developers.



See answers from the community.



Blog and update our documentation.

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