# XCustomer.xsd Sample

This topic inludes the source code for the XCustomer.xsd Sample.

## Sample Location

This sample is located in the following directory in your WebLogic Workshop installation:

BEA_HOME/weblogic81/samples/workshop/SamplesApp/Schemas/

## Sample Source Code

`01 <?xml version="1.0" encoding="UTF-8"?> 02 <xsd:schema targetNamespace="java:///database/customer_db" xmlns="java:///database/customer_db" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:wld="http://www.bea.com/2002/10/weblogicdata" elementFormDefault="qualified" attributeFormDefault="unqualified"> 03 <xsd:element name="XCustomer" wld:DefaultNamespace="java:///database/customer_db" wld:RowSet="true"> 04 <xsd:complexType> 05 <xsd:choice maxOccurs="unbounded"> 06 <xsd:element name="XCustomerRow"> 07 <xsd:complexType> 08 <xsd:sequence> 09 <xsd:element name="CUSTID" type="xsd:int" wld:JDBCType="INTEGER" minOccurs="0" wld:TableName="WEBLOGIC.CUSTOMER" nillable="true"></xsd:element> 10 <xsd:element name="NAME" type="xsd:string" wld:JDBCType="VARCHAR" minOccurs="0" wld:TableName="WEBLOGIC.CUSTOMER" nillable="true"></xsd:element> 11 <xsd:element name="ADDRESS" type="xsd:string" wld:JDBCType="VARCHAR" minOccurs="0" wld:TableName="WEBLOGIC.CUSTOMER" nillable="true"></xsd:element> 12 <xsd:element name="CITY" type="xsd:string" wld:JDBCType="VARCHAR" minOccurs="0" wld:TableName="WEBLOGIC.CUSTOMER" nillable="true"></xsd:element> 13 <xsd:element name="STATE" type="xsd:string" wld:JDBCType="CHAR" minOccurs="0" wld:TableName="WEBLOGIC.CUSTOMER" nillable="true"></xsd:element> 14 <xsd:element name="ZIP" type="xsd:string" wld:JDBCType="VARCHAR" minOccurs="0" wld:TableName="WEBLOGIC.CUSTOMER" nillable="true"></xsd:element> 15 <xsd:element name="AREA_CODE" type="xsd:string" wld:JDBCType="CHAR" minOccurs="0" wld:TableName="WEBLOGIC.CUSTOMER" nillable="true"></xsd:element> 16 <xsd:element name="PHONE" type="xsd:string" wld:JDBCType="CHAR" minOccurs="0" wld:TableName="WEBLOGIC.CUSTOMER" nillable="true"></xsd:element> 17 </xsd:sequence> 18 <xsd:anyAttribute namespace="http://www.bea.com/2002/10/weblogicdata" processContents="skip"></xsd:anyAttribute> 19 </xsd:complexType> 20 </xsd:element> 21 </xsd:choice> 22 </xsd:complexType> 23 </xsd:element> 24 </xsd:schema>`