com.ibm.commerce.contract.objects
Class ContractJDBCHelperAccessBean

java.lang.Object
  |
  +--com.ibm.ivj.ejb.runtime.AbstractAccessBean
        |
        +--com.ibm.ivj.ejb.runtime.AbstractSessionAccessBean
              |
              +--com.ibm.commerce.contract.objects.ContractJDBCHelperAccessBean
All Implemented Interfaces:
java.io.Serializable

public class ContractJDBCHelperAccessBean
extends com.ibm.ivj.ejb.runtime.AbstractSessionAccessBean

See Also:
Serialized Form

Fields inherited from class com.ibm.ivj.ejb.runtime.AbstractAccessBean
DEFAULT_NAMESERVICE_PROVIDER_URL, DEFAULT_NAMESERVICE_TYPE, ejbRef
 
Constructor Summary
ContractJDBCHelperAccessBean()
          Zero argument constructor used to initialize the access bean.
ContractJDBCHelperAccessBean(javax.ejb.EJBObject anObject)
          Creates an access bean for the specified EJB
 
Method Summary
 int addEntryToContractName(java.lang.String name, java.lang.Long memberId, java.lang.Integer origin)
          Adds an entry to the contract name table
 int addEntryToContractName(java.lang.String name, java.lang.Long memberId, java.lang.Integer origin, boolean flush)
          Adds an entry to the contract name table
 int addPolicyTC(java.lang.Long policyId, java.lang.Long termConditionId)
          Adds an entry to the policy terms and conditions table
 int addStoreContract(java.lang.Long storeId, java.lang.Long contractId)
          Adds an entry to the store contract table
 int addTPCXMLDefinition(java.lang.Long tradingPositionContainerId, java.util.Vector xmlDefVec)
          Adds an entry to the trading position container xml table
 int addTPCXMLDefinition(java.lang.Long tradingPositionContainerId, java.util.Vector xmlDefVec, boolean flush)
          Adds an entry to the trading position container xml table
protected  java.lang.String defaultJNDIName()
          This method returns the default JNDI Name for the specified EJB
 int deleteEntryFromContractName(java.lang.String name, java.lang.Long memberId, java.lang.Integer origin)
          Deletes an entry from the contract name table
 int deleteEntryFromContractName(java.lang.String name, java.lang.Long memberId, java.lang.Integer origin, boolean flush)
          Deletes an entry from the contract name table
 int deletePolicyTC(java.lang.Long policyId, java.lang.Long termConditionId)
          Deletes an entry from the policy terms and conditions table
 int deletePolicyTCByTC(java.lang.Long termConditionId)
          Deletes an entry from the policy terms and conditions table
 int deleteStoreContract(java.lang.Long storeId, java.lang.Long contractId)
          Deletes an entry from the store contract table
 int deleteXMLDefByTPC(java.lang.Long tradingPositionContainerId)
          Deletes an entry from the trading position container xml table
 int deleteXMLDefByTPC(java.lang.Long tradingPositionContainerId, boolean flush)
          Deletes an entry from the trading position container xml table
 java.util.Vector findAllBusinessCmdClassNameForPolicy(java.lang.Long policyId)
          Retrieves the names of all the business command classes associated with the specified policy
 java.util.Vector findAllBusinessCmdClassNameForPolicy(java.lang.Long policyId, boolean flush)
          Retrieves the names of all the business command classes associated with the specified policy
 java.util.Vector findAllBusinessCmdInterfaceNameByPolicyType(java.lang.String policyId)
          Retrieves the names of all the business command interfaces associated with the specified policy
 java.util.Vector findAllBusinessCmdInterfaceNameByPolicyType(java.lang.String policyId, boolean flush)
          Retrieves the names of all the business command interfaces associated with the specified policy
 java.lang.String findContractComments(java.lang.Long contractId)
          Retrieves the comments associated with the specified contract
 java.lang.String findContractComments(java.lang.Long contractId, boolean flush)
          Retrieves the comments associated with the specified contract
 java.util.Vector findContractListInOrderByAccount(java.lang.Long accountId, java.lang.String orderByColumn)
          Retrieves all contracts associated with the specified account ID
 java.util.Vector findContractListInOrderByAccount(java.lang.Long accountId, java.lang.String orderByColumn, boolean flush)
          Retrieves all contracts associated with the specified account ID
 java.util.Vector findContractListInOrderByAccountAndState(java.lang.Long accountId, java.lang.Integer state, java.lang.String orderByColumn)
          Retrieves all contracts associated with the specified account ID and state
 java.util.Vector findContractListInOrderByAccountAndState(java.lang.Long accountId, java.lang.Integer state, java.lang.String orderByColumn, boolean flush)
          Retrieves all contracts associated with the specified account ID and state
 java.lang.String findParticipntInformation(java.lang.Long participantId)
          Retrieves the information associated with the specified participant
 java.lang.String findParticipntInformation(java.lang.Long participantId, boolean flush)
          Retrieves the information associated with the specified participant
 PAttrValueAccessBean[] findPAttrValueByTCIdOrderByPAttribute(java.lang.Long termConditionId)
          Retrieves an array of PAttrValueAccessBean objects with the specified term condition ID
 PAttrValueAccessBean[] findPAttrValueByTCIdOrderByPAttribute(java.lang.Long termConditionId, boolean flush)
          Retrieves an array of PAttrValueAccessBean objects with the specified term condition ID
 java.lang.String findPolicyDescription(java.lang.Long policyId, java.lang.Integer languageId)
          Retrieves the description associated with the specified policy
 java.lang.String findPolicyDescription(java.lang.Long policyId, java.lang.Integer languageId, boolean flush)
          Retrieves the description associated with the specified policy
 java.lang.String findTCDescLongDesc(java.lang.Long termConditionId, java.lang.Integer languageId)
          Retrieves the long description of the specified terms and conditions
 java.lang.String findTCDescLongDesc(java.lang.Long termConditionId, java.lang.Integer languageId, boolean flush)
          Retrieves the long description of the specified terms and conditions
 java.lang.String findTermCondStringField1(java.lang.Long termConditionId)
          Retrieves the string field of the terms and conditions table
 java.lang.String findTermCondStringField1(java.lang.Long termConditionId, boolean flush)
          Retrieves the string field of the terms and conditions table
 java.lang.String findTRDDescLongDesc(java.lang.Long tradingId, java.lang.Integer languageId)
          Retrieves the long description of the specified trading agreement
 java.lang.String findTRDDescLongDesc(java.lang.Long tradingId, java.lang.Integer languageId, boolean flush)
          Retrieves the long description of the specified trading agreement
 java.lang.String findXMLDefByTPC(java.lang.Long tradingPositionContainerId)
          Retrieves the XML definition of the trading position container
 java.lang.String findXMLDefByTPC(java.lang.Long tradingPositionContainerId, boolean flush)
          Retrieves the XML definition of the trading position container
 int getLargestTCSequenceByTrading(java.lang.Long tradingId)
          Retrieves the largest terms and conditions sequence number with the specified trading ID
 int getLargestTCSequenceByTrading(java.lang.Long tradingId, boolean flush)
          Retrieves the largest terms and conditions sequence number with the specified trading ID
 java.lang.String getTCAccessBeanNameBySubType(java.lang.String termConditionSubType)
          Retrieves the name of the terms and conditions access bean by the specified subtype
 java.lang.String getTCAccessBeanNameBySubType(java.lang.String termConditionSubType, boolean flush)
          Retrieves the name of the terms and conditions access bean by the specified subtype
 java.lang.String getTCAccessBeanNameByTC(java.lang.Long termConditionId)
          Retrieves the name of the terms and conditions access bean by the specified terms and conditions ID
 java.lang.String getTCAccessBeanNameByTC(java.lang.Long termConditionId, boolean flush)
          Retrieves the name of the terms and conditions access bean by the specified terms and conditions ID
 java.lang.String getTCDeployCmdBySubType(java.lang.String termConditionSubType)
          Retrieves the deploy command associated with the terms and conditions subtype
 java.lang.String getTCDeployCmdBySubType(java.lang.String termConditionSubType, boolean flush)
          Retrieves the deploy command associated with the terms and conditions subtype
 java.lang.String getTCDeployCmdByTC(java.lang.Long termConditionId)
          Retrieves the deploy command associated with the terms and conditions ID
 java.lang.String getTCDeployCmdByTC(java.lang.Long termConditionId, boolean flush)
          Retrieves the deploy command associated with the terms and conditions ID
