adressevedligehold/db/DBConnection.java

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);
                }
        }
}
1	package dk.daoas.adressevedligehold.db;
2
3	import java.sql.Connection;
4	import java.sql.SQLException;
5
6	import javax.naming.Context;
7	import javax.naming.InitialContext;
8	import javax.naming.NamingException;
9	import javax.sql.DataSource;
10
11	/*
12	Husk at tilføje denne til {TOMCAT}/conf/context.xml og tilrette password.
13
14	<Resource auth="Container"
15	driverClassName="com.mysql.jdbc.Driver"
16	maxActive="10"
17	maxIdle="5"
18	maxWait="10000"
19	name="jdbc/fulddaekning"
20	password=""
21	type="javax.sql.DataSource"
22	url="jdbc:mysql://10.30.2.51:3306/fulddaekning?rewriteBatchedStatements=true" username="import"
23
24	testOnBorrow="true"
25	validationQuery="SELECT 1"
26
27	/>
28
29	*/
30
31	public class DBConnection {
32	public static Connection getConnection() throws SQLException{
33	try {
34
35	Context initContext = new InitialContext();
36	Context envContext = (Context)initContext.lookup("java:/comp/env");
37
38	DataSource ds = (DataSource) envContext.lookup("jdbc/fulddaekning");
39	return ds.getConnection();
40	} catch (NamingException e) {
41	throw new SQLException("invalid data source: " +e.getMessage(), e);
42	}
43	}
44	}