With this example we are going to demonstrate how to check if a database supports transactions. In short, to check if a database supports transactions you should:
- Load the JDBC driver, using the
forName(String className)API method of the Class. In this example we use the Oracle JDBC driver. - Create a Connection to the database. Invoke the
getConnection(String url, String user, String password)API method of the DriverManager to create the connection. - Create the DatabaseMetaData, using the
getMetaData()API method of the Connection. It includes information about the database’s tables, its supported SQL grammar, its stored procedures and the connection capabilities. - Check whether this database supports transactions, using the
supportsTransactions()API method of the DatabaseMetaData.
Let’s take a look at the code snippet that follows:
package com.javacodegeeks.snippets.core;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.SQLException;
public class TransactionsSupport {
public static void main(String[] args) {
Connection connection = null;
try {
// Load the Oracle JDBC driver
String driverName = "oracle.jdbc.driver.OracleDriver";
Class.forName(driverName);
// Create a connection to the database
String serverName = "localhost";
String serverPort = "1521";
String sid = "mySchema";
String url = "jdbc:oracle:thin:@" + serverName + ":" + serverPort + ":" + sid;
String username = "username";
String password = "password";
connection = DriverManager.getConnection(url, username, password);
System.out.println("Successfully Connected to the database!");
} catch (ClassNotFoundException e) {
System.out.println("Could not find the database driver " + e.getMessage());
} catch (SQLException e) {
System.out.println("Could not connect to the database " + e.getMessage());
}
try {
DatabaseMetaData metaData = connection.getMetaData();
if (metaData.supportsTransactions()) {
System.out.println("Transactions are supported!");
} else {
System.out.println("Transactions are not supported!");
}
} catch (SQLException e) {
System.out.println("Could not get database metadata " + e.getMessage());
}
}
}
Output:
Successfully Connected to the database!
Transactions are supported!
This was an example of how to check if a database supports transactions in Java.
