Subject Re: [Firebird-Java] Re: Insert performance
Author William L. Thomson Jr.
On Thu, 2002-11-21 at 16:19, Roman Rokytskyy wrote:
> > 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?
> Well... That's probably not a JDBC issue. I would say, if you have
> normalized database with integrity constraints, you should not care
> about how many rows were inserted/updated/deleted. That is
> statistics, not consistency check. Your transaction will either
> succeed or fail.
That's all I care about, did it go through or not?

I really do not care about the count. Although checking the count is the
only way I know of at the moment to verify that my trans succeeded or

> However, what is better - integrity constraints on
> the server or update count on the client?
What do you mean, I have integrity constraints like not null, and other
checks. What else do I need on the server side.

I just need to know on the client side, not the server side.

> I think that Java people tend to forget what is relational database
> and use them in very simple manner.
I am starting to understand now why people can have a full time job of
dba. My use of Firebird so far is in my opinion a simple manor. I do use
some RDMS features, but my queries and etc are nothing like some that I
see on the ib-support list

> I do remember times when I was
> programming in Delphi and I had no problems moving most of my code
> into stored procedures, but now I tend to think "SP, oh no, if I
> switch to another database I have to re-implement them... better no"
> and first try to implement same thing using SELECT, INSERT, UPDATE
> and DELETE statements.
Yes I am middle road. I do not plan to use another RDMS so specific
stuff does not bother me at the moment. Not as much as things that are
not optimized. Right now I am traveling middle road not leaning to much
to anything to specific, but then not doing everything completely
universally either.

> Is it good? I doubt...
Are you saying it's not good to use the built in features. Or not good
to not?

William L. Thomson Jr.
Support Group
Obsidian-Studios Inc.
439 Amber Way
Petaluma, Ca. 94952
Phone 707.766.9509
Fax 707.766.8989