com.knowgate.http

Class HttpQueryServlet

java.lang.Object

javax.servlet.GenericServlet

javax.servlet.http.HttpServlet

com.knowgate.http.HttpQueryServlet

All Implemented Interfaces:

java.io.Serializable, javax.servlet.Servlet, javax.servlet.ServletConfig

public class HttpQueryServlet
extends javax.servlet.http.HttpServlet

Get Query By Form results

Version:

1.0

See Also:

QueryByForm, Serialized Form

Constructor Summary

Constructors

Constructor and Description
HttpQueryServlet()

Method Summary

Methods

Modifier and Type	Method and Description
void	doGet(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response) Get Query By Form results throught response output stream.
void	init() Initialize Servlet Parameters Take Database Driver, Conenction URL and User from /WEB-INF/web.xml.

Methods inherited from class javax.servlet.http.HttpServlet

service

Methods inherited from class javax.servlet.GenericServlet

destroy, getInitParameter, getInitParameterNames, getServletConfig, getServletContext, getServletInfo, getServletName, init, log, log

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

HttpQueryServlet

public HttpQueryServlet()

Method Detail

init

public void init()
          throws javax.servlet.ServletException

Initialize Servlet Parameters

Take Database Driver, Conenction URL and User from /WEB-INF/web.xml.
If any parameter is not found then look it up at hipergate.cnf Properties file using Environment singleton.

Overrides:

init in class javax.servlet.GenericServlet

Throws:

javax.servlet.ServletException

javax.servlet.UnavailableException - If jdbcDriverClassName parameter is not found and driver property at hipergate.cnf is not found or if jdbcURL parameter is not found and dburl property at hipergate.cnf is not found.

See Also:

Environment

doGet

public void doGet(javax.servlet.http.HttpServletRequest request,
         javax.servlet.http.HttpServletResponse response)
           throws java.io.IOException,
                  java.io.FileNotFoundException,
                  javax.servlet.ServletException

Get Query By Form results throught response output stream.

Overrides:

doGet in class javax.servlet.http.HttpServlet

Parameters:

queryspec - Name of XML file containing the Query Specification

columnlist - List of comma separated column names to retrieve

where - SQL WHERE clause to apply

order - by SQL ORDER BY clause to apply

showas - Output format. One of { "CSV" (comma separated), "TSV" (tabbed separated), "XLS" (Excel) }

Throws:

java.io.IOException

java.io.FileNotFoundException

javax.servlet.ServletException