MySQLNonTransientConnectionException: Communications link failure during comm
HI, 我们用mysql 5.6.21 和mysql-connector-java-5.1.17.jar 做ETL,mysql5.6.21 作为目标库, mysql-connector-java-5.1.17.jar作为JDBC驱动,从源表获取30万数据到目标表存到mysql,把30万数据分拆成3000个循环,每个commit 100条记录,有时会平凡报下面的错。
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communications link failure during commit(). Transaction resolution unknown.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~
at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~
at com.mysql.jdbc.Util.getInstance(Util.java:386) ~
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013) ~
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) ~
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) ~
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) ~
at com.mysql.jdbc.ConnectionImpl.commit(ConnectionImpl.java:1665) ~
at org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.java:334) ~
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:211) ~
谁有这方面的经验,请指教一二,不胜感激
页:
[1]