create table Cars
(
CarID int identity primary key,
Make varchar(50) not null,
Model varchar(50) not null,
Description varchar(800) not null
)
go

create table Inventory
(
SKU int identity primary key,
CarID int not null,
Price int not null,
Status varchar(50)
)
go

create view CarInventory
as
select c.CarID, Make, Model, Description, SKU, Price, Status
from Cars c, Inventory i where c.CarID = i.CarID
go

----------------------------------
-- Sample Data
----------------------------------

insert Cars select "Volkswagen", "New Beetle",
"The 2003 New Beetle is a 2-door, 4-passenger family coupe, or sports coupe,
available in 8 trims, ranging from the GL 2.0L to the Turbo S 1.8L."

insert Cars select "Mini", "Cooper",
"The new Mini Cooper is more fun than a carnival ride. Both models handle
like sports cars and the Mini Cooper S can accelerate from 0 to 60 mph in
less than seven seconds."

insert Cars select "Mercedes-Benz", "SL-Class",
"The 2003 SL-Class is a 2-door, 2-passenger luxury convertible, or convertible
sports car, available in two trims, the SL500 Roadster and the SL55
AMG Roadster."

insert Cars select "Land Rover", "Range Rover",
"The 2003 Range Rover is a 4-door, 5-passenger luxury sport-utility,
available in one trim only, the HSE."

insert Cars select "Honda", "Civic Coupe",
"The 2003 Civic Coupe is a 2-door, 5-passenger family coupe, available
in 16 trims, ranging from the DX 5-spd MT to the EX 4-spd AT w/
Front Side Airbags."

insert Inventory select 1, 18999, "Available"

insert Inventory select 2, 17597, "Available"

insert Inventory select 3, 92399, "Available"

insert Inventory select 4, 71200, "Available"

insert Inventory select 5, 12110, "Available"

------------------------------------------
-- Manufacturer Web Service Tables
------------------------------------------

create table ManufacturerOrders
(
OrderNumber int identity primary key,
SKU int not null,
Make varchar(50) not null,
Model varchar(50) not null,
Price int not null,
Status varchar(20) not null
)
go

Create table BasePrices
(
Make varchar(50) not null,
Model varchar(50) not null,
Price int not null,
primary key (Make, Model)
)
go

------------------------------------------
-- Manufacturer Web Service Tables
------------------------------------------

create procedure AddOrder ( int, varchar(50), varchar(50),
int, varchar(20))
as
set nocount on;

insert ManufacturerOrders
select , , , ,

select @ as "ID"
go

create procedure UpdateOrder ( int)
as
set nocount on

update ManufacturerOrders set Status = "Shipped" where
OrderNumber = ;

SELECT SKU, Price FROM ManufacturerOrders
WHERE OrderNumber =
go

------------------------------------------
-- Manufacturer Web Sample Data
------------------------------------------

insert BasePrices select "Volkswagen", "New Beetle", 18000
insert BasePrices select "Mini", "Cooper", 1700
insert BasePrices select "Mercedes-Benz", "SL-Class", 85000
insert BasePrices select "Honda", "Civic Coupe", 12000
insert BasePrices select "Land Rover", "Range Rover", 65000

public void ejbPostCreate()
throws CreateException
{}

// Put the message in the request string so we can show it on the JSP
getRequest().setAttribute("Message", OrderText);

return new Forward("success");
}

try{
// Use my entity bean wrapper to access the Inventory EJB
Car IBean = inventoryEJB.findByPrimaryKey(SKU);

// Can only sell the car if it is available
if (IBean.getStatus().equals("Available"))
{
// Set the status of the car to sold
IBean.setStatus("Sold to " + User);
OrderText = "Thank you for your order, " + User + ".
Your bill is +
IBean.getPrice() + ".";

// Create a new car based on the old car to
replace it in inventory
Car NewBean = inventoryEJB.create();
NewBean.setCarID(IBean.getCarID());
NewBean.setPrice(-1);
NewBean.setStatus("Waiting to be ordered");
}
else
// Opps. Someone else got it first.
OrderText = "I'm sorry. That vehicle has been sold.
Please choose another one.";

} catch (Exception e){
OrderText = "Error using EJB: " + e.getMessage();
}

return OrderText;
}

try {
// Print information
System.out.println("Got a message!");
System.out.println("Contents of the message:" +
((TextMessage)msg).getText());
} catch (Exception e) {
System.out.println("Exception in ListenBean: " + e.getMessage());
}
}
}

import com.bea.control.*;
import java.sql.SQLException;

/**
* :connection data-source-jndi-name="WASDataSource"
*/
public interface CSDataAccess extends DatabaseControl,
com.bea.control.ControlExtension
{
static public class Order
{
public int SKU;
public int Price;
}

static final long serialVersionUID = 1L;

/**
* :sql statement="exec UpdateOrder {OrderNumber}"
*/
Order sendOrder(int OrderNumber);

/**
* :sql statement="exec AddOrder {SKU}, {Make}, {Model},
{Price}, {Status}"
*/
int createOrder(int SKU, String Make, String Model,
int Price, String Status);

/**
* :sql statement="Select Price from BasePrices where Make =
{Make} and Model = {Model}"
*/
int getPrice(String Make, String Model);
}

