com.ibm.commerce.fulfillment.objects
Class InventoryAccessBean

java.lang.Object
  com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
      com.ibm.commerce.fulfillment.objects.InventoryAccessBean
All Implemented Interfaces:
InventoryAccessBeanData

public class InventoryAccessBean
extends com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
implements InventoryAccessBeanData

The inventory table. Each row of this table contains a quantity amount representing the inventory for a particular CatalogEntry available to be shipped from a FulfillmentCenter on behalf of a Store. This table cannot be used in conjunction with Available To Promise (ATP) inventory allocation. It is used only when ATP inventory is not enabled (refer to the ALLOCATIONGOODFOR column of the STORE table), and is used by the default implementations of the non-ATP inventory task commands: ResolveFullmentCenterCmd, CheckInventoryCmd, UpdateInventoryCmd, and ReverseUpdateInventoryCmd. This access bean corresponds to the database table 'INVENTORY'.

See Also:
Serialized Form

Constructor Summary
InventoryAccessBean()
Zero argument constructor used to initialize the access bean.
InventoryAccessBean(javax.ejb.EJBObject o)
constructor
InventoryAccessBean(java.lang.Long argCatalogEntryReferenceNumber, java.lang.Integer argFfmCenterId, java.lang.Integer argStoreId)
Creates an access bean with the specified attributes.
Method Summary
void commitCopyHelper()
Update(flush) data to the EJBObject (persistent storage).
protected java.lang.String defaultJNDIName()
InventoryAccessBean findByCatalogEntryAndFulfillmentCenterAndStore(java.lang.Long catalogEntryId, java.lang.Integer fulfillmentCenterId, java.lang.Integer storeId)
Retrieves the InventoryAccessBean representing the specified CatalogEntry in the context of a FulfillmentCenter and a Store, for update.
The SQL query used to fetch the requested row from the INVENTORY table is:
SELECT * FROM INVENTORY T1 WHERE T1.CATENTRY_ID = ? and T1.FFMCENTER_ID = ? and T1.STORE_ID = ? FOR UPDATE
java.util.Enumeration findByMultipleCatalogEntryAndFulfillmentCenterAndStore(java.lang.Long[] catalogEntryIds, java.lang.Integer[] fulfillmentCenterIds, java.lang.Integer[] storeIds)
findByMultipleCatalogEntryAndFulfillmentCenterAndStore
java.util.Enumeration findByMultipleCatalogEntryAndFulfillmentCenterAndStoreForUpdate(java.lang.Long[] catalogEntryIds, java.lang.Integer[] fulfillmentCenterIds, java.lang.Integer[] storeIds)
findByMultipleCatalogEntryAndFulfillmentCenterAndStoreForUpdate
java.util.Enumeration findByOrderItemsAndStore(java.util.Vector orderItems, java.lang.Integer storeId)
Retrieves the InventoryAccessBeans referenced by the specified Vector of OrderItemAccessBeans in the context of the a Store, for update.
The SQL query used to fetch all the required rows from the INVENTORY table is: SELECT * FROM INVENTORY T1 WHERE T1.STORE_ID = ? AND ((T1.CATENTRY_ID = ? AND T1.FFMCENTER_ID = ?) OR ...) FOR UPDATE
java.util.Enumeration findWithPushDownQuery(java.lang.String pushDownQuery)
java.lang.String getCatalogEntryId()
This method provides access to the INVENTORY.CATENTRY_ID column of DB2 type BIGINT NOT NULL.
java.lang.Long getCatalogEntryIdInEJBType()
This method provides access to the INVENTORY.CATENTRY_ID column of DB2 type BIGINT NOT NULL.
java.lang.String getFulfillmentCenterId()
This method provides access to the INVENTORY.FFMCENTER_ID column of DB2 type INTEGER NOT NULL.
java.lang.Integer getFulfillmentCenterIdInEJBType()
This method provides access to the INVENTORY.FFMCENTER_ID column of DB2 type INTEGER NOT NULL.
java.lang.String getInventoryFlags()
This method provides access to the INVENTORY.INVENTORYFLAGS column of DB2 type INTEGER NOT NULL DEFAULT 0.
java.lang.Integer getInventoryFlagsInEJBType()
This method provides access to the INVENTORY.INVENTORYFLAGS column of DB2 type INTEGER NOT NULL DEFAULT 0.
java.lang.String getQuantity()
This method provides access to the INVENTORY.QUANTITY column of DB2 type FLOAT NOT NULL DEFAULT 0.
java.lang.Double getQuantityInEJBType()
This method provides access to the INVENTORY.QUANTITY column of DB2 type FLOAT NOT NULL DEFAULT 0.
java.lang.String getQuantityMeasure()
This method provides access to the INVENTORY.QUANTITYMEASURE column of DB2 type CHAR(16) NOT NULL DEFAULT 'C62'.
java.lang.String getStoreId()
This method provides access to the INVENTORY.STORE_ID column of DB2 type INTEGER NOT NULL.
java.lang.Integer getStoreIdInEJBType()
This method provides access to the INVENTORY.STORE_ID column of DB2 type INTEGER NOT NULL.
protected void instantiateEJB()
protected boolean instantiateEJBByPrimaryKey()
void refreshCopyHelper()
Load data from the EJBObject.
void setInitKey_catalogEntryId(java.lang.String newValue)
Set the primary key for this object
void setInitKey_fulfillmentCenterId(java.lang.String newValue)
Set the primary key for this object
void setInitKey_storeId(java.lang.String newValue)
Set the primary key for this object
void setInventoryFlags(java.lang.Integer newValue)
This method accesses a non-CMP field
void setInventoryFlags(java.lang.String newValue)
This method accesses a non-CMP field
void setQuantity(java.lang.Double newValue)
This method accesses a non-CMP field
void setQuantity(java.lang.String newValue)
This method accesses a non-CMP field
void setQuantityMeasure(java.lang.String newValue)
This method accesses a non-CMP field
void setStoreId(java.lang.Integer newValue)
This method accesses a non-CMP field
void setStoreId(java.lang.String newValue)
This method accesses a non-CMP field
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

