<repo_name>jimmyangarita/newGitTest<file_sep>/auction/common/xml/xml-discover/target/jaxws/wsimport/java/com/jdap/auction/common/xml/discover/JobPayload.java

package com.jdap.auction.common.xml.discover;

import javax.xml.bind.annotation.XmlAccessType;
import javax.xml.bind.annotation.XmlAccessorType;
import javax.xml.bind.annotation.XmlElement;
import javax.xml.bind.annotation.XmlSeeAlso;
import javax.xml.bind.annotation.XmlType;


/**
 * <p>Java class for JobPayload complex type.
 * 
 * <p>The following schema fragment specifies the expected content contained within this class.
 * 
 * <pre>
 * &lt;complexType name="JobPayload">
 *   &lt;complexContent>
 *     &lt;restriction base="{http://www.w3.org/2001/XMLSchema}anyType">
 *       &lt;sequence>
 *         &lt;element name="TaskIdEBO" type="{http://xmlns.dcim.emerson.com/cps/scheduler/ebo}TaskIdEBOType"/>
 *         &lt;element name="TaskActionIdEBO" type="{http://xmlns.dcim.emerson.com/cps/scheduler/ebo}TaskActionIdEBOType"/>
 *         &lt;element name="TaskActionParameters" type="{http://www.w3.org/2001/XMLSchema}base64Binary"/>
 *         &lt;element name="JobStatusEBOType" type="{http://xmlns.dcim.emerson.com/cps/scheduler/ebo}StatusEBOType"/>
 *       &lt;/sequence>
 *     &lt;/restriction>
 *   &lt;/complexContent>
 * &lt;/complexType>
 * </pre>
 * 
 * 
 */
@XmlAccessorType(XmlAccessType.FIELD)
@XmlType(name = "JobPayload", namespace = "http://xmlns.dcim.emerson.com/cps/scheduler/quartz-scheduler/ebo", propOrder = {
    "taskIdEBO",
    "taskActionIdEBO",
    "taskActionParameters",
    "jobStatusEBOType"
})
@XmlSeeAlso({
    ResumeTaskRequestEBM.class
})
public class JobPayload {

    @XmlElement(name = "TaskIdEBO", required = true)
    protected TaskIdEBOType taskIdEBO;
    @XmlElement(name = "TaskActionIdEBO", required = true)
    protected TaskActionIdEBOType taskActionIdEBO;
    @XmlElement(name = "TaskActionParameters", required = true)
    protected byte[] taskActionParameters;
    @XmlElement(name = "JobStatusEBOType", required = true)
    protected StatusEBOType jobStatusEBOType;

    /**
     * Gets the value of the taskIdEBO property.
     * 
     * @return
     *     possible object is
     *     {@link TaskIdEBOType }
     *     
     */
    public TaskIdEBOType getTaskIdEBO() {
        return taskIdEBO;
    }

    /**
     * Sets the value of the taskIdEBO property.
     * 
     * @param value
     *     allowed object is
     *     {@link TaskIdEBOType }
     *     
     */
    public void setTaskIdEBO(TaskIdEBOType value) {
        this.taskIdEBO = value;
    }

    /**
     * Gets the value of the taskActionIdEBO property.
     * 
     * @return
     *     possible object is
     *     {@link TaskActionIdEBOType }
     *     
     */
    public TaskActionIdEBOType getTaskActionIdEBO() {
        return taskActionIdEBO;
    }

    /**
     * Sets the value of the taskActionIdEBO property.
     * 
     * @param value
     *     allowed object is
     *     {@link TaskActionIdEBOType }
     *     
     */
    public void setTaskActionIdEBO(TaskActionIdEBOType value) {
        this.taskActionIdEBO = value;
    }

    /**
     * Gets the value of the taskActionParameters property.
     * 
     * @return
     *     possible object is
     *     byte[]
     */
    public byte[] getTaskActionParameters() {
        return taskActionParameters;
    }

    /**
     * Sets the value of the taskActionParameters property.
     * 
     * @param value
     *     allowed object is
     *     byte[]
     */
    public void setTaskActionParameters(byte[] value) {
        this.taskActionParameters = ((byte[]) value);
    }

    /**
     * Gets the value of the jobStatusEBOType property.
     * 
     * @return
     *     possible object is
     *     {@link StatusEBOType }
     *     
     */
    public StatusEBOType getJobStatusEBOType() {
        return jobStatusEBOType;
    }

    /**
     * Sets the value of the jobStatusEBOType property.
     * 
     * @param value
     *     allowed object is
     *     {@link StatusEBOType }
     *     
     */
    public void setJobStatusEBOType(StatusEBOType value) {
        this.jobStatusEBOType = value;
    }

}
<file_sep>/auction/sql/Categoryes with-out Items.sql
select * 
  from category ca
 where (select count(*) 
         from item_category ic , item it
  	 	where ic.itemid = it.oid  
		  and ic.categoryid = ca.oid) = 0
  order by ca.name;
		  
select ca.*
	from category ca, item_category ic
	where ca.oid  = ic.categoryid (+)
minus 
select ca.*
	from category ca, item_category ic
	where ca.oid  = ic.categoryid; 
				  
		  
select ca.* 
  from category ca, item_category ic, item it
  where ic.itemid = it.oid
  	and ic.categoryid = ca.oid; 		  
	
select b.* from bid b
where b.itemid = 'b9e3330a-4339-44cc-aba8-761995890423';	

@NamedQuery(name = "Bids.getHighBids",
		query = "Select bid from Bid bid where bid.bidAmount > :amount")
<file_sep>/auction/domain-module/model/pom.xml
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>

	<parent>
		<artifactId>auction-domain</artifactId>
		<groupId>com.jdap.auction.domain-model</groupId>
		<version>0.0.1-SNAPSHOT</version>
	</parent>

	<groupId>com.jdap.auction.domain-model</groupId>
	<artifactId>auction-domain-model</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	
	<pluginRepositories>
    <pluginRepository>
      <id>maven-annotation-plugin</id>
      <url>http://maven-annotation-plugin.googlecode.com/svn/trunk/mavenrepo</url>
    </pluginRepository>
  </pluginRepositories>

	<dependencies>
		<dependency>
			<groupId>javaee</groupId>
			<artifactId>javaee-api</artifactId>
			<version>5</version>
			<scope>provided</scope>
		</dependency>
		<dependency>
			<groupId>org.eclipse.persistence</groupId>
			<artifactId>javax.persistence</artifactId>
			<version>${javax.persistence.version}</version>
			<scope>provided</scope>
		</dependency>
		<dependency>
			<groupId>org.eclipse.persistence</groupId>
			<artifactId>eclipselink</artifactId>
			<version>${eclipselink.version}</version>
			<classifier>${eclipselink.classifier}</classifier>
			<scope>provided</scope>
		</dependency>



<!--     <dependency>
      <groupId>org.eclipse.persistence</groupId>
      <artifactId>javax.persistence</artifactId>
      <version>2.1.0</version>
    </dependency>
    <dependency>
      <groupId>org.eclipse.persistence</groupId>
      <artifactId>eclipselink</artifactId>
      <version>2.5.0</version>
    </dependency> -->





		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-dao</artifactId>
			<version>2.0.3</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-orm</artifactId>
			<version>3.2.3.RELEASE</version>
		</dependency>


		<!-- <dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>org.springframework.core</artifactId>
			<version>${spring.version}</version>
			<scope>provided</scope>
			<exclusions>
				<exclusion>
					<groupId>org.apache.commons</groupId>
					<artifactId>com.springsource.org.apache.commons.logging</artifactId>
				</exclusion>
			</exclusions>
		</dependency>
			<groupId>org.springframework</groupId>
			<artifactId>org.springframework.beans</artifactId>
			<version>${spring.version}</version>
			<scope>provided</scope>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>org.springframework.context</artifactId>
			<version>${spring.version}</version>
			<scope>provided</scope>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>org.springframework.aop</artifactId>
			<version>${spring.version}</version>
			<scope>provided</scope>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>org.springframework.oxm</artifactId>
			<version>${spring.version}</version>
		</dependency> -->


		<dependency>
			<groupId>com.jdap.auction.domain-model</groupId>
			<artifactId>auction-domain-model-pu</artifactId>
			<version>${project.version}</version>
			<type>jar</type>
		</dependency>
		<dependency>
			<groupId>com.jdap.auction</groupId>
			<artifactId>auction-exceptions</artifactId>
			<version>${project.version}</version>
			<scope>provided</scope>
		</dependency>
		<dependency>
			<groupId>commons-lang</groupId>
			<artifactId>commons-lang</artifactId>
			<version>1.0</version>
		</dependency>
	</dependencies>

</project><file_sep>/auction/sql/Worksheet 5.sql
select * from item where oid ='b9e3330a-4339-44cc-aba8-761995890423'; 

describe item;

select  * from category;
select * from item_category;

select * from bid;
select * from users;

select * from bid where itemid = 'b9e3330a-4339-44cc-aba8-761995890423' order by biddate desc;

select * from users;

<file_sep>/auction/wlst/jmsmodule.py
"""
This script starts an edit session, creates a JMS Servers, 
targets the jms servers to the ADF server 
Creates a jms topics, two jms queues and two connections factories.
The ms queues and topics are targeted using sub-deployments. 
"""

import sys
from java.lang import System

print "Starting the script ..."
connect('weblogic','Passw0rd','t3://localhost:7001')
edit()
startEdit()

servermb=getMBean("Servers/AdminServer")
if servermb is None:
    print 'Value is Null'
else:
    jMSServer1mb = create('TESTJMSServer','JMSServer')
    jMSServer1mb.addTarget(servermb)

    jmsMySystemResource = create("TESTJMSSystemModule","JMSSystemResource")
    jmsMySystemResource.addTarget(servermb)

    subDep1mb = jmsMySystemResource.createSubDeployment('TESTJMSSystemModuleSub')
    subDep1mb.addTarget(jMSServer1mb)

    theJMSResource = jmsMySystemResource.getJMSResource()

    connfact1 = theJMSResource.createConnectionFactory('ApiFaultQueueConnectionFactory')
    connfact1.setJNDIName('jms.ApiFaultQueueConnectionFactory')
    connfact1.setSubDeploymentName('TESTJMSSystemModuleSub')
    connfact1.transactionParams.setXAConnectionFactoryEnabled(1)
    
    jmsqueue1 = theJMSResource.createQueue('ApiFaultQueue')
    jmsqueue1.setJNDIName('jms.ApiFaultQueue')
    jmsqueue1.setSubDeploymentName('TESTJMSSystemModuleSub')
	
    connfact2 = theJMSResource.createConnectionFactory('OrderBillingQueueConnectionFactory')
    connfact2.setJNDIName('jms.OrderBillingQueueConnectionFactory')
    connfact2.setSubDeploymentName('TESTJMSSystemModuleSub')
    connfact2.transactionParams.setXAConnectionFactoryEnabled(1)
    
    jmsqueue2 = theJMSResource.createQueue('OrderBillingQueue')
    jmsqueue2.setJNDIName('jms.OrderBillingQueue')
    jmsqueue2.setSubDeploymentName('TESTJMSSystemModuleSub')	
	
	
try:
    save()
    activate(block="true")
    print "script returns SUCCESS"   
except:
    print "Error while trying to save and/or activate!!!"
    dumpStack()<file_sep>/auction/domain-module/model/src/main/java/com/jdap/auction/model/Category.java
package com.jdap.auction.model;

//~--- non-JDK imports ---------------------------------------------------------

import com.jdap.auction.patterns.persistence.AbstractPersistentObject;

//~--- JDK imports -------------------------------------------------------------

import java.util.ArrayList;
import java.util.List;

import javax.persistence.CascadeType;
import javax.persistence.Entity;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToMany;
import javax.persistence.ManyToOne;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.OneToMany;

/**
 * Class description
 *
 *
 * @version        9.0, 2013.February.27 11:39 AM
 * @author         JDAP Corporation
 */
@Entity
@NamedQueries( { @NamedQuery( name = "category.getRootCategories",
                              query = "SELECT c FROM Category c where c.parentCategory is null" ) ,
                 @NamedQuery( name = "category.getCategoriesByParent",
                              query = "SELECT c FROM Category c where c.parentCategory = :parentcategory" ) } )
public class Category extends AbstractPersistentObject
{
    /** Field description */
    private String name;

    /** Field description */
    private String description;

    /** Field description */
    @ManyToMany( mappedBy = "categories", cascade = CascadeType.REMOVE )
    private List<Item> items;

    /*
     * @JoinTable(
     *   name = "category_items",
     *   joinColumns = @JoinColumn( name = "categoryid",
     *                              referencedColumnName = "oid" ) ,
     *   inverseJoinColumns = @JoinColumn( name = "itemid",
     *                                     referencedColumnName = "oid" )
     * )
     */

    /** Field description */
    @ManyToMany( mappedBy = "categories" )
    private List<User> users;

    /** Field description */
    @ManyToOne( cascade = CascadeType.ALL )
    @JoinColumn( name = "parentCategoryid", referencedColumnName = "oid" )
    private Category parentCategory;

    /** Field description */
    @OneToMany( mappedBy = "parentCategory", cascade = CascadeType.ALL )
    private List<Category> subCategories;

    /**
     * Constructs ...
     *
     */
    public Category()
    {
    	//String id = parentCategory.getId();
    }

    /**
     * Method description
     *
     *
     * @return
     */
    public String getName()
    {
        return name;
    }

    /**
     * Method description
     *
     *
     * @param name
     */
    public void setName( String name )
    {
        this.name = name;
    }

    /**
     * Method description
     *
     *
     * @return
     */
    public String getDescription()
    {
        return description;
    }

    /**
     * Method description
     *
     *
     * @param description
     */
    public void setDescription( String description )
    {
        this.description = description;
    }

    /**
     * Method description
     *
     *
     * @return
     */
    public List<Item> getItems()
    {
        if( items == null )
        {
            items = new ArrayList<Item>();
        }

        return items;
    }

    /**
     * Method description
     *
     *
     * @param items
     *
     * @return
     */

    /*
     * public void setItems( List<Item> items )
     * {
     *   this.items = items;
     * }
     */

    /**
     * Method description
     *
     *
     * @return
     */
    public Category getParentCategory()
    {
        return parentCategory;
    }

    /**
     * Method description
     *
     *
     * @param parentCategory
     */
    public void setParentCategory( Category parentCategory )
    {
        this.parentCategory = parentCategory;
    }

    /**
     * Method description
     *
     *
     * @return
     */
    public List<Category> getSubCategories()
    {
        if( subCategories == null )
        {
            subCategories = new ArrayList<Category>();
        }

        return this.subCategories;
    }

