关闭

ERROR manager.SqlManager: Error reading from database: java.sql.SQLException: Streaming result set

标签: sqoophivemysql
560人阅读 评论(0) 收藏 举报
分类:

问题

在使用sqoop导入数据时,报如下错误:

ERROR manager.SqlManager: Error reading from database: java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@2cbefcfd is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries.
java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@2cbefcfd is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries.

原因

原因是mysql-connector-java-。。。-bin.jar这个jar包出现了问题,可能是版本太低的原因。

解决方案

http://download.csdn.net/detail/heixiazuoluo10254222/7706781
在这里下载mysql-connector-java-5.1.31-bin
并替换掉原来sqoop目录下lib文件夹下的连接数据库jar包。这样就不会有问题了,如下截图。
这里写图片描述

1
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:227695次
    • 积分:3182
    • 等级:
    • 排名:第10774名
    • 原创:104篇
    • 转载:9篇
    • 译文:0篇
    • 评论:110条
    博客专栏
    最新评论