Untitled

Total Products: 102

Stacktrace:] with root cause
 java.lang.NullPointerException
    at com.study.crud.dao.jdbc.impl.ProductDao.getProducts(ProductDao.java:31)
    at org.apache.jsp.jsp.home_jsp._jspService(home_jsp.java:135)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

<?xml version="1.0" encoding="UTF-8"?>
<Context path="/product-manager-mvc1-webapp">
    <!-- PostgreSQL Datasource -->
    <Resource auth="Container" driverClassName="org.postgresql.Driver" factory="org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory" maxActive="50" maxIdle="10" maxWait="-1" name="jdbc/product-db-v1" password="def" type="javax.sql.DataSource" url="jdbc:postgresql://localhost:5432/product-db-v1" username="abc"/>
</Context>

public class ProductDao {

    @Resource(name = "jdbc/product-db-v1")
    private DataSource dataSource;

    public ProductDao() {
    }

    public List<Product> getProducts() throws SQLException {
        List<Product> products = QueryExecutor.getAllProducts(dataSource.getConnection());
        return products;
    }

}

<%
    ProductDao productDao = new ProductDao();
    List<Product> products = productDao.getProducts();
    LOG.debug("products = " + products);
    int productCnt = 0;
    if (products != null) {
        productCnt = products.size();
    }
%>

<body>
    <h1>Resource Injection Demo</h1>
    <h3>Product Count: <%= productCnt%></h3>
</body>