File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes JSP error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JSP error" Watch "JSP error" New topic

JSP error

Rashmi Trivedi
Ranch Hand

Joined: Aug 13, 2001
Posts: 60
Hi all
When i try to load this page i am getting following error message.
-Generated servlet error:
-Syntax error on tokens, delete these tokens

I strated getting this error messaage as i added dCurrentDate variable in SQL statement.

dCurrentDate is java.sql.Date variable and access database is also set to date/time datatype.

can somebody help me please as to what am i doing wrong here..

thanks and regards..

Rashmi Trivedi

Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63873

Doing SQL in a JSP? Tsk tsk.

In any case, this is a JDBC issue, not a JSP issue. So this topic has been moved.

[Asking smart questions] [About Bear] [Books by Bear]
Tim LeMaster
Ranch Hand

Joined: Aug 31, 2006
Posts: 226
I see a couple of problems

dCurrentDate doesn't seem to be defined anywhere.

Whats with the # around dCurrentDate?

This is neither a JSP issue nor a JDBC issue.

Eventually you will want to start breaking down your code into reuseable pieces - keep learning!
[ December 07, 2006: Message edited by: Tim LeMaster ]
I agree. Here's the link:
subject: JSP error
It's not a secret anymore!