Bug #45171 Connection.serverPrepareStatement() returns wrong default result set types

• Submitted: 28 May 23:21
• Modified: 23 Jun 16:43
• Reporter: Mark Matthews
• Status: Closed
• Category: Connector/J
• Severity: S2 (Serious)
• OS: Any
• Assigned to: Mark Matthews

[28 May 23:21] Mark Matthews

Description:
Calling Connection.serverPrepareStatement() variants that don't take result set type or
concurrency arguments returns statements that produce result sets with incorrect
defaults, namely TYPE_SCROLL_SENSITIVE.

How to repeat:
Call Connection.serverPrepareStatement() and see what kind of statements it returns.

[28 May 23:23] Mark Matthews

Now fixed.

[23 Jun 16:43] Tony Bedford

An entry has been added to the 5.1.8 changelog:

Calling Connection.serverPrepareStatement() variants that do not take result set type or
concurrency arguments returned statements that produced result sets with incorrect
defaults, namely TYPE_SCROLL_SENSITIVE.