Java JDBCConnectionException类代码示例

import org.hibernate.exception.JDBCConnectionException; //导入依赖的package包/类
public void retry(Runnable run) {
	for (long retry = this.retry; retry > 0; retry--) {
		try {
			run.run();
			retry = -1;
		} catch (JDBCConnectionException e) {
			clearSessionFactory();
			if (retry > 0) {							
				log.debug("(SecurityTokenManager) JDBCConnectionException for removeExpired, retry left: " + retry);
				ThreadUtils.sleep(200);
			} else {
				log.warn("(SecurityTokenManager) JDBCConnectionException for removeExpired, no more retry", e);
			}					
		}
	}
}
 

import org.hibernate.exception.JDBCConnectionException; //导入依赖的package包/类
@Override
public SQLExceptionConversionDelegate buildSQLExceptionConversionDelegate() {
	return new SQLExceptionConversionDelegate() {
		@Override
		public JDBCException convert(SQLException sqlException, String message, String sql) {
			final int errorCode = JdbcExceptionHelper.extractErrorCode(sqlException);
			if (errorCode == SQLITE_TOOBIG || errorCode == SQLITE_MISMATCH) {
				return new DataException(message, sqlException, sql);
			} else if (errorCode == SQLITE_BUSY || errorCode == SQLITE_LOCKED) {
				return new LockAcquisitionException(message, sqlException, sql);
			} else if ((errorCode >= SQLITE_IOERR && errorCode <= SQLITE_PROTOCOL) || errorCode == SQLITE_NOTADB) {
				return new JDBCConnectionException(message, sqlException, sql);
			}

			// returning null allows other delegates to operate
			return null;
		}
	};
}
 

import org.hibernate.exception.JDBCConnectionException; //导入依赖的package包/类
@Override
public SQLExceptionConversionDelegate buildSQLExceptionConversionDelegate() {
	return new SQLExceptionConversionDelegate() {
		@Override
		public JDBCException convert(SQLException sqlException, String message, String sql) {
			final int errorCode = JdbcExceptionHelper.extractErrorCode(sqlException);
			if (errorCode == SQLITE_TOOBIG || errorCode == SQLITE_MISMATCH) {
				return new DataException(message, sqlException, sql);
			} else if (errorCode == SQLITE_BUSY || errorCode == SQLITE_LOCKED) {
				return new LockAcquisitionException(message, sqlException, sql);
			} else if ((errorCode >= SQLITE_IOERR && errorCode <= SQLITE_PROTOCOL) || errorCode == SQLITE_NOTADB) {
				return new JDBCConnectionException(message, sqlException, sql);
			}
			return null;
		}
	};
}
 

import org.hibernate.exception.JDBCConnectionException; //导入依赖的package包/类
public List execQuery(String queryString) {
   List result = null;
   Transaction tx = null;
   try {
       Session session = _factory.getCurrentSession();
       tx = session.beginTransaction();
       Query query = session.createQuery(queryString);
       if (query != null) result = query.list();
   }
   catch (JDBCConnectionException jce) {
       _log.error("Caught Exception: Couldn't connect to datasource - " +
               "starting with an empty dataset");
   }
   catch (HibernateException he) {
       _log.error("Caught Exception: Error executing query: " + queryString, he);
       if (tx != null) tx.rollback();
   }

   return result;
}
 

import org.hibernate.exception.JDBCConnectionException; //导入依赖的package包/类
/**
 * executes a Query object based on the hql string passed
 * @param queryString - the hibernate query to execute
 * @return the List of objects returned, or null if the query has some problem
 */
public List execQuery(String queryString) {
    List result = null;
    Transaction tx = null;
    try {
        tx = getOrBeginTransaction();
        Query query = getSession().createQuery(queryString);
        if (query != null) result = query.list();
    }
    catch (JDBCConnectionException jce) {
        _log.error("Caught Exception: Couldn't connect to datasource - " +
                "continuing with an empty dataset");
        if (tx != null) tx.rollback();
    }
    catch (HibernateException he) {
        _log.error("Caught Exception: Error executing query: " + queryString, he);
        if (tx != null) tx.rollback();
    }

    return result;
}
 

import org.hibernate.exception.JDBCConnectionException; //导入依赖的package包/类
/**
 * executes a plain SQL Query
 * @param queryString - the SQL query to execute
 * @return the List of objects returned, or null if the query has some problem
 */
