Oracle data types

[nat]

Hello Vitaliy:

I still have problems with the inicialization of the Runa DB in Oracle. Finally I can change the large names of the indexes that cause the problem "too large indentifier".
Runa creates the schema sucessfully in Oracle 10g but for some reason can't insert values in executors, secured_objects, secured_object_types

Do you know if there is a problem with the data types in Oracle? I found this in the Jboss JBPM forum: http://www.jboss.com/products/jbpm/docs/faq

This is the log. I will appreciate any help or comments.

2007-03-23 01:07:39,796 INFO  [org.apache.catalina.startup.Embedded] Catalina naming disabled
2007-03-23 01:07:40,312 INFO  [org.apache.coyote.http11.Http11Protocol] Inicializando Coyote HTTP/1.1 en puerto http-localhost%2F127.0.0.1-8080
2007-03-23 01:07:40,312 INFO  [org.apache.catalina.startup.Catalina] Initialization processed in 437 ms
2007-03-23 01:07:40,312 INFO  [org.apache.catalina.core.StandardEngine] Starting Servlet Engine: Apache Tomcat/5.0.30
2007-03-23 01:07:40,343 INFO  [org.apache.catalina.core.StandardHost] XML validation disabled
2007-03-23 01:07:40,359 INFO  [org.apache.catalina.startup.Catalina] Server startup in 47 ms
2007-03-23 01:07:40,515 DEBUG [tomcat.localhost./invoker.Context] Starting tomcat.localhost./invoker.Context
2007-03-23 01:07:40,531 DEBUG [tomcat.localhost./invoker.Context] Configuring default Resources
2007-03-23 01:07:40,671 DEBUG [tomcat.localhost./invoker.Context] Processing standard container startup
2007-03-23 01:07:40,750 DEBUG [tomcat.localhost./invoker.Context] Setting deployment descriptor public ID to '-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN'
2007-03-23 01:07:40,843 DEBUG [tomcat.localhost./invoker.Context] Setting deployment descriptor public ID to '-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN'
2007-03-23 01:07:41,125 DEBUG [tomcat.localhost./invoker.Context] Posting standard context attributes
2007-03-23 01:07:41,140 DEBUG [tomcat.localhost./invoker.Context] Configuring application event listeners
2007-03-23 01:07:41,140 DEBUG [tomcat.localhost./invoker.Context] Sending application start events
2007-03-23 01:07:41,140 DEBUG [tomcat.localhost./invoker.Context] Starting filters
2007-03-23 01:07:41,140 DEBUG [tomcat.localhost./invoker.Context]  Starting filter 'CommonHeadersFilter'
2007-03-23 01:07:41,140 DEBUG [tomcat.localhost./invoker.Context]  Starting filter 'ReadOnlyAccessFilter'
2007-03-23 01:07:41,312 DEBUG [tomcat.localhost./invoker.Context] Starting completed
2007-03-23 01:07:41,312 DEBUG [tomcat.localhost./invoker.Context] Checking for jboss.web:j2eeType=WebModule,name=//localhost/invoker,J2EEApplication=none,J2EEServer=none
2007-03-23 01:07:41,484 DEBUG [tomcat.localhost.ROOT.Context] Starting tomcat.localhost.ROOT.Context
2007-03-23 01:07:41,484 DEBUG [tomcat.localhost.ROOT.Context] Configuring default Resources
2007-03-23 01:07:41,484 DEBUG [tomcat.localhost.ROOT.Context] No realm for this host null
2007-03-23 01:07:41,500 DEBUG [tomcat.localhost.ROOT.Context] Processing standard container startup
2007-03-23 01:07:41,515 DEBUG [tomcat.localhost.ROOT.Context] Setting deployment descriptor public ID to '-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN'
2007-03-23 01:07:41,578 DEBUG [tomcat.localhost.ROOT.Context] Setting deployment descriptor public ID to '-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN'
2007-03-23 01:07:41,593 DEBUG [tomcat.localhost.ROOT.Context] Posting standard context attributes
2007-03-23 01:07:41,593 DEBUG [tomcat.localhost.ROOT.Context] Configuring application event listeners
2007-03-23 01:07:41,593 DEBUG [tomcat.localhost.ROOT.Context] Sending application start events
2007-03-23 01:07:41,593 DEBUG [tomcat.localhost.ROOT.Context] Starting filters
2007-03-23 01:07:41,593 DEBUG [tomcat.localhost.ROOT.Context]  Starting filter 'CommonHeadersFilter'
2007-03-23 01:07:41,593 DEBUG [tomcat.localhost.ROOT.Context] Starting completed
2007-03-23 01:07:41,593 DEBUG [tomcat.localhost.ROOT.Context] Checking for jboss.web:j2eeType=WebModule,name=//localhost/,J2EEApplication=none,J2EEServer=none
2007-03-23 01:07:41,812 DEBUG [tomcat.localhost./jbossmq-httpil.Context] Starting tomcat.localhost./jbossmq-httpil.Context
2007-03-23 01:07:41,828 DEBUG [tomcat.localhost./jbossmq-httpil.Context] Configuring default Resources
2007-03-23 01:07:41,843 DEBUG [tomcat.localhost./jbossmq-httpil.Context] Processing standard container startup
2007-03-23 01:07:41,875 DEBUG [tomcat.localhost./jbossmq-httpil.Context] Setting deployment descriptor public ID to '-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN'
2007-03-23 01:07:41,906 DEBUG [tomcat.localhost./jbossmq-httpil.Context] Setting deployment descriptor public ID to '-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN'
2007-03-23 01:07:41,921 DEBUG [tomcat.localhost./jbossmq-httpil.Context] Posting standard context attributes
2007-03-23 01:07:41,921 DEBUG [tomcat.localhost./jbossmq-httpil.Context] Configuring application event listeners
2007-03-23 01:07:41,921 DEBUG [tomcat.localhost./jbossmq-httpil.Context] Sending application start events
2007-03-23 01:07:41,921 DEBUG [tomcat.localhost./jbossmq-httpil.Context] Starting filters
2007-03-23 01:07:41,921 DEBUG [tomcat.localhost./jbossmq-httpil.Context]  Starting filter 'CommonHeadersFilter'
2007-03-23 01:07:41,921 DEBUG [tomcat.localhost./jbossmq-httpil.Context] Starting completed
2007-03-23 01:07:41,921 DEBUG [tomcat.localhost./jbossmq-httpil.Context] Checking for jboss.web:j2eeType=WebModule,name=//localhost/jbossmq-httpil,J2EEApplication=none,J2EEServer=none
2007-03-23 01:07:50,453 DEBUG [tomcat.localhost./web-console.Context] Starting tomcat.localhost./web-console.Context
2007-03-23 01:07:50,453 DEBUG [tomcat.localhost./web-console.Context] Configuring default Resources
2007-03-23 01:07:50,453 DEBUG [tomcat.localhost./web-console.Context] Processing standard container startup
2007-03-23 01:07:50,468 DEBUG [tomcat.localhost./web-console.Context] Setting deployment descriptor public ID to '-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN'
2007-03-23 01:07:50,484 DEBUG [tomcat.localhost./web-console.Context] Setting deployment descriptor public ID to '-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN'
2007-03-23 01:07:50,500 DEBUG [tomcat.localhost./web-console.Context] Posting standard context attributes
2007-03-23 01:07:50,500 DEBUG [tomcat.localhost./web-console.Context] Configuring application event listeners
2007-03-23 01:07:50,500 DEBUG [tomcat.localhost./web-console.Context] Sending application start events
2007-03-23 01:07:50,500 DEBUG [tomcat.localhost./web-console.Context] Starting filters
2007-03-23 01:07:50,500 DEBUG [tomcat.localhost./web-console.Context]  Starting filter 'CommonHeadersFilter'
2007-03-23 01:07:50,750 DEBUG [tomcat.localhost./web-console.Context] Starting completed
2007-03-23 01:07:50,750 DEBUG [tomcat.localhost./web-console.Context] Checking for jboss.web:j2eeType=WebModule,name=//localhost/web-console,J2EEApplication=none,J2EEServer=none
2007-03-23 01:07:54,078 DEBUG [tomcat.localhost./wfe.Context] Starting tomcat.localhost./wfe.Context
2007-03-23 01:07:54,078 DEBUG [tomcat.localhost./wfe.Context] Configuring default Resources
2007-03-23 01:07:54,093 DEBUG [tomcat.localhost./wfe.Context] Processing standard container startup
2007-03-23 01:07:54,125 DEBUG [tomcat.localhost./wfe.Context] Setting deployment descriptor public ID to '-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN'
2007-03-23 01:07:54,156 DEBUG [tomcat.localhost./wfe.Context] Setting deployment descriptor public ID to 'null'
2007-03-23 01:07:54,265 DEBUG [tomcat.localhost./wfe.Context] Posting standard context attributes
2007-03-23 01:07:54,265 DEBUG [tomcat.localhost./wfe.Context] Configuring application event listeners
2007-03-23 01:07:54,265 DEBUG [tomcat.localhost./wfe.Context]  Configuring event listener class 'ru.runa.wf.web.servlet.InitializerServletContextListener'
2007-03-23 01:07:54,281 DEBUG [tomcat.localhost./wfe.Context] Sending application start events
2007-03-23 01:07:54,281 INFO  [ru.runa.wf.web.servlet.InitializerServletContextListener] initialization started
2007-03-23 01:07:54,468 INFO  [STDOUT] ------>>>°°°°°°°Hibernate
2007-03-23 01:07:57,093 INFO  [STDOUT] Hibernate: select this.ID as ID0_, this.NAME as NAME0_, this.VALUE as VALUE0_ from WFE_CONSTANTS this where this.NAME=?
2007-03-23 01:07:57,109 INFO  [STDOUT] °°°°°°°°°°°°°°°°BD Inicializada
2007-03-23 01:07:57,109 INFO  [ru.runa.wf.web.servlet.InitializerServletContextListener] database is not initialized. initializing...
2007-03-23 01:07:57,109 INFO  [STDOUT] °°°°°°°°°°°°°°°°BD Init
2007-03-23 01:07:57,140 INFO  [STDOUT] alter table BATCH_PRESENTATIONS drop constraint FK48783814DB317F91
2007-03-23 01:07:57,171 INFO  [STDOUT] alter table JBPM_DEFINITION drop constraint FK2F4CEE9D66309C76
2007-03-23 01:07:57,203 INFO  [STDOUT] alter table JBPM_DEFINITION drop constraint FK2F4CEE9DC3893553
2007-03-23 01:07:57,218 INFO  [STDOUT] alter table JBPM_DEFINITION drop constraint FK2F4CEE9DA1927D4F
2007-03-23 01:07:57,250 INFO  [STDOUT] alter table SORTED_FIELDS drop constraint FK38F1CA7BB4AB93B
2007-03-23 01:07:57,281 INFO  [STDOUT] alter table EXECUTOR_GROUP_RELATIONS drop constraint FKD66B5C8B658C7007
2007-03-23 01:07:57,312 INFO  [STDOUT] alter table EXECUTOR_GROUP_RELATIONS drop constraint FKD66B5C8B4CD4DEFB
2007-03-23 01:07:57,343 INFO  [STDOUT] alter table CRITERIA_CONDITIONS drop constraint FK7D91A798BC3317B4
2007-03-23 01:07:57,359 INFO  [STDOUT] alter table SORTING_MODES drop constraint FKCE1FAC75B4AB93B
2007-03-23 01:07:57,390 INFO  [STDOUT] alter table PERMISSION_MAPPINGS drop constraint FKF10C09D5658C7007
2007-03-23 01:07:57,406 INFO  [STDOUT] alter table PERMISSION_MAPPINGS drop constraint FKF10C09D5709DC009
2007-03-23 01:07:57,468 INFO  [STDOUT] alter table FILTER_CRITERIAS drop constraint FKC6A7E0CDB4AB93B
2007-03-23 01:07:57,500 INFO  [STDOUT] alter table JBPM_VARIABLE drop constraint FKD8CB5A4669B5865
2007-03-23 01:07:57,515 INFO  [STDOUT] alter table JBPM_VARIABLE drop constraint FKD8CB5A46C3893553
2007-03-23 01:07:57,546 INFO  [STDOUT] alter table PASSED_TRANSITIONS drop constraint FK522DAC4F84581845
2007-03-23 01:07:57,578 INFO  [STDOUT] alter table PASSED_TRANSITIONS drop constraint FK522DAC4FCF0F2F15
2007-03-23 01:07:57,609 INFO  [STDOUT] alter table DISPLAY_FIELDS drop constraint FK6DD5B0F6B4AB93B
2007-03-23 01:07:57,640 INFO  [STDOUT] alter table JBPM_TYPE drop constraint FKB48F940452D4AD28
2007-03-23 01:07:57,671 INFO  [STDOUT] alter table JBPM_TYPE drop constraint FKB48F9404C3893553
2007-03-23 01:07:57,703 INFO  [STDOUT] alter table JBPM_NODE drop constraint FKB48CB2CCFA8C2074
2007-03-23 01:07:57,718 INFO  [STDOUT] alter table JBPM_NODE drop constraint FKB48CB2CCF41BD495
2007-03-23 01:07:57,750 INFO  [STDOUT] alter table JBPM_NODE drop constraint FKB48CB2CC52D4AD28
2007-03-23 01:07:57,843 INFO  [STDOUT] alter table JBPM_NODE drop constraint FKB48CB2CCC3893553
2007-03-23 01:07:57,890 INFO  [STDOUT] alter table JBPM_NODE drop constraint FKB48CB2CCF41DA4FD
2007-03-23 01:07:57,921 INFO  [STDOUT] alter table JBPM_TRANSITION drop constraint FK4FF269F1C144
2007-03-23 01:07:57,953 INFO  [STDOUT] alter table JBPM_TRANSITION drop constraint FK4FF269FC3893553
2007-03-23 01:07:58,015 INFO  [STDOUT] alter table JBPM_TRANSITION drop constraint FK4FF269F5D2DDF5
2007-03-23 01:07:58,046 INFO  [STDOUT] alter table JBPM_SWIMLANE drop constraint FK1DD2A83EC3893553
2007-03-23 01:07:58,062 INFO  [STDOUT] alter table JBPM_SWIMLANE drop constraint FK1DD2A83E52D4AD28
2007-03-23 01:07:58,093 INFO  [STDOUT] alter table JBPM_ACTION drop constraint FKAD5A7480B5AA0E12
2007-03-23 01:07:58,125 INFO  [STDOUT] alter table JBPM_ACTION drop constraint FKAD5A7480F2A151BF
2007-03-23 01:07:58,156 INFO  [STDOUT] alter table JBPM_ACTION drop constraint FKAD5A74809126F810
2007-03-23 01:07:58,203 INFO  [STDOUT] alter table JBPM_ACTION drop constraint FKAD5A74807E4E3BFE
2007-03-23 01:07:58,234 INFO  [STDOUT] alter table JBPM_PROCESSINSTANCE drop constraint FK236E60DA76CFBBE5
2007-03-23 01:07:58,265 INFO  [STDOUT] alter table JBPM_PROCESSINSTANCE drop constraint FK236E60DA3580E2
2007-03-23 01:07:58,296 INFO  [STDOUT] alter table JBPM_PROCESSINSTANCE drop constraint FK236E60DAC3893553
2007-03-23 01:07:58,328 INFO  [STDOUT] alter table JBPM_JOB drop constraint FK375F5193696B9F9
2007-03-23 01:07:58,343 INFO  [STDOUT] alter table JBPM_JOB drop constraint FK375F5193842C3824
2007-03-23 01:07:58,375 INFO  [STDOUT] alter table JBPM_JOB drop constraint FK375F51937E4E3BFE
2007-03-23 01:07:58,406 INFO  [STDOUT] alter table JBPM_VARIABLEINSTANCE drop constraint FKC74438DB69B5865
2007-03-23 01:07:58,437 INFO  [STDOUT] alter table JBPM_VARIABLEINSTANCE drop constraint FKC74438DB696B9F9
2007-03-23 01:07:58,468 INFO  [STDOUT] alter table ACTIVE_BATCH_PRESENTATIONS drop constraint FKBD27795BDB317F91
2007-03-23 01:07:58,484 INFO  [STDOUT] alter table JBPM_TOKEN drop constraint FKDD5E4E4F68AC491
2007-03-23 01:07:58,546 INFO  [STDOUT] alter table JBPM_TOKEN drop constraint FKDD5E4E4FC4AB08AA
2007-03-23 01:07:58,562 INFO  [STDOUT] alter table JBPM_TOKEN drop constraint FKDD5E4E4F842C3824
2007-03-23 01:07:58,578 INFO  [STDOUT] alter table JBPM_TOKEN drop constraint FKDD5E4E4FCDC0E9C4
2007-03-23 01:07:58,593 INFO  [STDOUT] alter table JBPM_TOKEN drop constraint FKDD5E4E4F96611053
2007-03-23 01:07:58,625 INFO  [STDOUT] alter table GROUP_FIELDS drop constraint FK44F5899B4AB93B
2007-03-23 01:07:58,640 INFO  [STDOUT] alter table PRIVELEGE_MAPPINGS drop constraint FKEBB7C8D7658C7007
2007-03-23 01:07:58,656 INFO  [STDOUT] alter table PRIVELEGE_MAPPINGS drop constraint FKEBB7C8D7C6C84BD2
2007-03-23 01:07:58,671 INFO  [STDOUT] drop table BATCH_PRESENTATIONS cascade constraints
2007-03-23 01:07:58,781 INFO  [STDOUT] drop table JBPM_DEFINITION cascade constraints
2007-03-23 01:07:58,859 INFO  [STDOUT] drop table SORTED_FIELDS cascade constraints
2007-03-23 01:07:58,921 INFO  [STDOUT] drop table EXECUTOR_GROUP_RELATIONS cascade constraints
2007-03-23 01:07:59,015 INFO  [STDOUT] drop table CRITERIA_CONDITIONS cascade constraints
2007-03-23 01:07:59,062 INFO  [STDOUT] drop table SORTING_MODES cascade constraints
2007-03-23 01:07:59,125 INFO  [STDOUT] drop table PERMISSION_MAPPINGS cascade constraints
2007-03-23 01:07:59,234 INFO  [STDOUT] drop table FILTER_CRITERIAS cascade constraints
2007-03-23 01:07:59,296 INFO  [STDOUT] drop table JBPM_VARIABLE cascade constraints
2007-03-23 01:07:59,359 INFO  [STDOUT] drop table WFE_CONSTANTS cascade constraints
2007-03-23 01:07:59,484 INFO  [STDOUT] drop table PASSED_TRANSITIONS cascade constraints
2007-03-23 01:07:59,546 INFO  [STDOUT] drop table DISPLAY_FIELDS cascade constraints
2007-03-23 01:07:59,609 INFO  [STDOUT] drop table JBPM_TYPE cascade constraints
2007-03-23 01:07:59,656 INFO  [STDOUT] drop table JBPM_NODE cascade constraints
2007-03-23 01:07:59,750 INFO  [STDOUT] drop table JBPM_TRANSITION cascade constraints
2007-03-23 01:07:59,812 INFO  [STDOUT] drop table PASSWORDS cascade constraints
2007-03-23 01:07:59,875 INFO  [STDOUT] drop table JBPM_SWIMLANE cascade constraints
2007-03-23 01:07:59,937 INFO  [STDOUT] drop table JBPM_ACTION cascade constraints
2007-03-23 01:08:00,000 INFO  [STDOUT] drop table PROFILES cascade constraints
2007-03-23 01:08:00,078 INFO  [STDOUT] drop table JBPM_FILE cascade constraints
2007-03-23 01:08:00,140 INFO  [STDOUT] drop table JBPM_PROCESSINSTANCE cascade constraints
2007-03-23 01:08:00,250 INFO  [STDOUT] drop table SECURED_OBJECT_TYPES cascade constraints
2007-03-23 01:08:00,359 INFO  [STDOUT] drop table PROPERTY_IDS cascade constraints
2007-03-23 01:08:00,453 INFO  [STDOUT] drop table JBPM_JOB cascade constraints
2007-03-23 01:08:00,531 INFO  [STDOUT] drop table JBPM_VARIABLEINSTANCE cascade constraints
2007-03-23 01:08:00,609 INFO  [STDOUT] drop table ACTIVE_BATCH_PRESENTATIONS cascade constraints
2007-03-23 01:08:00,671 INFO  [STDOUT] drop table JBPM_TOKEN cascade constraints
2007-03-23 01:08:00,734 INFO  [STDOUT] drop table GROUP_FIELDS cascade constraints
2007-03-23 01:08:00,828 INFO  [STDOUT] drop table JBPM_SEQUENCEBLOCK cascade constraints
2007-03-23 01:08:00,906 INFO  [STDOUT] drop table PRIVELEGE_MAPPINGS cascade constraints
2007-03-23 01:08:00,968 INFO  [STDOUT] drop table JBPM_DELEGATION cascade constraints
2007-03-23 01:08:01,062 INFO  [STDOUT] drop table EXECUTORS cascade constraints
2007-03-23 01:08:01,125 INFO  [STDOUT] drop table SECURED_OBJECTS cascade constraints
2007-03-23 01:08:01,187 INFO  [STDOUT] drop sequence hibernate_sequence
2007-03-23 01:08:01,218 INFO  [STDOUT] create table BATCH_PRESENTATIONS (
   ID number(19,0) not null,
   VERSION number(19,0) not null,
   RANGE_SIZE number(10,0),
   PRESENTATION_NAME varchar2(128),
   PRESENTATION_ID varchar2(128),
   CLASS_PRESENTATION_ID number(10,0),
   PROFILE_ID number(19,0),
   primary key (ID)
)
2007-03-23 01:08:01,265 INFO  [STDOUT] create table JBPM_DEFINITION (
   id number(19,0) not null,
   name varchar2(255) not null,
   description varchar2(255),
   definition number(19,0),
   version_ number(10,0) not null,
   startState number(19,0),
   endState number(19,0),
   primary key (id),
   unique (name, version_)
)
2007-03-23 01:08:01,687 INFO  [STDOUT] create table SORTED_FIELDS (
   BATCH_PRESENTATION_ID number(19,0) not null,
   FIELD number(10,0),
   ARRAY_INDEX number(10,0) not null,
   primary key (BATCH_PRESENTATION_ID, ARRAY_INDEX)
)
2007-03-23 01:08:01,968 INFO  [STDOUT] create table EXECUTOR_GROUP_RELATIONS (
   ID number(19,0) not null,
   VERSION number(19,0) not null,
   EXECUTOR_ID number(19,0) not null,
   GROUP_ID number(19,0) not null,
   primary key (ID),
   unique (EXECUTOR_ID, GROUP_ID)
)
2007-03-23 01:08:02,203 INFO  [STDOUT] create table CRITERIA_CONDITIONS (
   FILTER_CRITERIA_ID number(19,0) not null,
   CRITERIA_CONDITION varchar2(255),
   CONDITION_INDEX number(10,0) not null,
   primary key (FILTER_CRITERIA_ID, CONDITION_INDEX)
)
2007-03-23 01:08:02,406 INFO  [STDOUT] create table SORTING_MODES (
   BATCH_PRESENTATION_ID number(19,0) not null,
   SORTING_MODE number(1,0),
   ARRAY_INDEX number(10,0) not null,
   primary key (BATCH_PRESENTATION_ID, ARRAY_INDEX)
)
2007-03-23 01:08:02,640 INFO  [STDOUT] create table PERMISSION_MAPPINGS (
   ID number(19,0) not null,
   VERSION number(19,0) not null,
   SECURED_OBJECT_ID number(19,0) not null,
   EXECUTOR_ID number(19,0) not null,
   MASK number(19,0) not null,
   primary key (ID),
   unique (SECURED_OBJECT_ID, EXECUTOR_ID, MASK)
)
2007-03-23 01:08:02,859 INFO  [STDOUT] create table FILTER_CRITERIAS (
   ID number(19,0) not null,
   CRITERIA_TYPE varchar2(255) not null,
   VERSION number(19,0) not null,
   BATCH_PRESENTATION_ID number(19,0),
   FIELD_INDEX number(10,0),
   primary key (ID)
)
2007-03-23 01:08:03,078 INFO  [STDOUT] create table JBPM_VARIABLE (
   id number(19,0) not null,
   name varchar2(255) not null,
   definition number(19,0) not null,
   type_ number(19,0),
   primary key (id)
)
2007-03-23 01:08:03,265 INFO  [STDOUT] create table WFE_CONSTANTS (
   ID number(19,0) not null,
   NAME varchar2(255) unique,
   VALUE varchar2(255),
   primary key (ID)
)
2007-03-23 01:08:03,593 INFO  [STDOUT] create table PASSED_TRANSITIONS (
   PROCESS_INSTANCE_ID number(19,0) not null,
   TRANSITION_ID number(19,0) not null,
   primary key (PROCESS_INSTANCE_ID, TRANSITION_ID)
)
2007-03-23 01:08:03,937 INFO  [STDOUT] create table DISPLAY_FIELDS (
   BATCH_PRESENTATION_ID number(19,0) not null,
   FIELD number(10,0),
   ARRAY_INDEX number(10,0) not null,
   primary key (BATCH_PRESENTATION_ID, ARRAY_INDEX)
)
2007-03-23 01:08:04,265 INFO  [STDOUT] create table JBPM_TYPE (
   id number(19,0) not null,
   description varchar2(255),
   javaType varchar2(255) not null,
   delegation number(19,0),
   definition number(19,0),
   index_ number(10,0),
   primary key (id)
)
2007-03-23 01:08:04,296 INFO  [STDOUT] create table JBPM_NODE (
   id number(19,0) not null,
   class varchar2(255) not null,
   name varchar2(255) not null,
   description varchar2(255),
   definition number(19,0) not null,
   swimlane number(19,0),
   assignmentRequired number(1,0),
   stateAuthentication varchar2(255),
   delegation number(19,0),
   correspondingJoin number(19,0),
   correspondingFork number(19,0),
   primary key (id)
)
2007-03-23 01:08:04,640 INFO  [STDOUT] create table JBPM_TRANSITION (
   id number(19,0) not null,
   name varchar2(255),
   description varchar2(255),
   definition number(19,0) not null,
   from_ number(19,0),
   to_ number(19,0),
   primary key (id)
)
2007-03-23 01:08:04,906 INFO  [STDOUT] create table PASSWORDS (
   ACTOR_ID number(19,0) not null,
   PASSWD raw(255) not null,
   primary key (ACTOR_ID)
)
2007-03-23 01:08:04,937 INFO  [STDOUT] create table JBPM_SWIMLANE (
   id number(19,0) not null,
   name varchar2(255) not null,
   description varchar2(255),
   definition number(19,0) not null,
   delegation number(19,0),
   primary key (id)
)
2007-03-23 01:08:05,187 INFO  [STDOUT] create table JBPM_ACTION (
   id number(19,0) not null,
   eventType varchar2(255),
   actionDelegation number(19,0),
   definition_element number(19,0),
   index_ number(10,0),
   node_element number(19,0),
   transition_element number(19,0),
   primary key (id)
)
2007-03-23 01:08:05,421 INFO  [STDOUT] create table PROFILES (
   ID number(19,0) not null,
   VERSION number(19,0) not null,
   ACTOR_ID number(19,0) not null unique,
   primary key (ID)
)
2007-03-23 01:08:05,671 INFO  [STDOUT] create table JBPM_FILE (
   id number(19,0) not null,
   name varchar2(255) not null,
   definitionId number(19,0) not null,
   bytes long raw,
   primary key (id),
   unique (name, definitionId)
)
2007-03-23 01:08:06,125 INFO  [STDOUT] create table JBPM_PROCESSINSTANCE (
   id number(19,0) not null,
   definition number(19,0) not null,
   root number(19,0) not null,
   superProcessToken number(19,0),
   start_ date,
   end_ date,
   primary key (id)
)
2007-03-23 01:08:06,390 INFO  [STDOUT] create table SECURED_OBJECT_TYPES (
   ID number(19,0) not null,
   PERMISSION_CLASS_NAME varchar2(255) not null,
   TYPE_CODE number(10,0) unique,
   primary key (ID)
)
2007-03-23 01:08:06,578 INFO  [STDOUT] create table PROPERTY_IDS (
   ID number(19,0) not null,
   VERSION number(19,0) not null,
   NEXT_ID number(19,0),
   CLASS_NAME varchar2(128),
   PROPERTY_NAME varchar2(128),
   primary key (ID),
   unique (CLASS_NAME, PROPERTY_NAME)
)
2007-03-23 01:08:07,093 INFO  [STDOUT] create table JBPM_JOB (
   id number(19,0) not null,
   actionDelegation number(19,0),
   token number(19,0),
   processInstance number(19,0),
   dueDate date,
   repeat_ number(19,0),
   reference varchar2(255),
   primary key (id)
)
2007-03-23 01:08:07,390 INFO  [STDOUT] create table JBPM_VARIABLEINSTANCE (
   id number(19,0) not null,
   name varchar2(255) not null,
   serializedValue long raw,
   defaultType varchar2(255),
   type_ number(19,0),
   token number(19,0) not null,
   primary key (id)
)
2007-03-23 01:08:07,437 INFO  [STDOUT] create table ACTIVE_BATCH_PRESENTATIONS (
   PROFILE_ID number(19,0) not null,
   PRESENTATION_NAME varchar2(255),
   PRESENTATION_ID varchar2(255) not null,
   primary key (PROFILE_ID, PRESENTATION_ID)
)
2007-03-23 01:08:07,750 INFO  [STDOUT] create table JBPM_TOKEN (
   id number(19,0) not null,
   TOKEN_NAME varchar2(255) not null,
   processInstance number(19,0),
   parent number(19,0),
   state number(19,0),
   actorId varchar2(255),
   start_ date,
   end_ date,
   reactivationJoin number(19,0),
   subProcessInstance number(19,0),
   primary key (id)
)
2007-03-23 01:08:07,796 INFO  [STDOUT] create table GROUP_FIELDS (
   BATCH_PRESENTATION_ID number(19,0) not null,
   FIELD number(10,0),
   ARRAY_INDEX number(10,0) not null,
   primary key (BATCH_PRESENTATION_ID, ARRAY_INDEX)
)
2007-03-23 01:08:08,078 INFO  [STDOUT] create table JBPM_SEQUENCEBLOCK (
   id number(19,0) not null,
   nextId number(19,0),
   primary key (id)
)
2007-03-23 01:08:08,343 INFO  [STDOUT] create table PRIVELEGE_MAPPINGS (
   TYPE_CODE number(19,0) not null,
   EXECUTOR_ID number(19,0) not null,
   primary key (TYPE_CODE, EXECUTOR_ID)
)
2007-03-23 01:08:08,390 INFO  [STDOUT] create table JBPM_DELEGATION (
   id number(19,0) not null,
   className varchar2(255),
   configuration long,
   primary key (id)
)
2007-03-23 01:08:08,593 INFO  [STDOUT] create table EXECUTORS (
   ID number(19,0) not null,
   IS_GROUP number(1,0) not null,
   VERSION number(19,0) not null,
   NAME varchar2(255) not null unique,
   DESCRIPTION varchar2(255),
   FULL_NAME varchar2(255),
   CODE number(19,0),
   primary key (ID)
)
2007-03-23 01:08:08,812 INFO  [STDOUT] create table SECURED_OBJECTS (
   ID number(19,0) not null,
   VERSION number(19,0) not null,
   EXT_ID number(19,0),
   TYPE_CODE number(10,0),
   primary key (ID),
   unique (EXT_ID, TYPE_CODE)
)
2007-03-23 01:08:09,031 INFO  [STDOUT] create index PRESENTATION_NAME_ID_IDX on BATCH_PRESENTATIONS (PRESENTATION_NAME, PRESENTATION_ID)
2007-03-23 01:08:09,234 INFO  [STDOUT] alter table BATCH_PRESENTATIONS add constraint FK48783814DB317F91 foreign key (PROFILE_ID) references PROFILES
2007-03-23 01:08:09,281 INFO  [STDOUT] create index JBPM_DEFINITION_NAME_IDX on JBPM_DEFINITION (name)
2007-03-23 01:08:09,328 INFO  [STDOUT] alter table JBPM_DEFINITION add constraint FK2F4CEE9D66309C76 foreign key (endState) references JBPM_NODE
2007-03-23 01:08:09,359 INFO  [STDOUT] alter table JBPM_DEFINITION add constraint FK2F4CEE9DC3893553 foreign key (definition) references JBPM_DEFINITION
2007-03-23 01:08:09,406 INFO  [STDOUT] alter table JBPM_DEFINITION add constraint FK2F4CEE9DA1927D4F foreign key (startState) references JBPM_NODE
2007-03-23 01:08:09,468 INFO  [STDOUT] alter table SORTED_FIELDS add constraint FK38F1CA7BB4AB93B foreign key (BATCH_PRESENTATION_ID) references BATCH_PRESENTATIONS
2007-03-23 01:08:09,515 INFO  [STDOUT] create index EXE_GR_RL_EXE_ID_IDX on EXECUTOR_GROUP_RELATIONS (EXECUTOR_ID)
2007-03-23 01:08:09,718 INFO  [STDOUT] create index EXE_GR_RL_GR_ID_IDX on EXECUTOR_GROUP_RELATIONS (GROUP_ID)
2007-03-23 01:08:09,750 INFO  [STDOUT] alter table EXECUTOR_GROUP_RELATIONS add constraint FKD66B5C8B658C7007 foreign key (EXECUTOR_ID) references EXECUTORS
2007-03-23 01:08:09,781 INFO  [STDOUT] alter table EXECUTOR_GROUP_RELATIONS add constraint FKD66B5C8B4CD4DEFB foreign key (GROUP_ID) references EXECUTORS
2007-03-23 01:08:09,828 INFO  [STDOUT] alter table CRITERIA_CONDITIONS add constraint FK7D91A798BC3317B4 foreign key (FILTER_CRITERIA_ID) references FILTER_CRITERIAS
2007-03-23 01:08:09,843 INFO  [STDOUT] alter table SORTING_MODES add constraint FKCE1FAC75B4AB93B foreign key (BATCH_PRESENTATION_ID) references BATCH_PRESENTATIONS
2007-03-23 01:08:09,890 INFO  [STDOUT] create index PRM_MPG_SCD_OBJ_ID_IDX on PERMISSION_MAPPINGS (SECURED_OBJECT_ID)
2007-03-23 01:08:10,156 INFO  [STDOUT] create index PRM_MPG_EXE_ID_IDX on PERMISSION_MAPPINGS (EXECUTOR_ID)
2007-03-23 01:08:10,187 INFO  [STDOUT] alter table PERMISSION_MAPPINGS add constraint FKF10C09D5658C7007 foreign key (EXECUTOR_ID) references EXECUTORS
2007-03-23 01:08:10,250 INFO  [STDOUT] alter table PERMISSION_MAPPINGS add constraint FKF10C09D5709DC009 foreign key (SECURED_OBJECT_ID) references SECURED_OBJECTS
2007-03-23 01:08:10,312 INFO  [STDOUT] alter table FILTER_CRITERIAS add constraint FKC6A7E0CDB4AB93B foreign key (BATCH_PRESENTATION_ID) references BATCH_PRESENTATIONS
2007-03-23 01:08:10,359 INFO  [STDOUT] alter table JBPM_VARIABLE add constraint FKD8CB5A4669B5865 foreign key (type_) references JBPM_TYPE
2007-03-23 01:08:10,390 INFO  [STDOUT] alter table JBPM_VARIABLE add constraint FKD8CB5A46C3893553 foreign key (definition) references JBPM_DEFINITION
2007-03-23 01:08:10,437 INFO  [STDOUT] alter table PASSED_TRANSITIONS add constraint FK522DAC4F84581845 foreign key (TRANSITION_ID) references JBPM_TRANSITION
2007-03-23 01:08:10,468 INFO  [STDOUT] alter table PASSED_TRANSITIONS add constraint FK522DAC4FCF0F2F15 foreign key (PROCESS_INSTANCE_ID) references JBPM_PROCESSINSTANCE
2007-03-23 01:08:10,515 INFO  [STDOUT] alter table DISPLAY_FIELDS add constraint FK6DD5B0F6B4AB93B foreign key (BATCH_PRESENTATION_ID) references BATCH_PRESENTATIONS
2007-03-23 01:08:10,546 INFO  [STDOUT] alter table JBPM_TYPE add constraint FKB48F940452D4AD28 foreign key (delegation) references JBPM_DELEGATION
2007-03-23 01:08:10,562 INFO  [STDOUT] alter table JBPM_TYPE add constraint FKB48F9404C3893553 foreign key (definition) references JBPM_DEFINITION
2007-03-23 01:08:10,593 INFO  [STDOUT] create index JBPM_NODE_SWIMLANE_ID_IDX on JBPM_NODE (swimlane)
2007-03-23 01:08:10,890 INFO  [STDOUT] alter table JBPM_NODE add constraint FKB48CB2CCFA8C2074 foreign key (swimlane) references JBPM_SWIMLANE
2007-03-23 01:08:10,921 INFO  [STDOUT] alter table JBPM_NODE add constraint FKB48CB2CCF41BD495 foreign key (correspondingFork) references JBPM_NODE
2007-03-23 01:08:10,953 INFO  [STDOUT] alter table JBPM_NODE add constraint FKB48CB2CC52D4AD28 foreign key (delegation) references JBPM_DELEGATION
2007-03-23 01:08:10,984 INFO  [STDOUT] alter table JBPM_NODE add constraint FKB48CB2CCC3893553 foreign key (definition) references JBPM_DEFINITION
2007-03-23 01:08:11,015 INFO  [STDOUT] alter table JBPM_NODE add constraint FKB48CB2CCF41DA4FD foreign key (correspondingJoin) references JBPM_NODE
2007-03-23 01:08:11,062 INFO  [STDOUT] alter table JBPM_TRANSITION add constraint FK4FF269F1C144 foreign key (to_) references JBPM_NODE
2007-03-23 01:08:11,093 INFO  [STDOUT] alter table JBPM_TRANSITION add constraint FK4FF269FC3893553 foreign key (definition) references JBPM_DEFINITION
2007-03-23 01:08:11,125 INFO  [STDOUT] alter table JBPM_TRANSITION add constraint FK4FF269F5D2DDF5 foreign key (from_) references JBPM_NODE
2007-03-23 01:08:11,203 INFO  [STDOUT] alter table JBPM_SWIMLANE add constraint FK1DD2A83EC3893553 foreign key (definition) references JBPM_DEFINITION
2007-03-23 01:08:11,234 INFO  [STDOUT] alter table JBPM_SWIMLANE add constraint FK1DD2A83E52D4AD28 foreign key (delegation) references JBPM_DELEGATION
2007-03-23 01:08:11,281 INFO  [STDOUT] alter table JBPM_ACTION add constraint FKAD5A7480B5AA0E12 foreign key (transition_element) references JBPM_TRANSITION
2007-03-23 01:08:11,328 INFO  [STDOUT] alter table JBPM_ACTION add constraint FKAD5A7480F2A151BF foreign key (node_element) references JBPM_NODE
2007-03-23 01:08:11,359 INFO  [STDOUT] alter table JBPM_ACTION add constraint FKAD5A74809126F810 foreign key (definition_element) references JBPM_DEFINITION
2007-03-23 01:08:11,406 INFO  [STDOUT] alter table JBPM_ACTION add constraint FKAD5A74807E4E3BFE foreign key (actionDelegation) references JBPM_DELEGATION
2007-03-23 01:08:11,453 INFO  [STDOUT] create index JBPM_PRC_DEF_ID_IDX on JBPM_PROCESSINSTANCE (definition)
2007-03-23 01:08:11,468 INFO  [STDOUT] alter table JBPM_PROCESSINSTANCE add constraint FK236E60DA76CFBBE5 foreign key (superProcessToken) references JBPM_TOKEN
2007-03-23 01:08:11,531 INFO  [STDOUT] alter table JBPM_PROCESSINSTANCE add constraint FK236E60DA3580E2 foreign key (root) references JBPM_TOKEN
2007-03-23 01:08:11,578 INFO  [STDOUT] alter table JBPM_PROCESSINSTANCE add constraint FK236E60DAC3893553 foreign key (definition) references JBPM_DEFINITION
2007-03-23 01:08:11,609 INFO  [STDOUT] alter table JBPM_JOB add constraint FK375F5193696B9F9 foreign key (token) references JBPM_TOKEN
2007-03-23 01:08:11,640 INFO  [STDOUT] alter table JBPM_JOB add constraint FK375F5193842C3824 foreign key (processInstance) references JBPM_PROCESSINSTANCE
2007-03-23 01:08:11,671 INFO  [STDOUT] alter table JBPM_JOB add constraint FK375F51937E4E3BFE foreign key (actionDelegation) references JBPM_DELEGATION
2007-03-23 01:08:11,703 INFO  [STDOUT] create index JBPM_VAR_TK_ID_IDX on JBPM_VARIABLEINSTANCE (token)
2007-03-23 01:08:11,734 INFO  [STDOUT] alter table JBPM_VARIABLEINSTANCE add constraint FKC74438DB69B5865 foreign key (type_) references JBPM_TYPE
2007-03-23 01:08:11,781 INFO  [STDOUT] alter table JBPM_VARIABLEINSTANCE add constraint FKC74438DB696B9F9 foreign key (token) references JBPM_TOKEN
2007-03-23 01:08:11,828 INFO  [STDOUT] alter table ACTIVE_BATCH_PRESENTATIONS add constraint FKBD27795BDB317F91 foreign key (PROFILE_ID) references PROFILES
2007-03-23 01:08:11,859 INFO  [STDOUT] create index JBPM_TKN_PRC_ID_IDX on JBPM_TOKEN (processInstance)
2007-03-23 01:08:12,031 INFO  [STDOUT] create index JBPM_TOKEN_STATE_ID_IDX on JBPM_TOKEN (state)
2007-03-23 01:08:12,046 INFO  [STDOUT] alter table JBPM_TOKEN add constraint FKDD5E4E4F68AC491 foreign key (state) references JBPM_NODE
2007-03-23 01:08:12,109 INFO  [STDOUT] alter table JBPM_TOKEN add constraint FKDD5E4E4FC4AB08AA foreign key (parent) references JBPM_TOKEN
2007-03-23 01:08:12,156 INFO  [STDOUT] alter table JBPM_TOKEN add constraint FKDD5E4E4F842C3824 foreign key (processInstance) references JBPM_PROCESSINSTANCE
2007-03-23 01:08:12,203 INFO  [STDOUT] alter table JBPM_TOKEN add constraint FKDD5E4E4FCDC0E9C4 foreign key (subProcessInstance) references JBPM_PROCESSINSTANCE
2007-03-23 01:08:12,250 INFO  [STDOUT] alter table JBPM_TOKEN add constraint FKDD5E4E4F96611053 foreign key (reactivationJoin) references JBPM_NODE
2007-03-23 01:08:12,281 INFO  [STDOUT] alter table GROUP_FIELDS add constraint FK44F5899B4AB93B foreign key (BATCH_PRESENTATION_ID) references BATCH_PRESENTATIONS
2007-03-23 01:08:12,312 INFO  [STDOUT] alter table PRIVELEGE_MAPPINGS add constraint FKEBB7C8D7658C7007 foreign key (EXECUTOR_ID) references EXECUTORS
2007-03-23 01:08:12,359 INFO  [STDOUT] alter table PRIVELEGE_MAPPINGS add constraint FKEBB7C8D7C6C84BD2 foreign key (TYPE_CODE) references SECURED_OBJECT_TYPES
2007-03-23 01:08:12,421 INFO  [STDOUT] create index EXECUTORS_CODE_IDX on EXECUTORS (CODE)
2007-03-23 01:08:12,609 INFO  [STDOUT] create sequence hibernate_sequence
2007-03-23 01:08:12,625 INFO  [STDOUT] ------>>>°°°°°°°Hibernate
2007-03-23 01:08:12,640 INFO  [STDOUT] ------>>>°°°°°°°Hibernate
2007-03-23 01:08:12,640 INFO  [STDOUT] ------>>>°°°°°°°Hibernate
2007-03-23 01:08:12,656 INFO  [STDOUT] Hibernate: select this.ID as ID0_, this.IS_GROUP as IS_GROUP0_, this.VERSION as VERSION0_, this.NAME as NAME0_, this.DESCRIPTION as DESCRIPT5_0_, this.FULL_NAME as FULL_NAME0_, this.CODE as CODE0_ from EXECUTORS this where this.NAME=?
2007-03-23 01:08:12,656 INFO  [STDOUT] Hibernate: select this.ID as ID0_, this.VERSION as VERSION0_, this.NEXT_ID as NEXT_ID0_, this.CLASS_NAME as CLASS_NAME0_, this.PROPERTY_NAME as PROPERTY5_0_ from PROPERTY_IDS this where this.CLASS_NAME=? and this.PROPERTY_NAME=?
2007-03-23 01:08:12,671 INFO  [STDOUT] Hibernate: select hibernate_sequence.nextval from dual
2007-03-23 01:08:12,703 INFO  [STDOUT] Hibernate: select this.ID as ID0_, this.FULL_NAME as FULL_NAME0_, this.CODE as CODE0_, this.VERSION as VERSION0_, this.NAME as NAME0_, this.DESCRIPTION as DESCRIPT5_0_ from EXECUTORS this where this.CODE=? and this.IS_GROUP=0
2007-03-23 01:08:12,703 INFO  [STDOUT] Hibernate: select hibernate_sequence.nextval from dual
2007-03-23 01:08:12,703 INFO  [STDOUT] -->>Entrando a Secured-Object
2007-03-23 01:08:12,703 INFO  [STDOUT] -->>Identifiable vale:::ru.runa.af.Executor:Administrator
2007-03-23 01:08:12,703 INFO  [STDOUT] Antes--->>
2007-03-23 01:08:12,703 INFO  [STDOUT] --1--type-->>::-984354279
2007-03-23 01:08:12,703 INFO  [STDOUT] --2--session es--->>::net.sf.hibernate.impl.SessionImpl@8b1323
2007-03-23 01:08:12,703 INFO  [STDOUT] --3--identifiable es--->>::2
2007-03-23 01:08:12,703 INFO  [STDOUT] Hibernate: select this.ID as ID0_, this.VERSION as VERSION0_, this.EXT_ID as EXT_ID0_, this.TYPE_CODE as TYPE_CODE0_ from SECURED_OBJECTS this where this.EXT_ID=? and this.TYPE_CODE=?
2007-03-23 01:08:12,718 INFO  [STDOUT] ---Secured-Object--->>extId:::2
2007-03-23 01:08:12,718 INFO  [STDOUT] ---Secured-Object--->>type::-984354279
2007-03-23 01:08:12,718 INFO  [STDOUT] Hibernate: select hibernate_sequence.nextval from dual
2007-03-23 01:08:12,718 INFO  [STDOUT] Hibernate: select this.ACTOR_ID as ACTOR_ID0_, this.PASSWD as PASSWD0_ from PASSWORDS this where this.ACTOR_ID=?
2007-03-23 01:08:12,734 INFO  [STDOUT] Hibernate: select this.ID as ID0_, this.IS_GROUP as IS_GROUP0_, this.VERSION as VERSION0_, this.NAME as NAME0_, this.DESCRIPTION as DESCRIPT5_0_, this.FULL_NAME as FULL_NAME0_, this.CODE as CODE0_ from EXECUTORS this where this.NAME=?
2007-03-23 01:08:12,765 INFO  [STDOUT] Hibernate: select hibernate_sequence.nextval from dual
2007-03-23 01:08:12,765 INFO  [STDOUT] -->>Entrando a Secured-Object
2007-03-23 01:08:12,765 INFO  [STDOUT] -->>Identifiable vale:::ru.runa.af.Executor:Administrators
2007-03-23 01:08:12,765 INFO  [STDOUT] Antes--->>
2007-03-23 01:08:12,765 INFO  [STDOUT] --1--type-->>::-978370909
2007-03-23 01:08:12,765 INFO  [STDOUT] --2--session es--->>::net.sf.hibernate.impl.SessionImpl@8b1323
2007-03-23 01:08:12,765 INFO  [STDOUT] --3--identifiable es--->>::4
2007-03-23 01:08:12,765 INFO  [STDOUT] Hibernate: select this.ID as ID0_, this.VERSION as VERSION0_, this.EXT_ID as EXT_ID0_, this.TYPE_CODE as TYPE_CODE0_ from SECURED_OBJECTS this where this.EXT_ID=? and this.TYPE_CODE=?
2007-03-23 01:08:12,765 INFO  [STDOUT] ---Secured-Object--->>extId:::4
2007-03-23 01:08:12,765 INFO  [STDOUT] ---Secured-Object--->>type::-978370909
2007-03-23 01:08:12,765 INFO  [STDOUT] Hibernate: select hibernate_sequence.nextval from dual
2007-03-23 01:08:12,781 INFO  [STDOUT] Hibernate: select this.ID as ID0_, this.VERSION as VERSION0_, this.EXECUTOR_ID as EXECUTOR3_0_, this.GROUP_ID as GROUP_ID0_ from EXECUTOR_GROUP_RELATIONS this where this.GROUP_ID=? and this.EXECUTOR_ID=?
2007-03-23 01:08:12,781 INFO  [STDOUT] Hibernate: select hibernate_sequence.nextval from dual
2007-03-23 01:08:12,812 INFO  [STDOUT] Hibernate: select this.ID as ID0_, this.IS_GROUP as IS_GROUP0_, this.VERSION as VERSION0_, this.NAME as NAME0_, this.DESCRIPTION as DESCRIPT5_0_, this.FULL_NAME as FULL_NAME0_, this.CODE as CODE0_ from EXECUTORS this where this.NAME=?
2007-03-23 01:08:12,812 INFO  [STDOUT] Hibernate: select hibernate_sequence.nextval from dual
2007-03-23 01:08:12,812 INFO  [STDOUT] -->>Entrando a Secured-Object
2007-03-23 01:08:12,812 INFO  [STDOUT] -->>Identifiable vale:::ru.runa.af.Executor:Process Definition Administrators
2007-03-23 01:08:12,812 INFO  [STDOUT] Antes--->>
2007-03-23 01:08:12,812 INFO  [STDOUT] --1--type-->>::-978370909
2007-03-23 01:08:12,812 INFO  [STDOUT] --2--session es--->>::net.sf.hibernate.impl.SessionImpl@8b1323
2007-03-23 01:08:12,812 INFO  [STDOUT] --3--identifiable es--->>::7
2007-03-23 01:08:12,812 INFO  [STDOUT] Hibernate: select this.ID as ID0_, this.VERSION as VERSION0_, this.EXT_ID as EXT_ID0_, this.TYPE_CODE as TYPE_CODE0_ from SECURED_OBJECTS this where this.EXT_ID=? and this.TYPE_CODE=?
2007-03-23 01:08:12,812 INFO  [STDOUT] ---Secured-Object--->>extId:::7
2007-03-23 01:08:12,812 INFO  [STDOUT] ---Secured-Object--->>type::-978370909
2007-03-23 01:08:12,812 INFO  [STDOUT] Hibernate: select hibernate_sequence.nextval from dual
2007-03-23 01:08:12,812 INFO  [STDOUT] Hibernate: select this.ID as ID0_, this.VERSION as VERSION0_, this.EXECUTOR_ID as EXECUTOR3_0_, this.GROUP_ID as GROUP_ID0_ from EXECUTOR_GROUP_RELATIONS this where this.GROUP_ID=? and this.EXECUTOR_ID=?
2007-03-23 01:08:12,812 INFO  [STDOUT] Hibernate: select hibernate_sequence.nextval from dual
2007-03-23 01:08:12,828 INFO  [STDOUT] -->>Entrando a Secured-Object
2007-03-23 01:08:12,828 INFO  [STDOUT] -->>Identifiable vale:::ru.runa.af.ASystem@3534c1
2007-03-23 01:08:12,828 INFO  [STDOUT] Antes--->>
2007-03-23 01:08:12,828 INFO  [STDOUT] --1--type-->>::-1524981484
2007-03-23 01:08:12,828 INFO  [STDOUT] --2--session es--->>::net.sf.hibernate.impl.SessionImpl@8b1323
2007-03-23 01:08:12,828 INFO  [STDOUT] °°°°°°°°°°El id es::::0
2007-03-23 01:08:12,828 INFO  [STDOUT] --3--identifiable es--->>::0
2007-03-23 01:08:12,828 INFO  [STDOUT] °°°°°°°°°°El id es::::0
2007-03-23 01:08:12,828 INFO  [STDOUT] Hibernate: select this.ID as ID0_, this.VERSION as VERSION0_, this.EXT_ID as EXT_ID0_, this.TYPE_CODE as TYPE_CODE0_ from SECURED_OBJECTS this where this.EXT_ID=? and this.TYPE_CODE=?
2007-03-23 01:08:12,843 INFO  [STDOUT] °°°°°°°°°°El id es::::0
2007-03-23 01:08:12,843 INFO  [STDOUT] ---Secured-Object--->>extId:::0
2007-03-23 01:08:12,843 INFO  [STDOUT] ---Secured-Object--->>type::-1524981484
2007-03-23 01:08:12,843 INFO  [STDOUT] Hibernate: select hibernate_sequence.nextval from dual
2007-03-23 01:08:12,843 INFO  [STDOUT] Hibernate: select hibernate_sequence.nextval from dual
2007-03-23 01:08:12,859 INFO  [STDOUT] Hibernate: select hibernate_sequence.nextval from dual
2007-03-23 01:08:12,859 INFO  [STDOUT] Hibernate: select hibernate_sequence.nextval from dual
2007-03-23 01:08:12,875 INFO  [STDOUT] Hibernate: select hibernate_sequence.nextval from dual
2007-03-23 01:08:12,875 INFO  [STDOUT] Hibernate: select hibernate_sequence.nextval from dual
2007-03-23 01:08:12,875 INFO  [STDOUT] Hibernate: select this.ID as ID0_, this.VERSION as VERSION0_, this.EXT_ID as EXT_ID0_, this.TYPE_CODE as TYPE_CODE0_ from SECURED_OBJECTS this where this.EXT_ID=? and this.TYPE_CODE=?
2007-03-23 01:08:12,875 INFO  [STDOUT] SecuredObjectDAO
2007-03-23 01:08:12,875 INFO  [STDOUT] ----Valor--->>securedObject es:::null
2007-03-23 01:08:12,875 INFO  [STDOUT] ------Exception es:::ru.runa.af.SecuredObjectOutOfDateException: Secured object with extId 4 and type -978370909 does not exists
2007-03-23 01:08:12,875 ERROR [org.jboss.ejb.plugins.LogInterceptor] RuntimeException in method: public abstract void ru.runa.af.service.impl.interfaces.InitializerService.init() throws ru.runa.af.InternalApplicationException,java.rmi.RemoteException
ru.runa.af.InternalApplicationException: ru.runa.af.SecuredObjectOutOfDateException: Secured object with extId 4 and type -978370909 does not exists
    at ru.runa.af.logic.AFInitializerLogic.exportDataInternal(AFInitializerLogic.java:109)
    at ru.runa.af.logic.InitializerLogic.init(InitializerLogic.java:59)
    at ru.runa.af.service.impl.ejb.InitializerServiceBean.init(InitializerServiceBean.java:70)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

