|
||||||||
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.AbstractSessionAccessBean | +--com.ibm.commerce.contract.objects.ContractJDBCHelperAccessBean
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 |
public ContractJDBCHelperAccessBean()
public ContractJDBCHelperAccessBean(javax.ejb.EJBObject anObject) throws java.rmi.RemoteException
Creates an access bean for the specified EJB
anObject
- The EJB Object used for the access bean construction.java.rmi.RemoteException
- The java.rmi.RemoteException exceptionMethod Detail |
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(?, ?, ?)
name
- The name of the contract.memberId
- The ID of the owner member.origin
- The origin of the contract name.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.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(?, ?, ?)
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.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.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(?, ?)
policyId
- The ID of the policy.termConditionId
- The ID of the terms and conditions.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.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(?, ?)
storeId
- The ID of the store.contractId
- The ID of the contract.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.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(?, ?, ?)
tradingPositionContainerId
- The ID of the trading position container.xmlDefVec
- The XML definition associated with the specified trading position container.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.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(?, ?, ?)
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.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.protected java.lang.String defaultJNDIName()
This method returns the default JNDI Name for the specified EJB
defaultJNDIName
in class com.ibm.ivj.ejb.runtime.AbstractAccessBean
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 = ?
name
- The name of the contract.memberId
- The ID of the owner member.origin
- The origin of the contract name.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.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 = ?
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.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.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= ?
policyId
- The ID of the policy.termConditionId
- The ID of the terms and conditions.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.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= ?
termConditionId
- The ID of the terms and conditions.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.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 = ?
storeId
- The ID of the store.contractId
- The ID of the contract.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.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 = ?
tradingPositionContainerId
- The ID of the trading position container.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.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 = ?
tradingPositionContainerId
- The ID of the trading position container.flush
- The flag indicating whether changes should be committed immediately.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.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 = ?
policyId
- The ID of the policy.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.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 = ?
policyId
- The ID of the policy.flush
- The flag indicating whether changes should be committed immediately.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.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 = ?
policyId
- The ID of the policy.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.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 = ?
policyId
- The ID of the policy.flush
- The flag indicating whether changes should be committed immediately.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.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 = ?
contractId
- The ID of the contract.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.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 = ?
contractId
- The ID of the contract.flush
- The flag indicating whether changes should be committed immediately.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.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
accountId
- The ID of the account.orderByColumn
- The order by which to display the result.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.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
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.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.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
accountId
- The ID of the account.state
- The state of the contract.orderByColumn
- The order by which to display the result.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.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
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.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.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 = ?
participantId
- The ID of the participant.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.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 = ?
participantId
- The ID of the participant.flush
- The flag indicating whether changes should be committed immediately.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.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
termConditionId
- The ID of the terms and conditions.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.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
termConditionId
- The ID of the terms and conditions.flush
- The flag indicating whether changes should be committed immediately.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.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 = ?
policyId
- The ID of the policy.languageId
- The ID of the language associated with the specified policy.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.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 = ?
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.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.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 = ?
termConditionId
- The ID of the terms and conditions.languageId
- The ID of the language associated with the specified terms and conditions description.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.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 = ?
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.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.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 = ?
termConditionId
- The ID of the terms and conditions.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.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 = ?
termConditionId
- The ID of the terms and conditions.flush
- The flag indicating whether changes should be committed immediately.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.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 = ?
tradingId
- The ID of the trading agreement.languageId
- The ID of the language associated with the specified terms and conditions description.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.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 = ?
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.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.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
tradingPositionContainerId
- The ID of the trading position container.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.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
tradingPositionContainerId
- The ID of the trading position container.flush
- The flag indicating whether changes should be committed immediately.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.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 = ?
tradingId
- The ID of the trading agreement.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.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 = ?
tradingId
- The ID of the trading agreement.flush
- The flag indicating whether changes should be committed immediately.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.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 = ?)
termConditionSubType
- The subtype of the terms and conditions.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.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 = ?)
termConditionSubType
- The subtype of the terms and conditions.flush
- The flag indicating whether changes should be committed immediately.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.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 = ?
termConditionId
- The ID of the terms and conditions.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.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 = ?
termConditionId
- The ID of the terms and conditions.flush
- The flag indicating whether changes should be committed immediately.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.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 = ?)
termConditionSubType
- The subtype of the terms and conditions.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.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 = ?)
termConditionSubType
- The subtype of the terms and conditions.flush
- The flag indicating whether changes should be committed immediately.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.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 = ?
termConditionId
- The ID of the terms and conditions.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.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 = ?
termConditionId
- The ID of the terms and conditions.flush
- The flag indicating whether changes should be committed immediately.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.protected void instantiateEJB() throws javax.ejb.CreateException, java.rmi.RemoteException, javax.naming.NamingException
This method instantiates the specified EJB
instantiateEJB
in class com.ibm.ivj.ejb.runtime.AbstractAccessBean
javax.ejb.CreateException
- The javax.ejb.CreateException exceptionjava.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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
name
- The name of the contract.memberId
- The ID of the owner member.origin
- The origin of the contract.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.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
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.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.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 = ?
storeId
- The ID of the store.contractId
- The ID of the contract.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.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 = ?
storeId
- The ID of the store.contractId
- The ID of the contract.flush
- The flag indicating whether changes should be committed immediately.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.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 = ?
contractId
- The ID of the contract.comments
- The comments of the contract.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.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 = ?
contractId
- The ID of the contract.comments
- The comments of the contract.flush
- The flag indicating whether changes should be committed immediately.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.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 = ?
participantId
- The ID of the participant.information
- The information associated with the participant.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.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 = ?
participantId
- The ID of the participant.information
- The information associated with the participant.flush
- The flag indicating whether changes should be committed immediately.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.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 = ?
policyId
- The ID of the policy.languageId
- The ID of the language associated with the policy description.description
- The description of the policy.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.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 = ?
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.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.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 = ?
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.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.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 = ?
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.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.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 = ?
termConditionId
- The ID of the terms and conditions.stringField1
- The string field associated with the terms and conditions.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.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 = ?
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.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.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 = ?
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.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.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 = ?
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.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.
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |