Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#637 error exporting lob to file

2.6.5
open
Rob Manning
Unknown (89)
5
2012-12-29
2008-06-05
Anonymous
No

When I save the contents of a BLOB-column (that contains an image) to file, the following error is shown:

Error-text:
there was an error while writing file c:\image.jpg
The error was:
string index out of range: 8

Software:
- Squirrel 2.6.5a
- Derby 10.3.2.1 (embedded jdbc driver)

Scenario:
- select the contents-tab for the table,
- double click a column and select Export.

This works fine for alpha-numerical results. For a lob-column (with the number base set to binary) i get the error message.

The content of the lob is attached (note: although the extension is jpg, it is !not! a jpg-image).

Discussion

  • binary content of Lob

     
    Attachments
  • Logged In: NO

    Software (additional):
    - Windows XP sp2
    - Jdk1.6.0_04

     
  • Rob Manning
    Rob Manning
    2008-07-06

    Logged In: YES
    user_id=1287991
    Originator: NO

    I cannot reproduce this using the 10.3.2.1 embedded driver (jdbc:derby:blobtest). I imported the image that was attached and exported it with no errors. The file content and size of the source and exported files are identical. Please provide the squirrel-sql.log file so we can examine the exception.

    Rob