I am using JBOSS 2.4.4 and connecting to a SQL 2000 Database using a JSQLConnect driver. I have a Session bean which has contanier managed transaction. This bean is concurrently called by two clients. Now when one of the transactions here rolls back the other one is also affected and my updates in the other transactions fail. But the data in the database is inconsistent. Looks like there is a bug in the transaction component and this is causing lot of problems to me as the application is not reliable in a multi user environment.
Is there a fix or patch that can be applied? Or should i upgrade to latest version of JBOSS and if so is this problem resolved there??