Problem using bonita on Informix

View: New views
1 Messages — Rating Filter:   Alert me  

Problem using bonita on Informix

by lperea :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hello, i was able to run the "ant init-db" and the bonita-console on an informix db, but when i tried to deploy the SimpleWebSale.bar the console log show this error:

Hibernate: select dbinfo('serial8') from systables where tabid=1
Hibernate: insert into NOVA_XPDL_ACTIVITY (ACT_ID, JOIN_TYPE_, SPLIT_TYPE_, TYPE
_, PERFORMER_, MULTI_INST_CLASS_, MULTI_INST_VAR_, CLASS_) values (?, ?, ?, ?, ?
, ?, ?, 'xpdl::no-impl')
Hibernate: select dbinfo('serial8') from systables where tabid=1
Hibernate: insert into NOVA_ITER_DESCR values ( )
18.09.2009 18:40:26 *ERROR* [http-8080-4] JDBCExceptionReporter: A syntax error
has occurred. (JDBCExceptionReporter.java, line 78)
18/09/2009 06:40:26 PM org.ow2.bonita.pvm.internal.log.Log error
GRAVE: exception while executing command org.ow2.bonita.facade.APIInterceptor$AP
IInterceptorCommand@122a7b5
org.ow2.bonita.facade.exception.DeploymentException: could not insert: [org.ow2.
bonita.definition.activity.AbstractActivity$IterationDescriptor]cause:could not
insert: [org.ow2.bonita.definition.activity.AbstractActivity$IterationDescriptor
]
  at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67
)
  at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.jav
a:43)
  at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSel
ectingDelegate.java:40)
  at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntit
yPersister.java:2163)
  at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntit
yPersister.java:2643)
  at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInser
tAction.java:51)
  at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
  at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(Ab
stractSaveEventListener.java:298)
  at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveE
ventListener.java:181)
  at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(Abstr
actSaveEventListener.java:107)
  at org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(Defau
ltPersistEventListener.java:131)
  at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersis
tEventListener.java:87)
  at org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:609)
  at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:601)
  at org.hibernate.engine.CascadingAction$8.cascade(CascadingAction.java:295)
  at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:268)
  at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:216)
  at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
  at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:296)
  at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:242)
  at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:219)
  at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
  at org.hibernate.engine.Cascade.cascade(Cascade.java:130)
  at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(Abstract
SaveEventListener.java:456)
  at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(Ab
...
...


when i tryed the same using H2 DB everything worked fine.

but it doesn't work with informix



pd. I turn on the hibernate.show_sql and the level=ALL in loggin.properties