Tuesday, March 27, 2007

Column name in postgre SQL


In postgre SQL if we give column name like userId,it will look for userid and we will get error:
ERROR: column "userid" does not exist

To avoid this error ,give column name in lower cases

Thursday, March 8, 2007

progress so far

We have set up the filter.
We have connected to a postgres datase and logged the
relevant details into a table.
We have started work on the report generating part of
the tool.

Monday, March 5, 2007

Apache Tomcat

Apache Tomcat is the servlet container that is used in the official Reference Implementation for the java servlet and JSP technologies.We are using tomcat 5.5

Filter mapping


Tomcat Filter


A filter dynamically intercepts requests and responses to transform or use the information contained in the requests or responses.

Logging data into database

We are using a tomcat filter to capture requests made to the
site .Then we log this data into a database table.