Sausage with HSQLDB over Tomcat

context.xml

<?xml version='1.0' encoding='utf-8'?>

<Context path="/sausage">

	<Resource name="jdbc/SausageDB"
           auth="Container"
			type="javax.sql.DataSource"
			username="sa"
			password=""
			driverClassName="org.hsqldb.jdbcDriver"
			url="jdbc:hsqldb:file://d:\tmp\sausage\sausage"
			maxActive="8"
			maxIdle="4"/>
</Context>

SausageServlet.java

public class SausageServlet extends HttpServlet {

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

        try {
            
            Context initCtx = new InitialContext();
            Context envCtx = (Context) initCtx.lookup("java:comp/env");
            DataSource ds = (DataSource) envCtx.lookup("jdbc/SausageDB");

            System.out.println("Open connecetion");
            Connection conn = ds.getConnection();
            
            Statement stat = conn.createStatement();
            String selectQuery = "SELECT * FROM Sausage";
            
            
            System.out.println("Select");
            ResultSet result = stat.executeQuery(selectQuery);
            
            System.out.println(result);

            conn.close();
            
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">

  <display-name>SausageServlet</display-name>

  <welcome-file-list>
    <welcome-file>index.html</welcome-file>
    <welcome-file>index.htm</welcome-file>
    <welcome-file>index.jsp</welcome-file>
    <welcome-file>default.html</welcome-file>
    <welcome-file>default.htm</welcome-file>
    <welcome-file>default.jsp</welcome-file>
  </welcome-file-list>
  
  
  <servlet> 
  	<servlet-name>SausageServlet</servlet-name>
  	<servlet-class>com.mst.sausage.SausageServlet</servlet-class>
  </servlet>
  
  <servlet-mapping>
  	<servlet-name>SausageServlet</servlet-name>
  	<url-pattern>/*</url-pattern>
  </servlet-mapping>
  
  
  <resource-ref>
	  <description>
	  	Sausage Database
	  </description>
	  <res-ref-name>
	    jdbc/SausageDB
	  </res-ref-name>
	  <res-type>
	    javax.sql.DataSource
	  </res-type>
	  <res-auth>
	    Container
	  </res-auth>
  </resource-ref>
	
</web-app>