Thanks again,
Regards

[Andrei Mikheev]

Hi Nattaly,

We have not tested RUNA WFE on Oracle 10g. We have tested it on Oracle 9i.
We haven't faced with this problem using Oracle 9i.

Is it possibly for you to use Oracle 9i instead of Oracle 10g?

Regards,
Andrei

[Nobody/Anonymous]

Did you really tested it on Oracle 9i?

Regards,
Vitaliy S

[Andrei Mikheev]

Hi Vitaly,

Sergei Gritsenko informed me he have tested RUNA WFE on Oracle 9i.

Regards,
Andrei

[Vitaliy Semochkin]

Hi,

re: Sergei Gritsenko informed me he have tested RUNA WFE on Oracle 9i.

Really? When?
Are you sure it was RUNA WFE and not the AF framework?

Regards,
Vitaliy S

[nat]

Hello Andrei,

I change the driver to classes12 for using Oracle 9i and I got the same exception. For Oracle 10g I used ojdbc14 driver.
I really interested in desploy Runa on Oracle, at the moment we have a critical project and we need a stable version in oracle.

Do you think it is something wrong with data types between hibernate and oracle?

I test Runa in MySql an everything works great.

Please any advice or comment about this subject would be great.

Thanks,
Regards.

P.D. In the previous message I post the data that I inserted manually.

