I am using a primary key generator as an entity bean that has the
following transaction defined in my ejb-jar.xml:

<assembly-descriptor>
   <container-transaction>
      <method>
         <ejb-name>PkTable</ejb-name>
         <method-name>getNextId</method-name>
      </method>
      <trans-attribute>RequiresNew</trans-attribute>
   </container-transaction>
</assembly-descriptor>

I have a method in a stateless session bean where I am adding records to a
couple of different entities. If an exception is thrown, the entry to my
pktable is not being committed even though I have explicitly demarcated the
method as RequiresNew.

2 interesting issues: 

Using inet opta's DataSource (com.inet.tds.XDataSource) it fails in that the
pkTable row is not updated, but the entity is created -- really bad because
on the next insert there will be a duplicate key exception.

Using the minerva
DataSource(org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl) the
transaction rolls back on the pktable and the entity that I am trying to
create -- better but this is still not how it should be working.

Any ideas?

I am using Windows2000, Microsoft Sql Server 2000, inet opta driver 2000,
and jboss version 2.2.2.

Thanks in advance,

Kevin Meldorf 
Systems Analyst 
WorldTravel BTI 
400 Skokie Blvd 
Northbrook, IL 60062 
Phone: (847) 480-8340 
[EMAIL PROTECTED] 

_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to