javax.ejb.*
            java.rmi.*
            javax.naming.*
            

            public class TradeStaticContext
            {
            private static boolean verbose = true;
            static InitialContext _initContext = null;
            static QuoteHome _marketHome = null;
            public static QuoteHome getQuoteHome()
            {
            if (_initContext == null)
            { setContext(); }
            return _marketHome;
            }
            private static synchronized void setContext()
            {
            InitialContext localContext = null;
            //Trade 2.037 - Fixes startup race condition -
            //if _initContext has been set, another thread got here first
            //and has already setup the EJB Homes
            if (_initContext != null)
            return;
            if (verbose)
            {
            System.out.println( "TradeStaticContext.setContext: Setting context" );
            }
            try
            {
            localContext = new InitialContext();
            }
            catch (Exception me)
            {
            System.out.println(
            "TradeStaticContext.setContext: Get InitialContext failed!!");
            me.printStackTrace();
            }
            try
            {
            Object obj = null;
            //?
            obj = localContext.lookup("java:comp/env/ejb/Quote");
            _marketHome =
            (QuoteHome) javax.rmi.PortableRemoteObject.narrow(obj, QuoteHome.class);
            // Trade 2.037: Set _initContext after all EJB Homes have been setup to avoid
            race condition
            _initContext = localContext;
            }
            catch (Exception me)
            {
            System.out.println("TradeStaticContext.setContext: Lookup Homes failed!");
            me.printStackTrace();
            _initContext = null;
            }
            //?
            if (_marketHome == null)
            {
            System.out.println(
            "TradeStaticContext.setContext: Exception creating QuoteHome");
            _initContext = null;
            }
            }
            }

            public class TradeBean implements SessionBean
            {
            public QuoteObject getQuote(String symbol)
            throws RemoteException, TradeException
            {
            //?
            Quote quote = findQuote(symbol);
            }
            private Quote findQuote(String symbol)
            throws RemoteException, TradeException
            {
            //?
            QuoteHome qhome = TradeStaticContext.getQuoteHome();
            retval = qhome.findByPrimaryKey(new QuoteKey(symbol));
            }
            }
            

            public class RegistryFacadeBean implements SessionBean
            {
            // Add user defined business methods here
            public QuoteData getQuote(String symbol)
            {
            QuoteWrapper wQuote = new QuoteCMPWrapper();
            Vector vQuote = wQuote.
            Select( symbol, null, null );
            if( vQuote.size() == 0 )
            return null;
            else
            return ( QuoteData ) vQuote.get( 0 );
            }
            }
            

            Select object(q) from Quote q where q.symbol=?l
            

            Select( symbol, price, null )
            

            Select object(q) from Quote q where q.symbol=?l and q.price=?2
            

            Column                         Type      Type
            name                           schema    name
            ------------------------------ --------- ------------
            USERID                         SYSIBM    VARCHAR
            PASSWORD                       SYSIBM    VARCHAR
            STATUS                         SYSIBM    INTEGER
            

            public class RegistryBean implements EntityBean
            {
            // Container managed fields
            public java.lang.String userid;
            public java.lang.String password;
            public java.lang.Integer status;
            //...
            }
            

            public interface RegistryWrapper
            {
            public Vector Select( RegistryData dRegistry );
            public Vector SelectForUpdate( RegistryData dRegistry );
            public void Insert( RegistryData dRegistry );
            public void Delete();
            public void Update( RegistryData dRegistry );
            }
            

            public class RegistryFacadeBean implements SessionBean
            {
            public Vector Select( RegistryData dRegistry ) {
            RegistryWrapper wRegistry
            = new RegistryCMPWrapper();
            return wRegistry.Select( dRegistry );
            }
            public Vector SelectForUpdate( RegistryData dRegistry )
            { /*...*/ }
            public void Insert( RegistryData dRegistry ) { /*...*/ }
            public void Delete() { /*...*/ }
            public void Update( RegistryData dRegistry ) { /*...*/ }
            // Add user defined business methods here
            }
            

            /**
            * The Select() method maps to the Registry EJB finder method. Initial
            * context is obtained and Home interface is looked up if necessary. The
            * parameters are used as the predicates in the where clause. Any reference to
            * null will be taken away from the clause. For example, a call to
            *
            * 	Select( null, null, 1 )
            *
            * translates to the SQL statement
            *
            * 	select * from Registry where status = 1
            */
            public Vector Select(java.lang.String userid, java.lang.String password, java.lang.Integer status);
            /**
            * Same as above except parameters are passed in form of RegistryData
            * wrapper.
            */
            public Vector Select(RegistryData data);
            /**
            * The Insert() method maps to the Registry EJB create method. Initial
            * context is obtained and Home interface is looked up if necessary. The
            * parameters are the data to be inserted to the underlying table.
            */
            public void Insert(java.lang.String userid, java.lang.String password, java.lang.Integer status)
            throws javax.ejb.CreateException, java.rmi.RemoteException;
            /**
            * Same as above except parameters are passed in form of RegistryData
            * wrapper.
            */
            public void Insert(RegistryData data)
            throws javax.ejb.CreateException, java.rmi.RemoteException;
            /**
            * The Delete() method maps to the Registry EJB remove method. Initial
            * context is obtained and Home interface is looked up if necessary. The
            * Select() method must be called beforehand with resultset not null
            */
            public void Delete();
            /**
            * The Update() method maps to the Registry EJB setter methods. Initial
            * context is obtained and Home/Remote interface is looked up if necessary. The
            * parameters contain the updated data for the current row(s). The
            * Select() method must be called beforehand with resultset not null
            */
            public void Update(java.lang.String userid, java.lang.String password, java.lang.Integer status);
            /**
            * Same as above except parameters are passed in form of RegistryData
            * wrapper.
            */
            public void Update(RegistryData data);