package si.uni.mb.aiv;

import java.sql.Connection;
import org.apache.tomcat.jdbc.pool.DataSource;
import org.apache.tomcat.jdbc.pool.PoolProperties;

public class DBExtensionAdapter extends DBExtension {

    private static DataSource datasource = null;

    public DBExtensionAdapter() {
    }

    public static void initDatasource() {

        PoolProperties p = new PoolProperties();

        p.setUrl("jdbc:mysql://localhost:3306/vzorci");
        p.setDriverClassName("com.mysql.jdbc.Driver");
        p.setUsername("root");
        p.setPassword("aiv2012");

        p.setJmxEnabled(true);
        p.setTestWhileIdle(false);
        p.setTestOnBorrow(true);
        p.setValidationQuery("SELECT 1");
        p.setTestOnReturn(false);
        p.setValidationInterval(30000);
        p.setTimeBetweenEvictionRunsMillis(30000);

        p.setMaxActive(75);
        p.setMaxIdle(75);
        p.setInitialSize(10);
        p.setMaxWait(10000);
        p.setRemoveAbandonedTimeout(60);
        p.setMinEvictableIdleTimeMillis(30000);
        p.setMinIdle(10);

        p.setLogAbandoned(true);
        p.setRemoveAbandoned(true);

        p.setJdbcInterceptors("org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;"
                + "org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer");

        datasource = new DataSource();
        datasource.setPoolProperties(p);

    }

    public static void zapriDatasource() {
        datasource.close();
    }

    @Override
    public Connection VrniPovezavo() {
        try {
            if (datasource == null) {
                DBExtensionAdapter.initDatasource();
            }
            return datasource.getConnection();
        } catch (Exception e) {
            return null;
        }
    }

}