package dao;

import java.sql.Connection;
import java.sql.SQLException;
import org.h2.jdbcx.JdbcConnectionPool;

/**
 *
 * @author mark
 */
public class JdbcConnection {

//   private static final String url = "jdbc:h2:tcp://localhost/~/work/202/2020/marking/project/m1/db/m1;IFEXISTS=TRUE";
//   private static final String url = "jdbc:h2:./db/testing;IFEXISTS=TRUE";
    private static final String url = MarkingProperties.jdbcUri();
    private static final String username = "sa";
    private static final String password = "";

    private static final JdbcConnectionPool pool = JdbcConnectionPool.create(url, username, password);

    public static Connection getConnection() {
        try {
            return pool.getConnection();
        } catch (SQLException ex) {
            throw new RuntimeException(ex);
        }
    }
}