error exporting lob to file
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
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).
binary content of Lob
Logged In: NO
Software (additional):
- Windows XP sp2
- Jdk1.6.0_04
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