com.ibm.commerce.taxation.objects
Class StateProvinceAccessBean

java.lang.Object
  |
  +--com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
        |
        +--com.ibm.commerce.taxation.objects.StateProvinceAccessBean
All Implemented Interfaces:
StateProvinceAccessBeanData

public class StateProvinceAccessBean
extends com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
implements StateProvinceAccessBeanData

This table lists State and Province names (by country or region) in each of the supported Languages identified by LANGUAGE_ID.

See Also:
Serialized Form

Constructor Summary
StateProvinceAccessBean()
          constructor
StateProvinceAccessBean(javax.ejb.EJBObject o)
          constructor
 
Method Summary
 void commitCopyHelper()
          Update(flush) data to the EJBObject (persistent storage).
protected  java.lang.String defaultJNDIName()
           
 java.util.Enumeration findByCountryNameAndLanguageId(java.lang.String arg0, java.lang.Integer arg1)
          Retrieves all the states or provinces for the indicated country and language.
 java.util.Enumeration findByLanguageIdAndState(java.lang.Integer arg0, java.lang.String arg1)
          Retrieves all the states or provinces for the indicated country and language.
 java.util.Enumeration findByLanguageIdAndStateName(java.lang.Integer arg0, java.lang.String arg1)
          Retrieves all the states or provinces for the indicated country and language.
 java.util.Enumeration findByLanguageIdStateAbbrAndCountryAbbr(java.lang.Integer arg0, java.lang.String arg1, java.lang.String arg2)
          Retrieves all the states or provinces for the indicated country and language.
 java.util.Enumeration findByLanguageIdStateAndCountryAbbr(java.lang.Integer arg0, java.lang.String arg1, java.lang.String arg2)
          Retrieves all the states or provinces for the indicated state, country abbreviation and language.
 java.util.Enumeration findByLanguageIdStateNameAndCountryAbbr(java.lang.Integer arg0, java.lang.String arg1, java.lang.String arg2)
          Retrieves all the states or provinces for the indicated country and language.
 java.util.Enumeration findByNameAndCountryAbbreviationCode(java.lang.String arg0, java.lang.String arg1)
          Retrieves all the states or provinces for the indicated country and language.
 java.lang.String getCountryAbbr()
          This method accesses a non-CMP field
 java.lang.String getLanguageId()
          This method accesses a non-CMP field
 java.lang.Integer getLanguageIdInEJBType()
          This method accesses a non-CMP field
 java.lang.String getName()
          This method accesses a non-CMP field
 java.lang.String getStateAbbr()
          This method accesses a non-CMP field
protected  void instantiateEJB()
           
protected  boolean instantiateEJBByPrimaryKey()
           
 void refreshCopyHelper()
          Load data from the EJBObject.
 void setCountryAbbr(java.lang.String newValue)
          This method accesses a non-CMP field
 void setInitKey_nLanguageId(java.lang.String newValue)
          Set the primary key for this object
 void setInitKey_strStateAbbr(java.lang.String newValue)
          Set the primary key for this object
 void setLanguageId(java.lang.Integer newValue)
          This method accesses a non-CMP field
 void setLanguageId(java.lang.String newValue)
          This method accesses a non-CMP field
 void setName(java.lang.String newValue)
          This method accesses a non-CMP field
 void setStateAbbr(java.lang.String newValue)
          This method accesses a non-CMP field
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

StateProvinceAccessBean

public StateProvinceAccessBean()
constructor

StateProvinceAccessBean

public StateProvinceAccessBean(javax.ejb.EJBObject o)
                        throws java.rmi.RemoteException
constructor
Parameters:
o - javax.ejb.EJBObject
Throws:
java.rmi.RemoteException
Method Detail

findByCountryNameAndLanguageId

public java.util.Enumeration findByCountryNameAndLanguageId(java.lang.String arg0,
                                                            java.lang.Integer arg1)
                                                     throws java.rmi.RemoteException,
                                                            javax.ejb.FinderException,
                                                            javax.naming.NamingException

