<%!
DBHandlerdbHandle;
ResultSetrs;
StringsearchString, searchType;
StringreportType, sqlString;
VectorindexWords, srchWords;
VectorfileNames; //field to store the file names.
HashtablestoreReports, storeDates;
Connectionconn;
PreparedStatementpstmt;
Stringroot, queryString;
booleanYesNo;
intsize,temp1=0;
intj,sri,my1;
int temp2=10;
intindexno = 0;
String getstring1,getstring2,getstring4;
java.util.Date getdate1;
String color,textcolor;
int mydisplay1;
//clossing the decleration
%>
this is waht i have between my <%! .. %> tags i dont think any where i have created any connection or statement or resultset only i have declared them here kindly let me know what could b the remedy for the second option u have given.