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

女爷i 2022-07-13 08:45 144阅读 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

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

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 SpringBoot报错Error attempting to get column ‘create_time’ from result set. Cause: java.sql.SQLFeature

相关 MybatisPlus UncategorizedSQLException: Error attempting to get column ‘xxx‘ from result set问题解决

相关 Error attempting to get column ‘xxx‘ from result set. Cause: java.sql.SQLDataException错误的解决方法

相关 LocalDateTime 字段报错： Error attempting to get column ‘reg_time‘ from result set

相关 Attempted read from closed stream

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

相关 Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Could not find

相关 Failed with error: Could not read from remote repository.

相关 mysql从库Last_IO_Error: Got fatal error 1236 from master when reading data from binary log

相关 Mybatis 报错 The error occurred while handling results，### Error querying database. Cause: java.lang.