I am looking for a database caching software that works with EJB (either CMP
or BMP).
The system needs to support caching SQL result sets for
1. Simple SQL
2. Complex SQL involving multiple table joins
3. Stored Procedure possibly returning multiple result set (a feature of
Sybase Server)
4. A mechanism to update the cache
5. Cache Mangement (LRU algorithm, Cache faulting,...)
6. Paging support (If Stored procedure returns a 100000 rows, the API should
allow client to get a subset of the data as soon as it is available (say as
soon as first 50 rows are processed). The client should be able to ask for
next page (next 50) which should come from the cache.
I looked at TopLink, but it does not support caching for Stored Procedure
since it returns one or more objects. Only object level caching is supported
(someone please correct me if I am wrong).
I also looked at TimesTen's Front-Tier, but the software main strength is
the ability to do complex queries on cached data. They do not support Stored
Procedure, Paging and so on (again, please correct me if I am wrong)
Suggestion anyone!!!!!
Thanks in advance....
Indy
_______________________________________________________
Send a cool gift with your E-Card
http://www.bluemountain.com/giftcenter/
===========================================================================
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".
