Hi,
I m not able to understand that why you are executing query to reteive the value which u have created earlier,
When you insert new record using CMP/BMP by calling ejbCreate(), it return the Component object using that object u can reterive all values
And i tell u why are not getting the result properly,
See application server actually insert/save record into database when the underlying transcation is being commited.
its helps application server when any transcation is roll back
if doesn't solve ur problem then i will suggest u use BMT