Mechanic of jdbc update lock

Asked By clinton sina 140 points N/A Posted on - 12/15/2012

 

Hi guys,

I want to know what the mechanic of jdbc update lock is. When do we use it? And please give me detail instruction about how to use it.

Thanks

• Status: Open
• Question Views: 786
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Databases

Answered By Shifflett Laurel 0 points N/A #180117

Mechanic of jdbc update lock

Hellow Clinton Sina,

I have  researched about your topics.Now I am giving outlines about jdbc update lock.

When a sql connection is created ,it is generally found to be operated in auto commit mode.From this you will be able to know that a sql statement is treated as a transaction and is automatically committed right after it is executed.

There is an excellent built in function by which you can lock the commit mode In the sql language it is said to destroy the previous condition for which the auto-commit mode was working.

The following code can be implemented for the purpose.

con.setAutoCommit(false);

 

Thanking you

Shifflett Laurel

 

About Shifflett Laurel

Questions
2

Answers
154

Best Answers
78

• Vote Up 0 Vote Down

• Posted on - 01/23/2013
• Question Category: Misc Databases