[nat]

Hello,

I inserted the following data at Runa database:

INSERT INTO PROPERTY_IDS VALUES(1,0,0,'ru.runa.af.Actor','code')
INSERT INTO EXECUTORS VALUES(1,0,0,'Administrator','Default System Administrator','',0)
INSERT INTO SECURED_OBJECTS VALUES(1,0,1,-984354279)
INSERT INTO PASSWORDS VALUES(1,'c1b291cb8522236e421731b509c9fcdd')
INSERT INTO EXECUTORS VALUES(2,1,0,'Administrators','Default Group For System Administrators',NULL,NULL)
INSERT INTO SECURED_OBJECTS VALUES(2,0,2,-978370909)
INSERT INTO EXECUTOR_GROUP_RELATIONS VALUES(1,0,1,2)
INSERT INTO EXECUTORS VALUES(3,1,0,'Process Definition Administrators','Executors that have all rights on all process definition',NULL,NULL)
INSERT INTO SECURED_OBJECTS VALUES(3,0,3,-978370909)
INSERT INTO EXECUTOR_GROUP_RELATIONS VALUES(2,0,2,3)
INSERT INTO SECURED_OBJECTS VALUES(4,0,0,-1524981484)
INSERT INTO SECURED_OBJECT_TYPES VALUES(1,'ru.runa.af.ActorPermission',-984354279)
INSERT INTO SECURED_OBJECT_TYPES VALUES(2,'ru.runa.af.GroupPermission',-978370909)
INSERT INTO SECURED_OBJECT_TYPES VALUES(3,'ru.runa.wf.WorkflowSystemPermission',-1524981484)
INSERT INTO SECURED_OBJECT_TYPES VALUES(4,'ru.runa.wf.ProcessDefinitionPermission',344855614)
INSERT INTO SECURED_OBJECT_TYPES VALUES(5,'ru.runa.wf.ProcessInstancePermission',-1929624128)
INSERT INTO PERMISSION_MAPPINGS VALUES(1,0,2,2,1)
INSERT INTO PERMISSION_MAPPINGS VALUES(2,0,2,2,2)
INSERT INTO PERMISSION_MAPPINGS VALUES(3,0,2,2,4)
INSERT INTO PERMISSION_MAPPINGS VALUES(4,0,2,2,8)
INSERT INTO PERMISSION_MAPPINGS VALUES(5,0,2,2,16)
INSERT INTO PERMISSION_MAPPINGS VALUES(6,0,2,2,32)
INSERT INTO PERMISSION_MAPPINGS VALUES(7,0,1,2,1)
INSERT INTO PERMISSION_MAPPINGS VALUES(8,0,1,2,2)
INSERT INTO PERMISSION_MAPPINGS VALUES(9,0,1,2,4)
INSERT INTO PERMISSION_MAPPINGS VALUES(10,0,1,1,1)
INSERT INTO PERMISSION_MAPPINGS VALUES(11,0,1,1,2)
INSERT INTO PERMISSION_MAPPINGS VALUES(12,0,1,1,4)
INSERT INTO PERMISSION_MAPPINGS VALUES(13,0,3,2,1)
INSERT INTO PERMISSION_MAPPINGS VALUES(14,0,3,2,2)
INSERT INTO PERMISSION_MAPPINGS VALUES(15,0,3,2,4)
INSERT INTO PERMISSION_MAPPINGS VALUES(16,0,3,2,8)
INSERT INTO PERMISSION_MAPPINGS VALUES(17,0,3,2,16)
INSERT INTO PERMISSION_MAPPINGS VALUES(18,0,3,2,32)
INSERT INTO PERMISSION_MAPPINGS VALUES(19,0,4,2,1)
INSERT INTO PERMISSION_MAPPINGS VALUES(20,0,4,2,2)
INSERT INTO PERMISSION_MAPPINGS VALUES(21,0,4,2,4)
INSERT INTO PERMISSION_MAPPINGS VALUES(22,0,4,2,8)
INSERT INTO PERMISSION_MAPPINGS VALUES(23,0,4,3,1)
INSERT INTO PERMISSION_MAPPINGS VALUES(24,0,4,3,2)
INSERT INTO PERMISSION_MAPPINGS VALUES(25,0,4,3,4)
INSERT INTO PERMISSION_MAPPINGS VALUES(26,0,4,3,8)
INSERT INTO PERMISSION_MAPPINGS VALUES(27,0,4,3,16)
INSERT INTO WFE_CONSTANTS VALUES(1,'ru.runa.database_initialized','true')
DELETE FROM PROPERTY_IDS WHERE ID=1
INSERT INTO PROPERTY_IDS VALUES(1,1,-1,'ru.runa.af.Actor','code')
INSERT INTO PRIVELEGE_MAPPINGS VALUES(1,2)
INSERT INTO PRIVELEGE_MAPPINGS VALUES(2,2)
INSERT INTO PRIVELEGE_MAPPINGS VALUES(3,2)
INSERT INTO PRIVELEGE_MAPPINGS VALUES(4,3)
INSERT INTO PRIVELEGE_MAPPINGS VALUES(5,3)

