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/221/2014/marking/test1/practical/db/info221_test1_practical;IFEXISTS=TRUE";
//   private static final String url = "jdbc:h2:db/info221_test1;IFEXISTS=TRUE";
	private static final String url = MarkingProperties.getJdbcUrl();
	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);
      }
   }
}