Author: jeff.yuchang
Date: 2010-05-09 08:19:06 -0400 (Sun, 09 May 2010)
New Revision: 643
Modified:
trunk/distribution/src/main/release/db/sql/mysql.drop.sql
trunk/distribution/src/main/release/db/sql/oracle.drop.sql
trunk/distribution/src/main/release/db/sql/postgres.drop.sql
trunk/distribution/src/main/release/db/sql/sqlserver.drop.sql
trunk/distribution/src/main/release/install/build.xml
trunk/docs/docbook/gettingstartedguide/src/main/module/installation.xml
trunk/integration-tests/pom.xml
trunk/pom.xml
trunk/runtime/engine-assembly/src/main/resources/bpel-sql/derby.sql
trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql
trunk/runtime/engine-assembly/src/main/resources/bpel-sql/mysql.sql
trunk/runtime/engine-assembly/src/main/resources/bpel-sql/oracle.sql
trunk/runtime/engine-assembly/src/main/resources/bpel-sql/postgres.sql
trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sqlserver.sql
Log:
* update the db scripts due to ODE upgrade.
Modified: trunk/distribution/src/main/release/db/sql/mysql.drop.sql
===================================================================
--- trunk/distribution/src/main/release/db/sql/mysql.drop.sql 2010-05-07 14:29:32 UTC (rev
642)
+++ trunk/distribution/src/main/release/db/sql/mysql.drop.sql 2010-05-09 12:19:06 UTC (rev
643)
@@ -9,7 +9,6 @@
drop table BPEL_FAULT;
drop table BPEL_INSTANCE;
drop table BPEL_MESSAGE;
-drop table BPEL_MESSAGE_EXCHANGE;
drop table BPEL_MEX_PROPS;
drop table BPEL_PLINK_VAL;
drop table BPEL_PROCESS;
@@ -17,12 +16,12 @@
drop table BPEL_SELECTORS;
drop table BPEL_UNMATCHED;
drop table BPEL_XML_DATA;
-drop table LARGE_DATA;
drop table VAR_PROPERTY;
drop table STORE_DU;
drop table STORE_PROCESS;
drop table STORE_PROCESS_PROP;
drop table STORE_VERSIONS;
+drop table BPEL_MESSAGE_EXCHANGE;
Modified: trunk/distribution/src/main/release/db/sql/oracle.drop.sql
===================================================================
--- trunk/distribution/src/main/release/db/sql/oracle.drop.sql 2010-05-07 14:29:32 UTC
(rev 642)
+++ trunk/distribution/src/main/release/db/sql/oracle.drop.sql 2010-05-09 12:19:06 UTC
(rev 643)
@@ -16,14 +16,14 @@
drop table BPEL_SELECTORS;
drop table BPEL_UNMATCHED;
drop table BPEL_XML_DATA;
-drop table LARGE_DATA;
drop table VAR_PROPERTY;
+drop sequence hibernate_seqhilo;
drop table STORE_DU;
drop table STORE_PROCESS;
drop table STORE_PROCESS_PROP;
drop table STORE_VERSIONS;
drop table BPEL_MESSAGE_EXCHANGE;
-drop sequence hibernate_sequence;
+
Modified: trunk/distribution/src/main/release/db/sql/postgres.drop.sql
===================================================================
--- trunk/distribution/src/main/release/db/sql/postgres.drop.sql 2010-05-07 14:29:32 UTC
(rev 642)
+++ trunk/distribution/src/main/release/db/sql/postgres.drop.sql 2010-05-09 12:19:06 UTC
(rev 643)
@@ -16,16 +16,11 @@
drop table BPEL_SELECTORS;
drop table BPEL_UNMATCHED;
drop table BPEL_XML_DATA;
-drop table LARGE_DATA;
drop table VAR_PROPERTY;
+drop sequence hibernate_seqhilo;
drop table STORE_DU;
drop table STORE_PROCESS;
drop table STORE_PROCESS_PROP;
drop table STORE_VERSIONS;
drop table BPEL_MESSAGE_EXCHANGE;
-drop sequence hibernate_sequence;
-
-
-
-
Modified: trunk/distribution/src/main/release/db/sql/sqlserver.drop.sql
===================================================================
--- trunk/distribution/src/main/release/db/sql/sqlserver.drop.sql 2010-05-07 14:29:32 UTC
(rev 642)
+++ trunk/distribution/src/main/release/db/sql/sqlserver.drop.sql 2010-05-09 12:19:06 UTC
(rev 643)
@@ -16,10 +16,11 @@
drop table BPEL_SELECTORS;
drop table BPEL_UNMATCHED;
drop table BPEL_XML_DATA;
-drop table LARGE_DATA;
drop table VAR_PROPERTY;
+drop table hibernate_unique_key;
drop table STORE_DU;
drop table STORE_PROCESS;
drop table STORE_PROCESS_PROP;
drop table STORE_VERSIONS;
drop table BPEL_MESSAGE_EXCHANGE;
+
Modified: trunk/distribution/src/main/release/install/build.xml
===================================================================
--- trunk/distribution/src/main/release/install/build.xml 2010-05-07 14:29:32 UTC (rev
642)
+++ trunk/distribution/src/main/release/install/build.xml 2010-05-09 12:19:06 UTC (rev
643)
@@ -1,334 +1,334 @@
-<project name="BPEL_Installer" default="deploy"
basedir=".">
-
- <!-- Set deployment properties filename -->
- <property name="org.jboss.soa.bpel.deployment.properties"
location="deployment.properties"/>
-
- <!-- Load Build Properties File -->
- <property file="${org.jboss.soa.bpel.deployment.properties}"/>
- <property file="../version.properties" />
-
- <property name="server.dir"
value="${org.jboss.as.home}/server/${org.jboss.as.config}"/>
- <property name="conf.dir" value="${server.dir}/conf"/>
- <property name="deploy.dir" value="${server.dir}/deploy"/>
- <property name="deployers.dir"
value="${server.dir}/deployers"/>
- <property name="server.lib.dir" value="${server.dir}/lib"/>
- <property name="bpel-deployer" value="riftsaw.deployer" />
- <property name="bpel-runtime" value="riftsaw.sar" />
- <property name="jbossesb-bpel" value="riftsaw.esb" />
- <property name="bpel-esb-examples" value="esb" />
- <property name="esb.examples.dir"
value="${org.jboss.esb.home}/samples/quickstarts"/>
-
- <!-- ws stack provider -->
- <property name="ws.stack" value="native" />
- <property name="ws.version" value="3.1.2.GA" />
-
- <property name="ws.stack.distro.url"
value="http://jboss.org/file-access/default/members/jbossws/download...
/>
- <property name="ws.stack.dir" value="ws-stack"/>
-
- <condition property="keep.ws.stack">
- <and>
- <equals arg1="${ws.stack}" arg2="native"/>
- <equals arg1="${ws.version}" arg2="3.1.2.GA" />
- </and>
- </condition>
-
- <condition property="is.ws.stack.distro.available">
- <available file="${ws.stack.dir}/jbossws-${ws.stack}-${ws.version}.zip"
/>
- </condition>
-
- <property name="modules" value="../modules" />
- <property name="samples" value="../samples" />
-
- <target name="check.deploy.props">
- <condition property="as.configured">
- <and>
- <isset property="org.jboss.as.home"/>
- <isset property="org.jboss.as.config"/>
- <isset property="org.jboss.esb.home"/>
- </and>
- </condition>
-
- <fail unless="as.configured" message="Cannot determine target
deployment, please check deployment.properties"/>
- </target>
-
- <target name="deploy" description="Deploys BPEL Runtime to the
server">
-
- <antcall target="internal.install.riftsaw.ws.stack"/>
-
- <echo message="Deploy BPEL runtime to JBoss server" />
- <copy todir="${deployers.dir}/${bpel-deployer}">
- <fileset dir="${modules}/${bpel-deployer}" />
- </copy>
- <copy todir="${deploy.dir}/${bpel-runtime}">
- <fileset dir="${modules}/${bpel-runtime}" />
- </copy>
-
- <copy todir="${deploy.dir}/${jbossesb-bpel}">
- <fileset dir="${modules}/${jbossesb-bpel}" />
- </copy>
-
- <!-- copy appropriate jboss-beans.xml, bpel.properties, datasource etc into server
-->
- <copy file="../db/jboss/jboss-beans.xml"
- toFile="${deploy.dir}/${bpel-runtime}/META-INF/jboss-beans.xml"
- overwrite="true">
- <filterset>
- <filter token="database" value="${database}"/>
- </filterset>
-
- </copy>
-
- <copy file="../db/bpel.properties"
- toFile="${deploy.dir}/${bpel-runtime}/bpel.properties"
- overwrite="true">
- <filterset filtersfile="../db/jdbc/${database}.properties" />
- </copy>
-
- <copy file="../db/datasource/bpel-${database}-ds.xml"
- toFile="${deploy.dir}/${bpel-runtime}/META-INF/bpel-ds.xml"
- overwrite="true">
- <filterset filtersfile="../db/jdbc/${database}.properties" />
- </copy>
-
- <!--install appropriate db driver-->
- <antcall target="internal.install.riftsaw.into.jboss.db.${database}"
/>
-
- <antcall target="deploy.esb.uddi.config"/>
- <!-- BPM Console -->
-
- <mkdir dir="${deploy.dir}/bpel-console"/>
- <mkdir dir="${deploy.dir}/bpel-console/bpel-identity.sar"/>
- <mkdir dir="${deploy.dir}/bpel-console/gwt-console-server.war"/>
- <copy file="${modules}/bpel-console/riftsaw-console-integration.jar"
todir="${deploy.dir}/bpel-console"/>
- <copy file="${modules}/bpel-console/jettison.jar"
todir="${deploy.dir}/bpel-console"/>
- <unzip src="${modules}/bpel-console/riftsaw-console-identity.jar"
dest="${deploy.dir}/bpel-console/bpel-identity.sar"/>
- <copy file="${modules}/bpel-console/gwt-console.war"
todir="${deploy.dir}/bpel-console"/>
- <unzip src="${modules}/bpel-console/gwt-console-server.war"
dest="${deploy.dir}/bpel-console/gwt-console-server.war"/>
- <copy file="${modules}/bpel-console/gwt-console-server-integration.jar"
todir="${server.lib.dir}"/>
- <copy file="${modules}/bpel-console/gwt-console-rpc.jar"
todir="${server.lib.dir}"/>
-
- <antcall target="remove.redundant.juddi" />
-
- </target>
-
- <target name="undeploy" description="Undeploys BPEL
Runtime">
- <echo message="Undeploy the BPEL runtime from JBoss ESB server" />
- <delete dir="${deployers.dir}/${bpel-deployer}" />
- <delete dir="${deploy.dir}/${bpel-runtime}" />
- <delete dir="${deploy.dir}/${jbossesb-bpel}" />
-
- <!--uninstall appropriate db driver-->
- <antcall target="internal.uninstall.riftsaw.into.jboss.db.${database}"
/>
- <antcall target="undeploy.esb.uddi.config"/>
-
- <delete dir="${deploy.dir}/bpel-console" />
- <delete
file="${server.lib.dir}/gwt-console-server-integration.jar"/>
- <delete file="${server.lib.dir}/gwt-console-rpc.jar"/>
- </target>
-
- <target name="deploy-esb-examples" depends="check.deploy.props"
description="Deploys BPEL example to JBossESB">
- <echo message="Deploy BPEL ESB examples" />
- <copy todir="${esb.examples.dir}">
- <fileset dir="${samples}/${bpel-esb-examples}" />
- </copy>
- </target>
-
- <target name="undeploy-esb-examples"
depends="check.deploy.props" description="Undeploys BPEL example from
JBossESB">
- <echo message="Undeploy BPEL example" />
- <delete dir="${esb.examples.dir}/bpel_helloworld" />
- <delete dir="${esb.examples.dir}/bpel_loan_fault" />
- <delete dir="${esb.examples.dir}/webservice_esb_bpel" />
- </target>
-
-
- <!-- install database specific driver -->
+<project name="BPEL_Installer" default="deploy"
basedir=".">
+
+ <!-- Set deployment properties filename -->
+ <property name="org.jboss.soa.bpel.deployment.properties"
location="deployment.properties"/>
+
+ <!-- Load Build Properties File -->
+ <property file="${org.jboss.soa.bpel.deployment.properties}"/>
+ <property file="../version.properties" />
+
+ <property name="server.dir"
value="${org.jboss.as.home}/server/${org.jboss.as.config}"/>
+ <property name="conf.dir" value="${server.dir}/conf"/>
+ <property name="deploy.dir" value="${server.dir}/deploy"/>
+ <property name="deployers.dir"
value="${server.dir}/deployers"/>
+ <property name="server.lib.dir" value="${server.dir}/lib"/>
+ <property name="bpel-deployer" value="riftsaw.deployer" />
+ <property name="bpel-runtime" value="riftsaw.sar" />
+ <property name="jbossesb-bpel" value="riftsaw.esb" />
+ <property name="bpel-esb-examples" value="esb" />
+ <property name="esb.examples.dir"
value="${org.jboss.esb.home}/samples/quickstarts"/>
+
+ <!-- ws stack provider -->
+ <property name="ws.stack" value="native" />
+ <property name="ws.version" value="3.1.2.GA" />
+
+ <property name="ws.stack.distro.url"
value="http://jboss.org/file-access/default/members/jbossws/download...
/>
+ <property name="ws.stack.dir" value="ws-stack"/>
+
+ <condition property="keep.ws.stack">
+ <and>
+ <equals arg1="${ws.stack}" arg2="native"/>
+ <equals arg1="${ws.version}" arg2="3.1.2.GA" />
+ </and>
+ </condition>
+
+ <condition property="is.ws.stack.distro.available">
+ <available file="${ws.stack.dir}/jbossws-${ws.stack}-${ws.version}.zip"
/>
+ </condition>
+
+ <property name="modules" value="../modules" />
+ <property name="samples" value="../samples" />
+
+ <target name="check.deploy.props">
+ <condition property="as.configured">
+ <and>
+ <isset property="org.jboss.as.home"/>
+ <isset property="org.jboss.as.config"/>
+ <isset property="org.jboss.esb.home"/>
+ </and>
+ </condition>
+
+ <fail unless="as.configured" message="Cannot determine target
deployment, please check deployment.properties"/>
+ </target>
+
+ <target name="deploy" description="Deploys BPEL Runtime to the
server">
+
+ <antcall target="internal.install.riftsaw.ws.stack"/>
+
+ <echo message="Deploy BPEL runtime to JBoss server" />
+ <copy todir="${deployers.dir}/${bpel-deployer}">
+ <fileset dir="${modules}/${bpel-deployer}" />
+ </copy>
+ <copy todir="${deploy.dir}/${bpel-runtime}">
+ <fileset dir="${modules}/${bpel-runtime}" />
+ </copy>
+
+ <copy todir="${deploy.dir}/${jbossesb-bpel}">
+ <fileset dir="${modules}/${jbossesb-bpel}" />
+ </copy>
+
+ <!-- copy appropriate jboss-beans.xml, bpel.properties, datasource etc into server
-->
+ <copy file="../db/jboss/jboss-beans.xml"
+ toFile="${deploy.dir}/${bpel-runtime}/META-INF/jboss-beans.xml"
+ overwrite="true">
+ <filterset>
+ <filter token="database" value="${database}"/>
+ </filterset>
+
+ </copy>
+
+ <copy file="../db/bpel.properties"
+ toFile="${deploy.dir}/${bpel-runtime}/bpel.properties"
+ overwrite="true">
+ <filterset filtersfile="../db/jdbc/${database}.properties" />
+ </copy>
+
+ <copy file="../db/datasource/bpel-${database}-ds.xml"
+ toFile="${deploy.dir}/${bpel-runtime}/META-INF/bpel-ds.xml"
+ overwrite="true">
+ <filterset filtersfile="../db/jdbc/${database}.properties" />
+ </copy>
+
+ <!--install appropriate db driver-->
+ <antcall target="internal.install.riftsaw.into.jboss.db.${database}"
/>
+
+ <antcall target="deploy.esb.uddi.config"/>
+ <!-- BPM Console -->
+
+ <mkdir dir="${deploy.dir}/bpel-console"/>
+ <mkdir dir="${deploy.dir}/bpel-console/bpel-identity.sar"/>
+ <mkdir dir="${deploy.dir}/bpel-console/gwt-console-server.war"/>
+ <copy file="${modules}/bpel-console/riftsaw-console-integration.jar"
todir="${deploy.dir}/bpel-console"/>
+ <copy file="${modules}/bpel-console/jettison.jar"
todir="${deploy.dir}/bpel-console"/>
+ <unzip src="${modules}/bpel-console/riftsaw-console-identity.jar"
dest="${deploy.dir}/bpel-console/bpel-identity.sar"/>
+ <copy file="${modules}/bpel-console/gwt-console.war"
todir="${deploy.dir}/bpel-console"/>
+ <unzip src="${modules}/bpel-console/gwt-console-server.war"
dest="${deploy.dir}/bpel-console/gwt-console-server.war"/>
+ <copy file="${modules}/bpel-console/gwt-console-server-integration.jar"
todir="${server.lib.dir}"/>
+ <copy file="${modules}/bpel-console/gwt-console-rpc.jar"
todir="${server.lib.dir}"/>
+
+ <antcall target="remove.redundant.juddi" />
+
+ </target>
+
+ <target name="undeploy" description="Undeploys BPEL
Runtime">
+ <echo message="Undeploy the BPEL runtime from JBoss ESB server" />
+ <delete dir="${deployers.dir}/${bpel-deployer}" />
+ <delete dir="${deploy.dir}/${bpel-runtime}" />
+ <delete dir="${deploy.dir}/${jbossesb-bpel}" />
+
+ <!--uninstall appropriate db driver-->
+ <antcall target="internal.uninstall.riftsaw.into.jboss.db.${database}"
/>
+ <antcall target="undeploy.esb.uddi.config"/>
+
+ <delete dir="${deploy.dir}/bpel-console" />
+ <delete
file="${server.lib.dir}/gwt-console-server-integration.jar"/>
+ <delete file="${server.lib.dir}/gwt-console-rpc.jar"/>
+ </target>
+
+ <target name="deploy-esb-examples" depends="check.deploy.props"
description="Deploys BPEL example to JBossESB">
+ <echo message="Deploy BPEL ESB examples" />
+ <copy todir="${esb.examples.dir}">
+ <fileset dir="${samples}/${bpel-esb-examples}" />
+ </copy>
+ </target>
+
+ <target name="undeploy-esb-examples"
depends="check.deploy.props" description="Undeploys BPEL example from
JBossESB">
+ <echo message="Undeploy BPEL example" />
+ <delete dir="${esb.examples.dir}/bpel_helloworld" />
+ <delete dir="${esb.examples.dir}/bpel_loan_fault" />
+ <delete dir="${esb.examples.dir}/webservice_esb_bpel" />
+ </target>
+
+
+ <!-- install database specific driver -->
<target name="internal.install.riftsaw.into.jboss.db.hsql">
<!-- If the older version of h2 exists, as installed by the ESB (4.7), then
rename it -->
<move file="${server.lib.dir}/h2-1.0.68.jar"
tofile="${server.lib.dir}/h2-1.0.68.jar.OLD"
failonerror="no" />
-
- <copy todir="${server.lib.dir}" overwrite="true">
- <fileset dir="../db/drivers">
- <include name="h2*.jar" />
- </fileset>
- </copy>
- </target>
-
- <target name="internal.install.riftsaw.into.jboss.db.derby">
- <copy todir="${server.lib.dir}" overwrite="true">
- <fileset dir="../db/drivers">
- <include name="derby*.jar"/>
- </fileset>
- </copy>
- </target>
-
- <target name="internal.install.riftsaw.into.jboss.db.mysql">
- <copy todir="${deploy.dir}/${bpel-runtime}/lib"
overwrite="true">
- <fileset dir="../db/drivers">
- <include name="mysql-connector-java*.jar"/>
- </fileset>
- </copy>
- </target>
-
- <target name="internal.install.riftsaw.into.jboss.db.sqlserver">
- <copy todir="${deploy.dir}/${bpel-runtime}/lib"
overwrite="true">
- <fileset dir="../db/drivers">
- <include name="jtds-*.jar"/>
- </fileset>
- </copy>
- </target>
-
- <target name="internal.install.riftsaw.into.jboss.db.postgres">
- <copy todir="${deploy.dir}/${bpel-runtime}/lib"
overwrite="true">
- <fileset dir="../db/drivers">
- <include name="postgresql-*.jar"/>
- </fileset>
- </copy>
- </target>
-
- <target name="internal.install.riftsaw.into.jboss.db.oracle">
- <available file="../db/drivers/ojdbc14.jar"
property="oracle.driver.jar.available" />
- <fail message="please download the oracle driver jar ojdbc14.jar from
oracle and put it in the db/drivers directory"
unless="oracle.driver.jar.available" />
- <copy file="../db/drivers/ojdbc14.jar"
- todir="${deploy.dir}/${bpel-runtime}/lib" />
- </target>
-
- <!-- uninstall database specific driver -->
- <target name="internal.uninstall.riftsaw.into.jboss.db.hsql" />
-
- <target name="internal.uninstall.riftsaw.into.jboss.db.derby">
- <delete file="${server.lib.dir}/derby-10.4.1.3.jar"/>
- <delete file="${server.lib.dir}/derbytools-10.4.1.3.jar"/>
- </target>
-
- <target name="internal.uninstall.riftsaw.into.jboss.db.mysql" />
-
- <target name="internal.uninstall.riftsaw.into.jboss.db.sqlserver" />
-
- <target name="internal.uninstall.riftsaw.into.jboss.db.postgres" />
-
- <target name="internal.uninstall.riftsaw.into.jboss.db.oracle"/>
-
- <target name="internal.install.riftsaw.ws.stack"
unless="keep.ws.stack">
- <echo>Replacing the Web Service Stack to
${ws.stack}-${ws.version}</echo>
- <antcall target="get.ws.stack" />
- <unzip src="${ws.stack.dir}/jbossws-${ws.stack}-${ws.version}.zip"
dest="${basedir}/ws-stack/dist/" />
- <copy
file="ws-stack/dist/jbossws-${ws.stack}-bin-dist/ant.properties.example"
tofile="ws-stack/dist/jbossws-${ws.stack}-bin-dist/ant.properties" />
- <ant dir="${basedir}/ws-stack/dist/jbossws-${ws.stack}-bin-dist"
target="deploy-jboss510">
- <property name="jboss510.home" value="${org.jboss.as.home}"
/>
- <property name="jboss.server.instance"
value="${org.jboss.as.config}" />
- </ant>
- </target>
-
- <target name="get.ws.stack" description="download ws stack"
unless="is.ws.stack.distro.available">
- <mkdir dir="${ws.stack.dir}" />
- <get src="${ws.stack.distro.url}"
dest="${ws.stack.dir}/jbossws-${ws.stack}-${ws.version}.zip" />
- </target>
-
- <target name="check.juddi">
- <condition property="is.juddi.duplicated">
- <available file="${deploy.dir}/juddi-service.sar" />
- </condition>
- </target>
-
- <target name="remove.redundant.juddi" if="is.juddi.duplicated"
depends="check.juddi">
- <!-- JBoss WS install additional juddi, duplicated with JBossESB's juddi one,
or in cluster environment -->
- <echo> deleting the duplicated juddi service</echo>
- <delete dir="${deploy.dir}/juddi-service.sar"/>
- </target>
-
- <target name="check.jbossesb-registry">
- <condition property="is.jbossesb-registry">
- <available file="${deploy.dir}/jbossesb-registry.sar" />
- </condition>
- <condition property="isNot.jbossesb-registry">
- <isfalse value="${is.jbossesb-registry}"/>
- </condition>
- </target>
-
- <target name="check.esb.juddi.client.xml.old"
if="is.jbossesb-registry" depends="check.jbossesb-registry">
- <condition property="is.renamedToOld">
- <available
file="${deploy.dir}/jbossesb-registry.sar/esb.juddi.client.xml.old" />
- </condition>
- <condition property="isNot.renamedToOld">
- <isfalse value="${is.renamedToOld}"/>
- </condition>
- </target>
-
- <target name="check.UDDI300" if="is.jbossesb-registry"
depends="check.jbossesb-registry">
- <condition property="is.juddi300">
- <available
file="${deployers.dir}/esb.deployer/lib/juddi-client-3.0.0.aop.jar" />
- </condition>
- <condition property="is.juddi">
- <isfalse value="${is.juddi300}"/>
- </condition>
- </target>
-
- <target name="deploy.esb.uddi.config" if="is.jbossesb-registry"
depends="check.jbossesb-registry,removeUDDI,removeUDDI300,renameEsbJUDDIClientXML">
- <echo>deploy jUDDI configuration</echo>
-
-
- <move
file="${deploy.dir}/jbossesb-registry.sar/juddi_custom_install_data/jbossesb_tModels.xml"
-
tofile="${deploy.dir}/jbossesb-registry.sar/juddi_custom_install_data/jbossesb_tModels.xml.old"/>
- <copy file="../db/juddi/jbossesb_tModels.xml"
- todir="${deploy.dir}/jbossesb-registry.sar/juddi_custom_install_data/"
/>
- <copy file="../db/juddi/jbossesb_BusinessEntity.xml"
- todir="${deploy.dir}/jbossesb-registry.sar/juddi_custom_install_data/"
/>
- <replace file="${deploy.dir}/riftsaw.sar/bpel.properties"
- token="bpel.uddi.registration=false"
- value="bpel.uddi.registration=true"/>
- <!-- uncomment to set UDDI lookup default to true
- <replace file="${deploy.dir}/riftsaw.sar/bpel.properties"
- token="bpel.uddi.lookup=false"
- value="bpel.uddi.lookup=true"/>
- -->
- <replace file="${deploy.dir}/jbossesb-registry.sar/esb.juddi.xml">
-
<replacetoken><![CDATA[juddi.seed.always">false]]></replacetoken>
-
<replacevalue><![CDATA[juddi.seed.always">true]]></replacevalue>
- </replace>
- <echo>${manager.name}</echo>
- <replace file="${deploy.dir}/riftsaw.sar/bpel.properties"
- token="bpel.uddi.clerk.manager=esb-registry"
- value="bpel.uddi.clerk.manager=${manager.name}"/>
- <replace file="${deploy.dir}/riftsaw.sar/bpel.properties"
- token="bpel.uddi.client.impl=org.jboss.soa.bpel.uddi.UDDIRegistration"
- value="bpel.uddi.client.impl=${UDDI.impl}"/>
- </target>
-
- <target name="renameEsbJUDDIClientXML" if="isNot.renamedToOld"
depends="check.esb.juddi.client.xml.old">
- <move file="${deploy.dir}/jbossesb.sar/esb.juddi.client.xml"
- tofile="${deploy.dir}/jbossesb.sar/esb.juddi.client.xml.old" />
- <copy file="../db/juddi/esb.${juddi.version}.client.xml"
- tofile="${deploy.dir}/jbossesb.sar/esb.juddi.client.xml" />
- </target>
-
- <!-- remove riftsaw-uddi jar if esb contains juddi-300 client artifacts -->
- <target name="removeUDDI" if="is.juddi300"
depends="check.UDDI300">
- <echo>remove riftsaw-uddi.jar</echo>
- <property name="juddi.version" value="juddi300"/>
- <property name="manager.name" value="test-manager"/>
- <property name="UDDI.impl"
value="org.jboss.soa.bpel.uddi300.UDDI300Registration" />
- <delete>
- <fileset dir="${deploy.dir}/riftsaw.sar/lib/"
includes="riftsaw-uddi-*.jar"/>
- </delete>
- </target>
-
- <!-- remove riftsaw-uddi300 jar if esb contains juddi-301 or higher client artifacts
-->
- <target name="removeUDDI300" if="is.juddi"
depends="check.UDDI300">
- <echo>remove riftsaw-uddi300.jar</echo>
- <property name="juddi.version" value="juddi"/>
- <property name="manager.name" value="esb-registry"/>
- <property name="UDDI.impl"
value="org.jboss.soa.bpel.uddi.UDDIRegistration" />
- <delete>
- <fileset dir="${deploy.dir}/riftsaw.sar/lib/"
includes="riftsaw-uddi300-*.jar"/>
- </delete>
- </target>
-
- <target name="undeploy.esb.uddi.config"
if="is.jbossesb-registry" depends="check.jbossesb-registry">
- <echo>undeploy jUDDI configuration</echo>
- <move file="${deploy.dir}/jbossesb.sar/esb.juddi.client.xml.old"
tofile="${deploy.dir}/jbossesb.sar/esb.juddi.client.xml"/>
- <move
file="${deploy.dir}/jbossesb-registry.sar/juddi_custom_install_data/jbossesb_tModels.xml.old"
-
tofile="${deploy.dir}/jbossesb-registry.sar/juddi_custom_install_data/jbossesb_tModels.xml"/>
- <delete
file="${deploy.dir}/jbossesb-registry.sar/juddi_custom_install_data/jbossesb_BusinessEntity.xml"
/>
- </target>
-
-</project>
+
+ <copy todir="${server.lib.dir}" overwrite="true">
+ <fileset dir="../db/drivers">
+ <include name="h2*.jar" />
+ </fileset>
+ </copy>
+ </target>
+
+ <target name="internal.install.riftsaw.into.jboss.db.derby">
+ <copy todir="${server.lib.dir}" overwrite="true">
+ <fileset dir="../db/drivers">
+ <include name="derby*.jar"/>
+ </fileset>
+ </copy>
+ </target>
+
+ <target name="internal.install.riftsaw.into.jboss.db.mysql">
+ <copy todir="${deploy.dir}/${bpel-runtime}/lib"
overwrite="true">
+ <fileset dir="../db/drivers">
+ <include name="mysql-connector-java*.jar"/>
+ </fileset>
+ </copy>
+ </target>
+
+ <target name="internal.install.riftsaw.into.jboss.db.sqlserver">
+ <copy todir="${deploy.dir}/${bpel-runtime}/lib"
overwrite="true">
+ <fileset dir="../db/drivers">
+ <include name="jtds-*.jar"/>
+ </fileset>
+ </copy>
+ </target>
+
+ <target name="internal.install.riftsaw.into.jboss.db.postgres">
+ <copy todir="${deploy.dir}/${bpel-runtime}/lib"
overwrite="true">
+ <fileset dir="../db/drivers">
+ <include name="postgresql-*.jar"/>
+ </fileset>
+ </copy>
+ </target>
+
+ <target name="internal.install.riftsaw.into.jboss.db.oracle">
+ <available file="../db/drivers/ojdbc14.jar"
property="oracle.driver.jar.available" />
+ <fail message="please download the oracle driver jar ojdbc14.jar from
oracle and put it in the db/drivers directory"
unless="oracle.driver.jar.available" />
+ <copy file="../db/drivers/ojdbc14.jar"
+ todir="${deploy.dir}/${bpel-runtime}/lib" />
+ </target>
+
+ <!-- uninstall database specific driver -->
+ <target name="internal.uninstall.riftsaw.into.jboss.db.hsql" />
+
+ <target name="internal.uninstall.riftsaw.into.jboss.db.derby">
+ <delete file="${server.lib.dir}/derby-10.4.1.3.jar"/>
+ <delete file="${server.lib.dir}/derbytools-10.4.1.3.jar"/>
+ </target>
+
+ <target name="internal.uninstall.riftsaw.into.jboss.db.mysql" />
+
+ <target name="internal.uninstall.riftsaw.into.jboss.db.sqlserver" />
+
+ <target name="internal.uninstall.riftsaw.into.jboss.db.postgres" />
+
+ <target name="internal.uninstall.riftsaw.into.jboss.db.oracle"/>
+
+ <target name="internal.install.riftsaw.ws.stack"
unless="keep.ws.stack">
+ <echo>Replacing the Web Service Stack to
${ws.stack}-${ws.version}</echo>
+ <antcall target="get.ws.stack" />
+ <unzip src="${ws.stack.dir}/jbossws-${ws.stack}-${ws.version}.zip"
dest="${basedir}/ws-stack/dist/" />
+ <copy
file="ws-stack/dist/jbossws-${ws.stack}-bin-dist/ant.properties.example"
tofile="ws-stack/dist/jbossws-${ws.stack}-bin-dist/ant.properties" />
+ <ant dir="${basedir}/ws-stack/dist/jbossws-${ws.stack}-bin-dist"
target="deploy-jboss510">
+ <property name="jboss510.home" value="${org.jboss.as.home}"
/>
+ <property name="jboss.server.instance"
value="${org.jboss.as.config}" />
+ </ant>
+ </target>
+
+ <target name="get.ws.stack" description="download ws stack"
unless="is.ws.stack.distro.available">
+ <mkdir dir="${ws.stack.dir}" />
+ <get src="${ws.stack.distro.url}"
dest="${ws.stack.dir}/jbossws-${ws.stack}-${ws.version}.zip" />
+ </target>
+
+ <target name="check.juddi">
+ <condition property="is.juddi.duplicated">
+ <available file="${deploy.dir}/juddi-service.sar" />
+ </condition>
+ </target>
+
+ <target name="remove.redundant.juddi" if="is.juddi.duplicated"
depends="check.juddi">
+ <!-- JBoss WS install additional juddi, duplicated with JBossESB's juddi one,
or in cluster environment -->
+ <echo> deleting the duplicated juddi service</echo>
+ <delete dir="${deploy.dir}/juddi-service.sar"/>
+ </target>
+
+ <target name="check.jbossesb-registry">
+ <condition property="is.jbossesb-registry">
+ <available file="${deploy.dir}/jbossesb-registry.sar" />
+ </condition>
+ <condition property="isNot.jbossesb-registry">
+ <isfalse value="${is.jbossesb-registry}"/>
+ </condition>
+ </target>
+
+ <target name="check.esb.juddi.client.xml.old"
if="is.jbossesb-registry" depends="check.jbossesb-registry">
+ <condition property="is.renamedToOld">
+ <available
file="${deploy.dir}/jbossesb-registry.sar/esb.juddi.client.xml.old" />
+ </condition>
+ <condition property="isNot.renamedToOld">
+ <isfalse value="${is.renamedToOld}"/>
+ </condition>
+ </target>
+
+ <target name="check.UDDI300" if="is.jbossesb-registry"
depends="check.jbossesb-registry">
+ <condition property="is.juddi300">
+ <available
file="${deployers.dir}/esb.deployer/lib/juddi-client-3.0.0.aop.jar" />
+ </condition>
+ <condition property="is.juddi">
+ <isfalse value="${is.juddi300}"/>
+ </condition>
+ </target>
+
+ <target name="deploy.esb.uddi.config" if="is.jbossesb-registry"
depends="check.jbossesb-registry,removeUDDI,removeUDDI300,renameEsbJUDDIClientXML">
+ <echo>deploy jUDDI configuration</echo>
+
+
+ <move
file="${deploy.dir}/jbossesb-registry.sar/juddi_custom_install_data/jbossesb_tModels.xml"
+
tofile="${deploy.dir}/jbossesb-registry.sar/juddi_custom_install_data/jbossesb_tModels.xml.old"/>
+ <copy file="../db/juddi/jbossesb_tModels.xml"
+ todir="${deploy.dir}/jbossesb-registry.sar/juddi_custom_install_data/"
/>
+ <copy file="../db/juddi/jbossesb_BusinessEntity.xml"
+ todir="${deploy.dir}/jbossesb-registry.sar/juddi_custom_install_data/"
/>
+ <replace file="${deploy.dir}/riftsaw.sar/bpel.properties"
+ token="bpel.uddi.registration=false"
+ value="bpel.uddi.registration=true"/>
+ <!-- uncomment to set UDDI lookup default to true
+ <replace file="${deploy.dir}/riftsaw.sar/bpel.properties"
+ token="bpel.uddi.lookup=false"
+ value="bpel.uddi.lookup=true"/>
+ -->
+ <replace file="${deploy.dir}/jbossesb-registry.sar/esb.juddi.xml">
+
<replacetoken><![CDATA[juddi.seed.always">false]]></replacetoken>
+
<replacevalue><![CDATA[juddi.seed.always">true]]></replacevalue>
+ </replace>
+ <echo>${manager.name}</echo>
+ <replace file="${deploy.dir}/riftsaw.sar/bpel.properties"
+ token="bpel.uddi.clerk.manager=esb-registry"
+ value="bpel.uddi.clerk.manager=${manager.name}"/>
+ <replace file="${deploy.dir}/riftsaw.sar/bpel.properties"
+ token="bpel.uddi.client.impl=org.jboss.soa.bpel.uddi.UDDIRegistration"
+ value="bpel.uddi.client.impl=${UDDI.impl}"/>
+ </target>
+
+ <target name="renameEsbJUDDIClientXML" if="isNot.renamedToOld"
depends="check.esb.juddi.client.xml.old">
+ <move file="${deploy.dir}/jbossesb.sar/esb.juddi.client.xml"
+ tofile="${deploy.dir}/jbossesb.sar/esb.juddi.client.xml.old" />
+ <copy file="../db/juddi/esb.${juddi.version}.client.xml"
+ tofile="${deploy.dir}/jbossesb.sar/esb.juddi.client.xml" />
+ </target>
+
+ <!-- remove riftsaw-uddi jar if esb contains juddi-300 client artifacts -->
+ <target name="removeUDDI" if="is.juddi300"
depends="check.UDDI300">
+ <echo>remove riftsaw-uddi.jar</echo>
+ <property name="juddi.version" value="juddi300"/>
+ <property name="manager.name" value="test-manager"/>
+ <property name="UDDI.impl"
value="org.jboss.soa.bpel.uddi300.UDDI300Registration" />
+ <delete>
+ <fileset dir="${deploy.dir}/riftsaw.sar/lib/"
includes="riftsaw-uddi-*.jar"/>
+ </delete>
+ </target>
+
+ <!-- remove riftsaw-uddi300 jar if esb contains juddi-301 or higher client artifacts
-->
+ <target name="removeUDDI300" if="is.juddi"
depends="check.UDDI300">
+ <echo>remove riftsaw-uddi300.jar</echo>
+ <property name="juddi.version" value="juddi"/>
+ <property name="manager.name" value="esb-registry"/>
+ <property name="UDDI.impl"
value="org.jboss.soa.bpel.uddi.UDDIRegistration" />
+ <delete>
+ <fileset dir="${deploy.dir}/riftsaw.sar/lib/"
includes="riftsaw-uddi300-*.jar"/>
+ </delete>
+ </target>
+
+ <target name="undeploy.esb.uddi.config"
if="is.jbossesb-registry" depends="check.jbossesb-registry">
+ <echo>undeploy jUDDI configuration</echo>
+ <move file="${deploy.dir}/jbossesb.sar/esb.juddi.client.xml.old"
tofile="${deploy.dir}/jbossesb.sar/esb.juddi.client.xml"/>
+ <move
file="${deploy.dir}/jbossesb-registry.sar/juddi_custom_install_data/jbossesb_tModels.xml.old"
+
tofile="${deploy.dir}/jbossesb-registry.sar/juddi_custom_install_data/jbossesb_tModels.xml"/>
+ <delete
file="${deploy.dir}/jbossesb-registry.sar/juddi_custom_install_data/jbossesb_BusinessEntity.xml"
/>
+ </target>
+
+</project>
Modified: trunk/docs/docbook/gettingstartedguide/src/main/module/installation.xml
===================================================================
--- trunk/docs/docbook/gettingstartedguide/src/main/module/installation.xml 2010-05-07
14:29:32 UTC (rev 642)
+++ trunk/docs/docbook/gettingstartedguide/src/main/module/installation.xml 2010-05-09
12:19:06 UTC (rev 643)
@@ -1,182 +1,182 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.5//EN"
"http://www.oasis-open.org/docbook/xml/4.5/docbookx.dtd" [
-]>
-<chapter id="installation">
- <title>Installation</title>
-
- <section>
- <title> Overview </title>
- <para>
- This chapter provides details of the pre-requisites for using the RiftSaw BPEL
project, and how
- to install the engine into a JBossAS environment.
- </para>
-
- <para>
- The examples distributed with RiftSaw are split into two categories, quickstarts
that are pure BPEL
- that can run directly in the JBossAS server, and ESB based examples that require
JBossESB. If you only
- want to use the pure BPEL examples, then JBossESB will not be required.
- </para>
- </section>
-
- <section>
- <title>Prerequisites</title>
- <orderedlist>
- <listitem>JBossAS (version 5.1.0.GA or higher) <emphasis
role="bold">jdk6</emphasis> version, available from
- <ulink
url="http://www.jboss.org/jbossas">http://www.jboss.org/jbos...;,
and please upgrade the web
- service stack to version 3.2.2.GA, as described in the following 'Upgrade
web service for JBoss AS' section.</listitem>
- <listitem>JBossESB (version 4.7.GA or higher), should download the
<emphasis role="bold">jbossesb-4.7.GA.zip</emphasis>,
- available from <ulink
url="http://www.jboss.org/jbossesb">http://www.jboss.org/jbo...;.
- This is only required to run the ESB/BPEL example.</listitem>
- <listitem>RiftSaw (version 2.0 or higher), available from
- <ulink
url="http://www.jboss.org/riftsaw">http://www.jboss.org/rift...
- <listitem>
- Ant, available from <ulink
url="http://ant.apache.org/">http://ant.apache.org</ulink...
- </listitem>
- </orderedlist>
- </section>
-
- <section>
- <title>Installation Instructions</title>
-
- <note>
- <para>
- If you have previously installed RiftSaw-2.0-M1, then you will need to undeploy
this version using the
- <emphasis>ant undeploy</emphasis> command from the
<filename>install</filename> folder of the M1
- distribution. This is due to database schema changes.
- </para>
- </note>
-
- <orderedlist>
- <listitem>
- Install JBossAS
- <para>
- Unpack the JBossAS installation into the required location.
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.5//EN"
"http://www.oasis-open.org/docbook/xml/4.5/docbookx.dtd" [
+]>
+<chapter id="installation">
+ <title>Installation</title>
+
+ <section>
+ <title> Overview </title>
+ <para>
+ This chapter provides details of the pre-requisites for using the RiftSaw BPEL
project, and how
+ to install the engine into a JBossAS environment.
+ </para>
+
+ <para>
+ The examples distributed with RiftSaw are split into two categories, quickstarts
that are pure BPEL
+ that can run directly in the JBossAS server, and ESB based examples that require
JBossESB. If you only
+ want to use the pure BPEL examples, then JBossESB will not be required.
+ </para>
+ </section>
+
+ <section>
+ <title>Prerequisites</title>
+ <orderedlist>
+ <listitem>JBossAS (version 5.1.0.GA or higher) <emphasis
role="bold">jdk6</emphasis> version, available from
+ <ulink
url="http://www.jboss.org/jbossas">http://www.jboss.org/jbos...;,
and please upgrade the web
+ service stack to version 3.2.2.GA, as described in the following 'Upgrade
web service for JBoss AS' section.</listitem>
+ <listitem>JBossESB (version 4.7.GA or higher), should download the
<emphasis role="bold">jbossesb-4.7.GA.zip</emphasis>,
+ available from <ulink
url="http://www.jboss.org/jbossesb">http://www.jboss.org/jbo...;.
+ This is only required to run the ESB/BPEL example.</listitem>
+ <listitem>RiftSaw (version 2.0 or higher), available from
+ <ulink
url="http://www.jboss.org/riftsaw">http://www.jboss.org/rift...
+ <listitem>
+ Ant, available from <ulink
url="http://ant.apache.org/">http://ant.apache.org</ulink...
+ </listitem>
+ </orderedlist>
+ </section>
+
+ <section>
+ <title>Installation Instructions</title>
+
+ <note>
+ <para>
+ If you have previously installed RiftSaw-2.0-M1, then you will need to undeploy
this version using the
+ <emphasis>ant undeploy</emphasis> command from the
<filename>install</filename> folder of the M1
+ distribution. This is due to database schema changes.
+ </para>
+ </note>
+
+ <orderedlist>
+ <listitem>
+ Install JBossAS
+ <para>
+ Unpack the JBossAS installation into the required location.
</para>
- </listitem>
-
- <listitem>
- Install JBossESB
- <para>
- This is only required if you want to run the ESB/BPEL examples.
- </para>
- <para>
- Unpack the JBossESB installation into a location alongside the JBossAS
installation.
- Then follow the instructions in the JBossESB installation
(install/readme.txt), to deploy
- JBossESB into the JBossAS environment.
- </para>
- <warning>
- <para>
- If you intend to install the jbossesb, it must be deployed to the
application server
- before riftsaw.
- </para>
- </warning>
- </listitem>
-
- <listitem>
- Install the RiftSaw distribution
- <para>
- Unpack the RiftSaw distribution into a location alongside the JBossAS installation.
- </para>
- <para>
- <itemizedlist>
- <listitem>
- Edit the <emphasis
role="bold">install/deployment.properties</emphasis> file to update
- the JBossAS and JBossESB location settings.
- </listitem>
- <listitem>
- From the install folder, run: <command>ant deploy
-Ddatabase=....</command> to deploy
- RiftSaw to JBossAS. The list of available databases, and how they should be
configured,
- is explained in the following sub-section.
- </listitem>
- <listitem>
- If JBossESB has been installed, then run: <command>ant
deploy-esb-examples</command> to
- install the BPEL/ESB examples into the JBossESB samples/quickstart folder.
- </listitem>
- </itemizedlist>
- </para>
- </listitem>
- </orderedlist>
-
- <para>
- To de-install the RiftSaw distribution,
- </para>
- <orderedlist>
- <listitem>
- Uninstall the RiftSaw distribution
- <para>
- <itemizedlist>
- <listitem>
- From the install folder, run: <command>ant undeploy
-Ddatabase=....</command> to remove
- RiftSaw from JBossAS. The database option should specify the same value used
- during installation of RiftSaw.
- </listitem>
- <listitem>
- If JBossESB has been installed, then run: <command>ant
undeploy-esb-examples</command> to
- remove the BPEL/ESB examples from the JBossESB samples/quickstart folder.
- </listitem>
- </itemizedlist>
- </para>
- </listitem>
- </orderedlist>
-
- <para>
- <tip>
- In the Hsql database environment, if you install the RiftSaw, we will copy the h2
library into JBoss AS server.
- But when you undeploy the RiftSaw, we won't delete it. The reason for doing this
is because the JBoss ESB or jBPM will use the h2 database also,
- if we remove the h2 database in the undeployment process, we might cause JBoss ESB or
jBPM start failed.
- So if you want to remove the h2 database, please go to the $JBossAS/server/${config}
(like default)/lib, and then remove it manually.
- </tip>
- </para>
-
- <section>
- <title>Available databases and how to configure them</title>
-
- <para>
- The following "in-memory" databases are available. If just evaluating
the capabilities
- of RiftSaw, it is recommended that one of these options is used to reduce the
- time taken to get RiftSaw up and running.
- </para>
-
- <orderedlist>
- <listitem>hsql</listitem>
- </orderedlist>
-
- <para>
- Other databases available, that require further configuration details, include:
- </para>
-
- <orderedlist>
- <listitem>mysql</listitem>
- <listitem>postgres</listitem>
- <listitem>oracle</listitem>
- <listitem>sqlserver</listitem>
- </orderedlist>
-
- <para>
- The configuration properties for these database options can be found in the
- <filename>${RiftSaw}/db/jdbc</filename> folder. These properties need
to be
- specified before executing the <command>ant deploy
-Ddatabase=...</command>
- command.
- </para>
- </section>
-
- <section>
- <title>Upgrade web service for JBoss AS</title>
- <para>
- If you want to upgrade the web service stack for JBoss AS, in the
${RiftSaw}/install folder, just run command as following:
- <command>ant deploy -Ddatabase=... -Dws.stack=...
-Dws.version=...</command>
- It will help you download the web service stack, and then upgrade it for JBoss
AS.
- <itemizedlist>
- <listitem>
+ </listitem>
+
+ <listitem>
+ Install JBossESB
+ <para>
+ This is only required if you want to run the ESB/BPEL examples.
+ </para>
+ <para>
+ Unpack the JBossESB installation into a location alongside the JBossAS
installation.
+ Then follow the instructions in the JBossESB installation
(install/readme.txt), to deploy
+ JBossESB into the JBossAS environment.
+ </para>
+ <warning>
+ <para>
+ If you intend to install the jbossesb, it must be deployed to the
application server
+ before riftsaw.
+ </para>
+ </warning>
+ </listitem>
+
+ <listitem>
+ Install the RiftSaw distribution
+ <para>
+ Unpack the RiftSaw distribution into a location alongside the JBossAS installation.
+ </para>
+ <para>
+ <itemizedlist>
+ <listitem>
+ Edit the <emphasis
role="bold">install/deployment.properties</emphasis> file to update
+ the JBossAS and JBossESB location settings.
+ </listitem>
+ <listitem>
+ From the install folder, run: <command>ant deploy
-Ddatabase=....</command> to deploy
+ RiftSaw to JBossAS. The list of available databases, and how they should be
configured,
+ is explained in the following sub-section.
+ </listitem>
+ <listitem>
+ If JBossESB has been installed, then run: <command>ant
deploy-esb-examples</command> to
+ install the BPEL/ESB examples into the JBossESB samples/quickstart folder.
+ </listitem>
+ </itemizedlist>
+ </para>
+ </listitem>
+ </orderedlist>
+
+ <para>
+ To de-install the RiftSaw distribution,
+ </para>
+ <orderedlist>
+ <listitem>
+ Uninstall the RiftSaw distribution
+ <para>
+ <itemizedlist>
+ <listitem>
+ From the install folder, run: <command>ant undeploy
-Ddatabase=....</command> to remove
+ RiftSaw from JBossAS. The database option should specify the same value used
+ during installation of RiftSaw.
+ </listitem>
+ <listitem>
+ If JBossESB has been installed, then run: <command>ant
undeploy-esb-examples</command> to
+ remove the BPEL/ESB examples from the JBossESB samples/quickstart folder.
+ </listitem>
+ </itemizedlist>
+ </para>
+ </listitem>
+ </orderedlist>
+
+ <para>
+ <tip>
+ In the Hsql database environment, if you install the RiftSaw, we will copy the h2
library into JBoss AS server.
+ But when you undeploy the RiftSaw, we won't delete it. The reason for doing this
is because the JBoss ESB or jBPM will use the h2 database also,
+ if we remove the h2 database in the undeployment process, we might cause JBoss ESB or
jBPM start failed.
+ So if you want to remove the h2 database, please go to the $JBossAS/server/${config}
(like default)/lib, and then remove it manually.
+ </tip>
+ </para>
+
+ <section>
+ <title>Available databases and how to configure them</title>
+
+ <para>
+ The following "in-memory" databases are available. If just evaluating
the capabilities
+ of RiftSaw, it is recommended that one of these options is used to reduce the
+ time taken to get RiftSaw up and running.
+ </para>
+
+ <orderedlist>
+ <listitem>hsql</listitem>
+ </orderedlist>
+
+ <para>
+ Other databases available, that require further configuration details, include:
+ </para>
+
+ <orderedlist>
+ <listitem>mysql</listitem>
+ <listitem>postgres</listitem>
+ <listitem>oracle</listitem>
+ <listitem>sqlserver</listitem>
+ </orderedlist>
+
+ <para>
+ The configuration properties for these database options can be found in the
+ <filename>${RiftSaw}/db/jdbc</filename> folder. These properties need
to be
+ specified before executing the <command>ant deploy
-Ddatabase=...</command>
+ command.
+ </para>
+ </section>
+
+ <section>
+ <title>Upgrade web service for JBoss AS</title>
+ <para>
+ If you want to upgrade the web service stack for JBoss AS, in the
${RiftSaw}/install folder, just run command as following:
+ <command>ant deploy -Ddatabase=... -Dws.stack=...
-Dws.version=...</command>
+ It will help you download the web service stack, and then upgrade it for JBoss
AS.
+ <itemizedlist>
+ <listitem>
Available ws.stack options are: 'native', 'cxf',
'metro'.
- </listitem>
- <listitem>
- Available ws.version options are: '3.2.1.GA', '3.2.2.GA'
- </listitem>
- </itemizedlist>
-
- </para>
- </section>
- </section>
-
-</chapter>
+ </listitem>
+ <listitem>
+ Available ws.version options are: '3.2.1.GA', '3.2.2.GA'
+ </listitem>
+ </itemizedlist>
+
+ </para>
+ </section>
+ </section>
+
+</chapter>
Modified: trunk/integration-tests/pom.xml
===================================================================
--- trunk/integration-tests/pom.xml 2010-05-07 14:29:32 UTC (rev 642)
+++ trunk/integration-tests/pom.xml 2010-05-09 12:19:06 UTC (rev 643)
@@ -278,7 +278,6 @@
<exclude>org/jboss/soa/bpel/tests/samples/TutorialBPELAtmTestCase.java</exclude>
<exclude>org/jboss/soa/bpel/tests/samples/TutorialBPELPurchaseTestCase.java</exclude>
<exclude>org/jboss/soa/bpel/tests/samples/TutorialBPELTravelAgencyTestCase.java</exclude>
- <exclude>org/jboss/soa/bpel/tests/tutorials/BluePrint5/BluePrint5TestCase.java</exclude>
</excludes>
</configuration>
<executions>
Modified: trunk/pom.xml
===================================================================
--- trunk/pom.xml 2010-05-07 14:29:32 UTC (rev 642)
+++ trunk/pom.xml 2010-05-09 12:19:06 UTC (rev 643)
@@ -66,7 +66,7 @@
</profiles>
<properties>
- <riftsaw.ode.version>2.1-SNAPSHOT</riftsaw.ode.version>
+ <riftsaw.ode.version>2.1.0-SNAPSHOT</riftsaw.ode.version>
<riftsaw.engine.version>2.0.1-SNAPSHOT</riftsaw.engine.version>
<bpm.console.version>2.1-SNAPSHOT</bpm.console.version>
<commons.logging.version>1.1.1</commons.logging.version>
Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/derby.sql
===================================================================
--- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/derby.sql 2010-05-07
14:29:32 UTC (rev 642)
+++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/derby.sql 2010-05-09
12:19:06 UTC (rev 643)
@@ -19,24 +19,24 @@
create table ODE_SCHEMA_VERSION(VERSION integer);
insert into ODE_SCHEMA_VERSION values (5);
-create table BPEL_ACTIVITY_RECOVERY (ID bigint not null, 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_ACTIVITY_RECOVERY (ID bigint not null, PIID bigint, AID bigint, CHANNEL
varchar(255), REASON varchar(255), DATE_TIME timestamp, DETAILS blob(2G), ACTIONS
varchar(255), RETRIES integer, INSERT_TIME timestamp, MLOCK integer not null, primary key
(ID));
create table BPEL_CORRELATION_PROP (ID bigint not null, 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 not null, 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 not null, CID varchar(255), PROCESS_ID bigint,
INSERT_TIME timestamp, MLOCK integer not null, primary key (ID));
create table BPEL_CORRELATOR_MESSAGE_CKEY (ID bigint not null, CKEY varchar(255),
CORRELATOR_MESSAGE_ID bigint, INSERT_TIME timestamp, MLOCK integer not null, primary key
(ID));
-create table BPEL_EVENT (ID bigint not null, IID bigint, PID bigint, TSTAMP timestamp,
TYPE varchar(255), DETAIL clob(32000), LDATA_ID bigint, SID bigint, INSERT_TIME timestamp,
MLOCK integer not null, primary key (ID));
-create table BPEL_FAULT (ID bigint not null, 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 not null, 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,
INSERT_TIME timestamp, MLOCK integer not null, primary key (ID));
-create table BPEL_MESSAGE (ID bigint not null, MEX bigint, TYPE varchar(255), DATA
bigint, HEADER bigint, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID));
-create table BPEL_MESSAGE_EXCHANGE (ID bigint 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, PIPED_ID varchar(255),
SUBSCRIBER_COUNT integer, INSERT_TIME timestamp, MLOCK integer not null, primary key
(ID));
+create table BPEL_EVENT (ID bigint not null, IID bigint, PID bigint, TSTAMP timestamp,
TYPE varchar(255), DETAIL clob(32000), DATA blob(2G), SID bigint, INSERT_TIME timestamp,
MLOCK integer not null, primary key (ID));
+create table BPEL_FAULT (ID bigint not null, FAULTNAME varchar(255), DATA blob(2G),
EXPLANATION varchar(4000), LINE_NUM integer, AID integer, INSERT_TIME timestamp, MLOCK
integer not null, primary key (ID));
+create table BPEL_INSTANCE (ID bigint not null, INSTANTIATING_CORRELATOR bigint, FAULT
bigint, JACOB_STATE_DATA blob(2G), PREVIOUS_STATE smallint, PROCESS_ID bigint, STATE
smallint, LAST_ACTIVE_DT timestamp, SEQUENCE bigint, FAILURE_COUNT integer, FAILURE_DT
timestamp, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID));
+create table BPEL_MESSAGE (ID bigint not null, MEX bigint, TYPE varchar(255),
MESSAGE_DATA blob(2G), MESSAGE_HEADER blob(2G), INSERT_TIME timestamp, MLOCK integer not
null, primary key (ID));
+create table BPEL_MESSAGE_EXCHANGE (ID bigint not null, PORT_TYPE varchar(255),
CHANNEL_NAME varchar(255), CLIENTKEY varchar(255), ENDPOINT blob(2G), CALLBACK_ENDPOINT
blob(2G), 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, PIPED_ID varchar(255),
SUBSCRIBER_COUNT integer, INSERT_TIME timestamp, 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, 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_PLINK_VAL (ID bigint not null, PARTNER_LINK varchar(100) not null,
PARTNERROLE varchar(100), MYROLE_EPR_DATA blob(2G), PARTNERROLE_EPR_DATA blob(2G), 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 not null, PROCID varchar(255) not null unique,
deployer varchar(255), deploydate timestamp, type_name varchar(255), type_ns varchar(255),
version bigint, ACTIVE_ smallint, guid varchar(255), INSERT_TIME timestamp, MLOCK integer
not null, primary key (ID));
create table BPEL_SCOPE (ID bigint not null, 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 not null, 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, ROUTE_POLICY varchar(255), CORRELATOR bigint not null,
INSERT_TIME timestamp, MLOCK integer not null, primary key (ID), unique (CORRELATION_KEY,
CORRELATOR));
create table BPEL_UNMATCHED (ID bigint not null, 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 not null, LDATA_ID bigint, NAME varchar(255) not
null, SCOPE_ID bigint, PIID bigint, IS_SIMPLE_TYPE smallint, INSERT_TIME timestamp, MLOCK
integer not null, primary key (ID));
-create table LARGE_DATA (ID bigint not null, BIN_DATA blob(2G), INSERT_TIME timestamp,
MLOCK integer not null, primary key (ID));
+create table BPEL_XML_DATA (ID bigint not null, DATA blob(2G), NAME varchar(255) not
null, SCOPE_ID bigint, PIID bigint, IS_SIMPLE_TYPE smallint, INSERT_TIME timestamp, MLOCK
integer not null, primary key (ID));
create table VAR_PROPERTY (ID bigint not null, XML_DATA_ID bigint, PROP_VALUE
varchar(255), PROP_NAME varchar(255) not null, INSERT_TIME timestamp, 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);
@@ -47,6 +47,7 @@
create index IDX_UNMATCHED_CORRELATOR on BPEL_UNMATCHED (CORRELATOR);
create table hibernate_unique_key ( next_hi integer );
insert into hibernate_unique_key values ( 0 );
+
create table STORE_DU (NAME varchar(255) not null, deployer varchar(255), DEPLOYDT
timestamp, DIR varchar(255), primary key (NAME));
create table STORE_PROCESS (PID varchar(255) not null, DU varchar(255), TYPE
varchar(255), version bigint, STATE varchar(255), primary key (PID));
create table STORE_PROCESS_PROP (propId varchar(255) not null, value varchar(255), name
varchar(255) not null, primary key (propId, name));
Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql
===================================================================
--- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql 2010-05-07 14:29:32
UTC (rev 642)
+++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql 2010-05-09 12:19:06
UTC (rev 643)
@@ -19,25 +19,24 @@
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, INSERT_TIME timestamp, MLOCK integer not
null, primary key (ID));
-create table BPEL_MESSAGE (ID bigint generated by default as identity (start with 1), MEX
bigint, 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), 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, PIPED_ID
varchar(255), SUBSCRIBER_COUNT integer, INSERT_TIME timestamp, MLOCK integer not null,
primary key (ID));
+create table BPEL_ACTIVITY_RECOVERY (ID bigint not null, PIID bigint, AID bigint, CHANNEL
varchar(255), REASON varchar(255), DATE_TIME timestamp, DETAILS varbinary, ACTIONS
varchar(255), RETRIES integer, INSERT_TIME timestamp, MLOCK integer not null, primary key
(ID));
+create table BPEL_CORRELATION_PROP (ID bigint not null, 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 not null, 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 not null, CID varchar(255), PROCESS_ID bigint,
INSERT_TIME timestamp, MLOCK integer not null, primary key (ID));
+create table BPEL_CORRELATOR_MESSAGE_CKEY (ID bigint not null, CKEY varchar(255),
CORRELATOR_MESSAGE_ID bigint, INSERT_TIME timestamp, MLOCK integer not null, primary key
(ID));
+create table BPEL_EVENT (ID bigint not null, IID bigint, PID bigint, TSTAMP timestamp,
TYPE varchar(255), DETAIL longvarchar, DATA varbinary, SID bigint, INSERT_TIME timestamp,
MLOCK integer not null, primary key (ID));
+create table BPEL_FAULT (ID bigint not null, FAULTNAME varchar(255), DATA varbinary,
EXPLANATION varchar(4000), LINE_NUM integer, AID integer, INSERT_TIME timestamp, MLOCK
integer not null, primary key (ID));
+create table BPEL_INSTANCE (ID bigint not null, INSTANTIATING_CORRELATOR bigint, FAULT
bigint, JACOB_STATE_DATA varbinary, PREVIOUS_STATE smallint, PROCESS_ID bigint, STATE
smallint, LAST_ACTIVE_DT timestamp, SEQUENCE bigint, FAILURE_COUNT integer, FAILURE_DT
timestamp, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID));
+create table BPEL_MESSAGE (ID bigint not null, MEX bigint, TYPE varchar(255),
MESSAGE_DATA varbinary, MESSAGE_HEADER varbinary, INSERT_TIME timestamp, MLOCK integer not
null, primary key (ID));
+create table BPEL_MESSAGE_EXCHANGE (ID bigint not null, PORT_TYPE varchar(255),
CHANNEL_NAME varchar(255), CLIENTKEY varchar(255), ENDPOINT varbinary, CALLBACK_ENDPOINT
varbinary, 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, PIPED_ID varchar(255),
SUBSCRIBER_COUNT integer, INSERT_TIME timestamp, 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 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, ROUTE_POLICY
varchar(255), 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 varbinary, 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));
+create table BPEL_PLINK_VAL (ID bigint not null, PARTNER_LINK varchar(100) not null,
PARTNERROLE varchar(100), MYROLE_EPR_DATA varbinary, PARTNERROLE_EPR_DATA varbinary,
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 not null, 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 not null, 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 not null, 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, ROUTE_POLICY varchar(255), CORRELATOR bigint not null,
INSERT_TIME timestamp, MLOCK integer not null, primary key (ID), unique (CORRELATION_KEY,
CORRELATOR));
+create table BPEL_UNMATCHED (ID bigint not null, 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 not null, DATA varbinary, 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 VAR_PROPERTY (ID bigint not null, XML_DATA_ID bigint, PROP_VALUE
varchar(255), PROP_NAME varchar(255) not null, INSERT_TIME timestamp, 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);
@@ -45,3 +44,6 @@
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_seqhilo;
+
Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/mysql.sql
===================================================================
--- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/mysql.sql 2010-05-07
14:29:32 UTC (rev 642)
+++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/mysql.sql 2010-05-09
12:19:06 UTC (rev 643)
@@ -22,38 +22,29 @@
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, INSERT_TIME datetime, MLOCK integer not null, primary key (ID));
-create table BPEL_MESSAGE (ID bigint not null auto_increment, MEX bigint, 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, 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, PIPED_ID varchar(255),
SUBSCRIBER_COUNT integer, INSERT_TIME datetime, MLOCK integer not null, primary key
(ID));
+create table BPEL_ACTIVITY_RECOVERY (ID bigint not null, PIID bigint, AID bigint, CHANNEL
varchar(255), REASON varchar(255), DATE_TIME datetime, DETAILS blob, ACTIONS varchar(255),
RETRIES integer, INSERT_TIME datetime, MLOCK integer not null, primary key (ID));
+create table BPEL_CORRELATION_PROP (ID bigint not null, 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, 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, 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, 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, IID bigint, PID bigint, TSTAMP datetime,
TYPE varchar(255), DETAIL longtext, DATA blob, SID bigint, INSERT_TIME datetime, MLOCK
integer not null, primary key (ID));
+create table BPEL_FAULT (ID bigint not null, FAULTNAME varchar(255), DATA blob,
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, INSTANTIATING_CORRELATOR bigint, FAULT
bigint, JACOB_STATE_DATA blob, PREVIOUS_STATE smallint, PROCESS_ID bigint, STATE smallint,
LAST_ACTIVE_DT datetime, SEQUENCE bigint, FAILURE_COUNT integer, FAILURE_DT datetime,
INSERT_TIME datetime, MLOCK integer not null, primary key (ID));
+create table BPEL_MESSAGE (ID bigint not null, MEX bigint, TYPE varchar(255),
MESSAGE_DATA blob, MESSAGE_HEADER blob, INSERT_TIME datetime, MLOCK integer not null,
primary key (ID));
+create table BPEL_MESSAGE_EXCHANGE (ID bigint not null, PORT_TYPE varchar(255),
CHANNEL_NAME varchar(255), CLIENTKEY varchar(255), ENDPOINT blob, CALLBACK_ENDPOINT blob,
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, PIPED_ID varchar(255), SUBSCRIBER_COUNT integer,
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, ROUTE_POLICY varchar(255), 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 table BPEL_PLINK_VAL (ID bigint not null, PARTNER_LINK varchar(100) not null,
PARTNERROLE varchar(100), MYROLE_EPR_DATA blob, PARTNERROLE_EPR_DATA blob, 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, 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, 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, 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, ROUTE_POLICY varchar(255), 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, 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, DATA blob, 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 VAR_PROPERTY (ID bigint not null, 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 indexes
-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 index IDX_XMLDATA_IID on BPEL_XML_DATA (PIID) ;
-create index IDX_XMLDATA_LDATA_ID on BPEL_XML_DATA (LDATA_ID) ;
create index IDX_XMLDATA_SID on BPEL_XML_DATA (SCOPE_ID) ;
create index IDX_XMLDATA_NAME on BPEL_XML_DATA (NAME) ;
create index IDX_XMLDATA_NAME_SID on BPEL_XML_DATA (NAME, SCOPE_ID) ;
@@ -67,25 +58,16 @@
create index IDX_BPEL_PROCESS_TYPE_NS on BPEL_PROCESS (type_ns) ;
create index IDX_BPEL_CORRELATOR_PROCESS_ID on BPEL_CORRELATOR (PROCESS_ID) ;
create index IDX_UNMATCHED_CORRELATOR_CKEY on BPEL_UNMATCHED (CORRELATOR,CORRELATION_KEY)
;
-create index IDX_RECOVERY_LDATAID on BPEL_ACTIVITY_RECOVERY (LDATA_ID) ;
-create index IDX_EVENT_LDATAID on BPEL_EVENT (LDATA_ID) ;
-create index IDX_FAULT_LDATAID on BPEL_FAULT (LDATA_ID) ;
-create index IDX_MESSAGE_LDATAID on BPEL_MESSAGE (DATA) ;
-create index IDX_INSTANCE_LDATAID on BPEL_INSTANCE (JACOB_STATE) ;
-create index IDX_MEXCEPR_LDATAID on BPEL_MESSAGE_EXCHANGE (LDATA_CEPR_ID) ;
-create index IDX_MEXEPR_LDATAID on BPEL_MESSAGE_EXCHANGE (LDATA_EPR_ID) ;
create index IDX_PLINK_VAL_PROCESS_IDX on BPEL_PLINK_VAL (PROCESS) ;
create index IDX_PLINK_VAL_SCOPE on BPEL_PLINK_VAL (SCOPE) ;
-create index IDX_PLINKMYR_LDATAID on BPEL_PLINK_VAL (MYROLE_EPR) ;
-create index IDX_PLINKPR_LDATAID on BPEL_PLINK_VAL (PARTNERROLE_EPR) ;
create index IDX_PLINK_VAL_MODELID on BPEL_PLINK_VAL (MODELID) ;
create index IDX_SELECTOR_INSTANCE on BPEL_SELECTORS (PIID) ;
create index IDX_VARPROP_XMLDATA on VAR_PROPERTY (XML_DATA_ID) ;
create index IDX_VARPROP_NAME on VAR_PROPERTY (PROP_NAME) ;
create index IDX_VARPROP_VALUE on VAR_PROPERTY (PROP_VALUE) ;
create index IDX_UNMATCHED_MEX on BPEL_UNMATCHED (MEX) ;
-create index IDX_MESSAGE_MEX on BPEL_MESSAGE(MEX);
-create index IDX_MESSAGE_EXCHANGE_PIID on BPEL_MESSAGE_EXCHANGE(PIID);
-create index IDX_SCOPE_PIID on BPEL_SCOPE(PIID);
-create index IDX_LARGE_DATA_ID on LARGE_DATA(ID);
-create index IDX_BPEL_MEX_PROPS_MEX on BPEL_MEX_PROPS (MEX) ;
+
+--Indexes for instance deletion
+create index IDX_MESSAGE_MEX on BPEL_MESSAGE(MEX) ;
+create index IDX_MESSAGE_EXCHANGE_PIID on BPEL_MESSAGE_EXCHANGE(PIID) ;
+create index IDX_SCOPE_PIID on BPEL_SCOPE(PIID) ;
Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/oracle.sql
===================================================================
--- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/oracle.sql 2010-05-07
14:29:32 UTC (rev 642)
+++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/oracle.sql 2010-05-09
12:19:06 UTC (rev 643)
@@ -18,48 +18,42 @@
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_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,
DETAILS blob, 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, INSERT_TIME timestamp,
MLOCK number(10,0) not null, primary key (ID));
-create table BPEL_MESSAGE (ID number(19,0) not null, MEX number(19,0), 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, 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),
PIPED_ID varchar2(255 char), SUBSCRIBER_COUNT number(10,0), INSERT_TIME timestamp, MLOCK
number(10,0) not null, primary key (ID));
-create table BPEL_MEX_PROPS (MEX number(19,0) not null, VALUE varchar2(255 char), 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_EVENT (ID number(19,0) not null, IID number(19,0), PID number(19,0),
TSTAMP timestamp, TYPE varchar2(255 char), DETAIL clob, DATA blob, 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), DATA
blob, 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_DATA blob, 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, INSERT_TIME timestamp,
MLOCK number(10,0) not null, primary key (ID));
+create table BPEL_MESSAGE (ID number(19,0) not null, MEX number(19,0), TYPE varchar2(255
char), MESSAGE_DATA blob, MESSAGE_HEADER blob, INSERT_TIME timestamp, MLOCK number(10,0)
not null, primary key (ID));
+create table BPEL_MESSAGE_EXCHANGE (ID number(19,0) not null, PORT_TYPE varchar2(255
char), CHANNEL_NAME varchar2(255 char), CLIENTKEY varchar2(255 char), ENDPOINT blob,
CALLBACK_ENDPOINT blob, 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), PIPED_ID varchar2(255 char),
SUBSCRIBER_COUNT number(10,0), 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_DATA blob, PARTNERROLE_EPR_DATA blob,
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, ROUTE_POLICY
varchar2(255 char), 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, INSERT_TIME timestamp,
MLOCK number(10,0) not null, primary key (ID));
+create table BPEL_XML_DATA (ID number(19,0) not null, DATA blob, 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 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_seqhilo;
-create index IDX_CORRELATOR_CID on BPEL_CORRELATOR (CID) ;
-create index IDX_CKEYxx 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;
-
--create indexes
create index IDX_XMLDATA_IID on BPEL_XML_DATA (PIID) ;
create index IDX_XMLDATA_SID on BPEL_XML_DATA (SCOPE_ID) ;
create index IDX_XMLDATA_NAME on BPEL_XML_DATA (NAME) ;
create index IDX_XMLDATA_NAME_SID on BPEL_XML_DATA (NAME, SCOPE_ID) ;
-
create index IDX_EVENT_IID on BPEL_EVENT (IID) ;
create index IDX_EVENT_PID on BPEL_EVENT (PID) ;
-
-
create index IDX_CORR_SET_NAME on BPEL_CORRELATION_SET (CORR_SET_NAME) ;
create index IDX_CORR_SET_SCOPE_ID on BPEL_CORRELATION_SET (SCOPE_ID) ;
create index IDX_BPEL_INSTANCE_PROCESS_ID on BPEL_INSTANCE (PROCESS_ID) ;
@@ -68,17 +62,8 @@
create index IDX_BPEL_PROCESS_TYPE_NS on BPEL_PROCESS (type_ns) ;
create index IDX_BPEL_CORRELATOR_PROCESS_ID on BPEL_CORRELATOR (PROCESS_ID) ;
create index IDX_UNMATCHED_CORRELATOR_CKEY on BPEL_UNMATCHED (CORRELATOR,CORRELATION_KEY)
;
-create index IDX_RECOVERY_LDATAID on BPEL_ACTIVITY_RECOVERY (LDATA_ID) ;
-create index IDX_EVENT_LDATAID on BPEL_EVENT (LDATA_ID) ;
-create index IDX_FAULT_LDATAID on BPEL_FAULT (LDATA_ID) ;
-create index IDX_MESSAGE_LDATAID on BPEL_MESSAGE (DATA) ;
-create index IDX_INSTANCE_LDATAID on BPEL_INSTANCE (JACOB_STATE) ;
-create index IDX_MEXCEPR_LDATAID on BPEL_MESSAGE_EXCHANGE (LDATA_CEPR_ID) ;
-create index IDX_MEXEPR_LDATAID on BPEL_MESSAGE_EXCHANGE (LDATA_EPR_ID) ;
create index IDX_PLINK_VAL_PROCESS_IDX on BPEL_PLINK_VAL (PROCESS) ;
create index IDX_PLINK_VAL_SCOPE on BPEL_PLINK_VAL (SCOPE) ;
-create index IDX_PLINKMYR_LDATAID on BPEL_PLINK_VAL (MYROLE_EPR) ;
-create index IDX_PLINKPR_LDATAID on BPEL_PLINK_VAL (PARTNERROLE_EPR) ;
create index IDX_PLINK_VAL_MODELID on BPEL_PLINK_VAL (MODELID) ;
create index IDX_SELECTOR_INSTANCE on BPEL_SELECTORS (PIID) ;
create index IDX_VARPROP_XMLDATA on VAR_PROPERTY (XML_DATA_ID) ;
Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/postgres.sql
===================================================================
--- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/postgres.sql 2010-05-07
14:29:32 UTC (rev 642)
+++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/postgres.sql 2010-05-09
12:19:06 UTC (rev 643)
@@ -19,24 +19,23 @@
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_ACTIVITY_RECOVERY (ID int8 not null, PIID int8, AID int8, CHANNEL
varchar(255), REASON varchar(255), DATE_TIME timestamp, DETAILS bytea, 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, INSERT_TIME timestamp,
MLOCK int4 not null, primary key (ID));
-create table BPEL_MESSAGE (ID int8 not null, MEX int8, 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, 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, PIPED_ID varchar(255), SUBSCRIBER_COUNT int4,
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, DATA bytea, SID int8, INSERT_TIME timestamp, MLOCK int4 not
null, primary key (ID));
+create table BPEL_FAULT (ID int8 not null, FAULTNAME varchar(255), DATA bytea,
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_DATA bytea, PREVIOUS_STATE int2, PROCESS_ID int8, STATE int2, LAST_ACTIVE_DT
timestamp, SEQUENCE int8, FAILURE_COUNT int4, FAILURE_DT timestamp, INSERT_TIME timestamp,
MLOCK int4 not null, primary key (ID));
+create table BPEL_MESSAGE (ID int8 not null, MEX int8, TYPE varchar(255), MESSAGE_DATA
bytea, MESSAGE_HEADER bytea, INSERT_TIME timestamp, MLOCK int4 not null, primary key
(ID));
+create table BPEL_MESSAGE_EXCHANGE (ID int8 not null, PORT_TYPE varchar(255),
CHANNEL_NAME varchar(255), CLIENTKEY varchar(255), ENDPOINT bytea, CALLBACK_ENDPOINT
bytea, 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, PIPED_ID varchar(255), SUBSCRIBER_COUNT int4,
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_PLINK_VAL (ID int8 not null, PARTNER_LINK varchar(100) not null,
PARTNERROLE varchar(100), MYROLE_EPR_DATA bytea, PARTNERROLE_EPR_DATA bytea, 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, ROUTE_POLICY varchar(255), 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 bytea, INSERT_TIME timestamp, MLOCK
int4 not null, primary key (ID));
+create table BPEL_XML_DATA (ID int8 not null, DATA bytea, 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 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);
@@ -46,13 +45,11 @@
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;
+create sequence hibernate_seqhilo;
-
--create indexes
create index IDX_XMLDATA_IID on BPEL_XML_DATA (PIID) ;
-create index IDX_XMLDATA_LDATA_ID on BPEL_XML_DATA (LDATA_ID) ;
create index IDX_XMLDATA_SID on BPEL_XML_DATA (SCOPE_ID) ;
create index IDX_XMLDATA_NAME on BPEL_XML_DATA (NAME) ;
create index IDX_XMLDATA_NAME_SID on BPEL_XML_DATA (NAME, SCOPE_ID) ;
@@ -66,25 +63,16 @@
create index IDX_BPEL_PROCESS_TYPE_NS on BPEL_PROCESS (type_ns) ;
create index IDX_BPEL_CORRELATOR_PROCESS_ID on BPEL_CORRELATOR (PROCESS_ID) ;
create index IDX_UNMATCHED_CORRELATOR_CKEY on BPEL_UNMATCHED (CORRELATOR,CORRELATION_KEY)
;
-create index IDX_RECOVERY_LDATAID on BPEL_ACTIVITY_RECOVERY (LDATA_ID) ;
-create index IDX_EVENT_LDATAID on BPEL_EVENT (LDATA_ID) ;
-create index IDX_FAULT_LDATAID on BPEL_FAULT (LDATA_ID) ;
-create index IDX_MESSAGE_LDATAID on BPEL_MESSAGE (DATA) ;
-create index IDX_INSTANCE_LDATAID on BPEL_INSTANCE (JACOB_STATE) ;
-create index IDX_MEXCEPR_LDATAID on BPEL_MESSAGE_EXCHANGE (LDATA_CEPR_ID) ;
-create index IDX_MEXEPR_LDATAID on BPEL_MESSAGE_EXCHANGE (LDATA_EPR_ID) ;
create index IDX_PLINK_VAL_PROCESS_IDX on BPEL_PLINK_VAL (PROCESS) ;
create index IDX_PLINK_VAL_SCOPE on BPEL_PLINK_VAL (SCOPE) ;
-create index IDX_PLINKMYR_LDATAID on BPEL_PLINK_VAL (MYROLE_EPR) ;
-create index IDX_PLINKPR_LDATAID on BPEL_PLINK_VAL (PARTNERROLE_EPR) ;
create index IDX_PLINK_VAL_MODELID on BPEL_PLINK_VAL (MODELID) ;
create index IDX_SELECTOR_INSTANCE on BPEL_SELECTORS (PIID) ;
create index IDX_VARPROP_XMLDATA on VAR_PROPERTY (XML_DATA_ID) ;
create index IDX_VARPROP_NAME on VAR_PROPERTY (PROP_NAME) ;
create index IDX_VARPROP_VALUE on VAR_PROPERTY (PROP_VALUE) ;
create index IDX_UNMATCHED_MEX on BPEL_UNMATCHED (MEX) ;
-create index IDX_MESSAGE_MEX on BPEL_MESSAGE(MEX);
-create index IDX_MESSAGE_EXCHANGE_PIID on BPEL_MESSAGE_EXCHANGE(PIID);
-create index IDX_SCOPE_PIID on BPEL_SCOPE(PIID);
-create index IDX_LARGE_DATA_ID on LARGE_DATA(ID);
-create index IDX_BPEL_MEX_PROPS_MEX on BPEL_MEX_PROPS (MEX) ;
+
+--Indexes for instance deletion
+create index IDX_MESSAGE_MEX on BPEL_MESSAGE(MEX) ;
+create index IDX_MESSAGE_EXCHANGE_PIID on BPEL_MESSAGE_EXCHANGE(PIID) ;
+create index IDX_SCOPE_PIID on BPEL_SCOPE(PIID) ;
\ No newline at end of file
Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sqlserver.sql
===================================================================
--- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sqlserver.sql 2010-05-07
14:29:32 UTC (rev 642)
+++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sqlserver.sql 2010-05-09
12:19:06 UTC (rev 643)
@@ -19,25 +19,24 @@
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, INSERT_TIME datetime null, MLOCK int not null, primary key
(ID));
-create table BPEL_MESSAGE (ID numeric(19,0) identity not null, MEX numeric(19,0) 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, 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, PIPED_ID varchar(255) null, SUBSCRIBER_COUNT int null,
INSERT_TIME datetime null, MLOCK int not null, primary key (ID));
+create table BPEL_ACTIVITY_RECOVERY (ID numeric(19,0) not null, PIID numeric(19,0) null,
AID numeric(19,0) null, CHANNEL varchar(255) null, REASON varchar(255) null, DATE_TIME
datetime null, DETAILS image 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) 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) 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) 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) 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) not null, IID numeric(19,0) null, PID
numeric(19,0) null, TSTAMP datetime null, TYPE varchar(255) null, DETAIL text null, DATA
image 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) not null, FAULTNAME varchar(255) null, DATA
image 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) not null, INSTANTIATING_CORRELATOR
numeric(19,0) null, FAULT numeric(19,0) null, JACOB_STATE_DATA image 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,
INSERT_TIME datetime null, MLOCK int not null, primary key (ID));
+create table BPEL_MESSAGE (ID numeric(19,0) not null, MEX numeric(19,0) null, TYPE
varchar(255) null, MESSAGE_DATA image null, MESSAGE_HEADER image null, INSERT_TIME
datetime null, MLOCK int not null, primary key (ID));
+create table BPEL_MESSAGE_EXCHANGE (ID numeric(19,0) not null, PORT_TYPE varchar(255)
null, CHANNEL_NAME varchar(255) null, CLIENTKEY varchar(255) null, ENDPOINT image null,
CALLBACK_ENDPOINT image 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,
PIPED_ID varchar(255) null, SUBSCRIBER_COUNT int 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, ROUTE_POLICY varchar(255) 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 image 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 table BPEL_PLINK_VAL (ID numeric(19,0) not null, PARTNER_LINK varchar(100) not
null, PARTNERROLE varchar(100) null, MYROLE_EPR_DATA image null, PARTNERROLE_EPR_DATA
image 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) 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) 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) 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, ROUTE_POLICY varchar(255) 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) 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) not null, DATA image 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 VAR_PROPERTY (ID numeric(19,0) 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);
@@ -45,18 +44,17 @@
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 table hibernate_unique_key ( next_hi int );
+insert into hibernate_unique_key values ( 0 );
--- create indexes.
+--create indexes
create index IDX_XMLDATA_IID on BPEL_XML_DATA (PIID) ;
create index IDX_XMLDATA_SID on BPEL_XML_DATA (SCOPE_ID) ;
create index IDX_XMLDATA_NAME on BPEL_XML_DATA (NAME) ;
create index IDX_XMLDATA_NAME_SID on BPEL_XML_DATA (NAME, SCOPE_ID) ;
-
create index IDX_EVENT_IID on BPEL_EVENT (IID) ;
create index IDX_EVENT_PID on BPEL_EVENT (PID) ;
-
-
create index IDX_CORR_SET_NAME on BPEL_CORRELATION_SET (CORR_SET_NAME) ;
create index IDX_CORR_SET_SCOPE_ID on BPEL_CORRELATION_SET (SCOPE_ID) ;
create index IDX_BPEL_INSTANCE_PROCESS_ID on BPEL_INSTANCE (PROCESS_ID) ;
@@ -65,17 +63,8 @@
create index IDX_BPEL_PROCESS_TYPE_NS on BPEL_PROCESS (type_ns) ;
create index IDX_BPEL_CORRELATOR_PROCESS_ID on BPEL_CORRELATOR (PROCESS_ID) ;
create index IDX_UNMATCHED_CORRELATOR_CKEY on BPEL_UNMATCHED (CORRELATOR,CORRELATION_KEY)
;
-create index IDX_RECOVERY_LDATAID on BPEL_ACTIVITY_RECOVERY (LDATA_ID) ;
-create index IDX_EVENT_LDATAID on BPEL_EVENT (LDATA_ID) ;
-create index IDX_FAULT_LDATAID on BPEL_FAULT (LDATA_ID) ;
-create index IDX_MESSAGE_LDATAID on BPEL_MESSAGE (DATA) ;
-create index IDX_INSTANCE_LDATAID on BPEL_INSTANCE (JACOB_STATE) ;
-create index IDX_MEXCEPR_LDATAID on BPEL_MESSAGE_EXCHANGE (LDATA_CEPR_ID) ;
-create index IDX_MEXEPR_LDATAID on BPEL_MESSAGE_EXCHANGE (LDATA_EPR_ID) ;
create index IDX_PLINK_VAL_PROCESS_IDX on BPEL_PLINK_VAL (PROCESS) ;
create index IDX_PLINK_VAL_SCOPE on BPEL_PLINK_VAL (SCOPE) ;
-create index IDX_PLINKMYR_LDATAID on BPEL_PLINK_VAL (MYROLE_EPR) ;
-create index IDX_PLINKPR_LDATAID on BPEL_PLINK_VAL (PARTNERROLE_EPR) ;
create index IDX_PLINK_VAL_MODELID on BPEL_PLINK_VAL (MODELID) ;
create index IDX_SELECTOR_INSTANCE on BPEL_SELECTORS (PIID) ;
create index IDX_VARPROP_XMLDATA on VAR_PROPERTY (XML_DATA_ID) ;