1 Reply Latest reply on Feb 10, 2006 7:38 AM by kurilenko

    ORacle + JBPM

      I am unablecreate schema on Oracle .

      jbpmSchema = new JbpmSchema(configuration);
      jbpmSchema.createSchema();
      


      it generate this sql - it is incorrect sql. Any suggestion be good.

      My cfg looks like this
      <property name="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</property>
       <property name="hibernate.connection.driver_class">
       oracle.jdbc.driver.OracleDriver</property>
      


      create table JBPM_ACTION (ID_ number(19,0) not null,
      class char(1 char) not null, NAME_ varchar2(255 char),
      ISPROPAGATIONALLOWED_ number(1,0),
      REFERENCEDACTION_ number(19,0),
      ACTIONDELEGATION_ number(19,0),
      EVENT_ number(19,0), PROCESSDEFINITION_ number(19,0),
      EXPRESSION_ varchar2(4000 char), TIMERNAME_ varchar2(255 char),
      DUEDATE_ varchar2(255 char), REPEAT_ varchar2(255 char),
      TRANSITIONNAME_ varchar2(255 char), TIMERACTION_ number(19,0),
      EVENTINDEX_ number(10,0), EXCEPTIONHANDLER_ number(19,0), EXCEPTIONHANDLERINDEX_ number(10,0),
      primary key (ID_));