Re: [JDBC] why would an update only work if done twice?

2001-10-02 Thread Dave Cramer
PROTECTED]] On Behalf Of C O'Connor Sent: September 28, 2001 9:41 AM To: [EMAIL PROTECTED] Subject: [JDBC] why would an update only work if done twice? I know this is a mistake I have made, and I am pretty sure it is a mistake that has been occuring ever since I caught an SQL exception (tri

[JDBC] why would an update only work if done twice?

2001-10-02 Thread C O'Connor
I know this is a mistake I have made, and I am pretty sure it is a mistake that has been occuring ever since I caught an SQL exception (tried to insert value with already existing primary key). At a guess I'd say that the db didn't recover properly because I didn't rollback when i caught that ex