sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mala Chikka Kempanna (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-1279) Sqoop connection resiliency option breaks older Mysql versions that don't have JDBC 4 methods
Date Wed, 02 Jul 2014 17:03:25 GMT

    [ 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)

Mime
View raw message