Subject Re: [Firebird-Java] Insert performance
Author William L. Thomson Jr.
Blas,

On Thu, 2002-11-14 at 18:43, Blas Rodriguez Somoza wrote:
> The problem only happen when the insert/update/delete are executed with executeUpdate. After the command runs, Jaybird needs to
> ask the server about insert/delete/update lines, because the server don't include those counts in the response, and executeUpdate
> must return the line count.

So basically using executeUpdate calls internalExecute and
getUpdateCount?

But if I switch to and use execute instead of executeUpdate, I will then
need to call getUpdateCount myself no?

How else can I determine if the update/insert/delete was successful or
not?

execute returns a boolean value but from what I have read and understand
that value has no bearing on whether or not the command succeeded. Only
if it returns a ResultSet object or not?

> Using execute instead of executeUpdate Jaybird performs near Interclient on local connections and better on remote connections.
>

But in the end if I must call execute and then getUpdateCount, and I
just better off sticking with executeUpdate?

Thanks.

--
Sincerely,
William L. Thomson Jr.
Support Group
Obsidian-Studios Inc.
439 Amber Way
Petaluma, Ca. 94952
Phone 707.766.9509
Fax 707.766.8989
http://www.obsidian-studios.com