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

女爷i 2022-07-13 08:45 112阅读 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][http_download.csdn.net_detail_heixiazuoluo10254222_7706781]  
在这里下载mysql-connector-java-5.1.31-bin  
并替换掉原来sqoop目录下lib文件夹下的连接数据库jar包。这样就不会有问题了，如下截图。  
![这里写图片描述][SouthEast]

[http_download.csdn.net_detail_heixiazuoluo10254222_7706781]: http://download.csdn.net/detail/heixiazuoluo10254222/7706781
[SouthEast]: /images/20220713/cdf09ad29fb9453b90c5174e724109bb.png