Bamboo should support Oracle Database

Please see BAM-957 for further reference.

Tried using it with the same Oracle 9 database that I am using for Jira and Confluence. On the "Configure Database" page I get the following error message:

Database configuration failed: Schema creation complete, but tables could not be found.

and indeed, the tables are not in the database.

Looking in the log indicates that:

(a) the PostgreSQLDialect was being used. Given that the install routine never asked what type of database would be used, there was little chance that the Oracle dialect would be the default. And therefore all of the "invalid datatype" messages.

(b) there is at least one identifier that is over Oracle's inane 30 character limit. Therefore the "invalid identifier" message.

Hopefully this information will help in reaching a "Oracle Compliant" mode quickly.

2007-07-11 19:02:22,249 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table AUTHOR (AUTHOR_ID int8 not null, LINKED_USER_NAME varchar(255), AUTHOR_NAME varchar(255), primary key (AUTHOR_ID))
2007-07-11 19:02:22,249 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype

2007-07-11 19:02:22,249 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table users (id int8 not null, name varchar(255) not null, password varchar(255), email varchar(255), created timestamp, fullname varchar(255), primary key (id))
2007-07-11 19:02:22,249 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype

2007-07-11 19:02:22,265 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table ACL_ENTRY (ID int8 not null, ACL_OBJECT_IDENTITY int8, TYPE varchar(255), SID varchar(255), ACE_ORDER int4, MASK int4, GRANTING bool, AUDIT_SUCCESS bool, AUDIT_FAILURE bool, primary key (ID))
2007-07-11 19:02:22,265 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype

2007-07-11 19:02:22,265 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table NOTIFICATION_RECIPIENTS (NOTIFICATION_RECIPIENT_ID int8 not null, RECIPIENT varchar(255), RECIPIENT_TYPE varchar(255), NOTIFICATION_RULE int8, primary key (NOTIFICATION_RECIPIENT_ID))
2007-07-11 19:02:22,265 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype

2007-07-11 19:02:22,265 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table PROJECT (PROJECT_ID int8 not null, CREATED_DATE timestamp, UPDATED_DATE timestamp, PROJECT_KEY varchar(255) not null, TITLE varchar(255), primary key (PROJECT_ID))
2007-07-11 19:02:22,265 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype

2007-07-11 19:02:22,265 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table BUILDRESULTSUMMARY_CUSTOMDATA (BUILDRESULTSUMMARY_ID int8 not null, CUSTOM_INFO_DATA varchar(4000), CUSTOM_INFO_KEY varchar(255) not null, primary key (BUILDRESULTSUMMARY_ID, CUSTOM_INFO_KEY))
2007-07-11 19:02:22,265 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype

2007-07-11 19:02:22,265 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table external_members (extentityid int8 not null, groupid int8 not null, primary key (groupid, extentityid))
2007-07-11 19:02:22,265 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype

2007-07-11 19:02:22,281 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table OS_PROPERTYENTRY (entity_name varchar(125) not null, entity_id int8 not null, entity_key varchar(200) not null, key_type int4, boolean_val bool, double_val float8, string_val varchar(255), text_val text, long_val int8, int_val int4, date_val timestamp, primary key (entity_name, entity_id, entity_key))
2007-07-11 19:02:22,281 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype

2007-07-11 19:02:22,281 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table BUILD_ASSOCIATION (CHILD_BUILD_ID int8 not null, PARENT_BUILD_ID int8 not null, primary key (PARENT_BUILD_ID, CHILD_BUILD_ID))
2007-07-11 19:02:22,281 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype

2007-07-11 19:02:22,281 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table BUILDRESULTSUMMARY_JIRAISSUE (BUILDRESULTSUMMARY_ID int8 not null, JIRA_ISSUE_KEY varchar(255))
2007-07-11 19:02:22,281 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype

2007-07-11 19:02:22,281 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table QUEUE_BUILD_KEY (QUEUE_ID int8 not null, BUILD_KEY varchar(255))
2007-07-11 19:02:22,281 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype

2007-07-11 19:02:22,281 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table ACL_OBJECT_IDENTITY (ID int8 not null, OBJECT_ID_CLASS varchar(255), OBJECT_ID_IDENTITY int8, PARENT_OBJECT int8, ENTRIES_INHERITING bool, OWNER_TYPE varchar(255), OWNER_SID varchar(255), primary key (ID))
2007-07-11 19:02:22,281 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype

