001 /** 002 * 003 */ 004 package org.apache.geronimo.samples.inventory.util; 005 006 import java.sql.Connection; 007 import java.sql.SQLException; 008 009 import javax.naming.Context; 010 import javax.naming.InitialContext; 011 import javax.naming.NamingException; 012 import javax.sql.DataSource; 013 014 015 public class DBManager { 016 017 public static Connection getConnection(){ 018 Connection con = null; 019 020 try { 021 Context context = new InitialContext(); 022 DataSource ds = (DataSource)context.lookup("java:comp/env/jdbc/InventoryDS"); 023 con = ds.getConnection(); 024 } catch (NamingException e) { 025 e.printStackTrace(); 026 } catch (SQLException e) { 027 e.printStackTrace(); 028 } 029 return con; 030 } 031 032 }