[
https://issues.apache.org/jira/browse/SQOOP-1279?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14050329#comment-14050329
]
Mala Chikka Kempanna commented on SQOOP-1279:
---------------------------------------------
Sample symptom of the problem when connecting to Informix looks like below
14/06/25 10:13:32 INFO mapreduce.Job: Task Id :
attempt_1403182618659_0156_m_000000_2, Status : FAILED
Error: java.io.IOException: java.sql.SQLException: Method not supported with
this server. : IfxPreparedStatement.isClosed()
at org.apache.sqoop.mapreduce.db.DBRecordReader.close(DBRecordReader.java:171)
at
org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.close(MapTask.java:500)
at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:768)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:340)
at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:168)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:415)
at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1548)
at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:163)
Caused by: java.sql.SQLException: Method not supported with this server. :
IfxPreparedStatement.isClosed()
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:488)
at
com.informix.jdbc.IfxPreparedStatement.isClosed(IfxPreparedStatement.java:5504)
at org.apache.sqoop.mapreduce.db.DBRecordReader.close(DBRecordReader.java:163)
... 8 more
> Sqoop connection resiliency option breaks older Mysql versions that don't
> have JDBC 4 methods
> ---------------------------------------------------------------------------------------------
>
> Key: SQOOP-1279
> URL: https://issues.apache.org/jira/browse/SQOOP-1279
> Project: Sqoop
> Issue Type: Bug
> Environment: Mysql 5.0.8 connector/J
> Reporter: Venkat Ranganathan
> Assignee: Venkat Ranganathan
> Priority: Critical
> Fix For: 1.4.5
>
> Attachments: SQOOP-1279.patch
>
>
> The connection resiliency changes (SQOOP-1056 and SQOOP-1057) add additional
> checks on the preparedStatement (Statement.isClosed()) that is introduced in
> JDBC 4 as part of JDK 6. That method is not available in older drivers that
> are not JDBC4 compliant. Since this is a backward breaking change proposing
> to fix it.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
