atement stmt;
if (conn == null || conn.isClosed())
{
String name = "java:comp/env/jdbc/db";
Context context = new InitialContext();
DataSource data = (DataSource) context.lookup(name);
conn = data.getConnection();
stmt = conn.prepareStatement(sql);
}