ode-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matthieu Riou <matthieu.r...@gmail.com>
Subject Re: Oracle + Hibernate
Date Fri, 20 Feb 2009 21:34:12 GMT
On Fri, Feb 20, 2009 at 10:48 AM, Andi Abes <aabes@progress.com> 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:aabes@progress.com]
> > Sent: Friday, February 20, 2009 1:24 PM
> > To: user@ode.apache.org
> > 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:boisvert@intalio.com]
> > > Sent: Friday, February 20, 2009 1:21 PM
> > > To: user@ode.apache.org
> > > 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 <aabes@progress.com>
> > 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?
> > > >
> > > >
> > > >
> > > >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message