[Bamboo Cloud docs]
[Bamboo Knowledge Base]
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 using the instructions below.
First, choose one of the following methods by which you will connect to your database:
Then follow the instructions for that method. Note that using JDBC is generally simpler, and is therefore the recommended method.
To connect Bamboo to an unsupported database, using JDBC:
jar
file into your application server's classpath by copying the jar
file into the webapp/WEB-INF/lib
directory.-Dbamboo.enable.unsupported.db=true
In the 'Setup JDBC Connection' screen, make the following settings:
Setting | Description |
---|---|
Driver Class Name | The classname of your JDBC driver (consult your JDBC driver documentation for details). |
Database URL | The URL where Bamboo will access your database (consult your JDBC driver documentation for details). |
UserName | The username that Bamboo will use to access your database. |
Password | The password (if required) that Bamboo will use to access your database. |
Hibernate Dialect | The Hibernate dialect for your particular database. See the table of dialects below. NOTE: the databases in 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 database instead. |
This table lists the Hibernate dialects that are available for particular databases.
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 |
To connect Bamboo to an unsupported database, using a datasource:
-Dbamboo.enable.unsupported.db=true
java:comp/env/jdbc/DataSourceName
doesn't work, try jdbc/DataSourceName
(and vice versa).