This page last changed on Oct 16, 2008 by alui.

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 jar file into your application server's classpath:
    • For the Bamboo Standalone 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. At Step 2 of the Bamboo Setup Wizard, choose 'External Database' and select 'Unsupported Database' from the list.
  3. The 'Select Database Connection' screen will appear. Select 'Direct JDBC connection'.
  4. 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 database instead.
      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
  5. Select the 'Overwrite existing data' checkbox if you wish Bamboo to overwrite any tables that already exist in the database.
  6. Go to Step 3 of the Setup Wizard.

Screenshot 1: 'Setup JDBC Connection (Unsupported Database)'




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. At Step 2 of the Bamboo Setup Wizard, choose 'External Database' and select 'Unsupported Database' from the list.
  3. The 'Select Database Connection' screen will appear. Select 'Connect via a datasource (configured in the application server)'.
  4. 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, try jdbc/DataSourceName (and vice versa).
  5. Select the 'Overwrite existing data' checkbox if you wish Bamboo to overwrite any tables that already exist in the database.
  6. Go to Step 3 of the Setup Wizard.

Screenshot 2: 'Setup Datasource Connection'

!2.1 MySQL 4.1 and 5.0^bamboo-database-jndi-connection.png!



Document generated by Confluence on Mar 09, 2009 17:06