Hi all,

I seem to be having a problem where the JBoss cache is out of sync with the DB.

--> viewing the DB shows one set of values
--> calling findByPrimaryKey retrieves a bean with a different set of values.

I am using Commit option A where JBoss "owns" the DB, and *definitely* only using entity beans to change the DB, i.e. no direct SQL execute against the DB.

The problem can be reproduced this way:

1. BMPBean.create()
-- e.g. values: (key=1, col1=null, col2=null)

2. MDBBean.onMessage() --> calls stateless session bean --> retrieves bean from step 1. + changes some values + causes ejbStore to be called.
-- e.g. values: (key=1, col1=X, col2=Y)


3. BMPBean.remove()

4. BMPBean.create() <-- using same key as 1.
-- e.g. values: (key=1, col1=null, col2=null)


5. BMPBean.findByPrimaryKey <-- PROBLEM
-- e.g. values: (key=1, col1=X, col2=Y