Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Order Booking Tutorial fails : GetOrderId results in Toplink error

6416Nov 2 2006 — edited Nov 3 2006
Below I copied some information that is visible from within the BPEL Process Manager. Can anybody tell me, what I did wrong?
<?xml version = '1.0' encoding = 'UTF-8'?>
<BPELTest processName="SOAOrderBooking" xmlns="http://xmlns.oracle.com/bpel/instancedriver">
   <initiate operation="initiate">
      <inboundMessage>
         <part name="payload">
            <content>
               <ns0:SOAOrderBookingProcessRequest xmlns:ns0="http://www.globalcompany.com/ns/OrderBooking">
                 <ns1:PurchaseOrder xmlns:ns1="http://www.globalcompany.com/ns/order">
                    <ns1:CustID>10</ns1:CustID>
                    <ns1:ID>192</ns1:ID>
                    <ns1:UserContact>
                       <ns1:PhoneNumber>18008888000</ns1:PhoneNumber>
                       <ns1:EmailAddress>sking@soademo.org</ns1:EmailAddress>
                    </ns1:UserContact>
                    <ns1:OrderItems>
                       <ns1:Item>
                          <ns1:ProductName>HD Television</ns1:ProductName>
                          <ns1:itemType>Video</ns1:itemType>
                          <ns1:partnum>128723</ns1:partnum>
                          <ns1:price>1999</ns1:price>
                          <ns1:Quantity>10</ns1:Quantity>
                       </ns1:Item>
                    </ns1:OrderItems>
                    <ns1:SupplierInfo>
                       <ns1:SupplierPrice>17991.0</ns1:SupplierPrice>
                       <ns1:SupplierName>Express Deliveries</ns1:SupplierName>
                    </ns1:SupplierInfo>
                    <ns1:OrderInfo>
                       <ns1:OrderDate>2006-11-02</ns1:OrderDate>
                       <ns1:OrderPrice>19990</ns1:OrderPrice>
                       <ns1:OrderStatus>pending</ns1:OrderStatus>
                       <ns1:OrderComments>This order was issued from the SOA Retail Client.</ns1:OrderComments>
                    </ns1:OrderInfo>
                 </ns1:PurchaseOrder>
              </ns0:SOAOrderBookingProcessRequest>
            </content>
         </part>
      </inboundMessage>
   </initiate>
   <activityDriver name="GetOrderId" firstIteration="1" lastIteration="1">
      <emulate>
         <inboundFault xmlns:faultNS="http://schemas.oracle.com/bpel/extension">faultNS:remoteFault</inboundFault>
         <inboundMessage>
            <part name="code">
               <content>
                  <code xmlns="http://schemas.oracle.com/bpel/extension">0</code>
               </content>
            </part>
            <part name="summary">
               <content>
                  <summary xmlns="http://schemas.oracle.com/bpel/extension">file:/opt/oracle/product/10.1.3.1/soa_1/bpel/domains/default/tmp/.bpel_SOAOrderBooking_1.0_937b09d1bd8dae1b33b028b2871aef63.tmp/OrderSequence.wsdl [ OrderSequence_ptt::OrderSequence(OrderSequenceInput_msg,OrderSequenceOutputCollection) ] - WSIF JCA Execute of operation 'OrderSequence' failed due to: DBWriteInteractionSpec Execute Failed Exception.
                      unknown failed. Descriptor name: [unknown]. [Caused by: The method 'commit' cant be called when a global transaction is active.]
                      ; nested exception is: 
                      	ORABPEL-11616
                      DBWriteInteractionSpec Execute Failed Exception.
                      unknown failed. Descriptor name: [unknown]. [Caused by: The method 'commit' cant be called when a global transaction is active.]
                      Caused by Exception [TOPLINK-4002] (Oracle TopLink - 10g Release 3 (10.1.3.1.0) (Build 061004)): oracle.toplink.exceptions.DatabaseException
                      Internal Exception: java.sql.SQLException: The method 'commit' cant be called when a global transaction is active.Error Code: 0.
                      </summary>
               </content>
            </part>
            <part name="detail">
               <content>
                  <detail xmlns="http://schemas.oracle.com/bpel/extension">
                      Internal Exception: java.sql.SQLException: The method 'commit' cant be called when a global transaction is active.Error Code: 0
                  </detail>
               </content>
           </part>
         </inboundMessage>
      </emulate>
   </activityDriver>
</BPELTest>
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 1 2006
Added on Nov 2 2006
3 comments
1,836 views