我正在JBoss6.1 +中使用CMT尝试访问zos / 390 DB2的一种非常奇怪的行为。

环境是:


JBoss 6.1以上
Linux红帽
在ZOS 390中运行的DB2
EJB3 / JPA2


事务根本不会使用SystemExceptions回滚。
我尝试了BMT,但也无法正常工作。
我的BMT代码如下:

@Stateless
@LocalBean
@TransactionManagement(TransactionManagementType.BEAN)
public class ManterPortabilidadeBean
    implements PortabilidadeService {

    @Inject
    private UserTransaction tx;

    @Override
    public void incluirPortabilidade(...) {
        try {
        tx.begin();

            //insert into database
        daoPortabilidade.incluir(portabilidade);

        if (1==1)
            throw new EJBException("Bingo");

        tx.commit();
        } catch (Exception e) {
        try {
            tx.rollback();
        } catch (Exception e1) {
            // TODO Auto-generated catch block
            e1.printStackTrace();
        }
        }
    }
}


好吧,记录在数据库中!!!难以置信!!!
EJB容器完全忽略,不执行任何操作。

这是CMT代码:

@Stateless
@LocalBean
@TransactionManagement(TransactionManagementType.CONTAINER)
public class ManterPortabilidadeBean
    implements PortabilidadeService {

    @Override
    @TransactionAttribute(TransactionAttributeType.REQUIRED)
    public void incluirPortabilidade(...) {
        //insert into database
        daoPortabilidade.incluir(portabilidade);

        if (1==1)
            throw new EJBException("Bingo");
    }
}


我相信DB2是自动提交的,就像autocommit = true一样,但是配置通知autocommit为false,请参见下面的persistence.xml:

<persistence-unit name="gecDS" transaction-type="JTA">
    <jta-data-source>java:/jdbc/DB2SigecDS</jta-data-source>
    <properties>
        <property name="hibernate.dialect"value="org.hibernate.dialect.DB2390Dialect" />
        <property name="hibernate.default_schema" value="GEC" />
        <property name="hibernate.show_sql" value="true" />
        <property name="hibernate.format_sql" value="true" />
        <property name="hibernate.connection.isolation" value="2" />
        <property name="hibernate.connection.autocommit" value="false"/>
        <property name="javax.persistence.jdbc.driver" value="com.ibm.db2.jcc.DB2Driver" />
    </properties>
</persistence-unit>


我standalone.xml我有此数据源的配置:

<datasource jta="false" jndi-name="java:/jdbc/DB2SigecDS" pool-name="jdbc/DB2SigecDS" enabled="true">
    <connection-url>jdbc:db2://************</connection-url>
    <driver-class>com.ibm.db2.jcc.DB2XADataSource</driver-class>
    <driver>db2</driver>
    <security>
        <user-name>*******</user-name>
        <password>*******</password>
    </security>
</datasource>


任何想法,配置???
谢谢

最佳答案

我发现了奇怪的问题。
只是配置!!!

在数据源属性中,“ jta”必须为true(thx Aramburu),并且我正在使用XADatasource:

<persistence-unit name="gecDS" transaction-type="JTA">
    <jta-data-source>java:/jdbc/DB2SigecDS</jta-data-source>
    <properties>
        <property name="hibernate.dialect" value="org.hibernate.dialect.DB2390Dialect" />
        <property name="hibernate.default_schema" value="GEC" />
        <property name="hibernate.show_sql" value="true" />
        <property name="hibernate.format_sql" value="true" />
        <property name="hibernate.connection.isolation" value="2" />
        <property name="hibernate.connection.autocommit" value="false"/>
        <property name="javax.persistence.jdbc.driver" value="com.ibm.db2.jcc.DB2XADataSource" />
    </properties>
</persistence-unit>


<datasource jta="true" jndi-name="java:/jdbc/DB2SigecDS" pool-name="jdbc/DB2SigecDS" enabled="true">
    <connection-url>jdbc:db2:**************</connection-url>
    <driver-class>com.ibm.db2.jcc.DB2XADataSource</driver-class>
    <driver>db2</driver>
    <security>
        <user-name>???????</user-name>
        <password>???????</password>
    </security>
</datasource>


Thx朋友

10-06 10:03