How to integrate operations of jpa repository methods i.e. save into xa resource transactions?

Question

I want to make operations performed by crud repository of jpa as part of xa transactions i.e. they should be committed when xa resource is committed.

Following is the code in which save method uses xa resource and saveTeam method uses crud repository method i.e. save. I have tried transaction propagation supported, not_supported, etc parameters but didn't worked

public boolean save() throws Exception {
        OracleXADataSource oracleRootSource = new OracleXADataSource();
        oracleRootSource.setUser("root");
        oracleRootSource.setPassword("root");
        oracleRootSource.setURL("jdbc:oracle:thin:@localhost:1521:xe");
        XADataSource xaDS = oracleRootSource;
        XAConnection xaCon = xaDS.getXAConnection("root", "root");
        XAResource xaRes = xaCon.getXAResource();
        Connection con = xaCon.getConnection();
        Statement stmt = con.createStatement();
        Xid xid = new MyXid(100, new byte[] { 0x01 }, new byte[] { 0x02 });
        xaRes.start(xid, XAResource.TMJOIN);
//      stmt.executeUpdate("Insert into school values ( " + 202 + ", 'Second')"); 
        this.saveTeam(new Team("second"));
        xaRes.end(xid, XAResource.TMSUCCESS);
        return true;
    }

    @Transactional(propagation = Propagation.MANDATORY)
    public Team saveTeam(Team team) {
        Team te = repo.save(team);
        return te;
    }

I want to see changes done by saveTeam method when xresource is commited. currently changes are visible in db when save method is executed in save Team method.

score 0 · Answer 1 · answered Sep 16 '19 at 12:39

0

add this line spring.jpa.show-sql=true in your application.properties file

answered Sep 16 '19 at 12:39

Patrick Kana

1
1

Using spring.jpa.show-sql=true, it shows query but I want to insert/save enitity after xresource is committed. – Akash Jadhav Sep 17 '19 at 04:52
Okay if you want to insert an entity with this method – Patrick Kana Sep 18 '19 at 07:00

How to integrate operations of jpa repository methods i.e. save into xa resource transactions?

1 Answers1