Resolve Sqoop Import Error: caused By:java.sql.SQLException:Protocol violation

Error message:

 .- .- the  the: Geneva: the,374INFO [main] org.apache.hadoop.mapred.MapTask:Ignoring exception during close for[email Protected]0java.io.ioexception:java.sql.sqlexception:protocol violation at Org.apache.sqoop.mapreduce.db.DBRecordReader.close (Dbrecordreader.java:173) at Org.apache.hadoop.mapred.maptask$newtrackingrecordreader.close (Maptask.java:523) at org.apache.hadoop.mapred.MapTask.closeQuietly (Maptask.java:2004) at Org.apache.hadoop.mapred.MapTask.runNewMapper (Maptask.java:796) at Org.apache.hadoop.mapred.MapTask.run (Maptask.java:341) at org.apache.hadoop.mapred.yarnchild$2. Run (Yarnchild.java:164) at java.security.AccessController.doPrivileged (Native Method) at Javax.security.auth.Subject.doAs (Subject.jav A:422) at Org.apache.hadoop.security.UserGroupInformation.doAs (Usergroupinformation.java:1657) at Org.apache.hadoop.mapred.YarnChild.main (Yarnchild.java:158) caused by:java.sql.SQLException:Protocol violation at Oracle.jdbc.driver.T4CTTIfun.readRXH (T4cttifun.java: 631) at Oracle.jdbc.driver.T4CTTIfun.receive (T4cttifun.java:391) at Oracle.jdbc.driver.T4CTTIfun.doRPC (T4cttifun.java:227) at Oracle.jdbc.driver.T4C7Ocommoncall.doOCOMMIT (T4c7ocommoncall.java: the) at Oracle.jdbc.driver.T4CConnection.doCommit (T4cconnection.java:641) at Oracle.jdbc.driver.PhysicalConnection.commit (Physicalconnection.java:3928) at Oracle.jdbc.driver.PhysicalConnection.commit (Physicalconnection.java:3934) at Org.apache.sqoop.mapreduce.db.DBRecordReader.close (Dbrecordreader.java:169)    ... 9 More .- .- the  the: Geneva: the,384FATAL [main] org.apache.hadoop.mapred.YarnChild:Error running Child:java.lang.OutOfMemoryError:Java heap Space At Java.lang.reflect.Array.newArray (Native Method) at Java.lang.reflect.Array.newInstance (Array.java: the) at Oracle.jdbc.driver.BufferCache.Get(Buffercache.java:226) at Oracle.jdbc.driver.PhysicalConnection.getCharBuffer (Physicalconnection.java:7698) at Oracle.jdbc.driver.OracleStatement.prepareAccessors (Oraclestatement.java:1013) at Oracle.jdbc.driver.T4CTTIdcb.receiveCommon (T4cttidcb.java:277) at Oracle.jdbc.driver.T4CTTIdcb.receive (T4cttidcb.java:146) at Oracle.jdbc.driver.T4C8Oall.readDCB (T4c8oall.java:916) at Oracle.jdbc.driver.T4CTTIfun.receive (T4cttifun.java:421) at Oracle.jdbc.driver.T4CTTIfun.doRPC (T4cttifun.java:227) at Oracle.jdbc.driver.T4C8Oall.doOALL (T4c8oall.java:531) at Oracle.jdbc.driver.T4CPreparedStatement.doOall8 (T4cpreparedstatement.java:208) at Oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe (T4cpreparedstatement.java:886) at Oracle.jdbc.driver.OracleStatement.executeMaybeDescribe (Oraclestatement.java:1175) at Oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout (Oraclestatement.java:1296) at Oracle.jdbc.driver.OraclePreparedStatement.executeInternal (Oraclepreparedstatement.java:3613) at Oracle.jdbc.driver.OraclePreparedStatement.executeQuery (Oraclepreparedstatement.java:3657) at Oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery (Oraclepreparedstatementwrapper.java: 1495) at Org.apache.sqoop.mapreduce.db.DBRecordReader.executeQuery (Dbrecordreader.java:111) at Org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue (Dbrecordreader.java:235) at Org.apache.hadoop.mapred.maptask$newtrackingrecordreader.nextkeyvalue (Maptask.java:556) at Org.apache.hadoop.mapreduce.task.MapContextImpl.nextKeyValue (Mapcontextimpl.java: the) at Org.apache.hadoop.mapreduce.lib.map.wrappedmapper$context.nextkeyvalue (Wrappedmapper.java: the) at Org.apache.hadoop.mapreduce.Mapper.run (Mapper.java:145) at Org.apache.sqoop.mapreduce.AutoProgressMapper.run (Autoprogressmapper.java: -) at Org.apache.hadoop.mapred.MapTask.runNewMapper (Maptask.java:787) at Org.apache.hadoop.mapred.MapTask.run (Maptask.java:341) at org.apache.hadoop.mapred.yarnchild$2. Run (Yarnchild.java:164) at java.security.AccessController.doPrivileged (Native Method) at Javax.security.auth.Subject.doAs (Subject.jav A:422) at Org.apache.hadoop.security.UserGroupInformation.doAs (Usergroupinformation.java:1657) at Org.apache.hadoop.mapred.YarnChild.main (Yarnchild.java:158) can

Reference: http://blog.csdn.net/wsm6591289/article/details/34425919

Resolve Sqoop Import Error: caused By:java.sql.SQLException:Protocol violation