alibaba / alibaba/druid

查询的时候报错 java.sql.SQLException: ResultSet is from UPDATE. No Data.

Open
#2,091 16 comments 0 reactions 0 assignees View on GitHub
Question
Dominant language
Java
Stars
28.2k
Forks
8.6k
PR merge metrics
No merged PRs in 30d

Description

druid version 1.1.2
mysql-connector-java 5.1.41

在做一个查询的时候报错如下
```
java.sql.SQLException: ResultSet is from UPDATE. No Data.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:6316)
at com.alibaba.druid.filter.FilterChainImpl.resultSet_next(FilterChainImpl.java:750)
at com.alibaba.druid.filter.FilterAdapter.resultSet_next(FilterAdapter.java:1907)
at com.alibaba.druid.filter.FilterChainImpl.resultSet_next(FilterChainImpl.java:747)
at com.alibaba.druid.proxy.jdbc.ResultSetProxyImpl.next(ResultSetProxyImpl.java:882)
at com.alibaba.druid.pool.DruidPooledResultSet.next(DruidPooledResultSet.java:69)
```
google 一下是在

调用存储过程的时候,要用execute(),不能用executeQuery(),executeQuery 只
会用executeQuery做查询。

不知具体是何原因

Contributor guide

Open the contributing guide

Research direction

No repository files, tests, or reproducible query are named. Start by reproducing the stored-procedure call with Druid 1.1.2 and mysql-connector-java 5.1.41, then compare the use of execute() and executeQuery() while tracing the ResultSet path. Done means identifying whether the failure is in the caller or Druid and documenting a verified resolution.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, mysql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.