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



    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • JDBC
    • None
    • all
    • Normal
    • 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 Aggarwal
        2. derby-1341-blob-forreview.diff
          39 kB
          Anurag Aggarwal
        3. LobStreamTest.java
          16 kB
          Fernanda Pizzorno
        4. releaseNote.html
          5 kB
          Anurag Aggarwal
        5. releaseNote.html
          5 kB
          Richard N. Hillegas
        6. releaseNote.html
          5 kB
          Anurag Aggarwal
        7. releaseNotes.html
          5 kB
          Anurag Aggarwal
        8. releaseNotes-v2.html
          5 kB
          Anurag Aggarwal

        Issue Links



              anurag Anurag Aggarwal
              keith mcfarlane Keith McFarlane
              1 Vote for this issue
              0 Start watching this issue