Changes: The statement did not return a result set.
Nobody has claimed this yet.
Assessment
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Newbie friendliness
- 32/100
Research direction
Reproduce the SQL Server UPDATE using Changes.setRequest, then inspect org.assertj.db.type.AbstractDbData.load and Changes.getDuplicatedRequest, where the stack trace shows the failure. Check how the statement is handled when no result set is returned; done means this UPDATE no longer raises the reported exception.
Written by the indexing model from the issue text.
Description
I am trying to update a table in my ms sqlserver db, below is my code.
Source source = new Source("//SourceConnectionString");
Changes change = new Changes();
change.setRequest(new Request(source, "UPDATE CM_GENERATOR SET GEN_VALUE='3'"));
when i execute above code, i am getting below error
org.assertj.db.exception.AssertJDBException: com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.
at org.assertj.db.type.AbstractDbData.load(AbstractDbData.java:136)
at org.assertj.db.type.AbstractDbData.getPksNameList(AbstractDbData.java:255)
at org.assertj.db.type.Changes.getDuplicatedRequest(Changes.java:244)
at org.assertj.db.type.Changes.setRequest(Changes.java:159)
<dependency>
<groupId>org.assertj</groupId>
<artifactId>assertj-db</artifactId>
<version>2.0.2</version>
</dependency>
- Dominant language
- Java
- Stars
- 130
- Forks
- 21
- PR merge metrics
- No merged PRs in 30d
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from assertj/assertj-db
-
assertj/assertj-db#324 · 1 comment · 1 assignee ·
-
question
Difficulty 3/5 1-2 days Newbie friendliness 35/100
assertj/assertj-db#290 · 1 comment ·
-
Difficulty 4/5 3-5 days Newbie friendliness 30/100
assertj/assertj-db#259 · 1 comment ·
-
Difficulty 5/5 Over a week Newbie friendliness 25/100
assertj/assertj-db#206 ·
-
enhancement
Difficulty 4/5 3-5 days Newbie friendliness 35/100
assertj/assertj-db#176 · 1 comment ·
All issues in assertj/assertj-db
Similar issues
-
certification
Difficulty 1/5 Under an hour Newbie friendliness 80/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
-
[BUG] ECR GetAuthorizationToken returns a proxyEndpoint for the default region, not the request's Openbug ecr
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
-
Needs: Triage Type: Feature request
Difficulty 2/5 1-3 hours Newbie friendliness 70/100
AntennaPod/AntennaPod#8794 ·
-
agentic-workflows
Difficulty 2/5 1-3 hours Newbie friendliness 65/100
github/copilot-sdk#2760 ·