捕获hibernate异常SqlExceptionHelper

Question

当该列与数据库列不匹配时，我们将在日志中获得以下行的异常。但它并没有破例。我甚至保留了尝试接球。我怎样才能抓住例外？

WARN 2015-11-04 17:25:44055[http-apr-8080-exec-4][SqlExceptionHelper.java:144]：SQL错误：904，SQLState:42000错误2015-11-04 17:25:44055[http-apr-8080-exec-4][SqlExceptionHelper.java:146]：ORA-00904：“shu RATE\u description”：无效标识符

 import javax.persistence.EntityManager;
 import javax.persistence.PersistenceContext;

 import org.springframework.beans.factory.annotation.Value;
 import org.springframework.stereotype.Repository;

 import com.core.model.entity.ShippingTable;

 @Repository("sTableDAO")
 public class STableDao {


 @PersistenceContext(unitName = "somaUnit")
 private EntityManager entityManager;


 public STable save(STable sTable) {    
    try{
        sTable = entityManager.merge(sTable);
    }catch(Exception e){
        e.printStackTrace();
    }
    return sTable;      
 }  
}

Answer 1

只需将此记录器的日志级别设置为致命。在守则中：

private static Logger logger = org.apache.log4j.Logger.getLogger("org.hibernate.engine.jdbc.spi.SqlExceptionHelper");
logger.setLevel(Level.FATAL);

或：

...
<!-- ADDED THE FOLLOWING -->
<logger category="org.hibernate.engine.jdbc.spi.SqlExceptionHelper">
<level name="FATAL"/>
</logger>
...

Answer 2

级别。致命甚至吞下了错误日志消息。背景

org.apache.log4j.Logger.getLogger("org.hibernate.engine.jdbc.spi.SqlExceptionHelper")
    .setLevel(Level.ALL);

在某个任意类的静态初始值设定项块中实现了这个技巧！

Answer 3

尝试从数据完整性违反异常获取消息

catch (DataIntegrityViolationException ex) {
   handleException(ex.getRootCause().getMessage()) /*get the message and handle it*/
}