protected  void instantiateEJB()
          This method instantiates the specified EJB
 java.lang.String queryContractName(java.lang.String name, java.lang.Long memberId, java.lang.Integer origin)
          Retrieves the name of the contract associated with the specified member ID and origin
 java.lang.String queryContractName(java.lang.String name, java.lang.Long memberId, java.lang.Integer origin, boolean flush)
          Retrieves the name of the contract associated with the specified member ID and origin
 boolean queryStoreContract(java.lang.Integer storeId, java.lang.Long contractId)
          Queries whether a particular contract exists for a specified store
 boolean queryStoreContract(java.lang.Integer storeId, java.lang.Long contractId, boolean flush)
          Queries whether a particular contract exists for a specified store
 int updateContractComments(java.lang.Long contractId, java.lang.String comments)
          Updates the comments field in the contract table
 int updateContractComments(java.lang.Long contractId, java.lang.String comments, boolean flush)
          Updates the comments field in the contract table
 int updateParticipntInfo(java.lang.Long participantId, java.lang.String information)
          Updates the information field in the participant table
 int updateParticipntInfo(java.lang.Long participantId, java.lang.String information, boolean flush)
          Updates the information field in the participant table
 int updatePolicyDescription(java.lang.Long policyId, java.lang.Integer languageId, java.lang.String description)
          Updates the long description field in the policy description table
 int updatePolicyDescription(java.lang.Long policyId, java.lang.Integer languageId, java.lang.String description, boolean flush)
          Updates the long description field in the policy description table
 int updateTCDescLongDesc(java.lang.Long termConditionId, java.lang.Integer languageId, java.lang.String description)
          Updates the long description field in the terms and conditions description table
 int updateTCDescLongDesc(java.lang.Long termConditionId, java.lang.Integer languageId, java.lang.String description, boolean flush)
          Updates the long description field in the terms and conditions description table
 int updateTermCondStringField1(java.lang.Long termConditionId, java.lang.String stringField1)
          Updates the string field in the terms and conditions table
 int updateTermCondStringField1(java.lang.Long termConditionId, java.lang.String stringField1, boolean flush)
          Updates the string field in the terms and conditions table
 int updateTRDDescLongDesc(java.lang.Long tradingId, java.lang.Integer languageId, java.lang.String description)
          Updates the long description field in the trading description table
 int updateTRDDescLongDesc(java.lang.Long tradingId, java.lang.Integer languageId, java.lang.String description, boolean flush)
          Updates the long description field in the trading description table
 
Methods inherited from class com.ibm.ivj.ejb.runtime.AbstractAccessBean
defaultNameServiceType, defaultNameServiceURL, getEJBRef, getGlobalHome, getHome, getInit_GlobalNameServiceTypeName, getInit_GlobalNameServiceURLName, getInit_JNDIName, getInit_NameServiceTypeName, getInit_NameServiceURLName, getInitContext, getInitContext, resetEJBRef, resetHomeCache, setEJBRef, 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

ContractJDBCHelperAccessBean

public ContractJDBCHelperAccessBean()
Zero argument constructor used to initialize the access bean. This constructor corresponds to the following home interface method: public abstract com.ibm.commerce.contract.objects.ContractJDBCHelper com.ibm.commerce.contract.objects.ContractJDBCHelperHome.create() throws javax.ejb.CreateException,java.rmi.RemoteException

ContractJDBCHelperAccessBean

public ContractJDBCHelperAccessBean(javax.ejb.EJBObject anObject)
                             throws java.rmi.RemoteException

Creates an access bean for the specified EJB

Parameters:
anObject - The EJB Object used for the access bean construction.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
Method Detail

addEntryToContractName

public int addEntryToContractName(java.lang.String name,
                                  java.lang.Long memberId,
                                  java.lang.Integer origin)
                           throws javax.naming.NamingException,
                                  java.sql.SQLException,
                                  java.rmi.RemoteException,
                                  javax.ejb.CreateException

Adds an entry to the contract name table

The SQL statement used to add a row to the CNTRNAME table is:

insert into cntrname (name, member_id, origin) values(?, ?, ?)

Parameters:
name - The name of the contract.
memberId - The ID of the owner member.
origin - The origin of the contract name.
Returns:
The number of rows in the contract name table after the new row has been inserted.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

addEntryToContractName

public int addEntryToContractName(java.lang.String name,
                                  java.lang.Long memberId,
                                  java.lang.Integer origin,
                                  boolean flush)
                           throws javax.naming.NamingException,
                                  java.sql.SQLException,
                                  java.rmi.RemoteException,
                                  javax.ejb.CreateException

Adds an entry to the contract name table

The SQL statement used to add a row to the CNTRNAME table is:

insert into cntrname (name, member_id, origin) values(?, ?, ?)

Parameters:
name - The name of the contract.
memberId - The ID of the owner member.
origin - The origin of the contract name.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The number of rows in the contract name table after the new row has been inserted.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

addPolicyTC

public int addPolicyTC(java.lang.Long policyId,
                       java.lang.Long termConditionId)
                throws javax.naming.NamingException,
                       java.sql.SQLException,
                       java.rmi.RemoteException,
                       javax.ejb.CreateException

