Is there any chance the blob was deleted before the insert completed?
The scenario I see is if you do an INSERT INTO ... SELECT ...
There is a discussion on the Architect list right now about the problem
where Blobs are garbage collected while they are still in use.

-----Original Message-----
From: Firebird-Java@yahoogroups.com
[mailto:Firebird-Java@yahoogroups.com] On Behalf Of robert_difalco
Sent: Friday, December 09, 2005 11:59 AM
To: Firebird-Java@yahoogroups.com
Subject: [Firebird-Java] 335544329 invalid BLOB ID

Can anyone think of a reason why I would "VERY RARELY" get this error
performing inserts? Usually with a stored procedure? The application is
very multi-threaded, but a single connection is never used concurrently.
When I say this is rare, it probably only happens 2-5% of the time. This
is with the pre 2.0 jaybird driver and 1.0.3 Firebird.





------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet
Life.
http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/saFolB/TM
--------------------------------------------------------------------~->


Yahoo! Groups Links