[overlord-commits] Overlord SVN: r214 - in cdl/trunk/distribution: assembly and 6 other directories.

Author: jeff.yuchang Date: 2008-08-04 11:11:28 -0400 (Mon, 04 Aug 2008) New Revision: 214 Added: cdl/trunk/distribution/assembly/ cdl/trunk/distribution/assembly/jbossesb/ cdl/trunk/distribution/assembly/jbossesb/pom.xml cdl/trunk/distribution/assembly/jbossesb/src/ cdl/trunk/distribution/assembly/jbossesb/src/main/ cdl/trunk/distribution/assembly/jbossesb/src/main/java/ cdl/trunk/distribution/assembly/jbossesb/src/main/resources/ cdl/trunk/distribution/assembly/jbossesb/src/main/resources/META-INF/ cdl/trunk/distribution/assembly/jbossesb/src/main/resources/META-INF/deployment.xml cdl/trunk/distribution/assembly/jbossesb/src/main/resources/META-INF/jboss-esb.xml cdl/trunk/distribution/assembly/jbossesb/src/main/resources/cdl-ds.xml cdl/trunk/distribution/assembly/jbossesb/src/main/resources/cdl-service.xml cdl/trunk/distribution/assembly/jbossesb/src/main/resources/cdl-sql/ cdl/trunk/distribution/assembly/jbossesb/src/main/resources/cdl-sql/cdl.hsqldb.sql cdl/trunk/distribution/assembly/jbossesb/src/main/resources/hibernate.cfg.xml cdl/trunk/distribution/assembly/pom.xml Log: [SOAG-28] * Using JBossAS default database. * This builds a esb artifact that wraps the conversation actions. Added: cdl/trunk/distribution/assembly/jbossesb/pom.xml =================================================================== --- cdl/trunk/distribution/assembly/jbossesb/pom.xml (rev 0) +++ cdl/trunk/distribution/assembly/jbossesb/pom.xml 2008-08-04 15:11:28 UTC (rev 214) @@ -0,0 +1,93 @@ +<project xmlns="http://maven.apache.org/POM/4.0.0" + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + 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.overlord.cdl.assembly</groupId> + <artifactId>jbossesb</artifactId> + <version>1.0-SNAPSHOT</version> + <packaging>jboss-esb</packaging> + <name>Overlord::CDL::Assembly::JBossESB</name> + <url>http://www.jboss.org/soag</url> + + <parent> + <groupId>org.jboss.soa.overlord.cdl</groupId> + <artifactId>assembly</artifactId> + <version>1.0-SNAPSHOT</version> + </parent> + + <properties> + <hibernate-commons-annotations>3.0.0.ga</hibernate-commons-annotations> + <hibernate-tools-version>3.2.0.ga</hibernate-tools-version> + <hsqldb-version>1.8.0.7</hsqldb-version> + </properties> + + <dependencies> + <dependency> + <groupId>org.jboss.soa.overlord.cdl</groupId> + <artifactId>runtime-jbossesb</artifactId> + <version>1.0-SNAPSHOT</version> + </dependency> + + <dependency> + <groupId>org.hibernate</groupId> + <artifactId>hibernate-commons-annotations</artifactId> + <version>${hibernate-commons-annotations}</version> + </dependency> + + <dependency> + <groupId>org.hibernate</groupId> + <artifactId>hibernate-tools</artifactId> + <version>${hibernate-tools-version}</version> + <scope>provided</scope> + </dependency> + + <dependency> + <groupId>hsqldb</groupId> + <artifactId>hsqldb</artifactId> + <version>${hsqldb-version}</version> + </dependency> + + </dependencies> + + <build> + <finalName>cdl-jbossesb</finalName> + <plugins> + <plugin> + <groupId>org.apache.maven.plugins</groupId> + <artifactId>maven-antrun-plugin</artifactId> + <executions> + <!--export schemas to database --> + <!--execution> + <id>schemaexport</id> + <phase>compile</phase> + <configuration> + <tasks> + <taskdef name="hibernatetool" classname="org.hibernate.tool.ant.HibernateToolTask" + classpathref="maven.compile.classpath"/> + <hibernatetool destdir="."> + <classpath> + <pathelement path="maven.compile.classpath" /> + </classpath> + <annotationconfiguration configurationfile="target/classes/hibernate.cfg.xml" /> + <hbm2ddl + create="true" + drop="false" + export="true" + outputfilename="cdl.hsqldb.sql" + delimiter=";" + format="true"/> + </hibernatetool> + </tasks> + </configuration> + <goals> + <goal>run</goal> + </goals> + </execution--> + + </executions> + </plugin> + </plugins> + </build> + +</project> + Added: cdl/trunk/distribution/assembly/jbossesb/src/main/resources/META-INF/deployment.xml =================================================================== --- cdl/trunk/distribution/assembly/jbossesb/src/main/resources/META-INF/deployment.xml (rev 0) +++ cdl/trunk/distribution/assembly/jbossesb/src/main/resources/META-INF/deployment.xml 2008-08-04 15:11:28 UTC (rev 214) @@ -0,0 +1,5 @@ +<jbossesb-deployment> + <depends>jboss.esb:deployment=jbossesb.esb</depends> + <depends>jboss.jca:service=DataSourceBinding,name=cdlDS</depends> + <depends>jboss.esb:service=CDLDatabaseInitializer</depends> +</jbossesb-deployment> Added: cdl/trunk/distribution/assembly/jbossesb/src/main/resources/META-INF/jboss-esb.xml =================================================================== --- cdl/trunk/distribution/assembly/jbossesb/src/main/resources/META-INF/jboss-esb.xml (rev 0) +++ cdl/trunk/distribution/assembly/jbossesb/src/main/resources/META-INF/jboss-esb.xml 2008-08-04 15:11:28 UTC (rev 214) @@ -0,0 +1,24 @@ +<?xml version = "1.0" encoding = "UTF-8"?> +<!-- + JBoss, Home of Professional Open Source + Copyright 2008, JBoss Inc., and others contributors as indicated + by the @authors tag. All rights reserved. + See the copyright.txt in the distribution for a + full listing of individual contributors. + This copyrighted material is made available to anyone wishing to use, + modify, copy, or redistribute it subject to the terms and conditions + of the GNU Lesser General Public License, v. 2.1. + This program is distributed in the hope that it will be useful, but WITHOUT A + WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A + PARTICULAR PURPOSE. See the GNU Lesser General Public License for more details. + You should have received a copy of the GNU Lesser General Public License, + v.2.1 along with this distribution; if not, write to the Free Software + Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, + MA 02110-1301, USA. + + (C) 2008, +--> +<jbossesb xmlns="http://anonsvn.labs.jboss.com/labs/jbossesb/trunk/product/etc... + parameterReloadSecs="500"> + +</jbossesb> Added: cdl/trunk/distribution/assembly/jbossesb/src/main/resources/cdl-ds.xml =================================================================== --- cdl/trunk/distribution/assembly/jbossesb/src/main/resources/cdl-ds.xml (rev 0) +++ cdl/trunk/distribution/assembly/jbossesb/src/main/resources/cdl-ds.xml 2008-08-04 15:11:28 UTC (rev 214) @@ -0,0 +1,37 @@ +<?xml version="1.0" encoding="UTF-8"?> + +<datasources> +<!-- + <xa-datasource> + <jndi-name>JbpmDS</jndi-name> + <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class> + <track-connection-by-tx/> + <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> + <xa-datasource-property name="URL">jdbc:h2:${jboss.server.data.dir}${/}h2${/}jbpmDB;MVCC=TRUE</xa-datasource-property> + <xa-datasource-property name="User">sa</xa-datasource-property> + <xa-datasource-property name="Password"></xa-datasource-property> + <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=jbpmDB</depends> + </xa-datasource> +--> + <local-tx-datasource> + <jndi-name>cdlDS</jndi-name> + <connection-url>jdbc:h2:${jboss.server.data.dir}${/}h2${/}cdlDB;MVCC=TRUE</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=cdlDB</depends> + </local-tx-datasource> + <mbean code="org.jboss.internal.soa.esb.dependencies.H2Database" + name="jboss:service=h2,database=cdlDB"> + <attribute name="Database">cdlDB</attribute> + </mbean> +</datasources> Added: cdl/trunk/distribution/assembly/jbossesb/src/main/resources/cdl-service.xml =================================================================== --- cdl/trunk/distribution/assembly/jbossesb/src/main/resources/cdl-service.xml (rev 0) +++ cdl/trunk/distribution/assembly/jbossesb/src/main/resources/cdl-service.xml 2008-08-04 15:11:28 UTC (rev 214) @@ -0,0 +1,17 @@ +<?xml version="1.0" encoding="UTF-8"?> + +<server> + <classpath codebase="deploy" archives="cdl-jbossesb.esb"/> + <classpath codebase="deploy/jbossesb.sar/lib" archives="jbossesb-rosetta.jar"/> + <mbean code="org.jboss.internal.soa.esb.dependencies.DatabaseInitializer" + name="jboss.esb:service=CDLDatabaseInitializer"> + <attribute name="Datasource">java:/cdlDS</attribute> + <attribute name="ExistsSql">select * from CDL_SESSION</attribute> + <attribute name="SqlFiles"> + cdl-sql/cdl.hsqldb.sql + </attribute> + <depends>jboss.jca:service=DataSourceBinding,name=cdlDS</depends> + <attribute name="UseEOL">true</attribute> + </mbean> + +</server> Added: cdl/trunk/distribution/assembly/jbossesb/src/main/resources/cdl-sql/cdl.hsqldb.sql =================================================================== --- cdl/trunk/distribution/assembly/jbossesb/src/main/resources/cdl-sql/cdl.hsqldb.sql (rev 0) +++ cdl/trunk/distribution/assembly/jbossesb/src/main/resources/cdl-sql/cdl.hsqldb.sql 2008-08-04 15:11:28 UTC (rev 214) @@ -0,0 +1,19 @@ + create table CDL_EPRS (ID bigint generated by default as identity (start with 1),name varchar(255),EPR longvarchar,SESSION_ID bigint,primary key (ID)); + + create table CDL_IDENTITY (ID bigint generated by default as identity (start with 1),TYPE varchar(255),PROPERTY_VALUE varchar(255),SERVICE_NAME varchar(255),SESSION_ID bigint not null,primary key (ID)); + + create table CDL_JOIN_STATES (ID bigint generated by default as identity (start with 1),CATEGORY varchar(255) not null,NAME varchar(255) not null,ITEM_COUNT integer,SESSION_ID bigint,primary key (ID)); + + create table CDL_SCHEDULE_ITEM (ID bigint generated by default as identity (start with 1),CATEGORY varchar(255) not null,NAME varchar(255) not null,SESSION_ID bigint,primary key (ID)); + + create table CDL_SESSION (SESSION_ID bigint generated by default as identity (start with 1),STATUS varchar(255),POJO_CLASS varchar(255),SERVICE_NAME varchar(255),CONVERSATION_TYPE varchar(255),Business_OBJECT longvarbinary,PARENT_ID bigint,primary key (SESSION_ID)); + + alter table CDL_EPRS add constraint FKC42217E088C85D6A foreign key (SESSION_ID)references CDL_SESSION; + + alter table CDL_IDENTITY add constraint FK41FEEA7288C85D6A foreign key (SESSION_ID) references CDL_SESSION; + + alter table CDL_JOIN_STATES add constraint FKBBDE508388C85D6A foreign key (SESSION_ID) references CDL_SESSION; + + alter table CDL_SCHEDULE_ITEM add constraint FKA523168788C85D6A foreign key (SESSION_ID) references CDL_SESSION; + + alter table CDL_SESSION add constraint FKD597E42A1212ED6 foreign key (PARENT_ID) references CDL_SESSION; Added: cdl/trunk/distribution/assembly/jbossesb/src/main/resources/hibernate.cfg.xml =================================================================== --- cdl/trunk/distribution/assembly/jbossesb/src/main/resources/hibernate.cfg.xml (rev 0) +++ cdl/trunk/distribution/assembly/jbossesb/src/main/resources/hibernate.cfg.xml 2008-08-04 15:11:28 UTC (rev 214) @@ -0,0 +1,64 @@ +<!DOCTYPE hibernate-configuration SYSTEM +"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> +<!-- + JBoss, Home of Professional Open Source + Copyright 2008, JBoss Inc., and others contributors as indicated + by the @authors tag. All rights reserved. + See the copyright.txt in the distribution for a + full listing of individual contributors. + This copyrighted material is made available to anyone wishing to use, + modify, copy, or redistribute it subject to the terms and conditions + of the GNU Lesser General Public License, v. 2.1. + This program is distributed in the hope that it will be useful, but WITHOUT A + WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A + PARTICULAR PURPOSE. See the GNU Lesser General Public License for more details. + You should have received a copy of the GNU Lesser General Public License, + v.2.1 along with this distribution; if not, write to the Free Software + Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, + MA 02110-1301, USA. + + (C) 2008, + @author JBoss Inc. +--> +<hibernate-configuration> + <session-factory> + <!--property name="hibernate.connection.driver_class"> + org.hsqldb.jdbcDriver + </property> + <property name="hibernate.connection.url"> + jdbc:hsqldb:hsql://localhost + </property> + <property name="hibernate.connection.username"> + sa + </property--> + + <property name="hibernate.dialect">org.hibernate.dialect.HSQLDialect</property> + + <!-- DataSource properties (begin) === --> + <property name="hibernate.connection.datasource">java:/cdlDS</property> + <!-- ==== DataSource properties (end) --> + + + <!-- Use the C3P0 connection pool provider --> + <property name="hibernate.c3p0.min_size">5</property> + <property name="hibernate.c3p0.max_size">20</property> + <property name="hibernate.c3p0.timeout">300</property> + <property name="hibernate.c3p0.max_statements">50</property> + <property name="hibernate.c3p0.idle_test_period">3000</property> + + <property name="current_session_context_class">thread</property> + <property name="hibernate.connection.isolation">4</property> + + <!-- Show and print nice SQL on stdout --> + <property name="show_sql">false</property> + <property name="format_sql">true</property> + + <!-- List of annotationed classes (Internal conversation class)--> + <mapping class="org.jboss.soa.overlord.conversation.Session" /> + <mapping class="org.jboss.soa.overlord.conversation.ScheduleItem"/> + <mapping class="org.jboss.soa.overlord.conversation.JoinState"/> + <mapping class="org.jboss.soa.overlord.conversation.Identity"/> + <mapping class="org.jboss.soa.overlord.conversation.EPRWrapper"/> + + </session-factory> +</hibernate-configuration> Added: cdl/trunk/distribution/assembly/pom.xml =================================================================== --- cdl/trunk/distribution/assembly/pom.xml (rev 0) +++ cdl/trunk/distribution/assembly/pom.xml 2008-08-04 15:11:28 UTC (rev 214) @@ -0,0 +1,47 @@ +<project xmlns="http://maven.apache.org/POM/4.0.0" + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + 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.overlord.cdl</groupId> + <artifactId>assembly</artifactId> + <packaging>pom</packaging> + <version>1.0-SNAPSHOT</version> + <name>Overlord::CDL::Assembly</name> + <url>http://www.jboss.org/soag</url> + + <parent> + <groupId>org.jboss.soa.overlord</groupId> + <artifactId>cdl</artifactId> + <version>1.0-SNAPSHOT</version> + </parent> + + <modules> + <module>jbossesb</module> + </modules> + + <build> + <plugins> + <plugin> + <groupId>org.codehaus.mojo</groupId> + <artifactId>jboss-packaging-maven-plugin</artifactId> + <version>2.0-20080130.110241-9</version> + <extensions>true</extensions> + </plugin> + </plugins> + </build> + + <pluginRepositories> + <pluginRepository> + <releases> + <enabled>false</enabled> + </releases> + <snapshots/> + <id>jboss-plugin-snapshots</id> + <name>JBoss Snapshot Plugin Repository</name> + <url>http://snapshots.repository.codehaus.org</url> + </pluginRepository> + </pluginRepositories> + + +</project> +