Adds an entry to the policy terms and conditions table

The SQL statement used to add a row to the POLICYTC table is:

insert into policytc (policy_id, termcond_id) values(?, ?)

Parameters:
policyId - The ID of the policy.
termConditionId - The ID of the terms and conditions.
Returns:
The number of rows in the policy terms and conditions table after the new row has been inserted.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

addStoreContract

public int addStoreContract(java.lang.Long storeId,
                            java.lang.Long contractId)
                     throws javax.naming.NamingException,
                            java.sql.SQLException,
                            java.rmi.RemoteException,
                            javax.ejb.CreateException

Adds an entry to the store contract table

The SQL statement used to add a row to the STORECNTR table is:

insert into storecntr (store_id, contract_id) values(?, ?)

Parameters:
storeId - The ID of the store.
contractId - The ID of the contract.
Returns:
The number of rows in the store contract table after the new row has been inserted.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

addTPCXMLDefinition

public int addTPCXMLDefinition(java.lang.Long tradingPositionContainerId,
                               java.util.Vector xmlDefVec)
                        throws javax.naming.NamingException,
                               java.sql.SQLException,
                               java.rmi.RemoteException,
                               javax.ejb.CreateException

Adds an entry to the trading position container xml table

The SQL statement used to add a row to the TRDPSCNXML table is:

insert into trdpscnxml (tradeposcn_id, sequence, xmldefinition) values(?, ?, ?)

Parameters:
tradingPositionContainerId - The ID of the trading position container.
xmlDefVec - The XML definition associated with the specified trading position container.
Returns:
The number of rows in the trading position container xml table after the new row has been inserted.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

addTPCXMLDefinition

public int addTPCXMLDefinition(java.lang.Long tradingPositionContainerId,
                               java.util.Vector xmlDefVec,
                               boolean flush)
                        throws javax.naming.NamingException,
                               java.sql.SQLException,
                               java.rmi.RemoteException,
                               javax.ejb.CreateException

Adds an entry to the trading position container xml table

The SQL statement used to add a row to the TRDPSCNXML table is:

insert into trdpscnxml (tradeposcn_id, sequence, xmldefinition) values(?, ?, ?)

Parameters:
tradingPositionContainerId - The ID of the trading position container.
xmlDefVec - The XML definition associated with the specified trading position container.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The number of rows in the trading position container xml table after the new row has been inserted.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

defaultJNDIName

protected java.lang.String defaultJNDIName()

This method returns the default JNDI Name for the specified EJB

Overrides:
defaultJNDIName in class com.ibm.ivj.ejb.runtime.AbstractAccessBean
Returns:
The JNDI Name for the EJB

deleteEntryFromContractName

public int deleteEntryFromContractName(java.lang.String name,
                                       java.lang.Long memberId,
                                       java.lang.Integer origin)
                                throws javax.naming.NamingException,
                                       java.sql.SQLException,
                                       java.rmi.RemoteException,
                                       javax.ejb.CreateException

Deletes an entry from the contract name table

The SQL statement used to delete a row from the CNTRNAME table is:

delete from cntrname where name = ? and member_id = ? and origin = ?

Parameters:
name - The name of the contract.
memberId - The ID of the owner member.
origin - The origin of the contract name.
Returns:
The number of rows in the contract name table after the entry has been deleted.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

deleteEntryFromContractName

public int deleteEntryFromContractName(java.lang.String name,
                                       java.lang.Long memberId,
                                       java.lang.Integer origin,
                                       boolean flush)
                                throws javax.naming.NamingException,
                                       java.sql.SQLException,
                                       java.rmi.RemoteException,
                                       javax.ejb.CreateException

Deletes an entry from the contract name table

The SQL statement used to delete a row from the CNTRNAME table is:

delete from cntrname where name = ? and member_id = ? and origin = ?

Parameters:
name - The name of the contract.
memberId - The ID of the owner member.
origin - The origin of the contract name.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The number of rows in the contract name after the entry has been deleted.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

deletePolicyTC

public int deletePolicyTC(java.lang.Long policyId,
                          java.lang.Long termConditionId)
                   throws javax.naming.NamingException,
                          java.sql.SQLException,
                          java.rmi.RemoteException,
                          javax.ejb.CreateException

Deletes an entry from the policy terms and conditions table

The SQL statement used to delete a row from the POLICYTC table is:

delete from policytc where policy_id = ? and termcond_id= ?

Parameters:
policyId - The ID of the policy.
termConditionId - The ID of the terms and conditions.
Returns:
The number of rows in the policy terms and conditions table after the entry has been deleted.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

deletePolicyTCByTC

public int deletePolicyTCByTC(java.lang.Long termConditionId)
                       throws javax.naming.NamingException,
                              java.sql.SQLException,
                              java.rmi.RemoteException,
                              javax.ejb.CreateException

Deletes an entry from the policy terms and conditions table

The SQL statement used to delete a row from the POLICYTC table is:

delete from policytc where termcond_id= ?

Parameters:
termConditionId - The ID of the terms and conditions.
Returns:
The number of rows in the policy terms and conditions table after the entry has been deleted.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

deleteStoreContract

public int deleteStoreContract(java.lang.Long storeId,
                               java.lang.Long contractId)
                        throws javax.naming.NamingException,
                               java.sql.SQLException,
                               java.rmi.RemoteException,
                               javax.ejb.CreateException

Deletes an entry from the store contract table

The SQL statement used to delete a row from the STORECNTR table is:

delete from storecntr where store_id = ? and contract_id = ?

Parameters:
storeId - The ID of the store.
contractId - The ID of the contract.
Returns:
The number of rows in the store contract table after the entry has been deleted.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

deleteXMLDefByTPC

public int deleteXMLDefByTPC(java.lang.Long tradingPositionContainerId)
                      throws javax.naming.NamingException,
                             java.sql.SQLException,
                             java.rmi.RemoteException,
                             javax.ejb.CreateException

Deletes an entry from the trading position container xml table

The SQL statement used to delete a row from the TRDPSCNXML table is:

delete from trdpscnxml where tradeposcn_id = ?

Parameters:
tradingPositionContainerId - The ID of the trading position container.
Returns:
The number of rows in the trading position container xml table after the entry has been deleted.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

deleteXMLDefByTPC

public int deleteXMLDefByTPC(java.lang.Long tradingPositionContainerId,
                             boolean flush)
                      throws javax.naming.NamingException,
                             java.sql.SQLException,
                             java.rmi.RemoteException,
                             javax.ejb.CreateException

Deletes an entry from the trading position container xml table

The SQL statement used to delete a row from the TRDPSCNXML table is:

delete from trdpscnxml where tradeposcn_id = ?

Parameters:
tradingPositionContainerId - The ID of the trading position container.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The number of rows in the trading position container xml table after the entry has been deleted.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

findAllBusinessCmdClassNameForPolicy

