package com.grundfos.gmatou.dataupload;


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

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

public class DBConnection {

	
	public static  Connection getDbConnection() throws NamingException,SQLException {
		//when using tomcat we need to prefix with java:comp/env/
		DataSource source = (DataSource) new InitialContext().lookup("java:comp/env/jdbc/dataupload");
		Connection conn = source.getConnection();		
		
		return conn;
	}
	
}