Re: MASSIVE degradation of insert using sequence ID's via JDBC on 9i?

"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote:
> <xhoster_at_gmail.com> wrote in message
> news:20050628160849.604$YE_at_newsreader.com...
> > sybrandb_at_hccnet.verwijderdit.nl wrote:
> > > On 28 Jun 2005 16:57:49 GMT, xhoster_at_gmail.com wrote:
> > >
> > > >Since when are business rules determined by the end user? Usually
> > > >the end user doesn't even know what a RDB is, let alone ACID.
> > >
> > > So according to you end-users don't need to be capable to rollback?
> >
> > Most of them, no. At least not with Oracle's rollback.
> >
> > > IMO, 80 percent of the garbage in most databases is caused by exactly
> > > this policy.
> >
> > Ha.
> >
> > Xho
> >
> > --
> > -------------------- http://NewsReader.Com/ --------------------
> > Usenet Newsgroup Service $9.95/Month 30GB
> So it sounds like you want to put the "rollback" code in the application.
> If so I feel a strong urge to throw up.

Someone enters some incorrect data. 2 seconds later they realize this. Or two days later they realize it. Or 2 months later they realize this. Are you going to keep the transaction open and uncommitted for two months, just in case they realize the data is wrong? No, of course not. So you need a part of the application to allow people to correct data that has already been committed.

> AAARRGGHH!!!
> Now I feel better. Its too bad that a rudimentary understanding of
> database transactions and data integrity is lost. Go back to school.

I was under the impression that data integrity was designed into the database and the application, and was not left up to the end user. Is that not what they teach in school these days? I've only used oracle rollback (other that for ad hoc work at the CLI) to ensure integrity and ACIDity at the application level, not the "user changed his mind" level. The only applications I've seen that exposed Oracle-level rollback directly to the end users have been unmitigated disasters.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB