Problems Generating Oracle create Script
fletch_g Jul 27, 2005 6:58 PMHi,
I am trying to build Oracle scripts from the starter-kit and am having problems. First, I could not build oracle.scripts. I received the following error:
oracle.scripts:
db.scripts:
[mkdir] Created dir: D:\jbpm\DB-jbpm-starters-kit-with-eclipse-3.0\jbpm-starters-kit-with-eclipse-3.0\jbpm-db\build\
oracle\scripts
[java] java.lang.NoClassDefFoundError: org/jbpm/db/JbpmSchema
[java] Exception in thread "main"
[java] Java Result: 1
I looked around and updated the claspath.jbpm.test in build.xml to include jars in the jbpm/build directory by changing it from this:
<path id="classpath.jbpm.test"> <fileset dir="${jbpm.3.location}/lib" includes="**/*.jar" /> <pathelement path="${basedir}" /> <!-- to get to jbpm.properties --> <pathelement path="${jbpm.3.location}/build/classes.jbpm" /> <pathelement path="${jbpm.3.location}/build/classes.identity" /> <pathelement path="${jbpm.3.location}/build/classes.jbpm.test" /> <pathelement path="${jbpm.3.location}/build/classes.identity.test" /> <pathelement path="${jbpm.3.location}/src/config.files" /> </path>
to this:
<path id="classpath.jbpm.test"> <fileset dir="${jbpm.3.location}/lib" includes="**/*.jar" /> <fileset dir="${jbpm.3.location}/build" includes="**/*.jar" /> <pathelement path="${basedir}" /> <!-- to get to jbpm.properties --> <pathelement path="${jbpm.3.location}/src/config.files" /> </path>
When I ran ant again it completed successfully, but the sql does not look like Oracle and does not work. As an example here is the first table create:
create table JBPM_ACTION
(ID_ bigint generated by default as identity (start with 1),
class char(1) not null,
NAME_ varchar(255),
ISPROPAGATIONALLOWED_ bit,
REFERENCEDACTION_ bigint,
ACTIONDELEGATION_ bigint,
EVENT_ bigint,
PROCESSDEFINITION_ bigint,
EXPRESSION_ varchar(4000),
TIMERNAME_ varchar(255),
DUEDATE_ varchar(255),
REPEAT_ varchar(255),
TRANSITIONNAME_ varchar(255),
TIMERACTION_ bigint,
EVENTINDEX_ integer,
EXCEPTIONHANDLER_ bigint,
EXCEPTIONHANDLERINDEX_ integer,
primary key (ID_));
Am I missing something? I also did the following:
1) Update hibernate.properties to use proper connect info.
2) modify jbpm.3/src/resources/hibernate.cfg.xml: add line true 1, false 0
3) copy classes12.zip to the jbpm-db\oracle\lib directory
Finally, here is some output from the script, it appears to be set to use Oracle but ...
[java] 16:43:44,234 DEBUG JbpmConfiguration : jbpm.hibernate.properties=jbpm.hibernate.properties
[java] 16:43:44,265 INFO Environment : Hibernate 3.0.5
[java] 16:43:44,265 INFO Environment : loaded properties from resource hibernate.properties: {hibernate.connection
.driver_class=oracle.jdbc.driver.OracleDriver, hibernate.cglib.use_reflection_optimizer=true, hibernate.c3p0.max_size=3,
hibernate.dialect=org.hibernate.dialect.Oracle9Dialect, hibernate.c3p0.min_size=1, hibernate.connection.username=jbpmte
st,hibernate.connection.url=jdbc:oracle:thin:@localhost:1521:, hibernate.show_sql=true, hibernate.connection.password=****}