Details
-
Suggestion
-
Resolution: Won't Fix
-
None
-
None
-
Standalone Confluence,
Red Hat Linux - Kernel 2.4.20,
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
- is duplicated by
-
CONFSERVER-9122 Support Firebird SQL
- Closed