CMP Commit Option A Cache Question

hunterhillegas Dec 9, 2002 10:23 PM

I have an application that uses CMP Entities in Commit Option A. I am testing it on JBoss 3.2 beta 2.

The app uses session facades and servlet+JSP to display the data.

I have a JSP page that displays a list of hotels. It includes a servlet that calls a SLSB to do a findAll() on the Hotel entity. The SLSB returns value objects that represent the entities.

I have my database logging turned all the way up so I can see what queries are executing.

The first time I run this, I see a query that loads all of the entities. This is to be expected.

The thing is, I see this on subsequent requests as well. Shouldn't this all be in the CMP cache since I am using option A? Why would it be going back to the database?

Trying to figure out if we have a design problem with our application.

Thanks,
Hunter

1. Re: CMP Commit Option A Cache Question

dsundstrom Dec 10, 2002 4:29 PM (in response to hunterhillegas)

Hunter,

JBoss does not have an in memory query engine, so all queries must go directly to the database. The only exception is findByPrimary key, which first checks if the bean is live in the cache.

Bill Burke sent me an example of a query results cache that caches query results for commit option A until an entity is modified in the query domain. Then the cache is flushed. I haven't looked at the code yet, but I plan on integrateing it as an option in 4.0.
Actions
2. Re: CMP Commit Option A Cache Question

hunterhillegas Dec 11, 2002 6:03 PM (in response to hunterhillegas)

Thanks for the response...

4.0 is sounding more and more sweet every day...
Actions

Go to original post