Issue Details (XML | Word | Printable)

Key: DERBY-2495
Type: Sub-task Sub-task
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Øystein Grøvlen
Reporter: Øystein Grøvlen
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Derby
DERBY-208

Create framework for calling locator related stored procedures from client

Created: 28/Mar/07 11:24 AM   Updated: 11/Jul/07 08:11 AM
Return to search
Component/s: Network Client
Affects Version/s: None
Fix Version/s: 10.3.1.4

Time Tracking:
Not Specified

File Attachments:
  Size
File Licensed for inclusion in ASF works blobframework.diff 2007-03-30 01:29 PM Øystein Grøvlen 44 kB
File Licensed for inclusion in ASF works blobframework_v2.diff 2007-04-03 12:44 PM Øystein Grøvlen 48 kB
File blobframework_v2.diff 2007-04-03 12:38 PM Øystein Grøvlen 48 kB
File Licensed for inclusion in ASF works derby-2459-followup.diff 2007-04-16 01:50 PM Øystein Grøvlen 3 kB

Resolution Date: 16/Apr/07 02:21 PM


 Description  « Hide
The client JDBC driver will need to call stored procedures (ref DERBY-2257) to operate on LOBs identified by locators. We should create a framework that implement the stored procedure calls. This way, the rest of the client code can call methods in this framework when needing to call the stored procedures without having to prepare SQL statements themselves.

The framework should make sure that prepared statements are reused within a connection. Each procedure call should only be prepared once per connection.

Since LOBs can not be parameters to stored procedures, the framework should make sure that calls involving a byte[] or String that does not fit in a VARCHAR (FOR BIT DATA), are split into several calls each operating on a fragment of the LOB.

 All   Comments   Work Log   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Øystein Grøvlen made changes - 30/Mar/07 09:54 AM
Field Original Value New Value
Status Open [ 1 ] In Progress [ 3 ]
Øystein Grøvlen made changes - 30/Mar/07 01:29 PM
Attachment blobframework.diff [ 12354601 ]
Øystein Grøvlen made changes - 30/Mar/07 01:33 PM
Component/s Network Client [ 11690 ]
Derby Info [Patch Available]
Øystein Grøvlen made changes - 03/Apr/07 12:38 PM
Attachment blobframework_v2.diff [ 12354833 ]
Øystein Grøvlen made changes - 03/Apr/07 12:44 PM
Attachment blobframework_v2.diff [ 12354834 ]
Kristian Waagan made changes - 16/Apr/07 10:06 AM
Derby Info [Patch Available]
Øystein Grøvlen made changes - 16/Apr/07 01:50 PM
Attachment derby-2459-followup.diff [ 12355607 ]
Øystein Grøvlen made changes - 16/Apr/07 01:52 PM
Derby Info [Patch Available]
Kristian Waagan made changes - 16/Apr/07 02:21 PM
Derby Info [Patch Available]
Resolution Fixed [ 1 ]
Status In Progress [ 3 ] Resolved [ 5 ]
Øystein Grøvlen made changes - 11/Jul/07 08:11 AM
Status Resolved [ 5 ] Closed [ 6 ]