permaculture playing cards
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 REST with Spring (video course) this week in the Spring 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: 63548

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!