    /**
     * Method description
     *
     *
     * @param subCategories
     *
     * @return
     */

    /*
     * public void setSubCategories( List<Category> subCategories )
     * {
     * this.subCategories = subCategories;
     * }
     */
    public List<User> getUsers()
    {
        return users;
    }

    /**
     * Method description
     *
     *
     * @param users
     */
    public void setUsers( List<User> users )
    {
        this.users = users;
    }
}
<file_sep>/auction/domain-module/model/src/main/java/com/jdap/auction/model/Bid.java

package com.jdap.auction.model;

// ~--- non-JDK imports ---------------------------------------------------------

import com.jdap.auction.patterns.persistence.AbstractPersistentObject;

// ~--- JDK imports -------------------------------------------------------------

import java.sql.Timestamp;

import javax.persistence.Entity;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;

/**
 * Class description
 * 
 * 
 * @version 9.0, 2013.February.26 05:07 PM
 * @author JDAP Corporation
 */
@Entity
// @Table( name = "BIDS" )
@NamedQueries (
	{@NamedQuery ( name = "Bids.getHighBids" ,
	               query = "Select bid from Bid bid where bid.bidAmount > :amount" ),
	 @NamedQuery ( name = "Bids.getItemBids" ,
	               query = "SELECT b FROM Bid b WHERE b.item = :item ORDER BY b.bidAmount ASC" )
	} )
public class Bid extends AbstractPersistentObject
{
	/** Field description */

	/** Field description */
	@ManyToOne ( )
	// cascade = CascadeType.PERSIST) has to change not cascade, in the one to many side to delete or update
	@JoinColumn ( name = "itemid" , referencedColumnName = "oid" )
	private Item item;

	/** Field description */
	@ManyToOne ( /* cascade = CascadeType.PERSIST */)
	// has to change not cascade, MERGE is better
	@JoinColumn ( name = "bidderid" , referencedColumnName = "oid" )
	private Bidder bidder;

	/** Field description */
	private Double bidAmount;

	/** Field description */
	private Double maxAmount;

	/** Field description */
	private Timestamp bidDate;

	/**
	 * Method description
	 * 
	 * 
	 * 
	 * @param bidID
	 * @return
	 */

	/* @Id
	 * @GeneratedValue( strategy = GenerationType.AUTO )
	 * @Column( name = "BID_ID" ) public Long getBidID() { return bidID; } */

	/**
	 * Method description
	 * 
	 * 
	 * @param bidID
	 */

	/* public void setBidID( Long bidID ) { this.bidID = bidID; } */

	/**
	 * Method description
	 * 
	 * 
	 * @return
	 */

	// @Column( name = "BID_AMOUNT" )
	public Double getBidAmount()
	{
		return bidAmount;
	}

	/**
	 * Method description
	 * 
	 * 
	 * @return
	 */
	public Item getItem()
	{
		return item;
	}

	/**
	 * Method description
	 * 
	 * 
	 * @param item
	 */
	public void setItem(Item item)
	{
		this.item = item;
	}

	/**
	 * Method description
	 * 
	 * 
	 * @param bidAmount
	 */
	public void setBidAmount(Double bidAmount)
	{
		this.bidAmount = bidAmount;
	}

	public Double getMaxAmount()
	{
		return maxAmount;
	}

	public void setMaxAmount(Double maxAmount)
	{
		this.maxAmount = maxAmount;
	}

	/**
	 * Method description
	 * 
	 * 
	 * @return
	 */

	// @Column( name = "BID_DATE" )
	public Timestamp getBidDate()
	{
		return bidDate;
	}

	/**
	 * Method description
	 * 
	 * 
	 * @param bidDate
	 */
	public void setBidDate(Timestamp bidDate)
	{
		this.bidDate = bidDate;
	}

	/**
	 * Method description
	 * 
	 * 
	 * @return
	 */
	public Bidder getBidder()
	{
		return bidder;
	}

	/**
	 * Method description
	 * 
	 * 
	 * @param bidder
	 */
	public void setBidder(Bidder bidder)
	{
		this.bidder = bidder;
	}
}
<file_sep>/Starting Project/Source Code/app/index.ts
export {environment} from './environment';
export {ServicesDiAppComponent} from './services-di.component';
<file_sep>/auction/common/xml/xml-user/target/generated-sources/jaxb/com/jdap/auction/common/xml/user/ObjectFactory.java
//
// This file was generated by the JavaTM Architecture for XML Binding(JAXB) Reference Implementation, v2.2.7 
// See <a href="http://java.sun.com/xml/jaxb">http://java.sun.com/xml/jaxb</a> 
// Any modifications to this file will be lost upon recompilation of the source schema. 
// Generated on: 2015.02.11 at 02:45:57 PM EST 
//


package com.jdap.auction.common.xml.user;

import javax.xml.bind.JAXBElement;
import javax.xml.bind.annotation.XmlElementDecl;
import javax.xml.bind.annotation.XmlRegistry;
import javax.xml.namespace.QName;


/**
 * This object contains factory methods for each 
 * Java content interface and Java element interface 
 * generated in the com.jdap.auction.common.xml.user package. 
 * <p>An ObjectFactory allows you to programatically 
 * construct new instances of the Java representation 
 * for XML content. The Java representation of XML 
 * content can consist of schema derived interfaces 
 * and classes representing the binding of schema 
 * type definitions, element declarations and model 
 * groups.  Factory methods for each of these are 
 * provided in this class.
 * 
 */
@XmlRegistry
public class ObjectFactory {

    private final static QName _ProblemIRI_QNAME = new QName("http://www.w3.org/2005/08/addressing", "ProblemIRI");
    private final static QName _DeleteSellerRequestMessage_QNAME = new QName("http://xmlns.jdap.com/auction/User/Messages/v2", "DeleteSellerRequestMessage");
    private final static QName _EndpointReference_QNAME = new QName("http://www.w3.org/2005/08/addressing", "EndpointReference");
    private final static QName _ProblemHeaderQName_QNAME = new QName("http://www.w3.org/2005/08/addressing", "ProblemHeaderQName");
    private final static QName _DeleteBidderRequestMessage_QNAME = new QName("http://xmlns.jdap.com/auction/User/Messages/v2", "DeleteBidderRequestMessage");
    private final static QName _ReferenceParameters_QNAME = new QName("http://www.w3.org/2005/08/addressing", "ReferenceParameters");
    private final static QName _From_QNAME = new QName("http://www.w3.org/2005/08/addressing", "From");
    private final static QName _CreateBidderResponseMessage_QNAME = new QName("http://xmlns.jdap.com/auction/User/Messages/v2", "CreateBidderResponseMessage");
    private final static QName _ReplyTo_QNAME = new QName("http://www.w3.org/2005/08/addressing", "ReplyTo");
    private final static QName _UpdateSellerResponseMessage_QNAME = new QName("http://xmlns.jdap.com/auction/User/Messages/v2", "UpdateSellerResponseMessage");
    private final static QName _MessageHeader_QNAME = new QName("http://xmlns.jdap.com/Common/MessageHeader/v2", "MessageHeader");
    private final static QName _Action_QNAME = new QName("http://www.w3.org/2005/08/addressing", "Action");
    private final static QName _FaultTo_QNAME = new QName("http://www.w3.org/2005/08/addressing", "FaultTo");
    private final static QName _QuerySellerRequestMessage_QNAME = new QName("http://xmlns.jdap.com/auction/User/Messages/v2", "QuerySellerRequestMessage");
    private final static QName _UpdateBidderRequestMessage_QNAME = new QName("http://xmlns.jdap.com/auction/User/Messages/v2", "UpdateBidderRequestMessage");
    private final static QName _UpdateSellerRequestMessage_QNAME = new QName("http://xmlns.jdap.com/auction/User/Messages/v2", "UpdateSellerRequestMessage");
    private final static QName _User_QNAME = new QName("http://xmlns.jdap.com/auction/User/Objects/v2", "user");
    private final static QName _RetryAfter_QNAME = new QName("http://www.w3.org/2005/08/addressing", "RetryAfter");
    private final static QName _CreateBidderRequestMessage_QNAME = new QName("http://xmlns.jdap.com/auction/User/Messages/v2", "CreateBidderRequestMessage");
    private final static QName _CreateSellerRequestMessage_QNAME = new QName("http://xmlns.jdap.com/auction/User/Messages/v2", "CreateSellerRequestMessage");
    private final static QName _DeleteBidderResponseMessage_QNAME = new QName("http://xmlns.jdap.com/auction/User/Messages/v2", "DeleteBidderResponseMessage");
    private final static QName _DeleteSellerResponseMessage_QNAME = new QName("http://xmlns.jdap.com/auction/User/Messages/v2", "DeleteSellerResponseMessage");
    private final static QName _To_QNAME = new QName("http://www.w3.org/2005/08/addressing", "To");
    private final static QName _Address_QNAME = new QName("http://xmlns.jdap.com/auction/Address/Objects/v2", "address");
    private final static QName _Bidder_QNAME = new QName("http://xmlns.jdap.com/auction/Bidder/Objects/v2", "bidder");
    private final static QName _ProblemAction_QNAME = new QName("http://www.w3.org/2005/08/addressing", "ProblemAction");
    private final static QName _UpdateBidderResponseMessage_QNAME = new QName("http://xmlns.jdap.com/auction/User/Messages/v2", "UpdateBidderResponseMessage");
    private final static QName _RelatesTo_QNAME = new QName("http://www.w3.org/2005/08/addressing", "RelatesTo");
    private final static QName _Seller_QNAME = new QName("http://xmlns.jdap.com/auction/Seller/Objects/v2", "seller");
    private final static QName _QueryBidderResponseMessage_QNAME = new QName("http://xmlns.jdap.com/auction/User/Messages/v2", "QueryBidderResponseMessage");
    private final static QName _Metadata_QNAME = new QName("http://www.w3.org/2005/08/addressing", "Metadata");
    private final static QName _QuerySellerResponseMessage_QNAME = new QName("http://xmlns.jdap.com/auction/User/Messages/v2", "QuerySellerResponseMessage");
    private final static QName _CreateSellerResponseMessage_QNAME = new QName("http://xmlns.jdap.com/auction/User/Messages/v2", "CreateSellerResponseMessage");
    private final static QName _MessageID_QNAME = new QName("http://www.w3.org/2005/08/addressing", "MessageID");
    private final static QName _QueryBidderRequestMessage_QNAME = new QName("http://xmlns.jdap.com/auction/User/Messages/v2", "QueryBidderRequestMessage");

    /**
     * Create a new ObjectFactory that can be used to create new instances of schema derived classes for package: com.jdap.auction.common.xml.user
     * 
     */
    public ObjectFactory() {
    }

    /**
     * Create an instance of {@link DeleteBidderRequestMessageType }
     * 
     */
    public DeleteBidderRequestMessageType createDeleteBidderRequestMessageType() {
        return new DeleteBidderRequestMessageType();
    }

    /**
     * Create an instance of {@link DeleteSellerResponseMessageType }
     * 
     */
    public DeleteSellerResponseMessageType createDeleteSellerResponseMessageType() {
        return new DeleteSellerResponseMessageType();
    }

    /**
     * Create an instance of {@link CreateSellerRequestMessageType }
     * 
     */
    public CreateSellerRequestMessageType createCreateSellerRequestMessageType() {
        return new CreateSellerRequestMessageType();
    }

    /**
     * Create an instance of {@link CreateBidderRequestMessageType }
     * 
     */
    public CreateBidderRequestMessageType createCreateBidderRequestMessageType() {
        return new CreateBidderRequestMessageType();
    }

    /**
     * Create an instance of {@link DeleteBidderResponseMessageType }
     * 
     */
    public DeleteBidderResponseMessageType createDeleteBidderResponseMessageType() {
        return new DeleteBidderResponseMessageType();
    }

    /**
     * Create an instance of {@link DeleteSellerRequestMessageType }
     * 
     */
    public DeleteSellerRequestMessageType createDeleteSellerRequestMessageType() {
        return new DeleteSellerRequestMessageType();
    }

    /**
     * Create an instance of {@link UpdateSellerRequestMessageType }
     * 
     */
    public UpdateSellerRequestMessageType createUpdateSellerRequestMessageType() {
        return new UpdateSellerRequestMessageType();
    }

    /**
     * Create an instance of {@link QueryBidderRequestMessageType }
     * 
     */
    public QueryBidderRequestMessageType createQueryBidderRequestMessageType() {
        return new QueryBidderRequestMessageType();
    }

    /**
     * Create an instance of {@link QuerySellerRequestMessageType }
     * 
     */
    public QuerySellerRequestMessageType createQuerySellerRequestMessageType() {
        return new QuerySellerRequestMessageType();
    }

    /**
     * Create an instance of {@link UpdateBidderRequestMessageType }
     * 
     */
    public UpdateBidderRequestMessageType createUpdateBidderRequestMessageType() {
        return new UpdateBidderRequestMessageType();
    }

    /**
     * Create an instance of {@link CreateSellerResponseMessageType }
     * 
     */
    public CreateSellerResponseMessageType createCreateSellerResponseMessageType() {
        return new CreateSellerResponseMessageType();
    }

    /**
     * Create an instance of {@link QuerySellerResponseMessageType }
     * 
     */
    public QuerySellerResponseMessageType createQuerySellerResponseMessageType() {
        return new QuerySellerResponseMessageType();
    }

    /**
     * Create an instance of {@link UpdateSellerResponseMessageType }
     * 
     */
    public UpdateSellerResponseMessageType createUpdateSellerResponseMessageType() {
        return new UpdateSellerResponseMessageType();
    }

    /**
     * Create an instance of {@link QueryBidderResponseMessageType }
     * 
     */
    public QueryBidderResponseMessageType createQueryBidderResponseMessageType() {
        return new QueryBidderResponseMessageType();
    }

    /**
     * Create an instance of {@link CreateBidderResponseMessageType }
     * 
     */
    public CreateBidderResponseMessageType createCreateBidderResponseMessageType() {
        return new CreateBidderResponseMessageType();
    }

    /**
     * Create an instance of {@link UpdateBidderResponseMessageType }
     * 
     */
    public UpdateBidderResponseMessageType createUpdateBidderResponseMessageType() {
        return new UpdateBidderResponseMessageType();
    }

    /**
     * Create an instance of {@link ListOfValuesType }
     * 
     */
    public ListOfValuesType createListOfValuesType() {
        return new ListOfValuesType();
    }

    /**
     * Create an instance of {@link CategoryType }
     * 
     */
    public CategoryType createCategoryType() {
        return new CategoryType();
    }

    /**
     * Create an instance of {@link UserIDType }
     * 
     */
    public UserIDType createUserIDType() {
        return new UserIDType();
    }

    /**
     * Create an instance of {@link ValueHolderType }
     * 
     */
    public ValueHolderType createValueHolderType() {
        return new ValueHolderType();
    }

    /**
     * Create an instance of {@link NameValuePairDataType }
     * 
     */
    public NameValuePairDataType createNameValuePairDataType() {
        return new NameValuePairDataType();
    }

    /**
     * Create an instance of {@link RangeOfDatesType }
     * 
     */
    public RangeOfDatesType createRangeOfDatesType() {
        return new RangeOfDatesType();
    }

    /**
     * Create an instance of {@link ExtensionUserType }
     * 
     */
    public ExtensionUserType createExtensionUserType() {
        return new ExtensionUserType();
    }

    /**
     * Create an instance of {@link AddressType }
     * 
     */
    public AddressType createAddressType() {
        return new AddressType();
    }

    /**
     * Create an instance of {@link ExtensionAddressType }
     * 
     */
    public ExtensionAddressType createExtensionAddressType() {
        return new ExtensionAddressType();
    }

    /**
     * Create an instance of {@link SellerType }
     * 
     */
    public SellerType createSellerType() {
        return new SellerType();
    }

    /**
     * Create an instance of {@link ExtensionSellerType }
     * 
     */
    public ExtensionSellerType createExtensionSellerType() {
        return new ExtensionSellerType();
    }

    /**
     * Create an instance of {@link BidderType }
     * 
     */
    public BidderType createBidderType() {
        return new BidderType();
    }

    /**
     * Create an instance of {@link ExtensionBidderType }
     * 
     */
    public ExtensionBidderType createExtensionBidderType() {
        return new ExtensionBidderType();
    }

    /**
     * Create an instance of {@link MessageHeaderType }
     * 
     */
    public MessageHeaderType createMessageHeaderType() {
        return new MessageHeaderType();
    }

    /**
     * Create an instance of {@link SenderType }
     * 
     */
    public SenderType createSenderType() {
        return new SenderType();
    }

    /**
     * Create an instance of {@link WSAddressType }
     * 
     */
    public WSAddressType createWSAddressType() {
        return new WSAddressType();
    }

    /**
     * Create an instance of {@link NameValuePairType }
     * 
     */
    public NameValuePairType createNameValuePairType() {
        return new NameValuePairType();
    }

    /**
     * Create an instance of {@link ProblemActionType }
     * 
     */
    public ProblemActionType createProblemActionType() {
        return new ProblemActionType();
    }

    /**
     * Create an instance of {@link AttributedURIType }
     * 
     */
    public AttributedURIType createAttributedURIType() {
        return new AttributedURIType();
    }

    /**
     * Create an instance of {@link AttributedQNameType }
     * 
     */
    public AttributedQNameType createAttributedQNameType() {
        return new AttributedQNameType();
    }

    /**
     * Create an instance of {@link EndpointReferenceType }
     * 
     */
    public EndpointReferenceType createEndpointReferenceType() {
        return new EndpointReferenceType();
    }

    /**
     * Create an instance of {@link AttributedUnsignedLongType }
     * 
     */
    public AttributedUnsignedLongType createAttributedUnsignedLongType() {
        return new AttributedUnsignedLongType();
    }

    /**
     * Create an instance of {@link MetadataType }
     * 
     */
    public MetadataType createMetadataType() {
        return new MetadataType();
    }

    /**
     * Create an instance of {@link ReferenceParametersType }
     * 
     */
    public ReferenceParametersType createReferenceParametersType() {
        return new ReferenceParametersType();
    }

    /**
     * Create an instance of {@link RelatesToType }
     * 
     */
    public RelatesToType createRelatesToType() {
        return new RelatesToType();
    }

