Newbie: How to prevent a commit

Hi Everyone.

I am using java (JDBC) to query and update an oracle database. I would like to revoke myself the privilege, or denying myself the possibility of executing the sql statements COMMIT or UPDATE.

If is sounds a bit strange, the reason why I want to do that, is testing. I want to make sure that I am handling exceptions in my program. If for any reason the user cannot commit, I want to make sure that the exception is handled.

The problem that I have is that I cannot revoke/grant privileges to myself. Moreover, the database is located in an account which belongs to me. My program is accessing the database, using my username and password. I cannot access it using someone else's password. Therefore, I don't really know how to handle this.

Any help appreciated. Thanks.

Bob.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Feb 22 2000 - 17:56:58 CST