<dependency>
<groupId>javax.transaction</groupId>
<artifactId>javax.transaction-api</artifactId>
<version>1.3</version>
</dependency>
DataSource dataSource = new HikariDataSource();
dataSource.setJdbcUrl("jdbc:mysql://localhost:3306/mydatabase");
dataSource.setUsername("myuser");
dataSource.setPassword("mypassword");
import javax.transaction.*;
import javax.naming.*;
UserTransaction userTransaction = (UserTransaction) new InitialContext().lookup("java:comp/UserTransaction");
userTransaction.begin();
Connection connection = dataSource.getConnection();
Statement statement = connection.createStatement();
statement.executeUpdate("INSERT INTO employees (name, age) VALUES ('John', 25)");
statement.close();
connection.close();
userTransaction.commit();
userTransaction.rollback();
