File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Servlets and the fly likes sql error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Reply locked New topic

sql error

pinakin patel

Joined: Jan 15, 2004
Posts: 5
hi everybody i have a jsppage(servlet) when i open that i can view that page
in that i have got buttons such as add, save, edit,delete,cancel and search
when i click on my add button my focus shifs on my first field of my jsppage
then i enter persons name,address and soon when i click on my save button the servlet is called which inturn will save my entries in the database but when clicking on the save button i get an error and i am writing down the exact error
Varun Khanna
Ranch Hand

Joined: May 30, 2002
Posts: 1400
Avoid multiple posting for same error.
Originally posted by pinakin patel:
the exact error is
SQL Exception:
syntax error or accessvioation
You have an error in your SQL syntax near ')' at line1
reply me as soon as possible its urgent

Probably there is something wrong with your generated SQL query, syntax error maybe.
Try to debug it and run through Db client.

- Varun
Mark Spritzler

Joined: Feb 05, 2001
Posts: 17276

I am going to close this thread also because this is an SQL question and not a Servlets question.
You should take the SQL that the code is creating and try to run it in the database directly and have that tell you where the code is wrong.

Perfect World Programming, LLC - iOS Apps
How to Ask Questions the Smart Way FAQ
I agree. Here's the link:
subject: sql error
It's not a secret anymore!