Getting and Error at this point in the below program
pstmt = cn.prepareStatement(sql);
pstmt.setString(1,serverName );
pstmt.setString(2,remoteDir );
pstmt.setString(3,remoteFile);
pstmt.setString(4,status);
pstmt.setString(5,requestDate);

//ERRORiN THIS LINE Syntax error on token ".", ; expected
pstmt.executeUpdate();//


cn.commit();
pstmt.close();
%>





<%@ page import="com.verizon.vzedge.dbconn.WeblogicConnecti onPool" %>
<%@ page import="com.verizon.vzedge.common.GISLogger" %>
<%@ page import="java.sql.PreparedStatement" %>
<%@ page import="java.util.Date"%>
<%@ page import="java.text.*" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.ResultSet" %>
<%
response.setContentType("text/html");
response.setHeader("Cache-Control","no-cache");

GISLogger log = GISLogger.getInstance();
Connection cn = null;
ResultSet rs= null;

try
{

String serverName = request.getParameter("servername");
String remoteDir = request.getParameter("path");
String remoteFile = request.getParameter("filename");
//String status = request.getParameter("status");

//We have to replace -BKSLSH- with \ in path and use it.
remoteDir = remoteDir.replaceAll("-BKSLSH-","\\\\");

cn = WeblogicConnectionPool.getConnection();

int cnt = 0;

String sqlCount = "select count(1) from county_lotlinepath where servername=? and remote_dir =? and filename=?";
String status="SCHEDULED";
DateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.ms");
System.out.println(dateFormat);
Date date = new Date();
System.out.println(date);
System.out.println(dateFormat.format(date));
String requestDate= "dateFormat.format(date)";

PreparedStatement pstmt = cn.prepareStatement(sqlCount);
pstmt.setString(1,serverName );
pstmt.setString(2,remoteDir );
pstmt.setString(3,remoteFile);
//pstmt.setString(4,status);
rs = pstmt.executeQuery();

while(rs.next())
cnt = rs.getInt(1);

if(cnt == 0)
{
String sql = "insert into county_lotlinepath(servername, remote_dir, filename, status, requestDate) values (?,?,?,?,?)";

pstmt = cn.prepareStatement(sql);
pstmt.setString(1,serverName );
pstmt.setString(2,remoteDir );
pstmt.setString(3,remoteFile);
pstmt.setString(4,status);
pstmt.setString(5,requestDate);

pstmt.executeUpdate();
cn.commit();
pstmt.close();
%>
alert("Selected County Zip file is queued for Processing");
<%
}
else
{
%>
alert("Selected County Lotline File was already chosen for processing. Please select ANOTHER File!!!");
<%
}
}
catch(Exception e)
{
%>
alert("Enountered an issue while saving file path to database - <%=e.toString()%>");
<%
log.problem(this,"Exception at query :"+e.toString());
}
finally
{
try
{
if(cn != null)
cn.close();
}
catch(Exception e)
{ log.fatal(this,"Unable to close connection - SavePathParcelloading.jsp"); }
}
%>
$('btnFtpOpen').disabled = false;