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	torben	2838	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	torben	3023	url="jdbc:mysql://10.30.2.51:3306/fulddaekning?rewriteBatchedStatements=true" username="import"
23	torben	2838
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			}