ERROR manager.SqlManager: Error reading from database: java.sql.SQLException: Streaming result set
来源:互联网 发布:淘宝王子团队联系方式 编辑:程序博客网 时间:2024/06/05 09:45
问题
在使用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包。这样就不会有问题了,如下截图。
0 0
- ERROR manager.SqlManager: Error reading from database: java.sql.SQLException: Streaming result set
- ERROR manager.SqlManager: Error reading from database: java.sql.SQLException: Streaming result set
- Error reading from database: java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDyna
- ERROR manager.SqlManager: Error executing statement: java.sql.SQLException: Access denied for user
- sqoop导入数据出错ERROR manager.SqlManager: Error executing statement: java.sql.SQLException: Access denied
- sqoop-导入数据出现java.sql.SQLException: Streaming result set com.mysql.jdbc.
- sqoop-导入数据出现java.sql.SQLException: Streaming result set com.mysql.jdbc.
- FAQ(12):Error querying database. Cause: java.sql.SQLException
- java.sql.SQLException: Got error 28 from storage engine 解决方案
- sqoop-从mysql导入数据到hive出现java.sql.SQLException: Streaming result set com.mysql.jdbc.
- Error getting nested result map values for 'user_inf'. Cause: java.sql.SQLException: Cannot convert
- Error getting nested result map values for 'company'. Cause: java.sql.SQLException: Invalid value fo
- sql问题:java.sql.SQLException:Before start of result set
- java.sql.SQLException: Before start of result set
- java.sql.SQLException: Before start of result set
- java.sql.SQLException: Before start of result set
- java.sql.SQLException: Before start of result set
- java.sql.SQLException: Before start of result set
- html 传递url参数特殊符号 & 传递网址
- php图谱
- 【Leetcode】104. Maximum Depth of Binary Tree
- jQuery中的clone妙用
- 历年诺贝尔物理学奖获得者名单及研究领域(1901-2016)
- ERROR manager.SqlManager: Error reading from database: java.sql.SQLException: Streaming result set
- tesnorflow实现N个epoch训练数据读取的办法
- Solr 学习(7) —- Solr Facet(实现搜索推荐词条)
- 15PB三周年创业感悟及献礼
- OpenSips使用说明
- Java 序列化 (Serializable) 的作用
- android中APK包的安装
- 建立交叉编译环境
- iOS 开发问与答(16-27)