Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-5371

Support Firebird DB for Confluence

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Won't Fix
    • None
    • None
    • Standalone Confluence,
      Red Hat Linux - Kernel 2.4.20,
    • We collect Confluence feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    Description

      I've been attempting to get confluence running with a Firebird (http://firebird.sourceforge.net/) database, which has its dialect included in hibernate-2.1.8-atlassian.jar.

      Setting up the external database seems fine, with JayBird jdbc drivers, a network database URL through port 3050 and the dialect.

      The setup procedure runs into trouble trying to insert tables into the database, because of the use of reserved words, or key size is too large.

      From the server log: (complete log attached)


      2006-02-02 14:40:31,413 ERROR [hibernate.tool.hbm2ddl.SchemaExport] execute Unsuccessful: create table external_entities (id numeric(18,0) not null, name varchar(255), type varchar(255) not null, primary key (id))
      2006-02-02 14:40:31,416 ERROR [hibernate.tool.hbm2ddl.SchemaExport] execute GDS Exception. 335544569. Dynamic SQL Error
      SQL error code = -104
      Token unknown - line 1, char 79
      type
      2006-02-02 14:40:31,438 ERROR [hibernate.tool.hbm2ddl.SchemaExport] execute Unsuccessful: create table os_user (id numeric(18,0) not null, username varchar(255) not null unique, passwd varchar(255), primary key (id))
      2006-02-02 14:40:31,442 ERROR [hibernate.tool.hbm2ddl.SchemaExport] execute GDS Exception. 335544351. unsuccessful metadata update
      key size too big for index RDB$12
      ...
      2006-02-02 14:40:31,481 ERROR [hibernate.tool.hbm2ddl.SchemaExport] execute Unsuccessful: create table users (id numeric(18,0) not null, name varchar(255) not null, password varchar(255), email varchar(255), created timestamp, fullname varchar(255), primary key (id))
      2006-02-02 14:40:31,483 ERROR [hibernate.tool.hbm2ddl.SchemaExport] execute GDS Exception. 335544569. Dynamic SQL Error
      SQL error code = -104
      Token unknown - line 1, char 76
      password


      I'm uncertain whether th solution would be in the hibernate mappings, or tweaking in confluence.

      Attachments

        Issue Links

          Activity

            People

              matt@atlassian.com Matt Ryall
              a91cd956d800 Ryan
              Votes:
              4 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: