|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--com.ibm.ivj.ejb.runtime.AbstractAccessBean | +--com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean | +--com.ibm.commerce.catalog.objects.RelatedCatalogEntryAccessBean
This bean provides access to the MASSOCCECE table.
The following is a description of this table:
This table holds the merchandising associations that exist between CatalogEntries.
Fields inherited from class com.ibm.ivj.ejb.runtime.AbstractAccessBean |
DEFAULT_NAMESERVICE_PROVIDER_URL, DEFAULT_NAMESERVICE_TYPE, ejbRef |
Constructor Summary | |
RelatedCatalogEntryAccessBean()
Default constructor. |
|
RelatedCatalogEntryAccessBean(javax.ejb.EJBObject relCatEntryEJBObj)
Maps to a corresponding ejbCreate method in the home interface of the EJB |
|
RelatedCatalogEntryAccessBean(java.lang.String assocTypeID,
java.lang.String assocID,
java.lang.Long fromCatEntryID,
java.lang.Long toCatEntryID)
Maps to a corresponding ejbCreate method in the home interface of the EJB. |
Method Summary | |
void |
commitCopyHelper()
Update(flush) data to the EJBObject (persistent storage). |
java.util.Enumeration |
findByCatalogEntryAccessories(java.lang.Long catEntryID,
java.lang.Long[] inclusionPS,
java.lang.Long[] exclusionPS)
Finds the related catalog entry with the catalog entry accessories. |
java.util.Enumeration |
findByCatalogEntryAccessory(java.lang.Long catEntryID)
Finds the related catalog entry with the catalog entry accessories. |
java.util.Enumeration |
findByCatalogEntryAccessoryWithSemantic(java.lang.Long catEntryID,
java.lang.String semantic)
Finds the related catalog entry with the catalog entry accessories. |
java.util.Enumeration |
findByCatalogEntryCrossSell(java.lang.Long catEntryID)
Finds the related catalog entry with the catalog entry accessories. |
java.util.Enumeration |
findByCatalogEntryCrossSells(java.lang.Long catEntryID,
java.lang.Long[] inclusionPS,
java.lang.Long[] exclusionPS)
Finds the related catalog entry with the catalog entry accessories. |
java.util.Enumeration |
findByCatalogEntryCrossSellWithSemantic(java.lang.Long catEntryID,
java.lang.String semantic)
Finds the related catalog entry with the catalog entry accessories. |
java.util.Enumeration |
findByCatalogEntryUpSell(java.lang.Long catEntryID)
Finds the related catalog entry with the catalog entry accessories. |
java.util.Enumeration |
findByCatalogEntryUpSells(java.lang.Long catEntryID,
java.lang.Long[] inclusionPS,
java.lang.Long[] exclusionPS)
Finds the related catalog entry with the catalog entry accessories. |
java.util.Enumeration |
findByCatalogEntryUpSellWithSemantic(java.lang.Long catEntryID,
java.lang.String semantic)
Finds the related catalog entry with the catalog entry accessories. |
java.util.Enumeration |
findWithPushDownQuery(java.lang.String query)
Finds the related catalog entry with the specified query. |
java.lang.String |
getAssociationType()
This method provides access to the MASSOCCECE.MASSOCTYPE_ID column of DB2 type CHAR(32) NOT NULL. |
java.lang.String |
getField1()
This method provides access to the MASSOCCECE.FIELD1 column of DB2 type VARCHAR(254) NULL. |
java.lang.String |
getField2()
This method provides access to the MASSOCCECE.FIELD2 column of DB2 type INTEGER NULL. |
java.lang.Integer |
getField2InEJBType()
This method provides access to the MASSOCCECE.FIELD2 column of DB2 type INTEGER NULL. |
java.lang.String |
getField3()
This method provides access to the MASSOCCECE.FIELD3 column of DB2 type DECIMAL(20,5) NULL. |
java.math.BigDecimal |
getField3InEJBType()
This method provides access to the MASSOCCECE.FIELD3 column of DB2 type DECIMAL(20,5) NULL. |
java.lang.String |
getFromCatalogEntryReferenceNumber()
This method provides access to the MASSOCCECE.CATENTRY_ID_FROM column of DB2 type BIGINT NOT NULL. |
java.lang.Long |
getFromCatalogEntryReferenceNumberInEJBType()
This method provides access to the MASSOCCECE.CATENTRY_ID_FROM column of DB2 type BIGINT NOT NULL. |
java.lang.String |
getGroupName()
This method provides access to the MASSOCCECE.GROUPNAME column of DB2 type VARCHAR(254) NULL. |
java.lang.String |
getOid()
This method provides access to the MASSOCCECE.OID column of DB2 type VARCHAR(64) NULL. |
java.lang.String |
getQuantity()
This method provides access to the MASSOCCECE.QUANTITY column of DB2 type FLOAT NULL. |
java.lang.Double |
getQuantityInEJBType()
This method provides access to the MASSOCCECE.QUANTITY column of DB2 type FLOAT NULL. |
java.lang.String |
getRank()
This method provides access to the MASSOCCECE.RANK column of DB2 type DECIMAL(20,5) NULL. |
java.math.BigDecimal |
getRankInEJBType()
This method provides access to the MASSOCCECE.RANK column of DB2 type DECIMAL(20,5) NULL. |
CatalogEntryAccessBean |
getRelatedCatalogEntry()
This method provides access to the MASSOCCECE.MASSOCTYPE_ID column of DB2 type CHAR(32) NOT NULL. |
java.lang.String |
getRule()
This method provides access to the MASSOCCECE.RULE column of DB2 type VARCHAR(254) NULL. |
java.lang.String |
getSemanticSpecifier()
This method provides access to the MASSOCCECE.MASSOC_ID column of DB2 type CHAR(32) NOT NULL. |
java.lang.String |
getToCatalogEntryReferenceNumber()
This method provides access to the MASSOCCECE.CATENTRY_ID_TO column of DB2 type BIGINT NOT NULL. |
java.lang.Long |
getToCatalogEntryReferenceNumberInEJBType()
This method provides access to the MASSOCCECE.CATENTRY_ID_TO column of DB2 type BIGINT NOT NULL. |
void |
refreshCopyHelper()
Load data from the EJBObject. |
void |
setAssociationType(java.lang.String associationType)
This method provides access to the MASSOCCECE.MASSOCTYPE_ID column of DB2 type CHAR(32) NOT NULL. |
void |
setField1(java.lang.String field1)
This method provides access to the MASSOCCECE.FIELD1 column of DB2 type VARCHAR(254) NULL. |
void |
setField2(java.lang.Integer field2)
This method provides access to the MASSOCCECE.FIELD2 column of DB2 type INTEGER NULL. |
void |
setField2(java.lang.String field2)
This method provides access to the MASSOCCECE.FIELD2 column of DB2 type INTEGER NULL. |
void |
setField3(java.math.BigDecimal field3)
This method provides access to the MASSOCCECE.FIELD3 column of DB2 type DECIMAL(20,5) NULL. |
void |
setField3(java.lang.String field3)
This method provides access to the MASSOCCECE.FIELD3 column of DB2 type DECIMAL(20,5) NULL. |
void |
setFromCatalogEntryReferenceNumber(java.lang.Long fromCatEntryID)
This method provides access to the MASSOCCECE.CATENTRY_ID_FROM column of DB2 type BIGINT NOT NULL. |
void |
setFromCatalogEntryReferenceNumber(java.lang.String fromCatEntryID)
This method provides access to the MASSOCCECE.CATENTRY_ID_FROM column of DB2 type BIGINT NOT NULL. |
void |
setGroupName(java.lang.String grpName)
This method provides access to the MASSOCCECE.GROUPNAME column of DB2 type VARCHAR(254) NULL. |
void |
setInitKey_associationReferenceNumber(java.lang.String assocID)
Set the primary key for this object |
void |
setOid(java.lang.String OID)
This method provides access to the MASSOCCECE.OID column of DB2 type VARCHAR(64) NULL. |
void |
setQuantity(java.lang.Double quantity)
This method provides access to the MASSOCCECE.QUANTITY column of DB2 type FLOAT NULL. |
void |
setQuantity(java.lang.String quantity)
This method provides access to the MASSOCCECE.QUANTITY column of DB2 type FLOAT NULL. |
void |
setRank(java.math.BigDecimal rank)
This method provides access to the MASSOCCECE.RANK column of DB2 type DECIMAL(20,5) NULL. |
void |
setRank(java.lang.String rank)
This method provides access to the MASSOCCECE.RANK column of DB2 type DECIMAL(20,5) NULL. |
void |
setRule(java.lang.String rule)
This method provides access to the MASSOCCECE.RULE column of DB2 type VARCHAR(254) NULL. |
void |
setSemanticSpecifier(java.lang.String semantic)
This method provides access to the MASSOCCECE.MASSOC_ID column of DB2 type CHAR(32) NOT NULL. |
void |
setToCatalogEntryReferenceNumber(java.lang.Long toCatEntryID)
This method provides access to the MASSOCCECE.CATENTRY_ID_TO column of DB2 type BIGINT NOT NULL. |
void |
setToCatalogEntryReferenceNumber(java.lang.String toCatEntryID)
This method provides access to the MASSOCCECE.CATENTRY_ID_TO column of DB2 type BIGINT NOT NULL. |
Methods inherited from class com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean |
__getCache, __getCache, __getKey, __setCache, __setCache, __setKey, commitCopyHelper, createAccessBeans, createAccessBeans, instantiateEJBByPrimaryKey, refreshCopyHelper, setEJBRef |
Methods inherited from class com.ibm.ivj.ejb.runtime.AbstractAccessBean |
defaultJNDIName, defaultNameServiceType, defaultNameServiceURL, getEJBRef, getGlobalHome, getHome, getInit_GlobalNameServiceTypeName, getInit_GlobalNameServiceURLName, getInit_JNDIName, getInit_NameServiceTypeName, getInit_NameServiceURLName, getInitContext, getInitContext, instantiateEJB, resetEJBRef, resetHomeCache, setInit_GlobalNameServiceTypeName, setInit_GlobalNameServiceURLName, setInit_JNDIName, setInit_NameServiceTypeName, setInit_NameServiceURLName |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
public RelatedCatalogEntryAccessBean()
Default constructor. Maps to findByPrimaryKey.
public RelatedCatalogEntryAccessBean(javax.ejb.EJBObject relCatEntryEJBObj) throws java.rmi.RemoteException
Maps to a corresponding ejbCreate method in the home interface of the EJB
relCatEntryEJBObj
- The related catalog entry EJB Object. javax.ejb.EJBObjectjava.rmi.RemoteException
- The java.rmi.RemoteException exceptionpublic RelatedCatalogEntryAccessBean(java.lang.String assocTypeID, java.lang.String assocID, java.lang.Long fromCatEntryID, java.lang.Long toCatEntryID) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, javax.ejb.FinderException
Maps to a corresponding ejbCreate method in the home interface of the EJB. Creates an access to the related catalog entry according to the association type ID, association reference number, from catalog entry ID, and to catalog entry ID.
assocTypeID
- The association type ID. java.lang.StringassocID
- The association ID. java.lang.StringfromCatEntryID
- The From catalog entry ID. java.lang.LongtoCatEntryID
- The To catalog entry ID. java.lang.Longjavax.naming.NamingException
- The javax.naming.NamingException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjava.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionMethod Detail |
public void commitCopyHelper() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
Update(flush) data to the EJBObject (persistent storage).
commitCopyHelper
in class com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic java.util.Enumeration findByCatalogEntryAccessories(java.lang.Long catEntryID, java.lang.Long[] inclusionPS, java.lang.Long[] exclusionPS) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Finds the related catalog entry with the catalog entry accessories.
SQL:
SELECT MASSOCCECE.CATENTRY_ID_TO, MASSOCCECE.QUANTITY, MASSOCCECE.MASSOCTYPE_ID, MASSOCCECE.MASSOCCECE_ID, MASSOCCECE.CATENTRY_ID_FROM, MASSOCCECE.MASSOC_ID, MASSOCCECE.RULE, MASSOCCECE.RANK, MASSOCCECE.FIELD1, MASSOCCECE.FIELD2, MASSOCCECE.FIELD3, MASSOCCECE.GROUPNAME, MASSOCCECE.OID
FROM MASSOCCECE, CATENTRY, PRSETCEREL, PRODUCTSET
WHERE CATENTRY.MARKFORDELETE = 0
AND MASSOCCECE.CATENTRY_ID_FROM = catEntryID
AND MASSOCCECE.MASSOCTYPE_ID = 'ACCESSORY'
AND PRODUCTSET.MARKFORDELETE=0
AND CATENTRY.CATENTRY_ID = MASSOCCECE.CATENTRY_ID_TO
AND MASSOCCECE.CATENTRY_ID_TO=CATENTRY.CATENTRY_ID
AND MASSOCCECE.CATENTRY_ID_TO=PRSETCEREL.CATENTRY_ID
AND PRSETCEREL.PRODUCTSET_ID = PRODUCTSET.PRODUCTSET_ID
AND PRSETCEREL.PRODUCTSET_ID IN (inclusionPS)
AND MASSOCCECE.CATENTRY_ID_TO NOT IN (SELECT CATENTRY_ID FROM PRSETCEREL WHERE PRODUCTSET_ID NOT IN (exclusionPS))
catEntryID
- The catalog entry reference number. java.lang.LonginclusionPS
- The inclusion PS. java.lang.Long[]exclusionPS
- The exclusion PS. java.lang.Long[]java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic java.util.Enumeration findByCatalogEntryAccessory(java.lang.Long catEntryID) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Finds the related catalog entry with the catalog entry accessories.
SQL:
SELECT T1.CATENTRY_ID_TO, T1.QUANTITY, T1.MASSOCTYPE_ID, T1.MASSOCCECE_ID, T1.CATENTRY_ID_FROM, T1.MASSOC_ID, T1.RULE, T1.RANK, T1.FIELD1, T1.FIELD2, T1.FIELD3, T1.GROUPNAME, T1.OID
FROM MASSOCCECE T1
WHERE CATENTRY.MARKFORDELETE = 0
AND MASSOCCECE.CATENTRY_ID_FROM = catEntryID
AND MASSOCCECE.MASSOCTYPE_ID = 'ACCESSORY'
AND CATENTRY.CATENTRY_ID = MASSOCCECE.CATENTRY_ID_TO
ORDER BY MASSOCCECE.RANK
catEntryID
- The catalog entry reference number. java.lang.Longjava.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic java.util.Enumeration findByCatalogEntryAccessoryWithSemantic(java.lang.Long catEntryID, java.lang.String semantic) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Finds the related catalog entry with the catalog entry accessories.
SQL:
SELECT MASSOCCECE.CATENTRY_ID_TO, MASSOCCECE.QUANTITY, MASSOCCECE.MASSOCTYPE_ID, MASSOCCECE.MASSOCCECE_ID, MASSOCCECE.CATENTRY_ID_FROM, MASSOCCECE.MASSOC_ID, MASSOCCECE.RULE, MASSOCCECE.RANK, MASSOCCECE.FIELD1, MASSOCCECE.FIELD2, MASSOCCECE.FIELD3, MASSOCCECE.GROUPNAME, MASSOCCECE.OID
FROM MASSOCCECE, CATENTRY
WHERE CATENTRY.MARKFORDELETE = 0
AND MASSOCCECE.CATENTRY_ID_FROM = catEntryID
AND MASSOCCECE.MASSOC_ID = semantic
AND MASSOCCECE.MASSOCTYPE_ID = 'ACCESSORY'
AND CATENTRY.CATENTRY_ID = MASSOCCECE.CATENTRY_ID_TO
ORDER BY MASSOCCECE.RANK
catEntryID
- The catalog entry reference number. java.lang.Longsemantic
- The semantic specifier. java.lang.Stringjava.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic java.util.Enumeration findByCatalogEntryCrossSell(java.lang.Long catEntryID) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Finds the related catalog entry with the catalog entry accessories.
SQL:
SELECT MASSOCCECE.CATENTRY_ID_TO, MASSOCCECE.QUANTITY, MASSOCCECE.MASSOCTYPE_ID, MASSOCCECE.MASSOCCECE_ID, MASSOCCECE.CATENTRY_ID_FROM, MASSOCCECE.MASSOC_ID, MASSOCCECE.RULE, MASSOCCECE.RANK, MASSOCCECE.FIELD1, MASSOCCECE.FIELD2, MASSOCCECE.FIELD3, MASSOCCECE.GROUPNAME, MASSOCCECE.OID
FROM MASSOCCECE, CATENTRY
WHERE CATENTRY.MARKFORDELETE = 0
AND MASSOCCECE.CATENTRY_ID_FROM = catEntryID
AND MASSOCCECE.MASSOCTYPE_ID = 'XSELL'
AND CATENTRY.CATENTRY_ID = MASSOCCECE.CATENTRY_ID_TO
ORDER BY MASSOCCECE.RANK
catEntryID
- The catalog entry reference number. java.lang.Longjava.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic java.util.Enumeration findByCatalogEntryCrossSells(java.lang.Long catEntryID, java.lang.Long[] inclusionPS, java.lang.Long[] exclusionPS) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Finds the related catalog entry with the catalog entry accessories.
SQL:
SELECT MASSOCCECE.CATENTRY_ID_TO, MASSOCCECE.QUANTITY, MASSOCCECE.MASSOCTYPE_ID, MASSOCCECE.MASSOCCECE_ID, MASSOCCECE.CATENTRY_ID_FROM, MASSOCCECE.MASSOC_ID, MASSOCCECE.RULE, MASSOCCECE.RANK, MASSOCCECE.FIELD1, MASSOCCECE.FIELD2, MASSOCCECE.FIELD3, MASSOCCECE.GROUPNAME, MASSOCCECE.OID
FROM MASSOCCECE, CATENTRY, PRSETCEREL, PRODUCTSET
WHERE CATENTRY.MARKFORDELETE = 0
AND MASSOCCECE.CATENTRY_ID_FROM = catEntryID
AND MASSOCCECE.MASSOCTYPE_ID = 'XSELL'
AND PRODUCTSET.MARKFORDELETE=0
AND CATENTRY.CATENTRY_ID = MASSOCCECE.CATENTRY_ID_TO
AND MASSOCCECE.CATENTRY_ID_TO=CATENTRY.CATENTRY_ID
AND MASSOCCECE.CATENTRY_ID_TO=PRSETCEREL.CATENTRY_ID
AND PRSETCEREL.PRODUCTSET_ID = PRODUCTSET.PRODUCTSET_ID
AND PRSETCEREL.PRODUCTSET_ID IN (inclusionPS)
AND MASSOCCECE.CATENTRY_ID_TO NOT IN (SELECT CATENTRY_ID FROM PRSETCEREL WHERE PRODUCTSET_ID NOT IN (exclusionPS))
catEntryID
- The catalog entry reference number. java.lang.LonginclusionPS
- The inclusion PS. java.lang.Long[]exclusionPS
- The exclusion PS. java.lang.Long[]java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic java.util.Enumeration findByCatalogEntryCrossSellWithSemantic(java.lang.Long catEntryID, java.lang.String semantic) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Finds the related catalog entry with the catalog entry accessories.
SQL:
SELECT MASSOCCECE.CATENTRY_ID_TO, MASSOCCECE.QUANTITY, MASSOCCECE.MASSOCTYPE_ID, MASSOCCECE.MASSOCCECE_ID, MASSOCCECE.CATENTRY_ID_FROM, MASSOCCECE.MASSOC_ID, MASSOCCECE.RULE, MASSOCCECE.RANK, MASSOCCECE.FIELD1, MASSOCCECE.FIELD2, MASSOCCECE.FIELD3, MASSOCCECE.GROUPNAME, MASSOCCECE.OID
FROM MASSOCCECE, CATENTRY
WHERE CATENTRY.MARKFORDELETE = 0
AND MASSOCCECE.CATENTRY_ID_FROM = catEntryID
AND MASSOCCECE.MASSOC_ID = semantic
AND MASSOCCECE.MASSOCTYPE_ID = 'XSELL'
AND CATENTRY.CATENTRY_ID = MASSOCCECE.CATENTRY_ID_TO
ORDER BY MASSOCCECE.RANK
catEntryID
- The catalog entry reference number. java.lang.Longsemantic
- The semantic specifier. java.lang.Stringjava.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic java.util.Enumeration findByCatalogEntryUpSell(java.lang.Long catEntryID) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Finds the related catalog entry with the catalog entry accessories.
SQL:
SELECT MASSOCCECE.CATENTRY_ID_TO, MASSOCCECE.QUANTITY, MASSOCCECE.MASSOCTYPE_ID, MASSOCCECE.MASSOCCECE_ID, MASSOCCECE.CATENTRY_ID_FROM, MASSOCCECE.MASSOC_ID, MASSOCCECE.RULE, MASSOCCECE.RANK, MASSOCCECE.FIELD1, MASSOCCECE.FIELD2, MASSOCCECE.FIELD3, MASSOCCECE.GROUPNAME, MASSOCCECE.OID
FROM MASSOCCECE, CATENTRY
WHERE CATENTRY.MARKFORDELETE = 0
AND MASSOCCECE.CATENTRY_ID_FROM = catEntryID
AND MASSOCCECE.MASSOCTYPE_ID = 'UPSELL'
AND CATENTRY.CATENTRY_ID = MASSOCCECE.CATENTRY_ID_TO
ORDER BY MASSOCCECE.RANK
catEntryID
- The catalog entry reference number. java.lang.Longjava.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic java.util.Enumeration findByCatalogEntryUpSells(java.lang.Long catEntryID, java.lang.Long[] inclusionPS, java.lang.Long[] exclusionPS) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Finds the related catalog entry with the catalog entry accessories.
SQL:
SELECT MASSOCCECE.CATENTRY_ID_TO, MASSOCCECE.QUANTITY, MASSOCCECE.MASSOCTYPE_ID, MASSOCCECE.MASSOCCECE_ID, MASSOCCECE.CATENTRY_ID_FROM, MASSOCCECE.MASSOC_ID, MASSOCCECE.RULE, MASSOCCECE.RANK, MASSOCCECE.FIELD1, MASSOCCECE.FIELD2, MASSOCCECE.FIELD3, MASSOCCECE.GROUPNAME, MASSOCCECE.OID
FROM MASSOCCECE, CATENTRY, PRSETCEREL, PRODUCTSET
WHERE CATENTRY.MARKFORDELETE = 0
AND MASSOCCECE.CATENTRY_ID_FROM = catEntryID
AND MASSOCCECE.MASSOCTYPE_ID = 'XSELL'
AND PRODUCTSET.MARKFORDELETE=0
AND CATENTRY.CATENTRY_ID = MASSOCCECE.CATENTRY_ID_TO
AND MASSOCCECE.CATENTRY_ID_TO=CATENTRY.CATENTRY_ID
AND MASSOCCECE.CATENTRY_ID_TO=PRSETCEREL.CATENTRY_ID
AND PRSETCEREL.PRODUCTSET_ID = PRODUCTSET.PRODUCTSET_ID
AND PRSETCEREL.PRODUCTSET_ID IN (inclusionPS)
AND MASSOCCECE.CATENTRY_ID_TO NOT IN (SELECT CATENTRY_ID FROM PRSETCEREL WHERE PRODUCTSET_ID NOT IN (exclusionPS))
catEntryID
- The catalog entry reference number. java.lang.LonginclusionPS
- The inclusion PS. java.lang.Long[]exclusionPS
- The exclusion PS. java.lang.Long[]java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic java.util.Enumeration findByCatalogEntryUpSellWithSemantic(java.lang.Long catEntryID, java.lang.String semantic) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Finds the related catalog entry with the catalog entry accessories.
SQL:
SELECT MASSOCCECE.CATENTRY_ID_TO, MASSOCCECE.QUANTITY, MASSOCCECE.MASSOCTYPE_ID, MASSOCCECE.MASSOCCECE_ID, MASSOCCECE.CATENTRY_ID_FROM, MASSOCCECE.MASSOC_ID, MASSOCCECE.RULE, MASSOCCECE.RANK, MASSOCCECE.FIELD1, MASSOCCECE.FIELD2, MASSOCCECE.FIELD3, MASSOCCECE.GROUPNAME, MASSOCCECE.OID
FROM MASSOCCECE, CATENTRY
WHERE CATENTRY.MARKFORDELETE = 0
AND MASSOCCECE.CATENTRY_ID_FROM = catEntryID
AND MASSOCCECE.MASSOC_ID = semantic
AND MASSOCCECE.MASSOCTYPE_ID = 'UPSELL'
AND CATENTRY.CATENTRY_ID = MASSOCCECE.CATENTRY_ID_TO
ORDER BY MASSOCCECE.RANK
catEntryID
- The catalog entry reference number. java.lang.Longsemantic
- The semantic. java.lang.Stringjava.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic java.util.Enumeration findWithPushDownQuery(java.lang.String query) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Finds the related catalog entry with the specified query. The push down query act as the where clause to search in the MASSOCCECE table. An example of the push down query: "CATENTRY_ID_TO=1234 AND CATENTRY_ID_FROM =5678"
query
- The push down query. java.lang.Stringjava.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic java.lang.String getAssociationType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the MASSOCCECE.MASSOCTYPE_ID column of DB2 type CHAR(32) NOT NULL.
The following is a description of this column:
The Identifier of the association type. Foreign key to the MASSOCTYPE table.
getAssociationType
in interface RelatedCatalogEntryAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic java.lang.String getField1() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the MASSOCCECE.FIELD1 column of DB2 type VARCHAR(254) NULL.
The following is a description of this column:
Customizable.
getField1
in interface RelatedCatalogEntryAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic java.lang.String getField2() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the MASSOCCECE.FIELD2 column of DB2 type INTEGER NULL.
The following is a description of this column:
Customizable.
getField2
in interface RelatedCatalogEntryAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic java.lang.Integer getField2InEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the MASSOCCECE.FIELD2 column of DB2 type INTEGER NULL.
The following is a description of this column:
Customizable.
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic java.lang.String getField3() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the MASSOCCECE.FIELD3 column of DB2 type DECIMAL(20,5) NULL.
The following is a description of this column:
Customizable.
getField3
in interface RelatedCatalogEntryAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic java.math.BigDecimal getField3InEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the MASSOCCECE.FIELD3 column of DB2 type DECIMAL(20,5) NULL.
The following is a description of this column:
Customizable.
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic java.lang.String getFromCatalogEntryReferenceNumber() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the MASSOCCECE.CATENTRY_ID_FROM column of DB2 type BIGINT NOT NULL.
The following is a description of this column:
The CatalogEntry that is the source of the association.
getFromCatalogEntryReferenceNumber
in interface RelatedCatalogEntryAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic java.lang.Long getFromCatalogEntryReferenceNumberInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the MASSOCCECE.CATENTRY_ID_FROM column of DB2 type BIGINT NOT NULL.
The following is a description of this column:
The CatalogEntry that is the source of the association.
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic java.lang.String getGroupName() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the MASSOCCECE.GROUPNAME column of DB2 type VARCHAR(254) NULL.
The following is a description of this column:
Reserved for IBM internal use.
getGroupName
in interface RelatedCatalogEntryAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic java.lang.String getOid() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the MASSOCCECE.OID column of DB2 type VARCHAR(64) NULL.
The following is a description of this column:
Reserved for IBM internal use.
getOid
in interface RelatedCatalogEntryAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic java.lang.String getQuantity() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the MASSOCCECE.QUANTITY column of DB2 type FLOAT NULL.
The following is a description of this column:
The quantity related to this association.
getQuantity
in interface RelatedCatalogEntryAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic java.lang.Double getQuantityInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the MASSOCCECE.QUANTITY column of DB2 type FLOAT NULL.
The following is a description of this column:
The quantity related to this association.
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic java.lang.String getRank() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the MASSOCCECE.RANK column of DB2 type DECIMAL(20,5) NULL.
The following is a description of this column:
The sequence number used for display order.
getRank
in interface RelatedCatalogEntryAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic java.math.BigDecimal getRankInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the MASSOCCECE.RANK column of DB2 type DECIMAL(20,5) NULL.
The following is a description of this column:
The sequence number used for display order.
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic CatalogEntryAccessBean getRelatedCatalogEntry() throws javax.naming.NamingException, javax.ejb.CreateException, javax.ejb.FinderException, java.rmi.RemoteException
This method provides access to the MASSOCCECE.MASSOCTYPE_ID column of DB2 type CHAR(32) NOT NULL.
The following is a description of this column:
The Identifier of the association type. Foreign key to the MASSOCTYPE table.
javax.naming.NamingException
- The javax.naming.NamingException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjava.rmi.RemoteException
- The java.rmi.RemoteException exceptionpublic java.lang.String getRule() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the MASSOCCECE.RULE column of DB2 type VARCHAR(254) NULL.
The following is a description of this column:
Reserved for IBM internal use.
getRule
in interface RelatedCatalogEntryAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic java.lang.String getSemanticSpecifier() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the MASSOCCECE.MASSOC_ID column of DB2 type CHAR(32) NOT NULL.
The following is a description of this column:
The Identifier of the semantic specifier. Foreign key to the MASSOC table.
getSemanticSpecifier
in interface RelatedCatalogEntryAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic java.lang.String getToCatalogEntryReferenceNumber() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the MASSOCCECE.CATENTRY_ID_TO column of DB2 type BIGINT NOT NULL.
The following is a description of this column:
The CatalogEntry that is the target of the association.
getToCatalogEntryReferenceNumber
in interface RelatedCatalogEntryAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic java.lang.Long getToCatalogEntryReferenceNumberInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the MASSOCCECE.CATENTRY_ID_TO column of DB2 type BIGINT NOT NULL.
The following is a description of this column:
The CatalogEntry that is the target of the association.
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic void refreshCopyHelper() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
Load data from the EJBObject.
refreshCopyHelper
in class com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic void setAssociationType(java.lang.String associationType)
This method provides access to the MASSOCCECE.MASSOCTYPE_ID column of DB2 type CHAR(32) NOT NULL.
The following is a description of this column:
The Identifier of the association type. Foreign key to the MASSOCTYPE table.
setAssociationType
in interface RelatedCatalogEntryAccessBeanData
associationType
- The association type. java.lang.Stringpublic void setField1(java.lang.String field1)
This method provides access to the MASSOCCECE.FIELD1 column of DB2 type VARCHAR(254) NULL.
The following is a description of this column:
Customizable.
setField1
in interface RelatedCatalogEntryAccessBeanData
field1
- The customizable field. java.lang.Stringpublic void setField2(java.lang.Integer field2)
This method provides access to the MASSOCCECE.FIELD2 column of DB2 type INTEGER NULL.
The following is a description of this column:
Customizable.
field2
- The customizable field. java.lang.Integerpublic void setField2(java.lang.String field2)
This method provides access to the MASSOCCECE.FIELD2 column of DB2 type INTEGER NULL.
The following is a description of this column:
Customizable.
setField2
in interface RelatedCatalogEntryAccessBeanData
field2
- The customizable field. java.lang.Stringpublic void setField3(java.math.BigDecimal field3)
This method provides access to the MASSOCCECE.FIELD3 column of DB2 type DECIMAL(20,5) NULL.
The following is a description of this column:
Customizable.
field3
- The customizable field. java.math.BigDecimalpublic void setField3(java.lang.String field3)
This method provides access to the MASSOCCECE.FIELD3 column of DB2 type DECIMAL(20,5) NULL.
The following is a description of this column:
Customizable.
setField3
in interface RelatedCatalogEntryAccessBeanData
field3
- The customizable field. java.lang.Stringpublic void setFromCatalogEntryReferenceNumber(java.lang.Long fromCatEntryID)
This method provides access to the MASSOCCECE.CATENTRY_ID_FROM column of DB2 type BIGINT NOT NULL.
The following is a description of this column:
The CatalogEntry that is the source of the association.
fromCatEntryID
- The From catalog entry reference number. java.lang.Longpublic void setFromCatalogEntryReferenceNumber(java.lang.String fromCatEntryID)
This method provides access to the MASSOCCECE.CATENTRY_ID_FROM column of DB2 type BIGINT NOT NULL.
The following is a description of this column:
The CatalogEntry that is the source of the association.
setFromCatalogEntryReferenceNumber
in interface RelatedCatalogEntryAccessBeanData
fromCatEntryID
- The From catalog entry reference number. java.lang.Stringpublic void setGroupName(java.lang.String grpName)
This method provides access to the MASSOCCECE.GROUPNAME column of DB2 type VARCHAR(254) NULL.
The following is a description of this column:
Reserved for IBM internal use.
setGroupName
in interface RelatedCatalogEntryAccessBeanData
grpName
- The group name. java.lang.Stringpublic void setInitKey_associationReferenceNumber(java.lang.String assocID)
Set the primary key for this object
assocID
- The association reference number. java.lang.Stringpublic void setOid(java.lang.String OID)
This method provides access to the MASSOCCECE.OID column of DB2 type VARCHAR(64) NULL.
The following is a description of this column:
Reserved for IBM internal use.
setOid
in interface RelatedCatalogEntryAccessBeanData
OID
- The object identifier. java.lang.Stringpublic void setQuantity(java.lang.Double quantity)
This method provides access to the MASSOCCECE.QUANTITY column of DB2 type FLOAT NULL.
The following is a description of this column:
The quantity related to this association.
quantity
- The quantity. java.lang.Doublepublic void setQuantity(java.lang.String quantity)
This method provides access to the MASSOCCECE.QUANTITY column of DB2 type FLOAT NULL.
The following is a description of this column:
The quantity related to this association.
setQuantity
in interface RelatedCatalogEntryAccessBeanData
quantity
- The quantity. java.lang.Stringpublic void setRank(java.math.BigDecimal rank)
This method provides access to the MASSOCCECE.RANK column of DB2 type DECIMAL(20,5) NULL.
The following is a description of this column:
The sequence number used for display order.
rank
- The rank. java.math.BigDecimalpublic void setRank(java.lang.String rank)
This method provides access to the MASSOCCECE.RANK column of DB2 type DECIMAL(20,5) NULL.
The following is a description of this column:
The sequence number used for display order.
setRank
in interface RelatedCatalogEntryAccessBeanData
rank
- The rank. java.lang.Stringpublic void setRule(java.lang.String rule)
This method provides access to the MASSOCCECE.RULE column of DB2 type VARCHAR(254) NULL.
The following is a description of this column:
Reserved for IBM internal use.
setRule
in interface RelatedCatalogEntryAccessBeanData
rule
- The rule. java.lang.Stringpublic void setSemanticSpecifier(java.lang.String semantic)
This method provides access to the MASSOCCECE.MASSOC_ID column of DB2 type CHAR(32) NOT NULL.
The following is a description of this column:
The Identifier of the semantic specifier. Foreign key to the MASSOC table.
setSemanticSpecifier
in interface RelatedCatalogEntryAccessBeanData
semantic
- The semantic specifier. java.lang.Stringpublic void setToCatalogEntryReferenceNumber(java.lang.Long toCatEntryID)
This method provides access to the MASSOCCECE.CATENTRY_ID_TO column of DB2 type BIGINT NOT NULL.
The following is a description of this column:
The CatalogEntry that is the target of the association.
toCatEntryID
- The To catalog entry reference number. java.lang.Longpublic void setToCatalogEntryReferenceNumber(java.lang.String toCatEntryID)
This method provides access to the MASSOCCECE.CATENTRY_ID_TO column of DB2 type BIGINT NOT NULL.
The following is a description of this column:
The CatalogEntry that is the target of the association.
setToCatalogEntryReferenceNumber
in interface RelatedCatalogEntryAccessBeanData
toCatEntryID
- The To catalog entry reference number. java.lang.String
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |