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:[EMAIL PROTECTED]
Sent: Wednesday, December 07, 2005 1:48 AM
To: [email protected]
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
