hi all

i'm getting the following error while running my jsp in WEBLOGIC 7.1
version.can u plzz help me out.

Parsing of JSP File '/validate.jsp' failed:





--------------------------------------------------------------------------------
/validate.jsp(30): scriptlet close brace '}' unbalanced at line 30
which breaks scope '_base_service_scope_'
probably occurred due to an error in /validate.jsp line 30:
rs = stmt.executeQuery(query);


this is my jsp code:
try
{

DBConnection conobj=new
DBConnection("C:\bea\weblogic700\server\bin\applications\sample\ login.txt");
con=conobj.createConnection();
stmt=con.createStatement();
String query="select role from login where username like '"+usrname+"'
and "+
"password like '"+pwd+"'";
rs = stmt.executeQuery(query);
if(rs.next())
{
role=rs.getString("role");
out.print(role);

}

}
catch(SQLException sqe)
{
out.print(sqe.toString());
}




thanks in advance.