D-Net

package eu.dnetlib.enabling.database.utils;

import javax.sql.DataSource;

import org.springframework.beans.factory.annotation.Required;

import org.springframework.jdbc.core.JdbcTemplate;

import eu.dnetlib.enabling.database.DataSourceFactory;

public class JdbcTemplateFactory {

	private int fetchSize = 100;

	private DataSourceFactory dataSourceFactory;

	public JdbcTemplate createJdbcTemplate(String db) {

		final JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSourceFactory.createDataSource(db));

		jdbcTemplate.setFetchSize(getFetchSize());

		return jdbcTemplate;

	}

	public JdbcTemplate createJdbcTemplate(DataSource dataSource) {

		final JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

		jdbcTemplate.setFetchSize(getFetchSize());

		return jdbcTemplate;

	}

	@Required

	public void setDataSourceFactory(DataSourceFactory dataSourceFactory) {

		this.dataSourceFactory = dataSourceFactory;

	}

	public int getFetchSize() {

		return fetchSize;

	}

	public void setFetchSize(final int fetchSize) {

		this.fetchSize = fetchSize;

	}

}