your middleware layer (servlets/JSPs in the canonical Sun model). Since the
forthcoming JDBC 3.0 Spec requires/suggests that vendors provide connection
pooling directly inside the driver, and since the middleware (servlet/JSP)
layer automatically provides a centralized place from which connections can
be pooled, I fail to see what EJB buys you at this point.
Ted Neward
|| Java Course Author & Instructor, DevelopMentor
(http://www.develop.com)
http://www.javageeks.com/tneward
----- Original Message -----
From: "Ashwani Kalra" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 01, 2002 2:51 AM
Subject: Re: [EJB-INT] EJB and Stored-Procedures
> There is no other choice then to use DAO IMO. if you want to use stored
> procedures. Or other way is if you want to use the app server features
then
> you can go for BMP. There you have all the control in your hand.
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Cheers
> Ashwani Kalra
> Sr. Mem. Dev. Staff
> Aithent Technologies
> India
> http://www.geocities.com/ashwani_kalra/
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
> -----Original Message-----
> From: A mailing list for Enterprise JavaBeans development
> [mailto:[EMAIL PROTECTED]]On Behalf Of
> [EMAIL PROTECTED]
> Sent: Friday, February 01, 2002 2:47 PM
> To: [EMAIL PROTECTED]
> Subject: Re: EJB and Stored-Procedures
>
>
> All,
>
> One of the reasons why we use stored proc, is for
> security reason. No users have an INSERT, UPDATE, or DELETE
> access, they are DBA ( and developer ) privilege access.
> The other one is, as Ted wrote, is for speed issues when
> retrieving data.
> Our stored proc could be just a single SELECT statement,
> or a very complex one, i.e. create one temp table ( or more ),
> grouping, sorting, do a bit calculation, put the result into
> another temp table, indexing, etc, etc.
>
> Any other ideas please ?
>
> Thanks,
> Benoit Aumars.
>
>
> -----Original Message-----
This message was posted using eunum
To interact with a real-time, threaded interface to this e-mail list, clickthe link below:
EJB-INTEREST
