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
-- Apache ODE - SimpleScheduler Database Schema -- -- Apache Derby scripts by Maciej Szefler. -- -- CREATE TABLE ode_job ( jobid VARCHAR(64) NOT NULL, ts number(37) NOT NULL, nodeid varchar(64), scheduled int NOT NULL, transacted int NOT NULL, details blob, 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 number(19,0) not null, PIID number(19,0), AID number(19,0), CHANNEL varchar2(255 char), REASON varchar2(255 char), DATE_TIME timestamp, LDATA_ID number(19,0), ACTIONS varchar2(255 char), RETRIES number(10,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); create table BPEL_CORRELATION_PROP (ID number(19,0) not null, NAME varchar2(255 char), NAMESPACE varchar2(255 char), VALUE varchar2(255 char), CORR_SET_ID number(19,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); create table BPEL_CORRELATION_SET (ID number(19,0) not null, VALUE varchar2(255 char), CORR_SET_NAME varchar2(255 char), SCOPE_ID number(19,0), PIID number(19,0), PROCESS_ID number(19,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); create table BPEL_CORRELATOR (ID number(19,0) not null, CID varchar2(255 char), PROCESS_ID number(19,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); create table BPEL_CORRELATOR_MESSAGE_CKEY (ID number(19,0) not null, CKEY varchar2(255 char), CORRELATOR_MESSAGE_ID number(19,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); create table BPEL_EVENT (ID number(19,0) not null, IID number(19,0), PID number(19,0), TSTAMP timestamp, TYPE varchar2(255 char), DETAIL clob, LDATA_ID number(19,0), SID number(19,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); create table BPEL_FAULT (ID number(19,0) not null, FAULTNAME varchar2(255 char), LDATA_ID number(19,0), EXPLANATION varchar2(4000 char), LINE_NUM number(10,0), AID number(10,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); create table BPEL_INSTANCE (ID number(19,0) not null, INSTANTIATING_CORRELATOR number(19,0), FAULT number(19,0), JACOB_STATE number(19,0), PREVIOUS_STATE number(5,0), PROCESS_ID number(19,0), STATE number(5,0), LAST_ACTIVE_DT timestamp, SEQUENCE number(19,0), FAILURE_COUNT number(10,0), FAILURE_DT timestamp, INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); create table BPEL_MESSAGE (ID number(19,0) not null, MEX number(19,0), TYPE varchar2(255 char), DATA number(19,0), HEADER number(19,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); create table BPEL_MESSAGE_EXCHANGE (ID number(19,0) not null, PORT_TYPE varchar2(255 char), CHANNEL_NAME varchar2(255 char), CLIENTKEY varchar2(255 char), LDATA_EPR_ID number(19,0), LDATA_CEPR_ID number(19,0), REQUEST number(19,0), RESPONSE number(19,0), INSERT_DT timestamp, OPERATION varchar2(255 char), STATE varchar2(255 char), PROCESS number(19,0), PIID number(19,0), DIR char(1 char), PLINK_MODELID number(10,0), PATTERN varchar2(255 char), CORR_STATUS varchar2(255 char), FAULT_TYPE varchar2(255 char), FAULT_EXPL varchar2(255 char), CALLEE varchar2(255 char), PARTNERLINK number(19,0), PIPED_ID varchar2(255 char), SUBSCRIBER_COUNT number(10,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); create table BPEL_MEX_PROPS (MEX number(19,0) not null, VALUE long, NAME varchar2(255 char) not null, primary key (MEX, NAME)); create table BPEL_PLINK_VAL (ID number(19,0) not null, PARTNER_LINK varchar2(100 char) not null, PARTNERROLE varchar2(100 char), MYROLE_EPR number(19,0), PARTNERROLE_EPR number(19,0), PROCESS number(19,0), SCOPE number(19,0), SVCNAME varchar2(255 char), MYROLE varchar2(100 char), MODELID number(10,0), MYSESSIONID varchar2(255 char), PARTNERSESSIONID varchar2(255 char), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); create table BPEL_PROCESS (ID number(19,0) not null, PROCID varchar2(255 char) not null unique, deployer varchar2(255 char), deploydate timestamp, type_name varchar2(255 char), type_ns varchar2(255 char), version number(19,0), ACTIVE_ number(1,0), guid varchar2(255 char), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); create table BPEL_SCOPE (ID number(19,0) not null, PIID number(19,0), PARENT_SCOPE_ID number(19,0), STATE varchar2(255 char) not null, NAME varchar2(255 char) not null, MODELID number(10,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); create table BPEL_SELECTORS (ID number(19,0) not null, PIID number(19,0) not null, SELGRPID varchar2(255 char) not null, IDX number(10,0) not null, CORRELATION_KEY varchar2(255 char) not null, PROC_TYPE varchar2(255 char) not null, ROUTE_POLICY varchar2(255 char), CORRELATOR number(19,0) not null, INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID), unique (CORRELATION_KEY, CORRELATOR)); create table BPEL_UNMATCHED (ID number(19,0) not null, MEX number(19,0), CORRELATION_KEY varchar2(255 char), CORRELATOR number(19,0) not null, INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); create table BPEL_XML_DATA (ID number(19,0) not null, LDATA_ID number(19,0), NAME varchar2(255 char) not null, SCOPE_ID number(19,0), PIID number(19,0), IS_SIMPLE_TYPE number(1,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); create table LARGE_DATA (ID number(19,0) not null, BIN_DATA blob, INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); create table VAR_PROPERTY (ID number(19,0) not null, XML_DATA_ID number(19,0), PROP_VALUE varchar2(255 char), PROP_NAME varchar2(255 char) not null, INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); create index IDX_CORRELATOR_CID on BPEL_CORRELATOR (CID); create index IDX_CKEYxx on BPEL_CORRELATOR_MESSAGE_CKEY (CKEY); 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); create index IDX_UNMATCHED_CKEY on BPEL_UNMATCHED (CORRELATION_KEY); create index IDX_UNMATCHED_CORRELATOR on BPEL_UNMATCHED (CORRELATOR); create sequence hibernate_sequence; create table STORE_DU (NAME varchar(255) not null, deployer varchar(255), DEPLOYDT timestamp, DIR varchar(255), primary key (NAME)); create table STORE_PROCESS (PID varchar(255) not null, DU varchar(255), TYPE varchar(255), version number(34), STATE varchar(255), primary key (PID)); create table STORE_PROCESS_PROP (propId varchar(255) not null, value varchar(255), name varchar(255) not null, primary key (propId, name)); create table STORE_VERSIONS (ID integer not null, VERSION number(34), primary key (ID));
