<Context>
<watchedresource>WEB-INF/web.xml</watchedresource>
<resource maxidle="10" maxactive="30" maxwait="1000" url="jdbc:firebirdsql://172.20.6.200:3050/C:/DataBases/WAREHOUSE.FDB" driverclassname="org.firebirdsql.jdbc.FBDriver" password="password" username="SYSDBA" type="javax.sql.DataSource" auth="Container" name="jdbc/warehouse">
</Context>
Despues al utilizarlo en tu codigo lo mandas a llamar:
DataSource ds = null;
Connection c = null;
try {
ds = (DataSource)new InitialContext().lookup("java:/comp/env/jdbc/warehouse");
c = ds.getConnection();
java.sql.Statement stmt = c.createStatement();
ResultSet rs = stmt.executeQuery("select CARRIER,TRAILER,CUSTOMER,NOTES from booking);
if(rs.next()){
carrier =rs.getString(1);
trailer = rs.getString(2);
customer = rs.getString(3);
notes = rs.getString(4);
}
rs.close();
stmt.close();
c.close();
}catch(Exception e){ ..... }
En Glassfish la linea para llamar el Datasource seria:
ds = (DataSource)new InitialContext().lookup("jdbc/warehouse");
Configurar el DataPool en Glassfish lo logras atravez de la interfaz web que este servidor incluye.