[riftsaw-commits] riftsaw SVN: r283 - in trunk: console/integration and 13 other directories.

Author: kurtstam Date: 2009-11-19 23:52:19 -0500 (Thu, 19 Nov 2009) New Revision: 283 Added: trunk/runtime/engine-assembly/src/ trunk/runtime/engine-assembly/src/main/ trunk/runtime/engine-assembly/src/main/resources/ trunk/runtime/engine-assembly/src/main/resources/META-INF/ trunk/runtime/engine-assembly/src/main/resources/META-INF/bpel-ds.xml trunk/runtime/engine-assembly/src/main/resources/META-INF/jboss-beans.xml trunk/runtime/engine-assembly/src/main/resources/META-INF/jboss-service.xml trunk/runtime/engine-assembly/src/main/resources/META-INF/jboss-structure.xml trunk/runtime/engine-assembly/src/main/resources/bpel-sql/ 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 trunk/runtime/engine-assembly/src/main/resources/bpel.properties Removed: trunk/runtime/engine-assembly/assembly.xml trunk/runtime/engine-assembly/resources/META-INF/jboss-beans.xml trunk/runtime/engine-assembly/resources/META-INF/jboss-structure.xml trunk/runtime/engine-assembly/resources/bpel-sql/ trunk/runtime/engine-assembly/resources/bpel.properties Modified: trunk/console/integration/pom.xml trunk/distribution/src/main/assembly/bin.xml trunk/pom.xml trunk/runtime/deployer/pom.xml trunk/runtime/engine-assembly/pom.xml trunk/runtime/engine/pom.xml trunk/runtime/engine/src/main/java/org/jboss/soa/bpel/runtime/engine/ode/BindingContextImpl.java trunk/runtime/engine/src/main/java/org/jboss/soa/bpel/runtime/engine/ode/MessageExchangeContextImpl.java trunk/runtime/jbossesb-bpel/pom.xml Log: RIFTSAW-24, building directly from the jars, not using the war. Modified: trunk/console/integration/pom.xml =================================================================== --- trunk/console/integration/pom.xml 2009-11-19 03:04:23 UTC (rev 282) +++ trunk/console/integration/pom.xml 2009-11-20 04:52:19 UTC (rev 283) @@ -46,7 +46,7 @@ <dependency> <groupId>org.apache.xmlbeans</groupId> <artifactId>xmlbeans</artifactId> - <version>2.4.0</version> + <version>2.2.0</version> </dependency> <dependency> @@ -109,6 +109,7 @@ <version>${javax.jaxb.version}</version> <scope>provided</scope> </dependency> + </dependencies> Modified: trunk/distribution/src/main/assembly/bin.xml =================================================================== --- trunk/distribution/src/main/assembly/bin.xml 2009-11-19 03:04:23 UTC (rev 282) +++ trunk/distribution/src/main/assembly/bin.xml 2009-11-20 04:52:19 UTC (rev 283) @@ -62,7 +62,7 @@ </fileSet> <fileSet> - <directory>../runtime/engine-assembly/target/bpel</directory> + <directory>../runtime/engine-assembly/target/riftsaw-2.0-SNAPSHOT/</directory> <outputDirectory>/modules/riftsaw.sar</outputDirectory> </fileSet> @@ -84,7 +84,7 @@ <!-- Short term fix as dependency on riftsaw-utils is not being resolved, so copy from BPEL war instead --> <fileSet> - <directory>../runtime/engine-assembly/target/bpel/bpel.war/WEB-INF/lib</directory> + <directory>../runtime/engine-assembly/target/riftsaw-2.0-SNAPSHOT/lib</directory> <outputDirectory>/samples/common/lib</outputDirectory> <includes> <include>riftsaw-utils-*.jar</include> @@ -143,7 +143,6 @@ <outputDirectory>/samples/common/lib</outputDirectory> <includes> <include>org.jboss.soa.bpel:riftsaw-tools</include> - <include>org.jboss.soa.bpel:riftsaw-utils</include> <include>commons-codec:commons-codec</include> <include>commons-httpclient:commons-httpclient</include> <include>commons-logging:commons-logging</include> @@ -162,14 +161,6 @@ </includes> </dependencySet> - <dependencySet> - <outputDirectory>/modules/shared</outputDirectory> - <outputFileNameMapping>${artifact.artifactId}.${artifact.extension}</outputFileNameMapping> - <includes> - <include>org.apache.xmlbeans:xmlbeans</include> - </includes> - </dependencySet> - </dependencySets> </assembly> Modified: trunk/pom.xml =================================================================== --- trunk/pom.xml 2009-11-19 03:04:23 UTC (rev 282) +++ trunk/pom.xml 2009-11-20 04:52:19 UTC (rev 283) @@ -66,12 +66,12 @@ </profiles> <properties> - <riftsaw.engine.version>2.0-SNAPSHOT</riftsaw.engine.version> + <riftsaw.engine.version>2.0-M2</riftsaw.engine.version> <bpm.console.version>1.2.0</bpm.console.version> <commons.logging.version>1.1.1</commons.logging.version> <junit.version>3.8.1</junit.version> - <jboss.version>5.0.0.GA</jboss.version> - <log4j.version>1.2.14</log4j.version> + <jboss.version>5.0.0.GA</jboss.version> + <log4j.version>1.2.14</log4j.version> <rosetta.version>4.5</rosetta.version> <wsdl4j.version>1.6.2</wsdl4j.version> </properties> @@ -312,6 +312,20 @@ <name>codehaus repository</name> <url>http://repo1.maven.org/maven2</url> </repository> + + <repository> + <id>apache-nexus</id> + <name>apache nexus</name> + <url>https://repository.apache.org/content/groups/public/</url> + </repository> + + <repository> + <id>intalio</id> + <name>intalio</name> + <url>http://www.intalio.org/public/maven2</url> + </repository> + + Modified: trunk/runtime/deployer/pom.xml =================================================================== --- trunk/runtime/deployer/pom.xml 2009-11-19 03:04:23 UTC (rev 282) +++ trunk/runtime/deployer/pom.xml 2009-11-20 04:52:19 UTC (rev 283) @@ -19,46 +19,55 @@ <groupId>org.jboss</groupId> <artifactId>jboss-common-core</artifactId> <version>2.2.14.GA</version> + <scope>provided</scope> </dependency> <dependency> <groupId>org.jboss.deployers</groupId> <artifactId>jboss-deployers-spi</artifactId> <version>2.0.7.GA</version> + <scope>provided</scope> </dependency> <dependency> <groupId>org.jboss.deployers</groupId> <artifactId>jboss-deployers-structure-spi</artifactId> <version>2.0.7.GA</version> + <scope>provided</scope> </dependency> <dependency> <groupId>org.jboss.deployers</groupId> <artifactId>jboss-deployers-core-spi</artifactId> <version>2.0.7.GA</version> + <scope>provided</scope> </dependency> <dependency> <groupId>org.jboss.deployers</groupId> <artifactId>jboss-deployers-client-spi</artifactId> <version>2.0.7.GA</version> + <scope>provided</scope> </dependency> <dependency> <groupId>org.jboss.deployers</groupId> <artifactId>jboss-deployers-vfs-spi</artifactId> <version>2.0.7.GA</version> + <scope>provided</scope> </dependency> <dependency> <groupId>org.jboss</groupId> <artifactId>jboss-vfs</artifactId> <version>2.1.2.GA</version> + <scope>provided</scope> </dependency> <dependency> <groupId>org.jboss</groupId> <artifactId>jboss-mdr</artifactId> <version>2.0.2.GA</version> + <scope>provided</scope> </dependency> <dependency> <groupId>org.jboss.logging</groupId> <artifactId>jboss-logging-spi</artifactId> <version>2.1.0.GA</version> + <scope>provided</scope> </dependency> <dependency> <groupId>junit</groupId> Modified: trunk/runtime/engine/pom.xml =================================================================== --- trunk/runtime/engine/pom.xml 2009-11-19 03:04:23 UTC (rev 282) +++ trunk/runtime/engine/pom.xml 2009-11-20 04:52:19 UTC (rev 283) @@ -2,7 +2,7 @@ xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>org.jboss.soa.bpel.runtime</groupId> - <artifactId>engine</artifactId> + <artifactId>riftsaw-engine</artifactId> <packaging>jar</packaging> <version>2.0-SNAPSHOT</version> <name>RiftSaw::Runtime::Engine</name> @@ -18,10 +18,12 @@ <dependency> <groupId>wsdl4j</groupId> <artifactId>wsdl4j</artifactId> + <scope>provided</scope> </dependency> <dependency> <groupId>commons-logging</groupId> <artifactId>commons-logging</artifactId> + <scope>provided</scope> </dependency> <dependency> <groupId>org.jboss.soa.bpel</groupId> @@ -97,12 +99,14 @@ <groupId>javassist</groupId> <artifactId>javassist</artifactId> <version>3.11.0.GA</version> + <scope>provided</scope> </dependency> <dependency> <groupId>javassist</groupId> <artifactId>javassist</artifactId> <version>3.11.0.GA</version> <classifier>sources</classifier> + <scope>provided</scope> </dependency> <dependency> <groupId>javax.xml.ws</groupId> @@ -113,8 +117,8 @@ <dependency> <groupId>org.jboss.jbossas</groupId> <artifactId>jboss-as-system-jmx</artifactId> + <version>${jboss.version}</version> <scope>provided</scope> - <version>${jboss.version}</version> </dependency> <dependency> <groupId>org.jboss.soa.bpel</groupId> @@ -143,8 +147,6 @@ <build> - <finalName>riftsaw-framework</finalName> - <!-- This section defines the default plugin settings inherited by child projects. --> <pluginManagement> <plugins> Modified: trunk/runtime/engine/src/main/java/org/jboss/soa/bpel/runtime/engine/ode/BindingContextImpl.java =================================================================== --- trunk/runtime/engine/src/main/java/org/jboss/soa/bpel/runtime/engine/ode/BindingContextImpl.java 2009-11-19 03:04:23 UTC (rev 282) +++ trunk/runtime/engine/src/main/java/org/jboss/soa/bpel/runtime/engine/ode/BindingContextImpl.java 2009-11-20 04:52:19 UTC (rev 283) @@ -202,7 +202,7 @@ } - @Override + //@Override public long calculateSizeofService(org.apache.ode.bpel.iapi.EndpointReference ref) { return 0; } Modified: trunk/runtime/engine/src/main/java/org/jboss/soa/bpel/runtime/engine/ode/MessageExchangeContextImpl.java =================================================================== --- trunk/runtime/engine/src/main/java/org/jboss/soa/bpel/runtime/engine/ode/MessageExchangeContextImpl.java 2009-11-19 03:04:23 UTC (rev 282) +++ trunk/runtime/engine/src/main/java/org/jboss/soa/bpel/runtime/engine/ode/MessageExchangeContextImpl.java 2009-11-20 04:52:19 UTC (rev 283) @@ -103,7 +103,7 @@ } - @Override + //@Override public void invokePartner(PartnerRoleMessageExchange mex) throws ContextException { if (__log.isDebugEnabled()) @@ -111,7 +111,7 @@ invokePartnerUnreliable(mex); } - @Override + //@Override public void onAsyncReply(MyRoleMessageExchange mex) throws BpelEngineException { if (__log.isDebugEnabled()) Deleted: trunk/runtime/engine-assembly/assembly.xml =================================================================== --- trunk/runtime/engine-assembly/assembly.xml 2009-11-19 03:04:23 UTC (rev 282) +++ trunk/runtime/engine-assembly/assembly.xml 2009-11-20 04:52:19 UTC (rev 283) @@ -1,12 +0,0 @@ -<assembly> - <id></id> - <formats> - <format>zip</format> - </formats> - <fileSets> - <fileSet> - <directory>${project.build.directory}/bpel</directory> - <outputDirectory></outputDirectory> - </fileSet> - </fileSets> -</assembly> Modified: trunk/runtime/engine-assembly/pom.xml =================================================================== --- trunk/runtime/engine-assembly/pom.xml 2009-11-19 03:04:23 UTC (rev 282) +++ trunk/runtime/engine-assembly/pom.xml 2009-11-20 04:52:19 UTC (rev 283) @@ -2,9 +2,9 @@ xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>org.jboss.soa.bpel.runtime</groupId> - <artifactId>bpel.sar</artifactId> + <artifactId>riftsaw</artifactId> <version>2.0-SNAPSHOT</version> - <packaging>pom</packaging> + <packaging>jboss-sar</packaging> <name>RiftSaw::Runtime::Engine-Assembly</name> <parent> @@ -14,28 +14,106 @@ </parent> <dependencies> + <dependency> <groupId>org.jboss.soa.bpel.runtime</groupId> - <artifactId>deployer</artifactId> + <artifactId>riftsaw-engine</artifactId> <version>${version}</version> </dependency> <dependency> - <groupId>org.jboss.soa.bpel.runtime</groupId> - <artifactId>engine</artifactId> - <version>${version}</version> + <groupId>org.jboss.soa.bpel</groupId> + <artifactId>riftsaw-bpel-compiler</artifactId> + <version>${riftsaw.engine.version}</version> </dependency> <dependency> <groupId>org.jboss.soa.bpel</groupId> - <artifactId>jboss-riftsaw-war</artifactId> - <version>${version}</version> - <type>zip</type> + <artifactId>riftsaw-bpel-obj</artifactId> + <version>${riftsaw.engine.version}</version> </dependency> + <dependency> + <groupId>org.jboss.soa.bpel</groupId> + <artifactId>riftsaw-bpel-ql</artifactId> + <version>${riftsaw.engine.version}</version> + </dependency> + <dependency> + <groupId>org.jboss.soa.bpel</groupId> + <artifactId>riftsaw-bpel-schemas</artifactId> + <version>${riftsaw.engine.version}</version> + </dependency> + <dependency> + <groupId>org.jboss.soa.bpel</groupId> + <artifactId>riftsaw-dao-hibernate</artifactId> + <version>${riftsaw.engine.version}</version> + </dependency> + <dependency> + <groupId>org.jboss.soa.bpel</groupId> + <artifactId>riftsaw-jacob</artifactId> + <version>${riftsaw.engine.version}</version> + </dependency> + <dependency> + <groupId>org.apache.xmlbeans</groupId> + <artifactId>xmlbeans</artifactId> + <version>2.2.0</version> + <exclusions> + <exclusion> + <groupId>stax</groupId> + <artifactId>stax-api</artifactId> + </exclusion> + </exclusions> + </dependency> + <!-- do we really need the following dependencies? --> + <dependency> + <groupId>commons-lang</groupId> + <artifactId>commons-lang</artifactId> + <version>2.3</version> + </dependency> + + <dependency> + <groupId>org.apache.geronimo.components</groupId> + <artifactId>geronimo-connector</artifactId> + <version>2.0.1</version> + <scope>runtime</scope> + <exclusions> + <exclusion><groupId>commons-logging</groupId><artifactId>commons-logging</artifactId></exclusion> + <exclusion><groupId>org.apache.geronimo.specs</groupId><artifactId>geronimo-j2ee-connector_1.5_spec</artifactId></exclusion> + <exclusion><groupId>org.apache.geronimo.specs</groupId><artifactId>geronimo-jta_1.1_spec</artifactId></exclusion> + <exclusion><groupId>org.apache.geronimo.modules</groupId><artifactId>geronimo-transaction</artifactId></exclusion> + <exclusion><groupId>org.objectweb.howl</groupId><artifactId>howl</artifactId></exclusion> + </exclusions> + </dependency> + + <dependency> + <groupId>net.sf.saxon</groupId> + <artifactId>saxon-dom</artifactId> + <version>9.x</version> + </dependency> + <dependency> + <groupId>net.sf.saxon</groupId> + <artifactId>saxon-xpath</artifactId> + <version>9.x</version> + </dependency> + <dependency> + <groupId>net.sf.saxon</groupId> + <artifactId>saxon-xqj</artifactId> + <version>9.x</version> + </dependency> + <dependency> + <groupId>net.sf.saxon</groupId> + <artifactId>saxon</artifactId> + <version>9.x</version> + </dependency> + </dependencies> <build> - <finalName>riftsaw.sar</finalName> <plugins> <plugin> + <groupId>org.codehaus.mojo</groupId> + <artifactId>jboss-packaging-maven-plugin</artifactId> + <!-- Enable 'jboss-sar', etc., as a recognized maven packaging type --> + <extensions>true</extensions> + </plugin> + <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-install-plugin</artifactId> <version>2.1</version> @@ -50,23 +128,8 @@ <phase>package</phase> <configuration> <tasks> - <property name="compile_classpath" refid="maven.compile.classpath" /> - <property name="runtime_classpath" refid="maven.runtime.classpath" /> - <property name="test_classpath" refid="maven.test.classpath" /> - <property name="plugin_classpath" refid="maven.plugin.classpath" /> - <property name="project.version" value="${project.version}" /> - <property name="local.repo" value="${settings.localRepository}" /> - <property name="riftsaw.engine.version" - value="${riftsaw.engine.version}" /> - <property name="dependency.bpel.deployer" - value="${maven.dependency.org.jboss.soa.bpel.runtime.deployer.jar.path}" /> - <property name="dependency.bpel.engine" - value="${maven.dependency.org.jboss.soa.bpel.runtime.engine.jar.path}" /> - <property name="dependency.bpel.jb-bpel-store" - value="${maven.dependency.org.jboss.soa.bpel.runtime.jb-bpel-store.jar.path}" /> - <ant antfile="${basedir}/build.xml"> - <target name="package-bpel" /> - </ant> + <delete file="${basedir}/target/riftsaw-2.0-SNAPSHOT/META-INF/jboss-service.xml"/> + <delete file="${basedir}/target/riftsaw-2.0-SNAPSHOT/lib/geronimo-transaction-2.0.1.jar"/> </tasks> </configuration> <goals> @@ -75,25 +138,6 @@ </execution> </executions> </plugin> - <plugin> - <groupId>org.apache.maven.plugins</groupId> - <artifactId>maven-assembly-plugin</artifactId> - <version>2.2-beta-3</version> - <executions> - <execution> - <id>make-assembly</id> - <phase>package</phase> - <goals> - <goal>attached</goal> - </goals> - <configuration> - <descriptors> - <descriptor>${basedir}/assembly.xml</descriptor> - </descriptors> - </configuration> - </execution> - </executions> - </plugin> </plugins> </build> </project> \ No newline at end of file Deleted: trunk/runtime/engine-assembly/resources/META-INF/jboss-beans.xml =================================================================== --- trunk/runtime/engine-assembly/resources/META-INF/jboss-beans.xml 2009-11-19 03:04:23 UTC (rev 282) +++ trunk/runtime/engine-assembly/resources/META-INF/jboss-beans.xml 2009-11-20 04:52:19 UTC (rev 283) @@ -1,42 +0,0 @@ -<?xml version="1.0" encoding="UTF-8"?> -<deployment xmlns="urn:jboss:bean-deployer:2.0"> - - <bean class="org.jboss.soa.bpel.runtime.db.DatabaseInitializer" - name="BPELDatabaseInitializer"> - <property name="datasource"><value>java:/BPELDB</value></property> - <property name="existsSql"><value>select * from ODE_JOB</value></property> - <property name="sqlFiles"><value>bpel-sql/hsql.sql</value></property> - <property name="useEOL"><value>false</value></property> - <depends>jboss.jca:service=DataSourceBinding,name=BPELDB</depends> - </bean> - - <bean class="org.jboss.soa.bpel.runtime.engine.service.BPELEngineService" - name="BPELEngine"> - <annotation>@org.jboss.aop.microcontainer.aspects.jmx.JMX(name="jboss.bpel:service=BPELEngine", exposedInterface=org.jboss.soa.bpel.runtime.engine.service.BPELEngineServiceMBean.class,registerDirectly=true)</annotation> - <property name="jndiName"><value>bpel/Engine</value></property> - <depends>jboss:service=Naming</depends> - <depends>BPELDatabaseInitializer</depends> - <depends>BPELDeployer</depends> - </bean> - - <!-- - Locate the single instance of the kernel - --> - <bean name="org.jboss.soa.bpel.runtime.util:service=KernelLocator" - class="org.jboss.soa.bpel.runtime.integration.KernelLocator"> - <property name="kernel"> - <inject bean="jboss.kernel:service=Kernel" /> - </property> - </bean> - - <!-- - ServerConfig - --> - <bean name="org.jboss.soa.bpel.runtime.util:service=ServerConfig" - class="org.jboss.soa.bpel.runtime.integration.ServerConfigImpl"> - <property name="mbeanServer"><inject bean="JMXKernel" property="mbeanServer"/></property> - <property name="webServiceHost">${jboss.bind.address}</property> - </bean> - - -</deployment> Deleted: trunk/runtime/engine-assembly/resources/META-INF/jboss-structure.xml =================================================================== --- trunk/runtime/engine-assembly/resources/META-INF/jboss-structure.xml 2009-11-19 03:04:23 UTC (rev 282) +++ trunk/runtime/engine-assembly/resources/META-INF/jboss-structure.xml 2009-11-20 04:52:19 UTC (rev 283) @@ -1,14 +0,0 @@ -<?xml version="1.0" encoding="UTF-8"?> -<structure> - <context> - <path name=""/> - <metaDataPath> - <path name="META-INF"/> - </metaDataPath> - <classpath> - <path name=""/> - <path name="" suffixes=".jar" /> - <path name="lib" suffixes=".jar" /> - </classpath> - </context> -</structure> Deleted: trunk/runtime/engine-assembly/resources/bpel.properties =================================================================== --- trunk/runtime/engine-assembly/resources/bpel.properties 2009-11-19 03:04:23 UTC (rev 282) +++ trunk/runtime/engine-assembly/resources/bpel.properties 2009-11-20 04:52:19 UTC (rev 283) @@ -1,101 +0,0 @@ -# -# Licensed to the Apache Software Foundation (ASF) under one -# or more contributor license agreements. See the NOTICE file -# distributed with this work for additional information -# regarding copyright ownership. The ASF licenses this file -# to you under the Apache License, Version 2.0 (the -# "License"); you may not use this file except in compliance -# with the License. You may obtain a copy of the License at -# -# http://www.apache.org/licenses/LICENSE-2.0 -# -# Unless required by applicable law or agreed to in writing, -# software distributed under the License is distributed on an -# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY -# KIND, either express or implied. See the License for the -# specific language governing permissions and limitations -# under the License. -# - -## bpel Configuraiton Properties - -## Database Mode ("INTERNAL", "EXTERNAL", "EMBEDDED") -## What kind of database should ODE use? -## * "EMBEDDED" - ODE will create its own embbeded database (Derby) -## and connection pool (Minerva). -## * "EXTERNAL" - ODE will use an app-server provided database and pool. -## The "ode-jbi.db.ext.dataSource" property will need to -## be set. -## * "INTERNAL" - ODE will create its own connection pool for a user- -## specified JDBC URL and driver. -#bpel.db.mode=EMBEDDED - -## External Database [JNDI Name] -## JNDI Name of the DataSource for the ODE database. This is only -## used if the "ode-jbi.db.mode" property is set to "EXTERNAL" -#bpel.db.ext.dataSource=java:comp/env/jdbc/ode - -## Embedded Database Name [String] -## Name of the embedded Derby database. This is only used if the -## "ode-jbi.db.mode" property is set to "EMBEDDED". -#ode-jbi.db.emb.name=hibdb -#ode-jbi.db.emb.name=jpadb - -## Internal Database Configuration -#ode-jbi.db.int.jdbcurl=jdbc:mysql://localhost/ode?user=sa -#ode-jbi.db.int.driver=com.mysql.jdbc.Driver -#bpel.db.int.password = -#bpel.db.int.username = - -## DB Pool Configuration for internal DB -#bpel.db.pool.max = 10 -#bpel.db.pool.min = 1 - -## DAO Connection Factory class. -## uncomment the following for hibernate. -bpel.dao.factory=org.apache.ode.daohib.bpel.BpelDAOConnectionFactoryImpl - -## Transaction Factory -## default is org.apache.ode.il.EmbeddedGeronimoFactory -## available alternatives are: -## org.apache.ode.axis2.util.GeronimoFactory -## org.apache.ode.axis2.util.JBossFactory -## org.apache.ode.axis2.util.TomcatFactory - -## org.apache.ode.axis2.util.WLSFactory -bpel.tx.factory.class = org.jboss.soa.bpel.runtime.engine.ode.JBossTransactionFactory - -## JCA connector port (default 2099), set to 0 to disable JCA connector -#bpel.jca.port = - -## JCA conncetor name (default 'ode') -#bpel.jca.name = - -## Working dir -#bpel.working.dir = - -## MEX Interceptors -#bpel.mex.interceptors = - -## Process dehydration -#bpel.process.dehydration = - -## Extension Bundles -## FQCNs, comma separated. -#bpel.extension.bundles.runtime = -#bpel.extension.bundles.validation = - -bpel.db.mode=EXTERNAL -bpel.db.ext.dataSource=java:BPELDB - -hibernate.dialect=org.hibernate.dialect.H2Dialect -hibernate.hbm2ddl.auto=update -hibernate.current_session_context_class=jta -hibernate.transaction.manager_lookup_class=org.hibernate.transaction.JBossTransactionManagerLookup - -jta.UserTransaction=UserTransaction - -ode.persistence=hibernate - -ode.process.checkguid=false -ode.process.store=org.apache.ode.store.JBossProcessStoreImpl Property changes on: trunk/runtime/engine-assembly/src/main ___________________________________________________________________ Name: svn:mergeinfo + Added: trunk/runtime/engine-assembly/src/main/resources/META-INF/bpel-ds.xml =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/META-INF/bpel-ds.xml (rev 0) +++ trunk/runtime/engine-assembly/src/main/resources/META-INF/bpel-ds.xml 2009-11-20 04:52:19 UTC (rev 283) @@ -0,0 +1,24 @@ +<?xml version="1.0" encoding="UTF-8"?> + + +<datasources> + <local-tx-datasource> + <jndi-name>BPELDB</jndi-name> + <connection-url>jdbc:h2:${jboss.server.data.dir}${/}h2${/}BPELDB</connection-url> + <driver-class>org.h2.Driver</driver-class> + <user-name>sa</user-name> + <password/> + <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> + <min-pool-size>5</min-pool-size> + <max-pool-size>20</max-pool-size> + <idle-timeout-minutes>0</idle-timeout-minutes> + <prepared-statement-cache-size>32</prepared-statement-cache-size> + <depends>jboss:service=h2,database=BPELDB</depends> + </local-tx-datasource> + <mbean code="org.jboss.internal.soa.esb.dependencies.H2Database" + name="jboss:service=h2,database=BPELDB"> + <attribute name="Database">BPELDB</attribute> + <attribute name="DataDir">${jboss.server.data.dir}</attribute> + </mbean> + +</datasources> Added: trunk/runtime/engine-assembly/src/main/resources/META-INF/jboss-beans.xml =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/META-INF/jboss-beans.xml (rev 0) +++ trunk/runtime/engine-assembly/src/main/resources/META-INF/jboss-beans.xml 2009-11-20 04:52:19 UTC (rev 283) @@ -0,0 +1,42 @@ +<?xml version="1.0" encoding="UTF-8"?> +<deployment xmlns="urn:jboss:bean-deployer:2.0"> + + <bean class="org.jboss.soa.bpel.runtime.db.DatabaseInitializer" + name="BPELDatabaseInitializer"> + <property name="datasource"><value>java:/BPELDB</value></property> + <property name="existsSql"><value>select * from ODE_JOB</value></property> + <property name="sqlFiles"><value>bpel-sql/hsql.sql</value></property> + <property name="useEOL"><value>false</value></property> + <depends>jboss.jca:service=DataSourceBinding,name=BPELDB</depends> + </bean> + + <bean class="org.jboss.soa.bpel.runtime.engine.service.BPELEngineService" + name="BPELEngine"> + <annotation>@org.jboss.aop.microcontainer.aspects.jmx.JMX(name="jboss.bpel:service=BPELEngine", exposedInterface=org.jboss.soa.bpel.runtime.engine.service.BPELEngineServiceMBean.class,registerDirectly=true)</annotation> + <property name="jndiName"><value>bpel/Engine</value></property> + <depends>jboss:service=Naming</depends> + <depends>BPELDatabaseInitializer</depends> + <depends>BPELDeployer</depends> + </bean> + + <!-- + Locate the single instance of the kernel + --> + <bean name="org.jboss.soa.bpel.runtime.util:service=KernelLocator" + class="org.jboss.soa.bpel.runtime.integration.KernelLocator"> + <property name="kernel"> + <inject bean="jboss.kernel:service=Kernel" /> + </property> + </bean> + + <!-- + ServerConfig + --> + <bean name="org.jboss.soa.bpel.runtime.util:service=ServerConfig" + class="org.jboss.soa.bpel.runtime.integration.ServerConfigImpl"> + <property name="mbeanServer"><inject bean="JMXKernel" property="mbeanServer"/></property> + <property name="webServiceHost">${jboss.bind.address}</property> + </bean> + + +</deployment> Added: trunk/runtime/engine-assembly/src/main/resources/META-INF/jboss-service.xml =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/META-INF/jboss-service.xml (rev 0) +++ trunk/runtime/engine-assembly/src/main/resources/META-INF/jboss-service.xml 2009-11-20 04:52:19 UTC (rev 283) @@ -0,0 +1,11 @@ +<?xml version="1.0" encoding="UTF-8"?> + +<server> +<!-- This file is only here to satisfy the jboss-packaging-maven-plugin. + Does someone know if there is a setting to avoid needing this file? + Or does this require a new version of the plugin? + + This file is going to be deleted by the ant plugin + --> + +</server> \ No newline at end of file Added: trunk/runtime/engine-assembly/src/main/resources/META-INF/jboss-structure.xml =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/META-INF/jboss-structure.xml (rev 0) +++ trunk/runtime/engine-assembly/src/main/resources/META-INF/jboss-structure.xml 2009-11-20 04:52:19 UTC (rev 283) @@ -0,0 +1,14 @@ +<?xml version="1.0" encoding="UTF-8"?> +<structure> + <context> + <path name=""/> + <metaDataPath> + <path name="META-INF"/> + </metaDataPath> + <classpath> + <path name=""/> + <path name="" suffixes=".jar" /> + <path name="lib" suffixes=".jar" /> + </classpath> + </context> +</structure> Added: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/derby.sql =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/derby.sql (rev 0) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/derby.sql 2009-11-20 04:52:19 UTC (rev 283) @@ -0,0 +1,53 @@ +-- Apache ODE - SimpleScheduler Database Schema +-- +-- Apache Derby scripts by Maciej Szefler. +-- +-- + +CREATE TABLE ode_job ( + jobid CHAR(64) NOT NULL DEFAULT '', + ts BIGINT NOT NULL DEFAULT 0, + nodeid char(64), + scheduled int NOT NULL DEFAULT 0, + transacted int NOT NULL DEFAULT 0, + details blob(4096), + PRIMARY KEY(jobid)); + +CREATE INDEX IDX_ODE_JOB_TS ON ode_job(ts); +CREATE INDEX IDX_ODE_JOB_NODEID ON ode_job(nodeid); + + +create table 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_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_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_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 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); +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 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)); +create table STORE_VERSIONS (ID integer not null, VERSION bigint, primary key (ID)); Added: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql (rev 0) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql 2009-11-20 04:52:19 UTC (rev 283) @@ -0,0 +1,47 @@ +create table ODE_SCHEMA_VERSION(VERSION integer); +insert into ODE_SCHEMA_VERSION values (5); +-- Apache ODE - SimpleScheduler Database Schema +-- +-- Apache Derby scripts by Maciej Szefler. +-- +-- + +CREATE TABLE ode_job ( + jobid CHAR(64) NOT NULL DEFAULT '', + ts BIGINT NOT NULL DEFAULT 0, + nodeid char(64), + scheduled int NOT NULL DEFAULT 0, + transacted int NOT NULL DEFAULT 0, + details blob(4096), + PRIMARY KEY(jobid)); + +CREATE INDEX IDX_ODE_JOB_TS ON ode_job(ts); +CREATE INDEX IDX_ODE_JOB_NODEID ON ode_job(nodeid); + + +create table BPEL_ACTIVITY_RECOVERY (ID bigint generated by default as identity (start with 1), PIID bigint, AID bigint, CHANNEL varchar(255), REASON varchar(255), DATE_TIME timestamp, LDATA_ID bigint, ACTIONS varchar(255), RETRIES integer, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); +create table BPEL_CORRELATION_PROP (ID bigint generated by default as identity (start with 1), NAME varchar(255), NAMESPACE varchar(255), VALUE varchar(255), CORR_SET_ID bigint, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); +create table BPEL_CORRELATION_SET (ID bigint generated by default as identity (start with 1), VALUE varchar(255), CORR_SET_NAME varchar(255), SCOPE_ID bigint, PIID bigint, PROCESS_ID bigint, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); +create table BPEL_CORRELATOR (ID bigint generated by default as identity (start with 1), CID varchar(255), PROCESS_ID bigint, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); +create table BPEL_CORRELATOR_MESSAGE_CKEY (ID bigint generated by default as identity (start with 1), CKEY varchar(255), CORRELATOR_MESSAGE_ID bigint, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); +create table BPEL_EVENT (ID bigint generated by default as identity (start with 1), IID bigint, PID bigint, TSTAMP timestamp, TYPE varchar(255), DETAIL longvarchar, LDATA_ID bigint, SID bigint, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); +create table BPEL_FAULT (ID bigint generated by default as identity (start with 1), FAULTNAME varchar(255), LDATA_ID bigint, EXPLANATION varchar(4000), LINE_NUM integer, AID integer, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); +create table BPEL_INSTANCE (ID bigint generated by default as identity (start with 1), INSTANTIATING_CORRELATOR bigint, FAULT bigint, JACOB_STATE bigint, PREVIOUS_STATE smallint, PROCESS_ID bigint, STATE smallint, LAST_ACTIVE_DT timestamp, SEQUENCE bigint, FAILURE_COUNT integer, FAILURE_DT timestamp, 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_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 blob(2G), INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); +create table VAR_PROPERTY (ID bigint generated by default as identity (start with 1), XML_DATA_ID bigint, PROP_VALUE varchar(255), PROP_NAME varchar(255) not null, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); +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); Added: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/mysql.sql =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/mysql.sql (rev 0) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/mysql.sql 2009-11-20 04:52:19 UTC (rev 283) @@ -0,0 +1,50 @@ +create table ODE_SCHEMA_VERSION(VERSION integer); +insert into ODE_SCHEMA_VERSION values (5); +-- Apache ODE - SimpleScheduler Database Schema +-- +-- MySQL scripts by Maciej Szefler. +-- +-- +DROP TABLE IF EXISTS ODE_JOB; + +CREATE TABLE ODE_JOB ( + jobid CHAR(64) NOT NULL DEFAULT '', + ts BIGINT NOT NULL DEFAULT 0, + nodeid char(64) NULL, + scheduled int NOT NULL DEFAULT 0, + transacted int NOT NULL DEFAULT 0, + details blob(4096) NULL, + PRIMARY KEY(jobid), + INDEX IDX_ODE_JOB_TS(ts), + INDEX IDX_ODE_JOB_NODEID(nodeid) +) +TYPE=InnoDB; + +COMMIT; + +create table BPEL_ACTIVITY_RECOVERY (ID bigint not null auto_increment, PIID bigint, AID bigint, CHANNEL varchar(255), REASON varchar(255), DATE_TIME datetime, LDATA_ID bigint, ACTIONS varchar(255), RETRIES integer, INSERT_TIME datetime, MLOCK integer not null, primary key (ID)); +create table BPEL_CORRELATION_PROP (ID bigint not null auto_increment, NAME varchar(255), NAMESPACE varchar(255), VALUE varchar(255), CORR_SET_ID bigint, INSERT_TIME datetime, MLOCK integer not null, primary key (ID)); +create table BPEL_CORRELATION_SET (ID bigint not null auto_increment, VALUE varchar(255), CORR_SET_NAME varchar(255), SCOPE_ID bigint, PIID bigint, PROCESS_ID bigint, INSERT_TIME datetime, MLOCK integer not null, primary key (ID)); +create table BPEL_CORRELATOR (ID bigint not null auto_increment, CID varchar(255), PROCESS_ID bigint, INSERT_TIME datetime, MLOCK integer not null, primary key (ID)); +create table BPEL_CORRELATOR_MESSAGE_CKEY (ID bigint not null auto_increment, CKEY varchar(255), CORRELATOR_MESSAGE_ID bigint, INSERT_TIME datetime, MLOCK integer not null, primary key (ID)); +create table BPEL_EVENT (ID bigint not null auto_increment, IID bigint, PID bigint, TSTAMP datetime, TYPE varchar(255), DETAIL text, LDATA_ID bigint, SID bigint, INSERT_TIME datetime, MLOCK integer not null, primary key (ID)); +create table BPEL_FAULT (ID bigint not null auto_increment, FAULTNAME varchar(255), LDATA_ID bigint, EXPLANATION varchar(4000), LINE_NUM integer, AID integer, INSERT_TIME datetime, MLOCK integer not null, primary key (ID)); +create table BPEL_INSTANCE (ID bigint not null auto_increment, INSTANTIATING_CORRELATOR bigint, FAULT bigint, JACOB_STATE bigint, PREVIOUS_STATE smallint, PROCESS_ID bigint, STATE smallint, LAST_ACTIVE_DT datetime, SEQUENCE bigint, FAILURE_COUNT integer, FAILURE_DT datetime, 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_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 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); Added: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/oracle.sql =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/oracle.sql (rev 0) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/oracle.sql 2009-11-20 04:52:19 UTC (rev 283) @@ -0,0 +1,49 @@ +create table ODE_SCHEMA_VERSION(VERSION integer); +insert into ODE_SCHEMA_VERSION values (5); +-- Apache ODE - SimpleScheduler Database Schema +-- +-- Apache Derby scripts by Maciej Szefler. +-- +-- + +CREATE TABLE ode_job ( + jobid CHAR(64) DEFAULT '' NOT NULL, + ts INTEGER DEFAULT 0 NOT NULL, + nodeid char(64), + scheduled int DEFAULT 0 NOT NULL, + transacted int DEFAULT 0 NOT NULL, + details blob, + PRIMARY KEY(jobid) +); + +CREATE INDEX IDX_ODE_JOB_TS ON ode_job(ts); +CREATE INDEX IDX_ODE_JOB_NODEID ON ode_job(nodeid); + + +create table BPEL_ACTIVITY_RECOVERY (ID number(19,0) not null, PIID number(19,0), AID number(19,0), CHANNEL varchar2(255 char), REASON varchar2(255 char), DATE_TIME timestamp, LDATA_ID number(19,0), ACTIONS varchar2(255 char), RETRIES number(10,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); +create table BPEL_CORRELATION_PROP (ID number(19,0) not null, NAME varchar2(255 char), NAMESPACE varchar2(255 char), VALUE varchar2(255 char), CORR_SET_ID number(19,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); +create table BPEL_CORRELATION_SET (ID number(19,0) not null, VALUE varchar2(255 char), CORR_SET_NAME varchar2(255 char), SCOPE_ID number(19,0), PIID number(19,0), PROCESS_ID number(19,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); +create table BPEL_CORRELATOR (ID number(19,0) not null, CID varchar2(255 char), PROCESS_ID number(19,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); +create table BPEL_CORRELATOR_MESSAGE_CKEY (ID number(19,0) not null, CKEY varchar2(255 char), CORRELATOR_MESSAGE_ID number(19,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); +create table BPEL_EVENT (ID number(19,0) not null, IID number(19,0), PID number(19,0), TSTAMP timestamp, TYPE varchar2(255 char), DETAIL clob, LDATA_ID number(19,0), SID number(19,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); +create table BPEL_FAULT (ID number(19,0) not null, FAULTNAME varchar2(255 char), LDATA_ID number(19,0), EXPLANATION varchar2(4000 char), LINE_NUM number(10,0), AID number(10,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); +create table BPEL_INSTANCE (ID number(19,0) not null, INSTANTIATING_CORRELATOR number(19,0), FAULT number(19,0), JACOB_STATE number(19,0), PREVIOUS_STATE number(5,0), PROCESS_ID number(19,0), STATE number(5,0), LAST_ACTIVE_DT timestamp, SEQUENCE number(19,0), FAILURE_COUNT number(10,0), FAILURE_DT timestamp, 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 long, NAME varchar2(255 char) not null, primary key (MEX, NAME)); +create table BPEL_PLINK_VAL (ID number(19,0) not null, PARTNER_LINK varchar2(100 char) not null, PARTNERROLE varchar2(100 char), MYROLE_EPR number(19,0), PARTNERROLE_EPR number(19,0), PROCESS number(19,0), SCOPE number(19,0), SVCNAME varchar2(255 char), MYROLE varchar2(100 char), MODELID number(10,0), MYSESSIONID varchar2(255 char), PARTNERSESSIONID varchar2(255 char), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); +create table BPEL_PROCESS (ID number(19,0) not null, PROCID varchar2(255 char) not null unique, deployer varchar2(255 char), deploydate timestamp, type_name varchar2(255 char), type_ns varchar2(255 char), version number(19,0), ACTIVE_ number(1,0), guid varchar2(255 char), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); +create table BPEL_SCOPE (ID number(19,0) not null, PIID number(19,0), PARENT_SCOPE_ID number(19,0), STATE varchar2(255 char) not null, NAME varchar2(255 char) not null, MODELID number(10,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); +create table BPEL_SELECTORS (ID number(19,0) not null, PIID number(19,0) not null, SELGRPID varchar2(255 char) not null, IDX number(10,0) not null, CORRELATION_KEY varchar2(255 char) not null, PROC_TYPE varchar2(255 char) not null, 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 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_MSG_CKEY on BPEL_CORRELATOR_MESSAGE_CKEY (CKEY); +create index IDX_SELECTOR_CORRELATOR on BPEL_SELECTORS (CORRELATOR); +create index IDX_SELECTOR_CKEY on BPEL_SELECTORS (CORRELATION_KEY); +create index IDX_SELECTOR_SELGRPID on BPEL_SELECTORS (SELGRPID); +create index IDX_UNMATCHED_CKEY on BPEL_UNMATCHED (CORRELATION_KEY); +create index IDX_UNMATCHED_CORRELATOR on BPEL_UNMATCHED (CORRELATOR); +create sequence hibernate_sequence; Added: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/postgres.sql =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/postgres.sql (rev 0) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/postgres.sql 2009-11-20 04:52:19 UTC (rev 283) @@ -0,0 +1,48 @@ +create table ODE_SCHEMA_VERSION(VERSION integer); +insert into ODE_SCHEMA_VERSION values (5); +-- Apache ODE - SimpleScheduler Database Schema +-- +-- Apache Derby scripts by Maciej Szefler. +-- +-- + +CREATE TABLE ode_job ( + jobid CHAR(64) NOT NULL DEFAULT '', + ts BIGINT NOT NULL DEFAULT 0, + nodeid char(64), + scheduled int NOT NULL DEFAULT 0, + transacted int NOT NULL DEFAULT 0, + details bytea, + PRIMARY KEY(jobid)); + +CREATE INDEX IDX_ODE_JOB_TS ON ode_job(ts); +CREATE INDEX IDX_ODE_JOB_NODEID ON ode_job(nodeid); + + +create table BPEL_ACTIVITY_RECOVERY (ID int8 not null, PIID int8, AID int8, CHANNEL varchar(255), REASON varchar(255), DATE_TIME timestamp, LDATA_ID int8, ACTIONS varchar(255), RETRIES int4, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); +create table BPEL_CORRELATION_PROP (ID int8 not null, NAME varchar(255), NAMESPACE varchar(255), VALUE varchar(255), CORR_SET_ID int8, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); +create table BPEL_CORRELATION_SET (ID int8 not null, VALUE varchar(255), CORR_SET_NAME varchar(255), SCOPE_ID int8, PIID int8, PROCESS_ID int8, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); +create table BPEL_CORRELATOR (ID int8 not null, CID varchar(255), PROCESS_ID int8, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); +create table BPEL_CORRELATOR_MESSAGE_CKEY (ID int8 not null, CKEY varchar(255), CORRELATOR_MESSAGE_ID int8, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); +create table BPEL_EVENT (ID int8 not null, IID int8, PID int8, TSTAMP timestamp, TYPE varchar(255), DETAIL text, LDATA_ID int8, SID int8, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); +create table BPEL_FAULT (ID int8 not null, FAULTNAME varchar(255), LDATA_ID int8, EXPLANATION varchar(4000), LINE_NUM int4, AID int4, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); +create table BPEL_INSTANCE (ID int8 not null, INSTANTIATING_CORRELATOR int8, FAULT int8, JACOB_STATE int8, PREVIOUS_STATE int2, PROCESS_ID int8, STATE int2, LAST_ACTIVE_DT timestamp, SEQUENCE int8, FAILURE_COUNT int4, FAILURE_DT timestamp, 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_MEX_PROPS (MEX int8 not null, VALUE varchar(8000), NAME varchar(255) not null, primary key (MEX, NAME)); +create table BPEL_PLINK_VAL (ID int8 not null, PARTNER_LINK varchar(100) not null, PARTNERROLE varchar(100), MYROLE_EPR int8, PARTNERROLE_EPR int8, PROCESS int8, SCOPE int8, SVCNAME varchar(255), MYROLE varchar(100), MODELID int4, MYSESSIONID varchar(255), PARTNERSESSIONID varchar(255), INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); +create table BPEL_PROCESS (ID int8 not null, PROCID varchar(255) not null unique, deployer varchar(255), deploydate timestamp, type_name varchar(255), type_ns varchar(255), version int8, ACTIVE_ bool, guid varchar(255), INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); +create table BPEL_SCOPE (ID int8 not null, PIID int8, PARENT_SCOPE_ID int8, STATE varchar(255) not null, NAME varchar(255) not null, MODELID int4, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); +create table BPEL_SELECTORS (ID int8 not null, PIID int8 not null, SELGRPID varchar(255) not null, IDX int4 not null, CORRELATION_KEY varchar(255) not null, PROC_TYPE varchar(255) not null, 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 VAR_PROPERTY (ID int8 not null, XML_DATA_ID int8, PROP_VALUE varchar(255), PROP_NAME varchar(255) not null, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); +create index IDX_CORRELATOR_CID on BPEL_CORRELATOR (CID); +create index IDX_BPEL_CORRELATOR_MESSAGE_CKEY on BPEL_CORRELATOR_MESSAGE_CKEY (CKEY); +create index IDX_SELECTOR_CORRELATOR on BPEL_SELECTORS (CORRELATOR); +create index IDX_SELECTOR_CKEY on BPEL_SELECTORS (CORRELATION_KEY); +create index IDX_SELECTOR_SELGRPID on BPEL_SELECTORS (SELGRPID); +create index IDX_UNMATCHED_CKEY on BPEL_UNMATCHED (CORRELATION_KEY); +create index IDX_UNMATCHED_CORRELATOR on BPEL_UNMATCHED (CORRELATOR); +create sequence hibernate_sequence; Added: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sqlserver.sql =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sqlserver.sql (rev 0) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sqlserver.sql 2009-11-20 04:52:19 UTC (rev 283) @@ -0,0 +1,47 @@ +create table ODE_SCHEMA_VERSION(VERSION integer); +insert into ODE_SCHEMA_VERSION values (5); +-- Apache ODE - SimpleScheduler Database Schema +-- +-- Apache Derby scripts by Maciej Szefler. +-- +-- + +CREATE TABLE ode_job ( + jobid CHAR(64) NOT NULL DEFAULT '', + ts BIGINT NOT NULL DEFAULT 0, + nodeid char(64), + scheduled int NOT NULL DEFAULT 0, + transacted int NOT NULL DEFAULT 0, + details image null, + PRIMARY KEY(jobid)); + +CREATE INDEX IDX_ODE_JOB_TS ON ode_job(ts); +CREATE INDEX IDX_ODE_JOB_NODEID ON ode_job(nodeid); + + +create table BPEL_ACTIVITY_RECOVERY (ID numeric(19,0) identity not null, PIID numeric(19,0) null, AID numeric(19,0) null, CHANNEL varchar(255) null, REASON varchar(255) null, DATE_TIME datetime null, LDATA_ID numeric(19,0) null, ACTIONS varchar(255) null, RETRIES int null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); +create table BPEL_CORRELATION_PROP (ID numeric(19,0) identity not null, NAME varchar(255) null, NAMESPACE varchar(255) null, VALUE varchar(255) null, CORR_SET_ID numeric(19,0) null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); +create table BPEL_CORRELATION_SET (ID numeric(19,0) identity not null, VALUE varchar(255) null, CORR_SET_NAME varchar(255) null, SCOPE_ID numeric(19,0) null, PIID numeric(19,0) null, PROCESS_ID numeric(19,0) null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); +create table BPEL_CORRELATOR (ID numeric(19,0) identity not null, CID varchar(255) null, PROCESS_ID numeric(19,0) null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); +create table BPEL_CORRELATOR_MESSAGE_CKEY (ID numeric(19,0) identity not null, CKEY varchar(255) null, CORRELATOR_MESSAGE_ID numeric(19,0) null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); +create table BPEL_EVENT (ID numeric(19,0) identity not null, IID numeric(19,0) null, PID numeric(19,0) null, TSTAMP datetime null, TYPE varchar(255) null, DETAIL text null, LDATA_ID numeric(19,0) null, SID numeric(19,0) null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); +create table BPEL_FAULT (ID numeric(19,0) identity not null, FAULTNAME varchar(255) null, LDATA_ID numeric(19,0) null, EXPLANATION varchar(4000) null, LINE_NUM int null, AID int null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID)); +create table BPEL_INSTANCE (ID numeric(19,0) identity not null, INSTANTIATING_CORRELATOR numeric(19,0) null, FAULT numeric(19,0) null, JACOB_STATE numeric(19,0) null, PREVIOUS_STATE smallint null, PROCESS_ID numeric(19,0) null, STATE smallint null, LAST_ACTIVE_DT datetime null, SEQUENCE numeric(19,0) null, FAILURE_COUNT int null, FAILURE_DT datetime null, 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_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 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); Added: trunk/runtime/engine-assembly/src/main/resources/bpel.properties =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/bpel.properties (rev 0) +++ trunk/runtime/engine-assembly/src/main/resources/bpel.properties 2009-11-20 04:52:19 UTC (rev 283) @@ -0,0 +1,101 @@ +# +# Licensed to the Apache Software Foundation (ASF) under one +# or more contributor license agreements. See the NOTICE file +# distributed with this work for additional information +# regarding copyright ownership. The ASF licenses this file +# to you under the Apache License, Version 2.0 (the +# "License"); you may not use this file except in compliance +# with the License. You may obtain a copy of the License at +# +# http://www.apache.org/licenses/LICENSE-2.0 +# +# Unless required by applicable law or agreed to in writing, +# software distributed under the License is distributed on an +# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +# KIND, either express or implied. See the License for the +# specific language governing permissions and limitations +# under the License. +# + +## bpel Configuraiton Properties + +## Database Mode ("INTERNAL", "EXTERNAL", "EMBEDDED") +## What kind of database should ODE use? +## * "EMBEDDED" - ODE will create its own embbeded database (Derby) +## and connection pool (Minerva). +## * "EXTERNAL" - ODE will use an app-server provided database and pool. +## The "ode-jbi.db.ext.dataSource" property will need to +## be set. +## * "INTERNAL" - ODE will create its own connection pool for a user- +## specified JDBC URL and driver. +#bpel.db.mode=EMBEDDED + +## External Database [JNDI Name] +## JNDI Name of the DataSource for the ODE database. This is only +## used if the "ode-jbi.db.mode" property is set to "EXTERNAL" +#bpel.db.ext.dataSource=java:comp/env/jdbc/ode + +## Embedded Database Name [String] +## Name of the embedded Derby database. This is only used if the +## "ode-jbi.db.mode" property is set to "EMBEDDED". +#ode-jbi.db.emb.name=hibdb +#ode-jbi.db.emb.name=jpadb + +## Internal Database Configuration +#ode-jbi.db.int.jdbcurl=jdbc:mysql://localhost/ode?user=sa +#ode-jbi.db.int.driver=com.mysql.jdbc.Driver +#bpel.db.int.password = +#bpel.db.int.username = + +## DB Pool Configuration for internal DB +#bpel.db.pool.max = 10 +#bpel.db.pool.min = 1 + +## DAO Connection Factory class. +## uncomment the following for hibernate. +bpel.dao.factory=org.apache.ode.daohib.bpel.BpelDAOConnectionFactoryImpl + +## Transaction Factory +## default is org.apache.ode.il.EmbeddedGeronimoFactory +## available alternatives are: +## org.apache.ode.axis2.util.GeronimoFactory +## org.apache.ode.axis2.util.JBossFactory +## org.apache.ode.axis2.util.TomcatFactory + +## org.apache.ode.axis2.util.WLSFactory +bpel.tx.factory.class = org.jboss.soa.bpel.runtime.engine.ode.JBossTransactionFactory + +## JCA connector port (default 2099), set to 0 to disable JCA connector +#bpel.jca.port = + +## JCA conncetor name (default 'ode') +#bpel.jca.name = + +## Working dir +#bpel.working.dir = + +## MEX Interceptors +#bpel.mex.interceptors = + +## Process dehydration +#bpel.process.dehydration = + +## Extension Bundles +## FQCNs, comma separated. +#bpel.extension.bundles.runtime = +#bpel.extension.bundles.validation = + +bpel.db.mode=EXTERNAL +bpel.db.ext.dataSource=java:BPELDB + +hibernate.dialect=org.hibernate.dialect.H2Dialect +hibernate.hbm2ddl.auto=update +hibernate.current_session_context_class=jta +hibernate.transaction.manager_lookup_class=org.hibernate.transaction.JBossTransactionManagerLookup + +jta.UserTransaction=UserTransaction + +ode.persistence=hibernate + +ode.process.checkguid=false +ode.process.store=org.apache.ode.store.JBossProcessStoreImpl Modified: trunk/runtime/jbossesb-bpel/pom.xml =================================================================== --- trunk/runtime/jbossesb-bpel/pom.xml 2009-11-19 03:04:23 UTC (rev 282) +++ trunk/runtime/jbossesb-bpel/pom.xml 2009-11-20 04:52:19 UTC (rev 283) @@ -17,7 +17,7 @@ <dependencies> <dependency> <groupId>org.jboss.soa.bpel.runtime</groupId> - <artifactId>engine</artifactId> + <artifactId>riftsaw-engine</artifactId> <version>2.0-SNAPSHOT</version> </dependency> <dependency> @@ -43,6 +43,11 @@ <version>3.8.1</version> <scope>test</scope> </dependency> + <dependency> + <groupId>commons-logging</groupId> + <artifactId>commons-logging</artifactId> + <scope>provided</scope> + </dependency> </dependencies> <build> <finalName>jbossesb-bpel</finalName>