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


pinakin patel

Joined: Jan 15, 2004
Posts: 5
hi everybody i have a jsp page in that i have some fields to fill and i have buttons such as add,save,edit,delete,cancel and search. when i click on add button my focus shifts on my first field on my jsppage then i enter something in the respective fields and after that i click on the save button on click of the save button my servlet is called so that the respective entries are stored in the database but instead of that i ma getting an error the error is
SQL Exception:
syntax error or accessviolation
you have an error in your sql syntax near ')' at line1
reply me as soon as possible its urgent
Frank Carver

Joined: Jan 07, 1999
Posts: 6920
Please don;t post the same message in more than one place. This thread is now closed.

Read about me at ~ Raspberry Alpha Omega ~ Frank's Punchbarrel Blog
I agree. Here's the link:
subject: sqlerror(urgent)
It's not a secret anymore!