import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Test
{
	public static void main(String[] x) throws SQLException
	{
		try(Connection connection = DriverManager.getConnection("jdbc:mariadb://localhost/schema", "user", "password");
			 Statement st = connection.createStatement())
		{
			final DatabaseMetaData meta = connection.getMetaData();
			System.out.println(meta.getDatabaseProductName());
			System.out.println(meta.getDatabaseProductVersion());
			System.out.println(meta.getDriverName());
			System.out.println(meta.getDriverVersion());

			st.execute("DROP TABLE IF EXISTS tab");
			st.execute("CREATE TABLE tab (col bigint)");

			st.execute("INSERT INTO tab VALUES (" + Long.MAX_VALUE + ")");
			fetch(st);

			st.execute("INSERT INTO tab VALUES (1)");
			fetch(st); //
		}
	}

	static void fetch(Statement st) throws SQLException
	{
		try(ResultSet rs = st.executeQuery("SELECT SUM(col) FROM tab"))
		{
			rs.next();
			System.out.println("SUM = " + (rs.getLong(1)));
		}
	}
}