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    }