This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Connecting to a database through servl Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Connecting to a database through servl" Watch "Connecting to a database through servl" New topic
Author

Connecting to a database through servl

Roger Fed
Ranch Hand

Joined: Oct 17, 2010
Posts: 82

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???


I Hear I Forget, I See I Remember, I Do I Understand.
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 63350
    
  70

Moved to the JDBC forum. Nothing to do with Servlets.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Paul Clapham
Sheriff

Joined: Oct 14, 2005
Posts: 19751
    
  10

My guess is that "E-mail" isn't a valid column name.
Raghu Chary
Greenhorn

Joined: May 12, 2011
Posts: 9
can you give the table structure
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connecting to a database through servl
 
It's not a secret anymore!