geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Selvaraj, Saraswathi \(Cognizant\)" <Saraswathi.Selva...@cognizant.com>
Subject RE: Java Adventure Builder Reference 1.0.3 webapp deployed
Date Wed, 07 Dec 2005 05:15:37 GMT

Hi Jakob,
    Herewith I am resending all the latest plans along with the jms plan that I have.  Still now I don't have plans for mail & principal objects.

   The plans included:
(1)     activitysupplier-plan
(2)     airlinesupplier-plan
(3)     bank-plan
(4)     lodgingsupplier-plan
(5)     opc-plan
(6)     processmanager-plan
(7)     jms-plan

The following are the changes that were made to the EJB's :
(1) Changed the ActivityDetailsBean in the activitysupplier module to include the getter and setter methods for the automatic key generation of unknown primary key field.
(2) Similarly changes were also made to the AddressBean, ContactInfoBean, LodgingBean, CreditcardBean, TransportationBean, ActivityBean in the opc module due to above mentioned reason.




JMS Plan:

<?xml version="1.0" encoding="UTF-8"?>
<connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector"
    version="1.5"
    configId="adventureBuilder/Queue"
    parentId="org/apache/geronimo/ActiveMQServer">
    <resourceadapter>
        <resourceadapter-instance>
            <resourceadapter-name>ActiveMQ AdventureBuilder</resourceadapter-name>
            <config-property-setting name="ServerUrl">tcp://localhost:61616</config-property-setting>
            <config-property-setting name="UserName"></config-property-setting>
            <config-property-setting name="Password"></config-property-setting>
            <workmanager>
                <gbean-link>DefaultWorkManager</gbean-link>
            </workmanager>
        </resourceadapter-instance>
        <outbound-resourceadapter>
            <connection-definition>
			<connectionfactory-interface>javax.jms.ConnectionFactory</connectionfactory-interface>
                	<connectiondefinition-instance>
                    <name>JmsXA</name>
				<implemented-interface>javax.jms.QueueConnectionFactory</implemented-interface>
				<implemented-interface>javax.jms.TopicConnectionFactory</implemented-interface>
                    <connectionmanager>
                        <xa-transaction>
                            <transaction-caching/>
                        </xa-transaction>
                        <single-pool>
                            <max-size>10</max-size>
				    <blocking-timeout-milliseconds>5000</blocking-timeout-milliseconds>
                            <match-one/>
                        </single-pool>
                    </connectionmanager>
                   
                </connectiondefinition-instance>
            </connection-definition>
        </outbound-resourceadapter>
    </resourceadapter>
   
    <adminobject>
        <adminobject-interface>javax.jms.Queue</adminobject-interface>
       <adminobject-class>org.codehaus.activemq.message.ActiveMQQueue</adminobject-class>
        <adminobject-instance>
            <message-destination-name>jms/opc/WorkFlowMgrQueue</message-destination-name>
            <config-property-setting name="PhysicalName">jms/opc/WorkFlowMgrQueue</config-property-setting>
        </adminobject-instance>
    </adminobject>

   <adminobject>
        <adminobject-interface>javax.jms.Queue</adminobject-interface>
	<adminobject-class>org.codehaus.activemq.message.ActiveMQQueue</adminobject-class>
        <adminobject-instance>
            <message-destination-name>jms/opc/OrderFillerQueue</message-destination-name>
            <config-property-setting name="PhysicalName">jms/opc/OrderFillerQueue</config-property-setting>
        </adminobject-instance>
    </adminobject>

   <adminobject>
        <adminobject-interface>javax.jms.Queue</adminobject-interface>
	<adminobject-class>org.codehaus.activemq.message.ActiveMQQueue</adminobject-class>
        <adminobject-instance>
            <message-destination-name>jms/opc/WebServiceBrokerQueue</message-destination-name>
            <config-property-setting name="PhysicalName">jms/opc/WebServiceBrokerQueue</config-property-setting>
        </adminobject-instance>
    </adminobject>

    <adminobject>
        <adminobject-interface>javax.jms.Queue</adminobject-interface>
	<adminobject-class>org.codehaus.activemq.message.ActiveMQQueue</adminobject-class>
        <adminobject-instance>
            <message-destination-name>jms/opc/CRMQueue</message-destination-name>
            <config-property-setting name="PhysicalName">jms/opc/CRMQueue</config-property-setting>
        </adminobject-instance>
    </adminobject>


 <adminobject>
        <adminobject-interface>javax.jms.Queue</adminobject-interface>
	  <adminobject-class>org.codehaus.activemq.message.ActiveMQQueue</adminobject-class>
        <adminobject-instance>
            <message-destination-name>jms/lodging/LodgingQueue</message-destination-name>
            <config-property-setting name="PhysicalName">jms/lodging/LodgingQueue</config-property-setting>
        </adminobject-instance>
 </adminobject>

<adminobject>
        <adminobject-interface>javax.jms.Queue</adminobject-interface>
	  <adminobject-class>org.codehaus.activemq.message.ActiveMQQueue</adminobject-class>
        <adminobject-instance>
            <message-destination-name>jms/airline/AirlineQueue</message-destination-name>
            <config-property-setting name="PhysicalName">jms/airline/AirlineQueue</config-property-setting>
        </adminobject-instance>
</adminobject>

 <adminobject>
      <adminobject-interface>javax.jms.Queue</adminobject-interface>
	<adminobject-class>org.codehaus.activemq.message.ActiveMQQueue</adminobject-class>
        <adminobject-instance>
            <message-destination-name>jms/activity/ActivityQueue</message-destination-name>
            <config-property-setting name="PhysicalName">jms/activity/ActivityQueue</config-property-setting>
        </adminobject-instance>
</adminobject>

</connector>


EAR Plans:

(1)	activitysupplier-plan.xml


<?xml version="1.0" encoding="UTF-8"?>

<openejb-jar  configId=""
  xmlns="http://www.openejb.org/xml/ns/openejb-jar"
  xmlns:naming="http://geronimo.apache.org/xml/ns/naming" xmlns:sys="http://geronimo.apache.org/xml/ns/deployment">

	<cmp-connection-factory>
		<resource-link>MysqlDataSource</resource-link>
	</cmp-connection-factory>

  <enterprise-beans>
    <entity>
      <ejb-name>ActivityPurchaseOrderBean</ejb-name>
      <jndi-name>com.sun.j2ee.blueprints.activitysupplier.purchaseorder.ejb.ActivityPurchaseOrderLocalHome</jndi-name>
      <table-name>ActivityPurchaseOrder</table-name>
      <cmp-field-mapping>
        <cmp-field-name>poId</cmp-field-name>
        <table-column>poId</table-column>
      </cmp-field-mapping>
       <ejb-local-ref>
        <ref-name>ejb/local/activitysupplier/ActivityDetails</ref-name>	
        <name>ActivityDetailsBean</name>
      </ejb-local-ref> 

	 <resource-ref>
		  <ref-name>jdbc/adventure/AdventureDB</ref-name>
		  <resource-link>MysqlDataSource</resource-link>
	 </resource-ref>
    </entity>

    <entity>
      <ejb-name>ActivityDetailsBean</ejb-name>
      <jndi-name>com.sun.j2ee.blueprints.activitysupplier.purchaseorder.ejb.ActivityDetailsLocalHome</jndi-name>
      <table-name>ActivityDetails</table-name>
      <cmp-field-mapping>
        <cmp-field-name>activityId</cmp-field-name>
        <table-column>activityId</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>startDate</cmp-field-name>
        <table-column>startDate</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>endDate</cmp-field-name>
        <table-column>endDate</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>headCount</cmp-field-name>
        <table-column>headCount</table-column>
      </cmp-field-mapping>


	<cmp-field-mapping>
		<cmp-field-name>activityDetailsBean_upk</cmp-field-name>
		<cmp-field-class>java.lang.Integer</cmp-field-class>
		<table-column>ActivityDetailsBean_upk</table-column>
		<sql-type>INTEGER</sql-type>
		<type-converter>org.tranql.sql.typeconverter.SerializableConverter</type-converter>
	</cmp-field-mapping>

        <primkey-field>activityDetailsBean_upk</primkey-field>
	 

	<key-generator>
		<auto-increment-table>
		      <sql>INSERT INTO ActivityDetails VALUES(null,activityId,startDate,endDate,headCount,null)</sql>
	        	<return-type>java.lang.Integer</return-type>
      	</auto-increment-table>
	</key-generator>

	 <resource-ref>
		  <ref-name>jdbc/adventure/AdventureDB</ref-name>
		  <resource-link>MysqlDataSource</resource-link>
	 </resource-ref>
    </entity>

    <session>
      <ejb-name>ActivityPOEndpointBean</ejb-name>
      <jndi-name>ActivityPOEndpointBean</jndi-name>
      <resource-ref>
        <ref-name>jms/activity/QueueConnectionFactory</ref-name>
        <resource-link>JmsXA</resource-link>  
      </resource-ref>
    </session>

    <message-driven>
      <ejb-name>ActivityMessageEJB</ejb-name>
	<resource-adapter>
        	<resource-link>ActiveMQ AdventureBuilder</resource-link>
        </resource-adapter>   	   
    </message-driven>
    
  </enterprise-beans>


 <relationships>
	<ejb-relation>
		<ejb-relation-name>ActivityRelations</ejb-relation-name>
		<ejb-relationship-role>
			<ejb-relationship-role-name>ActivityPurchaseOrderBean</ejb-relationship-role-name>
			<relationship-role-source>
		             <ejb-name>ActivityPurchaseOrderBean</ejb-name>
		      </relationship-role-source>
		      <cmr-field>
		          <cmr-field-name>activities</cmr-field-name>
		      </cmr-field>
			<role-mapping>
			    <cmr-field-mapping>
				<key-column>poId</key-column>
				<foreign-key-column>ActivityPurchaseOrderBean_activities</foreign-key-column>
 			    </cmr-field-mapping>
			</role-mapping>
		</ejb-relationship-role>
	</ejb-relation>
 </relationships>


</openejb-jar>


(2) AirlineSupplier-Plan									
													<?xml version="1.0" encoding="UTF-8"?>
<openejb-jar configId=""
  xmlns="http://www.openejb.org/xml/ns/openejb-jar"
  xmlns:naming="http://geronimo.apache.org/xml/ns/naming" xmlns:sys="http://geronimo.apache.org/xml/ns/deployment">
 