public List execSQLQuery(String queryString) {
    List result = null;
    Transaction tx = null;
    try {
        tx = getOrBeginTransaction();
        Query query = getSession().createSQLQuery(queryString);
        if (query != null) result = query.list();
        commit();
    }
    catch (JDBCConnectionException jce) {
        _log.error("Caught Exception: Couldn't connect to datasource - " +
                "starting with an empty dataset");
        if (tx != null) tx.rollback();
    }
    catch (HibernateException he) {
        _log.error("Caught Exception: Error executing query: " + queryString, he);
        rollback();
    }

    return result;
}
 

import org.hibernate.exception.JDBCConnectionException; //导入依赖的package包/类
public int execUpdate(String queryString, boolean commit) {
    int result = -1;
    Transaction tx = null;
    try {
        tx = getOrBeginTransaction();
        result = getSession().createQuery(queryString).executeUpdate();
        if (commit) commit();
    }
    catch (JDBCConnectionException jce) {
        _log.error("Caught Exception: Couldn't connect to datasource - " +
                "starting with an empty dataset");
    }
    catch (HibernateException he) {
        _log.error("Caught Exception: Error executing query: " + queryString, he);
        if (tx != null) tx.rollback();
    }

    return result;
}
 

import org.hibernate.exception.JDBCConnectionException; //导入依赖的package包/类
public void execute(TransactionalOperation operation) {
	JDBCConnectionException last = null;
	Transaction tx = null;
	for (int retry = 0; retry < TRANSACTIONS_MAX_RETRIES; retry++) {
		Session dbSession = this.getSession();
		try {
			tx = dbSession.beginTransaction();
			operation.execute(dbSession);
			tx.commit();
			if (retry > 0)
				LOG.warn("Transacao realizada apos "+String.valueOf(retry+1)+" tentativas.");
			return;
		} catch (JDBCConnectionException ex) {
			last = ex;
			if (tx != null)
				tx.rollback();
			tx = null;
			this.closeSession();
		}
	}
	LOG.error("Erro ao tentar executar operação transacional apos "+
			String.valueOf(TRANSACTIONS_MAX_RETRIES)+" tentativas.", last);
	throw new RuntimeException("Erro no banco de dados.", last);
}
 

import org.hibernate.exception.JDBCConnectionException; //导入依赖的package包/类
@Override
public void persist(Serializable entity) {
	JDBCConnectionException last = null;
	Transaction tx = null;
	for (int retry = 0; retry < TRANSACTIONS_MAX_RETRIES; retry++) {
		Session dbSession = this.getSession();
		try {
			tx = dbSession.beginTransaction();
			dbSession.persist(entity);
			tx.commit();
			if (retry > 0)
				LOG.warn("Transacao realizada apos "+String.valueOf(retry+1)+" tentativas.");
			return;
		} catch (JDBCConnectionException ex) {
			last = ex;
			if (tx != null)
				tx.rollback();
			tx = null;
			this.closeSession();
		}
	}
	LOG.error("Erro ao tentar salvar entidade: "+entity.getClass().getCanonicalName()+" apos "+
			String.valueOf(TRANSACTIONS_MAX_RETRIES)+" tentativas.", last);
	throw new RuntimeException("Erro no banco de dados.", last);
}
 

import org.hibernate.exception.JDBCConnectionException; //导入依赖的package包/类
@Override
public Serializable save(Serializable entity) {
	JDBCConnectionException last = null;
	Transaction tx = null;
	for (int retry = 0; retry < TRANSACTIONS_MAX_RETRIES; retry++) {
		Session dbSession = this.getSession();
		try {
			tx = dbSession.beginTransaction();
			Serializable id = dbSession.save(entity);
			tx.commit();
			if (retry > 0)
				LOG.warn("Transacao realizada apos "+String.valueOf(retry+1)+" tentativas.");
			return id;
		} catch (JDBCConnectionException ex) {
			last = ex;
			if (tx != null)
				tx.rollback();
			tx = null;
			this.closeSession();
		}
	}
	LOG.error("Erro ao tentar salvar entidade: "+entity.getClass().getCanonicalName()+" apos "+
			String.valueOf(TRANSACTIONS_MAX_RETRIES)+" tentativas.", last);
	throw new RuntimeException("Erro no banco de dados.", last);
}
 

import org.hibernate.exception.JDBCConnectionException; //导入依赖的package包/类
@Override
public void update(Serializable entity) {
	JDBCConnectionException last = null;
	Transaction tx = null;
	for (int retry = 0; retry < TRANSACTIONS_MAX_RETRIES; retry++) {
		Session dbSession = this.getSession();
		try {
			tx = dbSession.beginTransaction();
			dbSession.update(entity);
			tx.commit();
			if (retry > 0)
				LOG.warn("Transacao realizada apos "+String.valueOf(retry+1)+" tentativas.");
			return;
		} catch (JDBCConnectionException ex) {
			last = ex;
			if (tx != null)
				tx.rollback();
			tx = null;
			this.closeSession();
		}
	}
	LOG.error("Erro ao tentar atualizar entidade: "+entity.getClass().getCanonicalName()+" apos "+
			String.valueOf(TRANSACTIONS_MAX_RETRIES)+" tentativas.", last);
	throw new RuntimeException("Erro no banco de dados.", last);
}
 