InventoryAccessBean

public InventoryAccessBean()
Zero argument constructor used to initialize the access bean. This constructor corresponds to the following home interface method: public abstract com.ibm.commerce.fulfillment.objects.Inventory com.ibm.commerce.fulfillment.objimpl.InventoryHomeBase.findByPrimaryKey(com.ibm.commerce.fulfillment.objects.InventoryKey) throws java.rmi.RemoteException,javax.ejb.FinderException The home interface method properties need to be set by calling the following setter methods before calling any business methods: setInitKey_catalogEntryId( java.lang.Long ) setInitKey_fulfillmentCenterId( java.lang.Integer ) setInitKey_storeId( java.lang.Integer )

InventoryAccessBean

public InventoryAccessBean(javax.ejb.EJBObject o)
                    throws java.rmi.RemoteException
constructor
Parameters:
o - javax.ejb.EJBObject
Throws:
java.rmi.RemoteException

InventoryAccessBean

public InventoryAccessBean(java.lang.Long argCatalogEntryReferenceNumber,
                           java.lang.Integer argFfmCenterId,
                           java.lang.Integer argStoreId)
                    throws javax.ejb.CreateException,
                           java.rmi.RemoteException,
                           javax.naming.NamingException

Creates an access bean with the specified attributes.

Parameters:
argCatalogEntryReferenceNumber - the CatalogEntry ID
argFfmCenterId - the FulfillmentCenter ID
argStoreId - the Store ID
Throws:
javax.ejb.CreateException - The javax.ejb.CreateException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.naming.NamingException - The javax.naming.NamingException exception
Method Detail

findByCatalogEntryAndFulfillmentCenterAndStore

public InventoryAccessBean findByCatalogEntryAndFulfillmentCenterAndStore(java.lang.Long catalogEntryId,
                                                                          java.lang.Integer fulfillmentCenterId,
                                                                          java.lang.Integer storeId)
                                                                   throws java.rmi.RemoteException,
                                                                          javax.ejb.FinderException,
                                                                          javax.naming.NamingException

Retrieves the InventoryAccessBean representing the specified CatalogEntry in the context of a FulfillmentCenter and a Store, for update.
The SQL query used to fetch the requested row from the INVENTORY table is:
SELECT * FROM INVENTORY T1 WHERE T1.CATENTRY_ID = ? and T1.FFMCENTER_ID = ? and T1.STORE_ID = ? FOR UPDATE

Parameters:
catalogEntryId - the CatalogEntry ID
fulfillmentCenterId - the FulfillmentCenter ID
storeId - the Store ID
Returns:
The InventoryAccessBean representing the row that matches the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

findByOrderItemsAndStore

public java.util.Enumeration findByOrderItemsAndStore(java.util.Vector orderItems,
                                                      java.lang.Integer storeId)
                                               throws java.rmi.RemoteException,
                                                      javax.ejb.FinderException,
                                                      javax.naming.NamingException

Retrieves the InventoryAccessBeans referenced by the specified Vector of OrderItemAccessBeans in the context of the a Store, for update.
The SQL query used to fetch all the required rows from the
INVENTORY table is: SELECT * FROM INVENTORY T1 WHERE T1.STORE_ID = ? AND ((T1.CATENTRY_ID = ? AND T1.FFMCENTER_ID = ?) OR ...) FOR UPDATE

Parameters:
orderItems - a Vector of OrderItemAccessBeans
storeId - the Store ID
Returns:
An Enumeration of all the InventoryAccessBeans representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

setInitKey_catalogEntryId

public void setInitKey_catalogEntryId(java.lang.String newValue)

Set the primary key for this object

Parameters:
newValue - java.lang.String
Returns:
void

setInitKey_fulfillmentCenterId

public void setInitKey_fulfillmentCenterId(java.lang.String newValue)

Set the primary key for this object

Parameters:
newValue - java.lang.String
Returns:
void

setInitKey_storeId

public void setInitKey_storeId(java.lang.String newValue)

Set the primary key for this object

Parameters:
newValue - java.lang.String
Returns:
void

defaultJNDIName

protected java.lang.String defaultJNDIName()
Returns:
String

instantiateEJB

protected void instantiateEJB()
                       throws java.rmi.RemoteException,
                              javax.ejb.FinderException,
                              javax.naming.NamingException
Returns:
void
Throws:
java.rmi.RemoteException
javax.ejb.FinderException
javax.naming.NamingException

instantiateEJBByPrimaryKey

protected boolean instantiateEJBByPrimaryKey()
                                      throws java.rmi.RemoteException,
                                             javax.ejb.CreateException,
                                             javax.naming.NamingException
Returns:
boolean
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.naming.NamingException

commitCopyHelper

public void commitCopyHelper()
                      throws java.rmi.RemoteException,
                             javax.ejb.CreateException,
                             javax.ejb.FinderException,
                             javax.naming.NamingException

Update(flush) data to the EJBObject (persistent storage).

Returns:
void
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

refreshCopyHelper

public void refreshCopyHelper()
                       throws java.rmi.RemoteException,
                              javax.ejb.CreateException,
                              javax.ejb.FinderException,
                              javax.naming.NamingException

Load data from the EJBObject.

Returns:
void
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getQuantity

public java.lang.String getQuantity()
                             throws java.rmi.RemoteException,
                                    javax.ejb.CreateException,
                                    javax.ejb.FinderException,
                                    javax.naming.NamingException

This method provides access to the INVENTORY.QUANTITY column of DB2 type FLOAT NOT NULL DEFAULT 0.

The following is a description of this column:

The quantity amount, in units indicated by QUANTITYMEASURE.

Specified by:
getQuantity in interface InventoryAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getQuantityInEJBType

public java.lang.Double getQuantityInEJBType()
                                      throws java.rmi.RemoteException,
                                             javax.ejb.CreateException,
                                             javax.ejb.FinderException,
                                             javax.naming.NamingException

This method provides access to the INVENTORY.QUANTITY column of DB2 type FLOAT NOT NULL DEFAULT 0.

The following is a description of this column:

The quantity amount, in units indicated by QUANTITYMEASURE.

Returns:
java.lang.Double
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setQuantity

