SQL on Tomcat Test
<%
Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
Context ctx = new InitialContext();
if(ctx == null)
throw new RuntimeException("Could not create an InitialContext");
DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/TestDB");
if(ds == null)
throw new RuntimeException("Could not create a DataSource");
out.write("
found ds: " + ds + "
");
Connection conn = ds.getConnection();
if(conn == null)
throw new RuntimeException("Could not get database connection");
out.write("got here");
java.sql.Statement stmt = conn.createStatement();
try {
stmt.execute("drop table CATEGORIES");
stmt.close();
} catch(Exception ignore) {ignore.printStackTrace(); stmt.close();}
stmt = conn.createStatement();
boolean result = stmt.execute(
"CREATE TABLE Categories (CategoryID int GENERATED ALWAYS AS IDENTITY, CategoryName varchar (15) NOT NULL, Description CLOB (2K), CONSTRAINT PK_Categories PRIMARY KEY(CategoryID))");
out.write("result: " + result);
stmt.close();
stmt = conn.createStatement();
stmt.execute("insert into categories (CategoryName,Description) VALUES('Beverages','Soft drinks, coffees, teas, beers, and ales')");
stmt.close();
stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from categories");
pageContext.setAttribute("rs", rs);
while(rs.next()) {
out.write("name: " + rs.getObject("categoryname") + "
");
out.write("name: " + rs.getObject("description") + "
");
}
rs.close();
stmt.close();
conn.close();
%>