Thanks for your help!

I am trying to fail atransaction if someone else is writing to it. So that I can then allow them to read the data instead.

So I should just catch the error from this, and setup a read data instead?

Thanks again.

I hope this is the right place for this...

I want to implement java program to use a mysql DB, and need to make sure of a few things first.

Is it possible to lock a record when it is being written to, and if another process attempts to write to the same record, they can be notified that it is locked, so they can just read the record instead?

Ive read alot of the JDBC tutorials, and cant find if this is possible. I know you can lock a record, and a process will wait until it becomes 'unlocked' but I need to be able to find out if it is locked or not.

Thanks for any help

Just wondering has anyone used this? how would it compare to creating a game in j3d?

Does anybody know where I can find a free applet which creates decent graphs? This would be really useful. Thanks in advance.