Hi all, I am new to Orion. I am facing a major problem with transaction in orion. I wrote a simple session bean to insert record into a MYSQL database. I have given the transaction attribute as REQUIRED in the deployment descriptor. In the single insert() method, I am doing two sql inserts(to check transaction). So when I call the insert once, It will insert two records with consecutive IDs(Primary key). So if a record exits with the second ID, the whole transaction is supposed to roll back... But unfortunately it is not getting rolled back. The first record is getting committed. Could anyone please help me out on this.
Thanks George