com.mysql.jdbc.exceptions.jdbc4.CommunicationsException：通信链路故障6 [英] com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure 6

问题描述

在日志中，我收到以下异常。会有什么可能的原因呢？
应用程序有Spring 3.1，hibernate 3.6.9和最新的mysql。

  11：54：25,158错误登录控制器：152 -  org.springframework.transaction.CannotCreateTransactionException：无法打开JPA EntityManager进行事务处理;嵌套异常是javax.persistence.PersistenceException：org.hibernate.TransactionException：JDBC开始失败：
在org.springframework.orm.jpa.JpaTransactionManager.doBegin（JpaTransactionManager.java:427）
在org.springframework .transaction.support.AbstractPlatformTransactionManager.getTransaction（AbstractPlatformTransactionManager.java:371）
 at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary（TransactionAspectSupport.java:335）
 at org.springframework.transaction.interceptor .TransactionInterceptor.invoke（TransactionInterceptor.java:105）
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed（ReflectiveMethodInvocation.java:172）
 at org.springframework.aop.framework.Cglib2AopProxy $ DynamicAdvisedInterceptor .intercept（Cglib2AopProxy.java:622）
 ..... 
在java.util.concurrent.ThreadPoolExecutor。 （ThreadPoolExecutor.java:1110）
在java.util.concurrent.ThreadPoolExecutor $ Worker.run（ThreadPoolExecutor.java:603）
在java.lang.Thread.run（Thread.java:722） 
导致：javax.persistence.PersistenceException：org.hibernate.TransactionException：JDBC开始失败：$ b $在org.hibernate.ejb.AbstractEntityManagerImpl.convert（AbstractEntityManagerImpl.java:1215）$ b $在org .hibernate.ejb.AbstractEntityManagerImpl.convert（AbstractEntityManagerImpl.java:1148）
 at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException（AbstractEntityManagerImpl.java:1225）
 at org.hibernate.ejb.TransactionImpl.begin （TransactionImpl.java:63）
 at org.springframework.orm.jpa.DefaultJpaDialect.beginTransaction（DefaultJpaDialect.java:70）
 at org.springframework.orm.jpa.JpaTransactionManager.doBegin（JpaTransactionManager.java ：377）
 ... 50多
由org.hibernate.TransactionException导致：JDBC开始失败：
在org.hibernate.transaction.JDBCTransaction.begin（JDBCTransaction.java:92）
在org.hibernate.impl.SessionImpl.beginTransaction（ SessionImpl.java:1473）
在org.hibernate.ejb.TransactionImpl.begin（TransactionImpl.java:60）
 ... 52 more 
引起：com.mysql.jdbc.exceptions .jdbc4.CommunicationsException：通信链接失败
  

解决方案

连接池（C3PO）在persistance.xml中

In log , I am getting following exception. What would be possible cause of it? Application has Spring 3.1, hibernate 3.6.9 and latest mysql.

        11:54:25,158 ERROR LoginController:152 - org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.TransactionException: JDBC begin failed: 
            at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:427)
            at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371)
            at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:335)
            at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:105)
            at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
            at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
            .....
            at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
            at java.lang.Thread.run(Thread.java:722)
        Caused by: javax.persistence.PersistenceException: org.hibernate.TransactionException: JDBC begin failed: 
            at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1215)
            at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1148)
            at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:1225)
            at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:63)
            at org.springframework.orm.jpa.DefaultJpaDialect.beginTransaction(DefaultJpaDialect.java:70)
            at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:377)
            ... 50 more
        Caused by: org.hibernate.TransactionException: JDBC begin failed: 
            at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:92)
            at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1473)
            at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:60)
            ... 52 more
        Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

解决方案

Solved after implementing Connection Pooling (C3PO) in persistance.xml

这篇关于com.mysql.jdbc.exceptions.jdbc4.CommunicationsException：通信链路故障6的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！