public java.util.Vector findAllBusinessCmdClassNameForPolicy(java.lang.Long policyId)
                                                      throws javax.naming.NamingException,
                                                             java.sql.SQLException,
                                                             java.rmi.RemoteException,
                                                             javax.ejb.CreateException

Retrieves the names of all the business command classes associated with the specified policy

The SQL query used to fetch all the required rows from the POLICYCMD table is:

select policycmd.businesscmdclass from policycmd where policycmd.policy_id = ?

Parameters:
policyId - The ID of the policy.
Returns:
A vector of business command class names.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

findAllBusinessCmdClassNameForPolicy

public java.util.Vector findAllBusinessCmdClassNameForPolicy(java.lang.Long policyId,
                                                             boolean flush)
                                                      throws javax.naming.NamingException,
                                                             java.sql.SQLException,
                                                             java.rmi.RemoteException,
                                                             javax.ejb.CreateException

Retrieves the names of all the business command classes associated with the specified policy

The SQL query used to fetch all the required rows from the POLICYCMD table is:

select policycmd.businesscmdclass from policycmd where policycmd.policy_id = ?

Parameters:
policyId - The ID of the policy.
flush - The flag indicating whether changes should be committed immediately.
Returns:
A vector of business command class names.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

findAllBusinessCmdInterfaceNameByPolicyType

public java.util.Vector findAllBusinessCmdInterfaceNameByPolicyType(java.lang.String policyId)
                                                             throws javax.naming.NamingException,
                                                                    java.sql.SQLException,
                                                                    java.rmi.RemoteException,
                                                                    javax.ejb.CreateException

Retrieves the names of all the business command interfaces associated with the specified policy

The SQL query used to fetch all the required rows from the PLCYTYCMIF table is:

select plcytycmif.businesscmdif from plcytycmif where plcytycmif.policytype_id = ?

Parameters:
policyId - The ID of the policy.
Returns:
A vector of business command interface names.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

findAllBusinessCmdInterfaceNameByPolicyType

public java.util.Vector findAllBusinessCmdInterfaceNameByPolicyType(java.lang.String policyId,
                                                                    boolean flush)
                                                             throws javax.naming.NamingException,
                                                                    java.sql.SQLException,
                                                                    java.rmi.RemoteException,
                                                                    javax.ejb.CreateException

Retrieves the names of all the business command interfaces associated with the specified policy

The SQL query used to fetch all the required rows from the PLCYTYCMIF table is:

select plcytycmif.businesscmdif from plcytycmif where plcytycmif.policytype_id = ?

Parameters:
policyId - The ID of the policy.
flush - The flag indicating whether changes should be committed immediately.
Returns:
A vector of business command interface names.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

findContractComments

public java.lang.String findContractComments(java.lang.Long contractId)
                                      throws javax.naming.NamingException,
                                             java.sql.SQLException,
                                             java.rmi.RemoteException,
                                             javax.ejb.CreateException

Retrieves the comments associated with the specified contract

The SQL statement used to query the CONTRACT table is:

select contract.origin, contract.comments, contract.state from contract where contract.contract_id = ?

Parameters:
contractId - The ID of the contract.
Returns:
The comments associated with the specified contract.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

findContractComments

public java.lang.String findContractComments(java.lang.Long contractId,
                                             boolean flush)
                                      throws javax.naming.NamingException,
                                             java.sql.SQLException,
                                             java.rmi.RemoteException,
                                             javax.ejb.CreateException

Retrieves the comments associated with the specified contract

The SQL statement used to query the CONTRACT table is:

select contract.origin, contract.comments, contract.state from contract where contract.contract_id = ?

Parameters:
contractId - The ID of the contract.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The comments associated with the specified contract.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

findContractListInOrderByAccount

public java.util.Vector findContractListInOrderByAccount(java.lang.Long accountId,
                                                         java.lang.String orderByColumn)
                                                  throws javax.naming.NamingException,
                                                         java.sql.SQLException,
                                                         java.rmi.RemoteException,
                                                         javax.ejb.CreateException

Retrieves all contracts associated with the specified account ID

The SQL query used to fetch all the required rows from the CONTRACT table, the TRADING table, and the TRDDESC table is:

select distinct contract.contract_id from contract, trading, trddesc where (trading.account_id = ? and trading.markfordelete = 0) and contract.markfordelete = 0 and contract.contract_id = trading.trading_id and contract.contract_id = trddesc.trading_id order by

Parameters:
accountId - The ID of the account.
orderByColumn - The order by which to display the result.
Returns:
A vector of contract IDs.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

findContractListInOrderByAccount

public java.util.Vector findContractListInOrderByAccount(java.lang.Long accountId,
                                                         java.lang.String orderByColumn,
                                                         boolean flush)
                                                  throws javax.naming.NamingException,
                                                         java.sql.SQLException,
                                                         java.rmi.RemoteException,
                                                         javax.ejb.CreateException

Retrieves all contracts associated with the specified account ID

The SQL query used to fetch all the required rows from the CONTRACT table, the TRADING table, and the TRDDESC table is:

select distinct contract.contract_id from contract, trading, trddesc where (trading.account_id = ? and trading.markfordelete = 0) and contract.markfordelete = 0 and contract.contract_id = trading.trading_id and contract.contract_id = trddesc.trading_id order by

Parameters:
accountId - The ID of the account.
orderByColumn - The order by which to display the result.
flush - The flag indicating whether changes should be committed immediately.
Returns:
A vector of contract IDs.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

findContractListInOrderByAccountAndState

public java.util.Vector findContractListInOrderByAccountAndState(java.lang.Long accountId,
                                                                 java.lang.Integer state,
                                                                 java.lang.String orderByColumn)
                                                          throws javax.naming.NamingException,
                                                                 java.sql.SQLException,
                                                                 java.rmi.RemoteException,
                                                                 javax.ejb.CreateException

Retrieves all contracts associated with the specified account ID and state

The SQL query used to fetch all the required rows from the CONTRACT table, the TRADING table, and the TRDDESC table is:

select distinct contract.contract_id from contract, trading, trddesc where (trading.account_id = ? and trading.markfordelete = 0) and contract.state = ? and contract.markfordelete = 0 and contract.contract_id = trading.trading_id and contract.contract_id = trddesc.trading_id order by

Parameters:
accountId - The ID of the account.
state - The state of the contract.
orderByColumn - The order by which to display the result.
Returns:
A vector of contract IDs.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

findContractListInOrderByAccountAndState

public java.util.Vector findContractListInOrderByAccountAndState(java.lang.Long accountId,
                                                                 java.lang.Integer state,
                                                                 java.lang.String orderByColumn,
                                                                 boolean flush)
                                                          throws javax.naming.NamingException,
                                                                 java.sql.SQLException,
                                                                 java.rmi.RemoteException,
                                                                 javax.ejb.CreateException

