Also there are some issues with MS SQL Server. I have attached the correct sql scripts(Hibernate).
Thanks, Milinda On Sat, Feb 21, 2009 at 3:37 AM, Rafal Rusin <[email protected]> wrote: > I've got current version of scripts for Oracle + Hibernate for ODE1X. > Here they are. > > Regards, > > 2009/2/20 Matthieu Riou <[email protected]>: > > On Fri, Feb 20, 2009 at 10:48 AM, Andi Abes <[email protected]> wrote: > > > >> > >> Spoke too soon... > >> > >> 7141 [main] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - > >> Unsuccessful: create table LARGE_DATA (ID number(19,0) not null, > >> BIN_DATA blob(2G), INSERT_TIME time > >> stamp, MLOCK number(10,0) not null, primary key (ID)) > >> 7141 [main] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - ORA-00907: > >> missing right parenthesis > >> > >> > >> Is there an sql script to create the tables as Hibernate likes on > >> oracle? > >> > > > > There's one under dao-hibernate-db/target after a build. You only have to > > change the blob declarations to make Oracle happy (just remove the (2G) > part > > IIRC). Problem is, there's no mapping type declaration that will work > > correctly for all DBs... > > > > Matthieu > > > > > >> > >> > >> > >> > -----Original Message----- > >> > From: Andi Abes [mailto:[email protected]] > >> > Sent: Friday, February 20, 2009 1:24 PM > >> > To: [email protected] > >> > Subject: RE: [LIKELY JUNK]Re: Oracle + Hibernate > >> > > >> > Yup. You're right. > >> > > >> > Adding > >> > hibernate.hbm2ddl.auto = update > >> > > >> > to config resolved the issue. > >> > > >> > A. > >> > > >> > > -----Original Message----- > >> > > From: Alex Boisvert [mailto:[email protected]] > >> > > Sent: Friday, February 20, 2009 1:21 PM > >> > > To: [email protected] > >> > > Subject: [LIKELY JUNK]Re: Oracle + Hibernate > >> > > > >> > > I'm guessing you used the database schema for JPA instead of the > >> > Hibernate > >> > > one. They are different. > >> > > > >> > > alex > >> > > > >> > > > >> > > On Fri, Feb 20, 2009 at 10:16 AM, Andi Abes <[email protected]> > >> > wrote: > >> > > > >> > > > Seems that Oracle 10g and the hibernate mapping for ODE are a bit > >> at > >> > > > odds: > >> > > > > >> > > > > >> > > > > >> > > > 9031 [ProcessStoreImpl-1] WARN > >> > org.hibernate.util.JDBCExceptionReporter > >> > > > - SQL Error: 904, SQLState: 42000 > >> > > > > >> > > > 9031 [ProcessStoreImpl-1] ERROR > >> > org.hibernate.util.JDBCExceptionReporter > >> > > > - ORA-00904: "PROPERTIES0_"."PROPID": invalid identifier > >> > > > > >> > > > > >> > > > > >> > > > > >> > > > > >> > > > Caused by: java.util.concurrent.ExecutionException: > >> > > > org.hibernate.exception.SQLGrammarException: could not initialize > >> a > >> > > > collection: > >> > > > > >> > > > > >> > > >> [org.apache.ode.store.hib.ProcessConfDaoImpl.properties_#{urn:bpel:BpelM > >> > > > ock}BPELMock-2] > >> > > > > >> > > > at > >> > > > java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:205) > >> > > > > >> > > > > >> > > > > >> > > > > >> > > > > >> > > > This ode 1.2 with the following configuration: > >> > > > > >> > > > > >> > > >> ode-axis2.dao.factory=org.apache.ode.daohib.bpel.BpelDAOConnectionFactor > >> > > > yImpl > >> > > > > >> > > > org.hibernate.dialect.Dialect=org.hibernate.dialect.Oracle9Dialect > >> > > > > >> > > > > >> > > > > >> > > > Any pointers? > >> > > > > >> > > > > >> > > > > >> > > > > >> > > > > > > -- > Rafał Rusin > www.mimuw.edu.pl/~rrusin <http://www.mimuw.edu.pl/%7Errusin> > -- http://mpathirage.com http://wso2.org "Oxygen for Web Service Developers" http://wsaxc.blogspot.com "Web Services With Axis2/C"
CREATE TABLE ode_job ( jobid CHAR(64) NOT NULL DEFAULT '', ts BIGINT NOT NULL DEFAULT 0, nodeid char(64), scheduled int NOT NULL DEFAULT 0, transacted int NOT NULL DEFAULT 0, details varbinary(4096), PRIMARY KEY(jobid)); CREATE INDEX IDX_ODE_JOB_TS ON ode_job(ts); CREATE INDEX IDX_ODE_JOB_NODEID ON ode_job(nodeid); create table BPEL_ACTIVITY_RECOVERY (ID numeric(19,0) identity not null, PIID numeric(19,0) null, AID numeric(19,0) null, CHANNEL varchar(255) null, REASON varchar(255) null, DATE_TIME datetime null, LDATA_ID numeric(19,0) null, ACTIONS varchar(255) null, RETRIES int null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); create table BPEL_CORRELATION_PROP (ID numeric(19,0) identity not null, NAME varchar(255) null, NAMESPACE varchar(255) null, VALUE varchar(255) null, CORR_SET_ID numeric(19,0) null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); create table BPEL_CORRELATION_SET (ID numeric(19,0) identity not null, VALUE varchar(255) null, CORR_SET_NAME varchar(255) null, SCOPE_ID numeric(19,0) null, PIID numeric(19,0) null, PROCESS_ID numeric(19,0) null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); create table BPEL_CORRELATOR (ID numeric(19,0) identity not null, CID varchar(255) null, PROCESS_ID numeric(19,0) null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); create table BPEL_CORRELATOR_MESSAGE_CKEY (ID numeric(19,0) identity not null, CKEY varchar(255) null, CORRELATOR_MESSAGE_ID numeric(19,0) null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); create table BPEL_EVENT (ID numeric(19,0) identity not null, IID numeric(19,0) null, PID numeric(19,0) null, TSTAMP datetime null, TYPE varchar(255) null, DETAIL text null, LDATA_ID numeric(19,0) null, SID numeric(19,0) null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); create table BPEL_FAULT (ID numeric(19,0) identity not null, FAULTNAME varchar(255) null, LDATA_ID numeric(19,0) null, EXPLANATION varchar(4000) null, LINE_NUM int null, AID int null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); create table BPEL_INSTANCE (ID numeric(19,0) identity not null, INSTANTIATING_CORRELATOR numeric(19,0) null, FAULT numeric(19,0) null, JACOB_STATE numeric(19,0) null, PREVIOUS_STATE smallint null, PROCESS_ID numeric(19,0) null, STATE smallint null, LAST_ACTIVE_DT datetime null, SEQUENCE numeric(19,0) null, FAILURE_COUNT int null, FAILURE_DT datetime null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); create table BPEL_MESSAGE (ID numeric(19,0) identity not null, MEX numeric(19,0) null, TYPE varchar(255) null, DATA numeric(19,0) null, HEADER numeric(19,0) null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); create table BPEL_MESSAGE_EXCHANGE (ID numeric(19,0) identity not null, PORT_TYPE varchar(255) null, CHANNEL_NAME varchar(255) null, CLIENTKEY varchar(255) null, LDATA_EPR_ID numeric(19,0) null, LDATA_CEPR_ID numeric(19,0) null, REQUEST numeric(19,0) null, RESPONSE numeric(19,0) null, INSERT_DT datetime null, OPERATION varchar(255) null, STATE varchar(255) null, PROCESS numeric(19,0) null, PIID numeric(19,0) null, DIR char(1) null, PLINK_MODELID int null, PATTERN varchar(255) null, CORR_STATUS varchar(255) null, FAULT_TYPE varchar(255) null, FAULT_EXPL varchar(255) null, CALLEE varchar(255) null, PARTNERLINK numeric(19,0) null, PIPED_ID varchar(255) null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); create table BPEL_MEX_PROPS (MEX numeric(19,0) not null, VALUE varchar(8000) null, NAME varchar(255) not null, primary key (MEX, NAME)); create table BPEL_PLINK_VAL (ID numeric(19,0) identity not null, PARTNER_LINK varchar(100) not null, PARTNERROLE varchar(100) null, MYROLE_EPR numeric(19,0) null, PARTNERROLE_EPR numeric(19,0) null, PROCESS numeric(19,0) null, SCOPE numeric(19,0) null, SVCNAME varchar(255) null, MYROLE varchar(100) null, MODELID int null, MYSESSIONID varchar(255) null, PARTNERSESSIONID varchar(255) null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); create table BPEL_PROCESS (ID numeric(19,0) identity not null, PROCID varchar(255) not null unique, deployer varchar(255) null, deploydate datetime null, type_name varchar(255) null, type_ns varchar(255) null, version numeric(19,0) null, ACTIVE_ tinyint null, guid varchar(255) null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); create table BPEL_SCOPE (ID numeric(19,0) identity not null, PIID numeric(19,0) null, PARENT_SCOPE_ID numeric(19,0) null, STATE varchar(255) not null, NAME varchar(255) not null, MODELID int null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); create table BPEL_SELECTORS (ID numeric(19,0) identity not null, PIID numeric(19,0) not null, SELGRPID varchar(255) not null, IDX int not null, CORRELATION_KEY varchar(255) not null, PROC_TYPE varchar(255) not null, CORRELATOR numeric(19,0) not null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID), unique (CORRELATION_KEY, CORRELATOR)); create table BPEL_UNMATCHED (ID numeric(19,0) identity not null, MEX numeric(19,0) null, CORRELATION_KEY varchar(255) null, CORRELATOR numeric(19,0) not null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); create table BPEL_XML_DATA (ID numeric(19,0) identity not null, LDATA_ID numeric(19,0) null, NAME varchar(255) not null, SCOPE_ID numeric(19,0) null, PIID numeric(19,0) null, IS_SIMPLE_TYPE tinyint null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); create table LARGE_DATA (ID numeric(19,0) identity not null, BIN_DATA image null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); create table VAR_PROPERTY (ID numeric(19,0) identity not null, XML_DATA_ID numeric(19,0) null, PROP_VALUE varchar(255) null, PROP_NAME varchar(255) not null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); alter table BPEL_ACTIVITY_RECOVERY add constraint FK94D24A7B14020712 foreign key (LDATA_ID) references LARGE_DATA; alter table BPEL_ACTIVITY_RECOVERY add constraint FK94D24A7BA821BBE1 foreign key (PIID) references BPEL_INSTANCE; alter table BPEL_CORRELATION_PROP add constraint FK4EC9DDAA4D0B7982 foreign key (CORR_SET_ID) references BPEL_CORRELATION_SET; alter table BPEL_CORRELATION_SET add constraint FKB838191BA821BBE1 foreign key (PIID) references BPEL_INSTANCE; alter table BPEL_CORRELATION_SET add constraint FKB838191B6D49C363 foreign key (SCOPE_ID) references BPEL_SCOPE; alter table BPEL_CORRELATION_SET add constraint FKB838191BE15A2343 foreign key (PROCESS_ID) references BPEL_PROCESS; create index IDX_CORRELATOR_CID on BPEL_CORRELATOR (CID); alter table BPEL_CORRELATOR add constraint FKF50EFA33E15A2343 foreign key (PROCESS_ID) references BPEL_PROCESS; create index IDX_BPEL_CORRELATOR_MESSAGE_CKEY on BPEL_CORRELATOR_MESSAGE_CKEY (CKEY); alter table BPEL_CORRELATOR_MESSAGE_CKEY add constraint FK8997F700EEFA7470 foreign key (CORRELATOR_MESSAGE_ID) references BPEL_UNMATCHED; alter table BPEL_EVENT add constraint FKAA6D673014020712 foreign key (LDATA_ID) references LARGE_DATA; alter table BPEL_EVENT add constraint FKAA6D6730A7EED251 foreign key (IID) references BPEL_INSTANCE; alter table BPEL_EVENT add constraint FKAA6D6730C831CBE3 foreign key (PID) references BPEL_PROCESS; alter table BPEL_FAULT add constraint FKAA722EB814020712 foreign key (LDATA_ID) references LARGE_DATA; alter table BPEL_INSTANCE add constraint FKE1DED41FDD43DBE1 foreign key (INSTANTIATING_CORRELATOR) references BPEL_CORRELATOR; alter table BPEL_INSTANCE add constraint FKE1DED41F6B66C85F foreign key (JACOB_STATE) references LARGE_DATA; alter table BPEL_INSTANCE add constraint FKE1DED41F1F3C9CB7 foreign key (FAULT) references BPEL_FAULT; alter table BPEL_INSTANCE add constraint FKE1DED41FE15A2343 foreign key (PROCESS_ID) references BPEL_PROCESS; alter table BPEL_MESSAGE add constraint FK4FA7231DCA00A413 foreign key (MEX) references BPEL_MESSAGE_EXCHANGE; alter table BPEL_MESSAGE add constraint FK4FA7231DEB2C9ED8 foreign key (DATA) references LARGE_DATA; alter table BPEL_MESSAGE add constraint FK4FA7231DA23291BB foreign key (HEADER) references LARGE_DATA; alter table BPEL_MESSAGE_EXCHANGE add constraint FKBDA6BD0589D7A75B foreign key (LDATA_CEPR_ID) references LARGE_DATA; alter table BPEL_MESSAGE_EXCHANGE add constraint FKBDA6BD05BBA250D foreign key (PARTNERLINK) references BPEL_PLINK_VAL; alter table BPEL_MESSAGE_EXCHANGE add constraint FKBDA6BD05A821BBE1 foreign key (PIID) references BPEL_INSTANCE; alter table BPEL_MESSAGE_EXCHANGE add constraint FKBDA6BD05C29670AA foreign key (LDATA_EPR_ID) references LARGE_DATA; alter table BPEL_MESSAGE_EXCHANGE add constraint FKBDA6BD05B5BD38C7 foreign key (PROCESS) references BPEL_PROCESS; alter table BPEL_MESSAGE_EXCHANGE add constraint FKBDA6BD05FF451031 foreign key (RESPONSE) references BPEL_MESSAGE; alter table BPEL_MESSAGE_EXCHANGE add constraint FKBDA6BD0554DCEE7F foreign key (REQUEST) references BPEL_MESSAGE; alter table BPEL_MEX_PROPS add constraint FK203CAFC7CA00A413 foreign key (MEX) references BPEL_MESSAGE_EXCHANGE; alter table BPEL_PLINK_VAL add constraint FK7D71E742F2BC5EB8 foreign key (MYROLE_EPR) references LARGE_DATA; alter table BPEL_PLINK_VAL add constraint FK7D71E74290D95ED1 foreign key (SCOPE) references BPEL_SCOPE; alter table BPEL_PLINK_VAL add constraint FK7D71E742B5BD38C7 foreign key (PROCESS) references BPEL_PROCESS; alter table BPEL_PLINK_VAL add constraint FK7D71E742D4B651D4 foreign key (PARTNERROLE_EPR) references LARGE_DATA; alter table BPEL_SCOPE add constraint FKAB2A32EAA821BBE1 foreign key (PIID) references BPEL_INSTANCE; alter table BPEL_SCOPE add constraint FKAB2A32EA42B20B58 foreign key (PARENT_SCOPE_ID) references BPEL_SCOPE; create index IDX_SELECTOR_CORRELATOR on BPEL_SELECTORS (CORRELATOR); create index IDX_SELECTOR_CKEY on BPEL_SELECTORS (CORRELATION_KEY); create index IDX_SELECTOR_SELGRPID on BPEL_SELECTORS (SELGRPID); alter table BPEL_SELECTORS add constraint FKF1F83A0AA821BBE1 foreign key (PIID) references BPEL_INSTANCE; alter table BPEL_SELECTORS add constraint FKF1F83A0A875201C9 foreign key (CORRELATOR) references BPEL_CORRELATOR; create index IDX_UNMATCHED_CKEY on BPEL_UNMATCHED (CORRELATION_KEY); create index IDX_UNMATCHED_CORRELATOR on BPEL_UNMATCHED (CORRELATOR); alter table BPEL_UNMATCHED add constraint FKF0663E01CA00A413 foreign key (MEX) references BPEL_MESSAGE_EXCHANGE; alter table BPEL_UNMATCHED add constraint FKF0663E01875201C9 foreign key (CORRELATOR) references BPEL_CORRELATOR; alter table BPEL_XML_DATA add constraint FKB7D47E7C14020712 foreign key (LDATA_ID) references LARGE_DATA; alter table BPEL_XML_DATA add constraint FKB7D47E7CA821BBE1 foreign key (PIID) references BPEL_INSTANCE; alter table BPEL_XML_DATA add constraint FKB7D47E7C6D49C363 foreign key (SCOPE_ID) references BPEL_SCOPE; alter table VAR_PROPERTY add constraint FK9C1E2C0DA48E25F2 foreign key (XML_DATA_ID) references BPEL_XML_DATA;
