October 2009 - riftsaw-commits - Jboss List Archives

riftsaw SVN: r176 - trunk/console/integration/src/main/java/org/jboss/soa/bpel/console.

by riftsaw-commits＠lists.jboss.org

Author: jeff.yuchang Date: 2009-10-15 04:28:14 -0400 (Thu, 15 Oct 2009) New Revision: 176 Modified: trunk/console/integration/src/main/java/org/jboss/soa/bpel/console/ModelAdaptor.java trunk/console/integration/src/main/java/org/jboss/soa/bpel/console/ProcessMgmtImpl.java Log: * RIFTSAW-51, show the processName instead of process id in UI. * query instance thru namespace temporarily. Modified: trunk/console/integration/src/main/java/org/jboss/soa/bpel/console/ModelAdaptor.java =================================================================== --- trunk/console/integration/src/main/java/org/jboss/soa/bpel/console/ModelAdaptor.java 2009-10-15 08:26:01 UTC (rev 175) +++ trunk/console/integration/src/main/java/org/jboss/soa/bpel/console/ModelAdaptor.java 2009-10-15 08:28:14 UTC (rev 176) @@ -48,7 +48,7 @@ ProcessDefinitionRef def = new ProcessDefinitionRef( encodeId(pi.getPid()), - pi.getPid(), + processQName.toString(), pi.getVersion() ); @@ -58,7 +58,7 @@ results.add(def); } - + return results; } @@ -75,10 +75,10 @@ null, false ); - + results.add(ref); } - + return results; } Modified: trunk/console/integration/src/main/java/org/jboss/soa/bpel/console/ProcessMgmtImpl.java =================================================================== --- trunk/console/integration/src/main/java/org/jboss/soa/bpel/console/ProcessMgmtImpl.java 2009-10-15 08:26:01 UTC (rev 175) +++ trunk/console/integration/src/main/java/org/jboss/soa/bpel/console/ProcessMgmtImpl.java 2009-10-15 08:28:14 UTC (rev 176) @@ -79,10 +79,12 @@ { String actualId = ModelAdaptor.decodeId(definitionId); QName qname = QName.valueOf(actualId); - + + //TODO: qname.getLocalPart() includes the version number. InstanceInfoListDocument result = getMgmtFacade().listInstances( // filter, order, limit - "name="+qname.getLocalPart() +" namespace=*", "name", 1000); + "namespace=" + qname.getNamespaceURI(), "name", 1000); + return ModelAdaptor.adoptInstances(result); }

15 years, 2 months

1
0
0 / 0

riftsaw SVN: r174 - in trunk: console/identity and 2 other directories.

by riftsaw-commits＠lists.jboss.org

Author: heiko.braun(a)jboss.com Date: 2009-10-13 14:18:54 -0400 (Tue, 13 Oct 2009) New Revision: 174 Removed: trunk/console/console.iml trunk/console/identity/riftsaw-console-identity.iml trunk/console/integration/riftsaw-console-integration.iml trunk/runtime/jbossesb-bpel/jbossesb-bpel.iml Log: Remove intellj files Deleted: trunk/console/console.iml =================================================================== --- trunk/console/console.iml 2009-10-12 16:44:03 UTC (rev 173) +++ trunk/console/console.iml 2009-10-13 18:18:54 UTC (rev 174) @@ -1,15 +0,0 @@ -<?xml version="1.0" encoding="UTF-8"?> -<module version="4" relativePaths="true" type="JAVA_MODULE"> - <component name="ModuleRootManager" /> - <component name="NewModuleRootManager" inherit-compiler-output="true"> - <exclude-output /> - <content url="file://$MODULE_DIR$"> - <sourceFolder url="file://$MODULE_DIR$/integration/src/main/java" isTestSource="false" /> - <sourceFolder url="file://$MODULE_DIR$/integration/src/main/resources" isTestSource="false" /> - </content> - <orderEntry type="inheritedJdk" /> - <orderEntry type="sourceFolder" forTests="false" /> - <orderEntryProperties /> - </component> -</module> - Deleted: trunk/console/identity/riftsaw-console-identity.iml =================================================================== --- trunk/console/identity/riftsaw-console-identity.iml 2009-10-12 16:44:03 UTC (rev 173) +++ trunk/console/identity/riftsaw-console-identity.iml 2009-10-13 18:18:54 UTC (rev 174) @@ -1,12 +0,0 @@ -<?xml version="1.0" encoding="UTF-8"?> -<module relativePaths="true" type="JAVA_MODULE" version="4"> - <component name="NewModuleRootManager" inherit-compiler-output="true"> - <exclude-output /> - <content url="file://$MODULE_DIR$"> - <sourceFolder url="file://$MODULE_DIR$/src/main/resources" isTestSource="false" /> - </content> - <orderEntry type="inheritedJdk" /> - <orderEntry type="sourceFolder" forTests="false" /> - </component> -</module> - Deleted: trunk/console/integration/riftsaw-console-integration.iml =================================================================== --- trunk/console/integration/riftsaw-console-integration.iml 2009-10-12 16:44:03 UTC (rev 173) +++ trunk/console/integration/riftsaw-console-integration.iml 2009-10-13 18:18:54 UTC (rev 174) @@ -1,204 +0,0 @@ -<?xml version="1.0" encoding="UTF-8"?> -<module relativePaths="true" type="JAVA_MODULE" version="4"> - <component name="NewModuleRootManager" inherit-compiler-output="true"> - <exclude-output /> - <content url="file://$MODULE_DIR$"> - <sourceFolder url="file://$MODULE_DIR$/src/main/java" isTestSource="false" /> - <sourceFolder url="file://$MODULE_DIR$/src/main/resources" isTestSource="false" /> - </content> - <orderEntry type="inheritedJdk" /> - <orderEntry type="sourceFolder" forTests="false" /> - <orderEntry type="module" module-name="engine" exported="" /> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: javax.xml.bind:jaxb-api:jar:2.1:provided"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/javax/xml/bind/jaxb-api/2.1/jaxb-api-2.1.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES> - <root url="jar://$MAVEN_REPOSITORY$/javax/xml/bind/jaxb-api/2.1/jaxb-api-2.1-sources.jar!/" /> - </SOURCES> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: javax.xml.stream:stax-api:jar:1.0-2:provided"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/javax/xml/stream/stax-api/1.0-2/stax-api-1.0-2.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: stax:stax-api:jar:1.0.1:compile"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/stax/stax-api/1.0.1/stax-api-1.0.1.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: org.apache.xmlbeans:xmlbeans:jar:2.4.0:compile"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/org/apache/xmlbeans/xmlbeans/2.4.0/xmlbeans-2.4.0.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: org.jboss.bpm:gwt-console-rpc:jar:1.1.2-SNAPSHOT:provided"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/org/jboss/bpm/gwt-console-rpc/1.1.2-SNAPSHOT/gwt-console-rpc-1.1.2-SNAPSHOT.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES> - <root url="jar://$MAVEN_REPOSITORY$/org/jboss/bpm/gwt-console-rpc/1.1.2-SNAPSHOT/gwt-console-rpc-1.1.2-SNAPSHOT-sources.jar!/" /> - </SOURCES> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: com.google.code.gson:gson:jar:1.2.2:provided"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/com/google/code/gson/gson/1.2.2/gson-1.2.2.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: org.jboss.bpm:gwt-console-server-integration:jar:1.1.2-SNAPSHOT:provided"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/org/jboss/bpm/gwt-console-server-integration/1.1.2-SNAPSHOT/gwt-console-server-integration-1.1.2-SNAPSHOT.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES> - <root url="jar://$MAVEN_REPOSITORY$/org/jboss/bpm/gwt-console-server-integration/1.1.2-SNAPSHOT/gwt-console-server-integration-1.1.2-SNAPSHOT-sources.jar!/" /> - </SOURCES> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: javax.activation:activation:jar:1.1:provided"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/javax/activation/activation/1.1/activation-1.1.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES> - <root url="jar://$MAVEN_REPOSITORY$/javax/activation/activation/1.1/activation-1.1-sources.jar!/" /> - </SOURCES> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: org.jboss.soa.bpel:riftsaw-utils:jar:1.3.3:compile"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/org/jboss/soa/bpel/riftsaw-utils/1.3.3/riftsaw-utils-1.3.3.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: org.jboss.soa.bpel:riftsaw-bpel-api:jar:1.3.3:compile"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/org/jboss/soa/bpel/riftsaw-bpel-api/1.3.3/riftsaw-bpel-api-1.3.3.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: org.jboss.soa.bpel:riftsaw-bpel-epr:jar:1.3.3:compile"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/org/jboss/soa/bpel/riftsaw-bpel-epr/1.3.3/riftsaw-bpel-epr-1.3.3.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: commons-logging:commons-logging:jar:1.1.1:compile"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/commons-logging/commons-logging/1.1.1/commons-logging-1.1.1.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: javassist:javassist:jar:3.11.0.GA:compile"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/javassist/javassist/3.11.0.GA/javassist-3.11.0.GA.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES> - <root url="jar://$MAVEN_REPOSITORY$/javassist/javassist/3.11.0.GA/javassist-3.11.0.GA-sources.jar!/" /> - </SOURCES> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: org.jboss.soa.bpel:riftsaw-bpel-store:jar:1.3.3:compile"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/org/jboss/soa/bpel/riftsaw-bpel-store/1.3.3/riftsaw-bpel-store-1.3.3.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: org.jboss.soa.bpel:riftsaw-bpel-dao:jar:1.3.3:compile"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/org/jboss/soa/bpel/riftsaw-bpel-dao/1.3.3/riftsaw-bpel-dao-1.3.3.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: org.jboss.soa.bpel:riftsaw-scheduler-simple:jar:1.3.3:compile"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/org/jboss/soa/bpel/riftsaw-scheduler-simple/1.3.3/riftsaw-scheduler-simple-1.3.3.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: wsdl4j:wsdl4j:jar:1.6.2:compile"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/wsdl4j/wsdl4j/1.6.2/wsdl4j-1.6.2.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: org.jboss.soa.bpel:riftsaw-agents:jar:1.3.3:compile"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/org/jboss/soa/bpel/riftsaw-agents/1.3.3/riftsaw-agents-1.3.3.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: org.jboss.soa.bpel:riftsaw-bpel-runtime:jar:1.3.3:compile"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/org/jboss/soa/bpel/riftsaw-bpel-runtime/1.3.3/riftsaw-bpel-runtime-1.3.3.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: org.jboss.soa.bpel:riftsaw-bpel-schemas:jar:1.3.3:compile"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/org/jboss/soa/bpel/riftsaw-bpel-schemas/1.3.3/riftsaw-bpel-schemas-1.3.3.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - </component> -</module> - Deleted: trunk/runtime/jbossesb-bpel/jbossesb-bpel.iml =================================================================== --- trunk/runtime/jbossesb-bpel/jbossesb-bpel.iml 2009-10-12 16:44:03 UTC (rev 173) +++ trunk/runtime/jbossesb-bpel/jbossesb-bpel.iml 2009-10-13 18:18:54 UTC (rev 174) @@ -1,155 +0,0 @@ -<?xml version="1.0" encoding="UTF-8"?> -<module relativePaths="true" type="JAVA_MODULE" version="4"> - <component name="NewModuleRootManager" inherit-compiler-output="true"> - <exclude-output /> - <content url="file://$MODULE_DIR$"> - <sourceFolder url="file://$MODULE_DIR$/src/main/java" isTestSource="false" /> - <sourceFolder url="file://$MODULE_DIR$/src/main/resources" isTestSource="false" /> - <sourceFolder url="file://$MODULE_DIR$/src/test/java" isTestSource="true" /> - <sourceFolder url="file://$MODULE_DIR$/src/test/resources" isTestSource="true" /> - </content> - <orderEntry type="inheritedJdk" /> - <orderEntry type="sourceFolder" forTests="false" /> - <orderEntry type="module" module-name="engine" exported="" /> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: junit:junit:jar:3.8.1:test"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/junit/junit/3.8.1/junit-3.8.1.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: org.jboss.soa.esb:jbossesb-rosetta:jar:4.5.GA:compile"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/org/jboss/soa/esb/jbossesb-rosetta/4.5.GA/jbossesb-rosetta-4.5.GA.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: org.jboss.soa.bpel:riftsaw-bpel-api:jar:1.3.3:compile"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/org/jboss/soa/bpel/riftsaw-bpel-api/1.3.3/riftsaw-bpel-api-1.3.3.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: org.jboss.soa.bpel:riftsaw-utils:jar:1.3.3:compile"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/org/jboss/soa/bpel/riftsaw-utils/1.3.3/riftsaw-utils-1.3.3.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: org.jboss.soa.bpel:riftsaw-bpel-epr:jar:1.3.3:compile"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/org/jboss/soa/bpel/riftsaw-bpel-epr/1.3.3/riftsaw-bpel-epr-1.3.3.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: commons-logging:commons-logging:jar:1.1.1:compile"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/commons-logging/commons-logging/1.1.1/commons-logging-1.1.1.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: javassist:javassist:jar:3.11.0.GA:compile"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/javassist/javassist/3.11.0.GA/javassist-3.11.0.GA.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES> - <root url="jar://$MAVEN_REPOSITORY$/javassist/javassist/3.11.0.GA/javassist-3.11.0.GA-sources.jar!/" /> - </SOURCES> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: org.jboss.soa.bpel:riftsaw-bpel-store:jar:1.3.3:compile"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/org/jboss/soa/bpel/riftsaw-bpel-store/1.3.3/riftsaw-bpel-store-1.3.3.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: org.jboss.soa.bpel:riftsaw-bpel-dao:jar:1.3.3:compile"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/org/jboss/soa/bpel/riftsaw-bpel-dao/1.3.3/riftsaw-bpel-dao-1.3.3.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: org.jboss.soa.bpel:riftsaw-scheduler-simple:jar:1.3.3:compile"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/org/jboss/soa/bpel/riftsaw-scheduler-simple/1.3.3/riftsaw-scheduler-simple-1.3.3.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: wsdl4j:wsdl4j:jar:1.6.2:compile"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/wsdl4j/wsdl4j/1.6.2/wsdl4j-1.6.2.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: org.jboss.soa.bpel:riftsaw-agents:jar:1.3.3:compile"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/org/jboss/soa/bpel/riftsaw-agents/1.3.3/riftsaw-agents-1.3.3.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: org.jboss.soa.esb:jbossts-common:jar:4.5.GA:test"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/org/jboss/soa/esb/jbossts-common/4.5.GA/jbossts-common-4.5.GA.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: org.jboss.soa.bpel:riftsaw-bpel-runtime:jar:1.3.3:compile"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/org/jboss/soa/bpel/riftsaw-bpel-runtime/1.3.3/riftsaw-bpel-runtime-1.3.3.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES /> - </library> - </orderEntry> - <orderEntry type="module-library" exported=""> - <library name="M2 Dep: log4j:log4j:jar:1.2.14:test"> - <CLASSES> - <root url="jar://$MAVEN_REPOSITORY$/log4j/log4j/1.2.14/log4j-1.2.14.jar!/" /> - </CLASSES> - <JAVADOC /> - <SOURCES> - <root url="jar://$MAVEN_REPOSITORY$/log4j/log4j/1.2.14/log4j-1.2.14-sources.jar!/" /> - </SOURCES> - </library> - </orderEntry> - </component> -</module> -

15 years, 2 months

1
0
0 / 0

riftsaw SVN: r173 - trunk/console/integration/src/main/java/org/jboss/soa/bpel/console.

by riftsaw-commits＠lists.jboss.org

Author: heiko.braun(a)jboss.com Date: 2009-10-12 12:44:03 -0400 (Mon, 12 Oct 2009) New Revision: 173 Modified: trunk/console/integration/src/main/java/org/jboss/soa/bpel/console/ProcessMgmtImpl.java Log: Fix console integration Modified: trunk/console/integration/src/main/java/org/jboss/soa/bpel/console/ProcessMgmtImpl.java =================================================================== --- trunk/console/integration/src/main/java/org/jboss/soa/bpel/console/ProcessMgmtImpl.java 2009-10-12 16:43:21 UTC (rev 172) +++ trunk/console/integration/src/main/java/org/jboss/soa/bpel/console/ProcessMgmtImpl.java 2009-10-12 16:44:03 UTC (rev 173) @@ -78,56 +78,56 @@ public List<ProcessInstanceRef> getProcessInstances(String definitionId) { String actualId = ModelAdaptor.decodeId(definitionId); - QName qname = new QName(actualId); + QName qname = QName.valueOf(actualId); InstanceInfoListDocument result = - getMgmtFacade().listInstances( - "name="+qname.getLocalPart()+" namespace="+qname.getNamespaceURI(), "started", 1000); + getMgmtFacade().listInstances( // filter, order, limit + "name="+qname.getLocalPart() +" namespace=*", "name", 1000); return ModelAdaptor.adoptInstances(result); } public ProcessInstanceRef getProcessInstance(String instanceId) { - return null; + throw new RuntimeException("Not implemented"); } public ProcessInstanceRef newInstance(String defintionId) { - return null; + throw new RuntimeException("Not implemented"); } public ProcessInstanceRef newInstance(String definitionId, Map<String, Object> processVars) { - return null; + throw new RuntimeException("Not implemented"); } public Map<String, Object> getInstanceData(String instanceId) { - return null; + throw new RuntimeException("Not implemented"); } public void setInstanceData(String instanceId, Map<String, Object> data) { - + throw new RuntimeException("Not implemented"); } public void endInstance(String instanceId, ProcessInstanceRef.RESULT result) { - + throw new RuntimeException("Not implemented"); } public void deleteInstance(String instanceId) { - + throw new RuntimeException("Not implemented"); } public void setProcessState(String instanceId, ProcessInstanceRef.STATE nextState) { - + throw new RuntimeException("Not implemented"); } public void signalExecution(String executionId, String signal) { - + throw new RuntimeException("Not implemented"); } }

15 years, 2 months

1
0
0 / 0

riftsaw SVN: r172 - trunk/runtime/engine-assembly/resources/bpel-sql.

by riftsaw-commits＠lists.jboss.org

Author: heiko.braun(a)jboss.com Date: 2009-10-12 12:43:21 -0400 (Mon, 12 Oct 2009) New Revision: 172 Modified: trunk/runtime/engine-assembly/resources/bpel-sql/bpel-ds-mysql.xml Log: Update the default mysql ds decriptor Modified: trunk/runtime/engine-assembly/resources/bpel-sql/bpel-ds-mysql.xml =================================================================== --- trunk/runtime/engine-assembly/resources/bpel-sql/bpel-ds-mysql.xml 2009-10-12 16:42:34 UTC (rev 171) +++ trunk/runtime/engine-assembly/resources/bpel-sql/bpel-ds-mysql.xml 2009-10-12 16:43:21 UTC (rev 172) @@ -14,10 +14,10 @@ <datasources> <local-tx-datasource> <jndi-name>BPELDB</jndi-name> - <connection-url>jdbc:mysql://localhost/bpel?autoReconnect=true</connection-url> + <connection-url>jdbc:mysql://localhost/riftsawdb?autoReconnect=true</connection-url> <driver-class>com.mysql.jdbc.Driver</driver-class> - <user-name>root</user-name> - <password></password> + <user-name>riftsaw</user-name> + <password>riftsaw</password>

15 years, 2 months

1
0
0 / 0

riftsaw SVN: r171 - trunk/runtime/engine/src/main/java/org/jboss/soa/bpel/runtime/db.

by riftsaw-commits＠lists.jboss.org

Author: heiko.braun(a)jboss.com Date: 2009-10-12 12:42:34 -0400 (Mon, 12 Oct 2009) New Revision: 171 Modified: trunk/runtime/engine/src/main/java/org/jboss/soa/bpel/runtime/db/DatabaseInitializer.java Log: Improve exception handling and run in TX when creating the BPEL schema Modified: trunk/runtime/engine/src/main/java/org/jboss/soa/bpel/runtime/db/DatabaseInitializer.java =================================================================== --- trunk/runtime/engine/src/main/java/org/jboss/soa/bpel/runtime/db/DatabaseInitializer.java 2009-10-12 12:21:55 UTC (rev 170) +++ trunk/runtime/engine/src/main/java/org/jboss/soa/bpel/runtime/db/DatabaseInitializer.java 2009-10-12 16:42:34 UTC (rev 171) @@ -32,6 +32,8 @@ import javax.naming.InitialContext; import javax.sql.DataSource; +import javax.transaction.SystemException; +import javax.transaction.UserTransaction; import org.jboss.system.ServiceMBeanSupport; @@ -126,32 +128,51 @@ } public void executeSql(String resource, Connection conn) - throws Exception { - URL url = Thread.currentThread().getContextClassLoader().getResource(resource); - String sql = getStringFromStream(url.openStream()); - sql = sql.replaceAll("(?m)^--([^\n]+)?$", ""); // Remove all commented lines - final String[] statements ; - if (useEOL) { - statements = sql.split("[\n;]"); - } else { - statements = sql.split(";"); - } - for (String statement : statements) - { - if ((statement == null) || ("".equals(statement.trim()))) { - } else { - Statement sqlStatement = conn.createStatement(); - try - { - sqlStatement.executeUpdate(statement); - } - finally - { - sqlStatement.close(); - } - } - } + UserTransaction tx =null; + try + { + tx = (UserTransaction)new InitialContext().lookup("UserTransaction"); + tx.begin(); + + URL url = Thread.currentThread().getContextClassLoader().getResource(resource); + String sql = getStringFromStream(url.openStream()); + sql = sql.replaceAll("(?m)^--([^\n]+)?$", ""); // Remove all commented lines + final String[] statements ; + if (useEOL) { + statements = sql.split("[\n;]"); + } else { + statements = sql.split(";"); + } + for (String statement : statements) + { + if ((statement == null) || ("".equals(statement.trim()))) { + } + else { + Statement sqlStatement = conn.createStatement(); + try + { + sqlStatement.executeUpdate(statement); + } + finally + { + sqlStatement.close(); + } + } + } + + tx.commit(); + } + catch (Throwable t) + { + if(tx!=null) + try { + tx.rollback(); + } catch (SystemException e) { + // + } + throw new RuntimeException("Failed to create database", t); + } }

15 years, 2 months

1
0
0 / 0

riftsaw SVN: r170 - trunk/runtime/engine-assembly/resources/bpel-sql.

by riftsaw-commits＠lists.jboss.org

Author: heiko.braun(a)jboss.com Date: 2009-10-12 08:21:55 -0400 (Mon, 12 Oct 2009) New Revision: 170 Removed: trunk/runtime/engine-assembly/resources/bpel-sql/bpel.derby.sql trunk/runtime/engine-assembly/resources/bpel-sql/bpel.hsql.sql trunk/runtime/engine-assembly/resources/bpel-sql/bpel.mysql.sql trunk/runtime/engine-assembly/resources/bpel-sql/bpel.oracle.sql trunk/runtime/engine-assembly/resources/bpel-sql/bpel.postgres.sql trunk/runtime/engine-assembly/resources/bpel-sql/bpel.sqlserver.sql trunk/runtime/engine-assembly/resources/bpel-sql/hsql.sql-ORIGINAL Log: Remove legacy sql scripts Deleted: trunk/runtime/engine-assembly/resources/bpel-sql/bpel.derby.sql =================================================================== --- trunk/runtime/engine-assembly/resources/bpel-sql/bpel.derby.sql 2009-10-12 10:26:47 UTC (rev 169) +++ trunk/runtime/engine-assembly/resources/bpel-sql/bpel.derby.sql 2009-10-12 12:21:55 UTC (rev 170) @@ -1,87 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, --- software distributed under the License is distributed on an --- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY --- KIND, either express or implied. See the License for the --- specific language governing permissions and limitations --- under the License. --- - -CREATE TABLE ODE_ACTIVITY_RECOVERY (ID BIGINT NOT NULL, ACTIONS VARCHAR(255), ACTIVITY_ID BIGINT, CHANNEL VARCHAR(255), DATE_TIME TIMESTAMP, DETAILS CLOB, REASON VARCHAR(255), RETRIES INTEGER, INSTANCE_ID BIGINT, PRIMARY KEY (ID)); -CREATE TABLE ODE_CORRELATION_SET (CORRELATION_SET_ID BIGINT NOT NULL, CORRELATION_KEY VARCHAR(255), NAME VARCHAR(255), SCOPE_ID BIGINT, PRIMARY KEY (CORRELATION_SET_ID)); -CREATE TABLE ODE_CORRELATOR (CORRELATOR_ID BIGINT NOT NULL, CORRELATOR_KEY VARCHAR(255), PROC_ID BIGINT, PRIMARY KEY (CORRELATOR_ID)); -CREATE TABLE ODE_CORSET_PROP (ID BIGINT NOT NULL, PROP_KEY VARCHAR(255), PROP_VALUE VARCHAR(255), CORRSET_ID BIGINT, PRIMARY KEY (ID)); -CREATE TABLE ODE_EVENT (EVENT_ID BIGINT NOT NULL, DETAIL VARCHAR(255), DATA BLOB, SCOPE_ID BIGINT, TSTAMP TIMESTAMP, TYPE VARCHAR(255), INSTANCE_ID BIGINT, PROCESS_ID BIGINT, PRIMARY KEY (EVENT_ID)); -CREATE TABLE ODE_FAULT (FAULT_ID BIGINT NOT NULL, ACTIVITY_ID INTEGER, DATA CLOB, MESSAGE VARCHAR(4000), LINE_NUMBER INTEGER, NAME VARCHAR(255), PRIMARY KEY (FAULT_ID)); -CREATE TABLE ODE_MESSAGE (MESSAGE_ID BIGINT NOT NULL, DATA CLOB, HEADER CLOB, TYPE VARCHAR(255), PRIMARY KEY (MESSAGE_ID)); -CREATE TABLE ODE_MESSAGE_EXCHANGE (MESSAGE_EXCHANGE_ID VARCHAR(255) NOT NULL, ACK_TYPE VARCHAR(255), CALLEE VARCHAR(255), CHANNEL VARCHAR(255), CORRELATION_ID VARCHAR(255), CORRELATION_KEYS VARCHAR(255), CORRELATION_STATUS VARCHAR(255), CREATE_TIME TIMESTAMP NOT NULL, DIRECTION INTEGER NOT NULL, EPR CLOB, FAILURE_TYPE VARCHAR(255), FAULT VARCHAR(255), FAULT_EXPLANATION VARCHAR(255), ISTYLE VARCHAR(255), OPERATION VARCHAR(255) NOT NULL, PARTNER_LINK_MODEL_ID INTEGER NOT NULL, PATTERN VARCHAR(255) NOT NULL, PIPED_ID VARCHAR(255), PIPED_PID VARCHAR(255), PORT_TYPE VARCHAR(255), PROPAGATE_TRANS SMALLINT, STATUS VARCHAR(255), TIMEOUT BIGINT, CORRELATOR BIGINT, PLINK BIGINT, PROCESS BIGINT, INSTANCE BIGINT, REQUEST BIGINT, RESPONSE BIGINT, PRIMARY KEY (MESSAGE_EXCHANGE_ID)); -CREATE TABLE ODE_MESSAGE_ROUTE (MESSAGE_ROUTE_ID BIGINT NOT NULL, CORRELATION_KEY VARCHAR(255), GROUP_ID VARCHAR(255), ROUTE_INDEX INTEGER, CORR_ID BIGINT, PROCESS_INSTANCE_ID BIGINT, PRIMARY KEY (MESSAGE_ROUTE_ID)); -CREATE TABLE ODE_MEX_PROP (ID BIGINT NOT NULL, PROP_KEY VARCHAR(255), PROP_VALUE VARCHAR(2000), MEX_ID VARCHAR(255), PRIMARY KEY (ID)); -CREATE TABLE ODE_PARTNER_LINK (PARTNER_LINK_ID BIGINT NOT NULL, MY_EPR CLOB, MY_ROLE_NAME VARCHAR(255), MY_ROLE_SERVICE_NAME VARCHAR(255), MY_SESSION_ID VARCHAR(255), PARTNER_EPR CLOB, PARTNER_LINK_MODEL_ID INTEGER, PARTNER_LINK_NAME VARCHAR(255), PARTNER_ROLE_NAME VARCHAR(255), PARTNER_SESSION_ID VARCHAR(255), SCOPE_ID BIGINT, PRIMARY KEY (PARTNER_LINK_ID)); -CREATE TABLE ODE_PROCESS (ID BIGINT NOT NULL, GUID VARCHAR(255), PROCESS_ID VARCHAR(255), PROCESS_TYPE VARCHAR(255), VERSION BIGINT, PRIMARY KEY (ID)); -CREATE TABLE ODE_PROCESS_INSTANCE (ID BIGINT NOT NULL, DATE_CREATED TIMESTAMP, EXEC_STATE_COUNTER INTEGER, EXECUTION_STATE BLOB, LAST_ACTIVE_TIME TIMESTAMP, LAST_RECOVERY_DATE TIMESTAMP, PREVIOUS_STATE SMALLINT, SEQUENCE BIGINT, INSTANCE_STATE SMALLINT, FAULT_ID BIGINT, INSTANTIATING_CORRELATOR_ID BIGINT, PROCESS_ID BIGINT, ROOT_SCOPE_ID BIGINT, PRIMARY KEY (ID)); -CREATE TABLE ODE_SCOPE (SCOPE_ID BIGINT NOT NULL, MODEL_ID INTEGER, SCOPE_NAME VARCHAR(255), SCOPE_STATE VARCHAR(255), PARENT_SCOPE_ID BIGINT, PROCESS_INSTANCE_ID BIGINT, PRIMARY KEY (SCOPE_ID)); -CREATE TABLE ODE_XML_DATA (XML_DATA_ID BIGINT NOT NULL, DATA CLOB, IS_SIMPLE_TYPE SMALLINT, NAME VARCHAR(255), SCOPE_ID BIGINT, PRIMARY KEY (XML_DATA_ID)); -CREATE TABLE ODE_XML_DATA_PROP (ID BIGINT NOT NULL, PROP_KEY VARCHAR(255), PROP_VALUE VARCHAR(255), XML_DATA_ID BIGINT, PRIMARY KEY (ID)); -CREATE TABLE OPENJPA_SEQUENCE_TABLE (ID SMALLINT NOT NULL, SEQUENCE_VALUE BIGINT, PRIMARY KEY (ID)); -CREATE TABLE STORE_DU (NAME VARCHAR(255) NOT NULL, DEPLOYDT TIMESTAMP, DEPLOYER VARCHAR(255), DIR VARCHAR(255), PRIMARY KEY (NAME)); -CREATE TABLE STORE_PROCESS (PID VARCHAR(255) NOT NULL, STATE VARCHAR(255), TYPE VARCHAR(255), VERSION BIGINT, DU VARCHAR(255), PRIMARY KEY (PID)); -CREATE TABLE STORE_PROCESS_PROP (id BIGINT NOT NULL, PROP_KEY VARCHAR(255), PROP_VAL VARCHAR(255), PRIMARY KEY (id)); -CREATE TABLE STORE_PROC_TO_PROP (ProcessConfDaoImpl_PID VARCHAR(255), element_id BIGINT); -CREATE TABLE STORE_VERSIONS (id BIGINT NOT NULL, VERSION BIGINT, PRIMARY KEY (id)); -CREATE INDEX I_D_CTVRY_INSTANCE ON ODE_ACTIVITY_RECOVERY (INSTANCE_ID); -CREATE INDEX I_D_CR_ST_SCOPE ON ODE_CORRELATION_SET (SCOPE_ID); -CREATE INDEX I_D_CRLTR_PROCESS ON ODE_CORRELATOR (PROC_ID); -CREATE INDEX I_D_CRPRP_CORRSET ON ODE_CORSET_PROP (CORRSET_ID); -CREATE INDEX I_OD_VENT_INSTANCE ON ODE_EVENT (INSTANCE_ID); -CREATE INDEX I_OD_VENT_PROCESS ON ODE_EVENT (PROCESS_ID); -CREATE INDEX I_D_MSHNG_CORRELAT ON ODE_MESSAGE_EXCHANGE (CORRELATOR); -CREATE INDEX I_D_MSHNG_PARTNERL ON ODE_MESSAGE_EXCHANGE (PLINK); -CREATE INDEX I_D_MSHNG_PROCESS ON ODE_MESSAGE_EXCHANGE (PROCESS); -CREATE INDEX I_D_MSHNG_PROCESSI ON ODE_MESSAGE_EXCHANGE (INSTANCE); -CREATE INDEX I_D_MSHNG_REQUEST ON ODE_MESSAGE_EXCHANGE (REQUEST); -CREATE INDEX I_D_MSHNG_RESPONSE ON ODE_MESSAGE_EXCHANGE (RESPONSE); -CREATE INDEX I_D_MS_RT_CORRELAT ON ODE_MESSAGE_ROUTE (CORR_ID); -CREATE INDEX I_D_MS_RT_PROCESSI ON ODE_MESSAGE_ROUTE (PROCESS_INSTANCE_ID); -CREATE INDEX I_D_MXPRP_MEX ON ODE_MEX_PROP (MEX_ID); -CREATE INDEX I_D_PRLNK_SCOPE ON ODE_PARTNER_LINK (SCOPE_ID); -CREATE INDEX I_D_PRTNC_FAULT ON ODE_PROCESS_INSTANCE (FAULT_ID); -CREATE INDEX I_D_PRTNC_INSTANTI ON ODE_PROCESS_INSTANCE (INSTANTIATING_CORRELATOR_ID); -CREATE INDEX I_D_PRTNC_PROCESS ON ODE_PROCESS_INSTANCE (PROCESS_ID); -CREATE INDEX I_D_PRTNC_ROOTSCOP ON ODE_PROCESS_INSTANCE (ROOT_SCOPE_ID); -CREATE INDEX I_OD_SCOP_PARENTSC ON ODE_SCOPE (PARENT_SCOPE_ID); -CREATE INDEX I_OD_SCOP_PROCESSI ON ODE_SCOPE (PROCESS_INSTANCE_ID); -CREATE INDEX I_D_XM_DT_SCOPE ON ODE_XML_DATA (SCOPE_ID); -CREATE INDEX I_D_XMPRP_XMLDATA ON ODE_XML_DATA_PROP (XML_DATA_ID); -CREATE INDEX I_STR_CSS_DU ON STORE_PROCESS (DU); -CREATE INDEX I_STR_PRP_ELEMENT ON STORE_PROC_TO_PROP (element_id); -CREATE INDEX I_STR_PRP_PROCESSC ON STORE_PROC_TO_PROP (ProcessConfDaoImpl_PID); --- Apache ODE - SimpleScheduler Database Schema --- --- Apache Derby scripts by Maciej Szefler. --- --- - -CREATE TABLE ode_job ( - jobid CHAR(64) NOT NULL DEFAULT '', - ts BIGINT NOT NULL DEFAULT 0, - nodeid char(64), - scheduled int NOT NULL DEFAULT 0, - transacted int NOT NULL DEFAULT 0, - details blob(4096), - PRIMARY KEY(jobid)); - -CREATE INDEX IDX_ODE_JOB_TS ON ode_job(ts); -CREATE INDEX IDX_ODE_JOB_NODEID ON ode_job(nodeid); - - Deleted: trunk/runtime/engine-assembly/resources/bpel-sql/bpel.hsql.sql =================================================================== --- trunk/runtime/engine-assembly/resources/bpel-sql/bpel.hsql.sql 2009-10-12 10:26:47 UTC (rev 169) +++ trunk/runtime/engine-assembly/resources/bpel-sql/bpel.hsql.sql 2009-10-12 12:21:55 UTC (rev 170) @@ -1,87 +0,0 @@ --- Apache ODE - SimpleScheduler Database Schema --- --- Apache Derby scripts by Maciej Szefler. --- --- --- Changes: 5/5/09 - had to change blob to binary, and remove DEFAULT from ode_job definition. - - -CREATE TABLE ode_job ( - jobid CHAR(64) NOT NULL, - ts BIGINT NOT NULL, - nodeid char(64), - scheduled int NOT NULL, - transacted int NOT NULL, - details binary, - PRIMARY KEY(jobid)); - -CREATE INDEX IDX_ODE_JOB_TS ON ode_job(ts); -CREATE INDEX IDX_ODE_JOB_NODEID ON ode_job(nodeid); - - -create table BPEL_ACTIVITY_RECOVERY (ID bigint generated by default as identity (start with 1), PIID bigint, AID bigint, CHANNEL varchar(255), REASON varchar(255), DATE_TIME timestamp, LDATA_ID bigint, ACTIONS varchar(255), RETRIES integer, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table BPEL_CORRELATION_PROP (ID bigint generated by default as identity (start with 1), NAME varchar(255), NAMESPACE varchar(255), VALUE varchar(255), CORR_SET_ID bigint, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table BPEL_CORRELATION_SET (ID bigint generated by default as identity (start with 1), VALUE varchar(255), CORR_SET_NAME varchar(255), SCOPE_ID bigint, PIID bigint, PROCESS_ID bigint, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table BPEL_CORRELATOR (ID bigint generated by default as identity (start with 1), CID varchar(255), PROCESS_ID bigint, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table BPEL_CORRELATOR_MESSAGE_CKEY (ID bigint generated by default as identity (start with 1), CKEY varchar(255), CORRELATOR_MESSAGE_ID bigint, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table BPEL_EVENT (ID bigint generated by default as identity (start with 1), IID bigint, PID bigint, TSTAMP timestamp, TYPE varchar(255), DETAIL longvarchar, LDATA_ID bigint, SID bigint, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table BPEL_FAULT (ID bigint generated by default as identity (start with 1), FAULTNAME varchar(255), LDATA_ID bigint, EXPLANATION varchar(4000), LINE_NUM integer, AID integer, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table BPEL_INSTANCE (ID bigint generated by default as identity (start with 1), INSTANTIATING_CORRELATOR bigint, FAULT bigint, JACOB_STATE bigint, PREVIOUS_STATE smallint, PROCESS_ID bigint, STATE smallint, LAST_ACTIVE_DT timestamp, SEQUENCE bigint, FAILURE_COUNT integer, FAILURE_DT timestamp, EXEC_STATE_COUNT integer, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table BPEL_MESSAGE (ID bigint generated by default as identity (start with 1), TYPE varchar(255), DATA bigint, HEADER bigint, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table BPEL_MESSAGE_EXCHANGE (ID bigint generated by default as identity (start with 1), MEXID varchar(255) not null, PORT_TYPE varchar(255), CHANNEL_NAME varchar(255), CLIENTKEY varchar(255), LDATA_EPR_ID bigint, LDATA_CEPR_ID bigint, REQUEST bigint, RESPONSE bigint, INSERT_DT timestamp, OPERATION varchar(255), STATE varchar(255), PROCESS bigint, PIID bigint, DIR char(1), PLINK_MODELID integer, PATTERN varchar(255), CORR_STATUS varchar(255), FAULT_TYPE varchar(255), FAULT_EXPL varchar(255), CALLEE varchar(255), PARTNERLINK bigint, TIMEOUT bigint, ISTYLE varchar(255), P2P_PEER varchar(255), FAILURE_TYPE varchar(255), ACK_TYPE varchar(255), PIPED_PID varchar(255), INSERT_TIME timestamp, MLOCK integer not null, primary key (ID), unique (MEXID)); -create table BPEL_MEX_PROPS (MEX bigint not null, VALUE varchar(8000), NAME varchar(255) not null, primary key (MEX, NAME)); -create table BPEL_PLINK_VAL (ID bigint generated by default as identity (start with 1), PARTNER_LINK varchar(100) not null, PARTNERROLE varchar(100), MYROLE_EPR bigint, PARTNERROLE_EPR bigint, PROCESS bigint, SCOPE bigint, SVCNAME varchar(255), MYROLE varchar(100), MODELID integer, MYSESSIONID varchar(255), PARTNERSESSIONID varchar(255), INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table BPEL_PROCESS (ID bigint generated by default as identity (start with 1), PROCID varchar(255) not null, deployer varchar(255), deploydate timestamp, type_name varchar(255), type_ns varchar(255), version bigint, ACTIVE_ bit, guid varchar(255), INSERT_TIME timestamp, MLOCK integer not null, primary key (ID), unique (PROCID)); -create table BPEL_SCOPE (ID bigint generated by default as identity (start with 1), PIID bigint, PARENT_SCOPE_ID bigint, STATE varchar(255) not null, NAME varchar(255) not null, MODELID integer, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table BPEL_SELECTORS (ID bigint generated by default as identity (start with 1), PIID bigint not null, SELGRPID varchar(255) not null, IDX integer not null, CORRELATION_KEY varchar(255) not null, PROC_TYPE varchar(255) not null, CORRELATOR bigint not null, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID), unique (CORRELATION_KEY, CORRELATOR)); -create table BPEL_UNMATCHED (ID bigint generated by default as identity (start with 1), MEX bigint, CORRELATION_KEY varchar(255), CORRELATOR bigint not null, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table BPEL_XML_DATA (ID bigint generated by default as identity (start with 1), LDATA_ID bigint, NAME varchar(255) not null, SCOPE_ID bigint, PIID bigint, IS_SIMPLE_TYPE bit, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table LARGE_DATA (ID bigint generated by default as identity (start with 1), BIN_DATA binary, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table VAR_PROPERTY (ID bigint generated by default as identity (start with 1), XML_DATA_ID bigint, PROP_VALUE varchar(255), PROP_NAME varchar(255) not null, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -alter table BPEL_ACTIVITY_RECOVERY add constraint FK94D24A7B14020712 foreign key (LDATA_ID) references LARGE_DATA; -alter table BPEL_ACTIVITY_RECOVERY add constraint FK94D24A7BA821BBE1 foreign key (PIID) references BPEL_INSTANCE; -alter table BPEL_CORRELATION_PROP add constraint FK4EC9DDAA4D0B7982 foreign key (CORR_SET_ID) references BPEL_CORRELATION_SET; -alter table BPEL_CORRELATION_SET add constraint FKB838191BA821BBE1 foreign key (PIID) references BPEL_INSTANCE; -alter table BPEL_CORRELATION_SET add constraint FKB838191B6D49C363 foreign key (SCOPE_ID) references BPEL_SCOPE; -alter table BPEL_CORRELATION_SET add constraint FKB838191BE15A2343 foreign key (PROCESS_ID) references BPEL_PROCESS; -create index IDX_CORRELATOR_CID on BPEL_CORRELATOR (CID); -alter table BPEL_CORRELATOR add constraint FKF50EFA33E15A2343 foreign key (PROCESS_ID) references BPEL_PROCESS; -create index IDX_BPEL_CORRELATOR_MESSAGE_CKEY on BPEL_CORRELATOR_MESSAGE_CKEY (CKEY); -alter table BPEL_CORRELATOR_MESSAGE_CKEY add constraint FK8997F700EEFA7470 foreign key (CORRELATOR_MESSAGE_ID) references BPEL_UNMATCHED; -alter table BPEL_EVENT add constraint FKAA6D673014020712 foreign key (LDATA_ID) references LARGE_DATA; -alter table BPEL_EVENT add constraint FKAA6D6730A7EED251 foreign key (IID) references BPEL_INSTANCE; -alter table BPEL_EVENT add constraint FKAA6D6730C831CBE3 foreign key (PID) references BPEL_PROCESS; -alter table BPEL_FAULT add constraint FKAA722EB814020712 foreign key (LDATA_ID) references LARGE_DATA; -alter table BPEL_INSTANCE add constraint FKE1DED41FDD43DBE1 foreign key (INSTANTIATING_CORRELATOR) references BPEL_CORRELATOR; -alter table BPEL_INSTANCE add constraint FKE1DED41F6B66C85F foreign key (JACOB_STATE) references LARGE_DATA; -alter table BPEL_INSTANCE add constraint FKE1DED41F1F3C9CB7 foreign key (FAULT) references BPEL_FAULT; -alter table BPEL_INSTANCE add constraint FKE1DED41FE15A2343 foreign key (PROCESS_ID) references BPEL_PROCESS; -alter table BPEL_MESSAGE add constraint FK4FA7231DEB2C9ED8 foreign key (DATA) references LARGE_DATA; -alter table BPEL_MESSAGE add constraint FK4FA7231DA23291BB foreign key (HEADER) references LARGE_DATA; -alter table BPEL_MESSAGE_EXCHANGE add constraint FKBDA6BD0589D7A75B foreign key (LDATA_CEPR_ID) references LARGE_DATA; -alter table BPEL_MESSAGE_EXCHANGE add constraint FKBDA6BD05BBA250D foreign key (PARTNERLINK) references BPEL_PLINK_VAL; -alter table BPEL_MESSAGE_EXCHANGE add constraint FKBDA6BD05A821BBE1 foreign key (PIID) references BPEL_INSTANCE; -alter table BPEL_MESSAGE_EXCHANGE add constraint FKBDA6BD05C29670AA foreign key (LDATA_EPR_ID) references LARGE_DATA; -alter table BPEL_MESSAGE_EXCHANGE add constraint FKBDA6BD05B5BD38C7 foreign key (PROCESS) references BPEL_PROCESS; -alter table BPEL_MESSAGE_EXCHANGE add constraint FKBDA6BD05FF451031 foreign key (RESPONSE) references BPEL_MESSAGE; -alter table BPEL_MESSAGE_EXCHANGE add constraint FKBDA6BD0554DCEE7F foreign key (REQUEST) references BPEL_MESSAGE; -alter table BPEL_MEX_PROPS add constraint FK203CAFC7CA00A413 foreign key (MEX) references BPEL_MESSAGE_EXCHANGE; -alter table BPEL_PLINK_VAL add constraint FK7D71E742F2BC5EB8 foreign key (MYROLE_EPR) references LARGE_DATA; -alter table BPEL_PLINK_VAL add constraint FK7D71E74290D95ED1 foreign key (SCOPE) references BPEL_SCOPE; -alter table BPEL_PLINK_VAL add constraint FK7D71E742B5BD38C7 foreign key (PROCESS) references BPEL_PROCESS; -alter table BPEL_PLINK_VAL add constraint FK7D71E742D4B651D4 foreign key (PARTNERROLE_EPR) references LARGE_DATA; -alter table BPEL_SCOPE add constraint FKAB2A32EAA821BBE1 foreign key (PIID) references BPEL_INSTANCE; -alter table BPEL_SCOPE add constraint FKAB2A32EA42B20B58 foreign key (PARENT_SCOPE_ID) references BPEL_SCOPE; -create index IDX_SELECTOR_CORRELATOR on BPEL_SELECTORS (CORRELATOR); -create index IDX_SELECTOR_CKEY on BPEL_SELECTORS (CORRELATION_KEY); -create index IDX_SELECTOR_SELGRPID on BPEL_SELECTORS (SELGRPID); -alter table BPEL_SELECTORS add constraint FKF1F83A0AA821BBE1 foreign key (PIID) references BPEL_INSTANCE; -alter table BPEL_SELECTORS add constraint FKF1F83A0A875201C9 foreign key (CORRELATOR) references BPEL_CORRELATOR; -create index IDX_UNMATCHED_CKEY on BPEL_UNMATCHED (CORRELATION_KEY); -create index IDX_UNMATCHED_CORRELATOR on BPEL_UNMATCHED (CORRELATOR); -alter table BPEL_UNMATCHED add constraint FKF0663E01CA00A413 foreign key (MEX) references BPEL_MESSAGE_EXCHANGE; -alter table BPEL_UNMATCHED add constraint FKF0663E01875201C9 foreign key (CORRELATOR) references BPEL_CORRELATOR; -alter table BPEL_XML_DATA add constraint FKB7D47E7C14020712 foreign key (LDATA_ID) references LARGE_DATA; -alter table BPEL_XML_DATA add constraint FKB7D47E7CA821BBE1 foreign key (PIID) references BPEL_INSTANCE; -alter table BPEL_XML_DATA add constraint FKB7D47E7C6D49C363 foreign key (SCOPE_ID) references BPEL_SCOPE; -alter table VAR_PROPERTY add constraint FK9C1E2C0DA48E25F2 foreign key (XML_DATA_ID) references BPEL_XML_DATA; Deleted: trunk/runtime/engine-assembly/resources/bpel-sql/bpel.mysql.sql =================================================================== --- trunk/runtime/engine-assembly/resources/bpel-sql/bpel.mysql.sql 2009-10-12 10:26:47 UTC (rev 169) +++ trunk/runtime/engine-assembly/resources/bpel-sql/bpel.mysql.sql 2009-10-12 12:21:55 UTC (rev 170) @@ -1,48 +0,0 @@ --- Apache ODE - SimpleScheduler Database Schema --- --- MySQL scripts by Maciej Szefler. --- --- -DROP TABLE IF EXISTS ODE_JOB; - -CREATE TABLE ODE_JOB ( - jobid CHAR(64) NOT NULL DEFAULT '', - ts BIGINT NOT NULL DEFAULT 0, - nodeid char(64) NULL, - scheduled int NOT NULL DEFAULT 0, - transacted int NOT NULL DEFAULT 0, - details blob(4096) NULL, - PRIMARY KEY(jobid), - INDEX IDX_ODE_JOB_TS(ts), - INDEX IDX_ODE_JOB_NODEID(nodeid) -) -TYPE=InnoDB; - -COMMIT; - -create table BPEL_ACTIVITY_RECOVERY (ID bigint not null auto_increment, PIID bigint, AID bigint, CHANNEL varchar(255), REASON varchar(255), DATE_TIME datetime, LDATA_ID bigint, ACTIONS varchar(255), RETRIES integer, INSERT_TIME datetime, MLOCK integer not null, primary key (ID)); -create table BPEL_CORRELATION_PROP (ID bigint not null auto_increment, NAME varchar(255), NAMESPACE varchar(255), VALUE varchar(255), CORR_SET_ID bigint, INSERT_TIME datetime, MLOCK integer not null, primary key (ID)); -create table BPEL_CORRELATION_SET (ID bigint not null auto_increment, VALUE varchar(255), CORR_SET_NAME varchar(255), SCOPE_ID bigint, PIID bigint, PROCESS_ID bigint, INSERT_TIME datetime, MLOCK integer not null, primary key (ID)); -create table BPEL_CORRELATOR (ID bigint not null auto_increment, CID varchar(255), PROCESS_ID bigint, INSERT_TIME datetime, MLOCK integer not null, primary key (ID)); -create table BPEL_CORRELATOR_MESSAGE_CKEY (ID bigint not null auto_increment, CKEY varchar(255), CORRELATOR_MESSAGE_ID bigint, INSERT_TIME datetime, MLOCK integer not null, primary key (ID)); -create table BPEL_EVENT (ID bigint not null auto_increment, IID bigint, PID bigint, TSTAMP datetime, TYPE varchar(255), DETAIL text, LDATA_ID bigint, SID bigint, INSERT_TIME datetime, MLOCK integer not null, primary key (ID)); -create table BPEL_FAULT (ID bigint not null auto_increment, FAULTNAME varchar(255), LDATA_ID bigint, EXPLANATION varchar(4000), LINE_NUM integer, AID integer, INSERT_TIME datetime, MLOCK integer not null, primary key (ID)); -create table BPEL_INSTANCE (ID bigint not null auto_increment, INSTANTIATING_CORRELATOR bigint, FAULT bigint, JACOB_STATE bigint, PREVIOUS_STATE smallint, PROCESS_ID bigint, STATE smallint, LAST_ACTIVE_DT datetime, SEQUENCE bigint, FAILURE_COUNT integer, FAILURE_DT datetime, EXEC_STATE_COUNT integer, INSERT_TIME datetime, MLOCK integer not null, primary key (ID)); -create table BPEL_MESSAGE (ID bigint not null auto_increment, TYPE varchar(255), DATA bigint, HEADER bigint, INSERT_TIME datetime, MLOCK integer not null, primary key (ID)); -create table BPEL_MESSAGE_EXCHANGE (ID bigint not null auto_increment, MEXID varchar(255) not null unique, PORT_TYPE varchar(255), CHANNEL_NAME varchar(255), CLIENTKEY varchar(255), LDATA_EPR_ID bigint, LDATA_CEPR_ID bigint, REQUEST bigint, RESPONSE bigint, INSERT_DT datetime, OPERATION varchar(255), STATE varchar(255), PROCESS bigint, PIID bigint, DIR char(1), PLINK_MODELID integer, PATTERN varchar(255), CORR_STATUS varchar(255), FAULT_TYPE varchar(255), FAULT_EXPL varchar(255), CALLEE varchar(255), PARTNERLINK bigint, TIMEOUT bigint, ISTYLE varchar(255), P2P_PEER varchar(255), FAILURE_TYPE varchar(255), ACK_TYPE varchar(255), PIPED_PID varchar(255), INSERT_TIME datetime, MLOCK integer not null, primary key (ID)); -create table BPEL_MEX_PROPS (MEX bigint not null, VALUE varchar(8000), NAME varchar(255) not null, primary key (MEX, NAME)); -create table BPEL_PLINK_VAL (ID bigint not null auto_increment, PARTNER_LINK varchar(100) not null, PARTNERROLE varchar(100), MYROLE_EPR bigint, PARTNERROLE_EPR bigint, PROCESS bigint, SCOPE bigint, SVCNAME varchar(255), MYROLE varchar(100), MODELID integer, MYSESSIONID varchar(255), PARTNERSESSIONID varchar(255), INSERT_TIME datetime, MLOCK integer not null, primary key (ID)); -create table BPEL_PROCESS (ID bigint not null auto_increment, PROCID varchar(255) not null unique, deployer varchar(255), deploydate datetime, type_name varchar(255), type_ns varchar(255), version bigint, ACTIVE_ bit, guid varchar(255), INSERT_TIME datetime, MLOCK integer not null, primary key (ID)); -create table BPEL_SCOPE (ID bigint not null auto_increment, PIID bigint, PARENT_SCOPE_ID bigint, STATE varchar(255) not null, NAME varchar(255) not null, MODELID integer, INSERT_TIME datetime, MLOCK integer not null, primary key (ID)); -create table BPEL_SELECTORS (ID bigint not null auto_increment, PIID bigint not null, SELGRPID varchar(255) not null, IDX integer not null, CORRELATION_KEY varchar(255) not null, PROC_TYPE varchar(255) not null, CORRELATOR bigint not null, INSERT_TIME datetime, MLOCK integer not null, primary key (ID), unique (CORRELATION_KEY, CORRELATOR)); -create table BPEL_UNMATCHED (ID bigint not null auto_increment, MEX bigint, CORRELATION_KEY varchar(255), CORRELATOR bigint not null, INSERT_TIME datetime, MLOCK integer not null, primary key (ID)); -create table BPEL_XML_DATA (ID bigint not null auto_increment, LDATA_ID bigint, NAME varchar(255) not null, SCOPE_ID bigint, PIID bigint, IS_SIMPLE_TYPE bit, INSERT_TIME datetime, MLOCK integer not null, primary key (ID)); -create table LARGE_DATA (ID bigint not null auto_increment, BIN_DATA blob, INSERT_TIME datetime, MLOCK integer not null, primary key (ID)); -create table VAR_PROPERTY (ID bigint not null auto_increment, XML_DATA_ID bigint, PROP_VALUE varchar(255), PROP_NAME varchar(255) not null, INSERT_TIME datetime, MLOCK integer not null, primary key (ID)); -create index IDX_CORRELATOR_CID on BPEL_CORRELATOR (CID); -create index IDX_BPEL_CORRELATOR_MESSAGE_CKEY on BPEL_CORRELATOR_MESSAGE_CKEY (CKEY); -create index IDX_SELECTOR_CORRELATOR on BPEL_SELECTORS (CORRELATOR); -create index IDX_SELECTOR_CKEY on BPEL_SELECTORS (CORRELATION_KEY); -create index IDX_SELECTOR_SELGRPID on BPEL_SELECTORS (SELGRPID); -create index IDX_UNMATCHED_CKEY on BPEL_UNMATCHED (CORRELATION_KEY); -create index IDX_UNMATCHED_CORRELATOR on BPEL_UNMATCHED (CORRELATOR); Deleted: trunk/runtime/engine-assembly/resources/bpel-sql/bpel.oracle.sql =================================================================== --- trunk/runtime/engine-assembly/resources/bpel-sql/bpel.oracle.sql 2009-10-12 10:26:47 UTC (rev 169) +++ trunk/runtime/engine-assembly/resources/bpel-sql/bpel.oracle.sql 2009-10-12 12:21:55 UTC (rev 170) @@ -1,46 +0,0 @@ --- Apache ODE - SimpleScheduler Database Schema --- --- Apache Derby scripts by Maciej Szefler. --- --- - -CREATE TABLE ode_job ( - jobid CHAR(64) NOT NULL DEFAULT '', - ts BIGINT NOT NULL DEFAULT 0, - nodeid char(64), - scheduled int NOT NULL DEFAULT 0, - transacted int NOT NULL DEFAULT 0, - details blob(4096), - PRIMARY KEY(jobid)); - -CREATE INDEX IDX_ODE_JOB_TS ON ode_job(ts); -CREATE INDEX IDX_ODE_JOB_NODEID ON ode_job(nodeid); - - -create table BPEL_ACTIVITY_RECOVERY (ID number(19,0) not null, PIID number(19,0), AID number(19,0), CHANNEL varchar2(255 char), REASON varchar2(255 char), DATE_TIME timestamp, LDATA_ID number(19,0), ACTIONS varchar2(255 char), RETRIES number(10,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); -create table BPEL_CORRELATION_PROP (ID number(19,0) not null, NAME varchar2(255 char), NAMESPACE varchar2(255 char), VALUE varchar2(255 char), CORR_SET_ID number(19,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); -create table BPEL_CORRELATION_SET (ID number(19,0) not null, VALUE varchar2(255 char), CORR_SET_NAME varchar2(255 char), SCOPE_ID number(19,0), PIID number(19,0), PROCESS_ID number(19,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); -create table BPEL_CORRELATOR (ID number(19,0) not null, CID varchar2(255 char), PROCESS_ID number(19,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); -create table BPEL_CORRELATOR_MESSAGE_CKEY (ID number(19,0) not null, CKEY varchar2(255 char), CORRELATOR_MESSAGE_ID number(19,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); -create table BPEL_EVENT (ID number(19,0) not null, IID number(19,0), PID number(19,0), TSTAMP timestamp, TYPE varchar2(255 char), DETAIL clob, LDATA_ID number(19,0), SID number(19,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); -create table BPEL_FAULT (ID number(19,0) not null, FAULTNAME varchar2(255 char), LDATA_ID number(19,0), EXPLANATION varchar2(4000 char), LINE_NUM number(10,0), AID number(10,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); -create table BPEL_INSTANCE (ID number(19,0) not null, INSTANTIATING_CORRELATOR number(19,0), FAULT number(19,0), JACOB_STATE number(19,0), PREVIOUS_STATE number(5,0), PROCESS_ID number(19,0), STATE number(5,0), LAST_ACTIVE_DT timestamp, SEQUENCE number(19,0), FAILURE_COUNT number(10,0), FAILURE_DT timestamp, EXEC_STATE_COUNT number(10,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); -create table BPEL_MESSAGE (ID number(19,0) not null, TYPE varchar2(255 char), DATA number(19,0), HEADER number(19,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); -create table BPEL_MESSAGE_EXCHANGE (ID number(19,0) not null, MEXID varchar2(255 char) not null unique, PORT_TYPE varchar2(255 char), CHANNEL_NAME varchar2(255 char), CLIENTKEY varchar2(255 char), LDATA_EPR_ID number(19,0), LDATA_CEPR_ID number(19,0), REQUEST number(19,0), RESPONSE number(19,0), INSERT_DT timestamp, OPERATION varchar2(255 char), STATE varchar2(255 char), PROCESS number(19,0), PIID number(19,0), DIR char(1 char), PLINK_MODELID number(10,0), PATTERN varchar2(255 char), CORR_STATUS varchar2(255 char), FAULT_TYPE varchar2(255 char), FAULT_EXPL varchar2(255 char), CALLEE varchar2(255 char), PARTNERLINK number(19,0), TIMEOUT number(19,0), ISTYLE varchar2(255 char), P2P_PEER varchar2(255 char), FAILURE_TYPE varchar2(255 char), ACK_TYPE varchar2(255 char), PIPED_PID varchar2(255 char), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); -create table BPEL_MEX_PROPS (MEX number(19,0) not null, VALUE long, NAME varchar2(255 char) not null, primary key (MEX, NAME)); -create table BPEL_PLINK_VAL (ID number(19,0) not null, PARTNER_LINK varchar2(100 char) not null, PARTNERROLE varchar2(100 char), MYROLE_EPR number(19,0), PARTNERROLE_EPR number(19,0), PROCESS number(19,0), SCOPE number(19,0), SVCNAME varchar2(255 char), MYROLE varchar2(100 char), MODELID number(10,0), MYSESSIONID varchar2(255 char), PARTNERSESSIONID varchar2(255 char), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); -create table BPEL_PROCESS (ID number(19,0) not null, PROCID varchar2(255 char) not null unique, deployer varchar2(255 char), deploydate timestamp, type_name varchar2(255 char), type_ns varchar2(255 char), version number(19,0), ACTIVE_ number(1,0), guid varchar2(255 char), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); -create table BPEL_SCOPE (ID number(19,0) not null, PIID number(19,0), PARENT_SCOPE_ID number(19,0), STATE varchar2(255 char) not null, NAME varchar2(255 char) not null, MODELID number(10,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); -create table BPEL_SELECTORS (ID number(19,0) not null, PIID number(19,0) not null, SELGRPID varchar2(255 char) not null, IDX number(10,0) not null, CORRELATION_KEY varchar2(255 char) not null, PROC_TYPE varchar2(255 char) not null, CORRELATOR number(19,0) not null, INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID), unique (CORRELATION_KEY, CORRELATOR)); -create table BPEL_UNMATCHED (ID number(19,0) not null, MEX number(19,0), CORRELATION_KEY varchar2(255 char), CORRELATOR number(19,0) not null, INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); -create table BPEL_XML_DATA (ID number(19,0) not null, LDATA_ID number(19,0), NAME varchar2(255 char) not null, SCOPE_ID number(19,0), PIID number(19,0), IS_SIMPLE_TYPE number(1,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); -create table LARGE_DATA (ID number(19,0) not null, BIN_DATA blob(2G), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); -create table VAR_PROPERTY (ID number(19,0) not null, XML_DATA_ID number(19,0), PROP_VALUE varchar2(255 char), PROP_NAME varchar2(255 char) not null, INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); -create index IDX_CORRELATOR_CID on BPEL_CORRELATOR (CID); -create index IDX_BPEL_CORRELATOR_MESSAGE_CKEY on BPEL_CORRELATOR_MESSAGE_CKEY (CKEY); -create index IDX_SELECTOR_CORRELATOR on BPEL_SELECTORS (CORRELATOR); -create index IDX_SELECTOR_CKEY on BPEL_SELECTORS (CORRELATION_KEY); -create index IDX_SELECTOR_SELGRPID on BPEL_SELECTORS (SELGRPID); -create index IDX_UNMATCHED_CKEY on BPEL_UNMATCHED (CORRELATION_KEY); -create index IDX_UNMATCHED_CORRELATOR on BPEL_UNMATCHED (CORRELATOR); -create sequence hibernate_sequence; Deleted: trunk/runtime/engine-assembly/resources/bpel-sql/bpel.postgres.sql =================================================================== --- trunk/runtime/engine-assembly/resources/bpel-sql/bpel.postgres.sql 2009-10-12 10:26:47 UTC (rev 169) +++ trunk/runtime/engine-assembly/resources/bpel-sql/bpel.postgres.sql 2009-10-12 12:21:55 UTC (rev 170) @@ -1,46 +0,0 @@ --- Apache ODE - SimpleScheduler Database Schema --- --- Apache Derby scripts by Maciej Szefler. --- --- - -CREATE TABLE ode_job ( - jobid CHAR(64) NOT NULL DEFAULT '', - ts BIGINT NOT NULL DEFAULT 0, - nodeid char(64), - scheduled int NOT NULL DEFAULT 0, - transacted int NOT NULL DEFAULT 0, - details blob(4096), - PRIMARY KEY(jobid)); - -CREATE INDEX IDX_ODE_JOB_TS ON ode_job(ts); -CREATE INDEX IDX_ODE_JOB_NODEID ON ode_job(nodeid); - - -create table BPEL_ACTIVITY_RECOVERY (ID int8 not null, PIID int8, AID int8, CHANNEL varchar(255), REASON varchar(255), DATE_TIME timestamp, LDATA_ID int8, ACTIONS varchar(255), RETRIES int4, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); -create table BPEL_CORRELATION_PROP (ID int8 not null, NAME varchar(255), NAMESPACE varchar(255), VALUE varchar(255), CORR_SET_ID int8, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); -create table BPEL_CORRELATION_SET (ID int8 not null, VALUE varchar(255), CORR_SET_NAME varchar(255), SCOPE_ID int8, PIID int8, PROCESS_ID int8, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); -create table BPEL_CORRELATOR (ID int8 not null, CID varchar(255), PROCESS_ID int8, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); -create table BPEL_CORRELATOR_MESSAGE_CKEY (ID int8 not null, CKEY varchar(255), CORRELATOR_MESSAGE_ID int8, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); -create table BPEL_EVENT (ID int8 not null, IID int8, PID int8, TSTAMP timestamp, TYPE varchar(255), DETAIL text, LDATA_ID int8, SID int8, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); -create table BPEL_FAULT (ID int8 not null, FAULTNAME varchar(255), LDATA_ID int8, EXPLANATION varchar(4000), LINE_NUM int4, AID int4, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); -create table BPEL_INSTANCE (ID int8 not null, INSTANTIATING_CORRELATOR int8, FAULT int8, JACOB_STATE int8, PREVIOUS_STATE int2, PROCESS_ID int8, STATE int2, LAST_ACTIVE_DT timestamp, SEQUENCE int8, FAILURE_COUNT int4, FAILURE_DT timestamp, EXEC_STATE_COUNT int4, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); -create table BPEL_MESSAGE (ID int8 not null, TYPE varchar(255), DATA int8, HEADER int8, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); -create table BPEL_MESSAGE_EXCHANGE (ID int8 not null, MEXID varchar(255) not null unique, PORT_TYPE varchar(255), CHANNEL_NAME varchar(255), CLIENTKEY varchar(255), LDATA_EPR_ID int8, LDATA_CEPR_ID int8, REQUEST int8, RESPONSE int8, INSERT_DT timestamp, OPERATION varchar(255), STATE varchar(255), PROCESS int8, PIID int8, DIR char(1), PLINK_MODELID int4, PATTERN varchar(255), CORR_STATUS varchar(255), FAULT_TYPE varchar(255), FAULT_EXPL varchar(255), CALLEE varchar(255), PARTNERLINK int8, TIMEOUT int8, ISTYLE varchar(255), P2P_PEER varchar(255), FAILURE_TYPE varchar(255), ACK_TYPE varchar(255), PIPED_PID varchar(255), INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); -create table BPEL_MEX_PROPS (MEX int8 not null, VALUE varchar(8000), NAME varchar(255) not null, primary key (MEX, NAME)); -create table BPEL_PLINK_VAL (ID int8 not null, PARTNER_LINK varchar(100) not null, PARTNERROLE varchar(100), MYROLE_EPR int8, PARTNERROLE_EPR int8, PROCESS int8, SCOPE int8, SVCNAME varchar(255), MYROLE varchar(100), MODELID int4, MYSESSIONID varchar(255), PARTNERSESSIONID varchar(255), INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); -create table BPEL_PROCESS (ID int8 not null, PROCID varchar(255) not null unique, deployer varchar(255), deploydate timestamp, type_name varchar(255), type_ns varchar(255), version int8, ACTIVE_ bool, guid varchar(255), INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); -create table BPEL_SCOPE (ID int8 not null, PIID int8, PARENT_SCOPE_ID int8, STATE varchar(255) not null, NAME varchar(255) not null, MODELID int4, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); -create table BPEL_SELECTORS (ID int8 not null, PIID int8 not null, SELGRPID varchar(255) not null, IDX int4 not null, CORRELATION_KEY varchar(255) not null, PROC_TYPE varchar(255) not null, CORRELATOR int8 not null, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID), unique (CORRELATION_KEY, CORRELATOR)); -create table BPEL_UNMATCHED (ID int8 not null, MEX int8, CORRELATION_KEY varchar(255), CORRELATOR int8 not null, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); -create table BPEL_XML_DATA (ID int8 not null, LDATA_ID int8, NAME varchar(255) not null, SCOPE_ID int8, PIID int8, IS_SIMPLE_TYPE bool, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); -create table LARGE_DATA (ID int8 not null, BIN_DATA blob(2G), INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); -create table VAR_PROPERTY (ID int8 not null, XML_DATA_ID int8, PROP_VALUE varchar(255), PROP_NAME varchar(255) not null, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); -create index IDX_CORRELATOR_CID on BPEL_CORRELATOR (CID); -create index IDX_BPEL_CORRELATOR_MESSAGE_CKEY on BPEL_CORRELATOR_MESSAGE_CKEY (CKEY); -create index IDX_SELECTOR_CORRELATOR on BPEL_SELECTORS (CORRELATOR); -create index IDX_SELECTOR_CKEY on BPEL_SELECTORS (CORRELATION_KEY); -create index IDX_SELECTOR_SELGRPID on BPEL_SELECTORS (SELGRPID); -create index IDX_UNMATCHED_CKEY on BPEL_UNMATCHED (CORRELATION_KEY); -create index IDX_UNMATCHED_CORRELATOR on BPEL_UNMATCHED (CORRELATOR); -create sequence hibernate_sequence; Deleted: trunk/runtime/engine-assembly/resources/bpel-sql/bpel.sqlserver.sql =================================================================== --- trunk/runtime/engine-assembly/resources/bpel-sql/bpel.sqlserver.sql 2009-10-12 10:26:47 UTC (rev 169) +++ trunk/runtime/engine-assembly/resources/bpel-sql/bpel.sqlserver.sql 2009-10-12 12:21:55 UTC (rev 170) @@ -1,45 +0,0 @@ --- Apache ODE - SimpleScheduler Database Schema --- --- Apache Derby scripts by Maciej Szefler. --- --- - -CREATE TABLE ode_job ( - jobid CHAR(64) NOT NULL DEFAULT '', - ts BIGINT NOT NULL DEFAULT 0, - nodeid char(64), - scheduled int NOT NULL DEFAULT 0, - transacted int NOT NULL DEFAULT 0, - details blob(4096), - PRIMARY KEY(jobid)); - -CREATE INDEX IDX_ODE_JOB_TS ON ode_job(ts); -CREATE INDEX IDX_ODE_JOB_NODEID ON ode_job(nodeid); - - -create table BPEL_ACTIVITY_RECOVERY (ID numeric(19,0) identity not null, PIID numeric(19,0) null, AID numeric(19,0) null, CHANNEL varchar(255) null, REASON varchar(255) null, DATE_TIME datetime null, LDATA_ID numeric(19,0) null, ACTIONS varchar(255) null, RETRIES int null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); -create table BPEL_CORRELATION_PROP (ID numeric(19,0) identity not null, NAME varchar(255) null, NAMESPACE varchar(255) null, VALUE varchar(255) null, CORR_SET_ID numeric(19,0) null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); -create table BPEL_CORRELATION_SET (ID numeric(19,0) identity not null, VALUE varchar(255) null, CORR_SET_NAME varchar(255) null, SCOPE_ID numeric(19,0) null, PIID numeric(19,0) null, PROCESS_ID numeric(19,0) null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); -create table BPEL_CORRELATOR (ID numeric(19,0) identity not null, CID varchar(255) null, PROCESS_ID numeric(19,0) null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); -create table BPEL_CORRELATOR_MESSAGE_CKEY (ID numeric(19,0) identity not null, CKEY varchar(255) null, CORRELATOR_MESSAGE_ID numeric(19,0) null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); -create table BPEL_EVENT (ID numeric(19,0) identity not null, IID numeric(19,0) null, PID numeric(19,0) null, TSTAMP datetime null, TYPE varchar(255) null, DETAIL text null, LDATA_ID numeric(19,0) null, SID numeric(19,0) null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); -create table BPEL_FAULT (ID numeric(19,0) identity not null, FAULTNAME varchar(255) null, LDATA_ID numeric(19,0) null, EXPLANATION varchar(4000) null, LINE_NUM int null, AID int null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); -create table BPEL_INSTANCE (ID numeric(19,0) identity not null, INSTANTIATING_CORRELATOR numeric(19,0) null, FAULT numeric(19,0) null, JACOB_STATE numeric(19,0) null, PREVIOUS_STATE smallint null, PROCESS_ID numeric(19,0) null, STATE smallint null, LAST_ACTIVE_DT datetime null, SEQUENCE numeric(19,0) null, FAILURE_COUNT int null, FAILURE_DT datetime null, EXEC_STATE_COUNT int null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); -create table BPEL_MESSAGE (ID numeric(19,0) identity not null, TYPE varchar(255) null, DATA numeric(19,0) null, HEADER numeric(19,0) null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); -create table BPEL_MESSAGE_EXCHANGE (ID numeric(19,0) identity not null, MEXID varchar(255) not null unique, PORT_TYPE varchar(255) null, CHANNEL_NAME varchar(255) null, CLIENTKEY varchar(255) null, LDATA_EPR_ID numeric(19,0) null, LDATA_CEPR_ID numeric(19,0) null, REQUEST numeric(19,0) null, RESPONSE numeric(19,0) null, INSERT_DT datetime null, OPERATION varchar(255) null, STATE varchar(255) null, PROCESS numeric(19,0) null, PIID numeric(19,0) null, DIR char(1) null, PLINK_MODELID int null, PATTERN varchar(255) null, CORR_STATUS varchar(255) null, FAULT_TYPE varchar(255) null, FAULT_EXPL varchar(255) null, CALLEE varchar(255) null, PARTNERLINK numeric(19,0) null, TIMEOUT numeric(19,0) null, ISTYLE varchar(255) null, P2P_PEER varchar(255) null, FAILURE_TYPE varchar(255) null, ACK_TYPE varchar(255) null, PIPED_PID varchar(255) null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); -create table BPEL_MEX_PROPS (MEX numeric(19,0) not null, VALUE varchar(8000) null, NAME varchar(255) not null, primary key (MEX, NAME)); -create table BPEL_PLINK_VAL (ID numeric(19,0) identity not null, PARTNER_LINK varchar(100) not null, PARTNERROLE varchar(100) null, MYROLE_EPR numeric(19,0) null, PARTNERROLE_EPR numeric(19,0) null, PROCESS numeric(19,0) null, SCOPE numeric(19,0) null, SVCNAME varchar(255) null, MYROLE varchar(100) null, MODELID int null, MYSESSIONID varchar(255) null, PARTNERSESSIONID varchar(255) null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); -create table BPEL_PROCESS (ID numeric(19,0) identity not null, PROCID varchar(255) not null unique, deployer varchar(255) null, deploydate datetime null, type_name varchar(255) null, type_ns varchar(255) null, version numeric(19,0) null, ACTIVE_ tinyint null, guid varchar(255) null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); -create table BPEL_SCOPE (ID numeric(19,0) identity not null, PIID numeric(19,0) null, PARENT_SCOPE_ID numeric(19,0) null, STATE varchar(255) not null, NAME varchar(255) not null, MODELID int null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); -create table BPEL_SELECTORS (ID numeric(19,0) identity not null, PIID numeric(19,0) not null, SELGRPID varchar(255) not null, IDX int not null, CORRELATION_KEY varchar(255) not null, PROC_TYPE varchar(255) not null, CORRELATOR numeric(19,0) not null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID), unique (CORRELATION_KEY, CORRELATOR)); -create table BPEL_UNMATCHED (ID numeric(19,0) identity not null, MEX numeric(19,0) null, CORRELATION_KEY varchar(255) null, CORRELATOR numeric(19,0) not null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); -create table BPEL_XML_DATA (ID numeric(19,0) identity not null, LDATA_ID numeric(19,0) null, NAME varchar(255) not null, SCOPE_ID numeric(19,0) null, PIID numeric(19,0) null, IS_SIMPLE_TYPE tinyint null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); -create table LARGE_DATA (ID numeric(19,0) identity not null, BIN_DATA blob(2G) null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); -create table VAR_PROPERTY (ID numeric(19,0) identity not null, XML_DATA_ID numeric(19,0) null, PROP_VALUE varchar(255) null, PROP_NAME varchar(255) not null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); -create index IDX_CORRELATOR_CID on BPEL_CORRELATOR (CID); -create index IDX_BPEL_CORRELATOR_MESSAGE_CKEY on BPEL_CORRELATOR_MESSAGE_CKEY (CKEY); -create index IDX_SELECTOR_CORRELATOR on BPEL_SELECTORS (CORRELATOR); -create index IDX_SELECTOR_CKEY on BPEL_SELECTORS (CORRELATION_KEY); -create index IDX_SELECTOR_SELGRPID on BPEL_SELECTORS (SELGRPID); -create index IDX_UNMATCHED_CKEY on BPEL_UNMATCHED (CORRELATION_KEY); -create index IDX_UNMATCHED_CORRELATOR on BPEL_UNMATCHED (CORRELATOR); Deleted: trunk/runtime/engine-assembly/resources/bpel-sql/hsql.sql-ORIGINAL =================================================================== --- trunk/runtime/engine-assembly/resources/bpel-sql/hsql.sql-ORIGINAL 2009-10-12 10:26:47 UTC (rev 169) +++ trunk/runtime/engine-assembly/resources/bpel-sql/hsql.sql-ORIGINAL 2009-10-12 12:21:55 UTC (rev 170) @@ -1,85 +0,0 @@ --- Apache ODE - SimpleScheduler Database Schema --- --- Apache Derby scripts by Maciej Szefler. --- --- - -CREATE TABLE ode_job ( - jobid CHAR(64) NOT NULL DEFAULT '', - ts BIGINT NOT NULL DEFAULT 0, - nodeid char(64), - scheduled int NOT NULL DEFAULT 0, - transacted int NOT NULL DEFAULT 0, - details blob(4096), - PRIMARY KEY(jobid)); - -CREATE INDEX IDX_ODE_JOB_TS ON ode_job(ts); -CREATE INDEX IDX_ODE_JOB_NODEID ON ode_job(nodeid); - - -create table BPEL_ACTIVITY_RECOVERY (ID bigint generated by default as identity (start with 1), PIID bigint, AID bigint, CHANNEL varchar(255), REASON varchar(255), DATE_TIME timestamp, LDATA_ID bigint, ACTIONS varchar(255), RETRIES integer, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table BPEL_CORRELATION_PROP (ID bigint generated by default as identity (start with 1), NAME varchar(255), NAMESPACE varchar(255), VALUE varchar(255), CORR_SET_ID bigint, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table BPEL_CORRELATION_SET (ID bigint generated by default as identity (start with 1), VALUE varchar(255), CORR_SET_NAME varchar(255), SCOPE_ID bigint, PIID bigint, PROCESS_ID bigint, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table BPEL_CORRELATOR (ID bigint generated by default as identity (start with 1), CID varchar(255), PROCESS_ID bigint, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table BPEL_CORRELATOR_MESSAGE_CKEY (ID bigint generated by default as identity (start with 1), CKEY varchar(255), CORRELATOR_MESSAGE_ID bigint, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table BPEL_EVENT (ID bigint generated by default as identity (start with 1), IID bigint, PID bigint, TSTAMP timestamp, TYPE varchar(255), DETAIL longvarchar, LDATA_ID bigint, SID bigint, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table BPEL_FAULT (ID bigint generated by default as identity (start with 1), FAULTNAME varchar(255), LDATA_ID bigint, EXPLANATION varchar(4000), LINE_NUM integer, AID integer, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table BPEL_INSTANCE (ID bigint generated by default as identity (start with 1), INSTANTIATING_CORRELATOR bigint, FAULT bigint, JACOB_STATE bigint, PREVIOUS_STATE smallint, PROCESS_ID bigint, STATE smallint, LAST_ACTIVE_DT timestamp, SEQUENCE bigint, FAILURE_COUNT integer, FAILURE_DT timestamp, EXEC_STATE_COUNT integer, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table BPEL_MESSAGE (ID bigint generated by default as identity (start with 1), TYPE varchar(255), DATA bigint, HEADER bigint, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table BPEL_MESSAGE_EXCHANGE (ID bigint generated by default as identity (start with 1), MEXID varchar(255) not null, PORT_TYPE varchar(255), CHANNEL_NAME varchar(255), CLIENTKEY varchar(255), LDATA_EPR_ID bigint, LDATA_CEPR_ID bigint, REQUEST bigint, RESPONSE bigint, INSERT_DT timestamp, OPERATION varchar(255), STATE varchar(255), PROCESS bigint, PIID bigint, DIR char(1), PLINK_MODELID integer, PATTERN varchar(255), CORR_STATUS varchar(255), FAULT_TYPE varchar(255), FAULT_EXPL varchar(255), CALLEE varchar(255), PARTNERLINK bigint, TIMEOUT bigint, ISTYLE varchar(255), P2P_PEER varchar(255), FAILURE_TYPE varchar(255), ACK_TYPE varchar(255), PIPED_PID varchar(255), INSERT_TIME timestamp, MLOCK integer not null, primary key (ID), unique (MEXID)); -create table BPEL_MEX_PROPS (MEX bigint not null, VALUE varchar(8000), NAME varchar(255) not null, primary key (MEX, NAME)); -create table BPEL_PLINK_VAL (ID bigint generated by default as identity (start with 1), PARTNER_LINK varchar(100) not null, PARTNERROLE varchar(100), MYROLE_EPR bigint, PARTNERROLE_EPR bigint, PROCESS bigint, SCOPE bigint, SVCNAME varchar(255), MYROLE varchar(100), MODELID integer, MYSESSIONID varchar(255), PARTNERSESSIONID varchar(255), INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table BPEL_PROCESS (ID bigint generated by default as identity (start with 1), PROCID varchar(255) not null, deployer varchar(255), deploydate timestamp, type_name varchar(255), type_ns varchar(255), version bigint, ACTIVE_ bit, guid varchar(255), INSERT_TIME timestamp, MLOCK integer not null, primary key (ID), unique (PROCID)); -create table BPEL_SCOPE (ID bigint generated by default as identity (start with 1), PIID bigint, PARENT_SCOPE_ID bigint, STATE varchar(255) not null, NAME varchar(255) not null, MODELID integer, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table BPEL_SELECTORS (ID bigint generated by default as identity (start with 1), PIID bigint not null, SELGRPID varchar(255) not null, IDX integer not null, CORRELATION_KEY varchar(255) not null, PROC_TYPE varchar(255) not null, CORRELATOR bigint not null, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID), unique (CORRELATION_KEY, CORRELATOR)); -create table BPEL_UNMATCHED (ID bigint generated by default as identity (start with 1), MEX bigint, CORRELATION_KEY varchar(255), CORRELATOR bigint not null, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table BPEL_XML_DATA (ID bigint generated by default as identity (start with 1), LDATA_ID bigint, NAME varchar(255) not null, SCOPE_ID bigint, PIID bigint, IS_SIMPLE_TYPE bit, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table LARGE_DATA (ID bigint generated by default as identity (start with 1), BIN_DATA blob(2G), INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table VAR_PROPERTY (ID bigint generated by default as identity (start with 1), XML_DATA_ID bigint, PROP_VALUE varchar(255), PROP_NAME varchar(255) not null, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -alter table BPEL_ACTIVITY_RECOVERY add constraint FK94D24A7B14020712 foreign key (LDATA_ID) references LARGE_DATA; -alter table BPEL_ACTIVITY_RECOVERY add constraint FK94D24A7BA821BBE1 foreign key (PIID) references BPEL_INSTANCE; -alter table BPEL_CORRELATION_PROP add constraint FK4EC9DDAA4D0B7982 foreign key (CORR_SET_ID) references BPEL_CORRELATION_SET; -alter table BPEL_CORRELATION_SET add constraint FKB838191BA821BBE1 foreign key (PIID) references BPEL_INSTANCE; -alter table BPEL_CORRELATION_SET add constraint FKB838191B6D49C363 foreign key (SCOPE_ID) references BPEL_SCOPE; -alter table BPEL_CORRELATION_SET add constraint FKB838191BE15A2343 foreign key (PROCESS_ID) references BPEL_PROCESS; -create index IDX_CORRELATOR_CID on BPEL_CORRELATOR (CID); -alter table BPEL_CORRELATOR add constraint FKF50EFA33E15A2343 foreign key (PROCESS_ID) references BPEL_PROCESS; -create index IDX_BPEL_CORRELATOR_MESSAGE_CKEY on BPEL_CORRELATOR_MESSAGE_CKEY (CKEY); -alter table BPEL_CORRELATOR_MESSAGE_CKEY add constraint FK8997F700EEFA7470 foreign key (CORRELATOR_MESSAGE_ID) references BPEL_UNMATCHED; -alter table BPEL_EVENT add constraint FKAA6D673014020712 foreign key (LDATA_ID) references LARGE_DATA; -alter table BPEL_EVENT add constraint FKAA6D6730A7EED251 foreign key (IID) references BPEL_INSTANCE; -alter table BPEL_EVENT add constraint FKAA6D6730C831CBE3 foreign key (PID) references BPEL_PROCESS; -alter table BPEL_FAULT add constraint FKAA722EB814020712 foreign key (LDATA_ID) references LARGE_DATA; -alter table BPEL_INSTANCE add constraint FKE1DED41FDD43DBE1 foreign key (INSTANTIATING_CORRELATOR) references BPEL_CORRELATOR; -alter table BPEL_INSTANCE add constraint FKE1DED41F6B66C85F foreign key (JACOB_STATE) references LARGE_DATA; -alter table BPEL_INSTANCE add constraint FKE1DED41F1F3C9CB7 foreign key (FAULT) references BPEL_FAULT; -alter table BPEL_INSTANCE add constraint FKE1DED41FE15A2343 foreign key (PROCESS_ID) references BPEL_PROCESS; -alter table BPEL_MESSAGE add constraint FK4FA7231DEB2C9ED8 foreign key (DATA) references LARGE_DATA; -alter table BPEL_MESSAGE add constraint FK4FA7231DA23291BB foreign key (HEADER) references LARGE_DATA; -alter table BPEL_MESSAGE_EXCHANGE add constraint FKBDA6BD0589D7A75B foreign key (LDATA_CEPR_ID) references LARGE_DATA; -alter table BPEL_MESSAGE_EXCHANGE add constraint FKBDA6BD05BBA250D foreign key (PARTNERLINK) references BPEL_PLINK_VAL; -alter table BPEL_MESSAGE_EXCHANGE add constraint FKBDA6BD05A821BBE1 foreign key (PIID) references BPEL_INSTANCE; -alter table BPEL_MESSAGE_EXCHANGE add constraint FKBDA6BD05C29670AA foreign key (LDATA_EPR_ID) references LARGE_DATA; -alter table BPEL_MESSAGE_EXCHANGE add constraint FKBDA6BD05B5BD38C7 foreign key (PROCESS) references BPEL_PROCESS; -alter table BPEL_MESSAGE_EXCHANGE add constraint FKBDA6BD05FF451031 foreign key (RESPONSE) references BPEL_MESSAGE; -alter table BPEL_MESSAGE_EXCHANGE add constraint FKBDA6BD0554DCEE7F foreign key (REQUEST) references BPEL_MESSAGE; -alter table BPEL_MEX_PROPS add constraint FK203CAFC7CA00A413 foreign key (MEX) references BPEL_MESSAGE_EXCHANGE; -alter table BPEL_PLINK_VAL add constraint FK7D71E742F2BC5EB8 foreign key (MYROLE_EPR) references LARGE_DATA; -alter table BPEL_PLINK_VAL add constraint FK7D71E74290D95ED1 foreign key (SCOPE) references BPEL_SCOPE; -alter table BPEL_PLINK_VAL add constraint FK7D71E742B5BD38C7 foreign key (PROCESS) references BPEL_PROCESS; -alter table BPEL_PLINK_VAL add constraint FK7D71E742D4B651D4 foreign key (PARTNERROLE_EPR) references LARGE_DATA; -alter table BPEL_SCOPE add constraint FKAB2A32EAA821BBE1 foreign key (PIID) references BPEL_INSTANCE; -alter table BPEL_SCOPE add constraint FKAB2A32EA42B20B58 foreign key (PARENT_SCOPE_ID) references BPEL_SCOPE; -create index IDX_SELECTOR_CORRELATOR on BPEL_SELECTORS (CORRELATOR); -create index IDX_SELECTOR_CKEY on BPEL_SELECTORS (CORRELATION_KEY); -create index IDX_SELECTOR_SELGRPID on BPEL_SELECTORS (SELGRPID); -alter table BPEL_SELECTORS add constraint FKF1F83A0AA821BBE1 foreign key (PIID) references BPEL_INSTANCE; -alter table BPEL_SELECTORS add constraint FKF1F83A0A875201C9 foreign key (CORRELATOR) references BPEL_CORRELATOR; -create index IDX_UNMATCHED_CKEY on BPEL_UNMATCHED (CORRELATION_KEY); -create index IDX_UNMATCHED_CORRELATOR on BPEL_UNMATCHED (CORRELATOR); -alter table BPEL_UNMATCHED add constraint FKF0663E01CA00A413 foreign key (MEX) references BPEL_MESSAGE_EXCHANGE; -alter table BPEL_UNMATCHED add constraint FKF0663E01875201C9 foreign key (CORRELATOR) references BPEL_CORRELATOR; -alter table BPEL_XML_DATA add constraint FKB7D47E7C14020712 foreign key (LDATA_ID) references LARGE_DATA; -alter table BPEL_XML_DATA add constraint FKB7D47E7CA821BBE1 foreign key (PIID) references BPEL_INSTANCE; -alter table BPEL_XML_DATA add constraint FKB7D47E7C6D49C363 foreign key (SCOPE_ID) references BPEL_SCOPE; -alter table VAR_PROPERTY add constraint FK9C1E2C0DA48E25F2 foreign key (XML_DATA_ID) references BPEL_XML_DATA;

15 years, 2 months

1
0
0 / 0

riftsaw SVN: r169 - trunk/runtime/engine-assembly/resources/META-INF.

by riftsaw-commits＠lists.jboss.org

Author: heiko.braun(a)jboss.com Date: 2009-10-12 06:26:47 -0400 (Mon, 12 Oct 2009) New Revision: 169 Modified: trunk/runtime/engine-assembly/resources/META-INF/jboss-beans.xml Log: Reference the correct SQL scripts Modified: trunk/runtime/engine-assembly/resources/META-INF/jboss-beans.xml =================================================================== --- trunk/runtime/engine-assembly/resources/META-INF/jboss-beans.xml 2009-10-12 10:20:43 UTC (rev 168) +++ trunk/runtime/engine-assembly/resources/META-INF/jboss-beans.xml 2009-10-12 10:26:47 UTC (rev 169) @@ -5,7 +5,7 @@ name="BPELDatabaseInitializer"> <property name="datasource"><value>java:/BPELDB</value></property> <property name="existsSql"><value>select * from ODE_JOB</value></property> - <property name="sqlFiles"><value>bpel-sql/bpel.hsql.sql</value></property> + <property name="sqlFiles"><value>bpel-sql/hsql.sql</value></property> <property name="useEOL"><value>false</value></property> <depends>jboss.jca:service=DataSourceBinding,name=BPELDB</depends> </bean>

15 years, 2 months

1
0
0 / 0

riftsaw SVN: r168 - branches/ODE/ODE-1.x-fixes/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel.

by riftsaw-commits＠lists.jboss.org

Author: heiko.braun(a)jboss.com Date: 2009-10-12 06:20:43 -0400 (Mon, 12 Oct 2009) New Revision: 168 Modified: branches/ODE/ODE-1.x-fixes/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/BpelDAOConnectionImpl.java branches/ODE/ODE-1.x-fixes/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/MessageExchangeDaoImpl.java Log: Rollback changes wrt MEXID Modified: branches/ODE/ODE-1.x-fixes/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/BpelDAOConnectionImpl.java =================================================================== --- branches/ODE/ODE-1.x-fixes/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/BpelDAOConnectionImpl.java 2009-10-12 10:01:51 UTC (rev 167) +++ branches/ODE/ODE-1.x-fixes/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/BpelDAOConnectionImpl.java 2009-10-12 10:20:43 UTC (rev 168) @@ -97,10 +97,8 @@ } public MessageExchangeDAO getMessageExchange(String mexid) { - org.hibernate.Query query = getSession().createQuery("from HMessageExchange x where x.mexId = ?"); - query.setString(0, mexid); - HMessageExchange mex = (HMessageExchange) query.uniqueResult(); - return mex == null ? null : new MessageExchangeDaoImpl(_sm, mex); + HMessageExchange mex = (HMessageExchange) getSession().get(HMessageExchange.class, new Long(mexid)); + return mex == null ? null : new MessageExchangeDaoImpl(_sm, mex); } public ProcessDAO createProcess(QName pid, QName type, String guid, long version) { Modified: branches/ODE/ODE-1.x-fixes/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/MessageExchangeDaoImpl.java =================================================================== --- branches/ODE/ODE-1.x-fixes/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/MessageExchangeDaoImpl.java 2009-10-12 10:01:51 UTC (rev 167) +++ branches/ODE/ODE-1.x-fixes/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/MessageExchangeDaoImpl.java 2009-10-12 10:20:43 UTC (rev 168) @@ -60,7 +60,7 @@ } public String getMessageExchangeId() { - return _hself.getMexId(); + return _hself.getId().toString(); } public MessageDAO getResponse() {

15 years, 2 months

1
0
0 / 0

riftsaw SVN: r167 - branches/ODE/ODE-1.x-fixes/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel.

by riftsaw-commits＠lists.jboss.org

Author: heiko.braun(a)jboss.com Date: 2009-10-12 06:01:51 -0400 (Mon, 12 Oct 2009) New Revision: 167 Modified: branches/ODE/ODE-1.x-fixes/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/BpelDAOConnectionImpl.java Log: fix compile errors Modified: branches/ODE/ODE-1.x-fixes/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/BpelDAOConnectionImpl.java =================================================================== --- branches/ODE/ODE-1.x-fixes/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/BpelDAOConnectionImpl.java 2009-10-12 09:47:24 UTC (rev 166) +++ branches/ODE/ODE-1.x-fixes/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/BpelDAOConnectionImpl.java 2009-10-12 10:01:51 UTC (rev 167) @@ -97,8 +97,8 @@ } public MessageExchangeDAO getMessageExchange(String mexid) { - org.hibernate.Query query = _session.createQuery("from HMessageExchange x where x.mexId = ?"); - query.setString(0, mexId); + org.hibernate.Query query = getSession().createQuery("from HMessageExchange x where x.mexId = ?"); + query.setString(0, mexid); HMessageExchange mex = (HMessageExchange) query.uniqueResult(); return mex == null ? null : new MessageExchangeDaoImpl(_sm, mex); }

15 years, 2 months

1
0
0 / 0

riftsaw SVN: r166 - branches/ODE/ODE-1.x-fixes/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel.

by riftsaw-commits＠lists.jboss.org

Author: heiko.braun(a)jboss.com Date: 2009-10-12 05:47:24 -0400 (Mon, 12 Oct 2009) New Revision: 166 Modified: branches/ODE/ODE-1.x-fixes/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/BpelDAOConnectionImpl.java branches/ODE/ODE-1.x-fixes/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/MessageExchangeDaoImpl.java Log: Added patch for http://issues.apache.org/jira/browse/ODE-436 Modified: branches/ODE/ODE-1.x-fixes/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/BpelDAOConnectionImpl.java =================================================================== --- branches/ODE/ODE-1.x-fixes/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/BpelDAOConnectionImpl.java 2009-10-09 20:02:36 UTC (rev 165) +++ branches/ODE/ODE-1.x-fixes/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/BpelDAOConnectionImpl.java 2009-10-12 09:47:24 UTC (rev 166) @@ -97,8 +97,10 @@ } public MessageExchangeDAO getMessageExchange(String mexid) { - HMessageExchange mex = (HMessageExchange) getSession().get(HMessageExchange.class, new Long(mexid)); - return mex == null ? null : new MessageExchangeDaoImpl(_sm, mex); + org.hibernate.Query query = _session.createQuery("from HMessageExchange x where x.mexId = ?"); + query.setString(0, mexId); + HMessageExchange mex = (HMessageExchange) query.uniqueResult(); + return mex == null ? null : new MessageExchangeDaoImpl(_sm, mex); } public ProcessDAO createProcess(QName pid, QName type, String guid, long version) { Modified: branches/ODE/ODE-1.x-fixes/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/MessageExchangeDaoImpl.java =================================================================== --- branches/ODE/ODE-1.x-fixes/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/MessageExchangeDaoImpl.java 2009-10-09 20:02:36 UTC (rev 165) +++ branches/ODE/ODE-1.x-fixes/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/MessageExchangeDaoImpl.java 2009-10-12 09:47:24 UTC (rev 166) @@ -60,7 +60,7 @@ } public String getMessageExchangeId() { - return _hself.getId().toString(); + return _hself.getMexId(); } public MessageDAO getResponse() {

15 years, 2 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

riftsaw-commits October 2009