You have an error in your SQL syntax

import java.math.BigDecimal;

import java.util.ArrayList;

import java.util.Collection;

import java.util.Iterator;

import java.util.Random;

import javax.ejb.EntityContext;

import javax.naming.NamingException;

/**

protected EntityContext eContext;
private ServiceLocator locator;

/**
 * @ejb.interface-method
 *	view-type="local" 
**/
public boolean checkPassword ( String password )throws InvalidPasswordException{ 
	LOGGER.debug("Entering CustomerBean.checkPassword()");
	if (password.equals(getPassword())){
	   LOGGER.debug("Entering CustomerBean.checkPassword()");
	   return true;}
	throw new InvalidPasswordException("Invalid Password");
    }
   

/**
 * @ejb.interface-method
 *	view-type="local" 
 * Executa update de dados no banco de dados
 * @param CustomerTO com os daos atualizados
 * @throws InvalidPasswordException
**/
 public void update(CustomerTO customer, String oldPassword) throws InvalidPasswordException{
	LOGGER.debug("Entering CustomerCMPBean.update()");
	try{
	  this.checkPassword(oldPassword);
	  setName(customer.getName())  ;
	  setPassword(customer.getPassword());
     
   }catch(Exception e){
	LOGGER.debug("UpdateFailed cause : " + e);
	if(e instanceof InvalidPasswordException )
	throw new InvalidPasswordException("UpdateFailed cause :  Invalid password");
			
	}
   finally{
   LOGGER.debug("Leaving CustomerCMPBean.update()");
  } 
}

private static final Logger LOGGER =Logger.getLogger(CustomercmpBean.class);
/**
 * The  ejbCreate method.
 * 
 * @ejb.create-method 
 */
public java.lang.String ejbCreate(CustomerTO customer) throws javax.ejb.CreateException {
	
	LOGGER.debug("Entering CustomercmpCMPBean ejbCreate()");
	this.setName(customer.getName());
	this.setUsername(customer.getUsername());
	this.setPassword(customer.getPassword());
	LOGGER.debug("Leaving CustomercmpCMPBean ejbCreate()"); 
	return null;
}

/**
 * The container invokes this method immediately after it calls ejbCreate.
 * 
 */
public void ejbPostCreate() throws javax.ejb.CreateException {
}

/**
* Returns the username
* @return the username
* 
* @ejb.persistent-field 
* @ejb.persistence
*    column-name="USERNAME"
*     sql-type="VARCHAR"
* @ejb.pk-field 
* @ejb.interface-method
* 
* --
* This is needed for JOnAS.
* If you are not using JOnAS you can safely remove the tags below.
* @jonas.cmp-field-jdbc-mapping  field-name="username"
*	jdbc-field-name="USERNAME"
* 
--
*/
public abstract java.lang.String getUsername();

/**
* Sets the username
* 
* @param java.lang.String the new username value
* 
* @ejb.interface-method
*/
public abstract void setUsername(java.lang.String username);

/**
* Returns the name
* @return the name
* 
* @ejb.persistent-field 
* @ejb.persistence
*    column-name="NAME"
*     sql-type="VARCHAR"
*  
* @ejb.interface-method
* 
* --
* This is needed for JOnAS.
* If you are not using JOnAS you can safely remove the tags below.
* @jonas.cmp-field-jdbc-mapping  field-name="name"
*	jdbc-field-name="NAME"
* 
--
*/
public abstract java.lang.String getName();

/**
* Sets the name
* 
* @param java.lang.String the new name value
* 
* @ejb.interface-method
*/
public abstract void setName(java.lang.String name);

/**
* Returns the password
* @return the password
* 
* @ejb.persistent-field 
* @ejb.persistence
*    column-name="PASSWORD"
*     sql-type="VARCHAR"
*  
* @ejb.interface-method
* 
* --
* This is needed for JOnAS.
* If you are not using JOnAS you can safely remove the tags below.
* @jonas.cmp-field-jdbc-mapping  field-name="password"
*	jdbc-field-name="PASSWORD"
* 
--
*/
public abstract java.lang.String getPassword();

/**
* Sets the password
* 
* @param java.lang.String the new password value
* 
* @ejb.interface-method
*/
public abstract void setPassword(java.lang.String password);

/**
 * @ejb.interface-method
 * tview-type="local"
 * @return CustomerTO
 */
public CustomerTO getCustomerData(){
	LOGGER.debug("Entering CustomerCMPBean.getData()");
	LOGGER.debug("Leaving CustomerCMPBean.getData()");
	return new CustomerTO(getName(), getUsername(), getPassword());
}
/**
 * Sets the entity context
 */
public void setEntityContext(EntityContext context){
	eContext = context;
}
/**
 * Unset the entity context
 */
public void unsetEntityContext(){
	eContext = null;
}

public abstract Collection getOrder();

public abstract void setOrder(Collection newOrder);

import java.math.BigDecimal;

import java.util.Collection;

import java.util.Random;

import javax.ejb.CreateException;

import javax.ejb.EntityBean;

import javax.naming.NamingException;

public abstract class OrderBean implements EntityBean {

ServiceLocator locator = null;

/**

* The  ejbCreate method.

*

* @ejb.create-method

*/

public String ejbCreate() throws javax.ejb.CreateException {

// EJB 2.0 spec says return null for CMP ejbCreate methods.

// TODO: YOU MUST INITIALIZE THE FIELDS FOR THE BEAN HERE.

// setMyField(“Something”);

return null;

}

/**
 * The container invokes this method immediately after it calls ejbCreate.
 * 
 */
public void ejbPostCreate() throws javax.ejb.CreateException {
}

/**
* Returns the orderId
* @return the orderId
* 
* @ejb.persistent-field 
* @ejb.persistence
*    column-name="orderId"
*     sql-type="decimal"
* @ejb.pk-field 
* @ejb.interface-method
* 
* --
* This is needed for JOnAS.
* If you are not using JOnAS you can safely remove the tags below.
* @jonas.cmp-field-jdbc-mapping  field-name="orderId"
*	jdbc-field-name="orderId"
* 
--
*/
public abstract String getUsername();

/**
* Sets the orderId
* 
* @param java.math.BigDecimal the new orderId value
* 
* @ejb.interface-method
*/
public abstract void setUsername(String username);

/**
* Returns the orderDate
* @return the orderDate
* 
* @ejb.persistent-field 
* @ejb.persistence
*    column-name="orderDate"
*     sql-type="varchar"
*  
* @ejb.interface-method
* 
* --
* This is needed for JOnAS.
* If you are not using JOnAS you can safely remove the tags below.
* @jonas.cmp-field-jdbc-mapping  field-name="orderDate"
*	jdbc-field-name="orderDate"
* 
--
*/
public abstract java.lang.String getOrderDate();

/**
* Sets the orderDate
* 
* @param java.lang.String the new orderDate value
* 
* @ejb.interface-method
*/
public abstract void setOrderDate(java.lang.String orderDate);

/**
* Returns the adress
* @return the adress
* 
* @ejb.persistent-field 
* @ejb.persistence
*    column-name="adress"
*     sql-type="varchar"
*  
* @ejb.interface-method
* 
* --
* This is needed for JOnAS.
* If you are not using JOnAS you can safely remove the tags below.
* @jonas.cmp-field-jdbc-mapping  field-name="adress"
*	jdbc-field-name="adress"
* 
--
*/
public abstract java.lang.String getAdress();

/**
* Sets the adress
* 
* @param java.lang.String the new adress value
* 
* @ejb.interface-method
*/
public abstract void setAdress(java.lang.String adress);

public abstract Collection getOrderItem();

public abstract void setOrderItem (Collection newOrderItem);

public void myOrderItem() throws NamingException, CreateException{
	if (locator == null){
		locator = ServiceLocator.getLocator();
		}
	OrderItemLocalHome getHome = (OrderItemLocalHome) locator.getLocalService(OrderItemLocalHome.JNDI_NAME);
	OrderItemLocal orderItem = getHome.create();
	Random random = new Random();
	BigDecimal id = new BigDecimal(random.nextInt(100));
	orderItem.setOrderItemId(id);
	Collection collection = null;
	collection = this.getOrderItem();
	collection.add(orderItem);
	this.setOrderItem(collection);
}