I took the data from Hypersonic inicialization database.

Any help, comment or advice would be very great.

Thanks,
Regards.

[Dofs]

Hi people.
I have tested RUNA WFE on Oracle 9i one year ago and had not any problems.
Of course the system was changed.

[Vitaliy Semochkin]

Hi

re:I have tested RUNA WFE on Oracle 9i one year ago and had not any problems.

Are you sure? ;-)
As far as I remember it was not a year but 2 years ago when me and Maxim were developing AF framework (even before the release of RUNA WFE 1.0). Any way before I start the investigation of Oracle compatibility problem it would be nice if you find appropriate RUNA WFE version(the version you believe you manage to run on Oracle 9).
Once you find the revision that works without problem please send the number to me or post it two forum.

Regards,
Vitaliy S

[nat]

Hello Vitaliy:

I have all the availability for cooperate in the investigation about Oracle and Runa compatibility, if you are going to start testing Oracle in Runa. 
I will continue manage with this issue. I think it is possible to find a solution.

Thanks again for your time,
Regards.

[Nobody/Anonymous]

Hello Nattaly.
I have some solution for right init db.
At first see at the table SECURED_OBJECTS. There was a unique key at column TYPE_CODE (attribute type in java object SecuredObject). But as you can see in SQL script there are 2 records with the same TYPE_CODE (-978370909), so I undo this field as unique (I will consult with Vitaliy about this).