2007-07-11 19:02:22,296 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table external_entities (id int8 not null, name varchar(255), type varchar(255) not null, primary key (id))
2007-07-11 19:02:22,296 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype

2007-07-11 19:02:22,296 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table NOTIFICATION_RULES (NOTIFICATION_RULE_ID int8 not null, NOTIFICATION_EVENT_CONDITION_KEY varchar(255), NOTIFICATION_EVENT_CONDITION_META_INFO varchar(4000), NOTIFICATION_SET int8, primary key (NOTIFICATION_RULE_ID))
2007-07-11 19:02:22,296 ERROR [http-80-1] [SchemaExport] ORA-00972: identifier is too long

2007-07-11 19:02:22,296 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table JIRASERVER (JIRASERVER_ID int8 not null, TITLE varchar(255) not null, HOST varchar(255) not null, USERNAME varchar(255), PASSWORD varchar(255), primary key (JIRASERVER_ID))
2007-07-11 19:02:22,296 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype

2007-07-11 19:02:22,296 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table groups (id int8 not null, groupname varchar(255) not null, primary key (id))
2007-07-11 19:02:22,296 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype

2007-07-11 19:02:22,296 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table COMMIT (COMMIT_ID int8 not null, BUILDRESULTSUMMARY_ID int8, AUTHOR_ID int8, DATE timestamp, COMMENT varchar(4000), primary key (COMMIT_ID))
2007-07-11 19:02:22,296 ERROR [http-80-1] [SchemaExport] ORA-00904: : invalid identifier

2007-07-11 19:02:22,296 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table BUILD (BUILD_ID int8 not null, CREATED_DATE timestamp, UPDATED_DATE timestamp, FULL_KEY varchar(255), BUILDKEY varchar(255), TITLE varchar(255), FIRST_BUILD_NUMBER int4, LATEST_BUILD_NUMBER int4, LAST_BUILD_START_TIME timestamp, NEXT_BUILD_NUMBER int4, SUSPENDED_FROM_BUILDING bool, MARKED_FOR_DELETION bool, PROJECT_ID int8 not null, NOTIFICATION_SET int8, primary key (BUILD_ID))
2007-07-11 19:02:22,296 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype

2007-07-11 19:02:22,312 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table NOTIFICATION_SETS (NOTIFICATION_SET_ID int8 not null, primary key (NOTIFICATION_SET_ID))
2007-07-11 19:02:22,312 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype

2007-07-11 19:02:22,312 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table LABEL (LABEL_ID int8 not null, NAME varchar(255), NAMESPACE varchar(255), CREATED_DATE timestamp, UPDATED_DATE timestamp, primary key (LABEL_ID))
2007-07-11 19:02:22,312 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype

2007-07-11 19:02:22,312 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table BUILDRESULTSUMMARY (BUILDRESULTSUMMARY_ID int8 not null, CREATED_DATE timestamp, UPDATED_DATE timestamp, BUILD_KEY varchar(255), BUILD_NUMBER int4, BUILD_STATE varchar(255), SUCCESSFUL_TEST_COUNT int8, FAILED_TEST_COUNT int8, BUILD_DATE timestamp, BUILD_COMPLETED_DATE timestamp, DURATION int8, TIME_TO_FIX int8, REASON_FOR_BUILD varchar(255), DELTA_STATE varchar(255), primary key (BUILDRESULTSUMMARY_ID))
2007-07-11 19:02:22,312 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype

2007-07-11 19:02:22,312 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table COMMIT_FILES (COMMIT_ID int8 not null, COMMIT_FILE_NAME varchar(1000), COMMIT_FILE_REIVISION varchar(255), LIST_POSITION int4 not null, primary key (COMMIT_ID, LIST_POSITION))
2007-07-11 19:02:22,312 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype

2007-07-11 19:02:22,312 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table IMSERVER (IMSERVER_ID int8 not null, TITLE varchar(255) not null, HOST varchar(255) not null, PORT int4, USERNAME varchar(255), PASSWORD varchar(255), SSL_REQUIRED bool not null, primary key (IMSERVER_ID))
2007-07-11 19:02:22,312 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype

