com.github.drinkjava2.jtransactions.grouptx.GroupTxConnectionManager Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of jsqlbox Show documentation
jSqlBox is a full function DAO tool
There is a newer version: 5.0.15.jre8
/*
 * Licensed to the Apache Software Foundation (ASF) under one or more
 * contributor license agreements. See the NOTICE file distributed with this
 * work for additional information regarding copyright ownership. The ASF
 * licenses this file to You under the Apache License, Version 2.0 (the
 * "License"); you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
 * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
 * License for the specific language governing permissions and limitations under
 * the License.
 */
package com.github.drinkjava2.jtransactions.grouptx;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;
import java.util.Map.Entry;

import javax.sql.DataSource;

import com.github.drinkjava2.jtransactions.ConnectionManager;
import com.github.drinkjava2.jtransactions.TransactionsException;

/**
 * DataSourceManager determine how to get or release connection from DataSource,
 * it can be different transaction strategies like JDBC/SpringManaged/JTA..
 * 
 * @author Yong Zhu
 * @since 1.0.0
 */
public class GroupTxConnectionManager implements ConnectionManager {
	private int transactionIsolation = Connection.TRANSACTION_READ_COMMITTED;
	DataSource[] dataSources;

	public GroupTxConnectionManager(DataSource... dataSources) {
		this.dataSources = dataSources;
	}

	public GroupTxConnectionManager(Integer transactionIsolation, DataSource... dataSources) {
		this.transactionIsolation = transactionIsolation;
		this.dataSources = dataSources;
	}

	private ThreadLocal inTransation = new ThreadLocal() {
		@Override
		protected Boolean initialValue() {
			return false;
		}
	};

	private ThreadLocal> threadLocalConnections = new ThreadLocal>() {
		@Override
		protected Map initialValue() {
			return new HashMap();
		}
	};

	public boolean isInGroupTransaction() {
		return inTransation.get();
	}

	public void startGroupTransaction() {
		inTransation.set(true);
	}

	public void endGroupTransaction() {
		inTransation.set(false);
		Map map = threadLocalConnections.get();
		if (map == null)
			return;
		SQLException lastExp = null;

		for (Entry entry : map.entrySet())
			try {
				entry.getValue().setAutoCommit(true); // restore auto commit
			} catch (SQLException e) {
				if (lastExp != null)
					e.setNextException(lastExp);
				lastExp = e;
			}

		for (Entry entry : map.entrySet())
			try {
				entry.getValue().close(); // Close
			} catch (SQLException e) {
				if (lastExp != null)
					e.setNextException(lastExp);
				lastExp = e;
			}

		map.clear();
		if (lastExp != null)
			throw new TransactionsException(lastExp);
	}

	public void commitGroupTx() {
		if (!isInGroupTransaction())
			return;
		try {
			Map map = threadLocalConnections.get();
			if (map == null)
				return;
			SQLException lastExp = null;
			for (Entry entry : map.entrySet()) {
				Connection conn = entry.getValue();
				try {
					conn.commit();
					if (lastExp != null)
						conn.rollback();
				} catch (SQLException e) {
					if (lastExp != null)
						e.setNextException(lastExp);
					lastExp = e;
				}
			}
			if (lastExp != null)
				throw new TransactionsException(lastExp);
		} finally {
			endGroupTransaction();
		}
	}

	public void rollbackGroupTx() {
		if (!isInGroupTransaction())
			return;
		try {
			Map map = threadLocalConnections.get();
			if (map == null)
				return;
			SQLException lastExp = null;
			for (Entry entry : map.entrySet()) {
				Connection conn = entry.getValue();
				try {
					conn.rollback();
				} catch (SQLException e) {
					if (lastExp != null)
						e.setNextException(lastExp);
					lastExp = e;
				}
			}
			if (lastExp != null)
				throw new TransactionsException(lastExp);
		} finally {
			endGroupTransaction();
		}
	}

	@Override
	public boolean isInTransaction(DataSource ds) {
		return isInGroupTransaction();
	}

	@Override
	public Connection getConnection(DataSource ds) throws SQLException {
		TransactionsException.assureNotNull(ds, "DataSource can not be null");
		Connection conn = null;
		if (isInGroupTransaction()) {
			conn = threadLocalConnections.get().get(ds);
			if (conn == null) {
				conn = ds.getConnection(); // NOSONAR Have to get a new connection
				TransactionsException.assureNotNull(conn, "Can not obtain a connection from DataSource");
				conn.setTransactionIsolation(transactionIsolation);
				conn.setAutoCommit(false); // start real transaction
				threadLocalConnections.get().put(ds, conn);
			}
		} else {
			conn = ds.getConnection(); // Have to get a new connection
		}
		TransactionsException.assureNotNull(conn, "Fail to get a connection from DataSource");
		return conn;
	}

	@Override
	public void releaseConnection(Connection conn, DataSource ds) throws SQLException {
		if (isInGroupTransaction()) {
			// Do nothing, because this connection is used in a current thread's transaction
		} else {
			if (conn != null)
				conn.close();
		}
	}

}