do Stored Procedures preclude using CMP? Also, how does EJQL work?

From: Nikita Tovstoles (nikita.tovstoles_at_alumni.duke.edu)
Date: 08/04/04 

Date: Wed, 04 Aug 2004 16:16:46 GMT

Hi,

I recently read at http://j2eeadvisor.com/doc/14180 that sometimes it is
beneficial (performance-wise) to use stored procedures in J2EE apps for
more complex queries (i guess instead of entity finder methods). but
does using stored procedures force one to abandon CMP, and use BMP?

on that note, what does an AS do with EJQL queries? Are they:
-translated into SQL which is then executed by RDBMS
-executed by the AS itself (thereby possibly resulting in multiple
queries to RDBMS
-other?

thanks a lot
-nikita

Relevant Pages

  • Re: Access migration to SQL Server
    ... caveat in the first sentence, i.e. remove access all together and you don't ... > about having to convert all your queries to views and stored procedures. ... > using a named query parameter to look up a value from a form control and ...
    (microsoft.public.access.conversion)
  • Re: Access migration to SQL Server
    ... caveat in the first sentence, i.e. remove access all together and you don't ... > about having to convert all your queries to views and stored procedures. ... > using a named query parameter to look up a value from a form control and ...
    (microsoft.public.sqlserver.server)
  • Re: Off Topic - Access to Postgres
    ... >>However, I find that using views, stored procedures and pass through queries ... >procedures and pass-through queries. ... >The reason pass-through queries are a problem for Access (and stored ... - To the extent that your application relies on server-side objects, ...
    (comp.databases.ms-access)
  • Re: Off Topic - Access to Postgres
    ... If sprocs and pass through queries are not the solution then ... >However, I find that using views, stored procedures and pass through queries ... The reason pass-through queries are a problem for Access (and stored ... may have to create a saved pass-through query, ...
    (comp.databases.ms-access)
  • Re: queries Vs Stored Procs
    ... > queries in one stored procedure rule. ... > should put each branch into its own stored procedures. ... to have a chain of Procs rather than a chain of queries. ... a single procedure can execute and use the results from several ...
    (microsoft.public.sqlserver.programming)