[DERBY-1382] client: lobs fails silently with result sets of type TYPE_SCROLL_INSENSITIVE

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6
• Fix Version/s: 10.2.1.6
• Component/s: JDBC, Network Client
• Assignee: Fernanda Pizzorno
• Reporter: Dag H. Wanvik
• Created: 07/Jun/06 00:20
• Updated: 10/Oct/06 16:54
• Resolved: 27/Jun/06 15:29

Description

The documentation for 10.1
(http://db.apache.org/derby/docs/10.1/adminguide/cadminappsclientdiffs.html)
states:

"Scrollable cursors (ResultSet.TYPE_SCROLL_SENSITIVE or
ResultSet.TYPE_SCROLL_INSENSITIVE) are not supported using the
network client if the result set contains LOB
data. TYPE_FORWARD_ONLY must be specified for result sets containing
LOB data."

Unfortunately, this is not signalled when one tries to use it, it just fails silently,
cf. repro program. Either this should be implemented, or we should throw a
not implemented exception. For JDBC4 compliancy, it needs to be fixed, I
think.