2007-07-11 19:02:22,328 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table QUEUE (QUEUE_ID int8 not null, TITLE varchar(255) not null, primary key (QUEUE_ID))
2007-07-11 19:02:22,328 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype

2007-07-11 19:02:22,328 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table local_members (userid int8 not null, groupid int8 not null, primary key (groupid, userid))
2007-07-11 19:02:22,328 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype

2007-07-11 19:02:22,328 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table COMMENT (COMMENT_ID int8 not null, CONTENT text, USER_NAME varchar(255), BUILDRESULTSUMMARY_ID int8, CREATED_DATE timestamp, UPDATED_DATE timestamp, primary key (COMMENT_ID))
2007-07-11 19:02:22,328 ERROR [http-80-1] [SchemaExport] ORA-00903: invalid table name

2007-07-11 19:02:22,328 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table BUILD_DEFINITION (BUILD_DEFINITION_ID int8 not null, BUILD_DEFINITION_TYPE varchar(255) not null, CREATED_DATE timestamp, UPDATED_DATE timestamp, XML_DATA varchar(4000), BUILD_ID int8 unique, primary key (BUILD_DEFINITION_ID))
2007-07-11 19:02:22,328 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype

2007-07-11 19:02:22,328 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table BUILDRESULTSUMMARY_LABEL (ID int8 not null, LABEL_ID int8 not null, BUILDRESULTSUMMARY_ID int8, BUILD_ID int8, PROJECT_ID int8, USER_NAME varchar(255), CREATED_DATE timestamp, UPDATED_DATE timestamp, primary key (ID))
2007-07-11 19:02:22,328 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype

2007-07-11 19:02:22,343 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table ACL_ENTRY add constraint FK2FB5F83D988CEFE9 foreign key (ACL_OBJECT_IDENTITY) references ACL_OBJECT_IDENTITY
2007-07-11 19:02:22,343 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist

2007-07-11 19:02:22,343 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table NOTIFICATION_RECIPIENTS add constraint FK1A48714E9F30B1D0 foreign key (NOTIFICATION_RULE) references NOTIFICATION_RULES
2007-07-11 19:02:22,343 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist

2007-07-11 19:02:22,343 ERROR [http-80-1] [SchemaExport] Unsuccessful: create index project_key_idx on PROJECT (PROJECT_KEY)
2007-07-11 19:02:22,343 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist

2007-07-11 19:02:22,343 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table BUILDRESULTSUMMARY_CUSTOMDATA add constraint FK30932C1FA958B29F foreign key (BUILDRESULTSUMMARY_ID) references BUILDRESULTSUMMARY
2007-07-11 19:02:22,343 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist

2007-07-11 19:02:22,343 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table external_members add constraint FKD8C8D8A5117D5FDA foreign key (groupid) references groups
2007-07-11 19:02:22,343 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist

2007-07-11 19:02:22,359 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table external_members add constraint FKD8C8D8A5F25E5D5F foreign key (extentityid) references external_entities
2007-07-11 19:02:22,359 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist

2007-07-11 19:02:22,359 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table BUILD_ASSOCIATION add constraint FKF7997F059BA648F foreign key (CHILD_BUILD_ID) references BUILD
2007-07-11 19:02:22,359 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist

2007-07-11 19:02:22,359 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table BUILD_ASSOCIATION add constraint FKF7997F04B4828A1 foreign key (PARENT_BUILD_ID) references BUILD
2007-07-11 19:02:22,359 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist

2007-07-11 19:02:22,359 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table BUILDRESULTSUMMARY_JIRAISSUE add constraint FKBA35E7C7A958B29F foreign key (BUILDRESULTSUMMARY_ID) references BUILDRESULTSUMMARY
2007-07-11 19:02:22,359 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist

2007-07-11 19:02:22,359 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table QUEUE_BUILD_KEY add constraint FK5FECAB00E93DDB29 foreign key (QUEUE_ID) references QUEUE
2007-07-11 19:02:22,359 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist

2007-07-11 19:02:22,359 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table ACL_OBJECT_IDENTITY add constraint FK988CEFE974D9E474 foreign key (PARENT_OBJECT) references ACL_OBJECT_IDENTITY
2007-07-11 19:02:22,359 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist

