Examples with DataAccessException io.seata.common.exception.DataAccessException used on opensource projects

Example 6 with DataAccessException

use of io.seata.common.exception.DataAccessException in project XHuiCloud by sindaZeng.

the class LockStoreDataBaseDAO method isLockable.

@Override
public boolean isLockable(List<LockDO> lockDOs) {
    Connection conn = null;
    try {
        conn = lockStoreDataSource.getConnection();
        conn.setAutoCommit(true);
        if (!checkLockable(conn, lockDOs)) {
            return false;
        }
        return true;
    } catch (SQLException e) {
        throw new DataAccessException(e);
    } finally {
        IOUtil.close(conn);
    }
}

Example 7 with DataAccessException

use of io.seata.common.exception.DataAccessException in project XHuiCloud by sindaZeng.

the class LockStoreDataBaseDAO method checkLockable.

/**
 * Check lock boolean.
 *
 * @param conn    the conn
 * @param lockDOs the lock do
 * @return the boolean
 */
protected boolean checkLockable(Connection conn, List<LockDO> lockDOs) {
    PreparedStatement ps = null;
    ResultSet rs = null;
    try {
        StringJoiner sj = new StringJoiner(",");
        for (int i = 0; i < lockDOs.size(); i++) {
            sj.add("?");
        }
        // query
        String checkLockSQL = LockStoreSqlFactory.getLogStoreSql(dbType).getCheckLockableSql(lockTable, sj.toString());
        ps = conn.prepareStatement(checkLockSQL);
        for (int i = 0; i < lockDOs.size(); i++) {
            ps.setString(i + 1, lockDOs.get(i).getRowKey());
        }
        rs = ps.executeQuery();
        while (rs.next()) {
            String xid = rs.getString("xid");
            if (!StringUtils.equals(xid, lockDOs.get(0).getXid())) {
                return false;
            }
        }
        return true;
    } catch (SQLException e) {
        throw new DataAccessException(e);
    } finally {
        IOUtil.close(rs, ps);
    }
}

Example 8 with DataAccessException

use of io.seata.common.exception.DataAccessException in project XHuiCloud by sindaZeng.

the class LogStoreDataBaseDAO method getCurrentMaxSessionId.

private long getCurrentMaxSessionId(String sql, long high, long low) {
    long max = 0;
    Connection conn = null;
    PreparedStatement ps = null;
    ResultSet rs = null;
    try {
        conn = logStoreDataSource.getConnection();
        conn.setAutoCommit(true);
        ps = conn.prepareStatement(sql);
        ps.setLong(1, high);
        ps.setLong(2, low);
        rs = ps.executeQuery();
        while (rs.next()) {
            max = rs.getLong(1);
        }
    } catch (SQLException e) {
        throw new DataAccessException(e);
    } finally {
        IOUtil.close(rs, ps, conn);
    }
    return max;
}

Example 9 with DataAccessException

use of io.seata.common.exception.DataAccessException in project XHuiCloud by sindaZeng.

the class LogStoreDataBaseDAO method queryGlobalTransactionDO.

@Override
public GlobalTransactionDO queryGlobalTransactionDO(long transactionId) {
    String sql = LogStoreSqlsFactory.getLogStoreSqls(dbType).getQueryGlobalTransactionSQLByTransactionId(globalTable);
    Connection conn = null;
    PreparedStatement ps = null;
    ResultSet rs = null;
    try {
        conn = logStoreDataSource.getConnection();
        conn.setAutoCommit(true);
        ps = conn.prepareStatement(sql);
        ps.setLong(1, transactionId);
        rs = ps.executeQuery();
        if (rs.next()) {
            return convertGlobalTransactionDO(rs);
        } else {
            return null;
        }
    } catch (SQLException e) {
        throw new DataAccessException(e);
    } finally {
        IOUtil.close(rs, ps, conn);
    }
}

Example 10 with DataAccessException

use of io.seata.common.exception.DataAccessException in project XHuiCloud by sindaZeng.

the class LogStoreDataBaseDAO method queryBranchTransactionDO.

@Override
public List<BranchTransactionDO> queryBranchTransactionDO(String xid) {
    List<BranchTransactionDO> rets = new ArrayList<>();
    String sql = LogStoreSqlsFactory.getLogStoreSqls(dbType).getQueryBranchTransaction(branchTable);
    Connection conn = null;
    PreparedStatement ps = null;
    ResultSet rs = null;
    try {
        conn = logStoreDataSource.getConnection();
        conn.setAutoCommit(true);
        ps = conn.prepareStatement(sql);
        ps.setString(1, xid);
        rs = ps.executeQuery();
        while (rs.next()) {
            rets.add(convertBranchTransactionDO(rs));
        }
        return rets;
    } catch (SQLException e) {
        throw new DataAccessException(e);
    } finally {
        IOUtil.close(rs, ps, conn);
    }
}