package dk.daoas.adressevedligehold.db;

import java.sql.Connection;
import java.sql.SQLException;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

/*
Husk at tilføje denne til {TOMCAT}/conf/context.xml og tilrette password.

    <Resource auth="Container" 
    	driverClassName="com.mysql.jdbc.Driver" 
    	maxActive="10" 
    	maxIdle="5" 
    	maxWait="10000" 
    	name="jdbc/fulddaekning" 
    	password="" 
    	type="javax.sql.DataSource" 
    	url="jdbc:mysql://10.30.2.51:3306/fulddaekning?rewriteBatchedStatements=true" username="import"
    	
        testOnBorrow="true"
        validationQuery="SELECT 1"
    	
    	/>
    	
 */

public class DBConnection {
	public static Connection getConnection() throws SQLException{
		try {
						
			Context initContext = new InitialContext();
			Context envContext  = (Context)initContext.lookup("java:/comp/env");
			
			DataSource ds = (DataSource) envContext.lookup("jdbc/fulddaekning"); 
			return ds.getConnection();
		} catch (NamingException e) {
			throw new SQLException("invalid data source: " +e.getMessage(), e);
		}
	}
}