my dog learned polymorphism*
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Servlets
Reply locked New topic
Author

sql error

pinakin patel
Greenhorn

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
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17249
    
    6

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.
Thanks
Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: sql error
 
Similar Threads
How to distinguish between two different button clicks on servlet
error
error (its urgent)
sqlerror(urgent)
How to distinguish between two different button clicks on servlet