<cmp-connection-factory>
	<resource-link>MysqlDataSource</resource-link>
</cmp-connection-factory>
  <enterprise-beans>
    <entity>
      <ejb-name>AirlineOrderBean</ejb-name>
      <jndi-name>com.sun.j2ee.blueprints.airlinesupplier.purchaseorder.ejb.AirlineOrderLocalHome</jndi-name>
      <table-name>AirlineOrder</table-name>
      <cmp-field-mapping>
        <cmp-field-name>orderId</cmp-field-name>
        <table-column>orderId</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>depFlightId</cmp-field-name>
        <table-column>depFlightId</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>depFlightDate</cmp-field-name>
        <table-column>depFlightDate</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>retFlightId</cmp-field-name>
        <table-column>retFlightId</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>retFlightDate</cmp-field-name>
        <table-column>retFlightDate</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>headCount</cmp-field-name>
        <table-column>headCount</table-column>
      </cmp-field-mapping>

	 <resource-ref>
		  <ref-name>jdbc/adventure/AdventureDB</ref-name>
		  <resource-link>MysqlDataSource</resource-link>
	 </resource-ref>
    </entity>
    <session>
      <ejb-name>AirlinePOEndpointBean</ejb-name>
      <jndi-name>AirlinePOEndpointBean</jndi-name>
      <resource-ref>
        <ref-name>jms/airline/QueueConnectionFactory</ref-name>
	  <resource-link>JmsXA</resource-link>
      </resource-ref>
    </session>
    <message-driven>
      <ejb-name>AirlineMessageEJB</ejb-name>
	<resource-adapter>
		<resource-link>ActiveMQ AdventureBuilder</resource-link>
	</resource-adapter>
    </message-driven>

  </enterprise-beans>

</openejb-jar>

(3) Bank-Plan																								<?xml version="1.0" encoding="UTF-8"?>
<openejb-jar configId=""
  xmlns="http://www.openejb.org/xml/ns/openejb-jar"
  xmlns:naming="http://geronimo.apache.org/xml/ns/naming" xmlns:sys="http://geronimo.apache.org/xml/ns/deployment">
 
  <enterprise-beans>
    <session>
      <ejb-name>CreditCardEndpointBean</ejb-name>
      <jndi-name>CreditCardEndpointBean</jndi-name>
	<web-service-address>http://localhost:8080/webservice/CreditCardService</web-service-address>
    </session>
  </enterprise-beans>

</openejb-jar>

(4) LodgingSupplier Plan																						<?xml version="1.0" encoding="UTF-8"?>
<openejb-jar configId=""
  xmlns="http://www.openejb.org/xml/ns/openejb-jar"
  xmlns:naming="http://geronimo.apache.org/xml/ns/naming" xmlns:sys="http://geronimo.apache.org/xml/ns/deployment">
 
<cmp-connection-factory>
	<resource-link>MysqlDataSource</resource-link>
</cmp-connection-factory>
  <enterprise-beans>
    <entity>
      <ejb-name>LodgingOrderBean</ejb-name>
      <jndi-name>com.sun.j2ee.blueprints.lodgingsupplier.purchaseorder.ejb.LodgingOrderLocalHome</jndi-name>
      <table-name>LodgingOrder</table-name>
      <cmp-field-mapping>
        <cmp-field-name>orderId</cmp-field-name>
        <table-column>orderId</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>lodgingId</cmp-field-name>
        <table-column>lodgingId</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>startDate</cmp-field-name>
        <table-column>startDate</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>endDate</cmp-field-name>
        <table-column>endDate</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>headCount</cmp-field-name>
        <table-column>headCount</table-column>
      </cmp-field-mapping>
    </entity>
    <session>
      <ejb-name>LodgingPOEndpointBean</ejb-name>
      <jndi-name>LodgingPOEndpointBean</jndi-name>
      <resource-ref>
        <ref-name>jms/lodging/QueueConnectionFactory</ref-name>
        <resource-link>JmsXA</resource-link>
      </resource-ref>
	<web-service-address>http://localhost:8080/webservice/LodgingPOService</web-service-address>
    </session>
    <message-driven>
      <ejb-name>LodgingMessageEJB</ejb-name>
	<resource-adapter>
        	<resource-link>ActiveMQ AdventureBuilder</resource-link>
        </resource-adapter>  
    </message-driven>
  </enterprise-beans>

</openejb-jar>


(5) OPC Plan																								<?xml version="1.0" encoding="UTF-8"?>
<openejb-jar configId=""
  xmlns="http://www.openejb.org/xml/ns/openejb-jar"
  xmlns:naming="http://geronimo.apache.org/xml/ns/naming" xmlns:sys="http://geronimo.apache.org/xml/ns/deployment">
 
<cmp-connection-factory>
	<resource-link>MysqlDataSource</resource-link>