2007-07-11 19:02:22,374 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table NOTIFICATION_RULES add constraint FK46E58883707D72EE foreign key (NOTIFICATION_SET) references NOTIFICATION_SETS
2007-07-11 19:02:22,374 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist

2007-07-11 19:02:22,374 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table COMMIT add constraint FK76D21D37A958B29F foreign key (BUILDRESULTSUMMARY_ID) references BUILDRESULTSUMMARY
2007-07-11 19:02:22,374 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist

2007-07-11 19:02:22,374 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table COMMIT add constraint FK76D21D37FE0C684F foreign key (AUTHOR_ID) references AUTHOR
2007-07-11 19:02:22,374 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist

2007-07-11 19:02:22,374 ERROR [http-80-1] [SchemaExport] Unsuccessful: create index build_key_idx on BUILD (FULL_KEY)
2007-07-11 19:02:22,374 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist

2007-07-11 19:02:22,374 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table BUILD add constraint FK3C9CE4E707D72EE foreign key (NOTIFICATION_SET) references NOTIFICATION_SETS
2007-07-11 19:02:22,374 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist

2007-07-11 19:02:22,390 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table BUILD add constraint FK3C9CE4EA77F0821 foreign key (PROJECT_ID) references PROJECT
2007-07-11 19:02:22,390 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist

2007-07-11 19:02:22,390 ERROR [http-80-1] [SchemaExport] Unsuccessful: create index key_number_results_index on BUILDRESULTSUMMARY (BUILD_KEY, BUILD_NUMBER)
2007-07-11 19:02:22,390 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist

2007-07-11 19:02:22,390 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table COMMIT_FILES add constraint FKA9983D4F4D373123 foreign key (COMMIT_ID) references COMMIT
2007-07-11 19:02:22,390 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist

2007-07-11 19:02:22,390 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table local_members add constraint FK6B8FB445CE2B3226 foreign key (userid) references users
2007-07-11 19:02:22,390 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist

2007-07-11 19:02:22,390 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table local_members add constraint FK6B8FB445117D5FDA foreign key (groupid) references groups
2007-07-11 19:02:22,390 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist

2007-07-11 19:02:22,406 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table COMMENT add constraint FK63717A3FA958B29F foreign key (BUILDRESULTSUMMARY_ID) references BUILDRESULTSUMMARY
2007-07-11 19:02:22,406 ERROR [http-80-1] [SchemaExport] ORA-00903: invalid table name

2007-07-11 19:02:22,406 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table BUILD_DEFINITION add constraint FK611B4BE4D96054AC foreign key (BUILD_ID) references BUILD
2007-07-11 19:02:22,406 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist

2007-07-11 19:02:22,406 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table BUILDRESULTSUMMARY_LABEL add constraint FK9043ED0A77F0821 foreign key (PROJECT_ID) references PROJECT
2007-07-11 19:02:22,406 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist

2007-07-11 19:02:22,406 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table BUILDRESULTSUMMARY_LABEL add constraint FK9043ED0D96054AC foreign key (BUILD_ID) references BUILD
2007-07-11 19:02:22,406 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist

2007-07-11 19:02:22,406 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table BUILDRESULTSUMMARY_LABEL add constraint FK9043ED0B9DE8666 foreign key (LABEL_ID) references LABEL
2007-07-11 19:02:22,406 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist

2007-07-11 19:02:22,406 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table BUILDRESULTSUMMARY_LABEL add constraint FK9043ED0A958B29F foreign key (BUILDRESULTSUMMARY_ID) references BUILDRESULTSUMMARY
2007-07-11 19:02:22,406 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist

2007-07-11 19:02:22,421 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table hibernate_unique_key ( next_hi int4 )
2007-07-11 19:02:22,421 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype

2007-07-11 19:02:22,421 ERROR [http-80-1] [SchemaExport] Unsuccessful: insert into hibernate_unique_key values ( 0 )
2007-07-11 19:02:22,421 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist
[ Show » ]
Arvid Jedlicka - 11/Jul/07 07:17 PM Tried using it with the same Oracle 9 database that I am using for Jira and Confluence. On the "Configure Database" page I get the following error message: Database configuration failed: Schema creation complete, but tables could not be found. and indeed, the tables are not in the database. Looking in the log indicates that: (a) the PostgreSQLDialect was being used. Given that the install routine never asked what type of database would be used, there was little chance that the Oracle dialect would be the default. And therefore all of the "invalid datatype" messages. (b) there is at least one identifier that is over Oracle's inane 30 character limit. Therefore the "invalid identifier" message. Hopefully this information will help in reaching a "Oracle Compliant" mode quickly. 2007-07-11 19:02:22,249 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table AUTHOR (AUTHOR_ID int8 not null, LINKED_USER_NAME varchar(255), AUTHOR_NAME varchar(255), primary key (AUTHOR_ID)) 2007-07-11 19:02:22,249 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype 2007-07-11 19:02:22,249 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table users (id int8 not null, name varchar(255) not null, password varchar(255), email varchar(255), created timestamp, fullname varchar(255), primary key (id)) 2007-07-11 19:02:22,249 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype 2007-07-11 19:02:22,265 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table ACL_ENTRY (ID int8 not null, ACL_OBJECT_IDENTITY int8, TYPE varchar(255), SID varchar(255), ACE_ORDER int4, MASK int4, GRANTING bool, AUDIT_SUCCESS bool, AUDIT_FAILURE bool, primary key (ID)) 2007-07-11 19:02:22,265 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype 2007-07-11 19:02:22,265 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table NOTIFICATION_RECIPIENTS (NOTIFICATION_RECIPIENT_ID int8 not null, RECIPIENT varchar(255), RECIPIENT_TYPE varchar(255), NOTIFICATION_RULE int8, primary key (NOTIFICATION_RECIPIENT_ID)) 2007-07-11 19:02:22,265 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype 2007-07-11 19:02:22,265 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table PROJECT (PROJECT_ID int8 not null, CREATED_DATE timestamp, UPDATED_DATE timestamp, PROJECT_KEY varchar(255) not null, TITLE varchar(255), primary key (PROJECT_ID)) 2007-07-11 19:02:22,265 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype 2007-07-11 19:02:22,265 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table BUILDRESULTSUMMARY_CUSTOMDATA (BUILDRESULTSUMMARY_ID int8 not null, CUSTOM_INFO_DATA varchar(4000), CUSTOM_INFO_KEY varchar(255) not null, primary key (BUILDRESULTSUMMARY_ID, CUSTOM_INFO_KEY)) 2007-07-11 19:02:22,265 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype 2007-07-11 19:02:22,265 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table external_members (extentityid int8 not null, groupid int8 not null, primary key (groupid, extentityid)) 2007-07-11 19:02:22,265 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype 2007-07-11 19:02:22,281 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table OS_PROPERTYENTRY (entity_name varchar(125) not null, entity_id int8 not null, entity_key varchar(200) not null, key_type int4, boolean_val bool, double_val float8, string_val varchar(255), text_val text, long_val int8, int_val int4, date_val timestamp, primary key (entity_name, entity_id, entity_key)) 2007-07-11 19:02:22,281 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype 2007-07-11 19:02:22,281 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table BUILD_ASSOCIATION (CHILD_BUILD_ID int8 not null, PARENT_BUILD_ID int8 not null, primary key (PARENT_BUILD_ID, CHILD_BUILD_ID)) 2007-07-11 19:02:22,281 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype 2007-07-11 19:02:22,281 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table BUILDRESULTSUMMARY_JIRAISSUE (BUILDRESULTSUMMARY_ID int8 not null, JIRA_ISSUE_KEY varchar(255)) 2007-07-11 19:02:22,281 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype 2007-07-11 19:02:22,281 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table QUEUE_BUILD_KEY (QUEUE_ID int8 not null, BUILD_KEY varchar(255)) 2007-07-11 19:02:22,281 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype 2007-07-11 19:02:22,281 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table ACL_OBJECT_IDENTITY (ID int8 not null, OBJECT_ID_CLASS varchar(255), OBJECT_ID_IDENTITY int8, PARENT_OBJECT int8, ENTRIES_INHERITING bool, OWNER_TYPE varchar(255), OWNER_SID varchar(255), primary key (ID)) 2007-07-11 19:02:22,281 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype 2007-07-11 19:02:22,296 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table external_entities (id int8 not null, name varchar(255), type varchar(255) not null, primary key (id)) 2007-07-11 19:02:22,296 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype 2007-07-11 19:02:22,296 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table NOTIFICATION_RULES (NOTIFICATION_RULE_ID int8 not null, NOTIFICATION_EVENT_CONDITION_KEY varchar(255), NOTIFICATION_EVENT_CONDITION_META_INFO varchar(4000), NOTIFICATION_SET int8, primary key (NOTIFICATION_RULE_ID)) 2007-07-11 19:02:22,296 ERROR [http-80-1] [SchemaExport] ORA-00972: identifier is too long 2007-07-11 19:02:22,296 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table JIRASERVER (JIRASERVER_ID int8 not null, TITLE varchar(255) not null, HOST varchar(255) not null, USERNAME varchar(255), PASSWORD varchar(255), primary key (JIRASERVER_ID)) 2007-07-11 19:02:22,296 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype 2007-07-11 19:02:22,296 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table groups (id int8 not null, groupname varchar(255) not null, primary key (id)) 2007-07-11 19:02:22,296 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype 2007-07-11 19:02:22,296 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table COMMIT (COMMIT_ID int8 not null, BUILDRESULTSUMMARY_ID int8, AUTHOR_ID int8, DATE timestamp, COMMENT varchar(4000), primary key (COMMIT_ID)) 2007-07-11 19:02:22,296 ERROR [http-80-1] [SchemaExport] ORA-00904: : invalid identifier 2007-07-11 19:02:22,296 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table BUILD (BUILD_ID int8 not null, CREATED_DATE timestamp, UPDATED_DATE timestamp, FULL_KEY varchar(255), BUILDKEY varchar(255), TITLE varchar(255), FIRST_BUILD_NUMBER int4, LATEST_BUILD_NUMBER int4, LAST_BUILD_START_TIME timestamp, NEXT_BUILD_NUMBER int4, SUSPENDED_FROM_BUILDING bool, MARKED_FOR_DELETION bool, PROJECT_ID int8 not null, NOTIFICATION_SET int8, primary key (BUILD_ID)) 2007-07-11 19:02:22,296 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype 2007-07-11 19:02:22,312 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table NOTIFICATION_SETS (NOTIFICATION_SET_ID int8 not null, primary key (NOTIFICATION_SET_ID)) 2007-07-11 19:02:22,312 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype 2007-07-11 19:02:22,312 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table LABEL (LABEL_ID int8 not null, NAME varchar(255), NAMESPACE varchar(255), CREATED_DATE timestamp, UPDATED_DATE timestamp, primary key (LABEL_ID)) 2007-07-11 19:02:22,312 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype 2007-07-11 19:02:22,312 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table BUILDRESULTSUMMARY (BUILDRESULTSUMMARY_ID int8 not null, CREATED_DATE timestamp, UPDATED_DATE timestamp, BUILD_KEY varchar(255), BUILD_NUMBER int4, BUILD_STATE varchar(255), SUCCESSFUL_TEST_COUNT int8, FAILED_TEST_COUNT int8, BUILD_DATE timestamp, BUILD_COMPLETED_DATE timestamp, DURATION int8, TIME_TO_FIX int8, REASON_FOR_BUILD varchar(255), DELTA_STATE varchar(255), primary key (BUILDRESULTSUMMARY_ID)) 2007-07-11 19:02:22,312 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype 2007-07-11 19:02:22,312 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table COMMIT_FILES (COMMIT_ID int8 not null, COMMIT_FILE_NAME varchar(1000), COMMIT_FILE_REIVISION varchar(255), LIST_POSITION int4 not null, primary key (COMMIT_ID, LIST_POSITION)) 2007-07-11 19:02:22,312 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype 2007-07-11 19:02:22,312 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table IMSERVER (IMSERVER_ID int8 not null, TITLE varchar(255) not null, HOST varchar(255) not null, PORT int4, USERNAME varchar(255), PASSWORD varchar(255), SSL_REQUIRED bool not null, primary key (IMSERVER_ID)) 2007-07-11 19:02:22,312 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype 2007-07-11 19:02:22,328 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table QUEUE (QUEUE_ID int8 not null, TITLE varchar(255) not null, primary key (QUEUE_ID)) 2007-07-11 19:02:22,328 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype 2007-07-11 19:02:22,328 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table local_members (userid int8 not null, groupid int8 not null, primary key (groupid, userid)) 2007-07-11 19:02:22,328 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype 2007-07-11 19:02:22,328 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table COMMENT (COMMENT_ID int8 not null, CONTENT text, USER_NAME varchar(255), BUILDRESULTSUMMARY_ID int8, CREATED_DATE timestamp, UPDATED_DATE timestamp, primary key (COMMENT_ID)) 2007-07-11 19:02:22,328 ERROR [http-80-1] [SchemaExport] ORA-00903: invalid table name 2007-07-11 19:02:22,328 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table BUILD_DEFINITION (BUILD_DEFINITION_ID int8 not null, BUILD_DEFINITION_TYPE varchar(255) not null, CREATED_DATE timestamp, UPDATED_DATE timestamp, XML_DATA varchar(4000), BUILD_ID int8 unique, primary key (BUILD_DEFINITION_ID)) 2007-07-11 19:02:22,328 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype 2007-07-11 19:02:22,328 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table BUILDRESULTSUMMARY_LABEL (ID int8 not null, LABEL_ID int8 not null, BUILDRESULTSUMMARY_ID int8, BUILD_ID int8, PROJECT_ID int8, USER_NAME varchar(255), CREATED_DATE timestamp, UPDATED_DATE timestamp, primary key (ID)) 2007-07-11 19:02:22,328 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype 2007-07-11 19:02:22,343 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table ACL_ENTRY add constraint FK2FB5F83D988CEFE9 foreign key (ACL_OBJECT_IDENTITY) references ACL_OBJECT_IDENTITY 2007-07-11 19:02:22,343 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist 2007-07-11 19:02:22,343 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table NOTIFICATION_RECIPIENTS add constraint FK1A48714E9F30B1D0 foreign key (NOTIFICATION_RULE) references NOTIFICATION_RULES 2007-07-11 19:02:22,343 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist 2007-07-11 19:02:22,343 ERROR [http-80-1] [SchemaExport] Unsuccessful: create index project_key_idx on PROJECT (PROJECT_KEY) 2007-07-11 19:02:22,343 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist 2007-07-11 19:02:22,343 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table BUILDRESULTSUMMARY_CUSTOMDATA add constraint FK30932C1FA958B29F foreign key (BUILDRESULTSUMMARY_ID) references BUILDRESULTSUMMARY 2007-07-11 19:02:22,343 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist 2007-07-11 19:02:22,343 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table external_members add constraint FKD8C8D8A5117D5FDA foreign key (groupid) references groups 2007-07-11 19:02:22,343 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist 2007-07-11 19:02:22,359 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table external_members add constraint FKD8C8D8A5F25E5D5F foreign key (extentityid) references external_entities 2007-07-11 19:02:22,359 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist 2007-07-11 19:02:22,359 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table BUILD_ASSOCIATION add constraint FKF7997F059BA648F foreign key (CHILD_BUILD_ID) references BUILD 2007-07-11 19:02:22,359 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist 2007-07-11 19:02:22,359 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table BUILD_ASSOCIATION add constraint FKF7997F04B4828A1 foreign key (PARENT_BUILD_ID) references BUILD 2007-07-11 19:02:22,359 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist 2007-07-11 19:02:22,359 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table BUILDRESULTSUMMARY_JIRAISSUE add constraint FKBA35E7C7A958B29F foreign key (BUILDRESULTSUMMARY_ID) references BUILDRESULTSUMMARY 2007-07-11 19:02:22,359 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist 2007-07-11 19:02:22,359 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table QUEUE_BUILD_KEY add constraint FK5FECAB00E93DDB29 foreign key (QUEUE_ID) references QUEUE 2007-07-11 19:02:22,359 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist 2007-07-11 19:02:22,359 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table ACL_OBJECT_IDENTITY add constraint FK988CEFE974D9E474 foreign key (PARENT_OBJECT) references ACL_OBJECT_IDENTITY 2007-07-11 19:02:22,359 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist 2007-07-11 19:02:22,374 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table NOTIFICATION_RULES add constraint FK46E58883707D72EE foreign key (NOTIFICATION_SET) references NOTIFICATION_SETS 2007-07-11 19:02:22,374 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist 2007-07-11 19:02:22,374 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table COMMIT add constraint FK76D21D37A958B29F foreign key (BUILDRESULTSUMMARY_ID) references BUILDRESULTSUMMARY 2007-07-11 19:02:22,374 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist 2007-07-11 19:02:22,374 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table COMMIT add constraint FK76D21D37FE0C684F foreign key (AUTHOR_ID) references AUTHOR 2007-07-11 19:02:22,374 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist 2007-07-11 19:02:22,374 ERROR [http-80-1] [SchemaExport] Unsuccessful: create index build_key_idx on BUILD (FULL_KEY) 2007-07-11 19:02:22,374 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist 2007-07-11 19:02:22,374 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table BUILD add constraint FK3C9CE4E707D72EE foreign key (NOTIFICATION_SET) references NOTIFICATION_SETS 2007-07-11 19:02:22,374 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist 2007-07-11 19:02:22,390 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table BUILD add constraint FK3C9CE4EA77F0821 foreign key (PROJECT_ID) references PROJECT 2007-07-11 19:02:22,390 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist 2007-07-11 19:02:22,390 ERROR [http-80-1] [SchemaExport] Unsuccessful: create index key_number_results_index on BUILDRESULTSUMMARY (BUILD_KEY, BUILD_NUMBER) 2007-07-11 19:02:22,390 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist 2007-07-11 19:02:22,390 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table COMMIT_FILES add constraint FKA9983D4F4D373123 foreign key (COMMIT_ID) references COMMIT 2007-07-11 19:02:22,390 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist 2007-07-11 19:02:22,390 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table local_members add constraint FK6B8FB445CE2B3226 foreign key (userid) references users 2007-07-11 19:02:22,390 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist 2007-07-11 19:02:22,390 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table local_members add constraint FK6B8FB445117D5FDA foreign key (groupid) references groups 2007-07-11 19:02:22,390 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist 2007-07-11 19:02:22,406 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table COMMENT add constraint FK63717A3FA958B29F foreign key (BUILDRESULTSUMMARY_ID) references BUILDRESULTSUMMARY 2007-07-11 19:02:22,406 ERROR [http-80-1] [SchemaExport] ORA-00903: invalid table name 2007-07-11 19:02:22,406 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table BUILD_DEFINITION add constraint FK611B4BE4D96054AC foreign key (BUILD_ID) references BUILD 2007-07-11 19:02:22,406 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist 2007-07-11 19:02:22,406 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table BUILDRESULTSUMMARY_LABEL add constraint FK9043ED0A77F0821 foreign key (PROJECT_ID) references PROJECT 2007-07-11 19:02:22,406 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist 2007-07-11 19:02:22,406 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table BUILDRESULTSUMMARY_LABEL add constraint FK9043ED0D96054AC foreign key (BUILD_ID) references BUILD 2007-07-11 19:02:22,406 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist 2007-07-11 19:02:22,406 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table BUILDRESULTSUMMARY_LABEL add constraint FK9043ED0B9DE8666 foreign key (LABEL_ID) references LABEL 2007-07-11 19:02:22,406 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist 2007-07-11 19:02:22,406 ERROR [http-80-1] [SchemaExport] Unsuccessful: alter table BUILDRESULTSUMMARY_LABEL add constraint FK9043ED0A958B29F foreign key (BUILDRESULTSUMMARY_ID) references BUILDRESULTSUMMARY 2007-07-11 19:02:22,406 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist 2007-07-11 19:02:22,421 ERROR [http-80-1] [SchemaExport] Unsuccessful: create table hibernate_unique_key ( next_hi int4 ) 2007-07-11 19:02:22,421 ERROR [http-80-1] [SchemaExport] ORA-00902: invalid datatype 2007-07-11 19:02:22,421 ERROR [http-80-1] [SchemaExport] Unsuccessful: insert into hibernate_unique_key values ( 0 ) 2007-07-11 19:02:22,421 ERROR [http-80-1] [SchemaExport] ORA-00942: table or view does not exist