Retrieves all contracts associated with the specified account ID and state

The SQL query used to fetch all the required rows from the CONTRACT table, the TRADING table, and the TRDDESC table is:

select distinct contract.contract_id from contract, trading, trddesc where (trading.account_id = ? and trading.markfordelete = 0) and contract.state = ? and contract.markfordelete = 0 and contract.contract_id = trading.trading_id and contract.contract_id = trddesc.trading_id order by

Parameters:
accountId - The ID of the account.
state - The state of the contract.
orderByColumn - The order by which to display the result.
flush - The flag indicating whether changes should be committed immediately.
Returns:
A vector of contract IDs.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

findParticipntInformation

public java.lang.String findParticipntInformation(java.lang.Long participantId)
                                           throws javax.naming.NamingException,
                                                  java.sql.SQLException,
                                                  java.rmi.RemoteException,
                                                  javax.ejb.CreateException

Retrieves the information associated with the specified participant

The SQL statement used to query the PARTICIPNT table is:

select participnt.member_id, participnt.information, participnt.termcond_id from participnt where participnt.participnt_id = ?

Parameters:
participantId - The ID of the participant.
Returns:
The information associated with the specified participant.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

findParticipntInformation

public java.lang.String findParticipntInformation(java.lang.Long participantId,
                                                  boolean flush)
                                           throws javax.naming.NamingException,
                                                  java.sql.SQLException,
                                                  java.rmi.RemoteException,
                                                  javax.ejb.CreateException

Retrieves the information associated with the specified participant

The SQL statement used to query the PARTICIPNT table is:

select participnt.member_id, participnt.information, participnt.termcond_id from participnt where participnt.participnt_id = ?

Parameters:
participantId - The ID of the participant.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The information associated with the specified participant.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

findPAttrValueByTCIdOrderByPAttribute

public PAttrValueAccessBean[] findPAttrValueByTCIdOrderByPAttribute(java.lang.Long termConditionId)
                                                             throws javax.naming.NamingException,
                                                                    java.sql.SQLException,
                                                                    java.rmi.RemoteException,
                                                                    javax.ejb.CreateException

Retrieves an array of PAttrValueAccessBean objects with the specified term condition ID

The SQL query used to fetch all the required rows from the PATTRVALUE table is:

select pattrvalue_id, pattribute_id from pattrvalue where termcond_id = ? order by pattribute_id

Parameters:
termConditionId - The ID of the terms and conditions.
Returns:
An array of PAttrValueAccessBean objects with the specified term condition ID.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

findPAttrValueByTCIdOrderByPAttribute

public PAttrValueAccessBean[] findPAttrValueByTCIdOrderByPAttribute(java.lang.Long termConditionId,
                                                                    boolean flush)
                                                             throws javax.naming.NamingException,
                                                                    java.sql.SQLException,
                                                                    java.rmi.RemoteException,
                                                                    javax.ejb.CreateException

Retrieves an array of PAttrValueAccessBean objects with the specified term condition ID

The SQL query used to fetch all the required rows from the PATTRVALUE table is:

select pattrvalue_id, pattribute_id from pattrvalue where termcond_id = ? order by pattribute_id

Parameters:
termConditionId - The ID of the terms and conditions.
flush - The flag indicating whether changes should be committed immediately.
Returns:
An array of PAttrValueAccessBean objects with the specified term condition ID.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

findPolicyDescription

public java.lang.String findPolicyDescription(java.lang.Long policyId,
                                              java.lang.Integer languageId)
                                       throws javax.naming.NamingException,
                                              java.sql.SQLException,
                                              java.rmi.RemoteException,
                                              javax.ejb.CreateException

Retrieves the description associated with the specified policy

The SQL statement used to query the POLICYDESC table is:

select policydesc.policy_id, policydesc.longdescription, policydesc.language_id from policydesc where policydesc.policy_id = ? and policydesc.language_id = ?

Parameters:
policyId - The ID of the policy.
languageId - The ID of the language associated with the specified policy.
Returns:
The description associated with the specified policy.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

findPolicyDescription

public java.lang.String findPolicyDescription(java.lang.Long policyId,
                                              java.lang.Integer languageId,
                                              boolean flush)
                                       throws javax.naming.NamingException,
                                              java.sql.SQLException,
                                              java.rmi.RemoteException,
                                              javax.ejb.CreateException

Retrieves the description associated with the specified policy

The SQL statement used to query the POLICYDESC table is:

select policydesc.policy_id, policydesc.longdescription, policydesc.language_id from policydesc where policydesc.policy_id = ? and policydesc.language_id = ?

Parameters:
policyId - The ID of the policy.
languageId - The ID of the language associated with the specified policy.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The description associated with the specified policy.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

findTCDescLongDesc

public java.lang.String findTCDescLongDesc(java.lang.Long termConditionId,
                                           java.lang.Integer languageId)
                                    throws javax.naming.NamingException,
                                           java.sql.SQLException,
                                           java.rmi.RemoteException,
                                           javax.ejb.CreateException

Retrieves the long description of the specified terms and conditions

The SQL statement used to query the TCDESC table is:

select tcdesc.termcond_id, tcdesc.longdescription, tcdesc.language_id from tcdesc where tcdesc.termcond_id = ? and tcdesc.language_id = ?

Parameters:
termConditionId - The ID of the terms and conditions.
languageId - The ID of the language associated with the specified terms and conditions description.
Returns:
The long description of the specified terms and conditions.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

findTCDescLongDesc

public java.lang.String findTCDescLongDesc(java.lang.Long termConditionId,
                                           java.lang.Integer languageId,
                                           boolean flush)
                                    throws javax.naming.NamingException,
                                           java.sql.SQLException,
                                           java.rmi.RemoteException,
                                           javax.ejb.CreateException

Retrieves the long description of the specified terms and conditions

The SQL statement used to query the TCDESC table is:

select tcdesc.termcond_id, tcdesc.longdescription, tcdesc.language_id from tcdesc where tcdesc.termcond_id = ? and tcdesc.language_id = ?

Parameters:
termConditionId - The ID of the terms and conditions.
languageId - The ID of the language associated with the specified terms and conditions description.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The long description of the specified terms and conditions.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

findTermCondStringField1

public java.lang.String findTermCondStringField1(java.lang.Long termConditionId)
                                          throws javax.naming.NamingException,
                                                 java.sql.SQLException,
                                                 java.rmi.RemoteException,
                                                 javax.ejb.CreateException

Retrieves the string field of the terms and conditions table

The SQL statement used to query the TERMCOND table is:

select termcond.integerfield1, termcond.stringfield1, termcond.integerfield2 from termcond where termcond.termcond_id = ?

Parameters:
termConditionId - The ID of the terms and conditions.
Returns:
The string field of the terms and conditions table.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

findTermCondStringField1

