>>> On Sun, 20 Feb 2000 11:13:24 +0100,
>>> "Robert" == Robert Kr�ger <[EMAIL PROTECTED]> wrote:
Robert> entity beans are a great tool for manipulating your datamodel and
Robert> for RAD but when it comes to presenting different views on the
Robert> data (i.e. results of queries) efficiently in most cases the best
Robert> thing is to just write that sql.
Just to add fuel to the fire ...
We've been using EBs for data update, but direct SQL from SBs for efficient
querying ... just like you described.
However, we've been bitten by the fact that an EB update does not always
result in an immediate database update (ie. the container may choose to
delay the ejbStore() until later). Thus, subsequent direct-SQL queries
within the same transaction might not see the changes!
--
Mike Williams
http://www.o3.co.uk
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
