deadlock in oracle

[Michal Harezlak]

According to the documentation Oracle RDBMS systems resolves deadlock itself. When one client is trying to access for write/update a row locked by another one, it should be given error message (deadlock while waiting for the resources or similar) from server. I updated (without commit - row is still locked) one row using SQL PLUS and tried to use my Java/JDBC application to update the same row (using stored proc.) I caused my application to hang and received no messages from server. Any ideas? Am I missing some settings?

[Bhupinder Dhillon]

It will only resolve the situation if both updates were done in the same app (java or otherwise) but from different threads.

[Michal Harezlak]

Thanks, dose it mean that I will have to synchronize data access manually while using multiple single threaded servers?

[Bhupinder Dhillon]

That's correct.

[E]

Is this an Oracle issue or a JDBC one?

[Michal Harezlak]

The problem will occur no matter what kind of client will you use, so I think it has little to do with JDBC.