[DERBY-3377] Network Client/Server should use sqlType instead of locator value to determine if lob was sent by locator/value

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 10.3.1.4, 10.3.2.1, 10.4.1.3
• Component/s: Network Client, Network Server
• Labels: LOB derby_triage10_9
• Urgency: Low
• Assignee: Unassigned
• Reporter: Katherine Marsden
• Created: 01/Feb/08 18:25
• Updated: 21/Feb/12 20:57

Description

This issue came up during the fix for DERBY-3243. Currently network server does not send the correct sqlType for locators. It sends DB2_SQLTYPE_BLOB or DB2_SQLTYPE_CLOB instead of DB2_SQLTYPE_BLOB_LOCATOR or DB2_SQLTYPE_CLOB_LOCATOR so the client's only way of determining whether it is getting a lob by value or locator is to look at the locator/extended length field and use that to branch its logic. It would be cleaner moving foward to use the sqlType to branch this logic, but there would have to be version specific handling to allow it to work the old way when communicating with older versions.

The sqlType is sent as part of the SQLDAGRP in DRDAConnThread.writeSQLDAGRP() in the
server code.

Issue Links

• is related to: DERBY-3243 (jdbc net client) exception during normal iteration through "ResultSet" of "select * from t"