Consequently, on startup gives
012-07-04 05:15:03,974 ERROR hbm2ddl.SchemaUpdate Unsuccessful: create table user (id number(19,0) not null, version number(19,0) not null, account_expired number(1,0) not null, account_locked number(1,0)
not null, enabled number(1,0) not null, "password" varchar2(255 char) not null, password_expired number(1,0) not null, username varchar2(255 char) not null unique, primary key (id))
2012-07-04 05:15:03,974 ERROR hbm2ddl.SchemaUpdate ORA-00903: invalid table name
2012-07-04 05:15:03,975 ERROR hbm2ddl.SchemaUpdate Unsuccessful: alter table user_role add constraint FK143BF46A84DFE2B0 foreign key (user_id) references user
2012-07-04 05:15:03,975 ERROR hbm2ddl.SchemaUpdate ORA-00903: invalid table name
2012-07-04 05:15:03,976 ERROR hbm2ddl.SchemaUpdate Unsuccessful: alter table webhook add constraint FK48F4F67784DFE2B0 foreign key (user_id) references user
2012-07-04 05:15:03,976 ERROR hbm2ddl.SchemaUpdate ORA-00903: invalid table name
2012-07-04 05:15:10,469 ERROR util.JDBCExceptionReporter ORA-02289: sequence does not exist
2012-07-04 05:17:53,135 ERROR hbm2ddl.SchemaUpdate Unsuccessful: create table user (id number(19,0) not null, version number(19,0) not null, account_expired number(1,0) not null, account_locked number
(1,0) not null, enabled number(1,0) not null, "password" varchar2(255 char) not null, password_expired number(1,0) not null, username varchar2(255 char) not null unique, primary key (id))
2012-07-04 05:17:53,135 ERROR hbm2ddl.SchemaUpdate ORA-00903: invalid table name
The table needs to be created with some other name for Yana2 to function against oracle.
Yana2 is not deployable against Oracle database. The schema creates a table called User which is a reserved keyword.
http://docs.oracle.com/cd/B19306_01/em.102/b40103/app_oracle_reserved_words.htm
Consequently, on startup gives 012-07-04 05:15:03,974 ERROR hbm2ddl.SchemaUpdate Unsuccessful: create table user (id number(19,0) not null, version number(19,0) not null, account_expired number(1,0) not null, account_locked number(1,0)
not null, enabled number(1,0) not null, "password" varchar2(255 char) not null, password_expired number(1,0) not null, username varchar2(255 char) not null unique, primary key (id)) 2012-07-04 05:15:03,974 ERROR hbm2ddl.SchemaUpdate ORA-00903: invalid table name
2012-07-04 05:15:03,975 ERROR hbm2ddl.SchemaUpdate Unsuccessful: alter table user_role add constraint FK143BF46A84DFE2B0 foreign key (user_id) references user 2012-07-04 05:15:03,975 ERROR hbm2ddl.SchemaUpdate ORA-00903: invalid table name
2012-07-04 05:15:03,976 ERROR hbm2ddl.SchemaUpdate Unsuccessful: alter table webhook add constraint FK48F4F67784DFE2B0 foreign key (user_id) references user 2012-07-04 05:15:03,976 ERROR hbm2ddl.SchemaUpdate ORA-00903: invalid table name
2012-07-04 05:15:10,469 ERROR util.JDBCExceptionReporter ORA-02289: sequence does not exist
2012-07-04 05:17:53,135 ERROR hbm2ddl.SchemaUpdate Unsuccessful: create table user (id number(19,0) not null, version number(19,0) not null, account_expired number(1,0) not null, account_locked number
(1,0) not null, enabled number(1,0) not null, "password" varchar2(255 char) not null, password_expired number(1,0) not null, username varchar2(255 char) not null unique, primary key (id)) 2012-07-04 05:17:53,135 ERROR hbm2ddl.SchemaUpdate ORA-00903: invalid table name
The table needs to be created with some other name for Yana2 to function against oracle.