// Start timer
csTimer.start();

return;
}

// put a message in the console window
System.out.println("[CarSource]Ordering 1 " + myCar.getMake() + " "
+ myCar.getModel() + " from other manufacturing.");

// Create a new order item in the DB and get the order number
orderCar(myCar.getSKU(), myCar.getMake(), myCar.getModel(),
nMarkupMax);

// Send back the order number
return OrderNumber.toString();
}

retOrder.setOrderNumber(OrderNumber.intValue());
retOrder.setPrice(myOrder.Price);
retOrder.setSKU(myOrder.SKU);
retOrder.setStatus("Shipped");

System.out.println("[CarSource]Order " + OrderNumber + "
Complete. Sending message back to requestor.");

callback.finishOrder(myOrderDoc);

return;
}

public interface Callback extends com.bea.control.ServiceControl
{
// Send the car order info back to the requesting web service
/**
* :conversation phase="finish"
*/
public void finishOrder(OrderCarDocument yourOrder);
}

<SOAP-ENV:Envelope xmlns:SOAP-ENV=
"http://schemas.xmlsoap.org/soap/envelope/"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<SOAP-ENV:Body>
<ns:orderOtherResponse xmlns:ns="http://www.openuri.org/">
<ns:orderOtherResult>1</ns:orderOtherResult>
</ns:orderOtherResponse>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

<SOAP-ENV:Envelope xmlns:SOAP-ENC=
"http://schemas.xmlsoap.org/soap/encoding/"
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<SOAP-ENV:Header>
<CallbackHeader xmlns=
"http://www.openuri.org/2002/04/soap/conversation/">
<conversationID>1057964523220</conversationID>
</CallbackHeader>
</SOAP-ENV:Header>
<SOAP-ENV:Body>
<ns:finishOrder xmlns:ns="http://www.openuri.org/">
<bea:OrderCar xmlns:bea="http://www.BEA-OrderCar.com">
<bea:SKU>3</bea:SKU>
<bea:Price>19162</bea:Price>
<bea:OrderNumber>1</bea:OrderNumber>
<bea:Status>Shipped</bea:Status>
</bea:OrderCar>
</ns:finishOrder>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

// put a message in the console window
System.out.println("[CarSource]Ordering 1 " + myCar.getMake()
+ " " + myCar.getModel() + " from Honda manufacturing.");

// Create a new order item in the DB and get the order number
orderCar(myCar.getSKU(), "Honda", myCar.getModel(), nMarkupMax);

// Send back the order number
return OrderNumber.toString();
}

/**
* :protocol form-post="false" form-get="false"
* :conversation phase="start"
*/
public java.lang.String orderHonda
(com.beaHonda.HondaCarDocument HondaCar);

/**
* :protocol form-post="false" form-get="false"
* :conversation phase="start"
*/
public java.lang.String orderOther
(com.beaOrderCar.OrderCarDocument OrderCar);

// Order the car from the proper manufacturer
String OrderNumber = new String();

if (sMake.equalsIgnoreCase("honda"))
{
// order from honda method

// Prepare the XML to send to the manufacturer
HondaCarDocument orderDoc = HondaCarDocument.Factory.newInstance();
HondaCar order = orderDoc.addNewHondaCar();

order.setEngine("I4");
order.setModel(sModel);
order.setOptions("Basic");
order.setCountrycode(03);
order.setSKU(nSKU.intValue());

System.out.println("Ordering 1 " + sModel +
" from Honda manufacturer.");

OrderNumber = carSourceWSControl.orderHonda(orderDoc);
}
else
{
// order a car through the normal channel

// Prepare the XML to send to the manufacturer
OrderCarDocument orderDoc =
OrderCarDocument.Factory.newInstance();
OrderCar order = orderDoc.addNewOrderCar();

order.setMake(sMake);
order.setModel(sModel);
order.setOptions("Loaded");
order.setYear(2003);
order.setSKU(nSKU.intValue());

// Print out the message
System.out.println("Ordering 1 " + sModel +
" from other manufacturer.");

OrderNumber = carSourceWSControl.orderOther(orderDoc);
}

System.out.println("Received Order Number " + OrderNumber );

// Add the car to inventory and set the status as ordered
wASControl.AddCarToInventory(new Integer(SKU),
new Integer(OrderNumber));
}

try {
// Print information
System.out.println("Got a message!");
System.out.println("Contents of the message:" +
((TextMessage)msg).getText());

// Order the car via the OrderCarFromWS Web Service
OrderCarFromWS_Impl CSImpl = new OrderCarFromWS_Impl();
OrderCarFromWSSoap soap = CSImpl.getOrderCarFromWSSoap();
soap.orderFromCS(((TextMessage)msg).getText());

} catch (Exception e) {
System.out.println("Exception in ListenBean: " + e.getMessage());
}
}