problem with jdbc url and query in jsp code

hello everybody


i tried the following jsp code to query cloudscape db :
__________________________________________________-
<%@ page import="java.io.StringWriter" %>
<%@ page import="java.io.PrintWriter" %>
<%@ page import="java.sql.*" %>
<html>
<body>
<b><h1>Search Page</h1></b><br><br>

<!-- here handle the request parameters and give control to apt func.
-->
<%

String varpname=request.getParameter("pname");
String vardepname=request.getParameter("depname");
String vardocname=request.getParameter("docname");

String jdbcurl="jdbc:derby:C:\Program Files\IBM
\Cloudscape_10.0\frameworks\NetworkServer\bin\projdb";
jdbcurl= java.net.URLDecoder.decode(jdbcurl).trim();

String query="select pname,dname,statusfld from status,ptb,dtb where
status.pid=ptb.pid and status.did=dtb.did order by pname";
query= java.net.URLDecoder.decode(query).trim();

%>


<!-- user form for search -->
<form name="searchForm" action="search.jsp">
<table>
<tr>
<td> Party Name:</td>
<td> <input type="text" size="30" name="pname">

</td>
</tr>
<tr>
<td> Department Name:</td>
<td> <input type="text" size="30" name="depname">

</td>
</tr>
<tr>
<td> Document Name:</td>
<td> <input type="text" size="30" name="docname">

</td>
</tr>
<tr> <td align=center> <input value="Submit form" type="Submit"> </td>
</tr>
</table>
</form>

<%
try{
Class.forName("org.apache.derby.jdbc.EmbeddedDriver");


Connection conn=DriverManager.getConnection(jdbcurl);

Statement statm=conn.createStatement();




java.sql.ResultSet rs=stat.executeQuery(query);
try{
java.sql.ResultSetMetaData rsmd=rs.getMetaData();
int colcount=rsmd.getColumnCount();
%>
<table>
<tr>

<% for(int i=1;i<=colcount;i++) {
%>

<th class="tab"><%= rsmd.getColumnLabel(i) %> </th>
<% } %>
</tr>
<%
int varReturnedRows=0;
while (varJdbcResultSet.next())
{
varReturnedRows++;
%>

<tr>
<%
for (int i = 1; i <= varColumnCount; i++) {
%>
<td><%= varJdbcResultSet.getString(i) %> </td>
<%
}
%>
</tr>

<% } %>
</table>
<% }
finally {
rs.close();
}
%>
</body>
</html>
_______________________________________________

and tomcat returned this:
________________________________________________
message

description The server encountered an internal error () that prevented
it from fulfilling this request.

exception

org.apache.jasper.JasperException: Unable to compile class for JSP:

An error occurred at line: 15 in the jsp file: /CloudscapeDemo/bb.jsp
Invalid escape sequence (valid ones are \b \t \n \f \r \" \' \
\ )
12: String vardepname=request.getParameter("depname");
13: String vardocname=request.getParameter("docname");
14:
15: String jdbcurl="jdbc:derby:C:\Program Files\IBM
\Cloudscape_10.0\frameworks\NetworkServer\bin\projdb";
16: jdbcurl= java.net.URLDecoder.decode(jdbcurl).trim();
17:
18: String query="select pname,dname,statusfld from status,ptb,dtb
where status.pid=ptb.pid and status.did=dtb.did order by pname";


An error occurred at line: 15 in the jsp file: /CloudscapeDemo/bb.jsp
Invalid escape sequence (valid ones are \b \t \n \f \r \" \' \
\ )
12: String vardepname=request.getParameter("depname");
13: String vardocname=request.getParameter("docname");
14:
15: String jdbcurl="jdbc:derby:C:\Program Files\IBM
\Cloudscape_10.0\frameworks\NetworkServer\bin\projdb";
16: jdbcurl= java.net.URLDecoder.decode(jdbcurl).trim();
17:
18: String query="select pname,dname,statusfld from status,ptb,dtb
where status.pid=ptb.pid and status.did=dtb.did order by pname";


An error occurred at line: 202 in the generated java file
Syntax error, insert "}" to complete ClassBody

Stacktrace:

org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:
92)

org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:
330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:
423)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:308)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:286)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:273)

org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:
566)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:
317)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:
320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
____________________________________________________________________

somebody please tell what's wrong with it.

thanks

.