What is the Transaction Attribute on ur Methods?
If u have the update/insert and select in the same method and have a "Required" tx attribute, you are not committing the changes as they are in the same method. Change your Tx Attribute or split your insert/update and select into different methods.
I'm using one method for update and another for select where the first calls the other. Both methods use a Required transaction and I can't break this transaction!
If u have a Stateless bean doing the calls for updates/selects, create a method for updates and make that run with a "RequiresNew" attribute. This way, your updates will be commited (coz of a RequiresNew) and the Select which happens in another method would get the new values. So methodA in SLSB calls update() followed by select() and update() is a RequiresNew method.
I'm running in a similar problem with JBoss 3.2.2RC3 and set the transactual attribute to RequiresNew already. This doesn't work. Is there a known problem?