[DERBY-208] Add support to retrieve lobs for Network Server by locator rather than matierializing the LOB

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.1.1.0
• Fix Version/s: 10.3.1.4
• Component/s: Network Server
• Issue & fix info: Release Note Needed
• Assignee: Unassigned
• Reporter: Katherine Marsden
• Created: 11/Apr/05 09:12
• Updated: 17/Jul/09 13:04
• Resolved: 16/Jun/07 23:22

Description

Currently Network Server materializes all LOB objects. LOB locator support is part of the DRDA spec so could be added to network server. See
http://www.opengroup.org/dbiop/

It is not clear if SQL Support for LOB locators would also be required.

Issue Links

• incorporates: DERBY-2496 Implement Blob support for Locators
• is related to: DERBY-2781 10.2 client blobclob4blob test run against 10.3 server fails for many tests with SQLSTATE(XJ073): The data in this BLOB or CLOB is no longer available.
• is related to: DERBY-1560 When receiving EXTDTA object, the client should avoid keeping the entire LOB in memory for large LOBs
• relates to: DERBY-2892 Closing a resultset after retrieving a large > 32665 bytes value with Network Server does not release locks
• relates to: DERBY-4312 SQLException XJ215 on insert with setCharacterStream() and autocommit off in mailjdbc test
• relates to: DERBY-2807 Create a test for BlobClob compatibility on Derby server versions vs. Derby client versions.

Sub-Tasks

• Implementing the stored procedures called by the LOB related JDBC methods: Closed
• Add code to support request and return of locators over DRDA: Closed
• Create framework for calling locator related stored procedures from client: Closed
• Implement Blob support for Locators: Closed
• Adding the locator information to FD:OCA descriptor (FDODSC) andFD:OCA data (FDODTA) of the SQLDTA objects: Closed
• Client PreparedStatement/CallableStatement implementations need to use locators: Closed
• Restructure code for Blob/Clob length in client to prepare for locator implementation: Closed
• BrokeredConnection needs to forward implementations of locator related methods in EngineConnection to the underlying physical connection: Closed
• Connection.createClob() and Connection.createBlob() need to return locator support enabled LOB objects in the NetworkClient: Closed
• Remove temporary code added to enable testing of CLOB locator related stored procedures.: Closed
• Implement Clob support for locators: Closed
• Fix javadoc issues related to locator work: Closed
• Fix build problems related to locator work: Closed
• Add locator support of soft upgrade to 10.3: Closed
• Enable Clob locator support between NetworkServer and NetworkClient and modify tests that experience changed behaviour due to this(enabling Clob Locators).: Closed