Have attached the mysql log. You can see where jboss rolls back the transaction. However the select does work returning two rows from the customer table.
4 Query SET autocommit=1
4 Query SHOW VARIABLES LIKE 'tx_isolation'
4 Query SET autocommit=0
4 Query SELECT DISTINCT t0_c.customer_id FROM mvdc_customer t0_c, mvdc_customer_account t1_d WHERE (t1_d.is_active = 0) AND (t0_c.customer_id=t1_d.fk_customer_id)
4 Query SELECT customer_id,name, pword FROM mvdc_customer WHERE (customer_id=2) OR (customer_id=6263)
4 Query rollback
It seems that JBoss is checking the cache for the two primary keys and then throwing an exception when they are not there?
Would appreciate if someone can cast a wise eye over this and give me a pointer.
problem was down to shabby coding in the primary key class.