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? > -----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? > > > > > > > > > > > >
