concurrency concersn in JDBC operations?

[Steve]

If the web application only has JDBC insert operation, do u need to
worry about the concurrency? Let's assume the web application is just
using JDBC for database manipulation. I'm concerned if the transaction
management mechanism is necessary.

If the application has update operation, then we should make sure each
the update operation is locked if 2 user are trying to update the same
record at the same time?

Please advice. thanks!!

 

[=?ISO-8859-1?Q?Arne_Vajh=F8j?=]

If the web application only has JDBC insert operation, do u need to
worry about the concurrency? Let's assume the web application is just
using JDBC for database manipulation. I'm concerned if the transaction
management mechanism is necessary.

If the application has update operation, then we should make sure each
the update operation is locked if 2 user are trying to update the same
record at the same time?

The database should itself handle two programs/threads doing single
SQL statement operations.

If you have two programs/threads doing multiple SQL statement
operations, then you may need to use transactions and specify
an appropriate transaction isolation level.

Arne