<%@ page import="javax.naming.InitialContext" %> <%@ page import="javax.sql.DataSource" %> <%@ page import="java.sql.Connection" %> <%@ page import="java.sql.ResultSet" %> <%@ page import="java.sql.Statement" %> <% InitialContext ctx = new InitialContext(); DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/InventoryDB"); try (Connection conn = ds.getConnection(); Statement stmt = conn.createStatement()) { stmt.execute("create table if not exists items (id int primary key, name varchar(40))"); stmt.executeUpdate("merge into items key(id) values (1, 'inventory')"); try (ResultSet rs = stmt.executeQuery("select name from items where id = 1")) { rs.next(); out.println("JNDI datasource OK: " + rs.getString(1)); } } %>