The short answer is that I'd like to be able to coerce my CMP container to
generate and execute the SQL I would write, if I was hand-coding a
well-tuned application. This includes not only "what" SQL, but "when" the
SQL is executed. Which tricks are important depends upon the customer and
the specific application.
Here are some that come to mind:
* Ability to fetch related beans (or dependent objects) using a database
join or a separate query, based on a switch
* If issuing separate queries, I want the control to execute the dependent
query immediately, or when I navigate the relationship (lazily)
* Ability to map more than one table to a single EJB, for 1:1 relationships
* Bulk fetching for finders that return collections
* Option to do bulk dependent object fetching (fetching all children of all
parents retrieved in an earlier bulk fetch)
* Bulk inserts managed by the container, based upon transaction boundaries
* intelligent (eliminating unnecessary DB hits) implementations of ejbLoad()
and ejbStore() including UPDATES that are issued to mutate only the columns
whose data has truly been modified in the bean
* above implies support for exclusive (EJB server is only mutator) access to
DB. Obviously, shared access must also be supported.
* no pollution (vendor specific code) in my EJB java source -- not even
imports.
* ability to pin beans into the cache
* ability to specify cache-only queries
* a robust UI for developing and tweaking all of the above AND generating
DDs from the bean java source.
* cache coordination across clustered servers
-Tom Larson
-----Original Message-----
From: Evan Ireland [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 20, 2001 5:55 PM
To: Larson, Tom
Cc: [EMAIL PROTECTED]
Subject: Re: How to use CMP for complex query
"Larson, Tom" wrote:
>
> ...
>
> I say we should demand 100% compliance with open standards such as J2EE,
> then we should purchase from the vendors who implement them in the ways
that
> work best for us. If that means we become dependent on a vendor (BEA
> because we like WebLogic's clustering solution, or WebGain because we like
> the TopLink container) then so be it. I have no problem depending on a
> better implementation of the standard -- as long as the extended features
> are made available behind the J2EE APIs.
So perhaps you could share with us what "extended features" you would like
to
see in products in relation to CMP.
____________________________________________________________________________
____
Evan Ireland Sybase EAServer Engineering
[EMAIL PROTECTED]
Wellington, New Zealand +64 4
934-5856
**************************************************************************
The Information transmitted herewith is sensitive information intended only
for use to the individual or entity to which it is addressed. If the reader
of this message is not the intended recipient, you are hereby notified that
any review, retransmission, dissemination, distribution, copying or other
use of, or taking of any action in reliance upon, this information is
strictly prohibited. If you have received this communication in error,
please contact the sender and delete the material from your computer.
===========================================================================
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".
