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 Tue, 06 Dec 2005 13:12:58 GMT

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



ActivitySupplierPlan.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.Ac
tivityPurchaseOrderLocalHome</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.Ac
tivityDetailsLocalHome</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-co
lumn>

                      </cmr-field-mapping>

                  </role-mapping>

            </ejb-relationship-role>

      </ejb-relation>

 </relationships>





</openejb-jar>





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.PurchaseOrderLo
calHome</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.CreditCardLocal
Home</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.ActivityLocalHo
me</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,n
ull)</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.TransportationL
ocalHome</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.ContactInfoLoca
lHome</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.AddressLocalHom
e</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.LodgingLocalHom
e</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,p
ricePerNight)</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</we
b-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</we
b-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-nam
e>

                <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-nam
e>

                <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-nam
e>

                <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-nam
e>

                <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-nam
e>

                <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-nam
e>

                <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-nam
e>

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





The problem that I'am currently facing is that while doing checkout, the
cart values are not updated in the database.

I'am facing the issue, at the point: whenever the ManagerBean is trying
the update the status using the findByPrimayKey() and

I'am getting the following exception,







14:57:58,731 WARN  [SystemExceptionInterceptor] ManagerBean

javax.ejb.TransactionRolledbackLocalException

       at
org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolic
y.java:123)

       at
org.openejb.transaction.TransactionContextInterceptor.invoke(Transaction
ContextInterceptor.java:80)

       at
org.openejb.SystemExceptionInterceptor.invoke(SystemExceptionInterceptor
.java:82)

       at
org.openejb.GenericEJBContainer.invoke(GenericEJBContainer.java:238)

       at
org.openejb.proxy.EJBMethodInterceptor.intercept(EJBMethodInterceptor.ja
va:129)

       at
org.openejb.proxy.EntityEJBLocalHome$$EnhancerByCGLIB$$fd0189cc.findByPr
imaryKey(<generated>)

       at
com.sun.j2ee.blueprints.processmanager.ejb.ProcessManagerBean.updateStat
us(Unknown Source)

       at
com.sun.j2ee.blueprints.processmanager.ejb.ProcessManagerBean$$FastClass
ByCGLIB$$3f37cff8.invoke(<generated>)

       at
org.openejb.dispatch.AbstractMethodOperation.invoke(AbstractMethodOperat
ion.java:90)

       at
org.openejb.slsb.BusinessMethod.execute(BusinessMethod.java:67)

       at
org.openejb.dispatch.DispatchInterceptor.invoke(DispatchInterceptor.java
:72)

       at
org.apache.geronimo.naming.java.ComponentContextInterceptor.invoke(Compo
nentContextInterceptor.java:56)

       at
org.openejb.ConnectionTrackingInterceptor.invoke(ConnectionTrackingInter
ceptor.java:81)

       at
org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolic
y.java:119)

       at
org.openejb.transaction.TransactionContextInterceptor.invoke(Transaction
ContextInterceptor.java:80)

       at
org.openejb.slsb.StatelessInstanceInterceptor.invoke(StatelessInstanceIn
terceptor.java:98)

       at
org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolic
y.java:119)

       at
org.openejb.transaction.TransactionContextInterceptor.invoke(Transaction
ContextInterceptor.java:80)

       at
org.openejb.SystemExceptionInterceptor.invoke(SystemExceptionInterceptor
.java:82)

       at
org.openejb.GenericEJBContainer.invoke(GenericEJBContainer.java:238)

       at
org.openejb.proxy.EJBMethodInterceptor.intercept(EJBMethodInterceptor.ja
va:129)

       at
org.openejb.proxy.SessionEJBLocalObject$$EnhancerByCGLIB$$dcfe8e61.updat
eStatus(<generated>)

       at
com.sun.j2ee.blueprints.opc.workflowmanager.handlers.POHandler.handle(Un
known Source)

       at
com.sun.j2ee.blueprints.opc.workflowmanager.WorkFlowManagerBean.onMessag
e(Unknown Source)

       at
com.sun.j2ee.blueprints.opc.workflowmanager.WorkFlowManagerBean$$FastCla
ssByCGLIB$$2c23f31b.invoke(<generated>)

       at
org.openejb.dispatch.AbstractMethodOperation.invoke(AbstractMethodOperat
ion.java:90)

       at org.openejb.mdb.BusinessMethod.execute(BusinessMethod.java:66)

       at
org.openejb.dispatch.DispatchInterceptor.invoke(DispatchInterceptor.java
:72)

       at
org.apache.geronimo.naming.java.ComponentContextInterceptor.invoke(Compo
nentContextInterceptor.java:56)

       at
org.openejb.ConnectionTrackingInterceptor.invoke(ConnectionTrackingInter
ceptor.java:81)

       at
org.openejb.mdb.MDBInstanceInterceptor.invoke(MDBInstanceInterceptor.jav
a:92)

       at
org.openejb.SystemExceptionInterceptor.invoke(SystemExceptionInterceptor
.java:82)

       at org.openejb.mdb.MDBContainer.invoke(MDBContainer.java:239)

       at
org.openejb.mdb.EndpointHandler.invoke(EndpointHandler.java:180)

       at
org.openejb.mdb.EndpointHandler.intercept(EndpointHandler.java:223)

       at
org.openejb.mdb.EndpointProxy$$EnhancerByCGLIB$$69ce26c3.onMessage(<gene
rated>)

       at
org.activemq.ra.MessageEndpointProxy$MessageEndpointAlive.onMessage(Mess
ageEndpointProxy.java:136)

       at
org.activemq.ra.MessageEndpointProxy.onMessage(MessageEndpointProxy.java
:75)

       at org.activemq.ActiveMQSession.deliver(ActiveMQSession.java:567)

       at org.activemq.ActiveMQSession.run(ActiveMQSession.java:549)

       at
org.activemq.ra.ServerSessionImpl.run(ServerSessionImpl.java:164)

       at
org.apache.geronimo.connector.work.WorkerContext.run(WorkerContext.java:
291)

       at
EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown
Source)

       at java.lang.Thread.run(Thread.java:534)

Caused by: java.lang.ClassCastException

       at
org.tranql.sql.jdbc.binding.IntegerBinding.setValue(IntegerBinding.java:
47)

       at
org.tranql.sql.jdbc.binding.TypeConverterBinding.setValue(TypeConverterB
inding.java:93)

       at
org.tranql.sql.jdbc.binding.TypeConverterBinding.setValue(TypeConverterB
inding.java:89)

       at
org.tranql.sql.jdbc.JDBCUpdateCommand.execute(JDBCUpdateCommand.java:65)

       at
org.tranql.cache.SimpleFlushStrategy.flush(SimpleFlushStrategy.java:61)

       at
org.tranql.cache.SimpleFlushStrategy.flush(SimpleFlushStrategy.java:46)

       at org.tranql.cache.InTxCache.flush(InTxCache.java:85)

       at org.openejb.entity.cmp.CMPFinder.execute(CMPFinder.java:87)

       at
org.openejb.entity.cmp.SingleValuedFinder.execute(SingleValuedFinder.jav
a:80)

       at
org.openejb.dispatch.DispatchInterceptor.invoke(DispatchInterceptor.java
:72)

       at
org.apache.geronimo.naming.java.ComponentContextInterceptor.invoke(Compo
nentContextInterceptor.java:56)

       at
org.openejb.ConnectionTrackingInterceptor.invoke(ConnectionTrackingInter
ceptor.java:81)

       at
org.openejb.entity.EntityInstanceInterceptor.invoke(EntityInstanceInterc
eptor.java:136)

       at
org.openejb.entity.cmp.InTxCacheInterceptor.invoke(InTxCacheInterceptor.
java:84)

       at
org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolic
y.java:119)

       ... 43 more







I am not sure where I'm messing up.



Thanks & Regards,

S.Saraswathi







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