public void setQuantity(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setQuantity in interface InventoryAccessBeanData

setQuantity

public void setQuantity(java.lang.Double newValue)
This method accesses a non-CMP field

getInventoryFlags

public java.lang.String getInventoryFlags()
                                   throws java.rmi.RemoteException,
                                          javax.ejb.CreateException,
                                          javax.ejb.FinderException,
                                          javax.naming.NamingException

This method provides access to the INVENTORY.INVENTORYFLAGS column of DB2 type INTEGER NOT NULL DEFAULT 0.

The following is a description of this column:

Bit flags, from low to high order, indicating how QUANTITY is used:&l

Specified by:
getInventoryFlags in interface InventoryAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getInventoryFlagsInEJBType

public java.lang.Integer getInventoryFlagsInEJBType()
                                             throws java.rmi.RemoteException,
                                                    javax.ejb.CreateException,
                                                    javax.ejb.FinderException,
                                                    javax.naming.NamingException

This method provides access to the INVENTORY.INVENTORYFLAGS column of DB2 type INTEGER NOT NULL DEFAULT 0.

The following is a description of this column:

Bit flags, from low to high order, indicating how QUANTITY is used:&l

Returns:
java.lang.Integer
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setInventoryFlags

public void setInventoryFlags(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setInventoryFlags in interface InventoryAccessBeanData

setInventoryFlags

public void setInventoryFlags(java.lang.Integer newValue)
This method accesses a non-CMP field

getCatalogEntryId

public java.lang.String getCatalogEntryId()
                                   throws java.rmi.RemoteException,
                                          javax.ejb.CreateException,
                                          javax.ejb.FinderException,
                                          javax.naming.NamingException

This method provides access to the INVENTORY.CATENTRY_ID column of DB2 type BIGINT NOT NULL.

The following is a description of this column:

The CatalogEntry.

Specified by:
getCatalogEntryId in interface InventoryAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getCatalogEntryIdInEJBType

public java.lang.Long getCatalogEntryIdInEJBType()
                                          throws java.rmi.RemoteException,
                                                 javax.ejb.CreateException,
                                                 javax.ejb.FinderException,
                                                 javax.naming.NamingException

This method provides access to the INVENTORY.CATENTRY_ID column of DB2 type BIGINT NOT NULL.

The following is a description of this column:

The CatalogEntry.

Returns:
java.lang.Long
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getStoreId

public java.lang.String getStoreId()
                            throws java.rmi.RemoteException,
                                   javax.ejb.CreateException,
                                   javax.ejb.FinderException,
                                   javax.naming.NamingException

This method provides access to the INVENTORY.STORE_ID column of DB2 type INTEGER NOT NULL.

The following is a description of this column:

The Store.

Specified by:
getStoreId in interface InventoryAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getStoreIdInEJBType

public java.lang.Integer getStoreIdInEJBType()
                                      throws java.rmi.RemoteException,
                                             javax.ejb.CreateException,
                                             javax.ejb.FinderException,
                                             javax.naming.NamingException

This method provides access to the INVENTORY.STORE_ID column of DB2 type INTEGER NOT NULL.

The following is a description of this column:

The Store.

Returns:
java.lang.Integer
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setStoreId

public void setStoreId(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setStoreId in interface InventoryAccessBeanData

setStoreId

public void setStoreId(java.lang.Integer newValue)
This method accesses a non-CMP field

getQuantityMeasure

public java.lang.String getQuantityMeasure()
                                    throws java.rmi.RemoteException,
                                           javax.ejb.CreateException,
                                           javax.ejb.FinderException,
                                           javax.naming.NamingException

This method provides access to the INVENTORY.QUANTITYMEASURE column of DB2 type CHAR(16) NOT NULL DEFAULT 'C62'.

The following is a description of this column:

The unit of measurement for QUANTITY.

Specified by:
getQuantityMeasure in interface InventoryAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setQuantityMeasure

public void setQuantityMeasure(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setQuantityMeasure in interface InventoryAccessBeanData

getFulfillmentCenterId

public java.lang.String getFulfillmentCenterId()
                                        throws java.rmi.RemoteException,
                                               javax.ejb.CreateException,
                                               javax.ejb.FinderException,
                                               javax.naming.NamingException

This method provides access to the INVENTORY.FFMCENTER_ID column of DB2 type INTEGER NOT NULL.

The following is a description of this column:

The FulfillmentCenter.

Specified by:
getFulfillmentCenterId in interface InventoryAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getFulfillmentCenterIdInEJBType

public java.lang.Integer getFulfillmentCenterIdInEJBType()
                                                  throws java.rmi.RemoteException,
                                                         javax.ejb.CreateException,
                                                         javax.ejb.FinderException,
                                                         javax.naming.NamingException

This method provides access to the INVENTORY.FFMCENTER_ID column of DB2 type INTEGER NOT NULL.

The following is a description of this column:

The FulfillmentCenter.

Returns:
java.lang.Integer
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

findWithPushDownQuery

public java.util.Enumeration findWithPushDownQuery(java.lang.String pushDownQuery)
                                            throws javax.naming.NamingException,
                                                   javax.ejb.FinderException,
                                                   java.rmi.RemoteException
Parameters:
pushDownQuery - the push-down query
Returns:
java.util.Enumeration
Throws:
java.rmi.RemoteException
javax.ejb.FinderException
javax.naming.NamingException

findByMultipleCatalogEntryAndFulfillmentCenterAndStore

public java.util.Enumeration findByMultipleCatalogEntryAndFulfillmentCenterAndStore(java.lang.Long[] catalogEntryIds,
                                                                                    java.lang.Integer[] fulfillmentCenterIds,
                                                                                    java.lang.Integer[] storeIds)
                                                                             throws javax.naming.NamingException,
                                                                                    javax.ejb.FinderException,
                                                                                    java.rmi.RemoteException
findByMultipleCatalogEntryAndFulfillmentCenterAndStore
Parameters:
catalogEntryIds - java.lang.Long[]
fulfillmentCenterIds - java.lang.Integer[]
storeIds - java.lang.Integer[]
Returns:
java.util.Enumeration
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findByMultipleCatalogEntryAndFulfillmentCenterAndStoreForUpdate

public java.util.Enumeration findByMultipleCatalogEntryAndFulfillmentCenterAndStoreForUpdate(java.lang.Long[] catalogEntryIds,
                                                                                             java.lang.Integer[] fulfillmentCenterIds,
                                                                                             java.lang.Integer[] storeIds)
                                                                                      throws javax.naming.NamingException,
                                                                                             javax.ejb.FinderException,
                                                                                             java.rmi.RemoteException
findByMultipleCatalogEntryAndFulfillmentCenterAndStoreForUpdate
Parameters:
catalogEntryIds - java.lang.Long[]
fulfillmentCenterIds - java.lang.Integer[]
storeIds - java.lang.Integer[]
Returns:
java.util.Enumeration
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

Feedback