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

On 29 Jun 2005 03:33:26 GMT, xhoster_at_gmail.com wrote:

>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.

Apparently you don't know what data integrity is. Allowing the end-user to rollback doesn't violate data integrity in any fashion, *NOT* allowing rollback *DOES*.
Where have you been to school? You should either re-enter the course or ask your money back.
You last assertion is just simply plain ridiculous. Apparently that application was build by people who didn't understand anything about transactions and integrity. Maybe by you?

--
Sybrand Bakker, Senior Oracle DBA