public java.lang.String findTermCondStringField1(java.lang.Long termConditionId,
                                                 boolean flush)
                                          throws javax.naming.NamingException,
                                                 java.sql.SQLException,
                                                 java.rmi.RemoteException,
                                                 javax.ejb.CreateException

Retrieves the string field of the terms and conditions table

The SQL statement used to query the TERMCOND table is:

select termcond.integerfield1, termcond.stringfield1, termcond.integerfield2 from termcond where termcond.termcond_id = ?

Parameters:
termConditionId - The ID of the terms and conditions.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The string field of the terms and conditions table.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

findTRDDescLongDesc

public java.lang.String findTRDDescLongDesc(java.lang.Long tradingId,
                                            java.lang.Integer languageId)
                                     throws javax.naming.NamingException,
                                            java.sql.SQLException,
                                            java.rmi.RemoteException,
                                            javax.ejb.CreateException

Retrieves the long description of the specified trading agreement

The SQL statement used to query the TRDDESC table is:

select trddesc.trading_id, trddesc.longdescription, trddesc.language_id from trddesc where trddesc.trading_id = ? and trddesc.language_id = ?

Parameters:
tradingId - The ID of the trading agreement.
languageId - The ID of the language associated with the specified terms and conditions description.
Returns:
The long description of the specified trading agreement.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

findTRDDescLongDesc

public java.lang.String findTRDDescLongDesc(java.lang.Long tradingId,
                                            java.lang.Integer languageId,
                                            boolean flush)
                                     throws javax.naming.NamingException,
                                            java.sql.SQLException,
                                            java.rmi.RemoteException,
                                            javax.ejb.CreateException

Retrieves the long description of the specified trading agreement

The SQL statement used to query the TRDDESC table is:

select trddesc.trading_id, trddesc.longdescription, trddesc.language_id from trddesc where trddesc.trading_id = ? and trddesc.language_id = ?

Parameters:
tradingId - The ID of the trading agreement.
languageId - The ID of the language associated with the specified terms and conditions description.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The long description of the specified trading agreement.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

findXMLDefByTPC

public java.lang.String findXMLDefByTPC(java.lang.Long tradingPositionContainerId)
                                 throws javax.naming.NamingException,
                                        java.sql.SQLException,
                                        java.rmi.RemoteException,
                                        javax.ejb.CreateException

Retrieves the XML definition of the trading position container

The SQL statement used to query the TRDPSCNXML table is:

select xmldefinition, sequence from trdpscnxml where tradeposcn_id = ? order by sequence

Parameters:
tradingPositionContainerId - The ID of the trading position container.
Returns:
The XML definition associated with the trading position container.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

findXMLDefByTPC

public java.lang.String findXMLDefByTPC(java.lang.Long tradingPositionContainerId,
                                        boolean flush)
                                 throws javax.naming.NamingException,
                                        java.sql.SQLException,
                                        java.rmi.RemoteException,
                                        javax.ejb.CreateException

Retrieves the XML definition of the trading position container

The SQL statement used to query the TRDPSCNXML table is:

select xmldefinition, sequence from trdpscnxml where tradeposcn_id = ? order by sequence

Parameters:
tradingPositionContainerId - The ID of the trading position container.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The XML definition associated with the trading position container.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

getLargestTCSequenceByTrading

public int getLargestTCSequenceByTrading(java.lang.Long tradingId)
                                  throws javax.naming.NamingException,
                                         java.sql.SQLException,
                                         java.rmi.RemoteException,
                                         javax.ejb.CreateException

Retrieves the largest terms and conditions sequence number with the specified trading ID

The SQL statement used to fetch the result from the TERMCOND table is:

select max(sequence) from termcond where trading_id = ?

Parameters:
tradingId - The ID of the trading agreement.
Returns:
The largest terms and conditions sequence number with the specified trading ID.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

getLargestTCSequenceByTrading

public int getLargestTCSequenceByTrading(java.lang.Long tradingId,
                                         boolean flush)
                                  throws javax.naming.NamingException,
                                         java.sql.SQLException,
                                         java.rmi.RemoteException,
                                         javax.ejb.CreateException

Retrieves the largest terms and conditions sequence number with the specified trading ID

The SQL statement used to fetch the result from the TERMCOND table is:

select max(sequence) from termcond where trading_id = ?

Parameters:
tradingId - The ID of the trading agreement.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The largest terms and conditions sequence number with the specified trading ID.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

getTCAccessBeanNameBySubType

public java.lang.String getTCAccessBeanNameBySubType(java.lang.String termConditionSubType)
                                              throws javax.naming.NamingException,
                                                     java.sql.SQLException,
                                                     java.rmi.RemoteException,
                                                     javax.ejb.CreateException

Retrieves the name of the terms and conditions access bean by the specified subtype

The SQL statement used to query the TCSUBTYPE table is:

select distinct t1.accessbeanname from tcsubtype t1 where (t1.tcsubtype_id = ?)

Parameters:
termConditionSubType - The subtype of the terms and conditions.
Returns:
The name of the terms and conditions access bean.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

getTCAccessBeanNameBySubType

public java.lang.String getTCAccessBeanNameBySubType(java.lang.String termConditionSubType,
                                                     boolean flush)
                                              throws javax.naming.NamingException,
                                                     java.sql.SQLException,
                                                     java.rmi.RemoteException,
                                                     javax.ejb.CreateException

Retrieves the name of the terms and conditions access bean by the specified subtype

The SQL statement used to query the TCSUBTYPE table is:

select distinct t1.accessbeanname from tcsubtype t1 where (t1.tcsubtype_id = ?)

Parameters:
termConditionSubType - The subtype of the terms and conditions.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The name of the terms and conditions access bean.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

getTCAccessBeanNameByTC

public java.lang.String getTCAccessBeanNameByTC(java.lang.Long termConditionId)
                                         throws javax.naming.NamingException,
                                                java.sql.SQLException,
                                                java.rmi.RemoteException,
                                                javax.ejb.CreateException

Retrieves the name of the terms and conditions access bean by the specified terms and conditions ID

The SQL statement used to query the TCSUBTYPE table is:

select distinct t1.accessbeanname from tcsubtype t1, termcond t2 where t1.tcsubtype_id = t2.tcsubtype_id and t2.termcond_id = ?

Parameters:
termConditionId - The ID of the terms and conditions.
Returns:
The name of the terms and conditions access bean.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

getTCAccessBeanNameByTC

public java.lang.String getTCAccessBeanNameByTC(java.lang.Long termConditionId,
                                                boolean flush)
                                         throws javax.naming.NamingException,
                                                java.sql.SQLException,
                                                java.rmi.RemoteException,
                                                javax.ejb.CreateException

Retrieves the name of the terms and conditions access bean by the specified terms and conditions ID

The SQL statement used to query the TCSUBTYPE table is:

select distinct t1.accessbeanname from tcsubtype t1, termcond t2 where t1.tcsubtype_id = t2.tcsubtype_id and t2.termcond_id = ?

Parameters:
termConditionId - The ID of the terms and conditions.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The name of the terms and conditions access bean.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

getTCDeployCmdBySubType

public java.lang.String getTCDeployCmdBySubType(java.lang.String termConditionSubType)
                                         throws javax.naming.NamingException,
                                                java.sql.SQLException,
                                                java.rmi.RemoteException,
                                                javax.ejb.CreateException

Retrieves the deploy command associated with the terms and conditions subtype

The SQL statement used to query the TCSUBTYPE table is:

select distinct t1.deploycommand from tcsubtype t1 where (t1.tcsubtype_id = ?)

Parameters:
termConditionSubType - The subtype of the terms and conditions.
Returns:
The deploy command associated with the terms and conditions subtype.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

getTCDeployCmdBySubType

public java.lang.String getTCDeployCmdBySubType(java.lang.String termConditionSubType,
                                                boolean flush)
                                         throws javax.naming.NamingException,
                                                java.sql.SQLException,
                                                java.rmi.RemoteException,
                                                javax.ejb.CreateException

Retrieves the deploy command associated with the terms and conditions subtype

The SQL statement used to query the TCSUBTYPE table is:

select distinct t1.deploycommand from tcsubtype t1 where (t1.tcsubtype_id = ?)

Parameters:
termConditionSubType - The subtype of the terms and conditions.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The deploy command associated with the terms and conditions subtype.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

getTCDeployCmdByTC

public java.lang.String getTCDeployCmdByTC(java.lang.Long termConditionId)
                                    throws javax.naming.NamingException,
                                           java.sql.SQLException,
                                           java.rmi.RemoteException,
                                           javax.ejb.CreateException

Retrieves the deploy command associated with the terms and conditions ID

The SQL statement used to query the TCSUBTYPE table and the TERMCOND table is:

select distinct t1.deploycommand from tcsubtype t1, termcond t2 where t1.tcsubtype_id = t2.tcsubtype_id and t2.termcond_id = ?

Parameters:
termConditionId - The ID of the terms and conditions.
Returns:
The deploy command associated with the terms and conditions ID.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

getTCDeployCmdByTC

public java.lang.String getTCDeployCmdByTC(java.lang.Long termConditionId,
                                           boolean flush)
                                    throws javax.naming.NamingException,
                                           java.sql.SQLException,
                                           java.rmi.RemoteException,
                                           javax.ejb.CreateException

Retrieves the deploy command associated with the terms and conditions ID

The SQL statement used to query the TCSUBTYPE table and the TERMCOND table is:

select distinct t1.deploycommand from tcsubtype t1, termcond t2 where t1.tcsubtype_id = t2.tcsubtype_id and t2.termcond_id = ?

Parameters:
termConditionId - The ID of the terms and conditions.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The deploy command associated with the terms and conditions ID.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

instantiateEJB

protected void instantiateEJB()
                       throws javax.ejb.CreateException,
                              java.rmi.RemoteException,
                              javax.naming.NamingException

This method instantiates the specified EJB

Overrides:
instantiateEJB in class com.ibm.ivj.ejb.runtime.AbstractAccessBean
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

queryContractName

public java.lang.String queryContractName(java.lang.String name,
                                          java.lang.Long memberId,
                                          java.lang.Integer origin)
                                   throws javax.naming.NamingException,
                                          java.sql.SQLException,
                                          java.rmi.RemoteException,
                                          javax.ejb.CreateException

Retrieves the name of the contract associated with the specified member ID and origin

The SQL statement used to query the CNTRNAME table is:

select name from cntrname where name = ? and member_id = ? and origin = ? for update

Parameters:
name - The name of the contract.
memberId - The ID of the owner member.
origin - The origin of the contract.
Returns:
The name of the contract.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

queryContractName

public java.lang.String queryContractName(java.lang.String name,
                                          java.lang.Long memberId,
                                          java.lang.Integer origin,
                                          boolean flush)
                                   throws javax.naming.NamingException,
                                          java.sql.SQLException,
                                          java.rmi.RemoteException,
                                          javax.ejb.CreateException

Retrieves the name of the contract associated with the specified member ID and origin

The SQL statement used to query the CNTRNAME table is:

select name from cntrname where name = ? and member_id = ? and origin = ? for update

Parameters:
name - The name of the contract.
memberId - The ID of the owner member.
origin - The origin of the contract.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The name of the contract.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

queryStoreContract

public boolean queryStoreContract(java.lang.Integer storeId,
                                  java.lang.Long contractId)
                           throws javax.naming.NamingException,
                                  java.sql.SQLException,
                                  java.rmi.RemoteException,
                                  javax.ejb.CreateException

Queries whether a particular contract exists for a specified store

The SQL query used to fetch all the required rows from the STORECNTR table is:

select * from storecntr where store_id = ? and contract_id = ?

Parameters:
storeId - The ID of the store.
contractId - The ID of the contract.
Returns:
boolean A flag indicating whether the contract exists for the specified store.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

queryStoreContract

public boolean queryStoreContract(java.lang.Integer storeId,
                                  java.lang.Long contractId,
                                  boolean flush)
                           throws javax.naming.NamingException,
                                  java.sql.SQLException,
                                  java.rmi.RemoteException,
                                  javax.ejb.CreateException

Queries whether a particular contract exists for a specified store

The SQL query used to fetch all the required rows from the STORECNTR table is:

select * from storecntr where store_id = ? and contract_id = ?

Parameters:
storeId - The ID of the store.
contractId - The ID of the contract.
flush - The flag indicating whether changes should be committed immediately.
Returns:
boolean A flag indicating whether the contract exists for the specified store.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

updateContractComments

public int updateContractComments(java.lang.Long contractId,
                                  java.lang.String comments)
                           throws javax.naming.NamingException,
                                  java.sql.SQLException,
                                  java.rmi.RemoteException,
                                  javax.ejb.CreateException

Updates the comments field in the contract table

The SQL statement used to update the CONTRACT table is:

update contract set comments = ? where contract.contract_id = ?

Parameters:
contractId - The ID of the contract.
comments - The comments of the contract.
Returns:
The number of rows in the contract table after the entry has updated.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

updateContractComments

public int updateContractComments(java.lang.Long contractId,
                                  java.lang.String comments,
                                  boolean flush)
                           throws javax.naming.NamingException,
                                  java.sql.SQLException,
                                  java.rmi.RemoteException,
                                  javax.ejb.CreateException

Updates the comments field in the contract table

The SQL statement used to update the CONTRACT table is:

update contract set comments = ? where contract.contract_id = ?

Parameters:
contractId - The ID of the contract.
comments - The comments of the contract.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The number of rows in the contract table after the entry has updated.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

updateParticipntInfo

