aswi2020vldc-gitlab/src/main/java/vldc/aswi/configuration/DbConfig.java @ ba8b306a

package vldc.aswi.configuration;

import javax.sql.DataSource;

import com.sun.istack.NotNull;
import oracle.jdbc.pool.OracleDataSource;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.transaction.annotation.EnableTransactionManagement;

import java.sql.SQLException;

/**
 * Connection configuration for database.
 */
@Configuration
@EnableTransactionManagement
@ConfigurationProperties(prefix = "oracle")
public class DbConfig {

	/** Username of logging user. */
	@NotNull
	private String username;

	/** Password of logging user. */
	@NotNull
	private String password;

	/** TNS url for connection into database. */
	@NotNull
	private String url;

	/**
	 * Set new username.
	 * @param username - User's name.
	 */
	public void setUsername(String username) {
		this.username = username;
	}

	/**
	 * Set new password.
	 * @param password - User's password.
	 */
	public void setPassword(String password) {
		this.password = password;
	}

	/**
	 * Set new url.
	 * @param url - TNS url for connection into database.
	 */
	public void setUrl(String url) {
		this.url = url;
	}

	/**
	 * Create new datasource.
	 * @return new Datasource of currently logged database.
	 * @throws SQLException
	 */
	@Bean
	DataSource dataSource() throws SQLException {
		OracleDataSource dataSource = new OracleDataSource();
		dataSource.setUser(username);
		dataSource.setPassword(password);
		dataSource.setURL(url);
		dataSource.setImplicitCachingEnabled(true);
		dataSource.setFastConnectionFailoverEnabled(true);
		return dataSource;
	}

}