</cmp-connection-factory>
  <enterprise-beans>
    <entity>
      <ejb-name>PurchaseOrderBean</ejb-name>
      <jndi-name>com.sun.j2ee.blueprints.opc.purchaseorder.ejb.PurchaseOrderLocalHome</jndi-name>
      <table-name>PurchaseOrder</table-name>
      <cmp-field-mapping>
        <cmp-field-name>locale</cmp-field-name>
        <table-column>locale</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>totalPrice</cmp-field-name>
        <table-column>totalPrice</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>startDate</cmp-field-name>
        <table-column>startDate</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>userId</cmp-field-name>
        <table-column>userId</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>departureCity</cmp-field-name>
        <table-column>departureCity</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>endDate</cmp-field-name>
        <table-column>endDate</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>orderDate</cmp-field-name>
        <table-column>orderDate</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>headCount</cmp-field-name>
        <table-column>headCount</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>poId</cmp-field-name>
        <table-column>poId</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>emailId</cmp-field-name>
        <table-column>emailId</table-column>
      </cmp-field-mapping>
      <ejb-local-ref>
        <ref-name>ejb/local/CreditCard</ref-name>
        <name>CreditCardBean</name>
      </ejb-local-ref>
      <ejb-local-ref>
        <ref-name>ejb/local/ContactInfo</ref-name>
        <name>ContactInfoBean</name>
      </ejb-local-ref>
      <ejb-local-ref>
        <ref-name>ejb/local/Activity</ref-name>
        <name>ActivityBean</name>
      </ejb-local-ref>
      <ejb-local-ref>
        <ref-name>ejb/local/Lodging</ref-name>
        <name>LodgingBean</name>
      </ejb-local-ref>
      <ejb-local-ref>
        <ref-name>ejb/local/Transportation</ref-name>
        <name>TransportationBean</name>
      </ejb-local-ref>
	
	 <resource-ref>
		  <ref-name>jdbc/adventure/AdventureDB</ref-name>
		  <resource-link>MysqlDataSource</resource-link>
	 </resource-ref>
    </entity>
    <entity>
      <ejb-name>CreditCardBean</ejb-name>
      <jndi-name>com.sun.j2ee.blueprints.opc.purchaseorder.ejb.CreditCardLocalHome</jndi-name>
      <table-name>CreditCard</table-name>
      <cmp-field-mapping>
        <cmp-field-name>cardNumber</cmp-field-name>
        <table-column>cardNumber</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>cardType</cmp-field-name>
        <table-column>cardType</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>cardExpiryDate</cmp-field-name>
        <table-column>cardExpiryDate</table-column>
      </cmp-field-mapping>
	
	<cmp-field-mapping>
		<cmp-field-name>creditCardBean_upk</cmp-field-name>
		<cmp-field-class>java.lang.Integer</cmp-field-class>
		<table-column>CreditCardBean_upk</table-column>
		<sql-type>INTEGER</sql-type>
		<type-converter>org.tranql.sql.typeconverter.SerializableConverter</type-converter>
	</cmp-field-mapping>

        <primkey-field>creditCardBean_upk</primkey-field>
	<key-generator>
		<auto-increment-table>
	        <sql>INSERT INTO CreditCard VALUES(null,cardNumber,cardType,cardExpiryDate)</sql>
          	  <return-type>java.lang.Integer</return-type>
      	</auto-increment-table>
	</key-generator>	

	 <resource-ref>
		  <ref-name>jdbc/adventure/AdventureDB</ref-name>
		  <resource-link>MysqlDataSource</resource-link>
	 </resource-ref>
    </entity>
    <entity>
      <ejb-name>ActivityBean</ejb-name>
      <jndi-name>com.sun.j2ee.blueprints.opc.purchaseorder.ejb.ActivityLocalHome</jndi-name>
      <table-name>Activity_Bean</table-name>
      <cmp-field-mapping>
        <cmp-field-name>activityId</cmp-field-name>
        <table-column>activityId</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>startDate</cmp-field-name>
        <table-column>startDate</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>price</cmp-field-name>
        <table-column>price</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>endDate</cmp-field-name>
        <table-column>endDate</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>headCount</cmp-field-name>
        <table-column>headCount</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>location</cmp-field-name>
        <table-column>location</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>name</cmp-field-name>
        <table-column>name</table-column>
      </cmp-field-mapping>
	<!-- Included from jbosscmp-jdbc.xml   -->
	<cmp-field-mapping>
		<cmp-field-name>activityBean_upk</cmp-field-name>
		<cmp-field-class>java.lang.Integer</cmp-field-class>
		<table-column>ActivityBean_upk</table-column>
		<sql-type>INTEGER</sql-type>
		<type-converter>org.tranql.sql.typeconverter.SerializableConverter</type-converter>
	</cmp-field-mapping>

      <primkey-field>activityBean_upk</primkey-field>

	<key-generator>
		<auto-increment-table>
		        <sql>INSERT INTO Activity_Bean VALUES(null,activityId,startDate,price,endDate,headCount,location,name,null)</sql>
	        	<return-type>java.lang.Integer</return-type>
      		</auto-increment-table>
	</key-generator>


	 <resource-ref>
		  <ref-name>jdbc/adventure/AdventureDB</ref-name>
		  <resource-link>MysqlDataSource</resource-link>
	 </resource-ref>
    </entity>
    <entity>
      <ejb-name>TransportationBean</ejb-name>
      <jndi-name>com.sun.j2ee.blueprints.opc.purchaseorder.ejb.TransportationLocalHome</jndi-name>
      <table-name>Transportation_Bean</table-name>
      <cmp-field-mapping>
        <cmp-field-name>transportationId</cmp-field-name>
        <table-column>transportationId</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>departureDate</cmp-field-name>
        <table-column>departureDate</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>destination</cmp-field-name>
        <table-column>destination</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>travelClass</cmp-field-name>
        <table-column>travelClass</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>price</cmp-field-name>
        <table-column>price</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>carrier</cmp-field-name>
        <table-column>carrier</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>origin</cmp-field-name>
        <table-column>origin</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>departureTime</cmp-field-name>
        <table-column>departureTime</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>headCount</cmp-field-name>
        <table-column>headCount</table-column>
      </cmp-field-mapping>


	<cmp-field-mapping>
		<cmp-field-name>transportationBean_upk</cmp-field-name>
		<cmp-field-class>java.lang.Integer</cmp-field-class>
		<table-column>TransportationBean_upk</table-column>
		<sql-type>INTEGER</sql-type>
		<type-converter>org.tranql.sql.typeconverter.SerializableConverter</type-converter>
	</cmp-field-mapping>

        <primkey-field>transportationBean_upk</primkey-field>

	<key-generator>
		<auto-increment-table>
		      <sql>INSERT INTO Transportation_Bean VALUES(null,transportationId,departureDate,destination,travelClass,price,carrier,origin,departureTime,headCount)</sql>
	        	<return-type>java.lang.Integer</return-type>
      		</auto-increment-table>
	</key-generator>


	 <resource-ref>
		  <ref-name>jdbc/adventure/AdventureDB</ref-name>
		  <resource-link>MysqlDataSource</resource-link>
	 </resource-ref>

    </entity>
    <entity>
      <ejb-name>ContactInfoBean</ejb-name>
      <jndi-name>com.sun.j2ee.blueprints.opc.purchaseorder.ejb.ContactInfoLocalHome</jndi-name>
      <table-name>ContactInfo</table-name>
      <cmp-field-mapping>
        <cmp-field-name>phone</cmp-field-name>
        <table-column>phone</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>email</cmp-field-name>
        <table-column>email</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>givenName</cmp-field-name>
        <table-column>givenName</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>familyName</cmp-field-name>
        <table-column>familyName</table-column>
      </cmp-field-mapping>

		<!-- Included from jbosscmp-jdbc.xml   -->
	<cmp-field-mapping>
		<cmp-field-name>contactInfoBean_upk</cmp-field-name>
		<cmp-field-class>java.lang.Integer</cmp-field-class>
		<table-column>ContactInfoBean_upk</table-column>
		<sql-type>INTEGER</sql-type>
		<type-converter>org.tranql.sql.typeconverter.SerializableConverter</type-converter>
	</cmp-field-mapping>

        <primkey-field>contactInfoBean_upk</primkey-field>

	<key-generator>
		<auto-increment-table>
		        <sql>INSERT INTO ContactInfo VALUES(null,phone,email,givenName,familyName,null)</sql>
	        	<return-type>java.lang.Integer</return-type>
      		</auto-increment-table>
	</key-generator>


      <ejb-local-ref>
        <ref-name>ejb/local/Address</ref-name>
        <name>AddressBean</name>
      </ejb-local-ref>


	 <resource-ref>
		  <ref-name>jdbc/adventure/AdventureDB</ref-name>
		  <resource-link>MysqlDataSource</resource-link>
	 </resource-ref>
    </entity>
    <entity>
      <ejb-name>AddressBean</ejb-name>
      <jndi-name>com.sun.j2ee.blueprints.opc.purchaseorder.ejb.AddressLocalHome</jndi-name>
      <table-name>Address</table-name>
      <cmp-field-mapping>
        <cmp-field-name>streetName1</cmp-field-name>
        <table-column>streetName1</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>streetName2</cmp-field-name>
        <table-column>streetName2</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>city</cmp-field-name>
        <table-column>city</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>state</cmp-field-name>
        <table-column>state</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>postalCode</cmp-field-name>
        <table-column>postalCode</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>country</cmp-field-name>
        <table-column>country</table-column>
      </cmp-field-mapping>


	<cmp-field-mapping>
		<cmp-field-name>addressBean_upk</cmp-field-name>
		<cmp-field-class>java.lang.Integer</cmp-field-class>
		<table-column>AddressBean_upk</table-column>
		<sql-type>INTEGER</sql-type>
		<type-converter>org.tranql.sql.typeconverter.SerializableConverter</type-converter>
	</cmp-field-mapping>

        <primkey-field>addressBean_upk</primkey-field>

	<key-generator>
		<auto-increment-table>
		        <sql>INSERT INTO Address VALUES(null,streetName1,streetName2,city,state,postalCode,country)</sql>
	        	<return-type>java.lang.Integer</return-type>
      		</auto-increment-table>
	</key-generator>


	 <resource-ref>
		  <ref-name>jdbc/adventure/AdventureDB</ref-name>
		  <resource-link>MysqlDataSource</resource-link>
	 </resource-ref>
    </entity>
    <entity>
      <ejb-name>LodgingBean</ejb-name>
      <jndi-name>com.sun.j2ee.blueprints.opc.purchaseorder.ejb.LodgingLocalHome</jndi-name>
      <table-name>Lodging_Bean</table-name>
      <cmp-field-mapping>
        <cmp-field-name>startDate</cmp-field-name>
        <table-column>startDate</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>lodgingId</cmp-field-name>
        <table-column>lodgingId</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>noNights</cmp-field-name>
        <table-column>noNights</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>endDate</cmp-field-name>
        <table-column>endDate</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>location</cmp-field-name>
        <table-column>location</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>noRooms</cmp-field-name>
        <table-column>noRooms</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>name</cmp-field-name>
        <table-column>name</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>pricePerNight</cmp-field-name>
        <table-column>pricePerNight</table-column>
      </cmp-field-mapping>
		<!-- Included from jbosscmp-jdbc.xml   -->
	<cmp-field-mapping>
		<cmp-field-name>lodgingBean_upk</cmp-field-name>
		<cmp-field-class>java.lang.Integer</cmp-field-class>
		<table-column>LodgingBean_upk</table-column>
		<sql-type>INTEGER</sql-type>
		<type-converter>org.tranql.sql.typeconverter.SerializableConverter</type-converter> 
	</cmp-field-mapping>

        <primkey-field>lodgingBean_upk</primkey-field>

	<key-generator>
		<auto-increment-table>
		        <sql>INSERT INTO Lodging_Bean VALUES(null,startDate,lodgingId,noNights,endDate,location,noRooms,name,pricePerNight)</sql>
	        	<return-type>java.lang.Integer</return-type>
      		</auto-increment-table>
	</key-generator>


	 <resource-ref>
		  <ref-name>jdbc/adventure/AdventureDB</ref-name>
		  <resource-link>MysqlDataSource</resource-link>
	 </resource-ref>
    </entity>
    <session>
      <ejb-name>PoEndpointBean</ejb-name>
      <jndi-name>PoEndpointBean</jndi-name>
      <resource-ref>
        <ref-name>jms/opc/QueueConnectionFactory</ref-name>
  	  <resource-link>JmsXA</resource-link>     
      </resource-ref>
      <web-service-address>http://localhost:8080/webservice/PoEndpointBean</web-service-address>     
    </session>
    <session>
      <ejb-name>BrokerServiceBean</ejb-name>
      <jndi-name>BrokerServiceBean</jndi-name>
      <resource-ref>
        <ref-name>jms/opc/QueueConnectionFactory</ref-name>
	  <resource-link>JmsXA</resource-link>        
      </resource-ref>
      <web-service-address>http://localhost:8080/webservice/WebServiceBroker</web-service-address>
     
    </session>
    <session>
      <ejb-name>OtEndpointBean</ejb-name>
      <jndi-name>OtEndpointBean</jndi-name>
      <ejb-local-ref>
        <ref-name>ejb/local/processmanager/ProcessManager</ref-name>
        <name>ProcessManagerBean</name>
      </ejb-local-ref>
      <ejb-local-ref>
        <ref-name>ejb/local/purchaseorder/PurchaseOrder</ref-name>
        <name>PurchaseOrderBean</name> 
      </ejb-local-ref>
      <web-service-address>http://localhost:8080/webservice/OtEndpointBean</web-service-address>
    </session>
    <message-driven>
      <ejb-name>WorkFlowManagerBean</ejb-name>

      <resource-adapter>
	  <resource-link>ActiveMQ AdventureBuilder</resource-link>
      </resource-adapter>
	<resource-ref>
        <ref-name>jms/opc/QueueConnectionFactory</ref-name>
	  <resource-link>JmsXA</resource-link>

      </resource-ref>
    </message-driven>
    <message-driven>
      <ejb-name>OrderFillerBean</ejb-name>
      <resource-adapter>
	  <resource-link>ActiveMQ AdventureBuilder</resource-link>
      </resource-adapter>	

      <resource-ref>
        <ref-name>jms/opc/QueueConnectionFactory</ref-name>
	  <resource-link>JmsXA</resource-link>
      </resource-ref>
    </message-driven>
    <message-driven>
      <ejb-name>BrokerRequestorBean</ejb-name>
    
      <resource-adapter>
	  <resource-link>ActiveMQ AdventureBuilder</resource-link>
      </resource-adapter>
	<resource-ref>
        <ref-name>jms/opc/QueueConnectionFactory</ref-name>
	  <resource-link>JmsXA</resource-link>        
      </resource-ref>
    </message-driven>
    <message-driven>
      <ejb-name>CRMBean</ejb-name>     
      <resource-adapter>
	  <resource-link>ActiveMQ AdventureBuilder</resource-link>
      </resource-adapter>
      <resource-ref>
        <ref-name>jms/opc/QueueConnectionFactory</ref-name>
	 <resource-link>JmsXA</resource-link>
      </resource-ref>
    </message-driven>
  </enterprise-beans>

   <relationships>
        <ejb-relation>
		<ejb-relation-name>ContactAddressRelations</ejb-relation-name>
            <ejb-relationship-role>
                <ejb-relationship-role-name>ContactInfoBean</ejb-relationship-role-name>
		    <relationship-role-source>
                    <ejb-name>ContactInfoBean</ejb-name>
                </relationship-role-source>
                <cmr-field>
                    <cmr-field-name>address</cmr-field-name>
                </cmr-field>
		    <foreign-key-column-on-source/>
		    <role-mapping>
			    <cmr-field-mapping>
		    		  <key-column>AddressBean_upk</key-column>
				  <foreign-key-column>address</foreign-key-column>
			    </cmr-field-mapping>
		    </role-mapping>	  
	       </ejb-relationship-role>
	   </ejb-relation>

	 <ejb-relation>
		<ejb-relation-name>PurchaseTransportationRelations</ejb-relation-name>
            <ejb-relationship-role>
                <ejb-relationship-role-name>PurchaseOrderBean</ejb-relationship-role-name>
		    <relationship-role-source>
                    <ejb-name>PurchaseOrderBean</ejb-name>
                </relationship-role-source>
                <cmr-field>
                    <cmr-field-name>returnFlightInfo</cmr-field-name>
                </cmr-field>
	          <foreign-key-column-on-source/>	
		    <role-mapping>
			    <cmr-field-mapping>
		    		  <key-column>TransportationBean_upk</key-column>
				  <foreign-key-column>returnFlightInfo</foreign-key-column>
			    </cmr-field-mapping>
		    </role-mapping>	  
	       </ejb-relationship-role>
	   </ejb-relation>

	 <ejb-relation>
		<ejb-relation-name>PurchaseLodgingRelations</ejb-relation-name>
            <ejb-relationship-role>
                <ejb-relationship-role-name>PurchaseOrderBean</ejb-relationship-role-name>
		    <relationship-role-source>
                    <ejb-name>PurchaseOrderBean</ejb-name>
                </relationship-role-source>
                <cmr-field>
                    <cmr-field-name>lodging</cmr-field-name>
                </cmr-field>
		    <foreign-key-column-on-source/>
		    <role-mapping>
			    <cmr-field-mapping>
		    		  <key-column>LodgingBean_upk</key-column>
				  <foreign-key-column>lodging</foreign-key-column>
			    </cmr-field-mapping>
		    </role-mapping>	  
	       </ejb-relationship-role>
	   </ejb-relation>

	 <ejb-relation>
		<ejb-relation-name>PurchaseActivityRelations</ejb-relation-name>
            <ejb-relationship-role>
                <ejb-relationship-role-name>PurchaseOrderBean</ejb-relationship-role-name>
		    <relationship-role-source>
                    <ejb-name>PurchaseOrderBean</ejb-name>
                </relationship-role-source>
                <cmr-field>
                    <cmr-field-name>activities</cmr-field-name>
                </cmr-field>
		    <role-mapping>
			    <cmr-field-mapping>
		    		  <key-column>poId</key-column>
				  <foreign-key-column>PurchaseOrderBean_activities</foreign-key-column>
			    </cmr-field-mapping>
		    </role-mapping>	  
	       </ejb-relationship-role>
	   </ejb-relation>

	  <ejb-relation>
		<ejb-relation-name>PurchaseTransportationRelations1</ejb-relation-name>
            <ejb-relationship-role>
                <ejb-relationship-role-name>PurchaseOrderBean</ejb-relationship-role-name>
		    <relationship-role-source>
                    <ejb-name>PurchaseOrderBean</ejb-name>
                </relationship-role-source>
                <cmr-field>
                    <cmr-field-name>departureFlightInfo</cmr-field-name>
                </cmr-field>
		    <foreign-key-column-on-source/>
		    <role-mapping>
			    <cmr-field-mapping>
		    		  <key-column>TransportationBean_upk</key-column>
				  <foreign-key-column>departureFlightInfo</foreign-key-column>
			    </cmr-field-mapping>
		    </role-mapping>	  
	       </ejb-relationship-role>
	   </ejb-relation>

	   <ejb-relation>
		<ejb-relation-name>PurchaseContactRelations</ejb-relation-name>
            <ejb-relationship-role>
                <ejb-relationship-role-name>PurchaseOrderBean</ejb-relationship-role-name>
		    <relationship-role-source>
                    <ejb-name>PurchaseOrderBean</ejb-name>
                </relationship-role-source>
                <cmr-field>
                    <cmr-field-name>billingInfo</cmr-field-name>
                </cmr-field>
		    <foreign-key-column-on-source/>
		    <role-mapping>
			    <cmr-field-mapping>
		    		  <key-column>ContactInfoBean_upk</key-column>
				  <foreign-key-column>billingInfo</foreign-key-column>
			    </cmr-field-mapping>
		    </role-mapping>	  
	       </ejb-relationship-role>
	   </ejb-relation>
	
 	 <ejb-relation>
		<ejb-relation-name>PurchaseContactRelations1</ejb-relation-name>
            <ejb-relationship-role>
                <ejb-relationship-role-name>PurchaseOrderBean</ejb-relationship-role-name>
		    <relationship-role-source>
                    <ejb-name>PurchaseOrderBean</ejb-name>
                </relationship-role-source>
                <cmr-field>
                    <cmr-field-name>shippingInfo</cmr-field-name>
                </cmr-field>
		    <foreign-key-column-on-source/>
		    <role-mapping>
			    <cmr-field-mapping>
		    		  <key-column>ContactInfoBean_upk</key-column>
				  <foreign-key-column>shippingInfo</foreign-key-column>
			    </cmr-field-mapping>
		    </role-mapping>	  
	       </ejb-relationship-role>
	   </ejb-relation>

        <ejb-relation>
		<ejb-relation-name>PurchaseCreditRelations</ejb-relation-name>
            <ejb-relationship-role>
                <ejb-relationship-role-name>PurchaseOrderBean</ejb-relationship-role-name>
		    <relationship-role-source>
                    <ejb-name>PurchaseOrderBean</ejb-name>
                </relationship-role-source>
                <cmr-field>
                    <cmr-field-name>creditCard</cmr-field-name>
                </cmr-field>
	         <foreign-key-column-on-source/>
		    <role-mapping>
			    <cmr-field-mapping>
		    		  <key-column>CreditCardBean_upk</key-column>
				  <foreign-key-column>creditCard</foreign-key-column>
			    </cmr-field-mapping>
		    </role-mapping>	  
	       </ejb-relationship-role>
	   </ejb-relation>

    </relationships>
</openejb-jar>


(6) ProcessManager Plan																						<?xml version="1.0" encoding="UTF-8"?>
<openejb-jar configId=""
  xmlns="http://www.openejb.org/xml/ns/openejb-jar"
  xmlns:naming="http://geronimo.apache.org/xml/ns/naming" xmlns:sys="http://geronimo.apache.org/xml/ns/deployment">
 
<cmp-connection-factory>
	<resource-link>MysqlDataSource</resource-link>
</cmp-connection-factory>
  <enterprise-beans>
    <session>
      <ejb-name>ProcessManagerBean</ejb-name>
      <jndi-name>com.sun.j2ee.blueprints.processmanager.ejb.ProcessManagerLocalHome</jndi-name>
      <local-jndi-name>com.sun.j2ee.blueprints.processmanager.ejb.ProcessManagerLocalHome</local-jndi-name>
      <ejb-local-ref>
        <ref-name>ejb/local/processmanager/Manager</ref-name>
        <name>ManagerBean</name>
      </ejb-local-ref>
    </session>
   
    <entity>
      <ejb-name>ManagerBean</ejb-name>
      <jndi-name>com.sun.j2ee.blueprints.processmanager.manager.ejb.ManagerLocalHome</jndi-name>
      <local-jndi-name>com.sun.j2ee.blueprints.processmanager.manager.ejb.ManagerLocalHome</local-jndi-name>
      <table-name>Manager</table-name>
      <cmp-field-mapping>
        <cmp-field-name>lodgingOrderStatus</cmp-field-name>
	  <cmp-field-class>String</cmp-field-class>
        <table-column>lodgingOrderStatus</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>orderError</cmp-field-name>
	  <cmp-field-class>boolean</cmp-field-class>
        <table-column>orderError</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>orderId</cmp-field-name>
	  <cmp-field-class>String</cmp-field-class>
        <table-column>orderId</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>status</cmp-field-name>
	  <cmp-field-class>String</cmp-field-class>
        <table-column>status</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>activityOrderStatus</cmp-field-name>
	  <cmp-field-class>String</cmp-field-class>
        <table-column>activityOrderStatus</table-column>
      </cmp-field-mapping>
      <cmp-field-mapping>
        <cmp-field-name>airlineOrderStatus</cmp-field-name>
	  <cmp-field-class>String</cmp-field-class>
        <table-column>airlineOrderStatus</table-column>
      </cmp-field-mapping>

      <primkey-field>orderId</primkey-field>
	 <resource-ref>
		  <ref-name>jdbc/adventure/AdventureDB</ref-name>
		  <resource-link>MysqlDataSource</resource-link>
	 </resource-ref>
    </entity>
  </enterprise-beans>