public int updateParticipntInfo(java.lang.Long participantId,
                                java.lang.String information)
                         throws javax.naming.NamingException,
                                java.sql.SQLException,
                                java.rmi.RemoteException,
                                javax.ejb.CreateException

Updates the information field in the participant table

The SQL statement used to update the PARTICIPNT table is:

update participnt set information = ? where participnt.participnt_id = ?

Parameters:
participantId - The ID of the participant.
information - The information associated with the participant.
Returns:
The number of rows in the participant table after the entry has updated.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

updateParticipntInfo

public int updateParticipntInfo(java.lang.Long participantId,
                                java.lang.String information,
                                boolean flush)
                         throws javax.naming.NamingException,
                                java.sql.SQLException,
                                java.rmi.RemoteException,
                                javax.ejb.CreateException

Updates the information field in the participant table

The SQL statement used to update the PARTICIPNT table is:

update participnt set information = ? where participnt.participnt_id = ?

Parameters:
participantId - The ID of the participant.
information - The information associated with the participant.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The number of rows in the participant table after the entry has updated.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

updatePolicyDescription

public int updatePolicyDescription(java.lang.Long policyId,
                                   java.lang.Integer languageId,
                                   java.lang.String description)
                            throws javax.naming.NamingException,
                                   java.sql.SQLException,
                                   java.rmi.RemoteException,
                                   javax.ejb.CreateException

Updates the long description field in the policy description table

The SQL statement used to update the POLICYDESC table is:

update policydesc set longdescription = ? where policydesc.policy_id = ? and policydesc.language_id = ?

Parameters:
policyId - The ID of the policy.
languageId - The ID of the language associated with the policy description.
description - The description of the policy.
Returns:
The number of rows in the policy description table after the entry has updated.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

updatePolicyDescription

public int updatePolicyDescription(java.lang.Long policyId,
                                   java.lang.Integer languageId,
                                   java.lang.String description,
                                   boolean flush)
                            throws javax.naming.NamingException,
                                   java.sql.SQLException,
                                   java.rmi.RemoteException,
                                   javax.ejb.CreateException

Updates the long description field in the policy description table

The SQL statement used to update the POLICYDESC table is:

update policydesc set longdescription = ? where policydesc.policy_id = ? and policydesc.language_id = ?

Parameters:
policyId - The ID of the policy.
languageId - The ID of the language associated with the policy description.
description - The description of the policy.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The number of rows in the policy description table after the entry has updated.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

updateTCDescLongDesc

public int updateTCDescLongDesc(java.lang.Long termConditionId,
                                java.lang.Integer languageId,
                                java.lang.String description)
                         throws javax.naming.NamingException,
                                java.sql.SQLException,
                                java.rmi.RemoteException,
                                javax.ejb.CreateException

Updates the long description field in the terms and conditions description table

The SQL statement used to update the TCDESC table is:

update tcdesc set tcdesc.longdescription = ? where tcdesc.termcond_id = ? and tcdesc.language_id = ?

Parameters:
termConditionId - The ID of the terms and conditions.
languageId - The ID of the language associated with the terms and conditions description.
description - The description of the terms and conditions.
Returns:
The number of rows in the terms and conditions description table after the entry has updated.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

updateTCDescLongDesc

public int updateTCDescLongDesc(java.lang.Long termConditionId,
                                java.lang.Integer languageId,
                                java.lang.String description,
                                boolean flush)
                         throws javax.naming.NamingException,
                                java.sql.SQLException,
                                java.rmi.RemoteException,
                                javax.ejb.CreateException

Updates the long description field in the terms and conditions description table

The SQL statement used to update the TCDESC table is:

update tcdesc set tcdesc.longdescription = ? where tcdesc.termcond_id = ? and tcdesc.language_id = ?

Parameters:
termConditionId - The ID of the terms and conditions.
languageId - The ID of the language associated with the terms and conditions description.
description - The description of the terms and conditions.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The number of rows in the terms and conditions description table after the entry has updated.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

updateTermCondStringField1

public int updateTermCondStringField1(java.lang.Long termConditionId,
                                      java.lang.String stringField1)
                               throws javax.naming.NamingException,
                                      java.sql.SQLException,
                                      java.rmi.RemoteException,
                                      javax.ejb.CreateException

Updates the string field in the terms and conditions table

The SQL statement used to update the TERMCOND table is:

update termcond set termcond.stringfield1 = ? where termcond.termcond_id = ?

Parameters:
termConditionId - The ID of the terms and conditions.
stringField1 - The string field associated with the terms and conditions.
Returns:
The number of rows in the terms and conditions table after the entry has updated.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

updateTermCondStringField1

public int updateTermCondStringField1(java.lang.Long termConditionId,
                                      java.lang.String stringField1,
                                      boolean flush)
                               throws javax.naming.NamingException,
                                      java.sql.SQLException,
                                      java.rmi.RemoteException,
                                      javax.ejb.CreateException

Updates the string field in the terms and conditions table

The SQL statement used to update the TERMCOND table is:

update termcond set termcond.stringfield1 = ? where termcond.termcond_id = ?

Parameters:
termConditionId - The ID of the terms and conditions.
stringField1 - The string field associated with the terms and conditions.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The number of rows in the terms and conditions table after the entry has updated.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

updateTRDDescLongDesc

public int updateTRDDescLongDesc(java.lang.Long tradingId,
                                 java.lang.Integer languageId,
                                 java.lang.String description)
                          throws javax.naming.NamingException,
                                 java.sql.SQLException,
                                 java.rmi.RemoteException,
                                 javax.ejb.CreateException

Updates the long description field in the trading description table

The SQL statement used to update the TRDDESC table is:

update trddesc set trddesc.longdescription = ? where trddesc.trading_id = ? and trddesc.language_id = ?

Parameters:
tradingId - The ID of the trading agreement.
languageId - The ID of the language associated with the trading description.
description - The description of the trading agreement.
Returns:
The number of rows in the trading description table after the entry has updated.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.

updateTRDDescLongDesc

public int updateTRDDescLongDesc(java.lang.Long tradingId,
                                 java.lang.Integer languageId,
                                 java.lang.String description,
                                 boolean flush)
                          throws javax.naming.NamingException,
                                 java.sql.SQLException,
                                 java.rmi.RemoteException,
                                 javax.ejb.CreateException

Updates the long description field in the trading description table

The SQL statement used to update the TRDDESC table is:

update trddesc set trddesc.longdescription = ? where trddesc.trading_id = ? and trddesc.language_id = ?

Parameters:
tradingId - The ID of the trading agreement.
languageId - The ID of the language associated with the trading description.
description - The description of the trading agreement.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The number of rows in the trading description table after the entry has updated.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception.
java.sql.SQLException - The java.sql.SQLException exception.
java.rmi.RemoteException - The java.rmi.RemoteException exception.
javax.ejb.CreateException - The javax.ejb.CreateException exception.