<%@ page import="java.io.StringWriter" %> <%@ page import="java.io.PrintWriter" %> <%@ page import="java.sql.*" %> Hello Cloudscape!

Hello Cloudscape!

This is the output of a JSP page that is extended from Tomcat's sample Hello, World web application. It displays several useful values from the request we are currently processing and then offers a form that can be used to test a JDBC driver. It can be used for installation verification testing and to issue modest SQL commands as needed.
Context Path: <%= request.getContextPath() %>
Path Information: <%= request.getPathInfo() %>
Query String: <%= request.getQueryString() %>
Request Method: <%= request.getMethod() %>
Servlet Path: <%= request.getServletPath() %>
<% String varJdbcUrl = request.getParameter("jdbcurl"); if (varJdbcUrl == null) { varJdbcUrl = ""; } varJdbcUrl = java.net.URLDecoder.decode(varJdbcUrl).trim(); String varSql = request.getParameter("sql"); if (varSql == null) { varSql = ""; } varSql = java.net.URLDecoder.decode(varSql).trim(); %>
JDBC URL:
SQL:

<% if (varJdbcUrl.length() != 0) { try { %>

 <%=varJdbcUrl%>
<% Class.forName("org.apache.derby.jdbc.EmbeddedDriver"); Connection varJdbcConnection = DriverManager.getConnection(varJdbcUrl); Statement varJdbcStatement = null; try { varJdbcStatement = varJdbcConnection.createStatement(); if (varSql.length() != 0) { %> 
 <%= varSql %>
<% if (varJdbcStatement.execute(varSql)) { java.sql.ResultSet varJdbcResultSet = varJdbcStatement.getResultSet(); try { java.sql.ResultSetMetaData varJdbcMetaData = varJdbcResultSet.getMetaData(); int varColumnCount = varJdbcMetaData.getColumnCount(); %> <% for (int i = 1; i <= varColumnCount; i++) { %> <% } %> <% int varReturnedRows=0; while (varJdbcResultSet.next()) { varReturnedRows++; %> <% for (int i = 1; i <= varColumnCount; i++) { %> <% } %> <% } %>
<%= varJdbcMetaData.getColumnLabel(i) %>
<%= varJdbcResultSet.getString(i) %>
<% if (varReturnedRows == 1) { %> 1 row <% } else { %> <%=varReturnedRows %> rows <% } %> returned. <% } finally { varJdbcResultSet.close(); } } else { %> <% int varProcessedRows = varJdbcStatement.getUpdateCount(); if (varProcessedRows == 1) { %> 1 row <% } else { %> <%=varProcessedRows %> rows <% } %> processed. <% } } } catch (Exception varException) { StringWriter varStackBuffer = new StringWriter(); PrintWriter varPrint = new PrintWriter(varStackBuffer); varException.printStackTrace(varPrint); %>

An exception was caught executing a SQL statement. 

 <%=varStackBuffer %>
<% } finally { if (varJdbcStatement != null) { try { varJdbcStatement.close(); } catch (Throwable e) {} } try { varJdbcConnection.close(); } catch (Throwable e) {} } } catch (Exception varException) { StringWriter varStackBuffer = new StringWriter(); PrintWriter varPrint = new PrintWriter(varStackBuffer); varException.printStackTrace(varPrint); %>

An Exception was caught while connecting to the database. 

 <%=varStackBuffer %>
<% } } %>