what happens on connection.setAutoCommit = false

java jdbc connection autocommit
eatSleepCode picture eatSleepCode · Sep 23, 2015 · Viewed 38.6k times · Source

what happens if I do connection.setAutoCommit(false); does it creates a new transaction at database side?

Answer

Mick Mnemonic picture Mick Mnemonic · Sep 23, 2015

According to the documentation, connection.setAutoCommit(false) will allow you to group multiple subsequent Statements under the same transaction. This transaction will be committed when connection.commit() is invoked, as opposed to after each execute() call on individual Statements (which happens if autocommit is enabled).

Changing the auto-commit mode through connection.setAutoCommit() will implicitly commit the active transaction and create a new one. From the Javadocs:

NOTE: If this method is called during a transaction and the auto-commit mode is changed, the transaction is committed. If setAutoCommit is called and the auto-commit mode is not changed, the call is a no-op.

Related questions

java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

The following code: Class.forName("com.mysql.jdbc.Driver"); Connection m_connection = DriverManager.getConnection("jdbc:mysql://localhost","root","root"); Throws this exception on getConnection(): java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) at com.mysql.jdbc.…

Read More
How to connect Sybase database using Java code in NetBeans?

I want to connect remote Sybase from my Java code written in NetBeans. So far I have prepared a code as below: public static void connect() { String host = "192.168.150.11"; String url = "jdbc:sybase:Tds:"+host+":4100"; String username = "sa"; String password =""; SybDriver …

Read More
Is it safe to use a static java.sql.Connection instance in a multithreaded system?

I'm running a web application on Tomcat. I have a class that handles all DB queries. This class contains the Connection object and methods that returns query results. This is the connection object: private static Connection conn = null; It has …

Read More