Java BatchUpdateException.getNextException方法代码示例

import java.sql.BatchUpdateException; //导入方法依赖的package包/类
@ExceptionHandler
public void tratarHibernatePostgreSQL(RollbackException e) {
	PersistenceException persistenceException = (PersistenceException) e
			.getCause();
	/*
	 * Desde aquí ya no es estándar JEE6, estas son clases específicas de
	 * Hibernate y PostgreSQL dependiendo del proveedor JPA y del motor que
	 * se utilice esto habrá que adaptar
	 */
	ConstraintViolationException constraintViolationException = (ConstraintViolationException) persistenceException
			.getCause();
	BatchUpdateException batchUpdateException = (BatchUpdateException) constraintViolationException
			.getCause();
	Exception psqlException = batchUpdateException.getNextException();
	String msg = psqlException.getLocalizedMessage();
	logger.error("Error al realizar el update: " + msg);
	FacesContext.getCurrentInstance().addMessage(null,
			new FacesMessage(FacesMessage.SEVERITY_ERROR, msg, null));
}
 

import java.sql.BatchUpdateException; //导入方法依赖的package包/类
public void insert() throws SQLException {
	try {
		statement.executeBatch();
	}
	catch (BatchUpdateException e) {
		throw e.getNextException();
	}
	finally {
		statement.close();
	}
}
 

import java.sql.BatchUpdateException; //导入方法依赖的package包/类
/**
 * This method will take care of finding the real underlying exception. When a jdbc or hibernate
 * exception occurs then the whole stack trace is not available in the log because the exception
 * does not return the underlying exception using the {@link Throwable#getCause()} but using the
 * {@link SQLException#getNextException()}.
 * 
 * @param throwable
 *          the throwable to analyze
 * @return the underlying sql exception or the original throwable if none found
 */
public static Throwable getUnderlyingSQLException(Throwable throwable) {

  if (throwable instanceof BatchUpdateException
      && ((BatchUpdateException) throwable).getNextException() != null) {
    return ((BatchUpdateException) throwable).getNextException();
  }
  if (throwable.getCause() instanceof BatchUpdateException
      && ((BatchUpdateException) throwable.getCause()).getNextException() != null) {
    final BatchUpdateException bue = (BatchUpdateException) throwable.getCause();
    return bue.getNextException();
  }
  if (throwable.getCause() instanceof org.hibernate.exception.GenericJDBCException
      && ((org.hibernate.exception.GenericJDBCException) throwable.getCause()).getSQLException()
          .getNextException() != null) {
    final org.hibernate.exception.GenericJDBCException gjdbce = (org.hibernate.exception.GenericJDBCException) throwable
        .getCause();
    return gjdbce.getSQLException().getNextException();
  }
  if (throwable.getCause() instanceof org.hibernate.exception.ConstraintViolationException
      && ((org.hibernate.exception.ConstraintViolationException) throwable.getCause())
          .getSQLException().getNextException() != null) {
    final org.hibernate.exception.ConstraintViolationException cve = (org.hibernate.exception.ConstraintViolationException) throwable
        .getCause();
    return cve.getSQLException().getNextException();
  }
  return throwable;
}
 

import java.sql.BatchUpdateException; //导入方法依赖的package包/类
/**
 * Hibernate data.
 *
 * @param article
 *            the article
 * @param session
 *            the session
 * @return true, if successful
 */
public synchronized boolean hibernateData(final NewsArticle article, final Session session) {
	Transaction tx = null;

	HibernateHelper.logger.debug("hibernateData: " + article.getArticleId());

	final Location location = null;
	final String gender = null;
	try {
		tx = session.beginTransaction();
		tx.begin();

		final UsenetUser poster = this.createUsenetUser(article, session, location, gender);

		final Message message = this.createMessage(article, null, poster);

		this.storeNewsgroups(article.getNewsgroupsList(), message, session);

		tx.commit();

	}
	catch (Exception e) {
		if (e instanceof GenericJDBCException) {
			e = (Exception) e.getCause();
		}
		if (e instanceof BatchUpdateException) {
			final BatchUpdateException buex = (BatchUpdateException) e;
			System.err.println("Contents of BatchUpdateException:");
			System.err.println(" Update counts: ");
			final int[] updateCounts = buex.getUpdateCounts();
			for (int i = 0; i < updateCounts.length; i++) {
				System.err.println("  Statement " + i + ":" + updateCounts[i]);
			}
			System.err.println(" Message: " + buex.getMessage());
			System.err.println(" SQLSTATE: " + buex.getSQLState());
			System.err.println(" Error code: " + buex.getErrorCode());
			System.err.println(" Article: " + article);

			SQLException ex = buex.getNextException();
			while (ex != null) {
				System.err.println("SQL exception:");
				System.err.println(" Message: " + ex.getMessage());
				System.err.println(" SQLSTATE: " + ex.getSQLState());
				System.err.println(" Error code: " + ex.getErrorCode());
				System.err.println(" Error code: " + ex.getErrorCode());

				ex = ex.getNextException();
			}

		}
		HibernateHelper.logger.error("Failed to store message", e);
		e.printStackTrace();
		if (tx != null) {
			try {
				tx.rollback();
			}
			catch (final HibernateException e1) {
				e1.printStackTrace();
				return false;
			}
		}
	}
	return true;
}