File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connecting to a database through servl

 
Roger Fed
Ranch Hand
Posts: 82
Java Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I've developed this servlet for dealing with a database

and this is the the code for HTML file

I've made a jdbc-odbc driver for my database and name it Address and use this driver to be able to deal with the database
but when i run this web application it give me a syntax error as follow:
Error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
why???

 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64180
83
IntelliJ IDE Java jQuery Mac Mac OS X
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moved to the JDBC forum. Nothing to do with Servlets.
 
Paul Clapham
Sheriff
Pie
Posts: 20171
25
MySQL Database
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My guess is that "E-mail" isn't a valid column name.
 
Raghu Chary
Greenhorn
Posts: 9
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
can you give the table structure
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic