[DERBY-4362] Client returns -1 on Statement.getUpdateCount when a procedure is called, embedded returns 0.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Component/s: Network Client
• Bug behavior facts: Deviation from standard, Embedded/Client difference
• Assignee: Unassigned
• Reporter: Dag H. Wanvik
• Created: 26/Aug/09 20:53
• Updated: 13/Jan/11 17:26
• Resolved: 27/Aug/09 08:42

Description

I think embedded is correct here, -1 should be used for when there are no more results left,
cf Javadoc http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Statement.html#getUpdateCount():

"if the result is a ResultSet object or there are no more results, -1 is returned."
I attach a repro in the form of a Derby Junit test.

Issue Links

• duplicates: DERBY-211 Network Server returns no result sets for a procedure call that returns no result