Retrieves all the states or provinces for the indicated country and language.

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

SELECT * FROM STATEPROV T1 WHERE T1.COUNTRYABBR = ANY (SELECT COUNTRY.COUNTRYABBR FROM COUNTRY WHERE COUNTRY.NAME = ? AND COUNTRY.LANGUAGE_ID = T1.LANGUAGE_ID) AND T1.LANGUAGE_ID = ?

Returns:
java.util.Enumeration of all the StateProvinceAccessBeans representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

findByLanguageIdAndState

public java.util.Enumeration findByLanguageIdAndState(java.lang.Integer arg0,
                                                      java.lang.String arg1)
                                               throws java.rmi.RemoteException,
                                                      javax.ejb.FinderException,
                                                      javax.naming.NamingException

Retrieves all the states or provinces for the indicated country and language.

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

SELECT * FROM STATEPROV T1 WHERE T1.LANGUAGE_ID=? AND ((T1.NAME=?) OR (T1.STATEPROVABBR=?))

Returns:
java.util.Enumeration of all the StateProvinceAccessBeans representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

findByLanguageIdAndStateName

public java.util.Enumeration findByLanguageIdAndStateName(java.lang.Integer arg0,
                                                          java.lang.String arg1)
                                                   throws java.rmi.RemoteException,
                                                          javax.ejb.FinderException,
                                                          javax.naming.NamingException

Retrieves all the states or provinces for the indicated country and language.

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

SELECT * FROM STATEPROV T1 WHERE T1.LANGUAGE_ID=? AND T1.NAME=?

Returns:
java.util.Enumeration of all the StateProvinceAccessBeans representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

findByLanguageIdStateAbbrAndCountryAbbr

public java.util.Enumeration findByLanguageIdStateAbbrAndCountryAbbr(java.lang.Integer arg0,
                                                                     java.lang.String arg1,
                                                                     java.lang.String arg2)
                                                              throws java.rmi.RemoteException,
                                                                     javax.ejb.FinderException,
                                                                     javax.naming.NamingException

Retrieves all the states or provinces for the indicated country and language.

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

SELECT * FROM STATEPROV T1 WHERE T1.LANGUAGE_ID=? AND T1.STATEPROVABBR=? AND T1.COUNTRYABBR=?

Returns:
java.util.Enumeration of all the StateProvinceAccessBeans representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

findByLanguageIdStateAndCountryAbbr

public java.util.Enumeration findByLanguageIdStateAndCountryAbbr(java.lang.Integer arg0,
                                                                 java.lang.String arg1,
                                                                 java.lang.String arg2)
                                                          throws java.rmi.RemoteException,
                                                                 javax.ejb.FinderException,
                                                                 javax.naming.NamingException

Retrieves all the states or provinces for the indicated state, country abbreviation and language.

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

SELECT * FROM STATEPROV WHERE T1.LANGUAGE_ID=? AND ((T1.NAME=?) OR (T1.STATEPROVABBR=?)) AND (T1.COUNTRYABBR=?)

Returns:
java.util.Enumeration of all the StateProvinceAccessBeans representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

findByLanguageIdStateNameAndCountryAbbr

public java.util.Enumeration findByLanguageIdStateNameAndCountryAbbr(java.lang.Integer arg0,
                                                                     java.lang.String arg1,
                                                                     java.lang.String arg2)
                                                              throws java.rmi.RemoteException,
                                                                     javax.ejb.FinderException,
                                                                     javax.naming.NamingException

Retrieves all the states or provinces for the indicated country and language.

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

SELECT * FROM STATEPROV T1 WHERE T1.LANGUAGE_ID=? AND T1.NAME=? AND T1.COUNTRYABBR=?

Returns:
java.util.Enumeration of all the StateProvinceAccessBeans representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

findByNameAndCountryAbbreviationCode

public java.util.Enumeration findByNameAndCountryAbbreviationCode(java.lang.String arg0,
                                                                  java.lang.String arg1)
                                                           throws java.rmi.RemoteException,
                                                                  javax.ejb.FinderException,
                                                                  javax.naming.NamingException

