[DERBY-3249] Statement.getGeneratedKeys can return ResultSets that are not CONCUR_READ_ONLY if the Statement object has no CONCUR_READ_ONLY concurrency

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 10.2.2.0
• Component/s: JDBC
• Labels: derby_triage10_5_2
• Urgency: Normal
• Issue & fix info: Repro attached
• Bug behavior facts: Deviation from standard
• Assignee: Unassigned
• Reporter: Daniel John Debrunner
• Created: 04/Dec/07 19:07
• Updated: 16/Feb/12 22:02

Description

JDBC 4 section 13.6 states:

The concurrency of the ResultSet object returned by getGeneratedKeys must be CONCUR_READ_ONLY. The type of the ResultSet object must be either TYPE_FORWARD_ONLY or TYPE_SCROLL_INSENSITIVE.

Since in some cases Derby generates the generated keys ResultSet using the Statement object it inherits the concurrency and type of that statement.