查询的时候报错 java.sql.SQLException: ResultSet is from UPDATE. No Data.
- 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
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