Author: thomas.diesler(a)jboss.com Date: 2009-02-21 08:48:56 -0500 (Sat, 21 Feb 2009) New Revision: 3992 Added: jbpm3/trunk/modules/core/src/main/resources/hibernate.mapping.sybase.xml jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.sybase.hbm.xml jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/log/ActionLog.sybase.hbm.xml jbpm3/trunk/modules/core/src/test/java/org/jbpm/perf/SimplePerformanceTest.java Removed: jbpm3/trunk/modules/core/src/main/resources/hibernate.mapping.sybase.xml jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.sybase.hbm.xml jbpm3/trunk/modules/core/src/test/java/org/jbpm/perf/AsyncCallTest.java Modified: jbpm3/trunk/modules/core/src/main/java/org/jbpm/db/hibernate/StringMax.java jbpm3/trunk/modules/core/src/main/java/org/jbpm/db/hibernate/TextType.java jbpm3/trunk/modules/core/src/main/java/org/jbpm/graph/log/ActionLog.java jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/action/Script.hbm.xml jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/ExceptionHandler.hbm.xml jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/Node.hbm.xml jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/ProcessDefinition.hbm.xml jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/Transition.hbm.xml jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/exe/Comment.hbm.xml jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/log/ActionLog.hbm.xml jbpm3/trunk/modules/core/src/main/resources/org/jbpm/instantiation/Delegation.hbm.xml jbpm3/trunk/modules/core/src/main/resources/org/jbpm/job/Job.hbm.xml jbpm3/trunk/modules/core/src/main/resources/org/jbpm/logging/log/MessageLog.hbm.xml jbpm3/trunk/modules/core/src/main/resources/org/jbpm/module/def/ModuleDefinition.hbm.xml jbpm3/trunk/modules/core/src/main/resources/org/jbpm/taskmgmt/def/Task.hbm.xml jbpm3/trunk/modules/core/src/main/resources/org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml jbpm3/trunk/modules/core/src/test/java/org/jbpm/graph/log/ActionLogDbTest.java jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.db2.sql jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.derby.sql jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.firebird.sql jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.hsqldb.sql jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.informix.sql jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.ingres.sql jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.interbase.sql jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.mckoi.sql jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.mssql.sql jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.oracle.sql jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.pointbase.sql jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.postgresql.sql jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.progress.sql jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.sapdb.sql jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.sybase.sql Log: [JBPM-2056] Restore strictly compatible jbpm322 schema Modified: jbpm3/trunk/modules/core/src/main/java/org/jbpm/db/hibernate/StringMax.java =================================================================== --- jbpm3/trunk/modules/core/src/main/java/org/jbpm/db/hibernate/StringMax.java 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/core/src/main/java/org/jbpm/db/hibernate/StringMax.java 2009-02-21 13:48:56 UTC (rev 3992) @@ -1,37 +1,47 @@ package org.jbpm.db.hibernate; +// $Id$ + import java.sql.PreparedStatement; import java.sql.SQLException; import java.util.Properties; import org.hibernate.type.StringType; +import org.hibernate.usertype.ParameterizedType; import org.jbpm.JbpmException; -public class StringMax extends StringType implements org.hibernate.usertype.ParameterizedType { +/** + * A custom type that truncates string values + */ +public class StringMax extends StringType implements ParameterizedType +{ + private static final long serialVersionUID = 1L; - private static final long serialVersionUID = 1L; - int length = 4000; - public void set(PreparedStatement st, Object value, int index) throws SQLException { + public void set(PreparedStatement st, Object value, int index) throws SQLException + { String string = (String)value; - if ( (value!=null) - && (string.length()>length) - ) { - value = string.substring(0, length); + if (string != null && string.length() > length) + { + string = string.substring(0, length); } - super.set(st, value, index); + super.set(st, string, index); } - public void setParameterValues(Properties parameters) { - if ( (parameters!=null) - && (parameters.containsKey("length")) - ){ - try { - length = Integer.parseInt(parameters.getProperty("length")); - } catch (NumberFormatException e) { - throw new JbpmException("hibernate column type 'string_max' can't parse value '"+parameters.getProperty("length")+"' as a max length. default is 4000.", e); + public void setParameterValues(Properties parameters) + { + if (parameters != null && parameters.containsKey("length")) + { + String propval = parameters.getProperty("length"); + try + { + length = Integer.parseInt(propval); } + catch (NumberFormatException e) + { + throw new JbpmException("hibernate column type 'string_max' can't parse value '" + propval + "' as a max length. default is 4000.", e); + } } } } Modified: jbpm3/trunk/modules/core/src/main/java/org/jbpm/db/hibernate/TextType.java =================================================================== --- jbpm3/trunk/modules/core/src/main/java/org/jbpm/db/hibernate/TextType.java 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/core/src/main/java/org/jbpm/db/hibernate/TextType.java 2009-02-21 13:48:56 UTC (rev 3992) @@ -41,110 +41,138 @@ /** * @author Alejandro Guizar */ -public class TextType implements EnhancedUserType, Serializable { +public class TextType implements EnhancedUserType, Serializable +{ private transient Log log; - private static final boolean IS_VALUE_TRACING_ENABLED = LogFactory.getLog( - StringHelper.qualifier(Type.class.getName())).isTraceEnabled(); + private static final boolean IS_VALUE_TRACING_ENABLED = LogFactory.getLog(StringHelper.qualifier(Type.class.getName())).isTraceEnabled(); private static final long serialVersionUID = 1L; - private Log log() { - if (log == null) { + private Log log() + { + if (log == null) + { log = LogFactory.getLog(getClass()); } return log; } - public Object assemble(Serializable cached, Object owner) throws HibernateException { - if (cached == null) { + public Object assemble(Serializable cached, Object owner) throws HibernateException + { + if (cached == null) + { return null; } - else { + else + { return deepCopy(cached); } } - public Object deepCopy(Object value) throws HibernateException { + public Object deepCopy(Object value) throws HibernateException + { return value; } - public Serializable disassemble(Object value) throws HibernateException { - if (value == null) { + public Serializable disassemble(Object value) throws HibernateException + { + if (value == null) + { return null; } - else { - return (Serializable) deepCopy(value); + else + { + return (Serializable)deepCopy(value); } } - public boolean equals(Object x, Object y) throws HibernateException { + public boolean equals(Object x, Object y) throws HibernateException + { return EqualsHelper.equals(x, y); } - public int hashCode(Object x) throws HibernateException { + public int hashCode(Object x) throws HibernateException + { return x.hashCode(); } - public boolean isMutable() { + public boolean isMutable() + { return false; } - public Object nullSafeGet(ResultSet rs, String[] names, Object owner) throws HibernateException, - SQLException { + public Object nullSafeGet(ResultSet rs, String[] names, Object owner) throws HibernateException, SQLException + { return nullSafeGet(rs, names[0]); } - public Object nullSafeGet(ResultSet rs, String name) throws HibernateException, SQLException { - try { + public Object nullSafeGet(ResultSet rs, String name) throws HibernateException, SQLException + { + try + { Object value = get(rs, name); - if (value == null) { - if (IS_VALUE_TRACING_ENABLED) { + if (value == null) + { + if (IS_VALUE_TRACING_ENABLED) + { log().trace("returning null as column: " + name); } return null; } - else { - if (IS_VALUE_TRACING_ENABLED) { + else + { + if (IS_VALUE_TRACING_ENABLED) + { log().trace("returning '" + toString(value) + "' as column: " + name); } return value; } } - catch (RuntimeException re) { + catch (RuntimeException re) + { log().info("could not read column value from result set: " + name + "; " + re.getMessage()); throw re; } - catch (SQLException se) { + catch (SQLException se) + { log().info("could not read column value from result set: " + name + "; " + se.getMessage()); throw se; } } - public Object get(ResultSet rs, String name) throws HibernateException, SQLException { + public Object get(ResultSet rs, String name) throws HibernateException, SQLException + { // retrieve the value of the designated column in the current row of the // result set as a character reader Reader charReader = rs.getCharacterStream(name); // if the corresponding SQL value is NULL, the reader we got is NULL as well - if (charReader == null || rs.wasNull()) return null; + if (charReader == null || rs.wasNull()) + return null; // Fetch Reader content up to the end - and put characters in a StringBuffer StringBuffer sbuf = new StringBuffer(); - try { + try + { char[] cbuf = new char[1024]; - for (int amountRead; (amountRead = charReader.read(cbuf)) != -1;) { + for (int amountRead; (amountRead = charReader.read(cbuf)) != -1;) + { sbuf.append(cbuf, 0, amountRead); } } - catch (IOException ioe) { + catch (IOException ioe) + { throw new HibernateException("IOException occurred reading text", ioe); } - finally { - try { + finally + { + try + { charReader.close(); } - catch (IOException e) { + catch (IOException e) + { throw new HibernateException("IOException occurred closing stream", e); } } @@ -153,94 +181,100 @@ return sbuf.toString(); } - public void nullSafeSet(PreparedStatement st, Object value, int index) throws HibernateException, - SQLException { - try { - if (value == null) { - if (IS_VALUE_TRACING_ENABLED) { + public void nullSafeSet(PreparedStatement st, Object value, int index) throws HibernateException, SQLException + { + try + { + if (value == null) + { + if (IS_VALUE_TRACING_ENABLED) + { log().trace("binding null to parameter: " + index); } setNull(st, index); } - else { - if (IS_VALUE_TRACING_ENABLED) { + else + { + if (IS_VALUE_TRACING_ENABLED) + { log().trace("binding '" + toString(value) + "' to parameter: " + index); } set(st, value, index); } } - catch (RuntimeException re) { - log().info( - "could not bind value '" - + nullSafeToString(value) - + "' to parameter: " - + index - + "; " - + re.getMessage()); + catch (RuntimeException re) + { + log().info("could not bind value '" + nullSafeToString(value) + "' to parameter: " + index + "; " + re.getMessage()); throw re; } - catch (SQLException se) { - log().info( - "could not bind value '" - + nullSafeToString(value) - + "' to parameter: " - + index - + "; " - + se.getMessage()); + catch (SQLException se) + { + log().info("could not bind value '" + nullSafeToString(value) + "' to parameter: " + index + "; " + se.getMessage()); throw se; } } - public void set(PreparedStatement st, Object value, int index) throws HibernateException, - SQLException { - String str = (String) value; + public void set(PreparedStatement st, Object value, int index) throws HibernateException, SQLException + { + String str = (String)value; st.setCharacterStream(index, new StringReader(str), str.length()); } - public void setNull(PreparedStatement st, int index) throws HibernateException, SQLException { + public void setNull(PreparedStatement st, int index) throws HibernateException, SQLException + { // JBPM-1818: workaround for SQL state JZ0SL: "Unsupported SQL type" with jConnect st.setCharacterStream(index, null, 0); } - public Object replace(Object original, Object target, Object owner) throws HibernateException { + public Object replace(Object original, Object target, Object owner) throws HibernateException + { return original; } - public Class returnedClass() { + public Class returnedClass() + { return String.class; } - public int[] sqlTypes() { + public int[] sqlTypes() + { return new int[] { sqlType() }; } - public int sqlType() { + public int sqlType() + { return Types.CLOB; } - public String objectToSQLString(Object value) { - return '\'' + (String) value + '\''; + public String objectToSQLString(Object value) + { + return '\'' + (String)value + '\''; } - public Object fromXMLString(String xml) { + public Object fromXMLString(String xml) + { return xml == null || xml.length() == 0 ? null : fromStringValue(xml); } - public String toXMLString(Object value) { + public String toXMLString(Object value) + { return toString(value); } - public String nullSafeToString(Object value) throws HibernateException { + public String nullSafeToString(Object value) throws HibernateException + { return value == null ? null : toString(value); } - public String toString(Object val) { - return (String) val; + public String toString(Object val) + { + return (String)val; } - public Object fromStringValue(String xml) { + public Object fromStringValue(String xml) + { return xml; } } Modified: jbpm3/trunk/modules/core/src/main/java/org/jbpm/graph/log/ActionLog.java =================================================================== --- jbpm3/trunk/modules/core/src/main/java/org/jbpm/graph/log/ActionLog.java 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/core/src/main/java/org/jbpm/graph/log/ActionLog.java 2009-02-21 13:48:56 UTC (rev 3992) @@ -27,45 +27,57 @@ import org.jbpm.graph.def.Action; import org.jbpm.logging.log.CompositeLog; -public class ActionLog extends CompositeLog { +public class ActionLog extends CompositeLog +{ private static final long serialVersionUID = 1L; protected Action action = null; protected String exception = null; - - public ActionLog() { + + public ActionLog() + { } - public ActionLog(Action action) { + public ActionLog(Action action) + { this.action = action; } - public String toString() { + public String toString() + { StringBuffer buffer = new StringBuffer(); buffer.append("action["); buffer.append(action); - if (exception!=null) { + if (getException() != null) + { buffer.append(", threw '"); - buffer.append(exception); + buffer.append(getException()); buffer.append("'"); } buffer.append("]"); return buffer.toString(); } - - public void setException(Throwable exception) { + + public void setException(Throwable throwable) + { StringWriter stringWriter = new StringWriter(); - exception.printStackTrace(new PrintWriter(stringWriter)); - this.exception = stringWriter.toString(); + throwable.printStackTrace(new PrintWriter(stringWriter)); + exception = stringWriter.toString(); } - public Action getAction() { + + public Action getAction() + { return action; } - public void setAction(Action action) { + + public void setAction(Action action) + { this.action = action; } - public String getException() { + + public String getException() + { return exception; } } Deleted: jbpm3/trunk/modules/core/src/main/resources/hibernate.mapping.sybase.xml =================================================================== --- jbpm3/trunk/modules/core/src/main/resources/hibernate.mapping.sybase.xml 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/core/src/main/resources/hibernate.mapping.sybase.xml 2009-02-21 13:48:56 UTC (rev 3992) @@ -1,142 +0,0 @@ - <!-- ###################### --> - <!-- # jbpm mapping files # --> - <!-- ###################### --> - - <!-- hql queries --> - <mapping resource="org/jbpm/db/hibernate.queries.hbm.xml" /> - - <!-- sybase type mappings --> - <mapping resource="org/jbpm/db/hibernate.types.sybase.hbm.xml" /> - - <!-- hql queries used in simulation for querying historical data. - uncomment if you want to use the GetSimulationInputCommand - or you want to use the queries directly. - beware: the queries need the stddev function to be enabled in your dialect. - for more information, visit: - http://www.camunda.com/business_process_simulation_news/mysql_and_stddev.... --> - <!-- - <mapping resource="org/jbpm/sim/bam/hibernate.queries.hbm.xml" /> - --> - - <!-- graph.action mapping files --> - <mapping resource="org/jbpm/graph/action/MailAction.hbm.xml"/> - - <!-- graph.def mapping files --> - <mapping resource="org/jbpm/graph/def/ProcessDefinition.hbm.xml"/> - <mapping resource="org/jbpm/graph/def/Node.hbm.xml"/> - <mapping resource="org/jbpm/graph/def/Transition.hbm.xml"/> - <mapping resource="org/jbpm/graph/def/Event.hbm.xml"/> - <mapping resource="org/jbpm/graph/def/Action.hbm.xml"/> - <mapping resource="org/jbpm/graph/def/SuperState.hbm.xml"/> - <mapping resource="org/jbpm/graph/def/ExceptionHandler.hbm.xml"/> - <mapping resource="org/jbpm/instantiation/Delegation.hbm.xml"/> - - <!-- ########################################### --> - <!-- # mapping file with external dependencies # --> - <!-- ########################################### --> - <!-- the following mapping file has a dependency on 'bsh-{version}.jar'. - uncomment this if bsh is not in your classpath. - the script element will not be available in process definition files. - note: this mapping must appear below org/jbpm/graph/def/Action.hbm.xml --> - <mapping resource="org/jbpm/graph/action/Script.hbm.xml"/> - - <!-- graph.node mapping files --> - <mapping resource="org/jbpm/graph/node/StartState.hbm.xml"/> - <mapping resource="org/jbpm/graph/node/EndState.hbm.xml"/> - <mapping resource="org/jbpm/graph/node/ProcessState.hbm.xml"/> - <mapping resource="org/jbpm/graph/node/Decision.hbm.xml"/> - <mapping resource="org/jbpm/graph/node/Fork.hbm.xml"/> - <mapping resource="org/jbpm/graph/node/Join.hbm.xml"/> - <mapping resource="org/jbpm/graph/node/MailNode.hbm.xml"/> - <mapping resource="org/jbpm/graph/node/State.hbm.xml"/> - <mapping resource="org/jbpm/graph/node/TaskNode.hbm.xml"/> - - <!-- context.def mapping files --> - <mapping resource="org/jbpm/context/def/ContextDefinition.hbm.xml"/> - <mapping resource="org/jbpm/context/def/VariableAccess.hbm.xml"/> - - <!-- bytes mapping files --> - <mapping resource="org/jbpm/bytes/ByteArray.hbm.xml"/> - - <!-- module.def mapping files --> - <mapping resource="org/jbpm/module/def/ModuleDefinition.hbm.xml"/> - - <!-- file.def mapping files --> - <mapping resource="org/jbpm/file/def/FileDefinition.hbm.xml"/> - - <!-- taskmgmt.def mapping files --> - <mapping resource="org/jbpm/taskmgmt/def/TaskMgmtDefinition.hbm.xml"/> - <mapping resource="org/jbpm/taskmgmt/def/Swimlane.hbm.xml"/> - <mapping resource="org/jbpm/taskmgmt/def/Task.hbm.xml"/> - <mapping resource="org/jbpm/taskmgmt/def/TaskController.hbm.xml"/> - - <!-- scheduler.def mapping files --> - <mapping resource="org/jbpm/scheduler/def/CreateTimerAction.hbm.xml"/> - <mapping resource="org/jbpm/scheduler/def/CancelTimerAction.hbm.xml"/> - - <!-- graph.exe mapping files --> - <mapping resource="org/jbpm/graph/exe/Comment.hbm.xml"/> - <mapping resource="org/jbpm/graph/exe/ProcessInstance.hbm.xml"/> - <mapping resource="org/jbpm/graph/exe/Token.hbm.xml"/> - <mapping resource="org/jbpm/graph/exe/RuntimeAction.hbm.xml"/> - - <!-- module.exe mapping files --> - <mapping resource="org/jbpm/module/exe/ModuleInstance.hbm.xml"/> - - <!-- context.exe mapping files --> - <mapping resource="org/jbpm/context/exe/ContextInstance.hbm.xml"/> - <mapping resource="org/jbpm/context/exe/TokenVariableMap.hbm.xml"/> - <mapping resource="org/jbpm/context/exe/VariableInstance.hbm.xml"/> - <mapping resource="org/jbpm/context/exe/variableinstance/ByteArrayInstance.hbm.xml"/> - <mapping resource="org/jbpm/context/exe/variableinstance/DateInstance.hbm.xml"/> - <mapping resource="org/jbpm/context/exe/variableinstance/DoubleInstance.hbm.xml"/> - <mapping resource="org/jbpm/context/exe/variableinstance/HibernateLongInstance.hbm.xml"/> - <mapping resource="org/jbpm/context/exe/variableinstance/HibernateStringInstance.sybase.hbm.xml" /> - <mapping resource="org/jbpm/context/exe/variableinstance/LongInstance.hbm.xml"/> - <mapping resource="org/jbpm/context/exe/variableinstance/NullInstance.hbm.xml"/> - <mapping resource="org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml"/> - - <!-- job mapping files --> - <mapping resource="org/jbpm/job/Job.hbm.xml"/> - <mapping resource="org/jbpm/job/Timer.hbm.xml"/> - <mapping resource="org/jbpm/job/ExecuteNodeJob.hbm.xml"/> - <mapping resource="org/jbpm/job/ExecuteActionJob.hbm.xml"/> - <mapping resource="org/jbpm/job/CleanUpProcessJob.hbm.xml"/> - - <!-- taskmgmt.exe mapping files --> - <mapping resource="org/jbpm/taskmgmt/exe/TaskMgmtInstance.hbm.xml"/> - <mapping resource="org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml"/> - <mapping resource="org/jbpm/taskmgmt/exe/PooledActor.hbm.xml"/> - <mapping resource="org/jbpm/taskmgmt/exe/SwimlaneInstance.hbm.xml"/> - - <!-- logging mapping files --> - <mapping resource="org/jbpm/logging/log/ProcessLog.hbm.xml"/> - <mapping resource="org/jbpm/logging/log/MessageLog.hbm.xml"/> - <mapping resource="org/jbpm/logging/log/CompositeLog.hbm.xml"/> - <mapping resource="org/jbpm/graph/log/ActionLog.hbm.xml"/> - <mapping resource="org/jbpm/graph/log/NodeLog.hbm.xml"/> - <mapping resource="org/jbpm/graph/log/ProcessInstanceCreateLog.hbm.xml"/> - <mapping resource="org/jbpm/graph/log/ProcessInstanceEndLog.hbm.xml"/> - <mapping resource="org/jbpm/graph/log/ProcessStateLog.hbm.xml"/> - <mapping resource="org/jbpm/graph/log/SignalLog.hbm.xml"/> - <mapping resource="org/jbpm/graph/log/TokenCreateLog.hbm.xml"/> - <mapping resource="org/jbpm/graph/log/TokenEndLog.hbm.xml"/> - <mapping resource="org/jbpm/graph/log/TransitionLog.hbm.xml"/> - <mapping resource="org/jbpm/context/log/VariableLog.hbm.xml"/> - <mapping resource="org/jbpm/context/log/VariableCreateLog.hbm.xml"/> - <mapping resource="org/jbpm/context/log/VariableDeleteLog.hbm.xml"/> - <mapping resource="org/jbpm/context/log/VariableUpdateLog.hbm.xml"/> - <mapping resource="org/jbpm/context/log/variableinstance/ByteArrayUpdateLog.hbm.xml"/> - <mapping resource="org/jbpm/context/log/variableinstance/DateUpdateLog.hbm.xml"/> - <mapping resource="org/jbpm/context/log/variableinstance/DoubleUpdateLog.hbm.xml"/> - <mapping resource="org/jbpm/context/log/variableinstance/HibernateLongUpdateLog.hbm.xml"/> - <mapping resource="org/jbpm/context/log/variableinstance/HibernateStringUpdateLog.hbm.xml"/> - <mapping resource="org/jbpm/context/log/variableinstance/LongUpdateLog.hbm.xml"/> - <mapping resource="org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml"/> - <mapping resource="org/jbpm/taskmgmt/log/TaskLog.hbm.xml"/> - <mapping resource="org/jbpm/taskmgmt/log/TaskCreateLog.hbm.xml"/> - <mapping resource="org/jbpm/taskmgmt/log/TaskAssignLog.hbm.xml"/> - <mapping resource="org/jbpm/taskmgmt/log/TaskEndLog.hbm.xml"/> - <mapping resource="org/jbpm/taskmgmt/log/SwimlaneLog.hbm.xml"/> - <mapping resource="org/jbpm/taskmgmt/log/SwimlaneCreateLog.hbm.xml"/> - <mapping resource="org/jbpm/taskmgmt/log/SwimlaneAssignLog.hbm.xml"/> Copied: jbpm3/trunk/modules/core/src/main/resources/hibernate.mapping.sybase.xml (from rev 3991, jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/hibernate.mapping.sybase.xml) =================================================================== --- jbpm3/trunk/modules/core/src/main/resources/hibernate.mapping.sybase.xml (rev 0) +++ jbpm3/trunk/modules/core/src/main/resources/hibernate.mapping.sybase.xml 2009-02-21 13:48:56 UTC (rev 3992) @@ -0,0 +1,142 @@ + <!-- ###################### --> + <!-- # jbpm mapping files # --> + <!-- ###################### --> + + <!-- hql queries --> + <mapping resource="org/jbpm/db/hibernate.queries.hbm.xml" /> + + <!-- sybase type mappings --> + <mapping resource="org/jbpm/db/hibernate.types.sybase.hbm.xml" /> + + <!-- hql queries used in simulation for querying historical data. + uncomment if you want to use the GetSimulationInputCommand + or you want to use the queries directly. + beware: the queries need the stddev function to be enabled in your dialect. + for more information, visit: + http://www.camunda.com/business_process_simulation_news/mysql_and_stddev.... --> + <!-- + <mapping resource="org/jbpm/sim/bam/hibernate.queries.hbm.xml" /> + --> + + <!-- graph.action mapping files --> + <mapping resource="org/jbpm/graph/action/MailAction.hbm.xml"/> + + <!-- graph.def mapping files --> + <mapping resource="org/jbpm/graph/def/ProcessDefinition.hbm.xml"/> + <mapping resource="org/jbpm/graph/def/Node.hbm.xml"/> + <mapping resource="org/jbpm/graph/def/Transition.hbm.xml"/> + <mapping resource="org/jbpm/graph/def/Event.hbm.xml"/> + <mapping resource="org/jbpm/graph/def/Action.hbm.xml"/> + <mapping resource="org/jbpm/graph/def/SuperState.hbm.xml"/> + <mapping resource="org/jbpm/graph/def/ExceptionHandler.hbm.xml"/> + <mapping resource="org/jbpm/instantiation/Delegation.hbm.xml"/> + + <!-- ########################################### --> + <!-- # mapping file with external dependencies # --> + <!-- ########################################### --> + <!-- the following mapping file has a dependency on 'bsh-{version}.jar'. + uncomment this if bsh is not in your classpath. + the script element will not be available in process definition files. + note: this mapping must appear below org/jbpm/graph/def/Action.hbm.xml --> + <mapping resource="org/jbpm/graph/action/Script.hbm.xml"/> + + <!-- graph.node mapping files --> + <mapping resource="org/jbpm/graph/node/StartState.hbm.xml"/> + <mapping resource="org/jbpm/graph/node/EndState.hbm.xml"/> + <mapping resource="org/jbpm/graph/node/ProcessState.hbm.xml"/> + <mapping resource="org/jbpm/graph/node/Decision.hbm.xml"/> + <mapping resource="org/jbpm/graph/node/Fork.hbm.xml"/> + <mapping resource="org/jbpm/graph/node/Join.hbm.xml"/> + <mapping resource="org/jbpm/graph/node/MailNode.hbm.xml"/> + <mapping resource="org/jbpm/graph/node/State.hbm.xml"/> + <mapping resource="org/jbpm/graph/node/TaskNode.hbm.xml"/> + + <!-- context.def mapping files --> + <mapping resource="org/jbpm/context/def/ContextDefinition.hbm.xml"/> + <mapping resource="org/jbpm/context/def/VariableAccess.hbm.xml"/> + + <!-- bytes mapping files --> + <mapping resource="org/jbpm/bytes/ByteArray.hbm.xml"/> + + <!-- module.def mapping files --> + <mapping resource="org/jbpm/module/def/ModuleDefinition.hbm.xml"/> + + <!-- file.def mapping files --> + <mapping resource="org/jbpm/file/def/FileDefinition.hbm.xml"/> + + <!-- taskmgmt.def mapping files --> + <mapping resource="org/jbpm/taskmgmt/def/TaskMgmtDefinition.hbm.xml"/> + <mapping resource="org/jbpm/taskmgmt/def/Swimlane.hbm.xml"/> + <mapping resource="org/jbpm/taskmgmt/def/Task.hbm.xml"/> + <mapping resource="org/jbpm/taskmgmt/def/TaskController.hbm.xml"/> + + <!-- scheduler.def mapping files --> + <mapping resource="org/jbpm/scheduler/def/CreateTimerAction.hbm.xml"/> + <mapping resource="org/jbpm/scheduler/def/CancelTimerAction.hbm.xml"/> + + <!-- graph.exe mapping files --> + <mapping resource="org/jbpm/graph/exe/Comment.hbm.xml"/> + <mapping resource="org/jbpm/graph/exe/ProcessInstance.hbm.xml"/> + <mapping resource="org/jbpm/graph/exe/Token.hbm.xml"/> + <mapping resource="org/jbpm/graph/exe/RuntimeAction.hbm.xml"/> + + <!-- module.exe mapping files --> + <mapping resource="org/jbpm/module/exe/ModuleInstance.hbm.xml"/> + + <!-- context.exe mapping files --> + <mapping resource="org/jbpm/context/exe/ContextInstance.hbm.xml"/> + <mapping resource="org/jbpm/context/exe/TokenVariableMap.hbm.xml"/> + <mapping resource="org/jbpm/context/exe/VariableInstance.hbm.xml"/> + <mapping resource="org/jbpm/context/exe/variableinstance/ByteArrayInstance.hbm.xml"/> + <mapping resource="org/jbpm/context/exe/variableinstance/DateInstance.hbm.xml"/> + <mapping resource="org/jbpm/context/exe/variableinstance/DoubleInstance.hbm.xml"/> + <mapping resource="org/jbpm/context/exe/variableinstance/HibernateLongInstance.hbm.xml"/> + <mapping resource="org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml" /> + <mapping resource="org/jbpm/context/exe/variableinstance/LongInstance.hbm.xml"/> + <mapping resource="org/jbpm/context/exe/variableinstance/NullInstance.hbm.xml"/> + <mapping resource="org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml"/> + + <!-- job mapping files --> + <mapping resource="org/jbpm/job/Job.hbm.xml"/> + <mapping resource="org/jbpm/job/Timer.hbm.xml"/> + <mapping resource="org/jbpm/job/ExecuteNodeJob.hbm.xml"/> + <mapping resource="org/jbpm/job/ExecuteActionJob.hbm.xml"/> + <mapping resource="org/jbpm/job/CleanUpProcessJob.hbm.xml"/> + + <!-- taskmgmt.exe mapping files --> + <mapping resource="org/jbpm/taskmgmt/exe/TaskMgmtInstance.hbm.xml"/> + <mapping resource="org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml"/> + <mapping resource="org/jbpm/taskmgmt/exe/PooledActor.hbm.xml"/> + <mapping resource="org/jbpm/taskmgmt/exe/SwimlaneInstance.hbm.xml"/> + + <!-- logging mapping files --> + <mapping resource="org/jbpm/logging/log/ProcessLog.hbm.xml"/> + <mapping resource="org/jbpm/logging/log/MessageLog.hbm.xml"/> + <mapping resource="org/jbpm/logging/log/CompositeLog.hbm.xml"/> + <mapping resource="org/jbpm/graph/log/ActionLog.sybase.hbm.xml"/> + <mapping resource="org/jbpm/graph/log/NodeLog.hbm.xml"/> + <mapping resource="org/jbpm/graph/log/ProcessInstanceCreateLog.hbm.xml"/> + <mapping resource="org/jbpm/graph/log/ProcessInstanceEndLog.hbm.xml"/> + <mapping resource="org/jbpm/graph/log/ProcessStateLog.hbm.xml"/> + <mapping resource="org/jbpm/graph/log/SignalLog.hbm.xml"/> + <mapping resource="org/jbpm/graph/log/TokenCreateLog.hbm.xml"/> + <mapping resource="org/jbpm/graph/log/TokenEndLog.hbm.xml"/> + <mapping resource="org/jbpm/graph/log/TransitionLog.hbm.xml"/> + <mapping resource="org/jbpm/context/log/VariableLog.hbm.xml"/> + <mapping resource="org/jbpm/context/log/VariableCreateLog.hbm.xml"/> + <mapping resource="org/jbpm/context/log/VariableDeleteLog.hbm.xml"/> + <mapping resource="org/jbpm/context/log/VariableUpdateLog.hbm.xml"/> + <mapping resource="org/jbpm/context/log/variableinstance/ByteArrayUpdateLog.hbm.xml"/> + <mapping resource="org/jbpm/context/log/variableinstance/DateUpdateLog.hbm.xml"/> + <mapping resource="org/jbpm/context/log/variableinstance/DoubleUpdateLog.hbm.xml"/> + <mapping resource="org/jbpm/context/log/variableinstance/HibernateLongUpdateLog.hbm.xml"/> + <mapping resource="org/jbpm/context/log/variableinstance/HibernateStringUpdateLog.hbm.xml"/> + <mapping resource="org/jbpm/context/log/variableinstance/LongUpdateLog.hbm.xml"/> + <mapping resource="org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml"/> + <mapping resource="org/jbpm/taskmgmt/log/TaskLog.hbm.xml"/> + <mapping resource="org/jbpm/taskmgmt/log/TaskCreateLog.hbm.xml"/> + <mapping resource="org/jbpm/taskmgmt/log/TaskAssignLog.hbm.xml"/> + <mapping resource="org/jbpm/taskmgmt/log/TaskEndLog.hbm.xml"/> + <mapping resource="org/jbpm/taskmgmt/log/SwimlaneLog.hbm.xml"/> + <mapping resource="org/jbpm/taskmgmt/log/SwimlaneCreateLog.hbm.xml"/> + <mapping resource="org/jbpm/taskmgmt/log/SwimlaneAssignLog.hbm.xml"/> Modified: jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml =================================================================== --- jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml 2009-02-21 13:48:56 UTC (rev 3992) @@ -8,7 +8,7 @@ <subclass name="org.jbpm.context.exe.variableinstance.HibernateStringInstance" extends="org.jbpm.context.exe.VariableInstance" discriminator-value="I"> - <any name="value" id-type="text" cascade="save-update"> + <any name="value" id-type="string" cascade="save-update"> <column name="STRINGIDCLASS_" /> <column name="STRINGVALUE_" length="4000"/> </any> Deleted: jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.sybase.hbm.xml =================================================================== --- jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.sybase.hbm.xml 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.sybase.hbm.xml 2009-02-21 13:48:56 UTC (rev 3992) @@ -1,17 +0,0 @@ -<?xml version="1.0"?> - -<!DOCTYPE hibernate-mapping PUBLIC - "-//Hibernate/Hibernate Mapping DTD 3.0//EN" - "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> - -<hibernate-mapping auto-import="false" default-access="field"> - <subclass name="org.jbpm.context.exe.variableinstance.HibernateStringInstance" - extends="org.jbpm.context.exe.VariableInstance" - discriminator-value="I"> - <!-- id-type seems to be unaware of type definitions --> - <any name="value" id-type="org.jbpm.db.hibernate.TextType" cascade="save-update"> - <column name="STRINGIDCLASS_" /> - <column name="STRINGVALUE_" length="4000"/> - </any> - </subclass> -</hibernate-mapping> Copied: jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.sybase.hbm.xml (from rev 3991, jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.sybase.hbm.xml) =================================================================== --- jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.sybase.hbm.xml (rev 0) +++ jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.sybase.hbm.xml 2009-02-21 13:48:56 UTC (rev 3992) @@ -0,0 +1,17 @@ +<?xml version="1.0"?> + +<!DOCTYPE hibernate-mapping PUBLIC + "-//Hibernate/Hibernate Mapping DTD 3.0//EN" + "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> + +<hibernate-mapping auto-import="false" default-access="field"> + <subclass name="org.jbpm.context.exe.variableinstance.HibernateStringInstance" + extends="org.jbpm.context.exe.VariableInstance" + discriminator-value="I"> + <!-- id-type seems to be unaware of type definitions --> + <any name="value" id-type="org.jbpm.db.hibernate.TextType" cascade="save-update"> + <column name="STRINGIDCLASS_" /> + <column name="STRINGVALUE_" length="4000"/> + </any> + </subclass> +</hibernate-mapping> Modified: jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml =================================================================== --- jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml 2009-02-21 13:48:56 UTC (rev 3992) @@ -8,6 +8,6 @@ <subclass name="org.jbpm.context.exe.variableinstance.StringInstance" extends="org.jbpm.context.exe.VariableInstance" discriminator-value="S"> - <property name="value" column="STRINGVALUE_" type="text" length="4000"/> + <property name="value" column="STRINGVALUE_" type="string" length="4000"/> </subclass> </hibernate-mapping> Modified: jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml =================================================================== --- jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml 2009-02-21 13:48:56 UTC (rev 3992) @@ -9,8 +9,8 @@ <subclass name="org.jbpm.context.log.variableinstance.StringUpdateLog" extends="org.jbpm.context.log.VariableUpdateLog" discriminator-value="U"> - <property name="oldValue" column="OLDSTRINGVALUE_" type="text" length="4000"/> - <property name="newValue" column="NEWSTRINGVALUE_" type="text" length="4000"/> + <property name="oldValue" column="OLDSTRINGVALUE_" type="string" length="4000"/> + <property name="newValue" column="NEWSTRINGVALUE_" type="string" length="4000"/> </subclass> </hibernate-mapping> Modified: jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/action/Script.hbm.xml =================================================================== --- jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/action/Script.hbm.xml 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/action/Script.hbm.xml 2009-02-21 13:48:56 UTC (rev 3992) @@ -7,7 +7,7 @@ <subclass name="org.jbpm.graph.action.Script" discriminator-value="S" extends="org.jbpm.graph.def.Action"> - <property name="expression" column="EXPRESSION_" type="text" length="4000" /> + <property name="expression" column="EXPRESSION_" type="string" length="4000" /> <set name="variableAccesses" cascade="all"> <key column="SCRIPT_" foreign-key="FK_VARACC_SCRIPT"/> <one-to-many class="org.jbpm.context.def.VariableAccess" /> Modified: jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/ExceptionHandler.hbm.xml =================================================================== --- jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/ExceptionHandler.hbm.xml 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/ExceptionHandler.hbm.xml 2009-02-21 13:48:56 UTC (rev 3992) @@ -8,8 +8,7 @@ table="JBPM_EXCEPTIONHANDLER"> <id name="id" column="ID_"><generator class="native" /></id> - <property name="exceptionClassName" column="EXCEPTIONCLASSNAME_" - type="text" length="4000" /> + <property name="exceptionClassName" column="EXCEPTIONCLASSNAME_" type="string" length="4000" /> <any name="graphElement" id-type="long" meta-type="char"> <meta-value value="A" class="org.jbpm.taskmgmt.def.Task"/> Modified: jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/Node.hbm.xml =================================================================== --- jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/Node.hbm.xml 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/Node.hbm.xml 2009-02-21 13:48:56 UTC (rev 3992) @@ -25,7 +25,7 @@ <!-- GRAPHELEMENT --> <property name="name" column="NAME_"/> - <property name="description" column="DESCRIPTION_" type="text" length="4000"/> + <property name="description" column="DESCRIPTION_" type="string" length="4000"/> <many-to-one name="processDefinition" column="PROCESSDEFINITION_" foreign-key="FK_NODE_PROCDEF" Modified: jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/ProcessDefinition.hbm.xml =================================================================== --- jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/ProcessDefinition.hbm.xml 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/ProcessDefinition.hbm.xml 2009-02-21 13:48:56 UTC (rev 3992) @@ -13,7 +13,7 @@ <!-- GRAPHELEMENT --> <!-- base class fields are mapped here --> <property name="name" column="NAME_" /> - <property name="description" column="DESCRIPTION_" type="text" length="4000"/> + <property name="description" column="DESCRIPTION_" type="string" length="4000"/> <map name="events" cascade="all"> <key column="PROCESSDEFINITION_" foreign-key="FK_EVENT_PROCDEF" /> <index column="EVENTTYPE_" type="string"/> Modified: jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/Transition.hbm.xml =================================================================== --- jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/Transition.hbm.xml 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/Transition.hbm.xml 2009-02-21 13:48:56 UTC (rev 3992) @@ -10,7 +10,7 @@ <!-- GRAPHELEMENT --> <property name="name" column="NAME_"/> - <property name="description" column="DESCRIPTION_" type="text" length="4000"/> + <property name="description" column="DESCRIPTION_" type="string" length="4000"/> <many-to-one name="processDefinition" column="PROCESSDEFINITION_" foreign-key="FK_TRANS_PROCDEF" Modified: jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/exe/Comment.hbm.xml =================================================================== --- jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/exe/Comment.hbm.xml 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/exe/Comment.hbm.xml 2009-02-21 13:48:56 UTC (rev 3992) @@ -11,7 +11,7 @@ <property name="actorId" column="ACTORID_"/> <property name="time" column="TIME_"/> - <property name="message" column="MESSAGE_" type="text" length="4000"/> + <property name="message" column="MESSAGE_" type="string" length="4000"/> <many-to-one name="token" column="TOKEN_" foreign-key="FK_COMMENT_TOKEN" Modified: jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/log/ActionLog.hbm.xml =================================================================== --- jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/log/ActionLog.hbm.xml 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/log/ActionLog.hbm.xml 2009-02-21 13:48:56 UTC (rev 3992) @@ -6,16 +6,12 @@ <hibernate-mapping auto-import="false" default-access="field"> - <subclass name="org.jbpm.graph.log.ActionLog" - extends="org.jbpm.logging.log.CompositeLog" - discriminator-value="A"> - - <property name="exception" column="EXCEPTION_" type="text" length="4000"/> - <many-to-one name="action" - column="ACTION_" - class="org.jbpm.graph.def.Action" - foreign-key="FK_LOG_ACTION" /> + <subclass name="org.jbpm.graph.log.ActionLog" extends="org.jbpm.logging.log.CompositeLog" discriminator-value="A"> + <property name="exception" column="EXCEPTION_" type="string" length="4000"/> + + <many-to-one name="action" column="ACTION_" class="org.jbpm.graph.def.Action" foreign-key="FK_LOG_ACTION" /> + </subclass> </hibernate-mapping> Copied: jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/log/ActionLog.sybase.hbm.xml (from rev 3991, jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/log/ActionLog.sybase.hbm.xml) =================================================================== --- jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/log/ActionLog.sybase.hbm.xml (rev 0) +++ jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/log/ActionLog.sybase.hbm.xml 2009-02-21 13:48:56 UTC (rev 3992) @@ -0,0 +1,17 @@ +<?xml version="1.0"?> + +<!DOCTYPE hibernate-mapping PUBLIC + "-//Hibernate/Hibernate Mapping DTD 3.0//EN" + "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> + +<hibernate-mapping auto-import="false" default-access="field"> + + <subclass name="org.jbpm.graph.log.ActionLog" extends="org.jbpm.logging.log.CompositeLog" discriminator-value="A"> + + <property name="exception" column="EXCEPTION_" type="text" length="4000"/> + + <many-to-one name="action" column="ACTION_" class="org.jbpm.graph.def.Action" foreign-key="FK_LOG_ACTION" /> + + </subclass> + +</hibernate-mapping> Modified: jbpm3/trunk/modules/core/src/main/resources/org/jbpm/instantiation/Delegation.hbm.xml =================================================================== --- jbpm3/trunk/modules/core/src/main/resources/org/jbpm/instantiation/Delegation.hbm.xml 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/core/src/main/resources/org/jbpm/instantiation/Delegation.hbm.xml 2009-02-21 13:48:56 UTC (rev 3992) @@ -8,8 +8,8 @@ table="JBPM_DELEGATION"> <id name="id" column="ID_"><generator class="native" /></id> - <property name="className" column="CLASSNAME_" type="text" length="4000" /> - <property name="configuration" column="CONFIGURATION_" type="text" length="4000" /> + <property name="className" column="CLASSNAME_" type="string" length="4000" /> + <property name="configuration" column="CONFIGURATION_" type="string" length="4000" /> <property name="configType" column="CONFIGTYPE_"/> <many-to-one name="processDefinition" Modified: jbpm3/trunk/modules/core/src/main/resources/org/jbpm/job/Job.hbm.xml =================================================================== --- jbpm3/trunk/modules/core/src/main/resources/org/jbpm/job/Job.hbm.xml 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/core/src/main/resources/org/jbpm/job/Job.hbm.xml 2009-02-21 13:48:56 UTC (rev 3992) @@ -35,7 +35,7 @@ <property name="isExclusive" column="ISEXCLUSIVE_" /> <property name="lockOwner" column="LOCKOWNER_" /> <property name="lockTime" column="LOCKTIME_" /> - <property name="exception" column="EXCEPTION_" type="text" length="4000"/> + <property name="exception" column="EXCEPTION_" type="string" length="4000"/> <property name="retries" column="RETRIES_" /> </class> Modified: jbpm3/trunk/modules/core/src/main/resources/org/jbpm/logging/log/MessageLog.hbm.xml =================================================================== --- jbpm3/trunk/modules/core/src/main/resources/org/jbpm/logging/log/MessageLog.hbm.xml 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/core/src/main/resources/org/jbpm/logging/log/MessageLog.hbm.xml 2009-02-21 13:48:56 UTC (rev 3992) @@ -9,7 +9,7 @@ <subclass name="org.jbpm.logging.log.MessageLog" extends="org.jbpm.logging.log.ProcessLog" discriminator-value="M"> - <property name="message" column="MESSAGE_" type="text" length="4000"/> + <property name="message" column="MESSAGE_" type="string" length="4000"/> </subclass> </hibernate-mapping> Modified: jbpm3/trunk/modules/core/src/main/resources/org/jbpm/module/def/ModuleDefinition.hbm.xml =================================================================== --- jbpm3/trunk/modules/core/src/main/resources/org/jbpm/module/def/ModuleDefinition.hbm.xml 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/core/src/main/resources/org/jbpm/module/def/ModuleDefinition.hbm.xml 2009-02-21 13:48:56 UTC (rev 3992) @@ -21,7 +21,7 @@ <!-- : --> <!-- : --> - <property name="name" column="NAME_" type="text" length="4000"/> + <property name="name" column="NAME_" type="string" length="4000"/> <many-to-one name="processDefinition" column="PROCESSDEFINITION_" foreign-key="FK_MODDEF_PROCDEF" Modified: jbpm3/trunk/modules/core/src/main/resources/org/jbpm/taskmgmt/def/Task.hbm.xml =================================================================== --- jbpm3/trunk/modules/core/src/main/resources/org/jbpm/taskmgmt/def/Task.hbm.xml 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/core/src/main/resources/org/jbpm/taskmgmt/def/Task.hbm.xml 2009-02-21 13:48:56 UTC (rev 3992) @@ -12,7 +12,8 @@ <!-- GRAPHELEMENT --> <property name="name" column="NAME_" /> - <property name="description" column="DESCRIPTION_" type="text" length="4000"/> + <property name="description" column="DESCRIPTION_" type="string" length="4000"/> + <many-to-one name="processDefinition" column="PROCESSDEFINITION_" foreign-key="FK_TASK_PROCDEF" Modified: jbpm3/trunk/modules/core/src/main/resources/org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml =================================================================== --- jbpm3/trunk/modules/core/src/main/resources/org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/core/src/main/resources/org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml 2009-02-21 13:48:56 UTC (rev 3992) @@ -14,7 +14,7 @@ <version name="version" column="VERSION_" /> <property name="name" column="NAME_" /> - <property name="description" column="DESCRIPTION_" type="text" length="4000"/> + <property name="description" column="DESCRIPTION_" type="string" length="4000"/> <property name="actorId" column="ACTORID_" index="IDX_TASK_ACTORID"/> <property name="create" column="CREATE_" /> <property name="start" column="START_" /> Modified: jbpm3/trunk/modules/core/src/test/java/org/jbpm/graph/log/ActionLogDbTest.java =================================================================== --- jbpm3/trunk/modules/core/src/test/java/org/jbpm/graph/log/ActionLogDbTest.java 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/core/src/test/java/org/jbpm/graph/log/ActionLogDbTest.java 2009-02-21 13:48:56 UTC (rev 3992) @@ -21,12 +21,14 @@ */ package org.jbpm.graph.log; +import java.io.PrintWriter; +import java.io.StringWriter; + import org.jbpm.db.AbstractDbTestCase; import org.jbpm.graph.def.Action; public class ActionLogDbTest extends AbstractDbTestCase { - public void testActionLog() { Action action = new Action(); @@ -42,11 +44,29 @@ public void testActionExceptionLog() { + RuntimeException rte = getRuntimeException(); + StringWriter stwr = new StringWriter(); + PrintWriter prwr = new PrintWriter(stwr); + rte.printStackTrace(prwr); + ActionLog actionLog = new ActionLog(); - actionLog.setException(new IllegalArgumentException("it's not rocket science")); + actionLog.setException(rte); actionLog = (ActionLog)saveAndReload(actionLog); - assertNotNull(actionLog.getException()); + String rteStr = actionLog.getException(); + assertNotNull("Exception not null", rteStr); + assertEquals("Exception string", stwr.toString().length(), rteStr.length()); + session.delete(actionLog); } + + private RuntimeException getRuntimeException() + { + RuntimeException rte = new RuntimeException("level 0"); + for (int level = 0; level < 10; level++) + { + rte = new RuntimeException("level " + level, rte); + } + return rte; + } } Deleted: jbpm3/trunk/modules/core/src/test/java/org/jbpm/perf/AsyncCallTest.java =================================================================== --- jbpm3/trunk/modules/core/src/test/java/org/jbpm/perf/AsyncCallTest.java 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/core/src/test/java/org/jbpm/perf/AsyncCallTest.java 2009-02-21 13:48:56 UTC (rev 3992) @@ -1,111 +0,0 @@ -/* - * JBoss, Home of Professional Open Source - * Copyright 2005, JBoss Inc., and individual contributors as indicated - * by the @authors tag. See the copyright.txt in the distribution for a - * full listing of individual contributors. - * - * This is free software; you can redistribute it and/or modify it - * under the terms of the GNU Lesser General Public License as - * published by the Free Software Foundation; either version 2.1 of - * the License, or (at your option) any later version. - * - * This software is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU - * Lesser General Public License for more details. - * - * You should have received a copy of the GNU Lesser General Public - * License along with this software; if not, write to the Free - * Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA - * 02110-1301 USA, or see the FSF site: http://www.fsf.org. - */ -package org.jbpm.perf; - -// $Id$ - -import org.apache.commons.logging.Log; -import org.apache.commons.logging.LogFactory; -import org.jbpm.command.CommandService; -import org.jbpm.command.StartProcessInstanceCommand; -import org.jbpm.command.impl.CommandServiceImpl; -import org.jbpm.db.AbstractDbTestCase; -import org.jbpm.graph.def.ActionHandler; -import org.jbpm.graph.def.ProcessDefinition; -import org.jbpm.graph.exe.ExecutionContext; -import org.jbpm.graph.exe.ProcessInstance; - -/** - * This tests creates 10000 process instances. Every instance has an async call - * to the test class. See JIRA bugs SOA-1175 and JBPM-2043. - * - * @author mvecera(a)redhat.com - * @author pmacik(a)redhat.com - * @author thomas.diesler(a)jboss.com - * @since 18-Feb-2009 - */ -public class AsyncCallTest extends AbstractDbTestCase -{ - private static final Log log = LogFactory.getLog(AsyncCallTest.class); - - private CommandService commandService = new CommandServiceImpl(getJbpmConfiguration()); - private static final int INSTANCES = 1000; - private static int count; - - ProcessDefinition processDefinition; - - public void setUp() throws Exception - { - super.setUp(); - - processDefinition = ProcessDefinition.parseXmlString( - "<process-definition xmlns='urn:jbpm.org:jpdl-3.1' name='processDefinition1'>" + - " <start-state name='start'>" + - " <transition name='to_state' to='end'>" + - " <action class='" + PerfActionHandler.class.getName() + "'/>" + - " </transition>" + - " </start-state>" + - " <end-state name='end'/>" + - "</process-definition>"); - - saveAndReload(processDefinition); - } - - public void tearDown() throws Exception - { - beginSessionTransaction(); - jbpmContext.getGraphSession().deleteProcessDefinition(processDefinition.getId()); - super.tearDown(); - } - - public void testAsyncCall() - { - long start = System.currentTimeMillis(); - - commitAndCloseSession(); - startJobExecutor(); - - for (count = 0; count < INSTANCES; count++) - { - beginSessionTransaction(); - StartProcessInstanceCommand startCommand = new StartProcessInstanceCommand(); - startCommand.setProcessId(processDefinition.getId()); - startCommand.setProcessName("processDefinition1"); - ProcessInstance pi = (ProcessInstance)commandService.execute(startCommand); - commitAndCloseSession(); - } - - stopJobExecutor(); - - long stop = System.currentTimeMillis(); - System.out.println("=== Test finished processing " + INSTANCES + " instances in " + (stop - start) + "ms ==="); - System.out.println("=== This is " + Math.round(1000 * INSTANCES / (stop - start)) + " instances per second ==="); - } - - public static class PerfActionHandler implements ActionHandler - { - public void execute(ExecutionContext executionContext) throws Exception - { - //System.out.println(count); - } - } -} Copied: jbpm3/trunk/modules/core/src/test/java/org/jbpm/perf/SimplePerformanceTest.java (from rev 3991, jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/test/java/org/jbpm/perf/SimplePerformanceTest.java) =================================================================== --- jbpm3/trunk/modules/core/src/test/java/org/jbpm/perf/SimplePerformanceTest.java (rev 0) +++ jbpm3/trunk/modules/core/src/test/java/org/jbpm/perf/SimplePerformanceTest.java 2009-02-21 13:48:56 UTC (rev 3992) @@ -0,0 +1,110 @@ +/* + * JBoss, Home of Professional Open Source + * Copyright 2005, JBoss Inc., and individual contributors as indicated + * by the @authors tag. See the copyright.txt in the distribution for a + * full listing of individual contributors. + * + * This is free software; you can redistribute it and/or modify it + * under the terms of the GNU Lesser General Public License as + * published by the Free Software Foundation; either version 2.1 of + * the License, or (at your option) any later version. + * + * This software is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. + * + * You should have received a copy of the GNU Lesser General Public + * License along with this software; if not, write to the Free + * Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA + * 02110-1301 USA, or see the FSF site: http://www.fsf.org. + */ +package org.jbpm.perf; + +// $Id$ + +import org.apache.commons.logging.Log; +import org.apache.commons.logging.LogFactory; +import org.jbpm.command.CommandService; +import org.jbpm.command.StartProcessInstanceCommand; +import org.jbpm.command.impl.CommandServiceImpl; +import org.jbpm.db.AbstractDbTestCase; +import org.jbpm.graph.def.ActionHandler; +import org.jbpm.graph.def.ProcessDefinition; +import org.jbpm.graph.exe.ExecutionContext; +import org.jbpm.graph.exe.ProcessInstance; + +/** + * This tests creates a number of process instances. + * Every instance has a call to an ActionHandler. + * + * https://jira.jboss.org/jira/browse/JBPM-2043 + * + * @author mvecera(a)redhat.com + * @author pmacik(a)redhat.com + * @author thomas.diesler(a)jboss.com + * @since 18-Feb-2009 + */ +public class SimplePerformanceTest extends AbstractDbTestCase +{ + private static final Log log = LogFactory.getLog(SimplePerformanceTest.class); + + private CommandService commandService = new CommandServiceImpl(getJbpmConfiguration()); + private static final int INSTANCES = 1000; + private static int count; + + ProcessDefinition processDefinition; + + public void setUp() throws Exception + { + super.setUp(); + + processDefinition = ProcessDefinition.parseXmlString( + "<process-definition xmlns='urn:jbpm.org:jpdl-3.1' name='processDefinition1'>" + + " <start-state name='start'>" + + " <transition name='to_state' to='end'>" + + " <action class='" + PerfActionHandler.class.getName() + "'/>" + + " </transition>" + + " </start-state>" + + " <end-state name='end'/>" + + "</process-definition>"); + + saveAndReload(processDefinition); + } + + public void tearDown() throws Exception + { + beginSessionTransaction(); + jbpmContext.getGraphSession().deleteProcessDefinition(processDefinition.getId()); + super.tearDown(); + } + + public void testAsyncCall() + { + long start = System.currentTimeMillis(); + + commitAndCloseSession(); + + for (count = 0; count < INSTANCES; count++) + { + beginSessionTransaction(); + StartProcessInstanceCommand startCommand = new StartProcessInstanceCommand(); + startCommand.setProcessId(processDefinition.getId()); + startCommand.setProcessName("processDefinition1"); + ProcessInstance pi = (ProcessInstance)commandService.execute(startCommand); + commitAndCloseSession(); + } + + long stop = System.currentTimeMillis(); + System.out.println("=== Test finished processing " + INSTANCES + " instances in " + (stop - start) + "ms ==="); + System.out.println("=== This is " + Math.round(1000 * INSTANCES / (stop - start)) + " instances per second ==="); + } + + public static class PerfActionHandler implements ActionHandler + { + public void execute(ExecutionContext executionContext) throws Exception + { + //System.out.println(count); + } + } +} Modified: jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.db2.sql =================================================================== --- jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.db2.sql 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.db2.sql 2009-02-21 13:48:56 UTC (rev 3992) @@ -1,35 +1,3 @@ -drop table JBPM_ACTION -drop table JBPM_BYTEARRAY -drop table JBPM_BYTEBLOCK -drop table JBPM_COMMENT -drop table JBPM_DECISIONCONDITIONS -drop table JBPM_DELEGATION -drop table JBPM_EVENT -drop table JBPM_EXCEPTIONHANDLER -drop table JBPM_ID_GROUP -drop table JBPM_ID_MEMBERSHIP -drop table JBPM_ID_PERMISSIONS -drop table JBPM_ID_USER -drop table JBPM_JOB -drop table JBPM_LOG -drop table JBPM_MODULEDEFINITION -drop table JBPM_MODULEINSTANCE -drop table JBPM_NODE -drop table JBPM_POOLEDACTOR -drop table JBPM_PROCESSDEFINITION -drop table JBPM_PROCESSINSTANCE -drop table JBPM_RUNTIMEACTION -drop table JBPM_SWIMLANE -drop table JBPM_SWIMLANEINSTANCE -drop table JBPM_TASK -drop table JBPM_TASKACTORPOOL -drop table JBPM_TASKCONTROLLER -drop table JBPM_TASKINSTANCE -drop table JBPM_TOKEN -drop table JBPM_TOKENVARIABLEMAP -drop table JBPM_TRANSITION -drop table JBPM_VARIABLEACCESS -drop table JBPM_VARIABLEINSTANCE create table JBPM_ACTION (ID_ bigint generated by default as identity, class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ smallint, ACTIONEXPRESSION_ varchar(255), ISASYNC_ smallint, 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_)) create table JBPM_BYTEARRAY (ID_ bigint generated by default as identity, NAME_ varchar(255), FILEDEFINITION_ bigint, primary key (ID_)) create table JBPM_BYTEBLOCK (PROCESSFILE_ bigint not null, BYTES_ varchar(1024) for bit data, INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_)) Modified: jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.derby.sql =================================================================== --- jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.derby.sql 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.derby.sql 2009-02-21 13:48:56 UTC (rev 3992) @@ -1,126 +1,3 @@ -alter table JBPM_ACTION drop constraint FK_ACTION_REFACT -alter table JBPM_ACTION drop constraint FK_CRTETIMERACT_TA -alter table JBPM_ACTION drop constraint FK_ACTION_PROCDEF -alter table JBPM_ACTION drop constraint FK_ACTION_EVENT -alter table JBPM_ACTION drop constraint FK_ACTION_ACTNDEL -alter table JBPM_ACTION drop constraint FK_ACTION_EXPTHDL -alter table JBPM_BYTEARRAY drop constraint FK_BYTEARR_FILDEF -alter table JBPM_BYTEBLOCK drop constraint FK_BYTEBLOCK_FILE -alter table JBPM_COMMENT drop constraint FK_COMMENT_TOKEN -alter table JBPM_COMMENT drop constraint FK_COMMENT_TSK -alter table JBPM_DECISIONCONDITIONS drop constraint FK_DECCOND_DEC -alter table JBPM_DELEGATION drop constraint FK_DELEGATION_PRCD -alter table JBPM_EVENT drop constraint FK_EVENT_PROCDEF -alter table JBPM_EVENT drop constraint FK_EVENT_TRANS -alter table JBPM_EVENT drop constraint FK_EVENT_NODE -alter table JBPM_EVENT drop constraint FK_EVENT_TASK -alter table JBPM_ID_GROUP drop constraint FK_ID_GRP_PARENT -alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_GRP -alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_USR -alter table JBPM_JOB drop constraint FK_JOB_PRINST -alter table JBPM_JOB drop constraint FK_JOB_ACTION -alter table JBPM_JOB drop constraint FK_JOB_TOKEN -alter table JBPM_JOB drop constraint FK_JOB_NODE -alter table JBPM_JOB drop constraint FK_JOB_TSKINST -alter table JBPM_LOG drop constraint FK_LOG_SOURCENODE -alter table JBPM_LOG drop constraint FK_LOG_DESTNODE -alter table JBPM_LOG drop constraint FK_LOG_TOKEN -alter table JBPM_LOG drop constraint FK_LOG_TRANSITION -alter table JBPM_LOG drop constraint FK_LOG_TASKINST -alter table JBPM_LOG drop constraint FK_LOG_CHILDTOKEN -alter table JBPM_LOG drop constraint FK_LOG_OLDBYTES -alter table JBPM_LOG drop constraint FK_LOG_SWIMINST -alter table JBPM_LOG drop constraint FK_LOG_NEWBYTES -alter table JBPM_LOG drop constraint FK_LOG_ACTION -alter table JBPM_LOG drop constraint FK_LOG_VARINST -alter table JBPM_LOG drop constraint FK_LOG_NODE -alter table JBPM_LOG drop constraint FK_LOG_PARENT -alter table JBPM_MODULEDEFINITION drop constraint FK_MODDEF_PROCDEF -alter table JBPM_MODULEDEFINITION drop constraint FK_TSKDEF_START -alter table JBPM_MODULEINSTANCE drop constraint FK_MODINST_PRCINST -alter table JBPM_MODULEINSTANCE drop constraint FK_TASKMGTINST_TMD -alter table JBPM_NODE drop constraint FK_DECISION_DELEG -alter table JBPM_NODE drop constraint FK_NODE_PROCDEF -alter table JBPM_NODE drop constraint FK_NODE_ACTION -alter table JBPM_NODE drop constraint FK_PROCST_SBPRCDEF -alter table JBPM_NODE drop constraint FK_NODE_SCRIPT -alter table JBPM_NODE drop constraint FK_NODE_SUPERSTATE -alter table JBPM_POOLEDACTOR drop constraint FK_POOLEDACTOR_SLI -alter table JBPM_PROCESSDEFINITION drop constraint FK_PROCDEF_STRTSTA -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_PROCDEF -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_ROOTTKN -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_SPROCTKN -alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_PROCINST -alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_ACTION -alter table JBPM_SWIMLANE drop constraint FK_SWL_ASSDEL -alter table JBPM_SWIMLANE drop constraint FK_SWL_TSKMGMTDEF -alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_TM -alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_SL -alter table JBPM_TASK drop constraint FK_TASK_STARTST -alter table JBPM_TASK drop constraint FK_TASK_PROCDEF -alter table JBPM_TASK drop constraint FK_TASK_ASSDEL -alter table JBPM_TASK drop constraint FK_TASK_SWIMLANE -alter table JBPM_TASK drop constraint FK_TASK_TASKNODE -alter table JBPM_TASK drop constraint FK_TASK_TASKMGTDEF -alter table JBPM_TASK drop constraint FK_TSK_TSKCTRL -alter table JBPM_TASKACTORPOOL drop constraint FK_TASKACTPL_TSKI -alter table JBPM_TASKACTORPOOL drop constraint FK_TSKACTPOL_PLACT -alter table JBPM_TASKCONTROLLER drop constraint FK_TSKCTRL_DELEG -alter table JBPM_TASKINSTANCE drop constraint FK_TSKINS_PRCINS -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TMINST -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TOKEN -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_SLINST -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TASK -alter table JBPM_TOKEN drop constraint FK_TOKEN_SUBPI -alter table JBPM_TOKEN drop constraint FK_TOKEN_PROCINST -alter table JBPM_TOKEN drop constraint FK_TOKEN_NODE -alter table JBPM_TOKEN drop constraint FK_TOKEN_PARENT -alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_TOKEN -alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_CTXT -alter table JBPM_TRANSITION drop constraint FK_TRANSITION_FROM -alter table JBPM_TRANSITION drop constraint FK_TRANS_PROCDEF -alter table JBPM_TRANSITION drop constraint FK_TRANSITION_TO -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_PROCST -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_SCRIPT -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_TSKCTRL -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_PRCINST -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TKVARMP -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TK -alter table JBPM_VARIABLEINSTANCE drop constraint FK_BYTEINST_ARRAY -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VAR_TSKINST -drop table JBPM_ACTION -drop table JBPM_BYTEARRAY -drop table JBPM_BYTEBLOCK -drop table JBPM_COMMENT -drop table JBPM_DECISIONCONDITIONS -drop table JBPM_DELEGATION -drop table JBPM_EVENT -drop table JBPM_EXCEPTIONHANDLER -drop table JBPM_ID_GROUP -drop table JBPM_ID_MEMBERSHIP -drop table JBPM_ID_PERMISSIONS -drop table JBPM_ID_USER -drop table JBPM_JOB -drop table JBPM_LOG -drop table JBPM_MODULEDEFINITION -drop table JBPM_MODULEINSTANCE -drop table JBPM_NODE -drop table JBPM_POOLEDACTOR -drop table JBPM_PROCESSDEFINITION -drop table JBPM_PROCESSINSTANCE -drop table JBPM_RUNTIMEACTION -drop table JBPM_SWIMLANE -drop table JBPM_SWIMLANEINSTANCE -drop table JBPM_TASK -drop table JBPM_TASKACTORPOOL -drop table JBPM_TASKCONTROLLER -drop table JBPM_TASKINSTANCE -drop table JBPM_TOKEN -drop table JBPM_TOKENVARIABLEMAP -drop table JBPM_TRANSITION -drop table JBPM_VARIABLEACCESS -drop table JBPM_VARIABLEINSTANCE -drop table hibernate_unique_key create table JBPM_ACTION (ID_ bigint not null, class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ smallint, ACTIONEXPRESSION_ varchar(255), ISASYNC_ smallint, 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_)) create table JBPM_BYTEARRAY (ID_ bigint not null, NAME_ varchar(255), FILEDEFINITION_ bigint, primary key (ID_)) create table JBPM_BYTEBLOCK (PROCESSFILE_ bigint not null, BYTES_ varchar(1024) for bit data, INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_)) Modified: jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.firebird.sql =================================================================== --- jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.firebird.sql 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.firebird.sql 2009-02-21 13:48:56 UTC (rev 3992) @@ -1,126 +1,3 @@ -alter table JBPM_ACTION drop constraint FK_ACTION_REFACT -alter table JBPM_ACTION drop constraint FK_CRTETIMERACT_TA -alter table JBPM_ACTION drop constraint FK_ACTION_PROCDEF -alter table JBPM_ACTION drop constraint FK_ACTION_EVENT -alter table JBPM_ACTION drop constraint FK_ACTION_ACTNDEL -alter table JBPM_ACTION drop constraint FK_ACTION_EXPTHDL -alter table JBPM_BYTEARRAY drop constraint FK_BYTEARR_FILDEF -alter table JBPM_BYTEBLOCK drop constraint FK_BYTEBLOCK_FILE -alter table JBPM_COMMENT drop constraint FK_COMMENT_TOKEN -alter table JBPM_COMMENT drop constraint FK_COMMENT_TSK -alter table JBPM_DECISIONCONDITIONS drop constraint FK_DECCOND_DEC -alter table JBPM_DELEGATION drop constraint FK_DELEGATION_PRCD -alter table JBPM_EVENT drop constraint FK_EVENT_PROCDEF -alter table JBPM_EVENT drop constraint FK_EVENT_TRANS -alter table JBPM_EVENT drop constraint FK_EVENT_NODE -alter table JBPM_EVENT drop constraint FK_EVENT_TASK -alter table JBPM_ID_GROUP drop constraint FK_ID_GRP_PARENT -alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_GRP -alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_USR -alter table JBPM_JOB drop constraint FK_JOB_PRINST -alter table JBPM_JOB drop constraint FK_JOB_ACTION -alter table JBPM_JOB drop constraint FK_JOB_TOKEN -alter table JBPM_JOB drop constraint FK_JOB_NODE -alter table JBPM_JOB drop constraint FK_JOB_TSKINST -alter table JBPM_LOG drop constraint FK_LOG_SOURCENODE -alter table JBPM_LOG drop constraint FK_LOG_DESTNODE -alter table JBPM_LOG drop constraint FK_LOG_TOKEN -alter table JBPM_LOG drop constraint FK_LOG_TRANSITION -alter table JBPM_LOG drop constraint FK_LOG_TASKINST -alter table JBPM_LOG drop constraint FK_LOG_CHILDTOKEN -alter table JBPM_LOG drop constraint FK_LOG_OLDBYTES -alter table JBPM_LOG drop constraint FK_LOG_SWIMINST -alter table JBPM_LOG drop constraint FK_LOG_NEWBYTES -alter table JBPM_LOG drop constraint FK_LOG_ACTION -alter table JBPM_LOG drop constraint FK_LOG_VARINST -alter table JBPM_LOG drop constraint FK_LOG_NODE -alter table JBPM_LOG drop constraint FK_LOG_PARENT -alter table JBPM_MODULEDEFINITION drop constraint FK_MODDEF_PROCDEF -alter table JBPM_MODULEDEFINITION drop constraint FK_TSKDEF_START -alter table JBPM_MODULEINSTANCE drop constraint FK_MODINST_PRCINST -alter table JBPM_MODULEINSTANCE drop constraint FK_TASKMGTINST_TMD -alter table JBPM_NODE drop constraint FK_DECISION_DELEG -alter table JBPM_NODE drop constraint FK_NODE_PROCDEF -alter table JBPM_NODE drop constraint FK_NODE_ACTION -alter table JBPM_NODE drop constraint FK_PROCST_SBPRCDEF -alter table JBPM_NODE drop constraint FK_NODE_SCRIPT -alter table JBPM_NODE drop constraint FK_NODE_SUPERSTATE -alter table JBPM_POOLEDACTOR drop constraint FK_POOLEDACTOR_SLI -alter table JBPM_PROCESSDEFINITION drop constraint FK_PROCDEF_STRTSTA -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_PROCDEF -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_ROOTTKN -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_SPROCTKN -alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_PROCINST -alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_ACTION -alter table JBPM_SWIMLANE drop constraint FK_SWL_ASSDEL -alter table JBPM_SWIMLANE drop constraint FK_SWL_TSKMGMTDEF -alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_TM -alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_SL -alter table JBPM_TASK drop constraint FK_TASK_STARTST -alter table JBPM_TASK drop constraint FK_TASK_PROCDEF -alter table JBPM_TASK drop constraint FK_TASK_ASSDEL -alter table JBPM_TASK drop constraint FK_TASK_SWIMLANE -alter table JBPM_TASK drop constraint FK_TASK_TASKNODE -alter table JBPM_TASK drop constraint FK_TASK_TASKMGTDEF -alter table JBPM_TASK drop constraint FK_TSK_TSKCTRL -alter table JBPM_TASKACTORPOOL drop constraint FK_TASKACTPL_TSKI -alter table JBPM_TASKACTORPOOL drop constraint FK_TSKACTPOL_PLACT -alter table JBPM_TASKCONTROLLER drop constraint FK_TSKCTRL_DELEG -alter table JBPM_TASKINSTANCE drop constraint FK_TSKINS_PRCINS -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TMINST -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TOKEN -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_SLINST -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TASK -alter table JBPM_TOKEN drop constraint FK_TOKEN_SUBPI -alter table JBPM_TOKEN drop constraint FK_TOKEN_PROCINST -alter table JBPM_TOKEN drop constraint FK_TOKEN_NODE -alter table JBPM_TOKEN drop constraint FK_TOKEN_PARENT -alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_TOKEN -alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_CTXT -alter table JBPM_TRANSITION drop constraint FK_TRANSITION_FROM -alter table JBPM_TRANSITION drop constraint FK_TRANS_PROCDEF -alter table JBPM_TRANSITION drop constraint FK_TRANSITION_TO -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_PROCST -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_SCRIPT -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_TSKCTRL -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_PRCINST -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TKVARMP -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TK -alter table JBPM_VARIABLEINSTANCE drop constraint FK_BYTEINST_ARRAY -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VAR_TSKINST -drop table JBPM_ACTION -drop table JBPM_BYTEARRAY -drop table JBPM_BYTEBLOCK -drop table JBPM_COMMENT -drop table JBPM_DECISIONCONDITIONS -drop table JBPM_DELEGATION -drop table JBPM_EVENT -drop table JBPM_EXCEPTIONHANDLER -drop table JBPM_ID_GROUP -drop table JBPM_ID_MEMBERSHIP -drop table JBPM_ID_PERMISSIONS -drop table JBPM_ID_USER -drop table JBPM_JOB -drop table JBPM_LOG -drop table JBPM_MODULEDEFINITION -drop table JBPM_MODULEINSTANCE -drop table JBPM_NODE -drop table JBPM_POOLEDACTOR -drop table JBPM_PROCESSDEFINITION -drop table JBPM_PROCESSINSTANCE -drop table JBPM_RUNTIMEACTION -drop table JBPM_SWIMLANE -drop table JBPM_SWIMLANEINSTANCE -drop table JBPM_TASK -drop table JBPM_TASKACTORPOOL -drop table JBPM_TASKCONTROLLER -drop table JBPM_TASKINSTANCE -drop table JBPM_TOKEN -drop table JBPM_TOKENVARIABLEMAP -drop table JBPM_TRANSITION -drop table JBPM_VARIABLEACCESS -drop table JBPM_VARIABLEINSTANCE -drop generator hibernate_sequence create table JBPM_ACTION (ID_ numeric(18,0) not null, class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ smallint, ACTIONEXPRESSION_ varchar(255), ISASYNC_ smallint, REFERENCEDACTION_ numeric(18,0), ACTIONDELEGATION_ numeric(18,0), EVENT_ numeric(18,0), PROCESSDEFINITION_ numeric(18,0), EXPRESSION_ varchar(4000), TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ numeric(18,0), EVENTINDEX_ integer, EXCEPTIONHANDLER_ numeric(18,0), EXCEPTIONHANDLERINDEX_ integer, primary key (ID_)) create table JBPM_BYTEARRAY (ID_ numeric(18,0) not null, NAME_ varchar(255), FILEDEFINITION_ numeric(18,0), primary key (ID_)) create table JBPM_BYTEBLOCK (PROCESSFILE_ numeric(18,0) not null, BYTES_ blob, INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_)) Modified: jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.hsqldb.sql =================================================================== --- jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.hsqldb.sql 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.hsqldb.sql 2009-02-21 13:48:56 UTC (rev 3992) @@ -1,125 +1,3 @@ -alter table JBPM_ACTION drop constraint FK_ACTION_REFACT -alter table JBPM_ACTION drop constraint FK_CRTETIMERACT_TA -alter table JBPM_ACTION drop constraint FK_ACTION_PROCDEF -alter table JBPM_ACTION drop constraint FK_ACTION_EVENT -alter table JBPM_ACTION drop constraint FK_ACTION_ACTNDEL -alter table JBPM_ACTION drop constraint FK_ACTION_EXPTHDL -alter table JBPM_BYTEARRAY drop constraint FK_BYTEARR_FILDEF -alter table JBPM_BYTEBLOCK drop constraint FK_BYTEBLOCK_FILE -alter table JBPM_COMMENT drop constraint FK_COMMENT_TOKEN -alter table JBPM_COMMENT drop constraint FK_COMMENT_TSK -alter table JBPM_DECISIONCONDITIONS drop constraint FK_DECCOND_DEC -alter table JBPM_DELEGATION drop constraint FK_DELEGATION_PRCD -alter table JBPM_EVENT drop constraint FK_EVENT_PROCDEF -alter table JBPM_EVENT drop constraint FK_EVENT_TRANS -alter table JBPM_EVENT drop constraint FK_EVENT_NODE -alter table JBPM_EVENT drop constraint FK_EVENT_TASK -alter table JBPM_ID_GROUP drop constraint FK_ID_GRP_PARENT -alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_GRP -alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_USR -alter table JBPM_JOB drop constraint FK_JOB_PRINST -alter table JBPM_JOB drop constraint FK_JOB_ACTION -alter table JBPM_JOB drop constraint FK_JOB_TOKEN -alter table JBPM_JOB drop constraint FK_JOB_NODE -alter table JBPM_JOB drop constraint FK_JOB_TSKINST -alter table JBPM_LOG drop constraint FK_LOG_SOURCENODE -alter table JBPM_LOG drop constraint FK_LOG_DESTNODE -alter table JBPM_LOG drop constraint FK_LOG_TOKEN -alter table JBPM_LOG drop constraint FK_LOG_TRANSITION -alter table JBPM_LOG drop constraint FK_LOG_TASKINST -alter table JBPM_LOG drop constraint FK_LOG_CHILDTOKEN -alter table JBPM_LOG drop constraint FK_LOG_OLDBYTES -alter table JBPM_LOG drop constraint FK_LOG_SWIMINST -alter table JBPM_LOG drop constraint FK_LOG_NEWBYTES -alter table JBPM_LOG drop constraint FK_LOG_ACTION -alter table JBPM_LOG drop constraint FK_LOG_VARINST -alter table JBPM_LOG drop constraint FK_LOG_NODE -alter table JBPM_LOG drop constraint FK_LOG_PARENT -alter table JBPM_MODULEDEFINITION drop constraint FK_MODDEF_PROCDEF -alter table JBPM_MODULEDEFINITION drop constraint FK_TSKDEF_START -alter table JBPM_MODULEINSTANCE drop constraint FK_MODINST_PRCINST -alter table JBPM_MODULEINSTANCE drop constraint FK_TASKMGTINST_TMD -alter table JBPM_NODE drop constraint FK_DECISION_DELEG -alter table JBPM_NODE drop constraint FK_NODE_PROCDEF -alter table JBPM_NODE drop constraint FK_NODE_ACTION -alter table JBPM_NODE drop constraint FK_PROCST_SBPRCDEF -alter table JBPM_NODE drop constraint FK_NODE_SCRIPT -alter table JBPM_NODE drop constraint FK_NODE_SUPERSTATE -alter table JBPM_POOLEDACTOR drop constraint FK_POOLEDACTOR_SLI -alter table JBPM_PROCESSDEFINITION drop constraint FK_PROCDEF_STRTSTA -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_PROCDEF -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_ROOTTKN -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_SPROCTKN -alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_PROCINST -alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_ACTION -alter table JBPM_SWIMLANE drop constraint FK_SWL_ASSDEL -alter table JBPM_SWIMLANE drop constraint FK_SWL_TSKMGMTDEF -alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_TM -alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_SL -alter table JBPM_TASK drop constraint FK_TASK_STARTST -alter table JBPM_TASK drop constraint FK_TASK_PROCDEF -alter table JBPM_TASK drop constraint FK_TASK_ASSDEL -alter table JBPM_TASK drop constraint FK_TASK_SWIMLANE -alter table JBPM_TASK drop constraint FK_TASK_TASKNODE -alter table JBPM_TASK drop constraint FK_TASK_TASKMGTDEF -alter table JBPM_TASK drop constraint FK_TSK_TSKCTRL -alter table JBPM_TASKACTORPOOL drop constraint FK_TASKACTPL_TSKI -alter table JBPM_TASKACTORPOOL drop constraint FK_TSKACTPOL_PLACT -alter table JBPM_TASKCONTROLLER drop constraint FK_TSKCTRL_DELEG -alter table JBPM_TASKINSTANCE drop constraint FK_TSKINS_PRCINS -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TMINST -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TOKEN -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_SLINST -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TASK -alter table JBPM_TOKEN drop constraint FK_TOKEN_SUBPI -alter table JBPM_TOKEN drop constraint FK_TOKEN_PROCINST -alter table JBPM_TOKEN drop constraint FK_TOKEN_NODE -alter table JBPM_TOKEN drop constraint FK_TOKEN_PARENT -alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_TOKEN -alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_CTXT -alter table JBPM_TRANSITION drop constraint FK_TRANSITION_FROM -alter table JBPM_TRANSITION drop constraint FK_TRANS_PROCDEF -alter table JBPM_TRANSITION drop constraint FK_TRANSITION_TO -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_PROCST -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_SCRIPT -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_TSKCTRL -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_PRCINST -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TKVARMP -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TK -alter table JBPM_VARIABLEINSTANCE drop constraint FK_BYTEINST_ARRAY -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VAR_TSKINST -drop table JBPM_ACTION if exists -drop table JBPM_BYTEARRAY if exists -drop table JBPM_BYTEBLOCK if exists -drop table JBPM_COMMENT if exists -drop table JBPM_DECISIONCONDITIONS if exists -drop table JBPM_DELEGATION if exists -drop table JBPM_EVENT if exists -drop table JBPM_EXCEPTIONHANDLER if exists -drop table JBPM_ID_GROUP if exists -drop table JBPM_ID_MEMBERSHIP if exists -drop table JBPM_ID_PERMISSIONS if exists -drop table JBPM_ID_USER if exists -drop table JBPM_JOB if exists -drop table JBPM_LOG if exists -drop table JBPM_MODULEDEFINITION if exists -drop table JBPM_MODULEINSTANCE if exists -drop table JBPM_NODE if exists -drop table JBPM_POOLEDACTOR if exists -drop table JBPM_PROCESSDEFINITION if exists -drop table JBPM_PROCESSINSTANCE if exists -drop table JBPM_RUNTIMEACTION if exists -drop table JBPM_SWIMLANE if exists -drop table JBPM_SWIMLANEINSTANCE if exists -drop table JBPM_TASK if exists -drop table JBPM_TASKACTORPOOL if exists -drop table JBPM_TASKCONTROLLER if exists -drop table JBPM_TASKINSTANCE if exists -drop table JBPM_TOKEN if exists -drop table JBPM_TOKENVARIABLEMAP if exists -drop table JBPM_TRANSITION if exists -drop table JBPM_VARIABLEACCESS if exists -drop table JBPM_VARIABLEINSTANCE if exists create table JBPM_ACTION (ID_ bigint generated by default as identity (start with 1), class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ bit, ACTIONEXPRESSION_ varchar(255), ISASYNC_ 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_)) create table JBPM_BYTEARRAY (ID_ bigint generated by default as identity (start with 1), NAME_ varchar(255), FILEDEFINITION_ bigint, primary key (ID_)) create table JBPM_BYTEBLOCK (PROCESSFILE_ bigint not null, BYTES_ varbinary(1024), INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_)) Modified: jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.informix.sql =================================================================== --- jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.informix.sql 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.informix.sql 2009-02-21 13:48:56 UTC (rev 3992) @@ -1,125 +1,3 @@ -alter table JBPM_ACTION drop constraint FK_ACTION_REFACT -alter table JBPM_ACTION drop constraint FK_CRTETIMERACT_TA -alter table JBPM_ACTION drop constraint FK_ACTION_PROCDEF -alter table JBPM_ACTION drop constraint FK_ACTION_EVENT -alter table JBPM_ACTION drop constraint FK_ACTION_ACTNDEL -alter table JBPM_ACTION drop constraint FK_ACTION_EXPTHDL -alter table JBPM_BYTEARRAY drop constraint FK_BYTEARR_FILDEF -alter table JBPM_BYTEBLOCK drop constraint FK_BYTEBLOCK_FILE -alter table JBPM_COMMENT drop constraint FK_COMMENT_TOKEN -alter table JBPM_COMMENT drop constraint FK_COMMENT_TSK -alter table JBPM_DECISIONCONDITIONS drop constraint FK_DECCOND_DEC -alter table JBPM_DELEGATION drop constraint FK_DELEGATION_PRCD -alter table JBPM_EVENT drop constraint FK_EVENT_PROCDEF -alter table JBPM_EVENT drop constraint FK_EVENT_TRANS -alter table JBPM_EVENT drop constraint FK_EVENT_NODE -alter table JBPM_EVENT drop constraint FK_EVENT_TASK -alter table JBPM_ID_GROUP drop constraint FK_ID_GRP_PARENT -alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_GRP -alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_USR -alter table JBPM_JOB drop constraint FK_JOB_PRINST -alter table JBPM_JOB drop constraint FK_JOB_ACTION -alter table JBPM_JOB drop constraint FK_JOB_TOKEN -alter table JBPM_JOB drop constraint FK_JOB_NODE -alter table JBPM_JOB drop constraint FK_JOB_TSKINST -alter table JBPM_LOG drop constraint FK_LOG_SOURCENODE -alter table JBPM_LOG drop constraint FK_LOG_DESTNODE -alter table JBPM_LOG drop constraint FK_LOG_TOKEN -alter table JBPM_LOG drop constraint FK_LOG_TRANSITION -alter table JBPM_LOG drop constraint FK_LOG_TASKINST -alter table JBPM_LOG drop constraint FK_LOG_CHILDTOKEN -alter table JBPM_LOG drop constraint FK_LOG_OLDBYTES -alter table JBPM_LOG drop constraint FK_LOG_SWIMINST -alter table JBPM_LOG drop constraint FK_LOG_NEWBYTES -alter table JBPM_LOG drop constraint FK_LOG_ACTION -alter table JBPM_LOG drop constraint FK_LOG_VARINST -alter table JBPM_LOG drop constraint FK_LOG_NODE -alter table JBPM_LOG drop constraint FK_LOG_PARENT -alter table JBPM_MODULEDEFINITION drop constraint FK_MODDEF_PROCDEF -alter table JBPM_MODULEDEFINITION drop constraint FK_TSKDEF_START -alter table JBPM_MODULEINSTANCE drop constraint FK_MODINST_PRCINST -alter table JBPM_MODULEINSTANCE drop constraint FK_TASKMGTINST_TMD -alter table JBPM_NODE drop constraint FK_DECISION_DELEG -alter table JBPM_NODE drop constraint FK_NODE_PROCDEF -alter table JBPM_NODE drop constraint FK_NODE_ACTION -alter table JBPM_NODE drop constraint FK_PROCST_SBPRCDEF -alter table JBPM_NODE drop constraint FK_NODE_SCRIPT -alter table JBPM_NODE drop constraint FK_NODE_SUPERSTATE -alter table JBPM_POOLEDACTOR drop constraint FK_POOLEDACTOR_SLI -alter table JBPM_PROCESSDEFINITION drop constraint FK_PROCDEF_STRTSTA -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_PROCDEF -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_ROOTTKN -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_SPROCTKN -alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_PROCINST -alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_ACTION -alter table JBPM_SWIMLANE drop constraint FK_SWL_ASSDEL -alter table JBPM_SWIMLANE drop constraint FK_SWL_TSKMGMTDEF -alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_TM -alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_SL -alter table JBPM_TASK drop constraint FK_TASK_STARTST -alter table JBPM_TASK drop constraint FK_TASK_PROCDEF -alter table JBPM_TASK drop constraint FK_TASK_ASSDEL -alter table JBPM_TASK drop constraint FK_TASK_SWIMLANE -alter table JBPM_TASK drop constraint FK_TASK_TASKNODE -alter table JBPM_TASK drop constraint FK_TASK_TASKMGTDEF -alter table JBPM_TASK drop constraint FK_TSK_TSKCTRL -alter table JBPM_TASKACTORPOOL drop constraint FK_TASKACTPL_TSKI -alter table JBPM_TASKACTORPOOL drop constraint FK_TSKACTPOL_PLACT -alter table JBPM_TASKCONTROLLER drop constraint FK_TSKCTRL_DELEG -alter table JBPM_TASKINSTANCE drop constraint FK_TSKINS_PRCINS -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TMINST -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TOKEN -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_SLINST -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TASK -alter table JBPM_TOKEN drop constraint FK_TOKEN_SUBPI -alter table JBPM_TOKEN drop constraint FK_TOKEN_PROCINST -alter table JBPM_TOKEN drop constraint FK_TOKEN_NODE -alter table JBPM_TOKEN drop constraint FK_TOKEN_PARENT -alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_TOKEN -alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_CTXT -alter table JBPM_TRANSITION drop constraint FK_TRANSITION_FROM -alter table JBPM_TRANSITION drop constraint FK_TRANS_PROCDEF -alter table JBPM_TRANSITION drop constraint FK_TRANSITION_TO -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_PROCST -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_SCRIPT -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_TSKCTRL -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_PRCINST -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TKVARMP -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TK -alter table JBPM_VARIABLEINSTANCE drop constraint FK_BYTEINST_ARRAY -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VAR_TSKINST -drop table JBPM_ACTION -drop table JBPM_BYTEARRAY -drop table JBPM_BYTEBLOCK -drop table JBPM_COMMENT -drop table JBPM_DECISIONCONDITIONS -drop table JBPM_DELEGATION -drop table JBPM_EVENT -drop table JBPM_EXCEPTIONHANDLER -drop table JBPM_ID_GROUP -drop table JBPM_ID_MEMBERSHIP -drop table JBPM_ID_PERMISSIONS -drop table JBPM_ID_USER -drop table JBPM_JOB -drop table JBPM_LOG -drop table JBPM_MODULEDEFINITION -drop table JBPM_MODULEINSTANCE -drop table JBPM_NODE -drop table JBPM_POOLEDACTOR -drop table JBPM_PROCESSDEFINITION -drop table JBPM_PROCESSINSTANCE -drop table JBPM_RUNTIMEACTION -drop table JBPM_SWIMLANE -drop table JBPM_SWIMLANEINSTANCE -drop table JBPM_TASK -drop table JBPM_TASKACTORPOOL -drop table JBPM_TASKCONTROLLER -drop table JBPM_TASKINSTANCE -drop table JBPM_TOKEN -drop table JBPM_TOKENVARIABLEMAP -drop table JBPM_TRANSITION -drop table JBPM_VARIABLEACCESS -drop table JBPM_VARIABLEINSTANCE create table JBPM_ACTION (ID_ serial8 not null, class char(255) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ smallint, ACTIONEXPRESSION_ varchar(255), ISASYNC_ smallint, REFERENCEDACTION_ int8, ACTIONDELEGATION_ int8, EVENT_ int8, PROCESSDEFINITION_ int8, EXPRESSION_ lvarchar(4000), TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ int8, EVENTINDEX_ integer, EXCEPTIONHANDLER_ int8, EXCEPTIONHANDLERINDEX_ integer, primary key (ID_)) create table JBPM_BYTEARRAY (ID_ serial8 not null, NAME_ varchar(255), FILEDEFINITION_ int8, primary key (ID_)) create table JBPM_BYTEBLOCK (PROCESSFILE_ int8 not null, BYTES_ byte, INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_)) Modified: jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.ingres.sql =================================================================== --- jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.ingres.sql 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.ingres.sql 2009-02-21 13:48:56 UTC (rev 3992) @@ -1,36 +1,3 @@ -drop table JBPM_ACTION -drop table JBPM_BYTEARRAY -drop table JBPM_BYTEBLOCK -drop table JBPM_COMMENT -drop table JBPM_DECISIONCONDITIONS -drop table JBPM_DELEGATION -drop table JBPM_EVENT -drop table JBPM_EXCEPTIONHANDLER -drop table JBPM_ID_GROUP -drop table JBPM_ID_MEMBERSHIP -drop table JBPM_ID_PERMISSIONS -drop table JBPM_ID_USER -drop table JBPM_JOB -drop table JBPM_LOG -drop table JBPM_MODULEDEFINITION -drop table JBPM_MODULEINSTANCE -drop table JBPM_NODE -drop table JBPM_POOLEDACTOR -drop table JBPM_PROCESSDEFINITION -drop table JBPM_PROCESSINSTANCE -drop table JBPM_RUNTIMEACTION -drop table JBPM_SWIMLANE -drop table JBPM_SWIMLANEINSTANCE -drop table JBPM_TASK -drop table JBPM_TASKACTORPOOL -drop table JBPM_TASKCONTROLLER -drop table JBPM_TASKINSTANCE -drop table JBPM_TOKEN -drop table JBPM_TOKENVARIABLEMAP -drop table JBPM_TRANSITION -drop table JBPM_VARIABLEACCESS -drop table JBPM_VARIABLEINSTANCE -drop sequence hibernate_sequence restrict create table JBPM_ACTION (ID_ bigint not null, class char(1) not null, NAME_ varchar(255) with null, ISPROPAGATIONALLOWED_ tinyint with null, ACTIONEXPRESSION_ varchar(255) with null, ISASYNC_ tinyint with null, REFERENCEDACTION_ bigint with null, ACTIONDELEGATION_ bigint with null, EVENT_ bigint with null, PROCESSDEFINITION_ bigint with null, EXPRESSION_ varchar(4000) with null, TIMERNAME_ varchar(255) with null, DUEDATE_ varchar(255) with null, REPEAT_ varchar(255) with null, TRANSITIONNAME_ varchar(255) with null, TIMERACTION_ bigint with null, EVENTINDEX_ integer with null, EXCEPTIONHANDLER_ bigint with null, EXCEPTIONHANDLERINDEX_ integer with null, primary key (ID_)) create table JBPM_BYTEARRAY (ID_ bigint not null, NAME_ varchar(255) with null, FILEDEFINITION_ bigint with null, primary key (ID_)) create table JBPM_BYTEBLOCK (PROCESSFILE_ bigint not null, BYTES_ varbyte(1024) with null, INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_)) Modified: jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.interbase.sql =================================================================== --- jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.interbase.sql 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.interbase.sql 2009-02-21 13:48:56 UTC (rev 3992) @@ -1,126 +1,3 @@ -alter table JBPM_ACTION drop constraint FK_ACTION_REFACT -alter table JBPM_ACTION drop constraint FK_CRTETIMERACT_TA -alter table JBPM_ACTION drop constraint FK_ACTION_PROCDEF -alter table JBPM_ACTION drop constraint FK_ACTION_EVENT -alter table JBPM_ACTION drop constraint FK_ACTION_ACTNDEL -alter table JBPM_ACTION drop constraint FK_ACTION_EXPTHDL -alter table JBPM_BYTEARRAY drop constraint FK_BYTEARR_FILDEF -alter table JBPM_BYTEBLOCK drop constraint FK_BYTEBLOCK_FILE -alter table JBPM_COMMENT drop constraint FK_COMMENT_TOKEN -alter table JBPM_COMMENT drop constraint FK_COMMENT_TSK -alter table JBPM_DECISIONCONDITIONS drop constraint FK_DECCOND_DEC -alter table JBPM_DELEGATION drop constraint FK_DELEGATION_PRCD -alter table JBPM_EVENT drop constraint FK_EVENT_PROCDEF -alter table JBPM_EVENT drop constraint FK_EVENT_TRANS -alter table JBPM_EVENT drop constraint FK_EVENT_NODE -alter table JBPM_EVENT drop constraint FK_EVENT_TASK -alter table JBPM_ID_GROUP drop constraint FK_ID_GRP_PARENT -alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_GRP -alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_USR -alter table JBPM_JOB drop constraint FK_JOB_PRINST -alter table JBPM_JOB drop constraint FK_JOB_ACTION -alter table JBPM_JOB drop constraint FK_JOB_TOKEN -alter table JBPM_JOB drop constraint FK_JOB_NODE -alter table JBPM_JOB drop constraint FK_JOB_TSKINST -alter table JBPM_LOG drop constraint FK_LOG_SOURCENODE -alter table JBPM_LOG drop constraint FK_LOG_DESTNODE -alter table JBPM_LOG drop constraint FK_LOG_TOKEN -alter table JBPM_LOG drop constraint FK_LOG_TRANSITION -alter table JBPM_LOG drop constraint FK_LOG_TASKINST -alter table JBPM_LOG drop constraint FK_LOG_CHILDTOKEN -alter table JBPM_LOG drop constraint FK_LOG_OLDBYTES -alter table JBPM_LOG drop constraint FK_LOG_SWIMINST -alter table JBPM_LOG drop constraint FK_LOG_NEWBYTES -alter table JBPM_LOG drop constraint FK_LOG_ACTION -alter table JBPM_LOG drop constraint FK_LOG_VARINST -alter table JBPM_LOG drop constraint FK_LOG_NODE -alter table JBPM_LOG drop constraint FK_LOG_PARENT -alter table JBPM_MODULEDEFINITION drop constraint FK_MODDEF_PROCDEF -alter table JBPM_MODULEDEFINITION drop constraint FK_TSKDEF_START -alter table JBPM_MODULEINSTANCE drop constraint FK_MODINST_PRCINST -alter table JBPM_MODULEINSTANCE drop constraint FK_TASKMGTINST_TMD -alter table JBPM_NODE drop constraint FK_DECISION_DELEG -alter table JBPM_NODE drop constraint FK_NODE_PROCDEF -alter table JBPM_NODE drop constraint FK_NODE_ACTION -alter table JBPM_NODE drop constraint FK_PROCST_SBPRCDEF -alter table JBPM_NODE drop constraint FK_NODE_SCRIPT -alter table JBPM_NODE drop constraint FK_NODE_SUPERSTATE -alter table JBPM_POOLEDACTOR drop constraint FK_POOLEDACTOR_SLI -alter table JBPM_PROCESSDEFINITION drop constraint FK_PROCDEF_STRTSTA -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_PROCDEF -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_ROOTTKN -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_SPROCTKN -alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_PROCINST -alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_ACTION -alter table JBPM_SWIMLANE drop constraint FK_SWL_ASSDEL -alter table JBPM_SWIMLANE drop constraint FK_SWL_TSKMGMTDEF -alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_TM -alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_SL -alter table JBPM_TASK drop constraint FK_TASK_STARTST -alter table JBPM_TASK drop constraint FK_TASK_PROCDEF -alter table JBPM_TASK drop constraint FK_TASK_ASSDEL -alter table JBPM_TASK drop constraint FK_TASK_SWIMLANE -alter table JBPM_TASK drop constraint FK_TASK_TASKNODE -alter table JBPM_TASK drop constraint FK_TASK_TASKMGTDEF -alter table JBPM_TASK drop constraint FK_TSK_TSKCTRL -alter table JBPM_TASKACTORPOOL drop constraint FK_TASKACTPL_TSKI -alter table JBPM_TASKACTORPOOL drop constraint FK_TSKACTPOL_PLACT -alter table JBPM_TASKCONTROLLER drop constraint FK_TSKCTRL_DELEG -alter table JBPM_TASKINSTANCE drop constraint FK_TSKINS_PRCINS -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TMINST -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TOKEN -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_SLINST -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TASK -alter table JBPM_TOKEN drop constraint FK_TOKEN_SUBPI -alter table JBPM_TOKEN drop constraint FK_TOKEN_PROCINST -alter table JBPM_TOKEN drop constraint FK_TOKEN_NODE -alter table JBPM_TOKEN drop constraint FK_TOKEN_PARENT -alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_TOKEN -alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_CTXT -alter table JBPM_TRANSITION drop constraint FK_TRANSITION_FROM -alter table JBPM_TRANSITION drop constraint FK_TRANS_PROCDEF -alter table JBPM_TRANSITION drop constraint FK_TRANSITION_TO -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_PROCST -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_SCRIPT -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_TSKCTRL -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_PRCINST -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TKVARMP -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TK -alter table JBPM_VARIABLEINSTANCE drop constraint FK_BYTEINST_ARRAY -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VAR_TSKINST -drop table JBPM_ACTION -drop table JBPM_BYTEARRAY -drop table JBPM_BYTEBLOCK -drop table JBPM_COMMENT -drop table JBPM_DECISIONCONDITIONS -drop table JBPM_DELEGATION -drop table JBPM_EVENT -drop table JBPM_EXCEPTIONHANDLER -drop table JBPM_ID_GROUP -drop table JBPM_ID_MEMBERSHIP -drop table JBPM_ID_PERMISSIONS -drop table JBPM_ID_USER -drop table JBPM_JOB -drop table JBPM_LOG -drop table JBPM_MODULEDEFINITION -drop table JBPM_MODULEINSTANCE -drop table JBPM_NODE -drop table JBPM_POOLEDACTOR -drop table JBPM_PROCESSDEFINITION -drop table JBPM_PROCESSINSTANCE -drop table JBPM_RUNTIMEACTION -drop table JBPM_SWIMLANE -drop table JBPM_SWIMLANEINSTANCE -drop table JBPM_TASK -drop table JBPM_TASKACTORPOOL -drop table JBPM_TASKCONTROLLER -drop table JBPM_TASKINSTANCE -drop table JBPM_TOKEN -drop table JBPM_TOKENVARIABLEMAP -drop table JBPM_TRANSITION -drop table JBPM_VARIABLEACCESS -drop table JBPM_VARIABLEINSTANCE -delete from RDB$GENERATORS where RDB$GENERATOR_NAME = 'HIBERNATE_SEQUENCE' create table JBPM_ACTION (ID_ numeric(18,0) not null, class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ smallint, ACTIONEXPRESSION_ varchar(255), ISASYNC_ smallint, REFERENCEDACTION_ numeric(18,0), ACTIONDELEGATION_ numeric(18,0), EVENT_ numeric(18,0), PROCESSDEFINITION_ numeric(18,0), EXPRESSION_ varchar(4000), TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ numeric(18,0), EVENTINDEX_ integer, EXCEPTIONHANDLER_ numeric(18,0), EXCEPTIONHANDLERINDEX_ integer, primary key (ID_)) create table JBPM_BYTEARRAY (ID_ numeric(18,0) not null, NAME_ varchar(255), FILEDEFINITION_ numeric(18,0), primary key (ID_)) create table JBPM_BYTEBLOCK (PROCESSFILE_ numeric(18,0) not null, BYTES_ blob, INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_)) Modified: jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.mckoi.sql =================================================================== --- jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.mckoi.sql 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.mckoi.sql 2009-02-21 13:48:56 UTC (rev 3992) @@ -1,126 +1,3 @@ -alter table JBPM_ACTION drop constraint FK_ACTION_REFACT -alter table JBPM_ACTION drop constraint FK_CRTETIMERACT_TA -alter table JBPM_ACTION drop constraint FK_ACTION_PROCDEF -alter table JBPM_ACTION drop constraint FK_ACTION_EVENT -alter table JBPM_ACTION drop constraint FK_ACTION_ACTNDEL -alter table JBPM_ACTION drop constraint FK_ACTION_EXPTHDL -alter table JBPM_BYTEARRAY drop constraint FK_BYTEARR_FILDEF -alter table JBPM_BYTEBLOCK drop constraint FK_BYTEBLOCK_FILE -alter table JBPM_COMMENT drop constraint FK_COMMENT_TOKEN -alter table JBPM_COMMENT drop constraint FK_COMMENT_TSK -alter table JBPM_DECISIONCONDITIONS drop constraint FK_DECCOND_DEC -alter table JBPM_DELEGATION drop constraint FK_DELEGATION_PRCD -alter table JBPM_EVENT drop constraint FK_EVENT_PROCDEF -alter table JBPM_EVENT drop constraint FK_EVENT_TRANS -alter table JBPM_EVENT drop constraint FK_EVENT_NODE -alter table JBPM_EVENT drop constraint FK_EVENT_TASK -alter table JBPM_ID_GROUP drop constraint FK_ID_GRP_PARENT -alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_GRP -alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_USR -alter table JBPM_JOB drop constraint FK_JOB_PRINST -alter table JBPM_JOB drop constraint FK_JOB_ACTION -alter table JBPM_JOB drop constraint FK_JOB_TOKEN -alter table JBPM_JOB drop constraint FK_JOB_NODE -alter table JBPM_JOB drop constraint FK_JOB_TSKINST -alter table JBPM_LOG drop constraint FK_LOG_SOURCENODE -alter table JBPM_LOG drop constraint FK_LOG_DESTNODE -alter table JBPM_LOG drop constraint FK_LOG_TOKEN -alter table JBPM_LOG drop constraint FK_LOG_TRANSITION -alter table JBPM_LOG drop constraint FK_LOG_TASKINST -alter table JBPM_LOG drop constraint FK_LOG_CHILDTOKEN -alter table JBPM_LOG drop constraint FK_LOG_OLDBYTES -alter table JBPM_LOG drop constraint FK_LOG_SWIMINST -alter table JBPM_LOG drop constraint FK_LOG_NEWBYTES -alter table JBPM_LOG drop constraint FK_LOG_ACTION -alter table JBPM_LOG drop constraint FK_LOG_VARINST -alter table JBPM_LOG drop constraint FK_LOG_NODE -alter table JBPM_LOG drop constraint FK_LOG_PARENT -alter table JBPM_MODULEDEFINITION drop constraint FK_MODDEF_PROCDEF -alter table JBPM_MODULEDEFINITION drop constraint FK_TSKDEF_START -alter table JBPM_MODULEINSTANCE drop constraint FK_MODINST_PRCINST -alter table JBPM_MODULEINSTANCE drop constraint FK_TASKMGTINST_TMD -alter table JBPM_NODE drop constraint FK_DECISION_DELEG -alter table JBPM_NODE drop constraint FK_NODE_PROCDEF -alter table JBPM_NODE drop constraint FK_NODE_ACTION -alter table JBPM_NODE drop constraint FK_PROCST_SBPRCDEF -alter table JBPM_NODE drop constraint FK_NODE_SCRIPT -alter table JBPM_NODE drop constraint FK_NODE_SUPERSTATE -alter table JBPM_POOLEDACTOR drop constraint FK_POOLEDACTOR_SLI -alter table JBPM_PROCESSDEFINITION drop constraint FK_PROCDEF_STRTSTA -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_PROCDEF -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_ROOTTKN -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_SPROCTKN -alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_PROCINST -alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_ACTION -alter table JBPM_SWIMLANE drop constraint FK_SWL_ASSDEL -alter table JBPM_SWIMLANE drop constraint FK_SWL_TSKMGMTDEF -alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_TM -alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_SL -alter table JBPM_TASK drop constraint FK_TASK_STARTST -alter table JBPM_TASK drop constraint FK_TASK_PROCDEF -alter table JBPM_TASK drop constraint FK_TASK_ASSDEL -alter table JBPM_TASK drop constraint FK_TASK_SWIMLANE -alter table JBPM_TASK drop constraint FK_TASK_TASKNODE -alter table JBPM_TASK drop constraint FK_TASK_TASKMGTDEF -alter table JBPM_TASK drop constraint FK_TSK_TSKCTRL -alter table JBPM_TASKACTORPOOL drop constraint FK_TASKACTPL_TSKI -alter table JBPM_TASKACTORPOOL drop constraint FK_TSKACTPOL_PLACT -alter table JBPM_TASKCONTROLLER drop constraint FK_TSKCTRL_DELEG -alter table JBPM_TASKINSTANCE drop constraint FK_TSKINS_PRCINS -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TMINST -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TOKEN -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_SLINST -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TASK -alter table JBPM_TOKEN drop constraint FK_TOKEN_SUBPI -alter table JBPM_TOKEN drop constraint FK_TOKEN_PROCINST -alter table JBPM_TOKEN drop constraint FK_TOKEN_NODE -alter table JBPM_TOKEN drop constraint FK_TOKEN_PARENT -alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_TOKEN -alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_CTXT -alter table JBPM_TRANSITION drop constraint FK_TRANSITION_FROM -alter table JBPM_TRANSITION drop constraint FK_TRANS_PROCDEF -alter table JBPM_TRANSITION drop constraint FK_TRANSITION_TO -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_PROCST -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_SCRIPT -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_TSKCTRL -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_PRCINST -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TKVARMP -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TK -alter table JBPM_VARIABLEINSTANCE drop constraint FK_BYTEINST_ARRAY -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VAR_TSKINST -drop table JBPM_ACTION -drop table JBPM_BYTEARRAY -drop table JBPM_BYTEBLOCK -drop table JBPM_COMMENT -drop table JBPM_DECISIONCONDITIONS -drop table JBPM_DELEGATION -drop table JBPM_EVENT -drop table JBPM_EXCEPTIONHANDLER -drop table JBPM_ID_GROUP -drop table JBPM_ID_MEMBERSHIP -drop table JBPM_ID_PERMISSIONS -drop table JBPM_ID_USER -drop table JBPM_JOB -drop table JBPM_LOG -drop table JBPM_MODULEDEFINITION -drop table JBPM_MODULEINSTANCE -drop table JBPM_NODE -drop table JBPM_POOLEDACTOR -drop table JBPM_PROCESSDEFINITION -drop table JBPM_PROCESSINSTANCE -drop table JBPM_RUNTIMEACTION -drop table JBPM_SWIMLANE -drop table JBPM_SWIMLANEINSTANCE -drop table JBPM_TASK -drop table JBPM_TASKACTORPOOL -drop table JBPM_TASKCONTROLLER -drop table JBPM_TASKINSTANCE -drop table JBPM_TOKEN -drop table JBPM_TOKENVARIABLEMAP -drop table JBPM_TRANSITION -drop table JBPM_VARIABLEACCESS -drop table JBPM_VARIABLEINSTANCE -drop sequence hibernate_sequence create table JBPM_ACTION (ID_ bigint not null, class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ bit, ACTIONEXPRESSION_ varchar(255), ISASYNC_ 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_)) create table JBPM_BYTEARRAY (ID_ bigint not null, NAME_ varchar(255), FILEDEFINITION_ bigint, primary key (ID_)) create table JBPM_BYTEBLOCK (PROCESSFILE_ bigint not null, BYTES_ varbinary, INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_)) Modified: jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.mssql.sql =================================================================== --- jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.mssql.sql 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.mssql.sql 2009-02-21 13:48:56 UTC (rev 3992) @@ -1,125 +1,3 @@ -alter table JBPM_ACTION drop constraint FK_ACTION_REFACT -alter table JBPM_ACTION drop constraint FK_CRTETIMERACT_TA -alter table JBPM_ACTION drop constraint FK_ACTION_PROCDEF -alter table JBPM_ACTION drop constraint FK_ACTION_EVENT -alter table JBPM_ACTION drop constraint FK_ACTION_ACTNDEL -alter table JBPM_ACTION drop constraint FK_ACTION_EXPTHDL -alter table JBPM_BYTEARRAY drop constraint FK_BYTEARR_FILDEF -alter table JBPM_BYTEBLOCK drop constraint FK_BYTEBLOCK_FILE -alter table JBPM_COMMENT drop constraint FK_COMMENT_TOKEN -alter table JBPM_COMMENT drop constraint FK_COMMENT_TSK -alter table JBPM_DECISIONCONDITIONS drop constraint FK_DECCOND_DEC -alter table JBPM_DELEGATION drop constraint FK_DELEGATION_PRCD -alter table JBPM_EVENT drop constraint FK_EVENT_PROCDEF -alter table JBPM_EVENT drop constraint FK_EVENT_TRANS -alter table JBPM_EVENT drop constraint FK_EVENT_NODE -alter table JBPM_EVENT drop constraint FK_EVENT_TASK -alter table JBPM_ID_GROUP drop constraint FK_ID_GRP_PARENT -alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_GRP -alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_USR -alter table JBPM_JOB drop constraint FK_JOB_PRINST -alter table JBPM_JOB drop constraint FK_JOB_ACTION -alter table JBPM_JOB drop constraint FK_JOB_TOKEN -alter table JBPM_JOB drop constraint FK_JOB_NODE -alter table JBPM_JOB drop constraint FK_JOB_TSKINST -alter table JBPM_LOG drop constraint FK_LOG_SOURCENODE -alter table JBPM_LOG drop constraint FK_LOG_DESTNODE -alter table JBPM_LOG drop constraint FK_LOG_TOKEN -alter table JBPM_LOG drop constraint FK_LOG_TRANSITION -alter table JBPM_LOG drop constraint FK_LOG_TASKINST -alter table JBPM_LOG drop constraint FK_LOG_CHILDTOKEN -alter table JBPM_LOG drop constraint FK_LOG_OLDBYTES -alter table JBPM_LOG drop constraint FK_LOG_SWIMINST -alter table JBPM_LOG drop constraint FK_LOG_NEWBYTES -alter table JBPM_LOG drop constraint FK_LOG_ACTION -alter table JBPM_LOG drop constraint FK_LOG_VARINST -alter table JBPM_LOG drop constraint FK_LOG_NODE -alter table JBPM_LOG drop constraint FK_LOG_PARENT -alter table JBPM_MODULEDEFINITION drop constraint FK_MODDEF_PROCDEF -alter table JBPM_MODULEDEFINITION drop constraint FK_TSKDEF_START -alter table JBPM_MODULEINSTANCE drop constraint FK_MODINST_PRCINST -alter table JBPM_MODULEINSTANCE drop constraint FK_TASKMGTINST_TMD -alter table JBPM_NODE drop constraint FK_DECISION_DELEG -alter table JBPM_NODE drop constraint FK_NODE_PROCDEF -alter table JBPM_NODE drop constraint FK_NODE_ACTION -alter table JBPM_NODE drop constraint FK_PROCST_SBPRCDEF -alter table JBPM_NODE drop constraint FK_NODE_SCRIPT -alter table JBPM_NODE drop constraint FK_NODE_SUPERSTATE -alter table JBPM_POOLEDACTOR drop constraint FK_POOLEDACTOR_SLI -alter table JBPM_PROCESSDEFINITION drop constraint FK_PROCDEF_STRTSTA -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_PROCDEF -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_ROOTTKN -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_SPROCTKN -alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_PROCINST -alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_ACTION -alter table JBPM_SWIMLANE drop constraint FK_SWL_ASSDEL -alter table JBPM_SWIMLANE drop constraint FK_SWL_TSKMGMTDEF -alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_TM -alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_SL -alter table JBPM_TASK drop constraint FK_TASK_STARTST -alter table JBPM_TASK drop constraint FK_TASK_PROCDEF -alter table JBPM_TASK drop constraint FK_TASK_ASSDEL -alter table JBPM_TASK drop constraint FK_TASK_SWIMLANE -alter table JBPM_TASK drop constraint FK_TASK_TASKNODE -alter table JBPM_TASK drop constraint FK_TASK_TASKMGTDEF -alter table JBPM_TASK drop constraint FK_TSK_TSKCTRL -alter table JBPM_TASKACTORPOOL drop constraint FK_TASKACTPL_TSKI -alter table JBPM_TASKACTORPOOL drop constraint FK_TSKACTPOL_PLACT -alter table JBPM_TASKCONTROLLER drop constraint FK_TSKCTRL_DELEG -alter table JBPM_TASKINSTANCE drop constraint FK_TSKINS_PRCINS -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TMINST -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TOKEN -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_SLINST -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TASK -alter table JBPM_TOKEN drop constraint FK_TOKEN_SUBPI -alter table JBPM_TOKEN drop constraint FK_TOKEN_PROCINST -alter table JBPM_TOKEN drop constraint FK_TOKEN_NODE -alter table JBPM_TOKEN drop constraint FK_TOKEN_PARENT -alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_TOKEN -alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_CTXT -alter table JBPM_TRANSITION drop constraint FK_TRANSITION_FROM -alter table JBPM_TRANSITION drop constraint FK_TRANS_PROCDEF -alter table JBPM_TRANSITION drop constraint FK_TRANSITION_TO -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_PROCST -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_SCRIPT -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_TSKCTRL -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_PRCINST -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TKVARMP -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TK -alter table JBPM_VARIABLEINSTANCE drop constraint FK_BYTEINST_ARRAY -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VAR_TSKINST -drop table JBPM_ACTION -drop table JBPM_BYTEARRAY -drop table JBPM_BYTEBLOCK -drop table JBPM_COMMENT -drop table JBPM_DECISIONCONDITIONS -drop table JBPM_DELEGATION -drop table JBPM_EVENT -drop table JBPM_EXCEPTIONHANDLER -drop table JBPM_ID_GROUP -drop table JBPM_ID_MEMBERSHIP -drop table JBPM_ID_PERMISSIONS -drop table JBPM_ID_USER -drop table JBPM_JOB -drop table JBPM_LOG -drop table JBPM_MODULEDEFINITION -drop table JBPM_MODULEINSTANCE -drop table JBPM_NODE -drop table JBPM_POOLEDACTOR -drop table JBPM_PROCESSDEFINITION -drop table JBPM_PROCESSINSTANCE -drop table JBPM_RUNTIMEACTION -drop table JBPM_SWIMLANE -drop table JBPM_SWIMLANEINSTANCE -drop table JBPM_TASK -drop table JBPM_TASKACTORPOOL -drop table JBPM_TASKCONTROLLER -drop table JBPM_TASKINSTANCE -drop table JBPM_TOKEN -drop table JBPM_TOKENVARIABLEMAP -drop table JBPM_TRANSITION -drop table JBPM_VARIABLEACCESS -drop table JBPM_VARIABLEINSTANCE create table JBPM_ACTION (ID_ numeric(19,0) identity not null, class char(1) not null, NAME_ varchar(255) null, ISPROPAGATIONALLOWED_ tinyint null, ACTIONEXPRESSION_ varchar(255) null, ISASYNC_ tinyint null, REFERENCEDACTION_ numeric(19,0) null, ACTIONDELEGATION_ numeric(19,0) null, EVENT_ numeric(19,0) null, PROCESSDEFINITION_ numeric(19,0) null, EXPRESSION_ varchar(4000) null, TIMERNAME_ varchar(255) null, DUEDATE_ varchar(255) null, REPEAT_ varchar(255) null, TRANSITIONNAME_ varchar(255) null, TIMERACTION_ numeric(19,0) null, EVENTINDEX_ int null, EXCEPTIONHANDLER_ numeric(19,0) null, EXCEPTIONHANDLERINDEX_ int null, primary key (ID_)) create table JBPM_BYTEARRAY (ID_ numeric(19,0) identity not null, NAME_ varchar(255) null, FILEDEFINITION_ numeric(19,0) null, primary key (ID_)) create table JBPM_BYTEBLOCK (PROCESSFILE_ numeric(19,0) not null, BYTES_ varbinary(1024) null, INDEX_ int not null, primary key (PROCESSFILE_, INDEX_)) Modified: jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.oracle.sql =================================================================== --- jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.oracle.sql 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.oracle.sql 2009-02-21 13:48:56 UTC (rev 3992) @@ -1,36 +1,3 @@ -drop table JBPM_ACTION cascade constraints; -drop table JBPM_BYTEARRAY cascade constraints; -drop table JBPM_BYTEBLOCK cascade constraints; -drop table JBPM_COMMENT cascade constraints; -drop table JBPM_DECISIONCONDITIONS cascade constraints; -drop table JBPM_DELEGATION cascade constraints; -drop table JBPM_EVENT cascade constraints; -drop table JBPM_EXCEPTIONHANDLER cascade constraints; -drop table JBPM_ID_GROUP cascade constraints; -drop table JBPM_ID_MEMBERSHIP cascade constraints; -drop table JBPM_ID_PERMISSIONS cascade constraints; -drop table JBPM_ID_USER cascade constraints; -drop table JBPM_JOB cascade constraints; -drop table JBPM_LOG cascade constraints; -drop table JBPM_MODULEDEFINITION cascade constraints; -drop table JBPM_MODULEINSTANCE cascade constraints; -drop table JBPM_NODE cascade constraints; -drop table JBPM_POOLEDACTOR cascade constraints; -drop table JBPM_PROCESSDEFINITION cascade constraints; -drop table JBPM_PROCESSINSTANCE cascade constraints; -drop table JBPM_RUNTIMEACTION cascade constraints; -drop table JBPM_SWIMLANE cascade constraints; -drop table JBPM_SWIMLANEINSTANCE cascade constraints; -drop table JBPM_TASK cascade constraints; -drop table JBPM_TASKACTORPOOL cascade constraints; -drop table JBPM_TASKCONTROLLER cascade constraints; -drop table JBPM_TASKINSTANCE cascade constraints; -drop table JBPM_TOKEN cascade constraints; -drop table JBPM_TOKENVARIABLEMAP cascade constraints; -drop table JBPM_TRANSITION cascade constraints; -drop table JBPM_VARIABLEACCESS cascade constraints; -drop table JBPM_VARIABLEINSTANCE cascade constraints; -drop sequence hibernate_sequence; create table JBPM_ACTION (ID_ number(19,0) not null, class char(1 char) not null, NAME_ varchar2(255 char), ISPROPAGATIONALLOWED_ number(1,0), ACTIONEXPRESSION_ varchar2(255 char), ISASYNC_ 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_)); create table JBPM_BYTEARRAY (ID_ number(19,0) not null, NAME_ varchar2(255 char), FILEDEFINITION_ number(19,0), primary key (ID_)); create table JBPM_BYTEBLOCK (PROCESSFILE_ number(19,0) not null, BYTES_ raw(1024), INDEX_ number(10,0) not null, primary key (PROCESSFILE_, INDEX_)); Modified: jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.pointbase.sql =================================================================== --- jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.pointbase.sql 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.pointbase.sql 2009-02-21 13:48:56 UTC (rev 3992) @@ -1,36 +1,3 @@ -drop table JBPM_ACTION cascade -drop table JBPM_BYTEARRAY cascade -drop table JBPM_BYTEBLOCK cascade -drop table JBPM_COMMENT cascade -drop table JBPM_DECISIONCONDITIONS cascade -drop table JBPM_DELEGATION cascade -drop table JBPM_EVENT cascade -drop table JBPM_EXCEPTIONHANDLER cascade -drop table JBPM_ID_GROUP cascade -drop table JBPM_ID_MEMBERSHIP cascade -drop table JBPM_ID_PERMISSIONS cascade -drop table JBPM_ID_USER cascade -drop table JBPM_JOB cascade -drop table JBPM_LOG cascade -drop table JBPM_MODULEDEFINITION cascade -drop table JBPM_MODULEINSTANCE cascade -drop table JBPM_NODE cascade -drop table JBPM_POOLEDACTOR cascade -drop table JBPM_PROCESSDEFINITION cascade -drop table JBPM_PROCESSINSTANCE cascade -drop table JBPM_RUNTIMEACTION cascade -drop table JBPM_SWIMLANE cascade -drop table JBPM_SWIMLANEINSTANCE cascade -drop table JBPM_TASK cascade -drop table JBPM_TASKACTORPOOL cascade -drop table JBPM_TASKCONTROLLER cascade -drop table JBPM_TASKINSTANCE cascade -drop table JBPM_TOKEN cascade -drop table JBPM_TOKENVARIABLEMAP cascade -drop table JBPM_TRANSITION cascade -drop table JBPM_VARIABLEACCESS cascade -drop table JBPM_VARIABLEINSTANCE cascade -drop table hibernate_unique_key cascade create table JBPM_ACTION (ID_ bigint not null, class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ smallint, ACTIONEXPRESSION_ varchar(255), ISASYNC_ smallint, 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_)) create table JBPM_BYTEARRAY (ID_ bigint not null, NAME_ varchar(255), FILEDEFINITION_ bigint, primary key (ID_)) create table JBPM_BYTEBLOCK (PROCESSFILE_ bigint not null, BYTES_ blob(1024), INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_)) Modified: jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.postgresql.sql =================================================================== --- jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.postgresql.sql 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.postgresql.sql 2009-02-21 13:48:56 UTC (rev 3992) @@ -1,158 +1,35 @@ -alter table JBPM_ACTION drop constraint FK_ACTION_REFACT -alter table JBPM_ACTION drop constraint FK_CRTETIMERACT_TA -alter table JBPM_ACTION drop constraint FK_ACTION_PROCDEF -alter table JBPM_ACTION drop constraint FK_ACTION_EVENT -alter table JBPM_ACTION drop constraint FK_ACTION_ACTNDEL -alter table JBPM_ACTION drop constraint FK_ACTION_EXPTHDL -alter table JBPM_BYTEARRAY drop constraint FK_BYTEARR_FILDEF -alter table JBPM_BYTEBLOCK drop constraint FK_BYTEBLOCK_FILE -alter table JBPM_COMMENT drop constraint FK_COMMENT_TOKEN -alter table JBPM_COMMENT drop constraint FK_COMMENT_TSK -alter table JBPM_DECISIONCONDITIONS drop constraint FK_DECCOND_DEC -alter table JBPM_DELEGATION drop constraint FK_DELEGATION_PRCD -alter table JBPM_EVENT drop constraint FK_EVENT_PROCDEF -alter table JBPM_EVENT drop constraint FK_EVENT_TRANS -alter table JBPM_EVENT drop constraint FK_EVENT_NODE -alter table JBPM_EVENT drop constraint FK_EVENT_TASK -alter table JBPM_ID_GROUP drop constraint FK_ID_GRP_PARENT -alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_GRP -alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_USR -alter table JBPM_JOB drop constraint FK_JOB_PRINST -alter table JBPM_JOB drop constraint FK_JOB_ACTION -alter table JBPM_JOB drop constraint FK_JOB_TOKEN -alter table JBPM_JOB drop constraint FK_JOB_NODE -alter table JBPM_JOB drop constraint FK_JOB_TSKINST -alter table JBPM_LOG drop constraint FK_LOG_SOURCENODE -alter table JBPM_LOG drop constraint FK_LOG_DESTNODE -alter table JBPM_LOG drop constraint FK_LOG_TOKEN -alter table JBPM_LOG drop constraint FK_LOG_TRANSITION -alter table JBPM_LOG drop constraint FK_LOG_TASKINST -alter table JBPM_LOG drop constraint FK_LOG_CHILDTOKEN -alter table JBPM_LOG drop constraint FK_LOG_OLDBYTES -alter table JBPM_LOG drop constraint FK_LOG_SWIMINST -alter table JBPM_LOG drop constraint FK_LOG_NEWBYTES -alter table JBPM_LOG drop constraint FK_LOG_ACTION -alter table JBPM_LOG drop constraint FK_LOG_VARINST -alter table JBPM_LOG drop constraint FK_LOG_NODE -alter table JBPM_LOG drop constraint FK_LOG_PARENT -alter table JBPM_MODULEDEFINITION drop constraint FK_MODDEF_PROCDEF -alter table JBPM_MODULEDEFINITION drop constraint FK_TSKDEF_START -alter table JBPM_MODULEINSTANCE drop constraint FK_MODINST_PRCINST -alter table JBPM_MODULEINSTANCE drop constraint FK_TASKMGTINST_TMD -alter table JBPM_NODE drop constraint FK_DECISION_DELEG -alter table JBPM_NODE drop constraint FK_NODE_PROCDEF -alter table JBPM_NODE drop constraint FK_NODE_ACTION -alter table JBPM_NODE drop constraint FK_PROCST_SBPRCDEF -alter table JBPM_NODE drop constraint FK_NODE_SCRIPT -alter table JBPM_NODE drop constraint FK_NODE_SUPERSTATE -alter table JBPM_POOLEDACTOR drop constraint FK_POOLEDACTOR_SLI -alter table JBPM_PROCESSDEFINITION drop constraint FK_PROCDEF_STRTSTA -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_PROCDEF -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_ROOTTKN -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_SPROCTKN -alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_PROCINST -alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_ACTION -alter table JBPM_SWIMLANE drop constraint FK_SWL_ASSDEL -alter table JBPM_SWIMLANE drop constraint FK_SWL_TSKMGMTDEF -alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_TM -alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_SL -alter table JBPM_TASK drop constraint FK_TASK_STARTST -alter table JBPM_TASK drop constraint FK_TASK_PROCDEF -alter table JBPM_TASK drop constraint FK_TASK_ASSDEL -alter table JBPM_TASK drop constraint FK_TASK_SWIMLANE -alter table JBPM_TASK drop constraint FK_TASK_TASKNODE -alter table JBPM_TASK drop constraint FK_TASK_TASKMGTDEF -alter table JBPM_TASK drop constraint FK_TSK_TSKCTRL -alter table JBPM_TASKACTORPOOL drop constraint FK_TASKACTPL_TSKI -alter table JBPM_TASKACTORPOOL drop constraint FK_TSKACTPOL_PLACT -alter table JBPM_TASKCONTROLLER drop constraint FK_TSKCTRL_DELEG -alter table JBPM_TASKINSTANCE drop constraint FK_TSKINS_PRCINS -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TMINST -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TOKEN -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_SLINST -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TASK -alter table JBPM_TOKEN drop constraint FK_TOKEN_SUBPI -alter table JBPM_TOKEN drop constraint FK_TOKEN_PROCINST -alter table JBPM_TOKEN drop constraint FK_TOKEN_NODE -alter table JBPM_TOKEN drop constraint FK_TOKEN_PARENT -alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_TOKEN -alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_CTXT -alter table JBPM_TRANSITION drop constraint FK_TRANSITION_FROM -alter table JBPM_TRANSITION drop constraint FK_TRANS_PROCDEF -alter table JBPM_TRANSITION drop constraint FK_TRANSITION_TO -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_PROCST -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_SCRIPT -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_TSKCTRL -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_PRCINST -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TKVARMP -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TK -alter table JBPM_VARIABLEINSTANCE drop constraint FK_BYTEINST_ARRAY -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VAR_TSKINST -drop table JBPM_ACTION -drop table JBPM_BYTEARRAY -drop table JBPM_BYTEBLOCK -drop table JBPM_COMMENT -drop table JBPM_DECISIONCONDITIONS -drop table JBPM_DELEGATION -drop table JBPM_EVENT -drop table JBPM_EXCEPTIONHANDLER -drop table JBPM_ID_GROUP -drop table JBPM_ID_MEMBERSHIP -drop table JBPM_ID_PERMISSIONS -drop table JBPM_ID_USER -drop table JBPM_JOB -drop table JBPM_LOG -drop table JBPM_MODULEDEFINITION -drop table JBPM_MODULEINSTANCE -drop table JBPM_NODE -drop table JBPM_POOLEDACTOR -drop table JBPM_PROCESSDEFINITION -drop table JBPM_PROCESSINSTANCE -drop table JBPM_RUNTIMEACTION -drop table JBPM_SWIMLANE -drop table JBPM_SWIMLANEINSTANCE -drop table JBPM_TASK -drop table JBPM_TASKACTORPOOL -drop table JBPM_TASKCONTROLLER -drop table JBPM_TASKINSTANCE -drop table JBPM_TOKEN -drop table JBPM_TOKENVARIABLEMAP -drop table JBPM_TRANSITION -drop table JBPM_VARIABLEACCESS -drop table JBPM_VARIABLEINSTANCE -drop sequence hibernate_sequence -create table JBPM_ACTION (ID_ int8 not null, class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ bool, ACTIONEXPRESSION_ varchar(255), ISASYNC_ bool, REFERENCEDACTION_ int8, ACTIONDELEGATION_ int8, EVENT_ int8, PROCESSDEFINITION_ int8, EXPRESSION_ varchar(4000), TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ int8, EVENTINDEX_ int4, EXCEPTIONHANDLER_ int8, EXCEPTIONHANDLERINDEX_ int4, primary key (ID_)) -create table JBPM_BYTEARRAY (ID_ int8 not null, NAME_ varchar(255), FILEDEFINITION_ int8, primary key (ID_)) -create table JBPM_BYTEBLOCK (PROCESSFILE_ int8 not null, BYTES_ bytea, INDEX_ int4 not null, primary key (PROCESSFILE_, INDEX_)) -create table JBPM_COMMENT (ID_ int8 not null, VERSION_ int4 not null, ACTORID_ varchar(255), TIME_ timestamp, MESSAGE_ varchar(4000), TOKEN_ int8, TASKINSTANCE_ int8, TOKENINDEX_ int4, TASKINSTANCEINDEX_ int4, primary key (ID_)) -create table JBPM_DECISIONCONDITIONS (DECISION_ int8 not null, TRANSITIONNAME_ varchar(255), EXPRESSION_ varchar(255), INDEX_ int4 not null, primary key (DECISION_, INDEX_)) -create table JBPM_DELEGATION (ID_ int8 not null, CLASSNAME_ varchar(4000), CONFIGURATION_ varchar(4000), CONFIGTYPE_ varchar(255), PROCESSDEFINITION_ int8, primary key (ID_)) -create table JBPM_EVENT (ID_ int8 not null, EVENTTYPE_ varchar(255), TYPE_ char(1), GRAPHELEMENT_ int8, PROCESSDEFINITION_ int8, NODE_ int8, TRANSITION_ int8, TASK_ int8, primary key (ID_)) -create table JBPM_EXCEPTIONHANDLER (ID_ int8 not null, EXCEPTIONCLASSNAME_ varchar(4000), TYPE_ char(1), GRAPHELEMENT_ int8, PROCESSDEFINITION_ int8, GRAPHELEMENTINDEX_ int4, NODE_ int8, TRANSITION_ int8, TASK_ int8, primary key (ID_)) -create table JBPM_ID_GROUP (ID_ int8 not null, CLASS_ char(1) not null, NAME_ varchar(255), TYPE_ varchar(255), PARENT_ int8, primary key (ID_)) -create table JBPM_ID_MEMBERSHIP (ID_ int8 not null, CLASS_ char(1) not null, NAME_ varchar(255), ROLE_ varchar(255), USER_ int8, GROUP_ int8, primary key (ID_)) -create table JBPM_ID_PERMISSIONS (ENTITY_ int8 not null, CLASS_ varchar(255), NAME_ varchar(255), ACTION_ varchar(255)) -create table JBPM_ID_USER (ID_ int8 not null, CLASS_ char(1) not null, NAME_ varchar(255), EMAIL_ varchar(255), PASSWORD_ varchar(255), primary key (ID_)) -create table JBPM_JOB (ID_ int8 not null, CLASS_ char(1) not null, VERSION_ int4 not null, DUEDATE_ timestamp, PROCESSINSTANCE_ int8, TOKEN_ int8, TASKINSTANCE_ int8, ISSUSPENDED_ bool, ISEXCLUSIVE_ bool, LOCKOWNER_ varchar(255), LOCKTIME_ timestamp, EXCEPTION_ varchar(4000), RETRIES_ int4, NAME_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), ACTION_ int8, GRAPHELEMENTTYPE_ varchar(255), GRAPHELEMENT_ int8, NODE_ int8, primary key (ID_)) -create table JBPM_LOG (ID_ int8 not null, CLASS_ char(1) not null, INDEX_ int4, DATE_ timestamp, TOKEN_ int8, PARENT_ int8, MESSAGE_ varchar(4000), EXCEPTION_ varchar(4000), ACTION_ int8, NODE_ int8, ENTER_ timestamp, LEAVE_ timestamp, DURATION_ int8, NEWLONGVALUE_ int8, TRANSITION_ int8, CHILD_ int8, SOURCENODE_ int8, DESTINATIONNODE_ int8, VARIABLEINSTANCE_ int8, OLDBYTEARRAY_ int8, NEWBYTEARRAY_ int8, OLDDATEVALUE_ timestamp, NEWDATEVALUE_ timestamp, OLDDOUBLEVALUE_ float8, NEWDOUBLEVALUE_ float8, OLDLONGIDCLASS_ varchar(255), OLDLONGIDVALUE_ int8, NEWLONGIDCLASS_ varchar(255), NEWLONGIDVALUE_ int8, OLDSTRINGIDCLASS_ varchar(255), OLDSTRINGIDVALUE_ varchar(255), NEWSTRINGIDCLASS_ varchar(255), NEWSTRINGIDVALUE_ varchar(255), OLDLONGVALUE_ int8, OLDSTRINGVALUE_ varchar(4000), NEWSTRINGVALUE_ varchar(4000), TASKINSTANCE_ int8, TASKACTORID_ varchar(255), TASKOLDACTORID_ varchar(255), SWIMLANEINSTANCE_ int8, primary key (ID_)) -create table JBPM_MODULEDEFINITION (ID_ int8 not null, CLASS_ char(1) not null, NAME_ varchar(4000), PROCESSDEFINITION_ int8, STARTTASK_ int8, primary key (ID_)) -create table JBPM_MODULEINSTANCE (ID_ int8 not null, CLASS_ char(1) not null, VERSION_ int4 not null, PROCESSINSTANCE_ int8, TASKMGMTDEFINITION_ int8, NAME_ varchar(255), primary key (ID_)) -create table JBPM_NODE (ID_ int8 not null, CLASS_ char(1) not null, NAME_ varchar(255), DESCRIPTION_ varchar(4000), PROCESSDEFINITION_ int8, ISASYNC_ bool, ISASYNCEXCL_ bool, ACTION_ int8, SUPERSTATE_ int8, SUBPROCNAME_ varchar(255), SUBPROCESSDEFINITION_ int8, DECISIONEXPRESSION_ varchar(255), DECISIONDELEGATION int8, SCRIPT_ int8, SIGNAL_ int4, CREATETASKS_ bool, ENDTASKS_ bool, NODECOLLECTIONINDEX_ int4, primary key (ID_)) -create table JBPM_POOLEDACTOR (ID_ int8 not null, VERSION_ int4 not null, ACTORID_ varchar(255), SWIMLANEINSTANCE_ int8, primary key (ID_)) -create table JBPM_PROCESSDEFINITION (ID_ int8 not null, CLASS_ char(1) not null, NAME_ varchar(255), DESCRIPTION_ varchar(4000), VERSION_ int4, ISTERMINATIONIMPLICIT_ bool, STARTSTATE_ int8, primary key (ID_)) -create table JBPM_PROCESSINSTANCE (ID_ int8 not null, VERSION_ int4 not null, KEY_ varchar(255), START_ timestamp, END_ timestamp, ISSUSPENDED_ bool, PROCESSDEFINITION_ int8, ROOTTOKEN_ int8, SUPERPROCESSTOKEN_ int8, primary key (ID_)) -create table JBPM_RUNTIMEACTION (ID_ int8 not null, VERSION_ int4 not null, EVENTTYPE_ varchar(255), TYPE_ char(1), GRAPHELEMENT_ int8, PROCESSINSTANCE_ int8, ACTION_ int8, PROCESSINSTANCEINDEX_ int4, primary key (ID_)) -create table JBPM_SWIMLANE (ID_ int8 not null, NAME_ varchar(255), ACTORIDEXPRESSION_ varchar(255), POOLEDACTORSEXPRESSION_ varchar(255), ASSIGNMENTDELEGATION_ int8, TASKMGMTDEFINITION_ int8, primary key (ID_)) -create table JBPM_SWIMLANEINSTANCE (ID_ int8 not null, VERSION_ int4 not null, NAME_ varchar(255), ACTORID_ varchar(255), SWIMLANE_ int8, TASKMGMTINSTANCE_ int8, primary key (ID_)) -create table JBPM_TASK (ID_ int8 not null, NAME_ varchar(255), DESCRIPTION_ varchar(4000), PROCESSDEFINITION_ int8, ISBLOCKING_ bool, ISSIGNALLING_ bool, CONDITION_ varchar(255), DUEDATE_ varchar(255), PRIORITY_ int4, ACTORIDEXPRESSION_ varchar(255), POOLEDACTORSEXPRESSION_ varchar(255), TASKMGMTDEFINITION_ int8, TASKNODE_ int8, STARTSTATE_ int8, ASSIGNMENTDELEGATION_ int8, SWIMLANE_ int8, TASKCONTROLLER_ int8, primary key (ID_)) -create table JBPM_TASKACTORPOOL (TASKINSTANCE_ int8 not null, POOLEDACTOR_ int8 not null, primary key (TASKINSTANCE_, POOLEDACTOR_)) -create table JBPM_TASKCONTROLLER (ID_ int8 not null, TASKCONTROLLERDELEGATION_ int8, primary key (ID_)) -create table JBPM_TASKINSTANCE (ID_ int8 not null, CLASS_ char(1) not null, VERSION_ int4 not null, NAME_ varchar(255), DESCRIPTION_ varchar(4000), ACTORID_ varchar(255), CREATE_ timestamp, START_ timestamp, END_ timestamp, DUEDATE_ timestamp, PRIORITY_ int4, ISCANCELLED_ bool, ISSUSPENDED_ bool, ISOPEN_ bool, ISSIGNALLING_ bool, ISBLOCKING_ bool, TASK_ int8, TOKEN_ int8, PROCINST_ int8, SWIMLANINSTANCE_ int8, TASKMGMTINSTANCE_ int8, primary key (ID_)) -create table JBPM_TOKEN (ID_ int8 not null, VERSION_ int4 not null, NAME_ varchar(255), START_ timestamp, END_ timestamp, NODEENTER_ timestamp, NEXTLOGINDEX_ int4, ISABLETOREACTIVATEPARENT_ bool, ISTERMINATIONIMPLICIT_ bool, ISSUSPENDED_ bool, LOCK_ varchar(255), NODE_ int8, PROCESSINSTANCE_ int8, PARENT_ int8, SUBPROCESSINSTANCE_ int8, primary key (ID_)) -create table JBPM_TOKENVARIABLEMAP (ID_ int8 not null, VERSION_ int4 not null, TOKEN_ int8, CONTEXTINSTANCE_ int8, primary key (ID_)) -create table JBPM_TRANSITION (ID_ int8 not null, NAME_ varchar(255), DESCRIPTION_ varchar(4000), PROCESSDEFINITION_ int8, FROM_ int8, TO_ int8, CONDITION_ varchar(255), FROMINDEX_ int4, primary key (ID_)) -create table JBPM_VARIABLEACCESS (ID_ int8 not null, VARIABLENAME_ varchar(255), ACCESS_ varchar(255), MAPPEDNAME_ varchar(255), SCRIPT_ int8, PROCESSSTATE_ int8, TASKCONTROLLER_ int8, INDEX_ int4, primary key (ID_)) -create table JBPM_VARIABLEINSTANCE (ID_ int8 not null, CLASS_ char(1) not null, VERSION_ int4 not null, NAME_ varchar(255), CONVERTER_ char(1), TOKEN_ int8, TOKENVARIABLEMAP_ int8, PROCESSINSTANCE_ int8, BYTEARRAYVALUE_ int8, DATEVALUE_ timestamp, DOUBLEVALUE_ float8, LONGIDCLASS_ varchar(255), LONGVALUE_ int8, STRINGIDCLASS_ varchar(255), STRINGVALUE_ varchar(4000), TASKINSTANCE_ int8, primary key (ID_)) +create table JBPM_ACTION (ID_ int8 not null, class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ bool, ACTIONEXPRESSION_ varchar(255), ISASYNC_ bool, REFERENCEDACTION_ int8, ACTIONDELEGATION_ int8, EVENT_ int8, PROCESSDEFINITION_ int8, EXPRESSION_ varchar(4000), TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ int8, EVENTINDEX_ int4, EXCEPTIONHANDLER_ int8, EXCEPTIONHANDLERINDEX_ int4, primary key (ID_)); +create table JBPM_BYTEARRAY (ID_ int8 not null, NAME_ varchar(255), FILEDEFINITION_ int8, primary key (ID_)); +create table JBPM_BYTEBLOCK (PROCESSFILE_ int8 not null, BYTES_ bytea, INDEX_ int4 not null, primary key (PROCESSFILE_, INDEX_)); +create table JBPM_COMMENT (ID_ int8 not null, VERSION_ int4 not null, ACTORID_ varchar(255), TIME_ timestamp, MESSAGE_ varchar(4000), TOKEN_ int8, TASKINSTANCE_ int8, TOKENINDEX_ int4, TASKINSTANCEINDEX_ int4, primary key (ID_)); +create table JBPM_DECISIONCONDITIONS (DECISION_ int8 not null, TRANSITIONNAME_ varchar(255), EXPRESSION_ varchar(255), INDEX_ int4 not null, primary key (DECISION_, INDEX_)); +create table JBPM_DELEGATION (ID_ int8 not null, CLASSNAME_ varchar(4000), CONFIGURATION_ varchar(4000), CONFIGTYPE_ varchar(255), PROCESSDEFINITION_ int8, primary key (ID_)); +create table JBPM_EVENT (ID_ int8 not null, EVENTTYPE_ varchar(255), TYPE_ char(1), GRAPHELEMENT_ int8, PROCESSDEFINITION_ int8, NODE_ int8, TRANSITION_ int8, TASK_ int8, primary key (ID_)); +create table JBPM_EXCEPTIONHANDLER (ID_ int8 not null, EXCEPTIONCLASSNAME_ varchar(4000), TYPE_ char(1), GRAPHELEMENT_ int8, PROCESSDEFINITION_ int8, GRAPHELEMENTINDEX_ int4, NODE_ int8, TRANSITION_ int8, TASK_ int8, primary key (ID_)); +create table JBPM_ID_GROUP (ID_ int8 not null, CLASS_ char(1) not null, NAME_ varchar(255), TYPE_ varchar(255), PARENT_ int8, primary key (ID_)); +create table JBPM_ID_MEMBERSHIP (ID_ int8 not null, CLASS_ char(1) not null, NAME_ varchar(255), ROLE_ varchar(255), USER_ int8, GROUP_ int8, primary key (ID_)); +create table JBPM_ID_PERMISSIONS (ENTITY_ int8 not null, CLASS_ varchar(255), NAME_ varchar(255), ACTION_ varchar(255)); +create table JBPM_ID_USER (ID_ int8 not null, CLASS_ char(1) not null, NAME_ varchar(255), EMAIL_ varchar(255), PASSWORD_ varchar(255), primary key (ID_)); +create table JBPM_JOB (ID_ int8 not null, CLASS_ char(1) not null, VERSION_ int4 not null, DUEDATE_ timestamp, PROCESSINSTANCE_ int8, TOKEN_ int8, TASKINSTANCE_ int8, ISSUSPENDED_ bool, ISEXCLUSIVE_ bool, LOCKOWNER_ varchar(255), LOCKTIME_ timestamp, EXCEPTION_ varchar(4000), RETRIES_ int4, NAME_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), ACTION_ int8, GRAPHELEMENTTYPE_ varchar(255), GRAPHELEMENT_ int8, NODE_ int8, primary key (ID_)); +create table JBPM_LOG (ID_ int8 not null, CLASS_ char(1) not null, INDEX_ int4, DATE_ timestamp, TOKEN_ int8, PARENT_ int8, MESSAGE_ varchar(4000), EXCEPTION_ varchar(4000), ACTION_ int8, NODE_ int8, ENTER_ timestamp, LEAVE_ timestamp, DURATION_ int8, NEWLONGVALUE_ int8, TRANSITION_ int8, CHILD_ int8, SOURCENODE_ int8, DESTINATIONNODE_ int8, VARIABLEINSTANCE_ int8, OLDBYTEARRAY_ int8, NEWBYTEARRAY_ int8, OLDDATEVALUE_ timestamp, NEWDATEVALUE_ timestamp, OLDDOUBLEVALUE_ float8, NEWDOUBLEVALUE_ float8, OLDLONGIDCLASS_ varchar(255), OLDLONGIDVALUE_ int8, NEWLONGIDCLASS_ varchar(255), NEWLONGIDVALUE_ int8, OLDSTRINGIDCLASS_ varchar(255), OLDSTRINGIDVALUE_ varchar(255), NEWSTRINGIDCLASS_ varchar(255), NEWSTRINGIDVALUE_ varchar(255), OLDLONGVALUE_ int8, OLDSTRINGVALUE_ varchar(4000), NEWSTRINGVALUE_ varchar(4000), TASKINSTANCE_ int8, TASKACTORID_ varchar(255), TASKOLDACTORID_ varchar(255), SWIMLANEINSTANCE_ int8, primary key (ID_)); +create table JBPM_MODULEDEFINITION (ID_ int8 not null, CLASS_ char(1) not null, NAME_ varchar(4000), PROCESSDEFINITION_ int8, STARTTASK_ int8, primary key (ID_)); +create table JBPM_MODULEINSTANCE (ID_ int8 not null, CLASS_ char(1) not null, VERSION_ int4 not null, PROCESSINSTANCE_ int8, TASKMGMTDEFINITION_ int8, NAME_ varchar(255), primary key (ID_)); +create table JBPM_NODE (ID_ int8 not null, CLASS_ char(1) not null, NAME_ varchar(255), DESCRIPTION_ varchar(4000), PROCESSDEFINITION_ int8, ISASYNC_ bool, ISASYNCEXCL_ bool, ACTION_ int8, SUPERSTATE_ int8, SUBPROCNAME_ varchar(255), SUBPROCESSDEFINITION_ int8, DECISIONEXPRESSION_ varchar(255), DECISIONDELEGATION int8, SCRIPT_ int8, SIGNAL_ int4, CREATETASKS_ bool, ENDTASKS_ bool, NODECOLLECTIONINDEX_ int4, primary key (ID_)); +create table JBPM_POOLEDACTOR (ID_ int8 not null, VERSION_ int4 not null, ACTORID_ varchar(255), SWIMLANEINSTANCE_ int8, primary key (ID_)); +create table JBPM_PROCESSDEFINITION (ID_ int8 not null, CLASS_ char(1) not null, NAME_ varchar(255), DESCRIPTION_ varchar(4000), VERSION_ int4, ISTERMINATIONIMPLICIT_ bool, STARTSTATE_ int8, primary key (ID_)); +create table JBPM_PROCESSINSTANCE (ID_ int8 not null, VERSION_ int4 not null, KEY_ varchar(255), START_ timestamp, END_ timestamp, ISSUSPENDED_ bool, PROCESSDEFINITION_ int8, ROOTTOKEN_ int8, SUPERPROCESSTOKEN_ int8, primary key (ID_)); +create table JBPM_RUNTIMEACTION (ID_ int8 not null, VERSION_ int4 not null, EVENTTYPE_ varchar(255), TYPE_ char(1), GRAPHELEMENT_ int8, PROCESSINSTANCE_ int8, ACTION_ int8, PROCESSINSTANCEINDEX_ int4, primary key (ID_)); +create table JBPM_SWIMLANE (ID_ int8 not null, NAME_ varchar(255), ACTORIDEXPRESSION_ varchar(255), POOLEDACTORSEXPRESSION_ varchar(255), ASSIGNMENTDELEGATION_ int8, TASKMGMTDEFINITION_ int8, primary key (ID_)); +create table JBPM_SWIMLANEINSTANCE (ID_ int8 not null, VERSION_ int4 not null, NAME_ varchar(255), ACTORID_ varchar(255), SWIMLANE_ int8, TASKMGMTINSTANCE_ int8, primary key (ID_)); +create table JBPM_TASK (ID_ int8 not null, NAME_ varchar(255), DESCRIPTION_ varchar(4000), PROCESSDEFINITION_ int8, ISBLOCKING_ bool, ISSIGNALLING_ bool, CONDITION_ varchar(255), DUEDATE_ varchar(255), PRIORITY_ int4, ACTORIDEXPRESSION_ varchar(255), POOLEDACTORSEXPRESSION_ varchar(255), TASKMGMTDEFINITION_ int8, TASKNODE_ int8, STARTSTATE_ int8, ASSIGNMENTDELEGATION_ int8, SWIMLANE_ int8, TASKCONTROLLER_ int8, primary key (ID_)); +create table JBPM_TASKACTORPOOL (TASKINSTANCE_ int8 not null, POOLEDACTOR_ int8 not null, primary key (TASKINSTANCE_, POOLEDACTOR_)); +create table JBPM_TASKCONTROLLER (ID_ int8 not null, TASKCONTROLLERDELEGATION_ int8, primary key (ID_)); +create table JBPM_TASKINSTANCE (ID_ int8 not null, CLASS_ char(1) not null, VERSION_ int4 not null, NAME_ varchar(255), DESCRIPTION_ varchar(4000), ACTORID_ varchar(255), CREATE_ timestamp, START_ timestamp, END_ timestamp, DUEDATE_ timestamp, PRIORITY_ int4, ISCANCELLED_ bool, ISSUSPENDED_ bool, ISOPEN_ bool, ISSIGNALLING_ bool, ISBLOCKING_ bool, TASK_ int8, TOKEN_ int8, PROCINST_ int8, SWIMLANINSTANCE_ int8, TASKMGMTINSTANCE_ int8, primary key (ID_)); +create table JBPM_TOKEN (ID_ int8 not null, VERSION_ int4 not null, NAME_ varchar(255), START_ timestamp, END_ timestamp, NODEENTER_ timestamp, NEXTLOGINDEX_ int4, ISABLETOREACTIVATEPARENT_ bool, ISTERMINATIONIMPLICIT_ bool, ISSUSPENDED_ bool, LOCK_ varchar(255), NODE_ int8, PROCESSINSTANCE_ int8, PARENT_ int8, SUBPROCESSINSTANCE_ int8, primary key (ID_)); +create table JBPM_TOKENVARIABLEMAP (ID_ int8 not null, VERSION_ int4 not null, TOKEN_ int8, CONTEXTINSTANCE_ int8, primary key (ID_)); +create table JBPM_TRANSITION (ID_ int8 not null, NAME_ varchar(255), DESCRIPTION_ varchar(4000), PROCESSDEFINITION_ int8, FROM_ int8, TO_ int8, CONDITION_ varchar(255), FROMINDEX_ int4, primary key (ID_)); +create table JBPM_VARIABLEACCESS (ID_ int8 not null, VARIABLENAME_ varchar(255), ACCESS_ varchar(255), MAPPEDNAME_ varchar(255), SCRIPT_ int8, PROCESSSTATE_ int8, TASKCONTROLLER_ int8, INDEX_ int4, primary key (ID_)); +create table JBPM_VARIABLEINSTANCE (ID_ int8 not null, CLASS_ char(1) not null, VERSION_ int4 not null, NAME_ varchar(255), CONVERTER_ char(1), TOKEN_ int8, TOKENVARIABLEMAP_ int8, PROCESSINSTANCE_ int8, BYTEARRAYVALUE_ int8, DATEVALUE_ timestamp, DOUBLEVALUE_ float8, LONGIDCLASS_ varchar(255), LONGVALUE_ int8, STRINGIDCLASS_ varchar(255), STRINGVALUE_ varchar(4000), TASKINSTANCE_ int8, primary key (ID_)); create index IDX_ACTION_ACTNDL on JBPM_ACTION (ACTIONDELEGATION_) create index IDX_ACTION_PROCDF on JBPM_ACTION (PROCESSDEFINITION_) create index IDX_ACTION_EVENT on JBPM_ACTION (EVENT_) Modified: jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.progress.sql =================================================================== --- jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.progress.sql 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.progress.sql 2009-02-21 13:48:56 UTC (rev 3992) @@ -1,126 +1,3 @@ -alter table JBPM_ACTION drop constraint FK_ACTION_REFACT -alter table JBPM_ACTION drop constraint FK_CRTETIMERACT_TA -alter table JBPM_ACTION drop constraint FK_ACTION_PROCDEF -alter table JBPM_ACTION drop constraint FK_ACTION_EVENT -alter table JBPM_ACTION drop constraint FK_ACTION_ACTNDEL -alter table JBPM_ACTION drop constraint FK_ACTION_EXPTHDL -alter table JBPM_BYTEARRAY drop constraint FK_BYTEARR_FILDEF -alter table JBPM_BYTEBLOCK drop constraint FK_BYTEBLOCK_FILE -alter table JBPM_COMMENT drop constraint FK_COMMENT_TOKEN -alter table JBPM_COMMENT drop constraint FK_COMMENT_TSK -alter table JBPM_DECISIONCONDITIONS drop constraint FK_DECCOND_DEC -alter table JBPM_DELEGATION drop constraint FK_DELEGATION_PRCD -alter table JBPM_EVENT drop constraint FK_EVENT_PROCDEF -alter table JBPM_EVENT drop constraint FK_EVENT_TRANS -alter table JBPM_EVENT drop constraint FK_EVENT_NODE -alter table JBPM_EVENT drop constraint FK_EVENT_TASK -alter table JBPM_ID_GROUP drop constraint FK_ID_GRP_PARENT -alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_GRP -alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_USR -alter table JBPM_JOB drop constraint FK_JOB_PRINST -alter table JBPM_JOB drop constraint FK_JOB_ACTION -alter table JBPM_JOB drop constraint FK_JOB_TOKEN -alter table JBPM_JOB drop constraint FK_JOB_NODE -alter table JBPM_JOB drop constraint FK_JOB_TSKINST -alter table JBPM_LOG drop constraint FK_LOG_SOURCENODE -alter table JBPM_LOG drop constraint FK_LOG_DESTNODE -alter table JBPM_LOG drop constraint FK_LOG_TOKEN -alter table JBPM_LOG drop constraint FK_LOG_TRANSITION -alter table JBPM_LOG drop constraint FK_LOG_TASKINST -alter table JBPM_LOG drop constraint FK_LOG_CHILDTOKEN -alter table JBPM_LOG drop constraint FK_LOG_OLDBYTES -alter table JBPM_LOG drop constraint FK_LOG_SWIMINST -alter table JBPM_LOG drop constraint FK_LOG_NEWBYTES -alter table JBPM_LOG drop constraint FK_LOG_ACTION -alter table JBPM_LOG drop constraint FK_LOG_VARINST -alter table JBPM_LOG drop constraint FK_LOG_NODE -alter table JBPM_LOG drop constraint FK_LOG_PARENT -alter table JBPM_MODULEDEFINITION drop constraint FK_MODDEF_PROCDEF -alter table JBPM_MODULEDEFINITION drop constraint FK_TSKDEF_START -alter table JBPM_MODULEINSTANCE drop constraint FK_MODINST_PRCINST -alter table JBPM_MODULEINSTANCE drop constraint FK_TASKMGTINST_TMD -alter table JBPM_NODE drop constraint FK_DECISION_DELEG -alter table JBPM_NODE drop constraint FK_NODE_PROCDEF -alter table JBPM_NODE drop constraint FK_NODE_ACTION -alter table JBPM_NODE drop constraint FK_PROCST_SBPRCDEF -alter table JBPM_NODE drop constraint FK_NODE_SCRIPT -alter table JBPM_NODE drop constraint FK_NODE_SUPERSTATE -alter table JBPM_POOLEDACTOR drop constraint FK_POOLEDACTOR_SLI -alter table JBPM_PROCESSDEFINITION drop constraint FK_PROCDEF_STRTSTA -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_PROCDEF -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_ROOTTKN -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_SPROCTKN -alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_PROCINST -alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_ACTION -alter table JBPM_SWIMLANE drop constraint FK_SWL_ASSDEL -alter table JBPM_SWIMLANE drop constraint FK_SWL_TSKMGMTDEF -alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_TM -alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_SL -alter table JBPM_TASK drop constraint FK_TASK_STARTST -alter table JBPM_TASK drop constraint FK_TASK_PROCDEF -alter table JBPM_TASK drop constraint FK_TASK_ASSDEL -alter table JBPM_TASK drop constraint FK_TASK_SWIMLANE -alter table JBPM_TASK drop constraint FK_TASK_TASKNODE -alter table JBPM_TASK drop constraint FK_TASK_TASKMGTDEF -alter table JBPM_TASK drop constraint FK_TSK_TSKCTRL -alter table JBPM_TASKACTORPOOL drop constraint FK_TASKACTPL_TSKI -alter table JBPM_TASKACTORPOOL drop constraint FK_TSKACTPOL_PLACT -alter table JBPM_TASKCONTROLLER drop constraint FK_TSKCTRL_DELEG -alter table JBPM_TASKINSTANCE drop constraint FK_TSKINS_PRCINS -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TMINST -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TOKEN -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_SLINST -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TASK -alter table JBPM_TOKEN drop constraint FK_TOKEN_SUBPI -alter table JBPM_TOKEN drop constraint FK_TOKEN_PROCINST -alter table JBPM_TOKEN drop constraint FK_TOKEN_NODE -alter table JBPM_TOKEN drop constraint FK_TOKEN_PARENT -alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_TOKEN -alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_CTXT -alter table JBPM_TRANSITION drop constraint FK_TRANSITION_FROM -alter table JBPM_TRANSITION drop constraint FK_TRANS_PROCDEF -alter table JBPM_TRANSITION drop constraint FK_TRANSITION_TO -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_PROCST -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_SCRIPT -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_TSKCTRL -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_PRCINST -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TKVARMP -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TK -alter table JBPM_VARIABLEINSTANCE drop constraint FK_BYTEINST_ARRAY -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VAR_TSKINST -drop table JBPM_ACTION -drop table JBPM_BYTEARRAY -drop table JBPM_BYTEBLOCK -drop table JBPM_COMMENT -drop table JBPM_DECISIONCONDITIONS -drop table JBPM_DELEGATION -drop table JBPM_EVENT -drop table JBPM_EXCEPTIONHANDLER -drop table JBPM_ID_GROUP -drop table JBPM_ID_MEMBERSHIP -drop table JBPM_ID_PERMISSIONS -drop table JBPM_ID_USER -drop table JBPM_JOB -drop table JBPM_LOG -drop table JBPM_MODULEDEFINITION -drop table JBPM_MODULEINSTANCE -drop table JBPM_NODE -drop table JBPM_POOLEDACTOR -drop table JBPM_PROCESSDEFINITION -drop table JBPM_PROCESSINSTANCE -drop table JBPM_RUNTIMEACTION -drop table JBPM_SWIMLANE -drop table JBPM_SWIMLANEINSTANCE -drop table JBPM_TASK -drop table JBPM_TASKACTORPOOL -drop table JBPM_TASKCONTROLLER -drop table JBPM_TASKINSTANCE -drop table JBPM_TOKEN -drop table JBPM_TOKENVARIABLEMAP -drop table JBPM_TRANSITION -drop table JBPM_VARIABLEACCESS -drop table JBPM_VARIABLEINSTANCE -drop table hibernate_unique_key create table JBPM_ACTION (ID_ numeric not null, class character(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ bit, ACTIONEXPRESSION_ varchar(255), ISASYNC_ bit, REFERENCEDACTION_ numeric, ACTIONDELEGATION_ numeric, EVENT_ numeric, PROCESSDEFINITION_ numeric, EXPRESSION_ varchar(4000), TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ numeric, EVENTINDEX_ integer, EXCEPTIONHANDLER_ numeric, EXCEPTIONHANDLERINDEX_ integer, primary key (ID_)) create table JBPM_BYTEARRAY (ID_ numeric not null, NAME_ varchar(255), FILEDEFINITION_ numeric, primary key (ID_)) create table JBPM_BYTEBLOCK (PROCESSFILE_ numeric not null, BYTES_ varbinary(1024), INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_)) Modified: jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.sapdb.sql =================================================================== --- jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.sapdb.sql 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.sapdb.sql 2009-02-21 13:48:56 UTC (rev 3992) @@ -1,36 +1,3 @@ -drop table JBPM_ACTION -drop table JBPM_BYTEARRAY -drop table JBPM_BYTEBLOCK -drop table JBPM_COMMENT -drop table JBPM_DECISIONCONDITIONS -drop table JBPM_DELEGATION -drop table JBPM_EVENT -drop table JBPM_EXCEPTIONHANDLER -drop table JBPM_ID_GROUP -drop table JBPM_ID_MEMBERSHIP -drop table JBPM_ID_PERMISSIONS -drop table JBPM_ID_USER -drop table JBPM_JOB -drop table JBPM_LOG -drop table JBPM_MODULEDEFINITION -drop table JBPM_MODULEINSTANCE -drop table JBPM_NODE -drop table JBPM_POOLEDACTOR -drop table JBPM_PROCESSDEFINITION -drop table JBPM_PROCESSINSTANCE -drop table JBPM_RUNTIMEACTION -drop table JBPM_SWIMLANE -drop table JBPM_SWIMLANEINSTANCE -drop table JBPM_TASK -drop table JBPM_TASKACTORPOOL -drop table JBPM_TASKCONTROLLER -drop table JBPM_TASKINSTANCE -drop table JBPM_TOKEN -drop table JBPM_TOKENVARIABLEMAP -drop table JBPM_TRANSITION -drop table JBPM_VARIABLEACCESS -drop table JBPM_VARIABLEINSTANCE -drop sequence hibernate_sequence create table JBPM_ACTION (ID_ fixed(19,0) not null, class char(1) not null, NAME_ varchar(255) null, ISPROPAGATIONALLOWED_ boolean null, ACTIONEXPRESSION_ varchar(255) null, ISASYNC_ boolean null, REFERENCEDACTION_ fixed(19,0) null, ACTIONDELEGATION_ fixed(19,0) null, EVENT_ fixed(19,0) null, PROCESSDEFINITION_ fixed(19,0) null, EXPRESSION_ varchar(4000) null, TIMERNAME_ varchar(255) null, DUEDATE_ varchar(255) null, REPEAT_ varchar(255) null, TRANSITIONNAME_ varchar(255) null, TIMERACTION_ fixed(19,0) null, EVENTINDEX_ int null, EXCEPTIONHANDLER_ fixed(19,0) null, EXCEPTIONHANDLERINDEX_ int null, primary key (ID_)) create table JBPM_BYTEARRAY (ID_ fixed(19,0) not null, NAME_ varchar(255) null, FILEDEFINITION_ fixed(19,0) null, primary key (ID_)) create table JBPM_BYTEBLOCK (PROCESSFILE_ fixed(19,0) not null, BYTES_ long byte null, INDEX_ int not null, primary key (PROCESSFILE_, INDEX_)) Modified: jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.sybase.sql =================================================================== --- jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.sybase.sql 2009-02-21 13:08:24 UTC (rev 3991) +++ jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.sybase.sql 2009-02-21 13:48:56 UTC (rev 3992) @@ -1,125 +1,3 @@ -alter table JBPM_ACTION drop constraint FK_ACTION_REFACT -alter table JBPM_ACTION drop constraint FK_CRTETIMERACT_TA -alter table JBPM_ACTION drop constraint FK_ACTION_PROCDEF -alter table JBPM_ACTION drop constraint FK_ACTION_EVENT -alter table JBPM_ACTION drop constraint FK_ACTION_ACTNDEL -alter table JBPM_ACTION drop constraint FK_ACTION_EXPTHDL -alter table JBPM_BYTEARRAY drop constraint FK_BYTEARR_FILDEF -alter table JBPM_BYTEBLOCK drop constraint FK_BYTEBLOCK_FILE -alter table JBPM_COMMENT drop constraint FK_COMMENT_TOKEN -alter table JBPM_COMMENT drop constraint FK_COMMENT_TSK -alter table JBPM_DECISIONCONDITIONS drop constraint FK_DECCOND_DEC -alter table JBPM_DELEGATION drop constraint FK_DELEGATION_PRCD -alter table JBPM_EVENT drop constraint FK_EVENT_PROCDEF -alter table JBPM_EVENT drop constraint FK_EVENT_TRANS -alter table JBPM_EVENT drop constraint FK_EVENT_NODE -alter table JBPM_EVENT drop constraint FK_EVENT_TASK -alter table JBPM_ID_GROUP drop constraint FK_ID_GRP_PARENT -alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_GRP -alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_USR -alter table JBPM_JOB drop constraint FK_JOB_PRINST -alter table JBPM_JOB drop constraint FK_JOB_ACTION -alter table JBPM_JOB drop constraint FK_JOB_TOKEN -alter table JBPM_JOB drop constraint FK_JOB_NODE -alter table JBPM_JOB drop constraint FK_JOB_TSKINST -alter table JBPM_LOG drop constraint FK_LOG_SOURCENODE -alter table JBPM_LOG drop constraint FK_LOG_DESTNODE -alter table JBPM_LOG drop constraint FK_LOG_TOKEN -alter table JBPM_LOG drop constraint FK_LOG_TRANSITION -alter table JBPM_LOG drop constraint FK_LOG_TASKINST -alter table JBPM_LOG drop constraint FK_LOG_CHILDTOKEN -alter table JBPM_LOG drop constraint FK_LOG_OLDBYTES -alter table JBPM_LOG drop constraint FK_LOG_SWIMINST -alter table JBPM_LOG drop constraint FK_LOG_NEWBYTES -alter table JBPM_LOG drop constraint FK_LOG_ACTION -alter table JBPM_LOG drop constraint FK_LOG_VARINST -alter table JBPM_LOG drop constraint FK_LOG_NODE -alter table JBPM_LOG drop constraint FK_LOG_PARENT -alter table JBPM_MODULEDEFINITION drop constraint FK_MODDEF_PROCDEF -alter table JBPM_MODULEDEFINITION drop constraint FK_TSKDEF_START -alter table JBPM_MODULEINSTANCE drop constraint FK_MODINST_PRCINST -alter table JBPM_MODULEINSTANCE drop constraint FK_TASKMGTINST_TMD -alter table JBPM_NODE drop constraint FK_DECISION_DELEG -alter table JBPM_NODE drop constraint FK_NODE_PROCDEF -alter table JBPM_NODE drop constraint FK_NODE_ACTION -alter table JBPM_NODE drop constraint FK_PROCST_SBPRCDEF -alter table JBPM_NODE drop constraint FK_NODE_SCRIPT -alter table JBPM_NODE drop constraint FK_NODE_SUPERSTATE -alter table JBPM_POOLEDACTOR drop constraint FK_POOLEDACTOR_SLI -alter table JBPM_PROCESSDEFINITION drop constraint FK_PROCDEF_STRTSTA -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_PROCDEF -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_ROOTTKN -alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_SPROCTKN -alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_PROCINST -alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_ACTION -alter table JBPM_SWIMLANE drop constraint FK_SWL_ASSDEL -alter table JBPM_SWIMLANE drop constraint FK_SWL_TSKMGMTDEF -alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_TM -alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_SL -alter table JBPM_TASK drop constraint FK_TASK_STARTST -alter table JBPM_TASK drop constraint FK_TASK_PROCDEF -alter table JBPM_TASK drop constraint FK_TASK_ASSDEL -alter table JBPM_TASK drop constraint FK_TASK_SWIMLANE -alter table JBPM_TASK drop constraint FK_TASK_TASKNODE -alter table JBPM_TASK drop constraint FK_TASK_TASKMGTDEF -alter table JBPM_TASK drop constraint FK_TSK_TSKCTRL -alter table JBPM_TASKACTORPOOL drop constraint FK_TASKACTPL_TSKI -alter table JBPM_TASKACTORPOOL drop constraint FK_TSKACTPOL_PLACT -alter table JBPM_TASKCONTROLLER drop constraint FK_TSKCTRL_DELEG -alter table JBPM_TASKINSTANCE drop constraint FK_TSKINS_PRCINS -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TMINST -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TOKEN -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_SLINST -alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TASK -alter table JBPM_TOKEN drop constraint FK_TOKEN_SUBPI -alter table JBPM_TOKEN drop constraint FK_TOKEN_PROCINST -alter table JBPM_TOKEN drop constraint FK_TOKEN_NODE -alter table JBPM_TOKEN drop constraint FK_TOKEN_PARENT -alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_TOKEN -alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_CTXT -alter table JBPM_TRANSITION drop constraint FK_TRANSITION_FROM -alter table JBPM_TRANSITION drop constraint FK_TRANS_PROCDEF -alter table JBPM_TRANSITION drop constraint FK_TRANSITION_TO -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_PROCST -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_SCRIPT -alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_TSKCTRL -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_PRCINST -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TKVARMP -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TK -alter table JBPM_VARIABLEINSTANCE drop constraint FK_BYTEINST_ARRAY -alter table JBPM_VARIABLEINSTANCE drop constraint FK_VAR_TSKINST -drop table JBPM_ACTION -drop table JBPM_BYTEARRAY -drop table JBPM_BYTEBLOCK -drop table JBPM_COMMENT -drop table JBPM_DECISIONCONDITIONS -drop table JBPM_DELEGATION -drop table JBPM_EVENT -drop table JBPM_EXCEPTIONHANDLER -drop table JBPM_ID_GROUP -drop table JBPM_ID_MEMBERSHIP -drop table JBPM_ID_PERMISSIONS -drop table JBPM_ID_USER -drop table JBPM_JOB -drop table JBPM_LOG -drop table JBPM_MODULEDEFINITION -drop table JBPM_MODULEINSTANCE -drop table JBPM_NODE -drop table JBPM_POOLEDACTOR -drop table JBPM_PROCESSDEFINITION -drop table JBPM_PROCESSINSTANCE -drop table JBPM_RUNTIMEACTION -drop table JBPM_SWIMLANE -drop table JBPM_SWIMLANEINSTANCE -drop table JBPM_TASK -drop table JBPM_TASKACTORPOOL -drop table JBPM_TASKCONTROLLER -drop table JBPM_TASKINSTANCE -drop table JBPM_TOKEN -drop table JBPM_TOKENVARIABLEMAP -drop table JBPM_TRANSITION -drop table JBPM_VARIABLEACCESS -drop table JBPM_VARIABLEINSTANCE create table JBPM_ACTION (ID_ numeric(19,0) identity not null, class char(1) not null, NAME_ varchar(255) null, ISPROPAGATIONALLOWED_ tinyint null, ACTIONEXPRESSION_ varchar(255) null, ISASYNC_ tinyint null, REFERENCEDACTION_ numeric(19,0) null, ACTIONDELEGATION_ numeric(19,0) null, EVENT_ numeric(19,0) null, PROCESSDEFINITION_ numeric(19,0) null, EXPRESSION_ varchar(4000) null, TIMERNAME_ varchar(255) null, DUEDATE_ varchar(255) null, REPEAT_ varchar(255) null, TRANSITIONNAME_ varchar(255) null, TIMERACTION_ numeric(19,0) null, EVENTINDEX_ int null, EXCEPTIONHANDLER_ numeric(19,0) null, EXCEPTIONHANDLERINDEX_ int null, primary key (ID_)) create table JBPM_BYTEARRAY (ID_ numeric(19,0) identity not null, NAME_ varchar(255) null, FILEDEFINITION_ numeric(19,0) null, primary key (ID_)) create table JBPM_BYTEBLOCK (PROCESSFILE_ numeric(19,0) not null, BYTES_ varbinary(1024) null, INDEX_ int not null, primary key (PROCESSFILE_, INDEX_))