import org.hibernate.exception.JDBCConnectionException; //导入依赖的package包/类
@Override
public void delete(Serializable entity) {
	JDBCConnectionException last = null;
	Transaction tx = null;
	for (int retry = 0; retry < TRANSACTIONS_MAX_RETRIES; retry++) {
		Session dbSession = this.getSession();
		try {
			tx = dbSession.beginTransaction();
			dbSession.delete(entity);
			tx.commit();
			if (retry > 0)
				LOG.warn("Transacao realizada apos "+String.valueOf(retry+1)+" tentativas.");
			return;
		} catch (JDBCConnectionException ex) {
			last = ex;
			if (tx != null)
				tx.rollback();
			tx = null;
			this.closeSession();
		}
	}
	LOG.error("Erro ao tentar deletar entidade: "+entity.getClass().getCanonicalName()+" apos "+
			String.valueOf(TRANSACTIONS_MAX_RETRIES)+" tentativas.", last);
	throw new RuntimeException("Erro no banco de dados.", last);
}
 

import org.hibernate.exception.JDBCConnectionException; //导入依赖的package包/类
@Override
public int bulkUpdate(String sqlStatement) {
	JDBCConnectionException last = null;
	Transaction tx = null;
	for (int retry = 0; retry < TRANSACTIONS_MAX_RETRIES; retry++) {
		Session dbSession = this.getSession();
		try {
			tx = dbSession.beginTransaction();
			SQLQuery query = dbSession.createSQLQuery(sqlStatement);
			int affected = query.executeUpdate();
			tx.commit();
			if (retry > 0)
				LOG.warn("Transacao realizada apos "+String.valueOf(retry+1)+" tentativas.");
			return affected;
		} catch (JDBCConnectionException ex) {
			last = ex;
			if (tx != null)
				tx.rollback();
			tx = null;
			this.closeSession();
		}
	}
	LOG.error("Erro ao tentar atualizar entidade em massa apos "+
			String.valueOf(TRANSACTIONS_MAX_RETRIES)+" tentativas.", last);
	throw new RuntimeException("Erro no banco de dados.", last);
}
 

import org.hibernate.exception.JDBCConnectionException; //导入依赖的package包/类
public void execute(TransactionalOperation operation) {
	JDBCConnectionException last = null;
	EntityTransaction tx = null;
	for (int retry = 0; retry < TRANSACTIONS_MAX_RETRIES; retry++) {
		EntityManager dbSession = this.getSession();
		try {
			tx = dbSession.getTransaction();
			operation.execute(dbSession);
			tx.commit();
			if (retry > 0)
				LOG.warn("Transacao realizada apos "+String.valueOf(retry+1)+" tentativas.");
			return;
		} catch (JDBCConnectionException ex) {
			last = ex;
			if (tx != null)
				tx.rollback();
			tx = null;
			this.closeSession();
		}
	}
	LOG.error("Erro ao tentar executar operação transacional apos "+
			String.valueOf(TRANSACTIONS_MAX_RETRIES)+" tentativas.", last);
	throw new RuntimeException("Erro no banco de dados.", last);
}
 

import org.hibernate.exception.JDBCConnectionException; //导入依赖的package包/类
@Override
public void persist(Serializable entity) {
	JDBCConnectionException last = null;
	EntityTransaction tx = null;
	for (int retry = 0; retry < TRANSACTIONS_MAX_RETRIES; retry++) {
		EntityManager dbSession = this.getSession();
		try {
			tx = dbSession.getTransaction();
			dbSession.persist(entity);
			tx.commit();
			if (retry > 0)
				LOG.warn("Transacao realizada apos "+String.valueOf(retry+1)+" tentativas.");
			return;
		} catch (JDBCConnectionException ex) {
			last = ex;
			if (tx != null)
				tx.rollback();
			tx = null;
			this.closeSession();
		}
	}
	LOG.error("Erro ao tentar salvar entidade: "+entity.getClass().getCanonicalName()+" apos "+
			String.valueOf(TRANSACTIONS_MAX_RETRIES)+" tentativas.", last);
	throw new RuntimeException("Erro no banco de dados.", last);
}