package cz.manix;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;

import org.mariadb.jdbc.MariaDbPoolDataSource;

public class TcpRstMain2
{

	public static void main(String[] args) throws SQLException, InterruptedException
	{

		MariaDbPoolDataSource ds = new MariaDbPoolDataSource("jdbc:mariadb://10.0.206.31:3306/keycloak"); // "10.0.206.31",
		ds.setUser("keycloak");
		ds.setPassword("keycloak");


		while (true)
		{
			System.out.println(new Date() + ": Getting conn.");
			Connection conn = ds.getConnection();


			Statement stm = conn.createStatement();
			ResultSet rs = stm.executeQuery("select date('2013-07-18 12:21:32')");

			while (rs.next())
			{
				Date date = rs.getDate(1);
				System.out.println(date);
			}
			rs.close();

			System.out.println(new Date() + ": Closing conn.");
			conn.close();

			Thread.sleep(65 * 1000);
			if (false)
				break;

		}

		ds.close();

	}

}