public class OIConfigJDBCHelperBean extends BaseJDBCHelper
OICONFIG
table.Modifier and Type | Field and Description |
---|---|
static java.lang.String |
COPYRIGHT
IBM copyright notice field.
|
autoFlush, DB_AS400, DB_DB2, DB_DB2_390, DB_DB2J, DB_ORACLE
Constructor and Description |
---|
OIConfigJDBCHelperBean() |
Modifier and Type | Method and Description |
---|---|
java.lang.String |
findConfigurationByOrderItemId(long orderItemId)
This method queries
OICONFIG table to retrieve configuration by order item id. |
javax.ejb.SessionContext |
getSessionContext()
getSessionContext method comment
|
int |
insertOrderItemConfiguration(long oiConfigId,
long orderItemId,
java.lang.String configurationXML)
This method inserts a new row into
OICONFIG table
with the specified oiConfigId, orderItemId and configuration. |
int |
updateOrderItemConfiguration(long orderItemId,
java.lang.String configurationXML)
This method updates
CONFIGURATION |
buildCommaSeparatedWhereClause, convertResultSetToTable, flush, flush, getCharacterStreamFromResultSet, getDataSource, getDataSource, getInQueryClause, getObject, getObject, getObject, getSavedOptCounterInfoForDelete, getSavedOptCounterInfoForOptimisticSelect, getSavedOptCounterInfoForUpdate, init, init, useCloudscape, useDB2_390, useDB2_400, useDB2, useOracle, useOracle9
public static final java.lang.String COPYRIGHT
public javax.ejb.SessionContext getSessionContext()
public java.lang.String findConfigurationByOrderItemId(long orderItemId) throws ECSystemException, javax.naming.NamingException, java.sql.SQLException
OICONFIG
table to retrieve configuration by order item id.orderItemId
- the order item id.ECSystemException
javax.naming.NamingException
java.sql.SQLException
public int updateOrderItemConfiguration(long orderItemId, java.lang.String configurationXML) throws ECSystemException, javax.naming.NamingException, java.sql.SQLException
CONFIGURATION column of OICONFIG
table
for the specified order item id.
orderItemId
- the order item id.configurationXML
- the new value of CONFIGURATION column.
ECSystemException
javax.naming.NamingException
java.sql.SQLException
public int insertOrderItemConfiguration(long oiConfigId, long orderItemId, java.lang.String configurationXML) throws ECSystemException, javax.naming.NamingException, java.sql.SQLException
OICONFIG
table
with the specified oiConfigId, orderItemId and configuration.oiConfigId
- the value of OICONFIG_ID column
orderItemId
- the value of ORDERITEMS_ID column
configurationXML
- the value of CONFIGURATION column
ECSystemException
javax.naming.NamingException
java.sql.SQLException