"Spider Peter", sorry but your display name is not valid according to our name rules.
We require display names to be two words: your first name, a space, then your last name. Fictitious names are not allowed.
Just to be clear, you cannot have the current display name and then sign it 'John'. We now require you to set the first name in your display name to 'John' and second to be your last name. 'Spider' will not be accepted.
Please edit your profile and correct your profile, since accounts with invalid display names get deleted, often without warning
Joined: Aug 15, 2004
Originally posted by Spider Peter: May I know how to shorter the transaction? Reconstruct the logic, or ? Please enlighten me in detail. E.g: Simple code to illustrate it.
make connection.setAutoCommit(true), Or if don't want to do with auto-commit then do commit frequently.
Look at how locking is implemented on your database: row level vs. page level vs. table level. Monitor (at the database level) what threads are making requests for locks against what resources. Are locks escalating as a result? Tune the database to reduce contention. Also, create resource references for your datasources............modify the isolation level according to the nature of the work being performed to get the best performance (example: for select statements against static data, set your isolation level to be read uncommitted).
subject: How to eliminate deadlock or timeout in a jdbc application?