<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Why I can't run jbpm4.3 examples on oracle server?
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/june20100606">zhang june</a> in <i>jBPM Development</i> - <a href="http://community.jboss.org/message/553268#553268">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>I was so much confused. I am only going to finish one demo using a process manager, fork two services, then join the two results. I chose jbpm4.3. But, up to now , I can't even  run the examples on oracle.</p><p>First, I run "ant create.jbpm.schema", unsuccessful. I read the script, found varchar2(255 char) was not supported in oracle. So i rewrote the script. Schema was created. I could see them using oracle client.</p><p>Second, I configured the file 'jbpm.hibernate.cfg.xml' , making jdbc to my oracle server, then run one example. Errors below:</p><p>10:29:51,515 FIN | [BaseJbpmTestCase] === starting testAsyncActivity =============================<br/>10:29:52,625 FIN | [WireContext] eagerly initializing org.jbpm.pvm.internal.id.DatabaseIdComposer<br/>10:29:52,703 INF | [Environment] Hibernate 3.3.1.GA<br/>10:29:52,718 INF | [Environment] hibernate.properties not found<br/>10:29:52,718 INF | [Environment] Bytecode provider name : javassist<br/>10:29:52,734 INF | [Environment] using JDK 1.4 java.sql.Timestamp handling<br/>10:29:52,906 INF | [Configuration] configuring from resource: jbpm.hibernate.cfg.xml<br/>10:29:52,906 INF | [Configuration] Configuration resource: jbpm.hibernate.cfg.xml<br/>10:29:53,062 INF | [Configuration] Reading mappings from resource : jbpm.repository.hbm.xml<br/>10:29:53,593 INF | [Configuration] Reading mappings from resource : jbpm.execution.hbm.xml<br/>10:29:54,218 INF | [Configuration] Reading mappings from resource : jbpm.history.hbm.xml<br/>10:29:54,625 INF | [Configuration] Reading mappings from resource : jbpm.task.hbm.xml<br/>10:29:54,890 INF | [Configuration] Reading mappings from resource : jbpm.identity.hbm.xml<br/>10:29:55,093 INF | [Configuration] Configured SessionFactory: null<br/>10:29:55,187 INF | [DriverManagerConnectionProvider] Using Hibernate built-in connection pool (not for production use!)<br/>10:29:55,187 INF | [DriverManagerConnectionProvider] Hibernate connection pool size: 20<br/>10:29:55,187 INF | [DriverManagerConnectionProvider] autocommit mode: false<br/>10:29:55,406 INF | [DriverManagerConnectionProvider] using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin:@192.168.1.227:1521:jbpm</p><p>10:29:55,421 INF | [DriverManagerConnectionProvider] connection properties: {user=jbpm, password=****}<br/>10:30:00,046 INF | [Dialect] Using dialect: org.hibernate.dialect.Oracle10gDialect<br/>10:30:00,062 INF | [TransactionFactoryFactory] Using default transaction strategy (direct JDBC transactions)<br/>10:30:00,078 INF | [TransactionManagerLookupFactory] No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)<br/>10:30:00,125 INF | [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory<br/>10:30:00,281 INF | [SessionFactoryImpl] building session factory<br/>10:30:04,296 INF | [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured<br/>10:30:04,343 INF | [SchemaExport] Running hbm2ddl schema export<br/>10:30:04,343 INF | [SchemaExport] exporting generated schema to database<br/>10:30:06,312 SEV | [SchemaExport] Unsuccessful: create table JBPM4_DEPLOYMENT (DBID_ number(19,0) not null, NAME_ clob, TIMESTAMP_ number(19,0), STATE_ varchar2(255 char), primary key (DBID_))<br/>10:30:06,312 SEV | [SchemaExport] ORA-00907: 缺少右括号</p><p>10:30:06,312 SEV | [SchemaExport] Unsuccessful: create table JBPM4_DEPLOYPROP (DBID_ number(19,0) not null, DEPLOYMENT_ number(19,0), OBJNAME_ varchar2(255 char), KEY_ varchar2(255 char), STRINGVAL_ varchar2(255 char), LONGVAL_ number(19,0), primary key (DBID_))<br/>10:30:06,312 SEV | [SchemaExport] ORA-00907: 缺少右括号</p><p>10:30:06,343 SEV | [SchemaExport] Unsuccessful: create table JBPM4_EXECUTION (DBID_ number(19,0) not null, CLASS_ varchar2(255 char) not null, DBVERSION_ number(10,0) not null, ACTIVITYNAME_ varchar2(255 char), PROCDEFID_ varchar2(255 char), HASVARS_ number(1,0), NAME_ varchar2(255 char), KEY_ varchar2(255 char), ID_ varchar2(255 char) unique, STATE_ varchar2(255 char), SUSPHISTSTATE_ varchar2(255 char), PRIORITY_ number(10,0), HISACTINST_ number(19,0), PARENT_ number(19,0), INSTANCE_ number(19,0), SUPEREXEC_ number(19,0), SUBPROCINST_ number(19,0), PARENT_IDX_ number(10,0), primary key (DBID_))<br/>10:30:06,343 SEV | [SchemaExport] ORA-00907: 缺少右括号</p><p>10:30:06,343 SEV | [SchemaExport] Unsuccessful: create table JBPM4_HIST_ACTINST (DBID_ number(19,0) not null, CLASS_ varchar2(255 char) not null, DBVERSION_ number(10,0) not null, HPROCI_ number(19,0), TYPE_ varchar2(255 char), EXECUTION_ varchar2(255 char), ACTIVITY_NAME_ varchar2(255 char), START_ timestamp, END_ timestamp, DURATION_ number(19,0), TRANSITION_ varchar2(255 char), NEXTIDX_ number(10,0), HTASK_ number(19,0), primary key (DBID_))<br/>10:30:06,343 SEV | [SchemaExport] ORA-00907: 缺少右括号</p><p>10:30:06,343 SEV | [SchemaExport] Unsuccessful: create table JBPM4_HIST_DETAIL (DBID_ number(19,0) not null, CLASS_ varchar2(255 char) not null, DBVERSION_ number(10,0) not null, USERID_ varchar2(255 char), TIME_ timestamp, HPROCI_ number(19,0), HPROCIIDX_ number(10,0), HACTI_ number(19,0), HACTIIDX_ number(10,0), HTASK_ number(19,0), HTASKIDX_ number(10,0), HVAR_ number(19,0), HVARIDX_ number(10,0), MESSAGE_ clob, OLD_STR_ varchar2(255 char), NEW_STR_ varchar2(255 char), OLD_INT_ number(10,0), NEW_INT_ number(10,0), OLD_TIME_ timestamp, NEW_TIME_ timestamp, PARENT_ number(19,0), PARENT_IDX_ number(10,0), primary key (DBID_))<br/>10:30:06,343 SEV | [SchemaExport] ORA-00907: 缺少右括号</p><p>10:30:06,343 SEV | [SchemaExport] Unsuccessful: create table JBPM4_HIST_PROCINST (DBID_ number(19,0) not null, DBVERSION_ number(10,0) not null, ID_ varchar2(255 char), PROCDEFID_ varchar2(255 char), KEY_ varchar2(255 char), START_ timestamp, END_ timestamp, DURATION_ number(19,0), STATE_ varchar2(255 char), ENDACTIVITY_ varchar2(255 char), NEXTIDX_ number(10,0), primary key (DBID_))<br/>10:30:06,359 SEV | [SchemaExport] ORA-00907: 缺少右括号</p><p>10:30:06,359 SEV | [SchemaExport] Unsuccessful: create table JBPM4_HIST_TASK (DBID_ number(19,0) not null, DBVERSION_ number(10,0) not null, EXECUTION_ varchar2(255 char), OUTCOME_ varchar2(255 char), ASSIGNEE_ varchar2(255 char), PRIORITY_ number(10,0), STATE_ varchar2(255 char), CREATE_ timestamp, END_ timestamp, DURATION_ number(19,0), NEXTIDX_ number(10,0), SUPERTASK_ number(19,0), primary key (DBID_))<br/>10:30:06,359 SEV | [SchemaExport] ORA-00907: 缺少右括号</p><p>10:30:06,359 SEV | [SchemaExport] Unsuccessful: create table JBPM4_HIST_VAR (DBID_ number(19,0) not null, DBVERSION_ number(10,0) not null, PROCINSTID_ varchar2(255 char), EXECUTIONID_ varchar2(255 char), VARNAME_ varchar2(255 char), VALUE_ varchar2(255 char), HPROCI_ number(19,0), HTASK_ number(19,0), primary key (DBID_))<br/>10:30:06,359 SEV | [SchemaExport] ORA-00907: 缺少右括号</p><p>10:30:06,375 SEV | [SchemaExport] Unsuccessful: create table JBPM4_ID_GROUP (DBID_ number(19,0) not null, DBVERSION_ number(10,0) not null, ID_ varchar2(255 char), NAME_ varchar2(255 char), TYPE_ varchar2(255 char), PARENT_ number(19,0), primary key (DBID_))<br/>10:30:06,375 SEV | [SchemaExport] ORA-00907: 缺少右括号</p><p>10:30:06,375 SEV | [SchemaExport] Unsuccessful: create table JBPM4_ID_MEMBERSHIP (DBID_ number(19,0) not null, DBVERSION_ number(10,0) not null, USER_ number(19,0), GROUP_ number(19,0), NAME_ varchar2(255 char), primary key (DBID_))<br/>10:30:06,375 SEV | [SchemaExport] ORA-00907: 缺少右括号</p><p>10:30:06,375 SEV | [SchemaExport] Unsuccessful: create table JBPM4_ID_USER (DBID_ number(19,0) not null, DBVERSION_ number(10,0) not null, ID_ varchar2(255 char), PASSWORD_ varchar2(255 char), GIVENNAME_ varchar2(255 char), FAMILYNAME_ varchar2(255 char), BUSINESSEMAIL_ varchar2(255 char), primary key (DBID_))<br/>10:30:06,375 SEV | [SchemaExport] ORA-00907: 缺少右括号</p><p>10:30:06,390 SEV | [SchemaExport] Unsuccessful: create table JBPM4_JOB (DBID_ number(19,0) not null, CLASS_ varchar2(255 char) not null, DBVERSION_ number(10,0) not null, DUEDATE_ timestamp, STATE_ varchar2(255 char), ISEXCLUSIVE_ number(1,0), LOCKOWNER_ varchar2(255 char), LOCKEXPTIME_ timestamp, EXCEPTION_ clob, RETRIES_ number(10,0), PROCESSINSTANCE_ number(19,0), EXECUTION_ number(19,0), CFG_ number(19,0), SIGNAL_ varchar2(255 char), EVENT_ varchar2(255 char), REPEAT_ varchar2(255 char), primary key (DBID_))<br/>10:30:06,390 SEV | [SchemaExport] ORA-00907: 缺少右括号</p><p>10:30:06,437 SEV | [SchemaExport] Unsuccessful: create table JBPM4_PARTICIPATION (DBID_ number(19,0) not null, DBVERSION_ number(10,0) not null, GROUPID_ varchar2(255 char), USERID_ varchar2(255 char), TYPE_ varchar2(255 char), TASK_ number(19,0), SWIMLANE_ number(19,0), primary key (DBID_))<br/>10:30:06,453 SEV | [SchemaExport] ORA-00907: 缺少右括号</p><p>10:30:06,468 SEV | [SchemaExport] Unsuccessful: create table JBPM4_PROPERTY (KEY_ varchar2(255 char) not null, VERSION_ number(10,0) not null, VALUE_ varchar2(255 char), primary key (KEY_))<br/>10:30:06,468 SEV | [SchemaExport] ORA-00907: 缺少右括号</p><p>10:30:06,484 SEV | [SchemaExport] Unsuccessful: create table JBPM4_SWIMLANE (DBID_ number(19,0) not null, DBVERSION_ number(10,0) not null, NAME_ varchar2(255 char), ASSIGNEE_ varchar2(255 char), EXECUTION_ number(19,0), primary key (DBID_))<br/>10:30:06,484 SEV | [SchemaExport] ORA-00907: 缺少右括号</p><p>10:30:06,500 SEV | [SchemaExport] Unsuccessful: create table JBPM4_TASK (DBID_ number(19,0) not null, CLASS_ char(1 char) not null, DBVERSION_ number(10,0) not null, NAME_ varchar2(255 char), DESCR_ clob, STATE_ varchar2(255 char), SUSPHISTSTATE_ varchar2(255 char), ASSIGNEE_ varchar2(255 char), FORM_ varchar2(255 char), PRIORITY_ number(10,0), CREATE_ timestamp, DUEDATE_ timestamp, PROGRESS_ number(10,0), SIGNALLING_ number(1,0), EXECUTION_ID_ varchar2(255 char), ACTIVITY_NAME_ varchar2(255 char), HASVARS_ number(1,0), SUPERTASK_ number(19,0), EXECUTION_ number(19,0), PROCINST_ number(19,0), SWIMLANE_ number(19,0), TASKDEFNAME_ varchar2(255 char), primary key (DBID_))<br/>10:30:06,500 SEV | [SchemaExport] ORA-00907: 缺少右括号</p><p>10:30:06,500 SEV | [SchemaExport] Unsuccessful: create table JBPM4_VARIABLE (DBID_ number(19,0) not null, CLASS_ varchar2(255 char) not null, DBVERSION_ number(10,0) not null, KEY_ varchar2(255 char), CONVERTER_ varchar2(255 char), HIST_ number(1,0), EXECUTION_ number(19,0), TASK_ number(19,0), LOB_ number(19,0), DATE_VALUE_ timestamp, DOUBLE_VALUE_ double precision, CLASSNAME_ varchar2(255 char), LONG_VALUE_ number(19,0), STRING_VALUE_ varchar2(255 char), TEXT_VALUE_ clob, EXESYS_ number(19,0), primary key (DBID_))<br/>10:30:06,500 SEV | [SchemaExport] ORA-00907: 缺少右括号</p><p>10:30:06,515 SEV | [SchemaExport] Unsuccessful: create index IDX_DEPLPROP_DEPL on JBPM4_DEPLOYPROP (DEPLOYMENT_)<br/>10:30:06,515 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,515 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_DEPLOYPROP add constraint FK_DEPLPROP_DEPL foreign key (DEPLOYMENT_) references JBPM4_DEPLOYMENT<br/>10:30:06,515 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,515 SEV | [SchemaExport] Unsuccessful: create index IDX_EXEC_SUPEREXEC on JBPM4_EXECUTION (SUPEREXEC_)<br/>10:30:06,515 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,531 SEV | [SchemaExport] Unsuccessful: create index IDX_EXEC_INSTANCE on JBPM4_EXECUTION (INSTANCE_)<br/>10:30:06,531 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,531 SEV | [SchemaExport] Unsuccessful: create index IDX_EXEC_SUBPI on JBPM4_EXECUTION (SUBPROCINST_)<br/>10:30:06,531 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,531 SEV | [SchemaExport] Unsuccessful: create index IDX_EXEC_PARENT on JBPM4_EXECUTION (PARENT_)<br/>10:30:06,531 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,562 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_EXECUTION add constraint FK_EXEC_PARENT foreign key (PARENT_) references JBPM4_EXECUTION<br/>10:30:06,562 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,562 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_EXECUTION add constraint FK_EXEC_SUBPI foreign key (SUBPROCINST_) references JBPM4_EXECUTION<br/>10:30:06,562 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,578 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_EXECUTION add constraint FK_EXEC_INSTANCE foreign key (INSTANCE_) references JBPM4_EXECUTION<br/>10:30:06,578 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,578 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_EXECUTION add constraint FK_EXEC_SUPEREXEC foreign key (SUPEREXEC_) references JBPM4_EXECUTION<br/>10:30:06,578 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,578 SEV | [SchemaExport] Unsuccessful: create index IDX_HACTI_HPROCI on JBPM4_HIST_ACTINST (HPROCI_)<br/>10:30:06,578 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,578 SEV | [SchemaExport] Unsuccessful: create index IDX_HTI_HTASK on JBPM4_HIST_ACTINST (HTASK_)<br/>10:30:06,593 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,593 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_HIST_ACTINST add constraint FK_HACTI_HPROCI foreign key (HPROCI_) references JBPM4_HIST_PROCINST<br/>10:30:06,593 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,593 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_HIST_ACTINST add constraint FK_HTI_HTASK foreign key (HTASK_) references JBPM4_HIST_TASK<br/>10:30:06,593 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,609 SEV | [SchemaExport] Unsuccessful: create index IDX_HDET_HACTI on JBPM4_HIST_DETAIL (HACTI_)<br/>10:30:06,609 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,609 SEV | [SchemaExport] Unsuccessful: create index IDX_HDET_HPROCI on JBPM4_HIST_DETAIL (HPROCI_)<br/>10:30:06,609 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,609 SEV | [SchemaExport] Unsuccessful: create index IDX_HDET_HVAR on JBPM4_HIST_DETAIL (HVAR_)<br/>10:30:06,609 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,609 SEV | [SchemaExport] Unsuccessful: create index IDX_HDET_HTASK on JBPM4_HIST_DETAIL (HTASK_)<br/>10:30:06,609 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,625 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_HIST_DETAIL add constraint FK_HDETAIL_HPROCI foreign key (HPROCI_) references JBPM4_HIST_PROCINST<br/>10:30:06,625 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,625 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_HIST_DETAIL add constraint FK_HDETAIL_HACTI foreign key (HACTI_) references JBPM4_HIST_ACTINST<br/>10:30:06,625 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,625 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_HIST_DETAIL add constraint FK_HDETAIL_HTASK foreign key (HTASK_) references JBPM4_HIST_TASK<br/>10:30:06,625 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,640 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_HIST_DETAIL add constraint FK_HDETAIL_HVAR foreign key (HVAR_) references JBPM4_HIST_VAR<br/>10:30:06,640 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,656 SEV | [SchemaExport] Unsuccessful: create index IDX_HSUPERT_SUB on JBPM4_HIST_TASK (SUPERTASK_)<br/>10:30:06,656 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,656 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_HIST_TASK add constraint FK_HSUPERT_SUB foreign key (SUPERTASK_) references JBPM4_HIST_TASK<br/>10:30:06,656 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,656 SEV | [SchemaExport] Unsuccessful: create index IDX_HVAR_HPROCI on JBPM4_HIST_VAR (HPROCI_)<br/>10:30:06,656 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,671 SEV | [SchemaExport] Unsuccessful: create index IDX_HVAR_HTASK on JBPM4_HIST_VAR (HTASK_)<br/>10:30:06,671 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,671 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_HIST_VAR add constraint FK_HVAR_HPROCI foreign key (HPROCI_) references JBPM4_HIST_PROCINST<br/>10:30:06,671 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,671 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_HIST_VAR add constraint FK_HVAR_HTASK foreign key (HTASK_) references JBPM4_HIST_TASK<br/>10:30:06,671 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,687 SEV | [SchemaExport] Unsuccessful: create index IDX_GROUP_PARENT on JBPM4_ID_GROUP (PARENT_)<br/>10:30:06,687 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,687 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_ID_GROUP add constraint FK_GROUP_PARENT foreign key (PARENT_) references JBPM4_ID_GROUP<br/>10:30:06,687 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,687 SEV | [SchemaExport] Unsuccessful: create index IDX_MEM_USER on JBPM4_ID_MEMBERSHIP (USER_)<br/>10:30:06,687 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,703 SEV | [SchemaExport] Unsuccessful: create index IDX_MEM_GROUP on JBPM4_ID_MEMBERSHIP (GROUP_)<br/>10:30:06,703 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,703 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_ID_MEMBERSHIP add constraint FK_MEM_GROUP foreign key (GROUP_) references JBPM4_ID_GROUP<br/>10:30:06,703 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,703 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_ID_MEMBERSHIP add constraint FK_MEM_USER foreign key (USER_) references JBPM4_ID_USER<br/>10:30:06,703 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,703 SEV | [SchemaExport] Unsuccessful: create index IDX_JOBRETRIES on JBPM4_JOB (RETRIES_)<br/>10:30:06,718 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,718 SEV | [SchemaExport] Unsuccessful: create index IDX_JOB_CFG on JBPM4_JOB (CFG_)<br/>10:30:06,718 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,718 SEV | [SchemaExport] Unsuccessful: create index IDX_JOB_PRINST on JBPM4_JOB (PROCESSINSTANCE_)<br/>10:30:06,718 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,734 SEV | [SchemaExport] Unsuccessful: create index IDX_JOB_EXE on JBPM4_JOB (EXECUTION_)<br/>10:30:06,734 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,734 SEV | [SchemaExport] Unsuccessful: create index IDX_JOBLOCKEXP on JBPM4_JOB (LOCKEXPTIME_)<br/>10:30:06,734 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,734 SEV | [SchemaExport] Unsuccessful: create index IDX_JOBDUEDATE on JBPM4_JOB (DUEDATE_)<br/>10:30:06,734 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,734 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_JOB add constraint FK_JOB_CFG foreign key (CFG_) references JBPM4_LOB<br/>10:30:06,734 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,750 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_LOB add constraint FK_LOB_DEPLOYMENT foreign key (DEPLOYMENT_) references JBPM4_DEPLOYMENT<br/>10:30:06,750 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,765 SEV | [SchemaExport] Unsuccessful: create index IDX_PART_TASK on JBPM4_PARTICIPATION (TASK_)<br/>10:30:06,765 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,765 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_PARTICIPATION add constraint FK_PART_SWIMLANE foreign key (SWIMLANE_) references JBPM4_SWIMLANE<br/>10:30:06,765 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,781 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_PARTICIPATION add constraint FK_PART_TASK foreign key (TASK_) references JBPM4_TASK<br/>10:30:06,781 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,781 SEV | [SchemaExport] Unsuccessful: create index IDX_SWIMLANE_EXEC on JBPM4_SWIMLANE (EXECUTION_)<br/>10:30:06,781 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,781 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_SWIMLANE add constraint FK_SWIMLANE_EXEC foreign key (EXECUTION_) references JBPM4_EXECUTION<br/>10:30:06,781 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,796 SEV | [SchemaExport] Unsuccessful: create index IDX_TASK_SUPERTASK on JBPM4_TASK (SUPERTASK_)<br/>10:30:06,796 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,796 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_TASK add constraint FK_TASK_SWIML foreign key (SWIMLANE_) references JBPM4_SWIMLANE<br/>10:30:06,796 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,812 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_TASK add constraint FK_TASK_SUPERTASK foreign key (SUPERTASK_) references JBPM4_TASK<br/>10:30:06,812 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,812 SEV | [SchemaExport] Unsuccessful: create index IDX_VAR_EXESYS on JBPM4_VARIABLE (EXESYS_)<br/>10:30:06,812 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,812 SEV | [SchemaExport] Unsuccessful: create index IDX_VAR_TASK on JBPM4_VARIABLE (TASK_)<br/>10:30:06,812 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,828 SEV | [SchemaExport] Unsuccessful: create index IDX_VAR_EXECUTION on JBPM4_VARIABLE (EXECUTION_)<br/>10:30:06,828 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,828 SEV | [SchemaExport] Unsuccessful: create index IDX_VAR_LOB on JBPM4_VARIABLE (LOB_)<br/>10:30:06,828 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,843 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_VARIABLE add constraint FK_VAR_LOB foreign key (LOB_) references JBPM4_LOB<br/>10:30:06,843 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,843 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_VARIABLE add constraint FK_VAR_EXECUTION foreign key (EXECUTION_) references JBPM4_EXECUTION<br/>10:30:06,843 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,843 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_VARIABLE add constraint FK_VAR_EXESYS foreign key (EXESYS_) references JBPM4_EXECUTION<br/>10:30:06,843 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,875 SEV | [SchemaExport] Unsuccessful: alter table JBPM4_VARIABLE add constraint FK_VAR_TASK foreign key (TASK_) references JBPM4_TASK<br/>10:30:06,875 SEV | [SchemaExport] ORA-00942: 表或视图不存在</p><p>10:30:06,875 INF | [SchemaExport] schema export complete</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-size: 12pt;"><strong>Why the example drop the exitent schema and create new?Which java file does this operation?</strong></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I could not see the schema using oracle client.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I didn't learn about junit. Where can I find one java application using jbpm? Maybe I will learn the deploying process more clearly.</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/553268#553268">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in jBPM Development at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2035">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>