1 /**
2 *
3 */
4 package org.apache.geronimo.samples.inventory.util;
5
6 import java.sql.Connection;
7 import java.sql.SQLException;
8
9 import javax.naming.Context;
10 import javax.naming.InitialContext;
11 import javax.naming.NamingException;
12 import javax.sql.DataSource;
13
14
15 public class DBManager {
16
17 public static Connection getConnection(){
18 Connection con = null;
19
20 try {
21 Context context = new InitialContext();
22 DataSource ds = (DataSource)context.lookup("java:comp/env/jdbc/InventoryDS");
23 con = ds.getConnection();
24 } catch (NamingException e) {
25 e.printStackTrace();
26 } catch (SQLException e) {
27 e.printStackTrace();
28 }
29 return con;
30 }
31
32 }