    /**
     * Create an instance of {@link ExtensionMessageHeaderType }
     * 
     */
    public ExtensionMessageHeaderType createExtensionMessageHeaderType() {
        return new ExtensionMessageHeaderType();
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link AttributedURIType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "ProblemIRI")
    public JAXBElement<AttributedURIType> createProblemIRI(AttributedURIType value) {
        return new JAXBElement<AttributedURIType>(_ProblemIRI_QNAME, AttributedURIType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link DeleteSellerRequestMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/User/Messages/v2", name = "DeleteSellerRequestMessage")
    public JAXBElement<DeleteSellerRequestMessageType> createDeleteSellerRequestMessage(DeleteSellerRequestMessageType value) {
        return new JAXBElement<DeleteSellerRequestMessageType>(_DeleteSellerRequestMessage_QNAME, DeleteSellerRequestMessageType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link EndpointReferenceType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "EndpointReference")
    public JAXBElement<EndpointReferenceType> createEndpointReference(EndpointReferenceType value) {
        return new JAXBElement<EndpointReferenceType>(_EndpointReference_QNAME, EndpointReferenceType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link AttributedQNameType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "ProblemHeaderQName")
    public JAXBElement<AttributedQNameType> createProblemHeaderQName(AttributedQNameType value) {
        return new JAXBElement<AttributedQNameType>(_ProblemHeaderQName_QNAME, AttributedQNameType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link DeleteBidderRequestMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/User/Messages/v2", name = "DeleteBidderRequestMessage")
    public JAXBElement<DeleteBidderRequestMessageType> createDeleteBidderRequestMessage(DeleteBidderRequestMessageType value) {
        return new JAXBElement<DeleteBidderRequestMessageType>(_DeleteBidderRequestMessage_QNAME, DeleteBidderRequestMessageType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link ReferenceParametersType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "ReferenceParameters")
    public JAXBElement<ReferenceParametersType> createReferenceParameters(ReferenceParametersType value) {
        return new JAXBElement<ReferenceParametersType>(_ReferenceParameters_QNAME, ReferenceParametersType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link EndpointReferenceType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "From")
    public JAXBElement<EndpointReferenceType> createFrom(EndpointReferenceType value) {
        return new JAXBElement<EndpointReferenceType>(_From_QNAME, EndpointReferenceType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link CreateBidderResponseMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/User/Messages/v2", name = "CreateBidderResponseMessage")
    public JAXBElement<CreateBidderResponseMessageType> createCreateBidderResponseMessage(CreateBidderResponseMessageType value) {
        return new JAXBElement<CreateBidderResponseMessageType>(_CreateBidderResponseMessage_QNAME, CreateBidderResponseMessageType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link EndpointReferenceType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "ReplyTo")
    public JAXBElement<EndpointReferenceType> createReplyTo(EndpointReferenceType value) {
        return new JAXBElement<EndpointReferenceType>(_ReplyTo_QNAME, EndpointReferenceType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link UpdateSellerResponseMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/User/Messages/v2", name = "UpdateSellerResponseMessage")
    public JAXBElement<UpdateSellerResponseMessageType> createUpdateSellerResponseMessage(UpdateSellerResponseMessageType value) {
        return new JAXBElement<UpdateSellerResponseMessageType>(_UpdateSellerResponseMessage_QNAME, UpdateSellerResponseMessageType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link MessageHeaderType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/Common/MessageHeader/v2", name = "MessageHeader")
    public JAXBElement<MessageHeaderType> createMessageHeader(MessageHeaderType value) {
        return new JAXBElement<MessageHeaderType>(_MessageHeader_QNAME, MessageHeaderType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link AttributedURIType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "Action")
    public JAXBElement<AttributedURIType> createAction(AttributedURIType value) {
        return new JAXBElement<AttributedURIType>(_Action_QNAME, AttributedURIType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link EndpointReferenceType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "FaultTo")
    public JAXBElement<EndpointReferenceType> createFaultTo(EndpointReferenceType value) {
        return new JAXBElement<EndpointReferenceType>(_FaultTo_QNAME, EndpointReferenceType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link QuerySellerRequestMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/User/Messages/v2", name = "QuerySellerRequestMessage")
    public JAXBElement<QuerySellerRequestMessageType> createQuerySellerRequestMessage(QuerySellerRequestMessageType value) {
        return new JAXBElement<QuerySellerRequestMessageType>(_QuerySellerRequestMessage_QNAME, QuerySellerRequestMessageType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link UpdateBidderRequestMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/User/Messages/v2", name = "UpdateBidderRequestMessage")
    public JAXBElement<UpdateBidderRequestMessageType> createUpdateBidderRequestMessage(UpdateBidderRequestMessageType value) {
        return new JAXBElement<UpdateBidderRequestMessageType>(_UpdateBidderRequestMessage_QNAME, UpdateBidderRequestMessageType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link UpdateSellerRequestMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/User/Messages/v2", name = "UpdateSellerRequestMessage")
    public JAXBElement<UpdateSellerRequestMessageType> createUpdateSellerRequestMessage(UpdateSellerRequestMessageType value) {
        return new JAXBElement<UpdateSellerRequestMessageType>(_UpdateSellerRequestMessage_QNAME, UpdateSellerRequestMessageType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link UserType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/User/Objects/v2", name = "user")
    public JAXBElement<UserType> createUser(UserType value) {
        return new JAXBElement<UserType>(_User_QNAME, UserType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link AttributedUnsignedLongType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "RetryAfter")
    public JAXBElement<AttributedUnsignedLongType> createRetryAfter(AttributedUnsignedLongType value) {
        return new JAXBElement<AttributedUnsignedLongType>(_RetryAfter_QNAME, AttributedUnsignedLongType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link CreateBidderRequestMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/User/Messages/v2", name = "CreateBidderRequestMessage")
    public JAXBElement<CreateBidderRequestMessageType> createCreateBidderRequestMessage(CreateBidderRequestMessageType value) {
        return new JAXBElement<CreateBidderRequestMessageType>(_CreateBidderRequestMessage_QNAME, CreateBidderRequestMessageType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link CreateSellerRequestMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/User/Messages/v2", name = "CreateSellerRequestMessage")
    public JAXBElement<CreateSellerRequestMessageType> createCreateSellerRequestMessage(CreateSellerRequestMessageType value) {
        return new JAXBElement<CreateSellerRequestMessageType>(_CreateSellerRequestMessage_QNAME, CreateSellerRequestMessageType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link DeleteBidderResponseMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/User/Messages/v2", name = "DeleteBidderResponseMessage")
    public JAXBElement<DeleteBidderResponseMessageType> createDeleteBidderResponseMessage(DeleteBidderResponseMessageType value) {
        return new JAXBElement<DeleteBidderResponseMessageType>(_DeleteBidderResponseMessage_QNAME, DeleteBidderResponseMessageType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link DeleteSellerResponseMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/User/Messages/v2", name = "DeleteSellerResponseMessage")
    public JAXBElement<DeleteSellerResponseMessageType> createDeleteSellerResponseMessage(DeleteSellerResponseMessageType value) {
        return new JAXBElement<DeleteSellerResponseMessageType>(_DeleteSellerResponseMessage_QNAME, DeleteSellerResponseMessageType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link AttributedURIType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "To")
    public JAXBElement<AttributedURIType> createTo(AttributedURIType value) {
        return new JAXBElement<AttributedURIType>(_To_QNAME, AttributedURIType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link AddressType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/Address/Objects/v2", name = "address")
    public JAXBElement<AddressType> createAddress(AddressType value) {
        return new JAXBElement<AddressType>(_Address_QNAME, AddressType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link BidderType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/Bidder/Objects/v2", name = "bidder")
    public JAXBElement<BidderType> createBidder(BidderType value) {
        return new JAXBElement<BidderType>(_Bidder_QNAME, BidderType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link ProblemActionType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "ProblemAction")
    public JAXBElement<ProblemActionType> createProblemAction(ProblemActionType value) {
        return new JAXBElement<ProblemActionType>(_ProblemAction_QNAME, ProblemActionType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link UpdateBidderResponseMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/User/Messages/v2", name = "UpdateBidderResponseMessage")
    public JAXBElement<UpdateBidderResponseMessageType> createUpdateBidderResponseMessage(UpdateBidderResponseMessageType value) {
        return new JAXBElement<UpdateBidderResponseMessageType>(_UpdateBidderResponseMessage_QNAME, UpdateBidderResponseMessageType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link RelatesToType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "RelatesTo")
    public JAXBElement<RelatesToType> createRelatesTo(RelatesToType value) {
        return new JAXBElement<RelatesToType>(_RelatesTo_QNAME, RelatesToType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link SellerType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/Seller/Objects/v2", name = "seller")
    public JAXBElement<SellerType> createSeller(SellerType value) {
        return new JAXBElement<SellerType>(_Seller_QNAME, SellerType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link QueryBidderResponseMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/User/Messages/v2", name = "QueryBidderResponseMessage")
    public JAXBElement<QueryBidderResponseMessageType> createQueryBidderResponseMessage(QueryBidderResponseMessageType value) {
        return new JAXBElement<QueryBidderResponseMessageType>(_QueryBidderResponseMessage_QNAME, QueryBidderResponseMessageType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link MetadataType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "Metadata")
    public JAXBElement<MetadataType> createMetadata(MetadataType value) {
        return new JAXBElement<MetadataType>(_Metadata_QNAME, MetadataType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link QuerySellerResponseMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/User/Messages/v2", name = "QuerySellerResponseMessage")
    public JAXBElement<QuerySellerResponseMessageType> createQuerySellerResponseMessage(QuerySellerResponseMessageType value) {
        return new JAXBElement<QuerySellerResponseMessageType>(_QuerySellerResponseMessage_QNAME, QuerySellerResponseMessageType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link CreateSellerResponseMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/User/Messages/v2", name = "CreateSellerResponseMessage")
    public JAXBElement<CreateSellerResponseMessageType> createCreateSellerResponseMessage(CreateSellerResponseMessageType value) {
        return new JAXBElement<CreateSellerResponseMessageType>(_CreateSellerResponseMessage_QNAME, CreateSellerResponseMessageType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link AttributedURIType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "MessageID")
    public JAXBElement<AttributedURIType> createMessageID(AttributedURIType value) {
        return new JAXBElement<AttributedURIType>(_MessageID_QNAME, AttributedURIType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link QueryBidderRequestMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/User/Messages/v2", name = "QueryBidderRequestMessage")
    public JAXBElement<QueryBidderRequestMessageType> createQueryBidderRequestMessage(QueryBidderRequestMessageType value) {
        return new JAXBElement<QueryBidderRequestMessageType>(_QueryBidderRequestMessage_QNAME, QueryBidderRequestMessageType.class, null, value);
    }

}
<file_sep>/auction/common/xml/xml-user/target/generated-sources/jaxb/com/jdap/auction/common/xml/user/LoggingLevelType.java
//
// This file was generated by the JavaTM Architecture for XML Binding(JAXB) Reference Implementation, v2.2.7 
// See <a href="http://java.sun.com/xml/jaxb">http://java.sun.com/xml/jaxb</a> 
// Any modifications to this file will be lost upon recompilation of the source schema. 
// Generated on: 2015.02.11 at 02:45:57 PM EST 
//


package com.jdap.auction.common.xml.user;

import javax.xml.bind.annotation.XmlEnum;
import javax.xml.bind.annotation.XmlEnumValue;
import javax.xml.bind.annotation.XmlType;


/**
 * <p>Java class for LoggingLevelType.
 * 
 * <p>The following schema fragment specifies the expected content contained within this class.
 * <p>
 * <pre>
 * &lt;simpleType name="LoggingLevelType">
 *   &lt;restriction base="{http://www.w3.org/2001/XMLSchema}string">
 *     &lt;enumeration value="Fatal"/>
 *     &lt;enumeration value="Error"/>
 *     &lt;enumeration value="Warning"/>
 *     &lt;enumeration value="Notification"/>
 *     &lt;enumeration value="Trace"/>
 *   &lt;/restriction>
 * &lt;/simpleType>
 * </pre>
 * 
 */
@XmlType(name = "LoggingLevelType", namespace = "http://xmlns.jdap.com/Common/MessageHeader/v2")
@XmlEnum
public enum LoggingLevelType {


    /**
     * Highest severity level. Unexpected errors that occur during normal execution. Fatal exceptions or any other serious problems that require immediate attention from the System Administrator.
     * 
     */
    @XmlEnumValue("Fatal")
    FATAL("Fatal"),

    /**
     * The Error level designates error events that might still allow the application to continue running. Administrator action can be delayed in this severity.
     * 
     */
    @XmlEnumValue("Error")
    ERROR("Error"),

    /**
     * The Warning level designates potentially harmful situations. Any potential problem that should be reviewed by the System Administrator.
     * 
     */
    @XmlEnumValue("Warning")
    WARNING("Warning"),

    /**
     * Key flow steps; high-level functional progress messages. A major life cycle event such as the activation or deactivation of a primary sub-component or feature.
     * 
     */
    @XmlEnumValue("Notification")
    NOTIFICATION("Notification"),

    /**
     * Configuration properties and environment settings. This is a finer level of granularity for reporting normal events.
     * 
     */
    @XmlEnumValue("Trace")
    TRACE("Trace");
    private final String value;

    LoggingLevelType(String v) {
        value = v;
    }

    public String value() {
        return value;
    }

    public static LoggingLevelType fromValue(String v) {
        for (LoggingLevelType c: LoggingLevelType.values()) {
            if (c.value.equals(v)) {
                return c;
            }
        }
        throw new IllegalArgumentException(v);
    }

}
<file_sep>/auction/sql/Worksheet 2.sql
select * from users;

update users u
 set u.phone = 7760759
 where u.phone = 'string';<file_sep>/auction/sql/dropDDL_action_backup.sql
ALTER TABLE BID DROP CONSTRAINT FK_BID_itemid;
ALTER TABLE BID DROP CONSTRAINT FK_BID_bidderid;
ALTER TABLE USERS DROP CONSTRAINT FK_USERS_billingInfoid;
ALTER TABLE USERSPICTURE DROP CONSTRAINT FK_USERSPICTURE_OID;
ALTER TABLE BIDDER DROP CONSTRAINT FK_BIDDER_OID;
ALTER TABLE CATEGORY DROP CONSTRAINT FK_CATEGORY_parentCategoryid;
ALTER TABLE CONTACTINFO DROP CONSTRAINT FK_CONTACTINFO_userid;
ALTER TABLE ITEM DROP CONSTRAINT FK_ITEM_sellerid;
ALTER TABLE ITEM DROP CONSTRAINT FK_ITEM_orderid;
ALTER TABLE ORDERS DROP CONSTRAINT FK_ORDERS_bidderid;
ALTER TABLE SELLER DROP CONSTRAINT FK_SELLER_OID;
ALTER TABLE category_items DROP CONSTRAINT FK_category_items_itemid;
ALTER TABLE category_items DROP CONSTRAINT FK_category_items_categoryid;
DROP TABLE BID;
DROP TABLE USERSPICTURE;
DROP TABLE USERS;
DROP TABLE BIDDER;
DROP TABLE BILLINGINFO;
DROP TABLE CATEGORY;
DROP TABLE CONTACTINFO;
DROP TABLE ITEM;
DROP TABLE ORDERS;
DROP TABLE SELLER;
DROP TABLE category_items;
<file_sep>/auction/domain-module/model/sql/model.sql
CREATE TABLE ORDERS (CREATEDATE TIMESTAMP NULL, LASTMODIFIED TIMESTAMP NULL, VERSION NUMBER(19) NULL, OID VARCHAR(36), bidderid VARCHAR(36), PRIMARY KEY (OID));
CREATE TABLE USERS (USERTYPE VARCHAR2(1) NULL, OID VARCHAR(36), EMAIL VARCHAR2(255) NULL, FISRTNAME VARCHAR2(255) NOT NULL, LASTMODIFIED TIMESTAMP NULL, LASTNAME VARCHAR2(255) NOT NULL, PASSWORD VARCHAR2(255) NOT NULL, PHONE VARCHAR2(255) NULL, USERNAME VARCHAR2(255) NOT NULL, VERSION NUMBER(19) NULL, CITY VARCHAR2(255) NULL, COUNTRY VARCHAR2(255) NULL, STATE VARCHAR2(255) NULL, STREELINE2 VARCHAR2(255) NULL, STREETLINE1 VARCHAR2(255) NULL, ZIPCODE VARCHAR2(255) NULL, billingInfoid VARCHAR(36), PRIMARY KEY (OID));
CREATE TABLE USERSPICTURE (OID VARCHAR(36), PICTURE BLOB NULL, PRIMARY KEY (OID));
CREATE TABLE BIDDER (OID VARCHAR(36), BIDFRECUENCY NUMBER(19,4) NULL, PRIMARY KEY (OID));
CREATE TABLE CATEGORY (DESCRIPTION VARCHAR2(255) NULL, LASTMODIFIED TIMESTAMP NULL, NAME VARCHAR2(255) NULL, VERSION NUMBER(19) NULL, OID VARCHAR(36), parentCategoryid VARCHAR(36), PRIMARY KEY (OID));
CREATE TABLE CONTACTINFO (EMAIL VARCHAR2(255) NULL, FIRSTNAME VARCHAR2(255) NOT NULL, LASTMODIFIED TIMESTAMP NULL, LASTNAME VARCHAR2(255) NULL, PHONE VARCHAR2(255) NULL, VERSION NUMBER(19) NULL, CITY VARCHAR2(255) NULL, COUNTRY VARCHAR2(255) NULL, STATE VARCHAR2(255) NULL, STREELINE2 VARCHAR2(255) NULL, STREETLINE1 VARCHAR2(255) NULL, ZIPCODE VARCHAR2(255) NULL, OID VARCHAR(36), userid VARCHAR(36), PRIMARY KEY (OID));
CREATE TABLE BID (BIDAMOUNT NUMBER(19,4) NULL, BIDDATE TIMESTAMP NULL, LASTMODIFIED TIMESTAMP NULL, VERSION NUMBER(19) NULL, OID VARCHAR(36), bidderid VARCHAR(36), itemid VARCHAR(36), PRIMARY KEY (OID));
CREATE TABLE SELLER (OID VARCHAR(36), CREDITWORTH NUMBER(19,4) NULL, PRIMARY KEY (OID));
CREATE TABLE BILLINGINFO (BANKACCOUNTNUMBER VARCHAR2(255) NULL, BANKNAME VARCHAR2(255) NULL, CREDITCARDEXPIRATION DATE NULL, CREDITCARDNAMBER VARCHAR2(255) NULL, CREDITCARDTYPE VARCHAR2(255) NULL, LASTMODIFIED TIMESTAMP NULL, NAMEONCREDITCARD VARCHAR2(255) NULL, ROUTINGNUMBER VARCHAR2(255) NULL, VERSION NUMBER(19) NULL, OID VARCHAR(36), PRIMARY KEY (OID));
CREATE TABLE ITEM (BIDENDDATE TIMESTAMP NULL, BIDSTARTDATE TIMESTAMP NULL, DESCRIPTION CLOB NULL, INITIALPRICE NUMBER(19,4) NULL, LASTMODIFIED TIMESTAMP NULL, PICTURE BLOB NULL, POSTDATE TIMESTAMP NULL, TITLE VARCHAR2(255) NULL, VERSION NUMBER(19) NULL, OID VARCHAR(36), orderid VARCHAR(36), sellerid VARCHAR(36), PRIMARY KEY (OID));
CREATE TABLE category_items (categoryid VARCHAR(36), itemid VARCHAR(36), PRIMARY KEY (categoryid, itemid));
CREATE TABLE users_category (categoryid VARCHAR(36), userid VARCHAR(36), PRIMARY KEY (categoryid, userid));
ALTER TABLE ORDERS ADD CONSTRAINT FK_ORDERS_bidderid FOREIGN KEY (bidderid) REFERENCES USERS (OID);
ALTER TABLE USERS ADD CONSTRAINT FK_USERS_billingInfoid FOREIGN KEY (billingInfoid) REFERENCES BILLINGINFO (OID);
ALTER TABLE USERSPICTURE ADD CONSTRAINT FK_USERSPICTURE_OID FOREIGN KEY (OID) REFERENCES USERS (OID);
ALTER TABLE BIDDER ADD CONSTRAINT FK_BIDDER_OID FOREIGN KEY (OID) REFERENCES USERS (OID);
ALTER TABLE CATEGORY ADD CONSTRAINT FK_CATEGORY_parentCategoryid FOREIGN KEY (parentCategoryid) REFERENCES CATEGORY (OID);
ALTER TABLE CONTACTINFO ADD CONSTRAINT FK_CONTACTINFO_userid FOREIGN KEY (userid) REFERENCES USERS (OID);
ALTER TABLE BID ADD CONSTRAINT FK_BID_itemid FOREIGN KEY (itemid) REFERENCES ITEM (OID);
ALTER TABLE BID ADD CONSTRAINT FK_BID_bidderid FOREIGN KEY (bidderid) REFERENCES USERS (OID);
ALTER TABLE SELLER ADD CONSTRAINT FK_SELLER_OID FOREIGN KEY (OID) REFERENCES USERS (OID);
ALTER TABLE ITEM ADD CONSTRAINT FK_ITEM_sellerid FOREIGN KEY (sellerid) REFERENCES USERS (OID);
ALTER TABLE ITEM ADD CONSTRAINT FK_ITEM_orderid FOREIGN KEY (orderid) REFERENCES ORDERS (OID);
ALTER TABLE category_items ADD CONSTRAINT FK_category_items_itemid FOREIGN KEY (itemid) REFERENCES ITEM (OID);
ALTER TABLE category_items ADD CONSTRAINT FK_category_items_categoryid FOREIGN KEY (categoryid) REFERENCES CATEGORY (OID);
ALTER TABLE users_category ADD CONSTRAINT FK_users_category_userid FOREIGN KEY (userid) REFERENCES USERS (OID);
ALTER TABLE users_category ADD CONSTRAINT FK_users_category_categoryid FOREIGN KEY (categoryid) REFERENCES CATEGORY (OID);

select * from USERSPICTURE;  
truncate table USERSPICTURE;
select * from users;
delete from users;
truncate table users;
select * from BIDDER;
truncate table bidder;
select * from CATEGORY;
select * from CONTACTINFO;
select * from BID;
truncate table BID;
select * from SELLER;
select * from BILLINGINFO;
select * from ITEM;
delete from item;
truncate table Item;
select * from category_items;
truncate table category_items;
select * from users_category;
select * from orders;

ALTER TABLE ORDERS DROP CONSTRAINT FK_ORDERS_bidderid;
ALTER TABLE USERS DROP CONSTRAINT FK_USERS_billingInfoid;
ALTER TABLE USERSPICTURE DROP CONSTRAINT FK_USERSPICTURE_OID;
ALTER TABLE BIDDER DROP CONSTRAINT FK_BIDDER_OID;
ALTER TABLE CATEGORY DROP CONSTRAINT FK_CATEGORY_parentCategoryid;
ALTER TABLE CONTACTINFO DROP CONSTRAINT FK_CONTACTINFO_userid;
ALTER TABLE BID DROP CONSTRAINT FK_BID_itemid;
ALTER TABLE BID DROP CONSTRAINT FK_BID_bidderid;
ALTER TABLE SELLER DROP CONSTRAINT FK_SELLER_OID;
ALTER TABLE ITEM DROP CONSTRAINT FK_ITEM_sellerid;
ALTER TABLE ITEM DROP CONSTRAINT FK_ITEM_orderid;
ALTER TABLE category_items DROP CONSTRAINT FK_category_items_itemid;
ALTER TABLE category_items DROP CONSTRAINT FK_category_items_categoryid;
ALTER TABLE users_category DROP CONSTRAINT FK_users_category_userid;
ALTER TABLE users_category DROP CONSTRAINT FK_users_category_categoryid;
DROP TABLE ORDERS;
DROP TABLE USERS;
DROP TABLE USERSPICTURE;
DROP TABLE BIDDER;
DROP TABLE CATEGORY;
DROP TABLE CONTACTINFO;
DROP TABLE BID;
DROP TABLE SELLER;
DROP TABLE BILLINGINFO;
DROP TABLE ITEM;
DROP TABLE category_items;
DROP TABLE users_category;
<file_sep>/auction/common/xml/xml-bid/target/generated-sources/jaxb/com/jdap/auction/common/xml/bid/ObjectFactory.java
//
// This file was generated by the JavaTM Architecture for XML Binding(JAXB) Reference Implementation, v2.2.7 
// See <a href="http://java.sun.com/xml/jaxb">http://java.sun.com/xml/jaxb</a> 
// Any modifications to this file will be lost upon recompilation of the source schema. 
// Generated on: 2015.02.11 at 02:45:56 PM EST 
//


package com.jdap.auction.common.xml.bid;

import javax.xml.bind.JAXBElement;
import javax.xml.bind.annotation.XmlElementDecl;
import javax.xml.bind.annotation.XmlRegistry;
import javax.xml.namespace.QName;


/**
 * This object contains factory methods for each 
 * Java content interface and Java element interface 
 * generated in the com.jdap.auction.common.xml.bid package. 
 * <p>An ObjectFactory allows you to programatically 
 * construct new instances of the Java representation 
 * for XML content. The Java representation of XML 
 * content can consist of schema derived interfaces 
 * and classes representing the binding of schema 
 * type definitions, element declarations and model 
 * groups.  Factory methods for each of these are 
 * provided in this class.
 * 
 */
@XmlRegistry
public class ObjectFactory {

    private final static QName _ProblemIRI_QNAME = new QName("http://www.w3.org/2005/08/addressing", "ProblemIRI");
    private final static QName _EndpointReference_QNAME = new QName("http://www.w3.org/2005/08/addressing", "EndpointReference");
    private final static QName _ProblemHeaderQName_QNAME = new QName("http://www.w3.org/2005/08/addressing", "ProblemHeaderQName");
    private final static QName _ReferenceParameters_QNAME = new QName("http://www.w3.org/2005/08/addressing", "ReferenceParameters");
    private final static QName _From_QNAME = new QName("http://www.w3.org/2005/08/addressing", "From");
    private final static QName _ReplyTo_QNAME = new QName("http://www.w3.org/2005/08/addressing", "ReplyTo");
    private final static QName _MessageHeader_QNAME = new QName("http://xmlns.jdap.com/Common/MessageHeader/v2", "MessageHeader");
    private final static QName _Action_QNAME = new QName("http://www.w3.org/2005/08/addressing", "Action");
    private final static QName _UpdateBidRequestMessage_QNAME = new QName("http://xmlns.jdap.com/auction/Bid/Messages/v2", "UpdateBidRequestMessage");
    private final static QName _QueryBidResponseMessage_QNAME = new QName("http://xmlns.jdap.com/auction/Bid/Messages/v2", "QueryBidResponseMessage");
    private final static QName _FaultTo_QNAME = new QName("http://www.w3.org/2005/08/addressing", "FaultTo");
    private final static QName _RetryAfter_QNAME = new QName("http://www.w3.org/2005/08/addressing", "RetryAfter");
    private final static QName _CreateBidRequestMessage_QNAME = new QName("http://xmlns.jdap.com/auction/Bid/Messages/v2", "CreateBidRequestMessage");
    private final static QName _QueryBidDetailsRequestMessage_QNAME = new QName("http://xmlns.jdap.com/auction/Bid/Messages/v2", "QueryBidDetailsRequestMessage");
    private final static QName _To_QNAME = new QName("http://www.w3.org/2005/08/addressing", "To");
    private final static QName _CreateBidResponseMessage_QNAME = new QName("http://xmlns.jdap.com/auction/Bid/Messages/v2", "CreateBidResponseMessage");
    private final static QName _ProblemAction_QNAME = new QName("http://www.w3.org/2005/08/addressing", "ProblemAction");
    private final static QName _Bid_QNAME = new QName("http://xmlns.jdap.com/auction/Bid/Objects/v2", "bid");
    private final static QName _CreateBidDetailsResponseMessage_QNAME = new QName("http://xmlns.jdap.com/auction/Bid/Messages/v2", "CreateBidDetailsResponseMessage");
    private final static QName _DeleteBidResponseMessage_QNAME = new QName("http://xmlns.jdap.com/auction/Bid/Messages/v2", "DeleteBidResponseMessage");
    private final static QName _RelatesTo_QNAME = new QName("http://www.w3.org/2005/08/addressing", "RelatesTo");
    private final static QName _DeleteBidRequestMessage_QNAME = new QName("http://xmlns.jdap.com/auction/Bid/Messages/v2", "DeleteBidRequestMessage");
    private final static QName _Metadata_QNAME = new QName("http://www.w3.org/2005/08/addressing", "Metadata");
    private final static QName _QueryBidDetailsResponseMessage_QNAME = new QName("http://xmlns.jdap.com/auction/Bid/Messages/v2", "QueryBidDetailsResponseMessage");
    private final static QName _CreateBidDetailsRequestMessage_QNAME = new QName("http://xmlns.jdap.com/auction/Bid/Messages/v2", "CreateBidDetailsRequestMessage");
    private final static QName _QueryBidRequestMessage_QNAME = new QName("http://xmlns.jdap.com/auction/Bid/Messages/v2", "QueryBidRequestMessage");
    private final static QName _UpdateBidResponseMessage_QNAME = new QName("http://xmlns.jdap.com/auction/Bid/Messages/v2", "UpdateBidResponseMessage");
    private final static QName _MessageID_QNAME = new QName("http://www.w3.org/2005/08/addressing", "MessageID");

    /**
     * Create a new ObjectFactory that can be used to create new instances of schema derived classes for package: com.jdap.auction.common.xml.bid
     * 
     */
    public ObjectFactory() {
    }

    /**
     * Create an instance of {@link CreateBidDetailsRequestMessageType }
     * 
     */
    public CreateBidDetailsRequestMessageType createCreateBidDetailsRequestMessageType() {
        return new CreateBidDetailsRequestMessageType();
    }

    /**
     * Create an instance of {@link QueryBidDetailsResponseMessageType }
     * 
     */
    public QueryBidDetailsResponseMessageType createQueryBidDetailsResponseMessageType() {
        return new QueryBidDetailsResponseMessageType();
    }

    /**
     * Create an instance of {@link QueryBidRequestMessageType }
     * 
     */
    public QueryBidRequestMessageType createQueryBidRequestMessageType() {
        return new QueryBidRequestMessageType();
    }

    /**
     * Create an instance of {@link UpdateBidRequestMessageType }
     * 
     */
    public UpdateBidRequestMessageType createUpdateBidRequestMessageType() {
        return new UpdateBidRequestMessageType();
    }

    /**
     * Create an instance of {@link QueryBidResponseMessageType }
     * 
     */
    public QueryBidResponseMessageType createQueryBidResponseMessageType() {
        return new QueryBidResponseMessageType();
    }

    /**
     * Create an instance of {@link UpdateBidResponseMessageType }
     * 
     */
    public UpdateBidResponseMessageType createUpdateBidResponseMessageType() {
        return new UpdateBidResponseMessageType();
    }

    /**
     * Create an instance of {@link CreateBidResponseMessageType }
     * 
     */
    public CreateBidResponseMessageType createCreateBidResponseMessageType() {
        return new CreateBidResponseMessageType();
    }

    /**
     * Create an instance of {@link CreateBidDetailsResponseMessageType }
     * 
     */
    public CreateBidDetailsResponseMessageType createCreateBidDetailsResponseMessageType() {
        return new CreateBidDetailsResponseMessageType();
    }

    /**
     * Create an instance of {@link DeleteBidResponseMessageType }
     * 
     */
    public DeleteBidResponseMessageType createDeleteBidResponseMessageType() {
        return new DeleteBidResponseMessageType();
    }

    /**
     * Create an instance of {@link CreateBidRequestMessageType }
     * 
     */
    public CreateBidRequestMessageType createCreateBidRequestMessageType() {
        return new CreateBidRequestMessageType();
    }

    /**
     * Create an instance of {@link QueryBidDetailsRequestMessageType }
     * 
     */
    public QueryBidDetailsRequestMessageType createQueryBidDetailsRequestMessageType() {
        return new QueryBidDetailsRequestMessageType();
    }

    /**
     * Create an instance of {@link DeleteBidRequestMessageType }
     * 
     */
    public DeleteBidRequestMessageType createDeleteBidRequestMessageType() {
        return new DeleteBidRequestMessageType();
    }

    /**
     * Create an instance of {@link BidType }
     * 
     */
    public BidType createBidType() {
        return new BidType();
    }

    /**
     * Create an instance of {@link ListOfValuesType }
     * 
     */
    public ListOfValuesType createListOfValuesType() {
        return new ListOfValuesType();
    }

    /**
     * Create an instance of {@link CategoryType }
     * 
     */
    public CategoryType createCategoryType() {
        return new CategoryType();
    }

    /**
     * Create an instance of {@link UserIDType }
     * 
     */
    public UserIDType createUserIDType() {
        return new UserIDType();
    }

    /**
     * Create an instance of {@link ValueHolderType }
     * 
     */
    public ValueHolderType createValueHolderType() {
        return new ValueHolderType();
    }

    /**
     * Create an instance of {@link NameValuePairDataType }
     * 
     */
    public NameValuePairDataType createNameValuePairDataType() {
        return new NameValuePairDataType();
    }

    /**
     * Create an instance of {@link RangeOfDatesType }
     * 
     */
    public RangeOfDatesType createRangeOfDatesType() {
        return new RangeOfDatesType();
    }

    /**
     * Create an instance of {@link ExtensionBidType }
     * 
     */
    public ExtensionBidType createExtensionBidType() {
        return new ExtensionBidType();
    }

    /**
     * Create an instance of {@link MessageHeaderType }
     * 
     */
    public MessageHeaderType createMessageHeaderType() {
        return new MessageHeaderType();
    }

    /**
     * Create an instance of {@link SenderType }
     * 
     */
    public SenderType createSenderType() {
        return new SenderType();
    }

    /**
     * Create an instance of {@link WSAddressType }
     * 
     */
    public WSAddressType createWSAddressType() {
        return new WSAddressType();
    }

    /**
     * Create an instance of {@link NameValuePairType }
     * 
     */
    public NameValuePairType createNameValuePairType() {
        return new NameValuePairType();
    }

    /**
     * Create an instance of {@link ProblemActionType }
     * 
     */
    public ProblemActionType createProblemActionType() {
        return new ProblemActionType();
    }

    /**
     * Create an instance of {@link AttributedURIType }
     * 
     */
    public AttributedURIType createAttributedURIType() {
        return new AttributedURIType();
    }

    /**
     * Create an instance of {@link AttributedQNameType }
     * 
     */
    public AttributedQNameType createAttributedQNameType() {
        return new AttributedQNameType();
    }

    /**
     * Create an instance of {@link EndpointReferenceType }
     * 
     */
    public EndpointReferenceType createEndpointReferenceType() {
        return new EndpointReferenceType();
    }

    /**
     * Create an instance of {@link AttributedUnsignedLongType }
     * 
     */
    public AttributedUnsignedLongType createAttributedUnsignedLongType() {
        return new AttributedUnsignedLongType();
    }

    /**
     * Create an instance of {@link MetadataType }
     * 
     */
    public MetadataType createMetadataType() {
        return new MetadataType();
    }

    /**
     * Create an instance of {@link ReferenceParametersType }
     * 
     */
    public ReferenceParametersType createReferenceParametersType() {
        return new ReferenceParametersType();
    }

    /**
     * Create an instance of {@link RelatesToType }
     * 
     */
    public RelatesToType createRelatesToType() {
        return new RelatesToType();
    }

    /**
     * Create an instance of {@link ExtensionMessageHeaderType }
     * 
     */
    public ExtensionMessageHeaderType createExtensionMessageHeaderType() {
        return new ExtensionMessageHeaderType();
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link AttributedURIType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "ProblemIRI")
    public JAXBElement<AttributedURIType> createProblemIRI(AttributedURIType value) {
        return new JAXBElement<AttributedURIType>(_ProblemIRI_QNAME, AttributedURIType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link EndpointReferenceType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "EndpointReference")
    public JAXBElement<EndpointReferenceType> createEndpointReference(EndpointReferenceType value) {
        return new JAXBElement<EndpointReferenceType>(_EndpointReference_QNAME, EndpointReferenceType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link AttributedQNameType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "ProblemHeaderQName")
    public JAXBElement<AttributedQNameType> createProblemHeaderQName(AttributedQNameType value) {
        return new JAXBElement<AttributedQNameType>(_ProblemHeaderQName_QNAME, AttributedQNameType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link ReferenceParametersType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "ReferenceParameters")
    public JAXBElement<ReferenceParametersType> createReferenceParameters(ReferenceParametersType value) {
        return new JAXBElement<ReferenceParametersType>(_ReferenceParameters_QNAME, ReferenceParametersType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link EndpointReferenceType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "From")
    public JAXBElement<EndpointReferenceType> createFrom(EndpointReferenceType value) {
        return new JAXBElement<EndpointReferenceType>(_From_QNAME, EndpointReferenceType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link EndpointReferenceType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "ReplyTo")
    public JAXBElement<EndpointReferenceType> createReplyTo(EndpointReferenceType value) {
        return new JAXBElement<EndpointReferenceType>(_ReplyTo_QNAME, EndpointReferenceType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link MessageHeaderType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/Common/MessageHeader/v2", name = "MessageHeader")
    public JAXBElement<MessageHeaderType> createMessageHeader(MessageHeaderType value) {
        return new JAXBElement<MessageHeaderType>(_MessageHeader_QNAME, MessageHeaderType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link AttributedURIType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "Action")
    public JAXBElement<AttributedURIType> createAction(AttributedURIType value) {
        return new JAXBElement<AttributedURIType>(_Action_QNAME, AttributedURIType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link UpdateBidRequestMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/Bid/Messages/v2", name = "UpdateBidRequestMessage")
    public JAXBElement<UpdateBidRequestMessageType> createUpdateBidRequestMessage(UpdateBidRequestMessageType value) {
        return new JAXBElement<UpdateBidRequestMessageType>(_UpdateBidRequestMessage_QNAME, UpdateBidRequestMessageType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link QueryBidResponseMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/Bid/Messages/v2", name = "QueryBidResponseMessage")
    public JAXBElement<QueryBidResponseMessageType> createQueryBidResponseMessage(QueryBidResponseMessageType value) {
        return new JAXBElement<QueryBidResponseMessageType>(_QueryBidResponseMessage_QNAME, QueryBidResponseMessageType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link EndpointReferenceType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "FaultTo")
    public JAXBElement<EndpointReferenceType> createFaultTo(EndpointReferenceType value) {
        return new JAXBElement<EndpointReferenceType>(_FaultTo_QNAME, EndpointReferenceType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link AttributedUnsignedLongType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "RetryAfter")
    public JAXBElement<AttributedUnsignedLongType> createRetryAfter(AttributedUnsignedLongType value) {
        return new JAXBElement<AttributedUnsignedLongType>(_RetryAfter_QNAME, AttributedUnsignedLongType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link CreateBidRequestMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/Bid/Messages/v2", name = "CreateBidRequestMessage")
    public JAXBElement<CreateBidRequestMessageType> createCreateBidRequestMessage(CreateBidRequestMessageType value) {
        return new JAXBElement<CreateBidRequestMessageType>(_CreateBidRequestMessage_QNAME, CreateBidRequestMessageType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link QueryBidDetailsRequestMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/Bid/Messages/v2", name = "QueryBidDetailsRequestMessage")
    public JAXBElement<QueryBidDetailsRequestMessageType> createQueryBidDetailsRequestMessage(QueryBidDetailsRequestMessageType value) {
        return new JAXBElement<QueryBidDetailsRequestMessageType>(_QueryBidDetailsRequestMessage_QNAME, QueryBidDetailsRequestMessageType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link AttributedURIType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "To")
    public JAXBElement<AttributedURIType> createTo(AttributedURIType value) {
        return new JAXBElement<AttributedURIType>(_To_QNAME, AttributedURIType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link CreateBidResponseMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/Bid/Messages/v2", name = "CreateBidResponseMessage")
    public JAXBElement<CreateBidResponseMessageType> createCreateBidResponseMessage(CreateBidResponseMessageType value) {
        return new JAXBElement<CreateBidResponseMessageType>(_CreateBidResponseMessage_QNAME, CreateBidResponseMessageType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link ProblemActionType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "ProblemAction")
    public JAXBElement<ProblemActionType> createProblemAction(ProblemActionType value) {
        return new JAXBElement<ProblemActionType>(_ProblemAction_QNAME, ProblemActionType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link BidType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/Bid/Objects/v2", name = "bid")
    public JAXBElement<BidType> createBid(BidType value) {
        return new JAXBElement<BidType>(_Bid_QNAME, BidType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link CreateBidDetailsResponseMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/Bid/Messages/v2", name = "CreateBidDetailsResponseMessage")
    public JAXBElement<CreateBidDetailsResponseMessageType> createCreateBidDetailsResponseMessage(CreateBidDetailsResponseMessageType value) {
        return new JAXBElement<CreateBidDetailsResponseMessageType>(_CreateBidDetailsResponseMessage_QNAME, CreateBidDetailsResponseMessageType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link DeleteBidResponseMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/Bid/Messages/v2", name = "DeleteBidResponseMessage")
    public JAXBElement<DeleteBidResponseMessageType> createDeleteBidResponseMessage(DeleteBidResponseMessageType value) {
        return new JAXBElement<DeleteBidResponseMessageType>(_DeleteBidResponseMessage_QNAME, DeleteBidResponseMessageType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link RelatesToType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "RelatesTo")
    public JAXBElement<RelatesToType> createRelatesTo(RelatesToType value) {
        return new JAXBElement<RelatesToType>(_RelatesTo_QNAME, RelatesToType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link DeleteBidRequestMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/Bid/Messages/v2", name = "DeleteBidRequestMessage")
    public JAXBElement<DeleteBidRequestMessageType> createDeleteBidRequestMessage(DeleteBidRequestMessageType value) {
        return new JAXBElement<DeleteBidRequestMessageType>(_DeleteBidRequestMessage_QNAME, DeleteBidRequestMessageType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link MetadataType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "Metadata")
    public JAXBElement<MetadataType> createMetadata(MetadataType value) {
        return new JAXBElement<MetadataType>(_Metadata_QNAME, MetadataType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link QueryBidDetailsResponseMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/Bid/Messages/v2", name = "QueryBidDetailsResponseMessage")
    public JAXBElement<QueryBidDetailsResponseMessageType> createQueryBidDetailsResponseMessage(QueryBidDetailsResponseMessageType value) {
        return new JAXBElement<QueryBidDetailsResponseMessageType>(_QueryBidDetailsResponseMessage_QNAME, QueryBidDetailsResponseMessageType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link CreateBidDetailsRequestMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/Bid/Messages/v2", name = "CreateBidDetailsRequestMessage")
    public JAXBElement<CreateBidDetailsRequestMessageType> createCreateBidDetailsRequestMessage(CreateBidDetailsRequestMessageType value) {
        return new JAXBElement<CreateBidDetailsRequestMessageType>(_CreateBidDetailsRequestMessage_QNAME, CreateBidDetailsRequestMessageType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link QueryBidRequestMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/Bid/Messages/v2", name = "QueryBidRequestMessage")
    public JAXBElement<QueryBidRequestMessageType> createQueryBidRequestMessage(QueryBidRequestMessageType value) {
        return new JAXBElement<QueryBidRequestMessageType>(_QueryBidRequestMessage_QNAME, QueryBidRequestMessageType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link UpdateBidResponseMessageType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://xmlns.jdap.com/auction/Bid/Messages/v2", name = "UpdateBidResponseMessage")
    public JAXBElement<UpdateBidResponseMessageType> createUpdateBidResponseMessage(UpdateBidResponseMessageType value) {
        return new JAXBElement<UpdateBidResponseMessageType>(_UpdateBidResponseMessage_QNAME, UpdateBidResponseMessageType.class, null, value);
    }

    /**
     * Create an instance of {@link JAXBElement }{@code <}{@link AttributedURIType }{@code >}}
     * 
     */
    @XmlElementDecl(namespace = "http://www.w3.org/2005/08/addressing", name = "MessageID")
    public JAXBElement<AttributedURIType> createMessageID(AttributedURIType value) {
        return new JAXBElement<AttributedURIType>(_MessageID_QNAME, AttributedURIType.class, null, value);
    }

}
<file_sep>/auction/common/xml/xml-user/target/generated-sources/jaxb/com/jdap/auction/common/xml/user/SellerType.java
//
// This file was generated by the JavaTM Architecture for XML Binding(JAXB) Reference Implementation, v2.2.7 
// See <a href="http://java.sun.com/xml/jaxb">http://java.sun.com/xml/jaxb</a> 
// Any modifications to this file will be lost upon recompilation of the source schema. 
// Generated on: 2015.02.11 at 02:45:57 PM EST 
//


package com.jdap.auction.common.xml.user;

import javax.xml.bind.annotation.XmlAccessType;
import javax.xml.bind.annotation.XmlAccessorType;
import javax.xml.bind.annotation.XmlType;


/**
 * <p>Java class for sellerType complex type.
 * 
 * <p>The following schema fragment specifies the expected content contained within this class.
 * 
 * <pre>
 * &lt;complexType name="sellerType">
 *   &lt;complexContent>
 *     &lt;extension base="{http://xmlns.jdap.com/auction/User/Objects/v2}userType">
 *       &lt;sequence>
 *         &lt;element name="creditWorth" type="{http://www.w3.org/2001/XMLSchema}double"/>
 *         &lt;element name="commissionRate" type="{http://www.w3.org/2001/XMLSchema}double"/>
 *         &lt;element name="sellerExtension" type="{http://xmlns.jdap.com/auction/Seller/Objects/Extension/v2}ExtensionSellerType" minOccurs="0"/>
 *       &lt;/sequence>
 *     &lt;/extension>
 *   &lt;/complexContent>
 * &lt;/complexType>
 * </pre>
 * 
 * 
 */
@XmlAccessorType(XmlAccessType.FIELD)
@XmlType(name = "sellerType", namespace = "http://xmlns.jdap.com/auction/Seller/Objects/v2", propOrder = {
    "creditWorth",
    "commissionRate",
    "sellerExtension"
})
public class SellerType
    extends UserType
{

    protected double creditWorth;
    protected double commissionRate;
    protected ExtensionSellerType sellerExtension;

    /**
     * Gets the value of the creditWorth property.
     * 
     */
    public double getCreditWorth() {
        return creditWorth;
    }

    /**
     * Sets the value of the creditWorth property.
     * 
     */
    public void setCreditWorth(double value) {
        this.creditWorth = value;
    }

    /**
     * Gets the value of the commissionRate property.
     * 
     */
    public double getCommissionRate() {
        return commissionRate;
    }

    /**
     * Sets the value of the commissionRate property.
     * 
     */
    public void setCommissionRate(double value) {
        this.commissionRate = value;
    }

    /**
     * Gets the value of the sellerExtension property.
     * 
     * @return
     *     possible object is
     *     {@link ExtensionSellerType }
     *     
     */
    public ExtensionSellerType getSellerExtension() {
        return sellerExtension;
    }

    /**
     * Sets the value of the sellerExtension property.
     * 
     * @param value
     *     allowed object is
     *     {@link ExtensionSellerType }
     *     
     */
    public void setSellerExtension(ExtensionSellerType value) {
        this.sellerExtension = value;
    }

}
<file_sep>/auction/sql/slq scripts.sql
select count(6) from bids;

select * from bids;
SELECT * FROM bidders;

delete bids;
drop table bids;


CREATE TABLE "CDMR"."BIDS"
  (
    "BID_ID"     NUMBER(19,0) NOT NULL ENABLE,
    "BID_AMOUNT" NUMBER(19,4),
    "BID_DATE" TIMESTAMP (6),
    "BIDDER_ID" NUMBER(19,0),
    "ITEM_ID"   NUMBER(19,0),
    PRIMARY KEY ("BID_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "CDMR_TABLESPACE" ENABLE
  )
  SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE
  (
    INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT
  )
  
  CREATE TABLE "CDMR"."BID"
  (
    "BIDAMOUNT" NUMBER(19,4),
    "BIDDATE" TIMESTAMP (6),
    "BIDDERID" NUMBER(19,0),
    "ITEMID"   NUMBER(19,0),
    "LASTMODIFIED" TIMESTAMP (6),
    "VERSION"        NUMBER(19,0),
    "OID"            VARCHAR2(36 BYTE),
    PRIMARY KEY ("OID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "CDMR_TABLESPACE" ENABLE
  )
  SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE
  (
    INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT
  )

  
CREATE TABLE "CDMR"."SEQUENCE"
  (
    "SEQ_COUNT" NUMBER(38,0),
    "SEQ_NAME"  VARCHAR2(50 BYTE) NOT NULL ENABLE,
    PRIMARY KEY ("SEQ_NAME") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "CDMR_TABLESPACE" ENABLE
  )
  SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE
  (
    INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT
  )
  TABLESPACE "CDMR_TABLESPACE" ;  <file_sep>/auction/common/xml/xml-user/target/generated-sources/jaxb/com/jdap/auction/common/xml/user/UserKind.java
//
// This file was generated by the JavaTM Architecture for XML Binding(JAXB) Reference Implementation, v2.2.7 
// See <a href="http://java.sun.com/xml/jaxb">http://java.sun.com/xml/jaxb</a> 
// Any modifications to this file will be lost upon recompilation of the source schema. 
// Generated on: 2015.02.11 at 02:45:57 PM EST 
//


package com.jdap.auction.common.xml.user;

import javax.xml.bind.annotation.XmlEnum;
import javax.xml.bind.annotation.XmlType;


/**
 * <p>Java class for UserKind.
 * 
 * <p>The following schema fragment specifies the expected content contained within this class.
 * <p>
 * <pre>
 * &lt;simpleType name="UserKind">
 *   &lt;restriction base="{http://www.w3.org/2001/XMLSchema}string">
 *     &lt;enumeration value="SELLER"/>
 *     &lt;enumeration value="BIDDER"/>
 *     &lt;enumeration value="CSM"/>
 *     &lt;enumeration value="ADMIN"/>
 *   &lt;/restriction>
 * &lt;/simpleType>
 * </pre>
 * 
 */
@XmlType(name = "UserKind", namespace = "http://xmlns.jdap.com/auction/Common/v2")
@XmlEnum
public enum UserKind {

    SELLER,
    BIDDER,
    CSM,
    ADMIN;

    public String value() {
        return name();
    }

    public static UserKind fromValue(String v) {
        return valueOf(v);
    }

}
<file_sep>/auction/sql/Worksheet 51.sql
select * from category;
select * from Item;

delete from item where title = '?';
delete from item_category ic where ic.itemid = any (select oid from item where title = '?');


<file_sep>/auction/sql/dropDDL_action.sql
ALTER TABLE ORDERS DROP CONSTRAINT FK_ORDERS_bidderid;
ALTER TABLE USERS DROP CONSTRAINT FK_USERS_billingInfoid;
ALTER TABLE USERSPICTURE DROP CONSTRAINT FK_USERSPICTURE_OID;
ALTER TABLE BIDDER DROP CONSTRAINT FK_BIDDER_OID;
ALTER TABLE CATEGORY DROP CONSTRAINT FK_CATEGORY_parentCategoryid;
ALTER TABLE CONTACTINFO DROP CONSTRAINT FK_CONTACTINFO_userid;
ALTER TABLE BID DROP CONSTRAINT FK_BID_itemid;
ALTER TABLE BID DROP CONSTRAINT FK_BID_bidderid;
ALTER TABLE SELLER DROP CONSTRAINT FK_SELLER_OID;
ALTER TABLE ITEM DROP CONSTRAINT FK_ITEM_sellerid;
ALTER TABLE ITEM DROP CONSTRAINT FK_ITEM_orderid;
ALTER TABLE category_items DROP CONSTRAINT FK_category_items_itemid;
ALTER TABLE category_items DROP CONSTRAINT FK_category_items_categoryid;
ALTER TABLE users_category DROP CONSTRAINT FK_users_category_userid;
ALTER TABLE users_category DROP CONSTRAINT FK_users_category_categoryid;
DROP TABLE ORDERS;
DROP TABLE USERS;
DROP TABLE USERSPICTURE;
DROP TABLE BIDDER;
DROP TABLE CATEGORY;
DROP TABLE CONTACTINFO;
DROP TABLE BID;
DROP TABLE SELLER;
DROP TABLE BILLINGINFO;
DROP TABLE ITEM;
DROP TABLE category_items;
DROP TABLE users_category;
<file_sep>/auction/common/xml/xml-user/target/generated-sources/jaxb/com/jdap/auction/common/xml/user/UserType.java
//
// This file was generated by the JavaTM Architecture for XML Binding(JAXB) Reference Implementation, v2.2.7 
// See <a href="http://java.sun.com/xml/jaxb">http://java.sun.com/xml/jaxb</a> 
// Any modifications to this file will be lost upon recompilation of the source schema. 
// Generated on: 2015.02.11 at 02:45:57 PM EST 
//


package com.jdap.auction.common.xml.user;

import java.util.ArrayList;
import java.util.List;
import javax.xml.bind.annotation.XmlAccessType;
import javax.xml.bind.annotation.XmlAccessorType;
import javax.xml.bind.annotation.XmlElement;
import javax.xml.bind.annotation.XmlSchemaType;
import javax.xml.bind.annotation.XmlSeeAlso;
import javax.xml.bind.annotation.XmlType;
import javax.xml.datatype.XMLGregorianCalendar;


/**
 * <p>Java class for userType complex type.
 * 
 * <p>The following schema fragment specifies the expected content contained within this class.
 * 
 * <pre>
 * &lt;complexType name="userType">
 *   &lt;complexContent>
 *     &lt;restriction base="{http://www.w3.org/2001/XMLSchema}anyType">
 *       &lt;sequence>
 *         &lt;element name="id" type="{http://www.w3.org/2001/XMLSchema}string" minOccurs="0"/>
 *         &lt;element name="usertype" type="{http://xmlns.jdap.com/auction/Common/v2}UserKind"/>
 *         &lt;element name="username" type="{http://www.w3.org/2001/XMLSchema}string"/>
 *         &lt;element name="password">
 *           &lt;simpleType>
 *             &lt;restriction base="{http://www.w3.org/2001/XMLSchema}string">
 *               &lt;minLength value="5"/>
 *               &lt;maxLength value="8"/>
 *             &lt;/restriction>
 *           &lt;/simpleType>
 *         &lt;/element>
 *         &lt;element name="firstName" type="{http://www.w3.org/2001/XMLSchema}string"/>
 *         &lt;element name="lastName" type="{http://www.w3.org/2001/XMLSchema}string" minOccurs="0"/>
 *         &lt;element name="email" type="{http://www.w3.org/2001/XMLSchema}string"/>
 *         &lt;element name="phone" type="{http://www.w3.org/2001/XMLSchema}string" minOccurs="0"/>
 *         &lt;element name="creationDate" type="{http://www.w3.org/2001/XMLSchema}dateTime" minOccurs="0"/>
 *         &lt;element name="picture" type="{http://www.w3.org/2001/XMLSchema}byte" minOccurs="0"/>
 *         &lt;element ref="{http://xmlns.jdap.com/auction/Address/Objects/v2}address"/>
 *         &lt;element name="category" type="{http://xmlns.jdap.com/auction/Common/v2}categoryType" maxOccurs="unbounded" minOccurs="0"/>
 *         &lt;element name="Extension" type="{http://xmlns.jdap.com/auction/User/Objects/Extension/v2}ExtensionUserType" minOccurs="0"/>
 *       &lt;/sequence>
 *     &lt;/restriction>
 *   &lt;/complexContent>
 * &lt;/complexType>
 * </pre>
 * 
 * 
 */
@XmlAccessorType(XmlAccessType.FIELD)
@XmlType(name = "userType", namespace = "http://xmlns.jdap.com/auction/User/Objects/v2", propOrder = {
    "id",
    "usertype",
    "username",
    "<PASSWORD>",
    "firstName",
    "lastName",
    "email",
    "phone",
    "creationDate",
    "picture",
    "address",
    "category",
    "extension"
})
@XmlSeeAlso({
    SellerType.class,
    BidderType.class
})
public abstract class UserType {

    protected String id;
    @XmlElement(required = true)
    protected UserKind usertype;
    @XmlElement(required = true)
    protected String username;
    @XmlElement(required = true)
    protected String password;
    @XmlElement(required = true)
    protected String firstName;
    protected String lastName;
    @XmlElement(required = true)
    protected String email;
    protected String phone;
    @XmlSchemaType(name = "dateTime")
    protected XMLGregorianCalendar creationDate;
    protected Byte picture;
    @XmlElement(namespace = "http://xmlns.jdap.com/auction/Address/Objects/v2", required = true)
    protected AddressType address;
    @XmlElement(type = CategoryType.class)
    protected List<CategoryType> category;
    @XmlElement(name = "Extension")
    protected ExtensionUserType extension;

    /**
     * Gets the value of the id property.
     * 
     * @return
     *     possible object is
     *     {@link String }
     *     
     */
    public String getId() {
        return id;
    }

    /**
     * Sets the value of the id property.
     * 
     * @param value
     *     allowed object is
     *     {@link String }
     *     
     */
    public void setId(String value) {
        this.id = value;
    }

    /**
     * Gets the value of the usertype property.
     * 
     * @return
     *     possible object is
     *     {@link UserKind }
     *     
     */
    public UserKind getUsertype() {
        return usertype;
    }

    /**
     * Sets the value of the usertype property.
     * 
     * @param value
     *     allowed object is
     *     {@link UserKind }
     *     
     */
    public void setUsertype(UserKind value) {
        this.usertype = value;
    }

    /**
     * Gets the value of the username property.
     * 
     * @return
     *     possible object is
     *     {@link String }
     *     
     */
    public String getUsername() {
        return username;
    }

    /**
     * Sets the value of the username property.
     * 
     * @param value
     *     allowed object is
     *     {@link String }
     *     
     */
    public void setUsername(String value) {
        this.username = value;
    }

    /**
     * Gets the value of the password property.
     * 
     * @return
     *     possible object is
     *     {@link String }
     *     
     */
    public String getPassword() {
        return password;
    }

    /**
     * Sets the value of the password property.
     * 
     * @param value
     *     allowed object is
     *     {@link String }
     *     
     */
    public void setPassword(String value) {
        this.password = value;
    }

    /**
     * Gets the value of the firstName property.
     * 
     * @return
     *     possible object is
     *     {@link String }
     *     
     */
    public String getFirstName() {
        return firstName;
    }

    /**
     * Sets the value of the firstName property.
     * 
     * @param value
     *     allowed object is
     *     {@link String }
     *     
     */
    public void setFirstName(String value) {
        this.firstName = value;
    }

    /**
     * Gets the value of the lastName property.
     * 
     * @return
     *     possible object is
     *     {@link String }
     *     
     */
    public String getLastName() {
        return lastName;
    }

    /**
     * Sets the value of the lastName property.
     * 
     * @param value
     *     allowed object is
     *     {@link String }
     *     
     */
    public void setLastName(String value) {
        this.lastName = value;
    }

    /**
     * Gets the value of the email property.
     * 
     * @return
     *     possible object is
     *     {@link String }
     *     
     */
    public String getEmail() {
        return email;
    }

    /**
     * Sets the value of the email property.
     * 
     * @param value
     *     allowed object is
     *     {@link String }
     *     
     */
    public void setEmail(String value) {
        this.email = value;
    }

    /**
     * Gets the value of the phone property.
     * 
     * @return
     *     possible object is
     *     {@link String }
     *     
     */
    public String getPhone() {
        return phone;
    }

    /**
     * Sets the value of the phone property.
     * 
     * @param value
     *     allowed object is
     *     {@link String }
     *     
     */
    public void setPhone(String value) {
        this.phone = value;
    }

    /**
     * Gets the value of the creationDate property.
     * 
     * @return
     *     possible object is
     *     {@link XMLGregorianCalendar }
     *     
     */
    public XMLGregorianCalendar getCreationDate() {
        return creationDate;
    }

    /**
     * Sets the value of the creationDate property.
     * 
     * @param value
     *     allowed object is
     *     {@link XMLGregorianCalendar }
     *     
     */
    public void setCreationDate(XMLGregorianCalendar value) {
        this.creationDate = value;
    }

    /**
     * Gets the value of the picture property.
     * 
     * @return
     *     possible object is
     *     {@link Byte }
     *     
     */
    public Byte getPicture() {
        return picture;
    }

    /**
     * Sets the value of the picture property.
     * 
     * @param value
     *     allowed object is
     *     {@link Byte }
     *     
     */
    public void setPicture(Byte value) {
        this.picture = value;
    }

    /**
     * User Address
     * 
     * @return
     *     possible object is
     *     {@link AddressType }
     *     
     */
    public AddressType getAddress() {
        return address;
    }

    /**
     * Sets the value of the address property.
     * 
     * @param value
     *     allowed object is
     *     {@link AddressType }
     *     
     */
    public void setAddress(AddressType value) {
        this.address = value;
    }

    /**
     * Gets the value of the category property.
     * 
     * <p>
     * This accessor method returns a reference to the live list,
     * not a snapshot. Therefore any modification you make to the
     * returned list will be present inside the JAXB object.
     * This is why there is not a <CODE>set</CODE> method for the category property.
     * 
     * <p>
     * For example, to add a new item, do as follows:
     * <pre>
     *    getCategory().add(newItem);
     * </pre>
     * 
     * 
     * <p>
     * Objects of the following type(s) are allowed in the list
     * {@link CategoryType }
     * 
     * 
     */
    public List<CategoryType> getCategory() {
        if (category == null) {
            category = new ArrayList<CategoryType>();
        }
        return this.category;
    }

    /**
     * Gets the value of the extension property.
     * 
     * @return
     *     possible object is
     *     {@link ExtensionUserType }
     *     
     */
    public ExtensionUserType getExtension() {
        return extension;
    }

    /**
     * Sets the value of the extension property.
     * 
     * @param value
     *     allowed object is
     *     {@link ExtensionUserType }
     *     
     */
    public void setExtension(ExtensionUserType value) {
        this.extension = value;
    }

}
<file_sep>/auction/domain-module/model-pu/target/classes/META-INF/maven/com.jdap.auction.domain-model/auction-domain-model-pu/pom.xml
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<parent>
		<artifactId>auction-domain</artifactId>
		<groupId>com.jdap.auction.domain-model</groupId>
		<version>0.0.1-SNAPSHOT</version>
	</parent>

	<groupId>com.jdap.auction.domain-model</groupId>
	<artifactId>auction-domain-model-pu</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<packaging>jar</packaging>
	

	<build>
		<plugins>
			<plugin>
				<groupId>org.apache.maven.plugins</groupId>
				<artifactId>maven-compiler-plugin</artifactId>
				<version>2.0.2</version>
				<configuration>
					<source>1.6</source>
					<target>1.6</target>
				</configuration>
			</plugin>

			<plugin>
				<artifactId>maven-antrun-plugin</artifactId>
				<version>1.6</version>
				<executions>
					<execution>
						<configuration>
							<target>
								<replace file="./target/classes/META-INF/persistence.xml">
									<replacetoken><![CDATA[lib/auction-domain-model-XXX.jar]]></replacetoken>
									<replacevalue>lib/auction-domain-model-${project.version}.jar</replacevalue>
								</replace>
							</target>
						</configuration>
						<phase>compile</phase>
						<goals>
							<goal>run</goal>
						</goals>
					</execution>
					<execution>
						<id>clean</id>
						<phase>clean</phase>
						<configuration>
							<target>
								<delete dir="target" />
							</target>
						</configuration>
						<goals>
							<goal>run</goal>
						</goals>
					</execution>
				</executions>
			</plugin>
		</plugins>
	</build>
</project><file_sep>/auction/common/xml/xml-user/target/generated-sources/jaxb/com/jdap/auction/common/xml/user/CategoryType.java
//
// This file was generated by the JavaTM Architecture for XML Binding(JAXB) Reference Implementation, v2.2.7 
// See <a href="http://java.sun.com/xml/jaxb">http://java.sun.com/xml/jaxb</a> 
// Any modifications to this file will be lost upon recompilation of the source schema. 
// Generated on: 2015.02.11 at 02:45:57 PM EST 
//


package com.jdap.auction.common.xml.user;

import java.util.ArrayList;
import java.util.List;
import javax.xml.bind.annotation.XmlAccessType;
import javax.xml.bind.annotation.XmlAccessorType;
import javax.xml.bind.annotation.XmlElement;
import javax.xml.bind.annotation.XmlType;


/**
 * <p>Java class for categoryType complex type.
 * 
 * <p>The following schema fragment specifies the expected content contained within this class.
 * 
 * <pre>
 * &lt;complexType name="categoryType">
 *   &lt;complexContent>
 *     &lt;restriction base="{http://www.w3.org/2001/XMLSchema}anyType">
 *       &lt;sequence>
 *         &lt;element name="id" type="{http://www.w3.org/2001/XMLSchema}string" minOccurs="0"/>
 *         &lt;element name="category" type="{http://www.w3.org/2001/XMLSchema}boolean"/>
 *         &lt;element name="name" type="{http://www.w3.org/2001/XMLSchema}string"/>
 *         &lt;element name="description" type="{http://www.w3.org/2001/XMLSchema}string"/>
 *         &lt;element name="subcategory" type="{http://xmlns.jdap.com/auction/Common/v2}categoryType" maxOccurs="unbounded" minOccurs="0"/>
 *       &lt;/sequence>
 *     &lt;/restriction>
 *   &lt;/complexContent>
 * &lt;/complexType>
 * </pre>
 * 
 * 
 */
@XmlAccessorType(XmlAccessType.FIELD)
@XmlType(name = "categoryType", namespace = "http://xmlns.jdap.com/auction/Common/v2", propOrder = {
    "id",
    "category",
    "name",
    "description",
    "subcategory"
})
public class CategoryType {

    protected String id;
    protected boolean category;
    @XmlElement(required = true)
    protected String name;
    @XmlElement(required = true)
    protected String description;
    @XmlElement(type = CategoryType.class)
    protected List<CategoryType> subcategory;

    /**
     * Gets the value of the id property.
     * 
     * @return
     *     possible object is
     *     {@link String }
     *     
     */
    public String getId() {
        return id;
    }

    /**
     * Sets the value of the id property.
     * 
     * @param value
     *     allowed object is
     *     {@link String }
     *     
     */
    public void setId(String value) {
        this.id = value;
    }

    /**
     * Gets the value of the category property.
     * 
     */
    public boolean isCategory() {
        return category;
    }

    /**
     * Sets the value of the category property.
     * 
     */
    public void setCategory(boolean value) {
        this.category = value;
    }

    /**
     * Gets the value of the name property.
     * 
     * @return
     *     possible object is
     *     {@link String }
     *     
     */
    public String getName() {
        return name;
    }

    /**
     * Sets the value of the name property.
     * 
     * @param value
     *     allowed object is
     *     {@link String }
     *     
     */
    public void setName(String value) {
        this.name = value;
    }

    /**
     * Gets the value of the description property.
     * 
     * @return
     *     possible object is
     *     {@link String }
     *     
     */
    public String getDescription() {
        return description;
    }

    /**
     * Sets the value of the description property.
     * 
     * @param value
     *     allowed object is
     *     {@link String }
     *     
     */
    public void setDescription(String value) {
        this.description = value;
    }

    /**
     * Gets the value of the subcategory property.
     * 
     * <p>
     * This accessor method returns a reference to the live list,
     * not a snapshot. Therefore any modification you make to the
     * returned list will be present inside the JAXB object.
     * This is why there is not a <CODE>set</CODE> method for the subcategory property.
     * 
     * <p>
     * For example, to add a new item, do as follows:
     * <pre>
     *    getSubcategory().add(newItem);
     * </pre>
     * 
     * 
     * <p>
     * Objects of the following type(s) are allowed in the list
     * {@link CategoryType }
     * 
     * 
     */
    public List<CategoryType> getSubcategory() {
        if (subcategory == null) {
            subcategory = new ArrayList<CategoryType>();
        }
        return this.subcategory;
    }

}
<file_sep>/auction/sql/Worksheet 3.sql
select distinct se.*, us.* from users us, seller se
where us.oid = se.oid
order by us.lastmodified desc; 

select distinct bi.*, us.* from users us,  bidder bi
where us.oid = bi.oid
order by us.lastmodified desc; 
 
select * from users; 
select * from seller;
select * from bidder;
select * from users_category;
select * from billinginfo;

select * from Item order by 2 desc;
select * from item_category where itemid = 'a36eedb1-664e-46c6-8333-70215fdc910c';
select * from category;

Category Test	03/21/2014 09:55:02	Category 1	5	61b646b8-8258-4e09-b9bc-14ab83c1a44b	{null}<file_sep>/auction/domain-module/model/src/main/java/com/jdap/auction/model/ContactInfo.java
package com.jdap.auction.model;

//~--- JDK imports -------------------------------------------------------------

import javax.persistence.Column;
import javax.persistence.Embedded;
import javax.persistence.Entity;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;

import com.jdap.auction.patterns.persistence.AbstractPersistentObject;

/**
 * Class description
 *
 *
 * @version        9.0, 2013.February.28 04:44 PM
 * @author         JDAP Corporation    
 */
@Entity
public class ContactInfo extends AbstractPersistentObject
{
    /**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	/** Field description */
    @Column( name = "FIRSTNAME", nullable = false )
    private String firstName;

    /** Field description */
    @Column( name = "LASTNAME" )
    private String lastName;

    /** Field description */
    @Embedded
    private Address address;

    /** Field description */
    private String email;

    /** Field description */
    private String phone;

    /** Field description */
    @ManyToOne
    @JoinColumn( name = "userid", referencedColumnName = "oid" )
    private User user;

    /**
     * Method description
     *
     *
     * @return
     */
    public String getFirstName()
    {
        return firstName;
    }

    /**
     * Method description
     *
     *
     * @param firstName
     */
    public void setFirstName( String firstName )
    {
        this.firstName = firstName;
    }

    /**
     * Method description
     *
     *
     * @return
     */
    public String getLastName()
    {
        return lastName;
    }

    /**
     * Method description
     *
     *
     * @param lastName
     */
    public void setLastName( String lastName )
    {
        this.lastName = lastName;
    }

    /**
     * Method description
     *
     *
     * @return
     */
    public Address getAddress()
    {
        return address;
    }

    /**
     * Method description
     *
     *
     * @param address
     */
    public void setAddress( Address address )
    {
        this.address = address;
    }

    /**
     * Method description
     *
     *
     * @return
     */
    public String getEmail()
    {
        return email;
    }

    /**
     * Method description
     *
     *
     * @param email
     */
    public void setEmail( String email )
    {
        this.email = email;
    }

    /**
     * Method description
     *
     *
     * @return
     */
    public String getPhone()
    {
        return phone;
    }

    /**
     * Method description
     *
     *
     * @param phone
     */
    public void setPhone( String phone )
    {
        this.phone = phone;
    }

    /**
     * Method description
     *
     *
     * @return
     */
    public User getUser()
    {
        return user;
    }

    /**
     * Method description
     *
     *
     * @param user
     */
    public void setUser( User user )
    {
        this.user = user;
    }
}
<file_sep>/auction/sql/get tha referend tables.sql
select   a.table_name
        , a.constraint_name
        , a.constraint_type
        , b.table_name
        , b.column_name
        , b.position
from     user_constraints a
        , user_cons_columns b
where    a.owner = b.owner
and      a.constraint_name = b.constraint_name
and      a.constraint_type = 'P'
and     a.table_name = 'USERS'
union all
select   a.table_name
        , a.constraint_name
        , a.constraint_type
        , b.table_name
        , b.column_name
        , b.position
from     user_constraints a
        , user_cons_columns b
where    a.owner = b.owner
and      a.r_constraint_name = b.constraint_name
and      a.constraint_type = 'R'
and      a.table_name = 'USERS'
order by 1, 2, 3, 4, 5
/



select table_name, constraint_name, status, owner
from all_constraints
where r_owner = 'CDMR'
and constraint_type = 'R'
and r_constraint_name in
 (
   select constraint_name from all_constraints
   where constraint_type in ('P', 'U')
   and table_name = 'USERS'
   and owner = 'CDMR'
 )
order by table_name, constraint_name;
<file_sep>/auction/common/xml/xml-bid/target/generated-sources/jaxb/com/jdap/auction/common/xml/bid/WSAddressType.java
//
// This file was generated by the JavaTM Architecture for XML Binding(JAXB) Reference Implementation, v2.2.7 
// See <a href="http://java.sun.com/xml/jaxb">http://java.sun.com/xml/jaxb</a> 
// Any modifications to this file will be lost upon recompilation of the source schema. 
// Generated on: 2015.02.11 at 02:45:56 PM EST 
//


package com.jdap.auction.common.xml.bid;

import javax.xml.bind.annotation.XmlAccessType;
import javax.xml.bind.annotation.XmlAccessorType;
import javax.xml.bind.annotation.XmlElement;
import javax.xml.bind.annotation.XmlType;


/**
 * <p>Java class for WSAddressType complex type.
 * 
 * <p>The following schema fragment specifies the expected content contained within this class.
 * 
 * <pre>
 * &lt;complexType name="WSAddressType">
 *   &lt;complexContent>
 *     &lt;restriction base="{http://www.w3.org/2001/XMLSchema}anyType">
 *       &lt;sequence>
 *         &lt;element ref="{http://www.w3.org/2005/08/addressing}From" minOccurs="0"/>
 *         &lt;element ref="{http://www.w3.org/2005/08/addressing}To" minOccurs="0"/>
 *         &lt;element ref="{http://www.w3.org/2005/08/addressing}ReplyTo" minOccurs="0"/>
 *         &lt;element ref="{http://www.w3.org/2005/08/addressing}FaultTo" minOccurs="0"/>
 *       &lt;/sequence>
 *     &lt;/restriction>
 *   &lt;/complexContent>
 * &lt;/complexType>
 * </pre>
 * 
 * 
 */
@XmlAccessorType(XmlAccessType.FIELD)
@XmlType(name = "WSAddressType", namespace = "http://xmlns.jdap.com/Common/MessageHeader/v2", propOrder = {
    "from",
    "to",
    "replyTo",
    "faultTo"
})
public class WSAddressType {

    @XmlElement(name = "From", namespace = "http://www.w3.org/2005/08/addressing")
    protected EndpointReferenceType from;
    @XmlElement(name = "To", namespace = "http://www.w3.org/2005/08/addressing")
    protected AttributedURIType to;
    @XmlElement(name = "ReplyTo", namespace = "http://www.w3.org/2005/08/addressing")
    protected EndpointReferenceType replyTo;
    @XmlElement(name = "FaultTo", namespace = "http://www.w3.org/2005/08/addressing")
    protected EndpointReferenceType faultTo;

    /**
     * Gets the value of the from property.
     * 
     * @return
     *     possible object is
     *     {@link EndpointReferenceType }
     *     
     */
    public EndpointReferenceType getFrom() {
        return from;
    }

    /**
     * Sets the value of the from property.
     * 
     * @param value
     *     allowed object is
     *     {@link EndpointReferenceType }
     *     
     */
    public void setFrom(EndpointReferenceType value) {
        this.from = value;
    }

    /**
     * Gets the value of the to property.
     * 
     * @return
     *     possible object is
     *     {@link AttributedURIType }
     *     
     */
    public AttributedURIType getTo() {
        return to;
    }

    /**
     * Sets the value of the to property.
     * 
     * @param value
     *     allowed object is
     *     {@link AttributedURIType }
     *     
     */
    public void setTo(AttributedURIType value) {
        this.to = value;
    }

    /**
     * Gets the value of the replyTo property.
     * 
     * @return
     *     possible object is
     *     {@link EndpointReferenceType }
     *     
     */
    public EndpointReferenceType getReplyTo() {
        return replyTo;
    }

    /**
     * Sets the value of the replyTo property.
     * 
     * @param value
     *     allowed object is
     *     {@link EndpointReferenceType }
     *     
     */
    public void setReplyTo(EndpointReferenceType value) {
        this.replyTo = value;
    }

    /**
     * Gets the value of the faultTo property.
     * 
     * @return
     *     possible object is
     *     {@link EndpointReferenceType }
     *     
     */
    public EndpointReferenceType getFaultTo() {
        return faultTo;
    }

    /**
     * Sets the value of the faultTo property.
     * 
     * @param value
     *     allowed object is
     *     {@link EndpointReferenceType }
     *     
     */
    public void setFaultTo(EndpointReferenceType value) {
        this.faultTo = value;
    }

}
<file_sep>/auction/sql/Worksheet 4.sql
select * from item order by 2 desc;
select * from category;
select * from item_category ic ;
where ic.categoryid = any ('851e69f9-b43c-4ebd-b96d-ed7e5d69b8bf', '61b646b8-8258-4e09-b9bc-14ab83c1a44b')
  and ic.itemid = any ('8123fde8-4b42-43eb-a35d-0bbdb55ee655');
<file_sep>/auction/domain-module/model/src/main/java/com/jdap/auction/model/BillingInfo.java
package com.jdap.auction.model;

//~--- non-JDK imports ---------------------------------------------------------

import com.jdap.auction.patterns.persistence.AbstractPersistentObject;

//~--- JDK imports -------------------------------------------------------------

import java.sql.Date;

import javax.persistence.Entity;
import javax.persistence.OneToOne;


/**
 * Class description
 *
 *
 * @version        9.0, 2013.February.27 11:22 AM
 * @author         JDAP Corporation    
 */


@Entity
public class BillingInfo extends AbstractPersistentObject
{
    /** Field description */
    private String creditCardType;

    /** Field description */
    private String creditCardNamber;

    /** Field description */
    private String nameOnCreditCard;

    /** Field description */
    private Date creditCardExpiration;

    /** Field description */
    private String bankAccountNumber;

    /** Field description */
    private String bankName;

    /** Field description */
    private String routingNumber;

    /** Field description */
    @OneToOne( mappedBy = "billingInfo", optional = false )
    private User user;

    /**
     * Method description
     *
     *
     * @return
     */
    public String getCreditCardType()
    {
        return creditCardType;
    }

    /**
     * Method description
     *
     *
     * @param creditCardType
     */
    public void setCreditCardType( String creditCardType )
    {
        this.creditCardType = creditCardType;
    }

    /**
     * Method description
     *
     *
     * @return
     */
    public String getCreditCardNamber()
    {
        return creditCardNamber;
    }

    /**
     * Method description
     *
     *
     * @param creditCardNamber
     */
    public void setCreditCardNamber( String creditCardNamber )
    {
        this.creditCardNamber = creditCardNamber;
    }

    /**
     * Method description
     *
     *
     * @return
     */
    public String getNameOnCreditCard()
    {
        return nameOnCreditCard;
    }

    /**
     * Method description
     *
     *
     * @param nameOnCreditCard
     */
    public void setNameOnCreditCard( String nameOnCreditCard )
    {
        this.nameOnCreditCard = nameOnCreditCard;
    }

    /**
     * Method description
     *
     *
     * @return
     */
    public Date getCreditCardExpiration()
    {
        return creditCardExpiration;
    }

    /**
     * Method description
     *
     *
     * @param creditCardExpiration
     */
    public void setCreditCardExpiration( Date creditCardExpiration )
    {
        this.creditCardExpiration = creditCardExpiration;
    }

    /**
     * Method description
     *
     *
     * @return
     */
    public String getBankAccountNumber()
    {
        return bankAccountNumber;
    }

    /**
     * Method description
     *
     *
     * @param bankAccountNumber
     */
    public void setBankAccountNumber( String bankAccountNumber )
    {
        this.bankAccountNumber = bankAccountNumber;
    }

    /**
     * Method description
     *
     *
     * @return
     */
    public String getBankName()
    {
        return bankName;
    }

    /**
     * Method description
     *
     *
     * @param bankName
     */
    public void setBankName( String bankName )
    {
        this.bankName = bankName;
    }

    /**
     * Method description
     *
     *
     * @return
     */
    public String getRoutingNumber()
    {
        return routingNumber;
    }

    /**
     * Method description
     *
     *
     * @param routingNumber
     */
    public void setRoutingNumber( String routingNumber )
    {
        this.routingNumber = routingNumber;
    }

    /**
     * Method description
     *
     *
     * @return
     */
    public User getUser()
    {
        return user;
    }

    /**
     * Method description
     *
     *
     * @param user
     */
    public void setUser( User user )
    {
        this.user = user;
    }
}
<file_sep>/auction/sql/Worksheet0 1.sql
select * from item;
select * from category;
select * from item_categorie;

delete from item_categorie;
delete from item;
delete from category;
<file_sep>/auction/common/xml/xml-fault/pom.xml
<?xml version="1.0"?>
<project
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"
	xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
	<modelVersion>4.0.0</modelVersion>
	<parent>
		<artifactId>common-xml</artifactId>
		<groupId>com.jdap.auction.common.xml</groupId>
		<version>0.0.1-SNAPSHOT</version>
	</parent>


	<groupId>com.jdap.auction.common.xml</groupId>
	<artifactId>xml-fault</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<name>xml-fault</name>
	<packaging>jar</packaging>

	<dependencies>
		<dependency>
			<groupId>javax.xml.bind</groupId>
			<artifactId>jaxb-api</artifactId>
			<version>2.2.5</version>
			<scope>provided</scope>
		</dependency>

		<dependency>
			<groupId>com.sun.xml.bind</groupId>
			<artifactId>jaxb-impl</artifactId>
			<version>2.2.5</version>
			<scope>provided</scope>
		</dependency>


	</dependencies>

	<build>
		<plugins>
			<plugin>
				<groupId>org.codehaus.mojo</groupId>
				<artifactId>jaxb2-maven-plugin</artifactId>
				<executions>

					<execution>
					<!-- 	<id>template</id> -->
						<goals>
							<goal>xjc</goal>
						</goals>
						<configuration>
							<schemaDirectory>../SOAMetaData/Components/EnterpriseObjectLibrary/Common/Fault/v2</schemaDirectory>
							<includes>
								<include>ApiFault-v2.xsd</include>
							</includes>
							<packageName>com.jdap.auction.common.xml.fault</packageName>
							<xmlschema>true</xmlschema>
							<explicitAnnotation>true</explicitAnnotation>
							<extension>true</extension>
							<arguments>-Xifins</arguments>
						</configuration>
					</execution>

				</executions>
				<dependencies>
					<dependency>
						<groupId>com.sun.jaxb.commons</groupId>
						<artifactId>interface-insert</artifactId>
						<version>${jaxb.commons.interface.insert.version}</version>
					</dependency>
				</dependencies>


			</plugin>

			<plugin>
				<groupId>com.springsource.bundlor</groupId>
				<artifactId>com.springsource.bundlor.maven</artifactId>
				<version>${spring-bundlor-version}</version>
				<executions>
					<execution>
						<id>bundlor</id>
						<goals>
							<goal>bundlor</goal>
						</goals>
					</execution>
				</executions>
				<dependencies>
					<dependency>
						<groupId>asm</groupId>
						<artifactId>asm-all</artifactId>
						<version>3.1</version>
					</dependency>
				</dependencies>
			</plugin>
			<plugin>
				<groupId>org.apache.maven.plugins</groupId>
				<artifactId>maven-jar-plugin</artifactId>

				<configuration>
					<archive>
						<manifestFile>target/classes/META-INF/MANIFEST.MF</manifestFile>
					</archive>
				</configuration>

			</plugin>

		</plugins>
	</build>


</project>

