[riftsaw-commits] riftsaw SVN: r643 - in trunk: distribution/src/main/release/db/sql and 4 other directories.

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) ;