8. A method for accessing a database using container managed persistence enterprise Java beans (EJBs), wherein each instance of the container managed persistence enterprise java bean object represents a row of data in the database, the method comprising the steps of: (a) receiving a single EJB select method at a container managed persistence EJB object to access data of one or more container managed persistence 2 EJB objects, (b) translating an EJB query language (EJBQL) query of said single EJB select method into a target language query of said database wherein said EJBQL query comprises an EJBQL subquery, and wherein said EJBQL query comprises a SELECT clause, wherein said SELECT clause comprises an aggregate function and permits selecting multiple fields from multiple EJB object types; (c) retrieving data from said database using said target language query, wherein retrieving data from said database comprises bypassing a bean representation of the requested data; (d) saving said data as a result set object containing the retrieved data in response to the target language query; and (e) allowing access to said result set object to retrieve said data.
8. A method for accessing a database using container managed persistence enterprise Java beans (EJBs), wherein each instance of the container managed persistence enterprise java bean object represents a row of data in the database, the method comprising the steps of: (a) receiving a single EJB select method at a container managed persistence EJB object to access data of one or more container managed persistence 2 EJB objects, (b) translating an EJB query language (EJBQL) query of said single EJB select method into a target language query of said database wherein said EJBQL query comprises an EJBQL subquery, and wherein said EJBQL query comprises a SELECT clause, wherein said SELECT clause comprises an aggregate function and permits selecting multiple fields from multiple EJB object types; (c) retrieving data from said database using said target language query, wherein retrieving data from said database comprises bypassing a bean representation of the requested data; (d) saving said data as a result set object containing the retrieved data in response to the target language query; and (e) allowing access to said result set object to retrieve said data. 12. The method of claim 8 , wherein an aggregate function comprises one of MIN(x), MAX(x), AVG([DISTINCT]x), SUM([DISTINCT]x) and COUNT([DISTINCT]x).