At second there was something unexpected where working with uncommited objects in DAO level. See AFInitializerLogic between methods createPrivelegedExecutors and grantDefaultExecutorsPermissions. In first method we create SecuredObject and in second we trying to load these object from hibernate Session, but they are not available! I just insert some code before second method and this works fine.

            DAOHelper.close(executorDAO, securedObjectDAO, true);
            DAOHelper.close(profileDAO, true);
            try {
                ru.runa.commons.hibernate.HibernateSessionFactory.closeSession(true);
                ru.runa.commons.hibernate.HibernateSessionFactory.openSession();
            } catch (HibernateException e) {
                e.printStackTrace();
            }
            securedObjectDAO = DAOFactory.getInstance().createSecuredObjectDAO();
            executorDAO = DAOFactory.getInstance().createExecutorDAO();
            profileDAO = DAOFactory.getInstance().createProfileDAO();

I did not run tests on system, but I succesfully logon to the system.
I'm used Oracle9i.
Sergey.

[Nobody/Anonymous]

Dao has nothing to do with transaction management (at least in spring '06 does not). If you have to commit hibernate tx between dao calls you probably have different session associated w daos.

[nat]

Hello Sergey,

I did the things that you recommend. I undo as unique the column TYPE_CODE in the class SecuredObject. Also I add the code before the method grantDefaultExecutorsPermissions in the class AFInitializerLogic.
But when I try to add and actor or group, and when I run the script-runner.bat from adminkit I am getting the following error:

Because of error: ru.runa.af.SecuredObjectOutOfDateException: Secured object with extId 102 and type -978370909 does not exists

Secured object with extId 104 and type -984354279 does not exists

I run a test, but it didn't pass it

   [cactus] -----------------------------------------------------------------
   [cactus] Running tests against Unknown Container @ http://localhost:8080
   [cactus] -----------------------------------------------------------------
   [cactus] Running ru.runa.af.PermissionTest
   [cactus] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 0.39 sec
   [cactus] Running ru.runa.af.delegate.AASystemServiceDelegateLoginTest
   [cactus] Tests run: 4, Failures: 0, Errors: 4, Time elapsed: 1.234 sec
   [cactus] Test ru.runa.af.delegate.AASystemServiceDelegateLoginTest FAILED
   [cactus] Running ru.runa.af.delegate.AuthenticationServiceDelegateGetActorTest
   [cactus] Tests run: 3, Failures: 0, Errors: 3, Time elapsed: 1.344 sec
   [cactus] Test ru.runa.af.delegate.AuthenticationServiceDelegateGetActorTest FAILED
   [cactus] Running ru.runa.af.delegate.AuthenticationServiceDelegatePasswordLoginModuleTest

Runa insert the following data:

INSERT INTO EXECUTORS VALUES(2,0,0,Administrator Default System Administrator,    Administrator)
INSERT INTO EXECUTORS VALUES(4,1,0,Administrators Default Group For System Administrators)   
INSERT INTO EXECUTORS VALUES(7,1,0,Process Definition Administrators,Executors that have all rights on all process definition)
INSERT INTO EXECUTOR_GROUP_RELATIONS VALUES(6,0,2,4)
INSERT INTO EXECUTOR_GROUP_RELATIONS VALUES(9,0,4,7)
INSERT INTO PASSWORD VALUES(2,C1B291CB8522236E421731B509C9FCDD)
INSERT INTO PERMISSION_MAPPINGS VALUES(16,0,5,4,1)
INSERT INTO PERMISSION_MAPPINGS VALUES(17,0,5,4,2)
INSERT INTO PERMISSION_MAPPINGS VALUES(18,0,5,4,4)
INSERT INTO PERMISSION_MAPPINGS VALUES(19,0,5,4,8)
INSERT INTO PERMISSION_MAPPINGS VALUES(20,0,5,4,16)
INSERT INTO PERMISSION_MAPPINGS VALUES(21,0,5,4,32)
INSERT INTO PERMISSION_MAPPINGS VALUES(22,0,3,4,1)
INSERT INTO PERMISSION_MAPPINGS VALUES(23,0,3,4,2)
INSERT INTO PERMISSION_MAPPINGS VALUES(24,0,3,4,4)
INSERT INTO PERMISSION_MAPPINGS VALUES(25,0,3,2,1)
INSERT INTO PERMISSION_MAPPINGS VALUES(26,0,3,2,2)
INSERT INTO PERMISSION_MAPPINGS VALUES(27,0,3,2,4)
INSERT INTO PERMISSION_MAPPINGS VALUES(28,0,8,4,1)
INSERT INTO PERMISSION_MAPPINGS VALUES(29,0,8,4,2)
INSERT INTO PERMISSION_MAPPINGS VALUES(30,0,8,4,4)
INSERT INTO PERMISSION_MAPPINGS VALUES(31,0,8,4,8)
INSERT INTO PERMISSION_MAPPINGS VALUES(32,0,8,4,16)
INSERT INTO PERMISSION_MAPPINGS VALUES(33,0,8,4,32)
INSERT INTO PERMISSION_MAPPINGS VALUES(34,0,10,4,1)
INSERT INTO PERMISSION_MAPPINGS VALUES(35,0,10,4,2)
INSERT INTO PERMISSION_MAPPINGS VALUES(36,0,10,4,4)
INSERT INTO PERMISSION_MAPPINGS VALUES(37,0,10,4,8)
INSERT INTO PERMISSION_MAPPINGS VALUES(38,0,10,7,1)
INSERT INTO PERMISSION_MAPPINGS VALUES(39,0,10,7,2)
INSERT INTO PERMISSION_MAPPINGS VALUES(40,0,10,7,4)
INSERT INTO PERMISSION_MAPPINGS VALUES(41,0,10,7,8)
INSERT INTO PERMISSION_MAPPINGS VALUES(42,0,10,7,16)
INSERT INTO PRIVELEGE_MAPPINGS VALUES(11,4)
INSERT INTO PRIVELEGE_MAPPINGS VALUES(12,4)
INSERT INTO PRIVELEGE_MAPPINGS VALUES(13,4)
INSERT INTO PRIVELEGE_MAPPINGS VALUES(14,7)
INSERT INTO PRIVELEGE_MAPPINGS VALUES(15,7)
INSERT INTO PROPERTY_IDS VALUES(1,1,-1,ru.runa.af.Actor)
INSERT INTO SECURED_OBJECTS VALUES(3,0,2,-984354279)
INSERT INTO SECURED_OBJECTS VALUES(5,0,4,-978370909)
INSERT INTO SECURED_OBJECTS VALUES(8,0,7,-978370909)
INSERT INTO SECURED_OBJECTS VALUES(10,0,0,-1524981484)
INSERT INTO SECURED_OBJECT_TYPES VALUES(11,ru.runa.af.ActorPermission,-984354279)
INSERT INTO SECURED_OBJECT_TYPES VALUES(12,ru.runa.af.GroupPermission,-978370909)
INSERT INTO SECURED_OBJECT_TYPES VALUES(13,ru.runa.wf.WorkflowSystemPermission,    -1524981484)
INSERT INTO SECURED_OBJECT_TYPES VALUES(14,ru.runa.wf.ProcessDefinitionPermission,344855614)
INSERT INTO SECURED_OBJECT_TYPES VALUES(15,ru.runa.wf.ProcessInstancePermission,-1929624128)
INSERT INTO WFE_CONSTANTS(43,ru.runa.database_initialized,true)

What did you suggest Sergey?
I'm testing in Oracle9i.

Thanks for your help,
Regards.

[Dofs]

Hi Natally.
I will work on this problem, and now I understand only cause of this error.
Sergey.

[nat]

Hello Sergey,

When you think you will have a possible solution for this problem? Sorry for being impacient but the company is looking for a stable version of Runa WFE in Oracle. They are very interested in the workflow. I hope you understand my concern.

I will available if you need more feedback or have any comments.

Thanks a lot for your help again,
Regards.

[nat]

Hello Vitaliy,

Have you any notice about the migration of hibernate3? I still have problems with the inserts and updates with the SECURED_OBJECTS table.

Thanks for you help,
Regards.

[Vitaliy Semochkin]

Hello Natalia,

I'm in process of porting to Hibernate3 but so far I'm a bit far from working result.

Regards,
Vitaliy S