Retrieves all the states or provinces for the indicated country and language.

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

SELECT * FROM STATEPROV T1 T1.NAME=? AND T1.COUNTRYABBR=?

Returns:
java.util.Enumeration of all the StateProvinceAccessBeans representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

setInitKey_nLanguageId

public void setInitKey_nLanguageId(java.lang.String newValue)

Set the primary key for this object

Parameters:
newValue - java.lang.String
Returns:
void

setInitKey_strStateAbbr

public void setInitKey_strStateAbbr(java.lang.String newValue)

Set the primary key for this object

Parameters:
newValue - java.lang.String
Returns:
void

defaultJNDIName

protected java.lang.String defaultJNDIName()
Returns:
String

instantiateEJB

protected void instantiateEJB()
                       throws java.rmi.RemoteException,
                              javax.ejb.FinderException,
                              javax.naming.NamingException
Returns:
void
Throws:
java.rmi.RemoteException
javax.ejb.FinderException
javax.naming.NamingException

instantiateEJBByPrimaryKey

protected boolean instantiateEJBByPrimaryKey()
                                      throws java.rmi.RemoteException,
                                             javax.ejb.CreateException,
                                             javax.naming.NamingException
Returns:
boolean
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.naming.NamingException

commitCopyHelper

public void commitCopyHelper()
                      throws java.rmi.RemoteException,
                             javax.ejb.CreateException,
                             javax.ejb.FinderException,
                             javax.naming.NamingException

Update(flush) data to the EJBObject (persistent storage).

Returns:
void
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

refreshCopyHelper

public void refreshCopyHelper()
                       throws java.rmi.RemoteException,
                              javax.ejb.CreateException,
                              javax.ejb.FinderException,
                              javax.naming.NamingException

Load data from the EJBObject.

Returns:
void
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getLanguageId

public java.lang.String getLanguageId()
                               throws java.rmi.RemoteException,
                                      javax.ejb.CreateException,
                                      javax.ejb.FinderException,
                                      javax.naming.NamingException
This method accesses a non-CMP field
Specified by:
getLanguageId in interface StateProvinceAccessBeanData
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getLanguageIdInEJBType

public java.lang.Integer getLanguageIdInEJBType()
                                         throws java.rmi.RemoteException,
                                                javax.ejb.CreateException,
                                                javax.ejb.FinderException,
                                                javax.naming.NamingException
This method accesses a non-CMP field
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setLanguageId

public void setLanguageId(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setLanguageId in interface StateProvinceAccessBeanData

setLanguageId

public void setLanguageId(java.lang.Integer newValue)
This method accesses a non-CMP field

getCountryAbbr

public java.lang.String getCountryAbbr()
                                throws java.rmi.RemoteException,
                                       javax.ejb.CreateException,
                                       javax.ejb.FinderException,
                                       javax.naming.NamingException
This method accesses a non-CMP field
Specified by:
getCountryAbbr in interface StateProvinceAccessBeanData
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setCountryAbbr

public void setCountryAbbr(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setCountryAbbr in interface StateProvinceAccessBeanData

getStateAbbr

public java.lang.String getStateAbbr()
                              throws java.rmi.RemoteException,
                                     javax.ejb.CreateException,
                                     javax.ejb.FinderException,
                                     javax.naming.NamingException
This method accesses a non-CMP field
Specified by:
getStateAbbr in interface StateProvinceAccessBeanData
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setStateAbbr

public void setStateAbbr(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setStateAbbr in interface StateProvinceAccessBeanData

getName

public java.lang.String getName()
                         throws java.rmi.RemoteException,
                                javax.ejb.CreateException,
                                javax.ejb.FinderException,
                                javax.naming.NamingException
This method accesses a non-CMP field
Specified by:
getName in interface StateProvinceAccessBeanData
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setName

public void setName(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setName in interface StateProvinceAccessBeanData