com.ibm.commerce.order.objects

Class OIConfigJDBCHelperBean

java.lang.Object

com.ibm.commerce.base.helpers.BaseJDBCHelper

com.ibm.commerce.order.objects.OIConfigJDBCHelperBean

public class OIConfigJDBCHelperBean
extends BaseJDBCHelper

This is the JDBC Helper class used to access OICONFIG table.

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	COPYRIGHT IBM copyright notice field.

Fields inherited from class com.ibm.commerce.base.helpers.BaseJDBCHelper

autoFlush, DB_AS400, DB_DB2, DB_DB2_390, DB_DB2J, DB_ORACLE

Constructor Summary

Constructors

Constructor and Description
OIConfigJDBCHelperBean()

Method Summary

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 column of OICONFIG table for the specified order item id.

Methods inherited from class com.ibm.commerce.base.helpers.BaseJDBCHelper

buildCommaSeparatedWhereClause, convertResultSetToTable, flush, flush, getCharacterStreamFromResultSet, getDataSource, getDataSource, getInQueryClause, getObject, getObject, getObject, getSavedOptCounterInfoForDelete, getSavedOptCounterInfoForOptimisticSelect, getSavedOptCounterInfoForUpdate, init, init, useCloudscape, useDB2_390, useDB2_400, useDB2, useOracle, useOracle9

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

COPYRIGHT

public static final java.lang.String COPYRIGHT

IBM copyright notice field.

See Also:

Constant Field Values

Constructor Detail

OIConfigJDBCHelperBean

public OIConfigJDBCHelperBean()

Method Detail

getSessionContext

public javax.ejb.SessionContext getSessionContext()

getSessionContext method comment

Returns:

SessionContext

findConfigurationByOrderItemId

public java.lang.String findConfigurationByOrderItemId(long orderItemId)
                                                throws ECSystemException,
                                                       javax.naming.NamingException,
                                                       java.sql.SQLException

This method queries OICONFIG table to retrieve configuration by order item id.

Parameters:

orderItemId - the order item id.

Returns:

the value of configuration in String type.

Throws:

ECSystemException

javax.naming.NamingException

java.sql.SQLException

updateOrderItemConfiguration

public int updateOrderItemConfiguration(long orderItemId,
                                        java.lang.String configurationXML)
                                 throws ECSystemException,
                                        javax.naming.NamingException,
                                        java.sql.SQLException

This method updates CONFIGURATION column of OICONFIG table for the specified order item id.

Parameters:

orderItemId - the order item id.

configurationXML - the new value of CONFIGURATION column.

Returns:

the count of row that is updated.

Throws:

ECSystemException

javax.naming.NamingException

java.sql.SQLException

insertOrderItemConfiguration

public int insertOrderItemConfiguration(long oiConfigId,
                                        long orderItemId,
                                        java.lang.String configurationXML)
                                 throws ECSystemException,
                                        javax.naming.NamingException,
                                        java.sql.SQLException

This method inserts a new row into OICONFIG table with the specified oiConfigId, orderItemId and configuration.

Parameters:

oiConfigId - the value of OICONFIG_ID column

orderItemId - the value of ORDERITEMS_ID column

configurationXML - the value of CONFIGURATION column

Returns:

the count of row that is inserted.

Throws:

ECSystemException

javax.naming.NamingException

java.sql.SQLException