Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-1341

LOB set method(s) are currently no supported, but part of the Java 1.4 JDBC interface

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.2.0, 10.0.2.1, 10.0.2.2, 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6, 10.3.1.4
    • Fix Version/s: 10.3.1.4
    • Component/s: JDBC
    • Labels:
      None
    • Environment:
      all
    • Urgency:
      Normal
    • Issue & fix info:
      Release Note Needed

      Description

      JDBC LOB . getBtypes methods are not implemented in any Derby version to date: there is a "place-holder" method that throws a SQLException reporting that the methods are not implemented.

      It would be excellent to have any efficient Derby implementation of the getBytes LOB methods that provide "random-access" to the binary // character content of database large objects. The specific context is implementing a Lucene Directory interface that stores indexing data (index files) and other binary data in a local encrypted Derby instance.

      A work around is to write an encrypted RandomAccessFile implementation as a file-sdystem buffer, perhaps writing to the database on closure. An efficient Derby implementation of LOB . getBytes would avoid this an make for a clean design. I can think of several reasons why random-access to LOBs would be valuable in a "hostile" client environment.

        Attachments

        1. derby-1341.diff
          38 kB
          Anurag Shekhar
        2. derby-1341-blob-forreview.diff
          39 kB
          Anurag Shekhar
        3. LobStreamTest.java
          16 kB
          Fernanda Pizzorno
        4. releaseNotes.html
          5 kB
          Anurag Shekhar
        5. releaseNotes-v2.html
          5 kB
          Anurag Shekhar
        6. releaseNote.html
          5 kB
          Anurag Shekhar
        7. releaseNote.html
          5 kB
          Rick Hillegas
        8. releaseNote.html
          5 kB
          Anurag Shekhar

          Issue Links

          There are no Sub-Tasks for this issue.

            Activity

              People

              • Assignee:
                anurag Anurag Shekhar
                Reporter:
                keith mcfarlane Keith McFarlane
              • Votes:
                1 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: