staypufd

Mac - Run HSQLDB 

NOTE:  Assumes your hsqldb is installed at the top level of your home directory.


java -cp ~/hsqldb-2.3.2/hsqldb/lib/hsqldb.jar org.hsqldb.server.Server

staypufd

Windows - Run HSQLDB

NOTE:  Assumes your hsqldb is installed at c:\ on your PC

 java -cp c:\hsqldb-2.3.2\hsqldb\lib\hsqldb.jar org.hsqldb.server.Server

staypufd

		<table class="table table-striped">
			<c:forEach items="${theQuotes }" var="aQuote">
				<tr>
					<td>
						<blockquote class="blockquote">
							<p>${aQuote.quote }</p>
							<footer>
								<c:out value="${aQuote.author }"/>
							</footer>
						</blockquote>

staypufd

	<sql:query var="results" 		
				sql="select quotation, author from quote"
				dataSource="jdbc/quoteDB">
	</sql:query>
		
	<c:forEach items="${results.rows }" var="row">
				
				<p>${row.quotation } -- ${row.author }</p> 
	
	</c:forEach>	

staypufd

	<Resource name="jdbc/quoteDB" auth="Container" type="javax.sql.DataSource"
               maxActive="50" maxIdle="30" maxWait="10000"
               username="SA" password="" 
               driverClassName="org.hsqldb.jdbc.JDBCDriver"
               url="jdbc:hsqldb:hsql://localhost:9001/"/>

staypufd

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/functions" prefix="fn" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>