Hi all, I have transaction management problem with DAO Pattern. This is just a test implementation of DAO. I am using JBOSS 3.0 and Oracle 8i with Thin Driver. I have a table Customer with two fields
CUSTOMER_ID NUMBER PRIMARY KEY CUSTOMER_NAME VARCHAR2(50) I have a DAO which will update this table. In my Stateless Session bean I have called 2 times the same DAO. Since the primary key is same for both records I get PRIMARY KEY violated exception. This is correct. But when I see the data in the table, the firt record is already committed. Data is not getting rolled back when there is a exception. I have set the transaction attribute as REQUIRED for this bean. Please let me know what would be the problem. Do I need to do any other extra thing? Is there any thing to configure in Connection Pool? Can anybody please look into this.... Thanks in advance, Prasanna anonymous wrote : <a href="http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3825215#3825215">View the original post</a> <a href="http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3825215>Reply to the post</a> ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user