</openejb-jar>


Thanks & Regards,
S.Saraswathi



-----Original Message-----
From: Jakob Roesgaard Færch [mailto:jrf@trifork.com]
Sent: Wednesday, December 07, 2005 1:48 AM
To: dev@geronimo.apache.org
Subject: Re: Java Adventure Builder Reference 1.0.3 webapp deployed

Selvaraj, Saraswathi (Cognizant) wrote:
> Hi Jacek,
>
>      I solved the url issue by including the <web-service-address> tag
> in the POEndpointBean defined in opc-plan.
>
> We have to deploy all the modules because the OPC- depends on the rest
> of the modules.
>
> 
>
> Apart from the previous plans that I have published, major changes
> includes the CMP relationship definitions in the activitysupplier-plan
> and opc-plan
>
> (I am not able to view the previous plans that I have published already
> in the thread now....why?)
>

I haven't been able to find any messages in the thread containing any
more plans than the two in your message today, so you're not the only
one unable to view the plans.

Would it be possible for you to resend all the plans you are currently
using (including the jms plan I guess you must have written and plans
for mail and principal objects if you have gotten so far)?
Without these plans, the effort I am able to put into the adventure
builder will most probably duplicate the work you have already done,
which is a shame when we're this close to getting the app to run.

Kindly,
Jakob

This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly
prohibited and may be unlawful.

  Visit us at http://www.cognizant.com

Mime
View raw message