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,
- Put the appropriate JDBC driver
jar
file into your application server's classpath:- For the Bamboo distribution, copy the
jar
file into thewebapp/WEB-INF/lib
directory. - For the Bamboo EAR-WAR distribution, the location will depend on which application server you are using.
- For the Bamboo distribution, copy the
- 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
- At Step 2 of the Bamboo Setup Wizard, choose 'External Database' and select 'Unsupported Database' from the list.
- The 'Select Database Connection' screen will appear. Select 'Direct JDBC connection'.
- 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:
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
- Select the 'Overwrite existing data' checkbox if you wish Bamboo to overwrite any tables that already exist in the database.
- Go to Step 3 of the Setup Wizard.
Connecting via a datasource
To connect Bamboo to an unsupported database, via 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 your JDBC driver documentation.
- 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
- At Step 2 of the Bamboo Setup Wizard, choose 'External Database' and select 'Unsupported Database' from the list.
- The 'Select Database Connection' screen will appear. Select 'Connect via a datasource (configured in the application server)'.
- 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.
If
java:comp/env/jdbc/DataSourceName
doesn't work, tryjdbc/DataSourceName
(and vice versa). - Select the 'Overwrite existing data' checkbox if you wish Bamboo to overwrite any tables that already exist in the database.
- Go to Step 3 of the Setup Wizard.