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


    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s:,,,,,,,
    • Fix Version/s:
    • Component/s: JDBC
    • Labels:
    • Environment:
    • Urgency:
    • Issue & fix info:
      Release Note Needed


      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.


        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.



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


                • Created: