--- In Firebird-Java@yahoogroups.com, "Roman Rokytskyy"
<rrokytskyy@a...> wrote:

> > I never intend to call execute() twice on the same prepared

statement

> > (without clearing parameter(s) if re-using); but in this case -

although

> > it's accidental - I'm wondering (only out of curiousity) what's

going on

> > internally here? Can someone explain the mechanism?
>
> When you save a blob, a blob with a temporary ID is created and

opened for

> write (you cannot read from it, it is like OutputStream). This

temporary ID

> is used in the INSERT statement. Then, when statement is executed

(or on

> commit, I do not remember exactly), temporary ID is converted into

permanent

> one. When you tried to use this temporary ID for the second time

Firebird

> reported simply that ID is wrong, since no temporary blob exists.
>
> Now, why didn't JayBird complain earlier? That's a bug, you should

have

> something "Not all parameters were set" or something similar. Please

fill a

> bug report and I will take care of it before JayBird 2.0 is out.
>
> Roman

Hi Roman, I've been meaning to follow this up for a long time. Where
do I raise a bug report, or is this problem now resolved in 2.0
anyway?

Cheers