Win a copy of Learn Spring Security (video course) this week in the Spring forum!
    Bookmark Topic Watch Topic
  • New Topic

sql error

 
pinakin patel
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Report post to moderator
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
Posts: 1400
  • Mark post as helpful
  • send pies
  • Report post to moderator
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.
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Report post to moderator
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
 
    Bookmark Topic Watch Topic
  • New Topic